· 8 years ago · Mar 19, 2018, 09:12 PM
1DROP TABLE IF EXISTS `users`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `users` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `oauth_uid` varchar(100) NOT NULL,
7 `first_name` varchar(100) NOT NULL,
8 `last_name` varchar(100) NOT NULL,
9 `level` int(11) NOT NULL,
10 `xp` int(11) NOT NULL,
11 `xpneed` int(11) NOT NULL,
12 `picture` varchar(300) NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1;
15/*!40101 SET character_set_client = @saved_cs_client */;