sql file

git-svn-id: http://svn.tabris.net/repos/srsv@3565 70d4eda1-72e9-0310-a436-91e5bd24443c

diff --git a/branches/0.4.3/sql/004003004.sql b/branches/0.4.3/sql/004003004.sql
new file mode 100644 (file)
index 0000000..96a4209
--- /dev/null
+++ b/branches/0.4.3/sql/004003004.sql
@@ -0,0 +1,12 @@
+ALTER TABLE  `chanreg` ADD  `bantime` BIGINT( 20 ) UNSIGNED NOT NULL;
+
+CREATE TABLE IF NOT EXISTS `tmpban` (
+  `channel` varchar(20) NOT NULL,
+  `banmask` varchar(20) NOT NULL,
+  `expiry` bigint(20) unsigned NOT NULL,
+  `timeset` bigint(20) unsigned NOT NULL,
+  KEY `banmask` (`banmask`),
+  KEY `timeset` (`timeset`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+REPLACE INTO `srsv_schema` (`ver`) VALUES (4003004);