ModernAAC: Creating Guild

[Amiroslo]

When someonecreats a guild

Unknown column 'guild' in 'field list'

INSERT INTO `forums` (`id`, `name`, `description`, `access`, `closed`, `guild`, `moderators`, `order`, `requireLogin`) VALUES('', 'Guildboard for ReDisBlooD','Guildboard for ReDisBlooD','0','0', 3, 'Ramboo', '9999', '1')

 

[Elexonic]

CREATE TABLE `guilds`
(
`id` INT NOT NULL AUTO_INCREMENT,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`ownerid` INT NOT NULL,
`creationdata` INT NOT NULL,
`checkdata` INT NOT NULL,
`motd` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

Test.

 

[Amiroslo]

#1050 - Table 'guilds' already exists

 

[Elexonic]

change CREATE TABLE `guilds`
CREATE TABLE `guild`