diff options
| -rw-r--r-- | DATABASE.SCHEMA | 174 |
1 files changed, 174 insertions, 0 deletions
diff --git a/DATABASE.SCHEMA b/DATABASE.SCHEMA new file mode 100644 index 0000000..90d1cc6 --- /dev/null +++ b/DATABASE.SCHEMA @@ -0,0 +1,174 @@ +use asm_main; + +CREATE TABLE `actionlog` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `action` varchar(20) NOT NULL, + `reason` varchar(512) DEFAULT NULL, + `channel` varchar(51) DEFAULT NULL, + `nick` varchar(17) NOT NULL, + `user` varchar(11) DEFAULT NULL, + `host` varchar(64) DEFAULT NULL, + `ip` int(10) unsigned DEFAULT NULL, + `gecos` varchar(512) DEFAULT NULL, + `account` varchar(17) DEFAULT NULL, + `bynick` varchar(17) DEFAULT NULL, + `byuser` varchar(11) DEFAULT NULL, + `byhost` varchar(64) DEFAULT NULL, + `bygecos` varchar(512) DEFAULT NULL, + `byaccount` varchar(17) DEFAULT NULL, + PRIMARY KEY (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +CREATE TABLE `alertlog` ( + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` text NOT NULL, + `nick` text NOT NULL, + `user` text NOT NULL, + `host` text NOT NULL, + `gecos` text NOT NULL, + `level` tinytext NOT NULL, + `id` tinytext NOT NULL, + `reason` text NOT NULL, + KEY `channel` (`channel`(51)), + KEY `nick` (`nick`(17)), + KEY `user` (`user`(11)), + KEY `host` (`host`(64)), + KEY `gecos` (`gecos`(512)), + KEY `level` (`level`(16)), + KEY `id` (`id`(32)), + KEY `reason` (`reason`(512)), + KEY `time` (`time`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +use asm_log; +CREATE TABLE `action` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `joins` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `kick` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `ip` int(10) unsigned DEFAULT NULL, + `account` varchar(17) DEFAULT NULL, + `victim_nick` varchar(16) DEFAULT NULL, + `content1` varchar(1000) DEFAULT NULL, + `victim_user` varchar(10) DEFAULT NULL, + `victim_host` varchar(63) DEFAULT NULL, + `victim_geco` varchar(255) DEFAULT NULL, + `victim_ip` int(10) unsigned DEFAULT NULL, + `victim_account` varchar(17) DEFAULT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `mode` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(2) NOT NULL, + `content2` varchar(1000) DEFAULT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `nick` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(16) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `notice` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `part` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `ip` int(10) unsigned DEFAULT NULL, + `account` varchar(17) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `privmsg` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `quit` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `ip` int(10) unsigned DEFAULT NULL, + `account` varchar(17) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + +CREATE TABLE `topic` ( + `index` bigint(20) NOT NULL AUTO_INCREMENT, + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `channel` varchar(30) NOT NULL, + `nick` varchar(16) NOT NULL, + `user` varchar(10) NOT NULL, + `host` varchar(63) NOT NULL, + `geco` varchar(255) DEFAULT NULL, + `content1` varchar(1000) NOT NULL, + KEY `index` (`index`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 + |