CREATE TABLE  `m_cinema` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(75) NOT NULL DEFAULT '',
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

CREATE TABLE `m_imb` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(300) NOT NULL DEFAULT '',
  `address` varchar(45) NOT NULL DEFAULT '',
  `port` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(50) NOT NULL DEFAULT '0',
  `api_username` varchar(45) NOT NULL DEFAULT '',
  `api_password` varchar(45) NOT NULL DEFAULT '',
  `id_cinema` int(10) unsigned NOT NULL DEFAULT '0',
  `serial_number` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

CREATE TABLE `m_imb_certificates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_imb` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(45) NOT NULL DEFAULT '',
  `path` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

CREATE TABLE `m_kdm_list` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cpl_uuid` varchar(45) NOT NULL DEFAULT '',
  `path` text NOT NULL,
  `batch_id` varchar(45) NOT NULL DEFAULT '',
  `valid_from` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `valid_to` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `id_imb` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(95) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;