   `value` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`name`)
 ) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `userauth`
+-- 
+
+CREATE TABLE `userauth` (
+  `username` varchar(64) NOT NULL default '',
+  `digest` enum('md4','md5','sha1') NOT NULL default 'md4',
+  `seed` varchar(20) NOT NULL default '',
+  `key` varchar(16) NOT NULL default '',
+  `keyIndex` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`username`)
+) TYPE=MyISAM;

  `msgtype` int(11) NOT NULL default '0',
  `message` text NOT NULL,
  PRIMARY KEY  (`msgid`),
  KEY `timeChan` (`timestamp`,`chanid`),
  KEY `messageType` (`chanid`,`msgtype`,`timestamp`),
  FULLTEXT KEY `searchtext` (`nick`,`message`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1-Debian-1ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 23, 2006 at 05:12 PM
-- Server version: 4.0.24
-- PHP Version: 4.4.0-3
-- 
-- Database: `beirdobot`
-- 
