i can't find anything that tells me when is a reserved word so i don't really know what's the issue here. any help would be appreciated.
Code: Select all
CREATE TABLE apphist(
appindex int unsigned NOT NULL auto_increment PRIMARY KEY,
approver varchar(15) NOT NULL,
member varchar(15) NOT NULL,
item tinyint(1) NOT NULL,
reason tinytext,
ok tinyint(1) NOT NULL,
when datetime default '0000-00-00 00:00:00' NOT NULL,
KEY approver (approver),
KEY member (member),
KEY item (item),
KEY ok (ok),
KEY when (when)
) TYPE=MyISAM;