Browser Ikariam - Italia

01.CREATE TABLE `chat` (

02.`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

03.`from` VARCHAR(255) NOT NULL DEFAULT '',

04.`to` VARCHAR(255) NOT NULL DEFAULT '',

05.`message` TEXT NOT NULL,

06.`sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',

07.`recd` INTEGER UNSIGNED NOT NULL DEFAULT 0,

08.PRIMARY KEY (`id`),

09.INDEX `to` (`to`),

10.INDEX `from` (`from`)

11.)

12.ENGINE = InnoDB;