· 8 years ago · May 14, 2018, 04:14 AM
1DROP TABLE IF EXISTS `groups`;
2CREATE TABLE `groups` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `name` varchar(255) NOT NULL DEFAULT '',
5 `flags` bigint(20) unsigned NOT NULL DEFAULT '0',
6 `access` int(11) NOT NULL DEFAULT '0',
7 `maxdepotitems` int(11) NOT NULL DEFAULT '0',
8 `maxviplist` int(11) NOT NULL DEFAULT '0',
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
11
12--
13-- Dumping data for table `groups`
14--
15
16/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
17INSERT INTO `groups` (`id`,`name`,`flags`,`access`,`maxdepotitems`,`maxviplist`) VALUES
18 (1,'player',0,0,2000,25),
19 (2,'a gamemaster',137438953471,2,2000,100),
20 (3,'a god',547104989176,3,4000,200);