# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Nov 07, 2002 at 11:43 PM
# Server version: 4.00.01
# PHP Version: 4.2.3
# Database : `natasha`
# --------------------------------------------------------

#
# Table structure for table `admins`
#

CREATE TABLE `admins` (
  `uid` int(5) NOT NULL default '0',
  `dispnick` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `realname` varchar(60) NOT NULL default '',
  `comments` text NOT NULL,
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `uid` (`uid`)
) TYPE=MyISAM COMMENT='Support table to users';
# --------------------------------------------------------

#
# Table structure for table `arms`
#

CREATE TABLE `arms` (
  `id` int(5) NOT NULL default '0',
  `nick` char(20) NOT NULL default '',
  `type` tinyint(2) NOT NULL default '30',
  `channels` tinyint(2) NOT NULL default '1',
  `status` tinyint(1) NOT NULL default '0',
  `sid` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `sid` (`sid`)
) TYPE=MyISAM COMMENT='The arms';
# --------------------------------------------------------

#
# Table structure for table `badchan`
#

CREATE TABLE `badchan` (
  `id` int(11) NOT NULL auto_increment,
  `channel` char(250) NOT NULL default '',
  `adder` int(5) NOT NULL default '0',
  `reason` char(250) NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  `expire` int(10) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='The banned channels';
# --------------------------------------------------------

#
# Table structure for table `channels`
#

CREATE TABLE `channels` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `modes` varchar(15) NOT NULL default '+tn',
  `key` varchar(20) NOT NULL default '',
  `autoop` tinyint(1) NOT NULL default '1',
  `autovoice` tinyint(1) NOT NULL default '1',
  `bitch` tinyint(1) NOT NULL default '0',
  `ftopic` tinyint(1) NOT NULL default '0',
  `mvoice` varchar(10) NOT NULL default '',
  `advertise` tinyint(1) NOT NULL default '0',
  `flood` varchar(7) NOT NULL default '3:3',
  `peak` int(5) NOT NULL default '0',
  `greet` tinyint(1) NOT NULL default '1',
  `tv` tinyint(1) NOT NULL default '1',
  `vote` tinyint(1) NOT NULL default '0',
  `infobot` tinyint(1) NOT NULL default '0',
  `stats` tinyint(1) NOT NULL default '1',
  `onjoin` text NOT NULL,
  `arm` tinyint(4) NOT NULL default '0',
  `sid` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`name`),
  KEY `sid` (`sid`)
) TYPE=MyISAM COMMENT='The channel table, with modes';
# --------------------------------------------------------

#
# Table structure for table `chanusers`
#

CREATE TABLE `chanusers` (
  `cid` int(5) unsigned NOT NULL default '0',
  `uid` int(5) unsigned NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  `greet` char(100) NOT NULL default '',
  `sid` tinyint(2) NOT NULL default '0',
  KEY `sid` (`sid`)
) TYPE=MyISAM COMMENT='The table with all channel users';
# --------------------------------------------------------

#
# Table structure for table `info`
#

CREATE TABLE `info` (
  `stats_lastupdate` int(10) NOT NULL default '0',
  `stats_time` int(5) NOT NULL default '0'
) TYPE=MyISAM COMMENT='Some info fields';
# --------------------------------------------------------

#
# Table structure for table `infobot`
#

CREATE TABLE `infobot` (
  `id` int(5) NOT NULL default '0',
  `cid` int(5) NOT NULL default '0',
  `command` char(10) NOT NULL default '',
  `message` char(245) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Infobot';
# --------------------------------------------------------

#
# Table structure for table `log`
#

CREATE TABLE `log` (
  `id` bigint(20) NOT NULL auto_increment,
  `cid` int(5) NOT NULL default '0',
  `action` varchar(10) NOT NULL default '',
  `nick` varchar(20) NOT NULL default '',
  `username` varchar(10) NOT NULL default '',
  `host` varchar(63) NOT NULL default '',
  `uid` int(6) NOT NULL default '0',
  `msg` text NOT NULL,
  `time` int(10) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cid` (`cid`)
) TYPE=MyISAM COMMENT='The logs';
# --------------------------------------------------------

#
# Table structure for table `request`
#

CREATE TABLE `request` (
  `id` int(8) NOT NULL auto_increment,
  `channel` char(200) NOT NULL default '',
  `bot` char(16) NOT NULL default '',
  `users` int(5) NOT NULL default '0',
  `topic` char(250) NOT NULL default '',
  `service` char(1) NOT NULL default '',
  `uid` int(5) NOT NULL default '0',
  `nick` char(16) NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `huid` int(5) NOT NULL default '0',
  `reason` char(230) NOT NULL default '',
  `htime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='The requests';
# --------------------------------------------------------

#
# Table structure for table `services`
#

CREATE TABLE `services` (
  `id` tinyint(2) NOT NULL default '1',
  `name` char(50) NOT NULL default '',
  `admin` char(20) NOT NULL default '',
  `host` char(50) NOT NULL default '',
  `port` int(5) NOT NULL default '4860',
  `statsdb_ip` char(100) NOT NULL default '',
  `statsdb_port` mediumint(5) NOT NULL default '3306',
  `statsdb_db` char(50) NOT NULL default '',
  `statsdb_user` char(20) NOT NULL default '',
  `statsdb_pass` char(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='The services in the house';
# --------------------------------------------------------

#
# Table structure for table `stats`
#

CREATE TABLE `stats` (
  `name` varchar(200) NOT NULL default '',
  `cid` int(5) NOT NULL default '0',
  `html` text NOT NULL
) TYPE=MyISAM COMMENT='The stats HTML pages';
# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE `users` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `handle` char(20) NOT NULL default '',
  `auth` tinyint(2) NOT NULL default '1',
  `lastseen` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`handle`),
  KEY `handle` (`handle`)
) TYPE=MyISAM COMMENT='The bot users';

