[irc/SurrealServices/srsv.git] / branches / 0.4.3 / sql / 004003005.sql

ALTER TABLE  `chanreg` DROP `bantime`;
ALTER TABLE `chanreg` ADD  `bantime` int(11) UNSIGNED default 0;

DROP TABLE IF EXISTS `tmpban`;
CREATE TABLE IF NOT EXISTS `tmpban` (
  `channel` varchar(32) NOT NULL,
  `banmask` varchar(110) NOT NULL,
  `expiry` bigint(20) unsigned NOT NULL,
  `timeset` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `banmask` (`channel`, `banmask`),
  KEY `expiry` (`expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

REPLACE INTO `srsv_schema` (`ver`) VALUES (4003005);
Commit	Line	Data
e4273862	1	ALTER TABLE `chanreg` DROP `bantime`;
	2	ALTER TABLE `chanreg` ADD `bantime` int(11) UNSIGNED default 0;
	3
	4	DROP TABLE IF EXISTS `tmpban`;
	5	CREATE TABLE IF NOT EXISTS `tmpban` (
	6	`channel` varchar(32) NOT NULL,
	7	`banmask` varchar(110) NOT NULL,
	8	`expiry` bigint(20) unsigned NOT NULL,
	9	`timeset` bigint(20) unsigned NOT NULL,
	10	UNIQUE KEY `banmask` (`channel`, `banmask`),
12214858	11	KEY `expiry` (`expiry`)
e4273862	12	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	13
	14	REPLACE INTO `srsv_schema` (`ver`) VALUES (4003005);