swparserlogs table

[ZeroSixty]

Hello,

I have accidentally removed the swparserlogs table from the database. Can someone please tell me how to create this again ASAP?

How many fields and their names?

[v0lc4n0]

Originally Posted by ZeroSixty

Can someone please tell me how to create this again ASAP?

How many fields and their names?

Here is SQL command for re-creating table swparserlogs table.

CREATE TABLE `swparserlogs` (
  `parserlogid` int(10) unsigned NOT NULL auto_increment,
  `typeid` int(10) unsigned NOT NULL default '0',
  `ticketmaskid` varchar(20) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `emailqueueid` int(10) unsigned NOT NULL default '0',
  `logtype` enum('failure','success') NOT NULL default 'failure',
  `subject` varchar(255) NOT NULL default '',
  `fromemail` varchar(255) NOT NULL default '',
  `toemail` varchar(255) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `parsetimetaken` float unsigned NOT NULL default '0',
  `responsetype` enum('ticket','reply','bug') NOT NULL default 'ticket',
  `ticketpostid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`parserlogid`),
  KEY `parserlogs2` (`ticketpostid`),
  KEY `parserlogs3` (`dateline`)
) TYPE=MyISAM;

[ZeroSixty]

Thank you