User Tools

Site Tools


huy:mysql_atmail
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;
huy/mysql_atmail.txt · Last modified: 2007/04/17 15:35 (external edit)