CREATE TABLE `chatlogs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `room_id` int(11) NOT NULL, `user_name` varchar(200) NOT NULL, `timestamp` double NOT NULL, `message` varchar(150) NOT NULL, `type` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `room_id` (`room_id`), KEY `timestamp` (`timestamp`), FULLTEXT KEY `message` (`message`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
ALTER TABLE `users`ADD COLUMN `ignoreall` enum('0','1') NOT NULL DEFAULT '0' AFTER `langue`;