CREATE TABLE `chat` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`from` VARCHAR(255) NOT NULL DEFAULT '',
`to` VARCHAR(255) NOT NULL DEFAULT '',
`message` TEXT NOT NULL,
`sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`recd` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
INDEX `to` (`to`),
INDEX `from` (`from`)
)
ENGINE = InnoDB;
Add the following scripts to your page template
view sourceprint?
