HeadShot Extreme :: View topic - Fresh Arcade install

Code: [ Select all ]
--
-- Table structure for table `nuke_bbarcade`
--

CREATE TABLE `nuke_bbarcade` (
  `arcade_name` varchar(255) NOT NULL default '',
  `arcade_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`arcade_name`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_bbarcade`
--

INSERT INTO `nuke_bbarcade` VALUES('use_category_mod', '1');
INSERT INTO `nuke_bbarcade` VALUES('category_preview_games', '5');
INSERT INTO `nuke_bbarcade` VALUES('games_par_page', '15');
INSERT INTO `nuke_bbarcade` VALUES('game_order', 'Alpha');
INSERT INTO `nuke_bbarcade` VALUES('display_winner_avatar', '1');
INSERT INTO `nuke_bbarcade` VALUES('stat_par_page', '10');
INSERT INTO `nuke_bbarcade` VALUES('winner_avatar_position', 'left');
INSERT INTO `nuke_bbarcade` VALUES('maxsize_avatar', '200');
INSERT INTO `nuke_bbarcade` VALUES('linkcat_align', '2');
INSERT INTO `nuke_bbarcade` VALUES('limit_by_posts', '0');
INSERT INTO `nuke_bbarcade` VALUES('posts_needed', '5');
INSERT INTO `nuke_bbarcade` VALUES('days_limit', '5');
INSERT INTO `nuke_bbarcade` VALUES('limit_type', 'date');
INSERT INTO `nuke_bbarcade` VALUES('use_fav_category', '1');
INSERT INTO `nuke_bbarcade` VALUES('arcade_announcement', 'Welcome to the Arcade!<br />Enjoy!');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbarcade_categories`
--

CREATE TABLE `nuke_bbarcade_categories` (
  `arcade_catid` mediumint(8) unsigned NOT NULL auto_increment,
  `arcade_cattitle` varchar(100) NOT NULL default '',
  `arcade_nbelmt` mediumint(8) unsigned NOT NULL default '0',
  `arcade_catorder` mediumint(8) unsigned NOT NULL default '0',
  `arcade_catauth` tinyint(2) NOT NULL,
  KEY `arcade_catid` (`arcade_catid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `nuke_bbarcade_categories`
--

INSERT INTO `nuke_bbarcade_categories` VALUES(1, 'Arcade', 1, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbarcade_comments`
--

CREATE TABLE `nuke_bbarcade_comments` (
  `game_id` mediumint(8) NOT NULL default '0',
  `comments_value` varchar(255) NOT NULL default ''
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_bbarcade_comments`
--

INSERT INTO `nuke_bbarcade_comments` VALUES(1, '');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbarcade_fav`
--

CREATE TABLE `nuke_bbarcade_fav` (
  `order` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `game_id` mediumint(8) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_bbarcade_fav`
--


-- --------------------------------------------------------