help me habbo profiles table

Muff

Member
Aug 5, 2015
252
129
Code:
--
-- Tabellenstruktur für Tabelle `user_stats`
--

CREATE TABLE IF NOT EXISTS `user_stats` (
  `id` int(7) NOT NULL,
  `RoomVisits` int(7) NOT NULL DEFAULT '0',
  `OnlineTime` int(7) NOT NULL DEFAULT '0',
  `Respect` int(6) NOT NULL DEFAULT '0',
  `RespectGiven` int(6) NOT NULL DEFAULT '0',
  `GiftsGiven` int(6) NOT NULL DEFAULT '0',
  `GiftsReceived` int(6) NOT NULL DEFAULT '0',
  `DailyRespectPoints` int(1) NOT NULL DEFAULT '3',
  `DailyPetRespectPoints` int(1) NOT NULL DEFAULT '3',
  `AchievementScore` int(7) NOT NULL DEFAULT '0',
  `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
  `quest_progress` int(10) NOT NULL DEFAULT '0',
  `lev_builder` int(10) NOT NULL DEFAULT '0',
  `InRoom` int(10) NOT NULL DEFAULT '0',
  `lev_social` int(10) NOT NULL DEFAULT '0',
  `lev_identity` int(10) NOT NULL DEFAULT '0',
  `lev_explore` int(10) NOT NULL DEFAULT '0',
  `groupid` int(11) NOT NULL DEFAULT '0',
  `tickets_answered` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

Run that as a query then you should be fine i think,


~louka
 

Users who are viewing this thread

Top