· 8 years ago · May 14, 2018, 04:10 AM
1DROP TABLE IF EXISTS `accounts`;
2CREATE TABLE `accounts` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `name` int(32) NOT NULL DEFAULT '0',
5 `password` varchar(255) NOT NULL DEFAULT '',
6 `email` varchar(255) NOT NULL DEFAULT '',
7 `premend` int(10) unsigned NOT NULL DEFAULT '0',
8 `blocked` tinyint(1) NOT NULL DEFAULT '0',
9 `deleted` tinyint(1) NOT NULL DEFAULT '0',
10 `warned` tinyint(1) NOT NULL DEFAULT '0',
11 PRIMARY KEY (`id`),
12 UNIQUE KEY `name` (`name`)
13) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
14
15--
16-- Dumping data for table `accounts`
17--
18
19/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
20INSERT INTO `accounts` (`id`,`name`,`password`,`email`,`premend`,`blocked`,`deleted`,`warned`) VALUES
21 (1,760760,'killer','sjsdj@live.se',0,0,0,0),
22 (2,704660,'lol123','c.note11@hotmail.com',1287527025,0,0,0),