DROP TABLE IF EXISTS `badcs`;
CREATE TABLE `badcs` (
  `bad_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `partner_id` mediumint(8) NOT NULL,
  `service_type` varchar(50) COLLATE utf8_bin NOT NULL,
  `service_level` tinyint(3) unsigned NOT NULL,
  `service_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `service_end` timestamp NULL DEFAULT NULL,
  `invoice` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`bad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO `badcs` (`bad_id`, `partner_id`, `service_type`, `service_level`, `service_start`, `service_end`, `invoice`) VALUES
(1,	123,	'CREATE TABLE badcs',	5,	'2018-03-02 10:48:23',	NULL,	1),
(2,	123,	'zzzzzzzzzzzzz',	4,	'2018-03-02 10:48:46',	NULL,	1),
(3,	255,	'trrrrrrrrrrrr',	4,	'2018-03-02 11:56:37',	NULL,	0);
