· 9 years ago · Dec 12, 2016, 06:39 PM
1CREATE TABLE IF NOT EXISTS `guilds` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(255) NOT NULL,
4 `ownerid` int(11) NOT NULL,
5 `creationdata` int(11) NOT NULL,
6 `motd` varchar(255) NOT NULL DEFAULT '',
7 `description` text NOT NULL,
8 `guild_logo` mediumblob,
9 `create_ip` int(11) NOT NULL DEFAULT '0',
10 `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
11 `last_execute_points` int(11) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`),
13 UNIQUE KEY `name` (`name`),
14 UNIQUE KEY `ownerid` (`ownerid`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;