CREATE TABLE `entries` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`author` VARCHAR(50) NOT NULL,
	`posted` DATETIME NOT NULL,
	`ip` CHAR(15) NOT NULL,
	`text` TEXT DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `posted` (`posted`)
);