phpBB.de

Code: Alles auswählen

CREATE TABLE `phpbb_ina_games` (
							`game_id` mediumint(9) NOT NULL auto_increment, 
							`cat_id` mediumint(8) default NULL,
							`game_name` varchar(25) default NULL, 
							`game_path` varchar(255) default NULL, 
							`image_path` varchar(255) default NULL, 
							`game_desc` varchar(255) default NULL, 
							`game_charge` int(11) unsigned default '0', 
							`game_reward` int(11) unsigned NOT NULL default '0', 
							`game_bonus` smallint(5) unsigned default '0', 
					`at_game_bonus` smallint(5) default '0',
							`game_use_gl` tinyint(3) unsigned default '0', 
							`game_flash` tinyint(1) unsigned NOT NULL default '0', 
							`game_show_score` tinyint(1) NOT NULL default '1',
							`game_avail` tinyint(1) unsigned default '1',
							`allow_guest` tinyint(1) unsigned default '0', 
							`win_width` smallint(6) NOT NULL default '0', 
							`win_height` smallint(6) NOT NULL default '0', 
							`highscore_limit` int(11) default NULL, 
					`at_highscore_limit` int(10) default '0',
 							`reverse_list` tinyint(1) NOT NULL default '0', 
							`played` int(10) unsigned NOT NULL default '0', 
							`instructions` text,
					`score_type` smallint(1) default NULL,
							PRIMARY KEY  (`game_id`));