1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
|
DROP TABLE IF EXISTS bb1_arcade_session;
CREATE TABLE bb1_arcade_session (
session int(11) NOT NULL default '',
gameid int(11) NOT NULL default '0',
name varchar(50) NOT NULL default '',
userid int(11) NOT NULL default '',
user varchar(20) NOT NULL default '',
score varchar(10) NOT NULL default '',
date text NOT NULL,
KEY session (session)
) TYPE=MyISAM;
DROP TABLE IF EXISTS bb1_arcade_session_aktiv;
CREATE TABLE bb1_arcade_session_aktiv (
gameid int(11) NOT NULL default '0',
name varchar(50) NOT NULL default '',
userid int(11) NOT NULL default '',
user varchar(25) NOT NULL default 'kein',
score varchar(10) NOT NULL default '',
count int(11) NOT NULL default '0',
KEY gameid (gameid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS bb1_arcade_session_sieger;
CREATE TABLE bb1_arcade_session_sieger (
session int(11) NOT NULL default '',
date text NOT NULL,
userid int(11) NOT NULL default '',
user varchar(20) NOT NULL default '',
count char(4) NOT NULL default '',
hit char(2) NOT NULL default ''
) TYPE=MyISAM; |