sqlite.sql

   1 CREATE TABLE `bots` (
   2   `nick` varchar(30) NOT NULL,
   3   `user` varchar(10) NOT NULL DEFAULT 'erebus',
   4   `bind` varchar(15) DEFAULT NULL,
   5   `authname` varchar(30) DEFAULT NULL,
   6   `authpass` varchar(20) DEFAULT NULL,
   7   `active` tinyint(1) NOT NULL DEFAULT 1,
   8   `connected` tinyint(1) NOT NULL DEFAULT 0,
   9   PRIMARY KEY (`nick`)
  10 );
  11 CREATE TABLE `chans` (
  12   `chname` varchar(100) NOT NULL,
  13   `bot` varchar(30) NOT NULL,
  14   `active` tinyint(1) NOT NULL DEFAULT 1,
  15   PRIMARY KEY (`chname`)
  16 );
  17 CREATE INDEX chans_bot ON chans (bot);
  18 CREATE TABLE `chusers` (
  19   `chan` varchar(100) NOT NULL,
  20   `user` varchar(30) NOT NULL,
  21   `level` int(11) NOT NULL,
  22   PRIMARY KEY (`chan`,`user`)
  23 );
  24 CREATE TABLE `users` (
  25   `auth` varchar(30) NOT NULL,
  26   `level` tinyint(3) NOT NULL,
  27   PRIMARY KEY (`auth`)
  28 );