tags/0.4.3.1-pre2/sql/004003004.sql

   1 ALTER TABLE  `chanreg` ADD  `bantime` BIGINT( 20 ) UNSIGNED NOT NULL;
   2
   3 CREATE TABLE IF NOT EXISTS `tmpban` (
   4   `channel` varchar(20) NOT NULL,
   5   `banmask` varchar(20) NOT NULL,
   6   `expiry` bigint(20) unsigned NOT NULL,
   7   `timeset` bigint(20) unsigned NOT NULL,
   8   KEY `banmask` (`banmask`),
   9   KEY `timeset` (`timeset`)
  10 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  11
  12 REPLACE INTO `srsv_schema` (`ver`) VALUES (4003004);