-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 15, 2005 at 07:12 AM
-- Server version: 4.1.8
-- PHP Version: 5.0.3
-- 
-- Database: `pjj_dk`
-- 

-- 
-- Table structure for table `uo_chat`
-- 

CREATE TABLE `uo_chat` (
  `utime` int(15) NOT NULL default '0',
  `ip` bigint(20) default NULL,
  `chat` char(16) character set latin1 NOT NULL default '',
  `proxyip` bigint(20) default NULL,
  KEY `chat` (`chat`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=4096;

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

-- 
-- Table structure for table `uo_chat_adminlog`
-- 

CREATE TABLE `uo_chat_adminlog` (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `chat_id` int(10) unsigned NOT NULL default '0',
  `page_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_ip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`entry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_ban`
-- 

CREATE TABLE `uo_chat_ban` (
  `chat` char(16) character set latin1 NOT NULL default '',
  `ident` char(10) character set latin1 NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `auth` char(32) character set latin1 NOT NULL default '',
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=256;

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

-- 
-- Table structure for table `uo_chat_biglog`
-- 

CREATE TABLE `uo_chat_biglog` (
  `chat` varchar(16) collate utf8_unicode_ci NOT NULL default '',
  `chat_id` int(10) unsigned NOT NULL default '0',
  `user` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `user_id` int(10) unsigned NOT NULL default '0',
  `message` blob NOT NULL,
  `stamp` datetime default '0000-00-00 00:00:00',
  `message_id` int(10) unsigned NOT NULL auto_increment,
  `ident` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`message_id`),
  KEY `chat` (`chat`),
  KEY `user` (`user`),
  KEY `ident` (`ident`),
  KEY `user_id` (`user_id`),
  KEY `chat_id` (`chat_id`),
  KEY `stamp` (`stamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_biglog_wordhits`
-- 

CREATE TABLE `uo_chat_biglog_wordhits` (
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `message_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_id`,`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=1 DELAY_KEY_WRITE=1;

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

-- 
-- Table structure for table `uo_chat_biglog_words`
-- 

CREATE TABLE `uo_chat_biglog_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`word_id`),
  UNIQUE KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=1 DELAY_KEY_WRITE=1;

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

-- 
-- Table structure for table `uo_chat_boards`
-- 

CREATE TABLE `uo_chat_boards` (
  `chat` varchar(16) character set latin1 NOT NULL default '',
  `flags` char(2) character set latin1 NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `topic` varchar(255) character set latin1 NOT NULL default '',
  `username` varchar(64) character set latin1 NOT NULL default '',
  `ctime` int(11) unsigned NOT NULL default '0',
  `uid` int(8) unsigned NOT NULL auto_increment,
  `hits` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_char`
-- 

CREATE TABLE `uo_chat_char` (
  `chat` varchar(16) character set latin1 NOT NULL default '',
  `username` varchar(64) character set latin1 NOT NULL default '',
  `type` int(3) NOT NULL default '0',
  `data` mediumtext character set latin1 NOT NULL,
  `lastmod` int(8) NOT NULL default '0',
  KEY `chat` (`chat`),
  KEY `username` (`username`(2)),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_database`
-- 

CREATE TABLE `uo_chat_database` (
  `chat` varchar(16) character set latin1 NOT NULL default '',
  `username` varchar(64) character set latin1 NOT NULL default '',
  `password` varchar(32) character set latin1 NOT NULL default '',
  `flags` varchar(24) character set latin1 NOT NULL default '',
  `email` varchar(128) character set latin1 NOT NULL default '',
  `faction` smallint(6) NOT NULL default '0',
  `prefs` varchar(24) character set latin1 NOT NULL default '',
  `icq` int(12) unsigned NOT NULL default '0',
  `aim` varchar(16) character set latin1 NOT NULL default '',
  `ym` varchar(64) character set latin1 NOT NULL default '',
  `msn` varchar(128) character set latin1 NOT NULL default '',
  `site` text character set latin1 NOT NULL,
  `uid` int(8) unsigned NOT NULL auto_increment,
  `profile` blob NOT NULL,
  `icon` text character set latin1 NOT NULL,
  `chain` blob NOT NULL,
  `picon` text character set latin1 NOT NULL,
  `pimage` text character set latin1 NOT NULL,
  `plink` text character set latin1 NOT NULL,
  `pcolor` varchar(6) character set latin1 NOT NULL default '',
  `lastlogin` int(12) unsigned NOT NULL default '0',
  `skype` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`uid`),
  KEY `chat` (`chat`),
  KEY `username` (`username`(2))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_faction`
-- 

CREATE TABLE `uo_chat_faction` (
  `chat` varchar(16) NOT NULL default '',
  `id` mediumint(9) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `icon` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_ignore`
-- 

CREATE TABLE `uo_chat_ignore` (
  `chat` char(16) NOT NULL default '',
  `ident` char(8) NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `auth` char(8) NOT NULL default '',
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=256;

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

-- 
-- Table structure for table `uo_chat_images`
-- 

CREATE TABLE `uo_chat_images` (
  `width` smallint(5) unsigned NOT NULL default '0',
  `height` smallint(5) unsigned NOT NULL default '0',
  `sum` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=16384;

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

-- 
-- Table structure for table `uo_chat_last`
-- 

CREATE TABLE `uo_chat_last` (
  `chat` varchar(16) character set latin1 NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `email` varchar(255) character set latin1 NOT NULL default '',
  `owner` varchar(64) character set latin1 NOT NULL default '',
  `numwarn` int(3) unsigned NOT NULL default '0',
  `ctime` int(11) unsigned NOT NULL default '0',
  `prefs` varchar(32) character set latin1 NOT NULL default '0',
  `regnotes` text character set latin1,
  `chat_id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`chat`),
  UNIQUE KEY `chat_id` (`chat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table `uo_chat_log`
-- 

CREATE TABLE `uo_chat_log` (
  `chat` varchar(16) NOT NULL default '',
  `id` smallint(4) unsigned NOT NULL default '0',
  `ident` varchar(8) NOT NULL default '',
  `line` blob NOT NULL,
  `username` varchar(64) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `csig` varchar(32) NOT NULL default '',
  `proxyip` varchar(250) default NULL,
  KEY `chat` (`chat`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=16384;

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

-- 
-- Table structure for table `uo_chat_message`
-- 

CREATE TABLE `uo_chat_message` (
  `message_id` int(10) unsigned NOT NULL auto_increment,
  `chat` varchar(16) NOT NULL default '',
  `username` varchar(64) NOT NULL default '',
  `msg` text NOT NULL,
  `auth` varchar(64) NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `deleted` set('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`message_id`),
  KEY `chat` (`chat`),
  KEY `username` (`username`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_poll`
-- 

CREATE TABLE `uo_chat_poll` (
  `chat` varchar(16) NOT NULL default '',
  `topic` text NOT NULL,
  `nselect` tinyint(4) NOT NULL default '0',
  `ta` text NOT NULL,
  `ca` varchar(6) NOT NULL default '',
  `tb` text NOT NULL,
  `cb` varchar(6) NOT NULL default '',
  `tc` text NOT NULL,
  `cc` varchar(6) NOT NULL default '',
  `td` text NOT NULL,
  `cd` varchar(6) NOT NULL default '',
  `te` text NOT NULL,
  `ce` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_regapps`
-- 

CREATE TABLE `uo_chat_regapps` (
  `id` mediumint(9) unsigned NOT NULL auto_increment,
  `chat` varchar(16) NOT NULL default '',
  `username` varchar(64) NOT NULL default '',
  `email` varchar(128) NOT NULL default '',
  `faction` mediumint(9) NOT NULL default '0',
  `description` text,
  `rtime` int(11) unsigned NOT NULL default '0',
  `appstat` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_stats`
-- 

CREATE TABLE `uo_chat_stats` (
  `chat` varchar(16) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `h00` mediumint(8) unsigned NOT NULL default '0',
  `h01` mediumint(8) unsigned NOT NULL default '0',
  `h02` mediumint(8) unsigned NOT NULL default '0',
  `h03` mediumint(8) unsigned NOT NULL default '0',
  `h04` mediumint(8) unsigned NOT NULL default '0',
  `h05` mediumint(8) unsigned NOT NULL default '0',
  `h06` mediumint(8) unsigned NOT NULL default '0',
  `h07` mediumint(8) unsigned NOT NULL default '0',
  `h08` mediumint(8) unsigned NOT NULL default '0',
  `h09` mediumint(8) unsigned NOT NULL default '0',
  `h10` mediumint(8) unsigned NOT NULL default '0',
  `h11` mediumint(8) unsigned NOT NULL default '0',
  `h12` mediumint(8) unsigned NOT NULL default '0',
  `h13` mediumint(8) unsigned NOT NULL default '0',
  `h14` mediumint(8) unsigned NOT NULL default '0',
  `h15` mediumint(8) unsigned NOT NULL default '0',
  `h16` mediumint(8) unsigned NOT NULL default '0',
  `h17` mediumint(8) unsigned NOT NULL default '0',
  `h18` mediumint(8) unsigned NOT NULL default '0',
  `h19` mediumint(8) unsigned NOT NULL default '0',
  `h20` mediumint(8) unsigned NOT NULL default '0',
  `h21` mediumint(8) unsigned NOT NULL default '0',
  `h22` mediumint(8) unsigned NOT NULL default '0',
  `h23` mediumint(8) unsigned NOT NULL default '0',
  KEY `chat` (`chat`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_threads`
-- 

CREATE TABLE `uo_chat_threads` (
  `chat` varchar(16) NOT NULL default '',
  `id` mediumint(6) unsigned NOT NULL default '0',
  `utime` int(11) unsigned NOT NULL default '0',
  `topic` varchar(255) NOT NULL default '',
  `post` text NOT NULL,
  `username` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`,`utime`),
  KEY `chat` (`chat`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `uo_chat_ulist`
-- 

CREATE TABLE `uo_chat_ulist` (
  `chat` varchar(16) NOT NULL default '',
  `ident` varchar(10) NOT NULL default '',
  `username` tinytext NOT NULL,
  `link` tinytext NOT NULL,
  `image` tinytext NOT NULL,
  `utime` int(11) unsigned NOT NULL default '0',
  KEY `chat` (`chat`),
  KEY `username` (`username`(2))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=512;

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

-- 
-- Table structure for table `uo_chat_vote`
-- 

CREATE TABLE `uo_chat_vote` (
  `chat` varchar(16) NOT NULL default '',
  `utime` int(11) unsigned NOT NULL default '0',
  `username` varchar(64) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(128) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `vote` tinyint(3) NOT NULL default '0',
  `valid` tinyint(3) NOT NULL default '0',
  KEY `chat` (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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