--- /dev/null
+CREATE TABLE `administrators` (
+ `id` int(5) NOT NULL AUTO_INCREMENT,
+ `username` varchar(30),
+ `password` text,
+ `email` varchar(200),
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `appliance_version` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `appliance_id` int(11) NOT NULL,
+ `version_id` int(11) NOT NULL,
+ `creation_date` datetime NOT NULL,
+ `message` varchar(255) NOT NULL,
+ `is_valider` tinyint(1) NOT NULL,
+ `is_valide` tinyint(1) NOT NULL,
+ `nature` varchar(32) NOT NULL,
+ `sugar_id` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `appliances` (
+ `id` int(10) NOT NULL AUTO_INCREMENT,
+ `product` int(4),
+ `external_fqdn` varchar(200),
+ `reference` varchar(100),
+ `manager` varchar(100),
+ `os` varchar(200),
+ `disc_infos` text,
+ `internal_fqdn` varchar(200),
+ `contract_id` int(11),
+ `uuid` varchar(64) NOT NULL,
+ `last_appliance_version_id` int(11) NOT NULL,
+ `channel_id` int(10),
+ `type_hebergement_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `channel` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `channel_key` varchar(16) NOT NULL,
+ `libelle` varchar(16) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `channel_version` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `channel_id` int(10) NOT NULL,
+ `status` varchar(32) NOT NULL,
+ `version_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `commands` (
+ `id` int(12) NOT NULL AUTO_INCREMENT,
+ `verifications` text,
+ `value` text,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `contracts` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `number` varchar(50),
+ `state` varchar(50),
+ `start_date` date,
+ `end_date` date,
+ `sugar_id` varchar(64) NOT NULL,
+ `customer_id` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `sugar_id` (`sugar_id`) ,
+ KEY `customer_id` (`customer_id`),
+ KEY `number` (`number`)
+) ENGINE=InnoDB ;
+CREATE TABLE `customers` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `ap_id` varchar(30),
+ `name` varchar(50),
+ `ap_contact` varchar(100),
+ `sugar_id` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `sugar_id` (`sugar_id`) ,
+ KEY `ap_id` (`ap_id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `managers` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `ap_id` varchar(30),
+ `name` varchar(50),
+ `appliances` text,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `patches` (
+ `id` int(6) NOT NULL AUTO_INCREMENT,
+ `version_id_from` int(11) NOT NULL,
+ `version_id_to` int(11) NOT NULL,
+ `script_content` text NOT NULL,
+ `script_name` varchar(255),
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `products` (
+ `id` int(4) NOT NULL AUTO_INCREMENT,
+ `name` varchar(100),
+ `icon_url` varchar(255),
+ `diminutif` varchar(8) NOT NULL,
+ `sugar_id` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `tasks` (
+ `id` int(10) NOT NULL AUTO_INCREMENT,
+ `commands` text,
+ `name` varchar(120),
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `type_hebergement` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `type_hebergement_key` varchar(16) NOT NULL,
+ `libelle` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
+CREATE TABLE `versions` (
+ `id` int(10) NOT NULL AUTO_INCREMENT,
+ `value` varchar(100),
+ `nature` varchar(50),
+ `product` int(4),
+ `sugar_id` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB ;
\ No newline at end of file