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:
|
CREATE TABLE `bb1_arcadegames` (
`gameid` int(11) NOT NULL auto_increment,
`name` varchar(50) collate latin1_german1_ci NOT NULL default '',
`title` varchar(50) collate latin1_german1_ci NOT NULL default '',
`description` mediumtext collate latin1_german1_ci NOT NULL,
`filename` varchar(50) collate latin1_german1_ci NOT NULL default '',
`thumbnailname` varchar(100) collate latin1_german1_ci NOT NULL default '',
`thumbnaildata` mediumblob NOT NULL,
`active` smallint(1) NOT NULL default '0',
`championactive` tinyint(4) NOT NULL default '0',
`championid` int(11) NOT NULL default '0',
`championtext` varchar(255) collate latin1_german1_ci NOT NULL default '',
`championcolor` varchar(50) collate latin1_german1_ci NOT NULL default '',
`scorevar` varchar(50) collate latin1_german1_ci NOT NULL default '',
`width` int(11) NOT NULL default '0',
`height` int(11) NOT NULL default '0',
`codebase` mediumtext collate latin1_german1_ci NOT NULL,
`querystring` mediumtext collate latin1_german1_ci NOT NULL,
`objectparam` mediumtext collate latin1_german1_ci NOT NULL,
`embedparam` mediumtext collate latin1_german1_ci NOT NULL,
`hit` int(11) NOT NULL default '0',
`hit_session` int(11) NOT NULL default '0',
`datum` int(11) NOT NULL default '0',
`gut_fest` int(11) NOT NULL default '0',
`gut_dyn` int(11) NOT NULL default '0',
`bezahl_fest` int(11) NOT NULL default '0',
`bezahl_dyn` int(11) NOT NULL default '0',
`ov18` int(11) NOT NULL default '0',
`kat` int(11) NOT NULL default '1',
`bewertcount` int(11) NOT NULL default '0',
`bewertung` int(11) NOT NULL default '0',
`u_group` int(11) NOT NULL default '0',
`ibprovalue` int(11) NOT NULL default '0',
`rev_score` smallint(1) NOT NULL default '0',
PRIMARY KEY (`gameid`),
FULLTEXT KEY `thumbnailname` (`thumbnailname`)
) ENGINE=MyISAM AUTO_INCREMENT=4495 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
|