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');