Hvad er mysql dumb
Hej.. jeg har fået et mysql dumb som jeg skal bruge til min chat..?Men jeg ved ikek hvad man gør med et mysql dumb, skal man sætte det ind i databasen.. ind i en fil eller hvad? Jeg er virkelig på bar bund.. mysql = mig = newbie...?
Hvad skal jeg gøre med den:
CREATE TABLE chat (
id int(6) NOT NULL auto_increment,
text text NOT NULL,
script varchar(100) NOT NULL default '',
rum int(4) NOT NULL default '0',
time int(10) NOT NULL default '0',
f int(5) NOT NULL default '0',
t int(5) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
CREATE TABLE dagensprofil (
id varchar(8) NOT NULL default '',
data varchar(15) NOT NULL default ''
) TYPE=MyISAM;
CREATE TABLE felter (
rum int(4) NOT NULL default '0',
x int(3) NOT NULL default '0',
y int(3) NOT NULL default '0',
status varchar(6) NOT NULL default '0',
value varchar(150) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE konkurence (
id int(5) NOT NULL default '0',
kast int(1) NOT NULL default '0',
point int(4) NOT NULL default '0',
day char(3) NOT NULL default ''
) TYPE=MyISAM;
CREATE TABLE post (
id int(5) NOT NULL auto_increment,
afsendt int(10) NOT NULL default '0',
emne varchar(30) NOT NULL default '0',
text text NOT NULL,
modtager int(5) NOT NULL default '0',
afsender int(5) NOT NULL default '0',
status int(1) NOT NULL default '0',
smiley varchar(10) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
CREATE TABLE ting (
id int(5) NOT NULL auto_increment,
tingname varchar(50) NOT NULL default '',
figur varchar(30) NOT NULL default '0',
value varchar(4) NOT NULL default '0',
rum int(4) NOT NULL default '0',
x int(3) NOT NULL default '0',
y int(3) NOT NULL default '0',
owner varchar(20) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
CREATE TABLE urls (
id int(5) NOT NULL auto_increment,
url varchar(250) NOT NULL default '',
hits tinyint(6) NOT NULL default '1',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
CREATE TABLE users (
id int(5) NOT NULL auto_increment,
username varchar(15) NOT NULL default '',
kryppassword varchar(32) NOT NULL default '',
x int(3) NOT NULL default '0',
y int(3) NOT NULL default '0',
spir decimal(19,15) NOT NULL default '0.000000000000000',
onlinetid int(10) NOT NULL default '0',
onlinechat int(10) NOT NULL default '0',
logins int(4) NOT NULL default '0',
figur varchar(120) NOT NULL default '',
room int(4) NOT NULL default '0',
roomname varchar(50) NOT NULL default '',
roombg varchar(15) NOT NULL default '#A0BEBF',
roombgpic varchar(50) NOT NULL default '',
roommax int(2) NOT NULL default '0',
roomlukind enum('ja','nej') NOT NULL default 'ja',
roomstatus tinyint(1) NOT NULL default '0',
usernamecolor varchar(30) NOT NULL default '',
rum int(4) NOT NULL default '0',
status tinyint(1) NOT NULL default '0',
alder int(2) NOT NULL default '0',
email varchar(50) NOT NULL default '',
sex char(3) NOT NULL default '',
answer int(10) NOT NULL default '0',
emote varchar(15) NOT NULL default '',
startfrom int(6) NOT NULL default '0',
botmes varchar(200) NOT NULL default '',
roomvisits int(4) NOT NULL default '0',
oprettet int(10) NOT NULL default '0',
fisk int(3) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id,username)
) TYPE=MyISAM;
INSERT INTO users VALUES (1, 'System1', 'fgkij', 0, 0, '0.000000000000000', 0, 1, 0, 'voksen-han-1.gif', 1, 'Receptionen', '#A0BEBF', 'receptionen.jpg', 45, 'ja', 0, 'white', 0, 0, 0, '', 'han', 0, '', 0, '', 45, 0, 0);
INSERT INTO users VALUES (2, 'System2', 'fgkij', 0, 0, '0.000000000000000', 0, 1, 0, 'voksen-han-1.gif', 10, 'Butikken', '#A0BEBF', 'butikken.jpg', 25, 'ja', 1, '', 0, 0, 0, '', 'han', 0, '', 0, '', 18, 0, 0);
INSERT INTO users VALUES (3, 'System3', '321df654', 0, 0, '0.000000000000000', 0, 1, 0, '', 2, 'Pool', '#A0BEBF', 'pool.jpg', 45, 'ja', 0, '', 0, 0, 0, '', '', 0, '', 0, '', 56, 0, 0);
INSERT INTO users VALUES (4, 'System4', '54dgf345', 0, 0, '0.000000000000000', 0, 1, 0, '', 3, 'Debatrum', '#A0BEBF', 'debatrum.jpg', 45, 'ja', 0, '', 0, 0, 0, '', '', 0, '', 0, '', 7, 0, 0);
INSERT INTO users VALUES (5, 'System5', '3d24gfd65', 0, 0, '0.000000000000000', 0, 1, 0, '', 4, 'Stener', '#A0BEBF', 'stener.jpg', 45, 'ja', 0, '', 0, 0, 0, '', '', 0, '', 0, '', 8, 0, 0);
INSERT INTO users VALUES (6, 'System6', '324654', 0, 0, '0.000000000000000', 0, 1, 0, '', 5, 'Fængsel', '#A0BEBF', 'jail.jpg', 45, 'ja', 0, '', 0, 0, 0, '', '', 0, '', 0, '', 11, 0, 0);
