Nogen her som kan se fejlen i denne DB?
# phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Vært: localhost
# Genereringstidspunkt: 30/10 2002 kl. 19:57:40
# Server version: 3.23.52
# PHP version: 4.2.3
# Database: : `test`
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3`
#
CREATE TABLE minichat3 (
id int(4) unsigned NOT NULL auto_increment,
nick varchar(20) NOT NULL default '',
pass varchar(20) NOT NULL default '',
status int(1) NOT NULL default '1',
onlinetid int(15) NOT NULL default '0',
credits int(4) NOT NULL default '0',
chatlines int(5) NOT NULL default '0',
age char(2) NOT NULL default '',
email varchar(40) NOT NULL default '',
free_text longtext NOT NULL,
PRIMARY KEY (id,id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3`
#
INSERT INTO minichat3 VALUES (1, 'admin', 'admin', 3, 0, 0, 0, '', '', 'I am the Chat-Administrator');
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_banlist`
#
CREATE TABLE minichat3_banlist (
id int(2) unsigned NOT NULL auto_increment,
nick varchar(20) NOT NULL default '',
datetime datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar(15) NOT NULL default '',
banby varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_banlist`
#
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_forbidden_nicks`
#
CREATE TABLE minichat3_forbidden_nicks (
id int(4) unsigned NOT NULL auto_increment,
nick varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_forbidden_nicks`
#
INSERT INTO minichat3_forbidden_nicks VALUES (1, 'System');
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_givecredits`
#
CREATE TABLE minichat3_givecredits (
id int(20) unsigned NOT NULL auto_increment,
takefrom int(4) NOT NULL default '0',
amount int(20) NOT NULL default '0',
giveto int(4) NOT NULL default '0',
datetime datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_givecredits`
#
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_rooms`
#
CREATE TABLE minichat3_rooms (
id int(2) unsigned NOT NULL auto_increment,
navn varchar(25) NOT NULL default '',
emne varchar(50) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_rooms`
#
INSERT INTO minichat3_rooms VALUES (1, 'Playground', '1234567890');
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_sessions`
#
CREATE TABLE minichat3_sessions (
id varchar(50) NOT NULL default '',
sesid varchar(100) NOT NULL default '',
nick varchar(20) NOT NULL default '',
org_nick varchar(20) NOT NULL default '',
status int(1) NOT NULL default '0',
room int(1) NOT NULL default '1',
ip varchar(15) NOT NULL default '',
ignore_list longtext NOT NULL,
mode varchar(6) NOT NULL default 'normal',
mute int(1) NOT NULL default '0',
name_color varchar(7) NOT NULL default '#000000',
text_color varchar(7) NOT NULL default '#000000',
lastaction int(15) NOT NULL default '0',
logintime int(15) NOT NULL default '0',
chatlines int(5) NOT NULL default '0',
uid int(4) NOT NULL default '0',
kicktype int(1) NOT NULL default '0',
kicktime int(15) NOT NULL default '0',
kickby varchar(20) NOT NULL default '',
kicktext varchar(255) NOT NULL default 'No reason given'
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_sessions`
#
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_setup`
#
CREATE TABLE minichat3_setup (
id int(2) unsigned NOT NULL auto_increment,
thing varchar(20) NOT NULL default '',
value varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_setup`
#
INSERT INTO minichat3_setup VALUES (1, 'credits', '1');
INSERT INTO minichat3_setup VALUES (2, 'credits_time', '1');
INSERT INTO minichat3_setup VALUES (3, 'history', '1');
INSERT INTO minichat3_setup VALUES (4, 'language', 'dk');
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_txt_1`
#
CREATE TABLE minichat3_txt_1 (
id int(10) unsigned NOT NULL auto_increment,
fra varchar(20) NOT NULL default '',
fra_id varchar(50) NOT NULL default '',
til varchar(20) NOT NULL default '',
name_color varchar(7) NOT NULL default '#000000',
text_color varchar(7) NOT NULL default '#000000',
msg varchar(255) NOT NULL default '',
type int(1) NOT NULL default '0',
time time NOT NULL default '00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_txt_1`
#
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_vote_ses`
#
CREATE TABLE minichat3_vote_ses (
id int(4) unsigned NOT NULL auto_increment,
spm varchar(255) NOT NULL default '',
vote1 varchar(40) NOT NULL default '',
vote2 varchar(40) NOT NULL default '',
vote3 varchar(40) NOT NULL default '',
open int(1) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_vote_ses`
#
INSERT INTO minichat3_vote_ses VALUES (1, 'Hvad synes du om chatten?', 'God', 'Ved ikke', 'Dårlig', 1);
# --------------------------------------------------------
#
# Struktur dump for tabellen `minichat3_votes`
#
CREATE TABLE minichat3_votes (
id int(10) unsigned NOT NULL auto_increment,
voteid int(4) NOT NULL default '0',
vote int(1) NOT NULL default '0',
user int(4) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Data dump for tabellen `minichat3_votes`
#