-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- [URL]http://www.phpmyadmin.net[/URL]
--
-- Host: localhost
-- Erstellungszeit: 18. Dezember 2007 um 14:46
-- Server Version: 5.0.24
-- PHP-Version: 5.2.4
--
-- Datenbank: 'chat'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_blacklist'
--
DROP TABLE IF EXISTS etchat_blacklist;
-- limit --
CREATE TABLE etchat_blacklist (
etchat_blacklist_id int(8) NOT NULL auto_increment,
etchat_blacklist_ip varchar(255) NOT NULL,
etchat_blacklist_userid int(8) NOT NULL,
etchat_blacklist_time int(30) NOT NULL,
PRIMARY KEY (etchat_blacklist_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_blacklist'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_messages'
--
DROP TABLE IF EXISTS etchat_messages;
-- limit --
CREATE TABLE etchat_messages (
etchat_id bigint(20) unsigned NOT NULL auto_increment,
etchat_user_fid int(8) NOT NULL,
etchat_text text NOT NULL,
etchat_text_css text NOT NULL,
etchat_timestamp bigint(20) NOT NULL,
etchat_fid_room int(11) NOT NULL default '1',
etchat_privat int(8) default '0',
PRIMARY KEY (etchat_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_messages'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_rooms'
--
DROP TABLE IF EXISTS etchat_rooms;
-- limit --
CREATE TABLE etchat_rooms (
etchat_id_room int(3) unsigned NOT NULL auto_increment,
etchat_roomname varchar(100) NOT NULL,
PRIMARY KEY (etchat_id_room)
);
-- limit --
--
-- Daten für Tabelle 'etchat_rooms'
--
INSERT INTO etchat_rooms (etchat_id_room, etchat_roomname) VALUES
(1, 'Lobby'),
(2, 'Raum II'),
(3, 'Raum I');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_smileys'
--
DROP TABLE IF EXISTS etchat_smileys;
-- limit --
CREATE TABLE etchat_smileys (
etchat_smileys_id int(5) NOT NULL auto_increment,
etchat_smileys_sign varchar(20) NOT NULL,
etchat_smileys_img varchar(100) NOT NULL,
PRIMARY KEY (etchat_smileys_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_smileys'
--
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':angry:', 'smilies/angry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-]', 'smilies/approve.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-}', 'smilies/blushing.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':charming:', 'smilies/charming.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-P', 'smilies/cheeky.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':cheesy:', 'smilies/cheesy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES ('8-)', 'smilies/cool.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':*(', 'smilies/cry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES ('x-(', 'smilies/dead.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':dissap:', 'smilies/dissappointed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':embar:', 'smilies/embarassed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':evil:', 'smilies/evil.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':goofy:', 'smilies/goofy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-D', 'smilies/grin.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-?', 'smilies/huh.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':idea:', 'smilies/idea.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-L', 'smilies/laugh.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':lips:', 'smilies/lips.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-x', 'smilies/lipsrsealed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':mad:', 'smilies/mad.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-K', 'smilies/ok.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':rolleyes:', 'smilies/rolleyes.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-(', 'smilies/sad.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-O', 'smilies/shocked.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':shy:', 'smilies/shy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':smartass:', 'smilies/smartass.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':smarty:', 'smilies/smarty.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-)', 'smilies/smiley.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':tongue:', 'smilies/tongue.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':undecided:', 'smilies/undecided.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':veryangry:', 'smilies/veryangry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (';-)', 'smilies/wink.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':worried:', 'smilies/worried.gif');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_user'
--
DROP TABLE IF EXISTS etchat_user;
-- limit --
CREATE TABLE etchat_user (
etchat_user_id int(8) NOT NULL auto_increment,
etchat_username varchar(200) NOT NULL,
etchat_userpw varchar(40) default NULL,
etchat_userprivilegien varchar(15) NOT NULL default 'gast',
PRIMARY KEY (etchat_user_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_user'
--
INSERT INTO etchat_user (etchat_user_id, etchat_username, etchat_userpw, etchat_userprivilegien) VALUES
(1, '<i>System</i>', NULL, 'system'),
(2, 'Admin', '21232f297a57a5a743894a0e4a801fc3', 'admin');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_useronline'
--
DROP TABLE IF EXISTS etchat_useronline;
-- limit --
CREATE TABLE etchat_useronline (
etchat_onlineid bigint(20) unsigned NOT NULL auto_increment,
etchat_onlineuser_fid int(8) NOT NULL,
etchat_onlinetimestamp bigint(20) NOT NULL,
etchat_onlineip varchar(255) NOT NULL,
etchat_fid_room int(11) NOT NULL default '1',
etchat_user_online_room_name varchar(100) NOT NULL,
etchat_user_online_user_name varchar(200) NOT NULL,
etchat_user_online_user_priv varchar(20) NOT NULL,
PRIMARY KEY (etchat_onlineid)
);
-- limit --
--
-- Daten für Tabelle 'etchat_useronline'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `etchat_config`
--
DROP TABLE IF EXISTS etchat_config;
-- limit --
CREATE TABLE etchat_config (
etchat_config_id int(11) NOT NULL auto_increment,
etchat_config_reloadsequenz int(11) NOT NULL,
etchat_config_messages_im_chat int(11) NOT NULL,
etchat_config_style varchar(100) NOT NULL,
etchat_config_loeschen_nach int(11) NOT NULL,
PRIMARY KEY (etchat_config_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_config'
--
INSERT INTO etchat_config (etchat_config_id, etchat_config_reloadsequenz, etchat_config_messages_im_chat, etchat_config_style, etchat_config_loeschen_nach) VALUES
(1, 4000, 22, 'etchat_white', 1);
Alles anzeigen