CREATE TABLE `adminmessage` (
  `adminmessageid` int(10) unsigned NOT NULL auto_increment,
  `varname` varchar(250) NOT NULL default '',
  `dismissable` smallint(5) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `execurl` mediumtext NOT NULL,
  `method` enum('get','post') NOT NULL default 'post',
  `dateline` int(10) unsigned NOT NULL default '0',
  `status` enum('undone','done','dismissed') NOT NULL default 'undone',
  `statususerid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adminmessageid`),
  KEY `script_action` (`script`,`action`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1