-- MySQL dump 9.08
--
-- Host: localhost    Database: JinglyBOT
---------------------------------------------------------
-- Server version	4.0.15a-log

--
-- Table structure for table 'AccessList'
--

CREATE TABLE AccessList (
  Nick tinytext NOT NULL,
  Level tinyint(4) NOT NULL default '0',
  Password varchar(32) NOT NULL default '',
  QuoteAdmin enum('TRUE','FALSE') NOT NULL default 'FALSE'
) TYPE=MyISAM;

--
-- Table structure for table 'AdminSessions'
--

CREATE TABLE AdminSessions (
  Nick tinytext NOT NULL,
  IPAddress varchar(15) NOT NULL default '',
  SessionID varchar(15) NOT NULL default '',
  AccessTime timestamp(14) NOT NULL
) TYPE=MyISAM;

--
-- Table structure for table 'InsultFormat'
--

CREATE TABLE InsultFormat (
  FormatID smallint(6) NOT NULL auto_increment,
  Format tinytext NOT NULL,
  PRIMARY KEY  (FormatID)
) TYPE=MyISAM;

--
-- Table structure for table 'InsultWord'
--

CREATE TABLE InsultWord (
  WordID smallint(6) NOT NULL auto_increment,
  Type tinytext NOT NULL,
  Word tinytext NOT NULL,
  PRIMARY KEY  (WordID)
) TYPE=MyISAM;

--
-- Table structure for table 'Karma'
--

CREATE TABLE Karma (
  Key tinytext NOT NULL,
  Score smallint(6) NOT NULL default '0',
  UNIQUE KEY Key (Key(255))
) TYPE=MyISAM;

--
-- Table structure for table 'KnowledgeBase'
--

CREATE TABLE KnowledgeBase (
  Key text NOT NULL,
  Definition text NOT NULL,
  Nick tinytext
) TYPE=MyISAM;

--
-- Table structure for table 'NickLinks'
--

CREATE TABLE NickLinks (
  OriginalID int(11) NOT NULL default '0',
  LinkedID int(11) NOT NULL default '0',
  PRIMARY KEY  (OriginalID,LinkedID)
) TYPE=MyISAM;

--
-- Table structure for table 'Nicks'
--

CREATE TABLE Nicks (
  Nick tinytext NOT NULL,
  ID int(11) NOT NULL auto_increment,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table 'Prefs'
--

CREATE TABLE Prefs (
  Nick varchar(32) NOT NULL default '',
  Package varchar(234) NOT NULL default '',
  Name varchar(234) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  PRIMARY KEY  (Nick,Package,Name)
) TYPE=MyISAM;

--
-- Table structure for table 'QuoteIndex'
--

CREATE TABLE QuoteIndex (
  QuoteID smallint(6) NOT NULL default '0',
  Quoter tinytext NOT NULL,
  Hostmask text,
  Time datetime default '0000-00-00 00:00:00',
  LineCount tinyint(4) NOT NULL default '0',
  Score smallint(6) NOT NULL default '0',
  PRIMARY KEY  (QuoteID)
) TYPE=MyISAM;

--
-- Table structure for table 'QuoteLines'
--

CREATE TABLE QuoteLines (
  QuoteID smallint(5) unsigned NOT NULL default '0',
  LineNumber tinyint(3) unsigned NOT NULL default '0',
  Nickname tinytext NOT NULL,
  Text text NOT NULL,
  KEY QuoteID (QuoteID),
  KEY LineNumber (LineNumber)
) TYPE=MyISAM;

--
-- Table structure for table 'Reports'
--

CREATE TABLE Reports (
  ID int(11) NOT NULL auto_increment,
  Type enum('bug','feature') NOT NULL default 'bug',
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  From tinytext NOT NULL,
  Text longtext NOT NULL,
  Status enum('pending','processing','done') NOT NULL default 'pending',
  Assignee tinytext NOT NULL,
  Related int(11) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Table structure for table 'Seen'
--

CREATE TABLE Seen (
  Nick tinytext NOT NULL,
  Type enum('QUIT','PART','NICK','TALK') NOT NULL default 'QUIT',
  Text text,
  Location tinytext NOT NULL,
  Time datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

--
-- Table structure for table 'Stats'
--

CREATE TABLE Stats (
  Nick tinytext NOT NULL,
  Channel tinytext NOT NULL,
  LineCount int(11) NOT NULL default '0',
  Obscenities int(11) NOT NULL default '0',
  Hehs int(11) NOT NULL default '0',
  Soliloquies int(11) NOT NULL default '0',
  Questions int(11) NOT NULL default '0',
  Happiness int(11) NOT NULL default '0',
  Links int(11) NOT NULL default '0',
  PRIMARY KEY  (Nick(250),Channel(250))
) TYPE=MyISAM;

--
-- Table structure for table 'Tell'
--

CREATE TABLE Tell (
  ID bigint(20) unsigned NOT NULL auto_increment,
  To tinytext NOT NULL,
  From tinytext NOT NULL,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Message text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

