DROP TABLE IF EXISTS channels;
CREATE TABLE channels (
  Id int(18) unsigned NOT NULL auto_increment,
  Name varchar(20) NOT NULL default 'ENTER_CHANNELNAME',
  PASSWORD varchar(30) NOT NULL default '',
  User_Channel char(1) NOT NULL default '0',
  These text NOT NULL,
  Teilnehmerzahl int(11) NOT NULL default '0',
  BG_Color varchar(7) NOT NULL default '#284628',
  NICK_COLOR varchar(7) NOT NULL default '#88DEDE',
  Logo varchar(255) NOT NULL default 'images/exit_logo.gif',
  ExitURL varchar(255) NOT NULL default '/',
  Allow varchar(254) NOT NULL default '',
  moderiert tinyint(4) NOT NULL default '0',
  starts_at datetime NOT NULL default '1999-01-01 00:00:00',
  stops_at datetime NOT NULL default '9999-12-31 23:59:59',
  zeile int(11) NOT NULL default '0',
  zeile_0 text NOT NULL,
  zeile_1 text,
  zeile_2 text,
  zeile_3 text,
  zeile_4 text,
  zeile_5 text,
  zeile_6 text,
  zeile_7 text,
  zeile_8 text,
  zeile_9 text,
  zeile_10 text,
  zeile_11 text,
  zeile_12 text,
  zeile_13 text,
  zeile_14 text,
  zeile_15 text,
  zeile_16 text,
  zeile_17 text,
  zeile_18 text,
  zeile_19 text,
  zeile_20 text,
  zeile_21 text,
  zeile_22 text,
  zeile_23 text,
  zeile_24 text,
  zeile_25 text,
  zeile_26 text,
  zeile_27 text,
  zeile_28 text,
  zeile_29 text,
  zeile_30 text,
  zeile_31 text,
  zeile_32 text,
  zeile_33 text,
  zeile_34 text,
  zeile_35 text,
  zeile_36 text,
  zeile_37 text,
  zeile_38 text,
  zeile_39 text,
  PRIMARY KEY (Id),
  UNIQUE KEY Name(Name)
) TYPE=MyISAM;

#
# Dumping data for table 'channels'
#

