DROP TABLE IF EXISTS `litebans_bans`;
CREATE TABLE IF NOT EXISTS `litebans_bans` (
`id` bigint(20) unsigned NOT NULL,
  `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
  `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `time` bigint(20) NOT NULL,
  `until` bigint(20) NOT NULL,
  `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `silent` bit(1) NOT NULL,
  `ipban` bit(1) NOT NULL,
  `active` bit(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `litebans_bans` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
(3, '234a56a4-ec23-4985-8711-c4bc5b089b0b', '1.1.1.1', 'dit is een test haha', '234a56a4-ec23-4985-8711-c4bc5b089b0b', 'Marcooo', NULL, '#expired', '2018-01-31 21:13:11', 1517405598055, 1517405658055, 'kingdom', 'kingdom', b'0', b'0', b'0'),

DROP TABLE IF EXISTS `litebans_history`;
CREATE TABLE IF NOT EXISTS `litebans_history` (
`id` bigint(20) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `uuid` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1952 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `litebans_history` (`id`, `date`, `name`, `uuid`, `ip`) VALUES
(1, '2018-01-31 12:58:38', '_Rejox', '7aca088d-3f62-4a87-b4d6-f4fd111daf86', '84.82.56.52'),


DROP TABLE IF EXISTS `litebans_kicks`;
CREATE TABLE IF NOT EXISTS `litebans_kicks` (
`id` bigint(20) unsigned NOT NULL,
  `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
  `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` bigint(20) NOT NULL,
  `until` bigint(20) NOT NULL,
  `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `silent` bit(1) NOT NULL,
  `ipban` bit(1) NOT NULL,
  `active` bit(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `litebans_kicks` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
(2, 'a18adcee-66fd-40ea-a5fc-93033d54e410', '1.1.1.1', 'Spullen terug, 1 warn', '645fc856-65d8-44ac-b252-08046cb2f80b', 'MrWasbeer', 1518099505958, -1, '*', 'kingdom', b'0', b'0', b'0'),

DROP TABLE IF EXISTS `litebans_mutes`;
CREATE TABLE IF NOT EXISTS `litebans_mutes` (
`id` bigint(20) unsigned NOT NULL,
  `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
  `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `time` bigint(20) NOT NULL,
  `until` bigint(20) NOT NULL,
  `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `silent` bit(1) NOT NULL,
  `ipban` bit(1) NOT NULL,
  `active` bit(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `litebans_mutes` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
(2, '234a56a4-ec23-4985-8711-c4bc5b089b0b', '1.1.1.1', 'test', '234a56a4-ec23-4985-8711-c4bc5b089b0b', 'Marcooo', NULL, '#expired', '2018-01-31 21:13:11', 1517408634215, 1517408694215, 'lobby', 'lobby', b'0', b'0', b'0'),



DROP TABLE IF EXISTS `litebans_warnings`;
CREATE TABLE IF NOT EXISTS `litebans_warnings` (
`id` bigint(20) unsigned NOT NULL,
  `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
  `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `time` bigint(20) NOT NULL,
  `until` bigint(20) NOT NULL,
  `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `silent` bit(1) NOT NULL,
  `ipban` bit(1) NOT NULL,
  `active` bit(1) NOT NULL,
  `warned` bit(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `litebans_warnings` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`, `warned`) VALUES
(2, '8fae6db3-8c16-4496-9540-bcd0a27709c5', '1.1.1.1', 'Spammen.', '645fc856-65d8-44ac-b252-08046cb2f80b', 'MrWasbeer', NULL, '#expired', '2018-02-07 18:12:21', 1517417211071, 1518022011071, '*', 'kingdom', b'0', b'0', b'0', b'1'),