· 8 years ago · Apr 14, 2018, 07:38 AM
1CREATE TABLE IF NOT EXISTS `clans` (
2 `owner` VARCHAR(16) NOT NULL ,
3 `name` VARCHAR(16) NOT NULL DEFAULT '' ,
4 `enabled` INT(1) NOT NULL DEFAULT '0' ,
5 `enterReq` INT(2) NOT NULL DEFAULT '0' ,
6 `talkReq` INT(2) NOT NULL DEFAULT '0' ,
7 `kickReq` INT(2) NOT NULL DEFAULT '0' ,
8 `lootShareReq` INT(2) NOT NULL DEFAULT '0' ,
9 `recruits` VARCHAR(1024) NOT NULL DEFAULT '' ,
10 `corporals` VARCHAR(1024) NOT NULL DEFAULT '' ,
11 `sergeants` VARCHAR(1024) NOT NULL DEFAULT '' ,
12 `lieutenants` VARCHAR(1024) NOT NULL DEFAULT '' ,
13 `captains` VARCHAR(1024) NOT NULL DEFAULT '' ,
14 `generals` VARCHAR(1024) NOT NULL DEFAULT '' ,
15 PRIMARY KEY (`owner`) )
16ENGINE = MyISAM
17DEFAULT CHARACTER SET = latin1