View Single Post
  #39  
Old 03-26-2009, 04:08 PM
warhawk
Sarnak
 
Join Date: Mar 2008
Posts: 47
Default

I'm having trouble sourcing the SQL. This bit seems to cause a 1064 error:-

Code:
DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
  `varname` varchar(25) NOT NULL default '',
  `value` text NOT NULL,
  `information` text NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM DEFAULT;
Any Ideas?
Reply With Quote