· 8 years ago · May 14, 2018, 04:14 AM
1CREATE TABLE IF NOT EXISTS `groups` (
2 `id` int(10) unsigned NOT NULL auto_increment,
3 `name` varchar(255) NOT NULL COMMENT 'group name',
4 `flags` bigint(20) unsigned NOT NULL default '0',
5 `access` int(11) NOT NULL,
6 `maxdepotitems` int(11) NOT NULL,
7 `maxviplist` int(11) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
10
11--
12-- Dumping data for table `groups`
13--
14
15INSERT INTO `groups` (`id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist`) VALUES
16(1, 'player', 137438953472, 0, 1000, 100),
17(3, 'gm', 549755797503, 3, 1000, 100),
18(4, 'God', 549755789307, 3, 1000, 100),
19(5, 'cm', 493919926159, 2, 1000, 100);