SQL fejl, i må gerne lige rette min SQL igennem.
Lorteopgave, i know - men er ikke god til SQL, og den siger der er en masse fejl i det her.. så ville høre om der er nogle der orker at rette det igennem?gerne med lidt forklaringer, så jeg kan se hva jeg har gjort galt.
Tak. mvh. Mikael
# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Vært: localhost
# Genereringstidspunkt: 29/11 2003 kl. 11:56:12
# Server version: 3.23.47
# PHP version: 4.1.1
# Database: : `krede`
# --------------------------------------------------------
#
# Struktur dump for tabellen `backup_login`
#
DROP TABLE IF EXISTS backup_login;
CREATE TABLE backup_login (
id int(20) NOT NULL auto_increment,
bruger varchar(16) NOT NULL default '',
ip varchar(16) NOT NULL default '',
dato int(16) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `backup_pass`
#
DROP TABLE IF EXISTS backup_pass;
CREATE TABLE backup_pass (
id int(5) NOT NULL auto_increment,
ip varchar(18) NOT NULL default '',
dato int(16) NOT NULL default '0',
bruger varchar(16) NOT NULL default '',
oldpwd varchar(18) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id_2 (id),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `backup_samleop`
#
DROP TABLE IF EXISTS backup_samleop;
CREATE TABLE backup_samleop (
id int(5) NOT NULL auto_increment,
ting varchar(12) NOT NULL default '',
ip varchar(18) NOT NULL default '',
dato int(16) NOT NULL default '0',
bruger varchar(16) NOT NULL default '',
target varchar(16) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id_2 (id),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `backup_smid`
#
DROP TABLE IF EXISTS backup_smid;
CREATE TABLE backup_smid (
id int(5) NOT NULL auto_increment,
ting varchar(12) NOT NULL default '',
ip varchar(18) NOT NULL default '',
dato int(16) NOT NULL default '0',
bruger varchar(16) NOT NULL default '',
target varchar(16) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id_2 (id),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ban`
#
DROP TABLE IF EXISTS ban;
CREATE TABLE ban (
nr int(4) NOT NULL auto_increment,
navn varchar(16) NOT NULL default '',
bg varchar(16) NOT NULL default 'suite01',
snavn varchar(10) NOT NULL default 'ny suite',
dato varchar(50) NOT NULL default '',
PRIMARY KEY (nr,nr),
FULLTEXT KEY navn (navn)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ban_user`
#
DROP TABLE IF EXISTS ban_user;
CREATE TABLE ban_user (
user varchar(16) NOT NULL default '',
dato varchar(16) NOT NULL default '',
reason varchar(16) NOT NULL default '',
ip varchar(16) NOT NULL default '',
ansat varchar(16) NOT NULL default '',
PRIMARY KEY (user),
FULLTEXT KEY navn (user)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `breve`
#
DROP TABLE IF EXISTS breve;
CREATE TABLE breve (
id int(20) NOT NULL auto_increment,
afsender int(5) NOT NULL default '0',
modtager int(5) NOT NULL default '0',
overskrift varchar(100) NOT NULL default '',
tekst text NOT NULL,
laest char(3) NOT NULL default 'off',
gemt char(3) NOT NULL default 'off',
date int(10) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ht_chat_topic`
#
DROP TABLE IF EXISTS ht_chat_topic;
CREATE TABLE ht_chat_topic (
id int(5) NOT NULL auto_increment,
tekst text NOT NULL,
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ht_fig`
#
DROP TABLE IF EXISTS ht_fig;
CREATE TABLE ht_fig (
id int(11) NOT NULL auto_increment,
bruger varchar(14) NOT NULL default '',
figur varchar(20) NOT NULL default '',
UNIQUE KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ht_online`
#
DROP TABLE IF EXISTS ht_online;
CREATE TABLE ht_online (
id int(5) NOT NULL auto_increment,
logtid int(12) NOT NULL default '0',
rum varchar(14) NOT NULL default 'reception',
felt int(2) NOT NULL default '1',
textid int(1) NOT NULL default '1',
bruger varchar(16) NOT NULL default '',
stener varchar(16) NOT NULL default '',
suite char(3) NOT NULL default 'off',
ip varchar(15) NOT NULL default '',
onlinetid int(10) NOT NULL default '0',
browser tinytext NOT NULL,
PRIMARY KEY (bruger),
UNIQUE KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `ht_ting`
#
DROP TABLE IF EXISTS ht_ting;
CREATE TABLE ht_ting (
id int(3) NOT NULL auto_increment,
ejer varchar(16) NOT NULL default '',
ting varchar(16) NOT NULL default '',
værdi int(5) NOT NULL default '0',
rum varchar(16) NOT NULL default '',
felt int(2) NOT NULL default '1',
status int(1) NOT NULL default '0',
link varchar(150) NOT NULL default '',
PRIMARY KEY (id),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `kon`
#
DROP TABLE IF EXISTS kon;
CREATE TABLE kon (
id int(5) NOT NULL auto_increment,
tekst text NOT NULL,
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `konto`
#
DROP TABLE IF EXISTS konto;
CREATE TABLE konto (
id int(10) NOT NULL auto_increment,
bruger varchar(14) NOT NULL default '',
target varchar(14) NOT NULL default '',
forklaring tinytext NOT NULL,
sum varchar(15) NOT NULL default '0',
betalingsdato int(12) NOT NULL default '0',
status int(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `locked`
#
DROP TABLE IF EXISTS locked;
CREATE TABLE locked (
id int(25) NOT NULL auto_increment,
rum varchar(16) NOT NULL default '',
felt int(2) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `login`
#
DROP TABLE IF EXISTS login;
CREATE TABLE login (
id int(20) NOT NULL auto_increment,
user longtext NOT NULL,
pass longtext NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `news`
#
DROP TABLE IF EXISTS news;
CREATE TABLE news (
nyhed text NOT NULL,
ovrskrft varchar(249) NOT NULL default '',
id int(1) NOT NULL default '0',
img varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `newsletter`
#
DROP TABLE IF EXISTS newsletter;
CREATE TABLE newsletter (
id int(5) NOT NULL auto_increment,
bruger varchar(12) NOT NULL default '',
email varchar(250) NOT NULL default '',
made int(10) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `rum`
#
DROP TABLE IF EXISTS rum;
CREATE TABLE rum (
navn varchar(20) NOT NULL default '',
samleop char(2) NOT NULL default '',
access int(11) NOT NULL default '40',
secret char(2) NOT NULL default 'no',
bg varchar(15) NOT NULL default '',
nr int(3) NOT NULL default '0',
info varchar(255) NOT NULL default '',
PRIMARY KEY (navn),
KEY navn_2 (navn)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `stats_rum`
#
DROP TABLE IF EXISTS stats_rum;
CREATE TABLE stats_rum (
id int(10) NOT NULL auto_increment,
bruger varchar(16) NOT NULL default '',
dato int(10) NOT NULL default '0',
rum varchar(20) NOT NULL default '',
suite varchar(20) NOT NULL default '',
sesid int(3) NOT NULL default '0',
PRIMARY KEY (id),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `suites`
#
DROP TABLE IF EXISTS suites;
CREATE TABLE suites (
nr int(4) NOT NULL auto_increment,
navn varchar(16) NOT NULL default '',
bg varchar(16) NOT NULL default 'suite01',
snavn varchar(10) NOT NULL default 'ny suite',
dato varchar(50) NOT NULL default '',
PRIMARY KEY (nr,nr),
FULLTEXT KEY navn (navn)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `sw`
#
DROP TABLE IF EXISTS sw;
CREATE TABLE sw (
id int(5) NOT NULL auto_increment,
username varchar(16) NOT NULL default '',
password varchar(32) NOT NULL default '0',
mastercode varchar(32) NOT NULL default '0',
online int(50) NOT NULL default '0',
ecu int(15) NOT NULL default '0',
oldonline int(15) NOT NULL default '0',
oldecu int(15) NOT NULL default '0',
oldpass varchar(32) NOT NULL default '',
lastonline int(10) NOT NULL default '0',
opr int(10) NOT NULL default '0',
figur varchar(20) NOT NULL default '',
color varchar(6) NOT NULL default 'FFFFF',
sex varchar(7) NOT NULL default 'male',
refresh int(1) NOT NULL default '0',
admin int(2) NOT NULL default '0',
age varchar(35) NOT NULL default '',
mobile int(8) NOT NULL default '0',
icq int(12) NOT NULL default '0',
realname varchar(35) NOT NULL default '',
city varchar(35) NOT NULL default '',
picture varchar(150) NOT NULL default '',
email varchar(100) NOT NULL default '',
homepage varchar(150) NOT NULL default '',
info longtext NOT NULL,
PRIMARY KEY (id,id),
UNIQUE KEY id_2 (id),
KEY username_2 (username),
KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `tekst`
#
DROP TABLE IF EXISTS tekst;
CREATE TABLE tekst (
id int(10) NOT NULL auto_increment,
bruger varchar(14) NOT NULL default '',
tekst varchar(254) NOT NULL default '',
privat varchar(14) NOT NULL default '0',
action int(1) default NULL,
rum varchar(18) NOT NULL default '',
dato int(10) NOT NULL default '0',
suite char(3) NOT NULL default '',
PRIMARY KEY (id),
KEY tekst (tekst),
KEY rum (rum),
KEY dato (dato)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `venneliste`
#
DROP TABLE IF EXISTS venneliste;
CREATE TABLE venneliste (
id int(20) NOT NULL auto_increment,
bruger varchar(14) NOT NULL default '',
ven varchar(14) NOT NULL default '',
gruppe varchar(25) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `venner`
#
DROP TABLE IF EXISTS venner;
CREATE TABLE venner (
id int(4) unsigned NOT NULL auto_increment,
ven varchar(20) NOT NULL default '',
ejer varchar(20) NOT NULL default '',
PRIMARY KEY (id,id)
) TYPE=MyISAM;
