CREATE TABLE `smf_arcade_categories` (
  `id_cat` int(10) UNSIGNED NOT NULL,
  `cat_name` varchar(191) DEFAULT '',
  `num_games` int(10) UNSIGNED DEFAULT 0,
  `cat_order` int(10) UNSIGNED DEFAULT 1,
  `special` int(10) UNSIGNED DEFAULT 0,
  `member_groups` varchar(191) DEFAULT '-2,-1,0,2',
  `cat_icon` varchar(191) DEFAULT '',
  `cat_dl` int(10) UNSIGNED DEFAULT 0,
  `cat_js` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `smf_arcade_categories`
--

INSERT INTO `smf_arcade_categories` (`id_cat`, `cat_name`, `num_games`, `cat_order`, `special`, `member_groups`, `cat_icon`, `cat_dl`, `cat_js`) VALUES
(1, 'Default', 0, 1, 0, '-2,-1,0,1,2', 'Default.gif', 0, 0);

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

--
-- Table structure for table `smf_arcade_favorite`
--

CREATE TABLE `smf_arcade_favorite` (
  `id_favorite` int(10) UNSIGNED NOT NULL,
  `id_member` int(10) UNSIGNED DEFAULT NULL,
  `id_game` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_files`
--

CREATE TABLE `smf_arcade_files` (
  `id_file` int(10) UNSIGNED NOT NULL,
  `id_game` int(10) UNSIGNED DEFAULT NULL,
  `file_type` varchar(191) DEFAULT 'game',
  `game_name` varchar(191) DEFAULT '',
  `status` int(10) UNSIGNED DEFAULT 0,
  `game_file` varchar(191) DEFAULT '',
  `game_directory` varchar(191) DEFAULT '',
  `submit_system` varchar(191) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_games`
--

CREATE TABLE `smf_arcade_games` (
  `id_game` int(10) UNSIGNED NOT NULL,
  `internal_name` varchar(191) DEFAULT '',
  `game_name` varchar(191) DEFAULT '',
  `game_file` varchar(191) DEFAULT '',
  `game_directory` varchar(191) DEFAULT '',
  `description` text DEFAULT NULL,
  `help` text DEFAULT NULL,
  `thumbnail` varchar(191) DEFAULT '',
  `thumbnail_small` varchar(191) DEFAULT '',
  `submit_system` varchar(191) DEFAULT '',
  `id_cat` int(10) UNSIGNED DEFAULT 0,
  `enabled` int(10) UNSIGNED DEFAULT 0,
  `download` int(10) UNSIGNED DEFAULT 1,
  `local_permissions` int(10) UNSIGNED DEFAULT 0,
  `score_type` tinyint(3) UNSIGNED DEFAULT 0,
  `js_insertion` tinyint(1) UNSIGNED DEFAULT 2,
  `member_groups` varchar(191) DEFAULT '-2,-1,0,2',
  `game_rating` float DEFAULT 0,
  `id_champion` int(10) UNSIGNED DEFAULT 0,
  `id_champion_score` int(10) UNSIGNED DEFAULT 0,
  `extra_data` text DEFAULT NULL,
  `num_plays` int(10) UNSIGNED DEFAULT 0,
  `num_rates` int(10) UNSIGNED DEFAULT 0,
  `num_favorites` int(10) UNSIGNED DEFAULT 0,
  `id_topic` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_game_info`
--

CREATE TABLE `smf_arcade_game_info` (
  `id_game` int(10) NOT NULL,
  `icon_position` int(10) DEFAULT 0,
  `icon_position_hide` int(10) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_guest_data`
--

CREATE TABLE `smf_arcade_guest_data` (
  `online_ip` varchar(191) NOT NULL DEFAULT '',
  `online_time` int(10) UNSIGNED DEFAULT 0,
  `show_online` int(10) UNSIGNED DEFAULT 1,
  `current_action` int(10) UNSIGNED DEFAULT 0,
  `current_game` int(10) UNSIGNED DEFAULT 0,
  `temp_name` varchar(191) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_guest_extra_data`
--

CREATE TABLE `smf_arcade_guest_extra_data` (
  `online_ip` varchar(191) NOT NULL DEFAULT '',
  `year` int(10) UNSIGNED DEFAULT 0,
  `day` int(10) UNSIGNED DEFAULT 0,
  `count` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_internal_gamedata`
--

CREATE TABLE `smf_arcade_internal_gamedata` (
  `id_conflict` int(10) UNSIGNED NOT NULL,
  `id_game` int(10) DEFAULT NULL,
  `internal_id_conflict` int(10) DEFAULT NULL,
  `internal_name_conflict` varchar(191) DEFAULT '',
  `conflict_directory` varchar(191) DEFAULT '',
  `submit_system_flag` int(10) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_internal_game_conflicts`
--

CREATE TABLE `smf_arcade_internal_game_conflicts` (
  `id_conflict` int(10) UNSIGNED NOT NULL,
  `id_game` int(10) DEFAULT NULL,
  `internal_id_conflict` int(10) DEFAULT NULL,
  `internal_name_conflict` varchar(191) DEFAULT '',
  `conflict_directory` varchar(191) DEFAULT '',
  `submit_system_flag` int(10) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_lists`
--

CREATE TABLE `smf_arcade_lists` (
  `id_list` int(11) NOT NULL,
  `list_name` varchar(191) NOT NULL,
  `list_source_file` varchar(191) NOT NULL,
  `list_function` varchar(191) NOT NULL,
  `list_template` varchar(191) NOT NULL,
  `enabled` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `smf_arcade_lists`
--

INSERT INTO `smf_arcade_lists` (`id_list`, `list_name`, `list_source_file`, `list_function`, `list_template`, `enabled`) VALUES
(1, 'Retro', '', '', 'ArcadeSkinListB', 1),
(2, 'Vintage', '', '', 'ArcadeSkinListA', 1),
(3, 'Generic', '', '', 'ArcadeList', 1);

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

--
-- Table structure for table `smf_arcade_matches`
--

CREATE TABLE `smf_arcade_matches` (
  `id_match` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT '',
  `id_member` int(10) UNSIGNED DEFAULT 0,
  `private_game` int(10) UNSIGNED DEFAULT 0,
  `status` int(10) UNSIGNED DEFAULT 0,
  `created` int(10) UNSIGNED DEFAULT 0,
  `updated` int(10) UNSIGNED DEFAULT 0,
  `num_players` int(10) UNSIGNED DEFAULT 2,
  `current_players` int(10) UNSIGNED DEFAULT 1,
  `num_rounds` int(10) UNSIGNED DEFAULT 1,
  `current_round` int(10) UNSIGNED DEFAULT 0,
  `match_data` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_matches_players`
--

CREATE TABLE `smf_arcade_matches_players` (
  `id_match` int(10) UNSIGNED NOT NULL,
  `id_member` int(10) UNSIGNED NOT NULL,
  `status` int(10) UNSIGNED DEFAULT 0,
  `score` int(10) UNSIGNED DEFAULT 0,
  `player_data` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_matches_results`
--

CREATE TABLE `smf_arcade_matches_results` (
  `id_match` int(10) UNSIGNED NOT NULL,
  `id_member` int(10) UNSIGNED NOT NULL,
  `round` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `score` float DEFAULT 0,
  `duration` float DEFAULT NULL,
  `end_time` int(10) UNSIGNED DEFAULT 0,
  `score_status` varchar(191) DEFAULT '',
  `validate_hash` varchar(191) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_matches_rounds`
--

CREATE TABLE `smf_arcade_matches_rounds` (
  `id_match` int(10) UNSIGNED NOT NULL,
  `round` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `id_game` int(10) UNSIGNED DEFAULT NULL,
  `status` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_membergroups`
--

CREATE TABLE `smf_arcade_membergroups` (
  `id_group` int(11) NOT NULL DEFAULT -2,
  `download_limit` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_members`
--

CREATE TABLE `smf_arcade_members` (
  `id_member` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `arena_invite` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `arena_match_end` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `arena_new_round` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `new_game` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `champion_email` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `champion_pm` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `notify_game_reports` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `games_per_page` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `archive_type` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `arcade_gametype` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `new_champion_any` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `new_champion_own` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `scores_per_page` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `skin` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `list` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `skin_mobile` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `list_mobile` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `detect_mobile` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `download_count` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_member_data`
--

CREATE TABLE `smf_arcade_member_data` (
  `id_member` int(10) UNSIGNED NOT NULL,
  `online_ip` varchar(191) DEFAULT '',
  `online_time` int(10) UNSIGNED DEFAULT 0,
  `show_online` int(10) UNSIGNED DEFAULT 0,
  `online_name` varchar(191) DEFAULT '',
  `online_color` varchar(191) DEFAULT '',
  `current_action` int(10) UNSIGNED DEFAULT 0,
  `current_game` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_mobile_lists`
--

CREATE TABLE `smf_arcade_mobile_lists` (
  `id_list` int(11) NOT NULL,
  `list_name` varchar(191) NOT NULL,
  `list_source_file` varchar(191) NOT NULL,
  `list_function` varchar(191) NOT NULL,
  `list_template` varchar(191) NOT NULL,
  `enabled` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `smf_arcade_mobile_lists`
--

INSERT INTO `smf_arcade_mobile_lists` (`id_list`, `list_name`, `list_source_file`, `list_function`, `list_template`, `enabled`) VALUES
(1, 'Generic Mobile', '', '', 'ArcadeSkinListMobileA', 1);

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

--
-- Table structure for table `smf_arcade_mobile_skins`
--

CREATE TABLE `smf_arcade_mobile_skins` (
  `id_skin` int(11) NOT NULL,
  `skin_name` varchar(191) NOT NULL,
  `skin_source_file` varchar(191) NOT NULL,
  `skin_function` varchar(191) NOT NULL,
  `admin_function` varchar(191) NOT NULL,
  `skin_template` varchar(191) NOT NULL,
  `enabled` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `smf_arcade_mobile_skins`
--

INSERT INTO `smf_arcade_mobile_skins` (`id_skin`, `skin_name`, `skin_source_file`, `skin_function`, `admin_function`, `skin_template`, `enabled`) VALUES
(1, 'Generic Mobile', '', '', '', 'ArcadeSkinMobileA', 1);

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

--
-- Table structure for table `smf_arcade_newshouts`
--

CREATE TABLE `smf_arcade_newshouts` (
  `id_shout` int(11) NOT NULL,
  `id_member` int(11) NOT NULL,
  `content` varchar(191) NOT NULL,
  `time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_pdl1`
--

CREATE TABLE `smf_arcade_pdl1` (
  `id_member` int(10) UNSIGNED NOT NULL,
  `count` int(10) UNSIGNED DEFAULT NULL,
  `year` varchar(255) DEFAULT '',
  `day` varchar(255) DEFAULT '',
  `latest_year` varchar(255) DEFAULT '',
  `latest_day` varchar(255) DEFAULT '',
  `permission` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_pdl2`
--

CREATE TABLE `smf_arcade_pdl2` (
  `pdl_gameid` int(10) UNSIGNED NOT NULL,
  `game_name` varchar(255) DEFAULT '',
  `report_day` varchar(255) DEFAULT '',
  `report_year` varchar(255) DEFAULT '',
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `report_id` int(10) UNSIGNED DEFAULT NULL,
  `report_reason` varchar(191) DEFAULT '',
  `download_count` int(10) UNSIGNED DEFAULT NULL,
  `download_disable` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_rates`
--

CREATE TABLE `smf_arcade_rates` (
  `id_member` int(10) UNSIGNED NOT NULL,
  `id_game` int(10) UNSIGNED NOT NULL,
  `rating` int(10) UNSIGNED DEFAULT 0,
  `rate_time` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_scores`
--

CREATE TABLE `smf_arcade_scores` (
  `id_score` int(10) UNSIGNED NOT NULL,
  `id_game` int(10) UNSIGNED DEFAULT NULL,
  `id_member` int(10) UNSIGNED DEFAULT NULL,
  `score` float DEFAULT NULL,
  `duration` float DEFAULT NULL,
  `end_time` int(10) UNSIGNED DEFAULT NULL,
  `champion_from` int(10) UNSIGNED DEFAULT 0,
  `champion_to` int(10) UNSIGNED DEFAULT 0,
  `position` int(10) UNSIGNED DEFAULT 0,
  `personal_best` tinyint(3) UNSIGNED DEFAULT 0,
  `score_status` varchar(191) DEFAULT '',
  `member_ip` varchar(191) DEFAULT '',
  `player_name` varchar(191) DEFAULT '',
  `comment` varchar(191) DEFAULT '',
  `validate_hash` varchar(191) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `smf_arcade_skins`
--

CREATE TABLE `smf_arcade_skins` (
  `id_skin` int(11) NOT NULL,
  `skin_name` varchar(191) NOT NULL,
  `skin_source_file` varchar(191) NOT NULL,
  `skin_function` varchar(191) NOT NULL,
  `admin_function` varchar(191) NOT NULL,
  `skin_template` varchar(191) NOT NULL,
  `enabled` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `smf_arcade_skins`
--

INSERT INTO `smf_arcade_skins` (`id_skin`, `skin_name`, `skin_source_file`, `skin_function`, `admin_function`, `skin_template`, `enabled`) VALUES
(1, 'Enterprise-C', 'Subs-ArcadeSkinC.php', '', '', 'ArcadeSkinC', 1),
(2, 'Defiant', 'Subs-ArcadeSkinB.php', '', '', 'ArcadeSkinB', 1),
(3, 'Classic', 'Subs-ArcadeSkinA.php', '', '', 'Arcade', 1),
(4, 'Enterprise-A', 'Subs-ArcadeSkinA.php', 'ArcadeSkinA', 'ArcadeEnterpriseAdmin', 'ArcadeSkinA', 1);

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