INSERT INTO channels (Id, Name, PASSWORD, User_Channel, These, Teilnehmerzahl, BG_Color, NICK_COLOR, Logo, ExitURL, Allow, moderiert, starts_at, stops_at, zeile, zeile_0, zeile_1, zeile_2, zeile_3, zeile_4, zeile_5, zeile_6, zeile_7, zeile_8, zeile_9, zeile_10, zeile_11, zeile_12, zeile_13, zeile_14, zeile_15, zeile_16, zeile_17, zeile_18, zeile_19, zeile_20, zeile_21, zeile_22, zeile_23, zeile_24, zeile_25, zeile_26, zeile_27, zeile_28, zeile_29, zeile_30, zeile_31, zeile_32, zeile_33, zeile_34, zeile_35, zeile_36, zeile_37, zeile_38, zeile_39) VALUES (4,'Channel_1','','0','Welcome to this chat!',0,'#284628','#e1e1e1','images/exit_logo.gif','/','',0,'2002-01-01 00:00:00','9999-01-01 00:00:00',0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

#
# Table structure for table 'chat'
#

DROP TABLE IF EXISTS chat;
CREATE TABLE chat (
  Nick varchar(20) NOT NULL default '',
  Zeit int(11) default NULL,
  Raum varchar(30) default NULL,
  Ignor text,
  Quassel int(11) default NULL,
  GRANT_ACCESS_FOR varchar(255) NOT NULL default '',
  User_busy int(11) default '0',
  color varchar(7) default NULL,
  Host varchar(15) default NULL,
  Gruentext tinyint(4) NOT NULL default '1',
  PRIMARY KEY (Nick),
  KEY Raum(Raum)
) TYPE=MyISAM;

#
# Dumping data for table 'chat'
#


#
# Table structure for table 'chat_data'
#

DROP TABLE IF EXISTS chat_data;
CREATE TABLE chat_data (
  Nick varchar(20) NOT NULL default '',
  Zeit int(11) default NULL,
  Raum varchar(30) default NULL,
  Passwort varchar(10) default NULL,
  PictureURL varchar(130) default NULL,
  Email varchar(130) default NULL,
  Online int(11) default NULL,
  Host varchar(15) default NULL,
  kicked tinyint(4) NOT NULL default '0',
  color varchar(7) default NULL,
  last_kicktime int(11) default NULL,
  RegTime datetime default NULL,
  PRIMARY KEY (Nick)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_data'
#


#
# Table structure for table 'chat_forum'
#

DROP TABLE IF EXISTS chat_forum;
CREATE TABLE chat_forum (
  NUMMER int(10) unsigned NOT NULL auto_increment,
  DATE datetime default NULL,
  NAME varchar(255) default NULL,
  VORNAME varchar(255) default NULL,
  EMAIL varchar(255) default NULL,
  HOMEPAGE varchar(255) default NULL,
  EIGENE_URL varchar(255) default NULL,
  KOMMENTAR blob,
  HOST varchar(255) default NULL,
  THEMA varchar(255) default NULL,
  PRIMARY KEY (NUMMER),
  KEY THEMA(THEMA)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_forum'
#

INSERT INTO chat_forum (NUMMER, DATE, NAME, VORNAME, EMAIL, HOMEPAGE, EIGENE_URL, KOMMENTAR, HOST, THEMA) VALUES (1,'2002-02-04 18:57:21','Forum Admin',NULL,NULL,NULL,NULL,'This is a new topic that has just been opened.\r\nEdit the topics by going to the admin-tool.','127.0.0.1','PHPOpenChat');

#
# Table structure for table 'chat_gb'
#

DROP TABLE IF EXISTS chat_gb;
CREATE TABLE chat_gb (
  ID int(15) NOT NULL auto_increment,
  USER varchar(30) default NULL,
  NICK varchar(20) default NULL,
  DATE datetime default NULL,
  COMMENT text,
  PRIMARY KEY (ID),
  KEY (USER)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_gb'
#


#
# Table structure for table 'chat_mail'
#

DROP TABLE IF EXISTS chat_mail;
CREATE TABLE chat_mail (
  ID int(11) NOT NULL auto_increment,
  TIME datetime NOT NULL default '0000-00-00 00:00:00',
  NICK varchar(20) NOT NULL default '',
  SENDER varchar(15) NOT NULL default '',
  SUBJECT varchar(50) NOT NULL default '',
  BODY text NOT NULL,
  UNREAD tinyint(4) NOT NULL default '1',
  PRIMARY KEY (ID),
  KEY NICK(NICK),
  KEY UNREAD(UNREAD)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_mail'
#


#
# Table structure for table 'chat_messages'
#

DROP TABLE IF EXISTS chat_messages;
CREATE TABLE chat_messages (
  Message_0 text,
  Message_1 text,
  Message_2 text,
  Message_3 text,
  Message_4 text,
  Message_5 text,
  Message_6 text,
  Message_7 text,
  Message_8 text,
  Message_9 text,
  ID int(18) NOT NULL auto_increment,
  PRIMARY KEY (ID)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_messages'
#
INSERT INTO chat_messages VALUES('','','','','','','','','','','');

#
# Table structure for table 'chat_notify'
#

DROP TABLE IF EXISTS chat_notify;
CREATE TABLE chat_notify (
  Nick varchar(20) NOT NULL default '',
  Friend varchar(15) NOT NULL default '',
  Channel varchar(20) default NULL,
  Time timestamp(14) NOT NULL,
  PRIMARY KEY (Nick,Friend)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_notify'
#


#
# Table structure for table 'chat_userpages'
#

DROP TABLE IF EXISTS chat_userpages;
CREATE TABLE chat_userpages (
  ID int(18) NOT NULL auto_increment,
  Nick varchar(20) NOT NULL default '',
  Gender varchar(15) default NULL,
  Birthdate varchar(8) default NULL,
  City varchar(100) default NULL,
  ICQ varchar(15) default NULL,
  Homepage varchar(130) default NULL,
  Theme varchar(250) default NULL,
  Hobbies varchar(250) default NULL,
  Info text,
  Picture varchar(130) default NULL,
  Show_Email tinyint(1) default '0',
  Show_Birthdate tinyint(1) default '0',
  Show_Friends tinyint(1) default '0',
  PRIMARY KEY (Nick),
  KEY ID(ID)
) TYPE=MyISAM;

#
# Dumping data for table 'chat_userpages'
#


#
# Table structure for table 'comoderators'
#

DROP TABLE IF EXISTS comoderators;
CREATE TABLE comoderators (
  Nick varchar(20) NOT NULL default '',
  PRIMARY KEY (Nick)
) TYPE=MyISAM;

#
# Dumping data for table 'comoderators'
#


#
# Table structure for table 'ct_bilder'
#

DROP TABLE IF EXISTS ct_bilder;
CREATE TABLE ct_bilder (
  nick varchar(20) NOT NULL default '',
  text varchar(255) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  freigabe tinyint(1) NOT NULL default '0',
  id int(8) unsigned NOT NULL auto_increment,
  PRIMARY KEY (id),
  KEY freigabe(freigabe)
) TYPE=MyISAM;

#
# Dumping data for table 'ct_bilder'
#


#
# Table structure for table 'hall_of_fame'
#

DROP TABLE IF EXISTS hall_of_fame;
CREATE TABLE hall_of_fame (
  nick varchar(20) NOT NULL default '',
  days int(8) NOT NULL default '0',
  PRIMARY KEY (nick)
) TYPE=MyISAM;

#
# Dumping data for table 'hall_of_fame'
#


#
# Table structure for table 'paten'
#

DROP TABLE IF EXISTS paten;
CREATE TABLE paten (
  Nick char(20) NOT NULL default '',
  PRIMARY KEY (Nick)
) TYPE=MyISAM;

#
# Dumping data for table 'paten'
#


#
# Table structure for table 'vip'
#

DROP TABLE IF EXISTS vip;
CREATE TABLE vip (
  Nick varchar(20) NOT NULL default '',
  Moderator varchar(20) default NULL,
  Channel varchar(20) default NULL,
  PRIMARY KEY (Nick)
) TYPE=MyISAM;

#
# Dumping data for table 'vip'
#