CREATE TABLE `knowledge` ( `key` varchar(255) collate latin1_general_ci NOT NULL default '', `value` tinytext collate latin1_general_ci NOT NULL, `nick` varchar(255) collate latin1_general_ci NOT NULL default '', `timestamp` datetime NOT NULL default '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;