· 8 years ago · Jun 03, 2018, 03:06 PM
1DROP TABLE IF EXISTS `user_stats`;
2CREATE TABLE `user_stats` (
3 `id` int(7) NOT NULL,
4 `RoomVisits` int(7) NOT NULL DEFAULT '0',
5 `OnlineTime` int(7) NOT NULL DEFAULT '0',
6 `Respect` int(6) NOT NULL DEFAULT '0',
7 `RespectGiven` int(6) NOT NULL DEFAULT '0',
8 `GiftsGiven` int(6) NOT NULL DEFAULT '0',
9 `GiftsReceived` int(6) NOT NULL DEFAULT '0',
10 `DailyRespectPoints` int(1) NOT NULL DEFAULT '3',
11 `DailyPetRespectPoints` int(1) NOT NULL DEFAULT '3',
12 `AchievementScore` int(7) NOT NULL DEFAULT '0',
13 `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
14 `quest_progress` int(10) NOT NULL DEFAULT '0',
15 `lev_builder` int(10) NOT NULL DEFAULT '0',
16 `lev_social` int(10) NOT NULL DEFAULT '0',
17 `lev_identity` int(10) NOT NULL DEFAULT '0',
18 `lev_explore` int(10) NOT NULL DEFAULT '0',
19 PRIMARY KEY (`id`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;