CREATE TABLE `bl_game_users_reports` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_nick` varchar(64) NOT NULL,
  `reports` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `bl_game_users_reports`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `user_id` (`user_id`);

ALTER TABLE `bl_game_users_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

CREATE TABLE `bl_game_reports_meta` (
  `id` int(11) NOT NULL,
  `user_reported_id` int(11) NOT NULL,
  `submitter_user_id` int(11) NOT NULL,
  `report_type` int(7) UNSIGNED NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `bl_game_reports_meta`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `user_reported_id` (`user_reported_id`);

ALTER TABLE `bl_game_reports_meta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;