I have it simply has:
Code: Select all
CREATE TABLE `config` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(150) NOT NULL default '',
`value` text NOT NULL,
`dateupdated` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ID`)
) AUTO_INCREMENT=1 ;Is this the best method, anyone got any prior experience with a better method?
Many thanks,
Rich