CREATE TABLE `mydatabase`.`chat` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`zeit` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`nick` varchar( 30 ) NOT NULL default '',
`text` text NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
|