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:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
|
CREATE TABLE `bbx_burg_config` (
`id_config` int(5) NOT NULL default '0',
`value` varchar(150) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id_config`)
) TYPE=MyISAM;
CREATE TABLE `bbx_burg_fragen` (
`id_fragen` int(12) NOT NULL auto_increment,
`auto_stufe` int(5) NOT NULL default '0',
`desc_frage` mediumtext NOT NULL,
`desc_answer` varchar(100) NOT NULL default '',
`desc_bild` varchar(250) NOT NULL default '',
PRIMARY KEY (`id_fragen`)
) TYPE=MyISAM ;
CREATE TABLE `bbx_burg_player` (
`id_player` int(12) NOT NULL auto_increment,
`userid` int(12) NOT NULL default '0',
`auto_stufe` int(5) NOT NULL default '0',
`id_fragen` int(5) NOT NULL default '0',
`time_1` int(15) NOT NULL default '0',
`time_2` int(15) NOT NULL default '0',
`versuche` int(10) NOT NULL default '0',
`time_start` int(15) NOT NULL default '0',
`time_end` int(15) NOT NULL default '0',
`stufen_text` mediumtext NOT NULL,
`last_time` int(15) NOT NULL default '0',
`count_stufe` int(3) NOT NULL default '0',
PRIMARY KEY (`id_player`)
) TYPE=MyISAM ;
CREATE TABLE `bbx_burg_sponsoren` (
`id_sponsor` int(8) NOT NULL auto_increment,
`desc_banner` varchar(150) NOT NULL default '',
`desc_name` varchar(120) NOT NULL default '',
`desc_url` varchar(250) NOT NULL default '',
`desc_link` text NOT NULL,
`desc_banner_url` varchar(250) NOT NULL default '',
`banner_views` int(8) NOT NULL default '0',
PRIMARY KEY (`id_sponsor`)
) TYPE=MyISAM ;
CREATE TABLE `bbx_burg_start` (
`id_start` int(5) NOT NULL auto_increment,
`start_stufen` text NOT NULL,
`start_stufen_order` text NOT NULL,
`start_sponsoren` text NOT NULL,
`start_fragen` text NOT NULL,
`start_in` int(5) NOT NULL default '0',
`start_ende` int(5) NOT NULL default '30',
`post_in` int(5) NOT NULL default '0',
`time_out` int(5) NOT NULL default '0',
`time_between` int(5) NOT NULL default '0',
`auto_gewinn` tinyint(1) NOT NULL default '0',
`anz_gewinner` int(3) NOT NULL default '0',
`desc_gewinne` text NOT NULL,
`desc_volltext` text NOT NULL,
`auto_kommentar` tinyint(1) NOT NULL default '0',
`time_now` int(15) NOT NULL default '0',
PRIMARY KEY (`id_start`)
) TYPE=MyISAM ;
CREATE TABLE `bbx_burg_stufen` (
`auto_stufe` mediumint(5) NOT NULL auto_increment,
`desc_stufe` varchar(150) NOT NULL default '',
`preis_stufe` int(10) NOT NULL default '0',
PRIMARY KEY (`auto_stufe`)
) TYPE=MyISAM ;
REPLACE INTO `bbx_burg_config` (`id_config`, `value`, `name`) VALUES (101, '0', 'raetselburgid');
|