-- MySQL dump 8.22
--
-- Host: localhost    Database: nikkichat
---------------------------------------------------------
-- Server version	3.23.56

--
-- Table structure for table 'banned'
--

CREATE TABLE banned (
  entry varchar(255) NOT NULL default '',
  PRIMARY KEY  (entry)
) TYPE=MyISAM;

--
-- Dumping data for table 'banned'
--



--
-- Table structure for table 'memo'
--

CREATE TABLE memo (
  memo_to varchar(255) default NULL,
  memo_from varchar(255) default NULL,
  message text,
  memo_date int(11) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'memo'
--



--
-- Table structure for table 'messages'
--

CREATE TABLE messages (
  type varchar(255) default NULL,
  message_from varchar(255) default NULL,
  message_to varchar(255) default NULL,
  message text,
  message_timestamp int(11) default NULL,
  message_id varchar(30) NOT NULL default '',
  room int(11) default NULL,
  PRIMARY KEY  (message_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'messages'
--


INSERT INTO messages VALUES ('plain','dalbaech','','<B>dalbaech has entered the chat</B>',1055525746,'1055525746.8103.DHI',0);
INSERT INTO messages VALUES ('plain','WELCOME','dalbaech','Welcome to BetBasel ChatRoom!<BR>/help - helptext',1055525746,'1055525746.8103.OIT',0);
INSERT INTO messages VALUES ('action','dalbaech','','loginsound',1055525746,'1055525746.8103.ODV',0);
INSERT INTO messages VALUES ('command','HELP','dalbaech','<B>[HELP]</B> <I><B>You may use the following commands (according to your userlevel):</B></I><P> /away <KBD>message</KBD> - set or unset away status and post message (optional)<BR>/help - this help text<BR>/help <KBD>command</KBD> - help message of command<BR>/me - action (eg \"/me says hello\" will appear as \"* user says hello\")<BR>/whois <KBD>username</KBD> - show profile of user<BR>/about - about this program<BR>/memo <KBD>username message</KBD> - leave message for offline user<BR>/userlevel <KBD>username level [masterpassword]</KBD> - change userlevel of user (own userlevel must be > level, or masterpassword has to be given)<BR>/msg <KBD>username</KBD> <KBD>message</KBD> - send private message to user<BR>',1055525766,'1055525766.9807.HWD',0);
INSERT INTO messages VALUES ('command','WHOIS','dalbaech','<B>[WHOIS]</B> <B>dalbaech</B><BR>realname: <BR>email: <A HREF=\"mailto:\"></A><BR>age: <BR>city: <BR>country: <BR>homepage: <A HREF=\"\"></A><BR>anything else: <BR>photo: <A HREF=\"\"></A>',1055525776,'1055525776.28905.LIQ',0);
INSERT INTO messages VALUES ('command','LOGOUT','','<B>[LOGOUT]</B> <B> dalbaech has left the chat</B>',1055525787,'1055525787.5843.TMN',0);

--
-- Table structure for table 'nicks'
--

CREATE TABLE nicks (
  name varchar(255) NOT NULL default '',
  password varchar(255) default NULL,
  email varchar(255) default NULL,
  doc varchar(30) default NULL,
  lvd int(11) default NULL,
  updatefrequency int(11) default NULL,
  color varchar(8) default NULL,
  new_msg_on_top int(11) default NULL,
  banlevel int(11) default NULL,
  ip varchar(15) default NULL,
  memos int(11) default NULL,
  loginsound text,
  userlevel int(11) default NULL,
  streaming int(11) default NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Dumping data for table 'nicks'
--


INSERT INTO nicks VALUES ('dalbaech','550316','dalbaech@dalbaech.net','1055525746',1055525746,10,'standard',0,0,'212.41.64.67',0,NULL,0,0);

--
-- Table structure for table 'stillalive'
--

CREATE TABLE stillalive (
  name varchar(255) NOT NULL default '',
  sa_timestamp int(11) default NULL,
  away int(11) default NULL,
  userlevel int(11) default NULL,
  id varchar(50) default NULL,
  password varchar(255) default NULL,
  email varchar(255) default NULL,
  updatefrequency int(11) default NULL,
  color varchar(8) default NULL,
  new_msg_on_top int(11) default NULL,
  loginsound text,
  streaming int(11) default NULL,
  room int(11) default NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Dumping data for table 'stillalive'
--



--
-- Table structure for table 'userinfo'
--

CREATE TABLE userinfo (
  name varchar(255) NOT NULL default '',
  realname varchar(255) default NULL,
  email varchar(255) default NULL,
  age varchar(255) default NULL,
  city varchar(255) default NULL,
  country varchar(255) default NULL,
  url text,
  stuff text,
  photo_url text,
  icq_uin varchar(255) default NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

--
-- Dumping data for table 'userinfo'
--