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;

