SukuDokuWiki

DROP TABLE IF EXISTS `Log_Spam`;
CREATE TABLE `Log_Spam` (
  `LogMsg` varchar(255) default NULL,
  `LogDate` datetime default NULL,
  `Account` varchar(64) NOT NULL default '',
  `id` bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `iAccount` (`Account`),
  KEY `LogDate` (`LogDate`)
)   DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `Log_SendMail`;
CREATE TABLE `Log_SendMail` (
  `LogMsg` varchar(64) default NULL,
  `LogDate` datetime default NULL,
  `Account` varchar(128) NOT NULL default '',
  `id` bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `iAccount` (`Account`),
  KEY `LogDate` (`LogDate`)
)   DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `Log_RecvMail`;
CREATE TABLE `Log_RecvMail` (
  `LogMsg` varchar(64) default NULL,
  `LogDate` datetime default NULL,
  `Account` varchar(128) NOT NULL default '',
  `id` bigint(12) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `iAccount` (`Account`),
  KEY `LogDate` (`LogDate`)
)   DEFAULT CHARSET=latin1;