--- /dev/null
+{"administrators":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(5)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"username":{"Field":"username","Type":"varchar(30)","Null":"YES","Key":"","Default":null,"Extra":""},"password":{"Field":"password","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},"email":{"Field":"email","Type":"varchar(200)","Null":"YES","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"appliance_version":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"appliance_id":{"Field":"appliance_id","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""},"version_id":{"Field":"version_id","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""},"creation_date":{"Field":"creation_date","Type":"datetime","Null":"NO","Key":"","Default":null,"Extra":""},"message":{"Field":"message","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":""},"is_valider":{"Field":"is_valider","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":""},"is_valide":{"Field":"is_valide","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":""},"nature":{"Field":"nature","Type":"varchar(32)","Null":"NO","Key":"","Default":null,"Extra":""},"sugar_id":{"Field":"sugar_id","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"appliances":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(10)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"product":{"Field":"product","Type":"int(4)","Null":"YES","Key":"","Default":null,"Extra":""},"external_fqdn":{"Field":"external_fqdn","Type":"varchar(200)","Null":"YES","Key":"","Default":null,"Extra":""},"reference":{"Field":"reference","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},"manager":{"Field":"manager","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},"os":{"Field":"os","Type":"varchar(200)","Null":"YES","Key":"","Default":null,"Extra":""},"disc_infos":{"Field":"disc_infos","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},"internal_fqdn":{"Field":"internal_fqdn","Type":"varchar(200)","Null":"YES","Key":"","Default":null,"Extra":""},"contract_id":{"Field":"contract_id","Type":"int(11)","Null":"YES","Key":"","Default":null,"Extra":""},"uuid":{"Field":"uuid","Type":"varchar(64)","Null":"NO","Key":"","Default":null,"Extra":""},"last_appliance_version_id":{"Field":"last_appliance_version_id","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""},"channel_id":{"Field":"channel_id","Type":"int(10)","Null":"YES","Key":"","Default":null,"Extra":""},"type_hebergement_id":{"Field":"type_hebergement_id","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"channel":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"channel_key":{"Field":"channel_key","Type":"varchar(16)","Null":"NO","Key":"","Default":null,"Extra":""},"libelle":{"Field":"libelle","Type":"varchar(16)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"channel_version":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"channel_id":{"Field":"channel_id","Type":"int(10)","Null":"NO","Key":"","Default":null,"Extra":""},"status":{"Field":"status","Type":"varchar(32)","Null":"NO","Key":"","Default":null,"Extra":""},"version_id":{"Field":"version_id","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"commands":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(12)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"verifications":{"Field":"verifications","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},"value":{"Field":"value","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"contracts":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"number":{"Field":"number","Type":"varchar(50)","Null":"YES","Key":"MUL","Default":null,"Extra":""},"state":{"Field":"state","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},"start_date":{"Field":"start_date","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""},"end_date":{"Field":"end_date","Type":"date","Null":"YES","Key":"","Default":null,"Extra":""},"sugar_id":{"Field":"sugar_id","Type":"varchar(64)","Null":"NO","Key":"UNI","Default":null,"Extra":""},"customer_id":{"Field":"customer_id","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true},"sugar_id":{"type":"BTREE","col":["sugar_id"],"unique":true},"customer_id":{"type":"BTREE","col":["customer_id"],"unique":false},"number":{"type":"BTREE","col":["number"],"unique":false}}},"customers":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"ap_id":{"Field":"ap_id","Type":"varchar(30)","Null":"YES","Key":"MUL","Default":null,"Extra":""},"name":{"Field":"name","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},"ap_contact":{"Field":"ap_contact","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},"sugar_id":{"Field":"sugar_id","Type":"varchar(64)","Null":"NO","Key":"UNI","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true},"sugar_id":{"type":"BTREE","col":["sugar_id"],"unique":true},"ap_id":{"type":"BTREE","col":["ap_id"],"unique":false}}},"managers":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"ap_id":{"Field":"ap_id","Type":"varchar(30)","Null":"YES","Key":"","Default":null,"Extra":""},"name":{"Field":"name","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},"appliances":{"Field":"appliances","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"patches":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(6)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"version_id_from":{"Field":"version_id_from","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""},"version_id_to":{"Field":"version_id_to","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":""},"script_content":{"Field":"script_content","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""},"script_name":{"Field":"script_name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"products":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(4)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"name":{"Field":"name","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},"icon_url":{"Field":"icon_url","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},"diminutif":{"Field":"diminutif","Type":"varchar(8)","Null":"NO","Key":"","Default":null,"Extra":""},"sugar_id":{"Field":"sugar_id","Type":"varchar(64)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"tasks":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(10)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"commands":{"Field":"commands","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},"name":{"Field":"name","Type":"varchar(120)","Null":"YES","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"type_hebergement":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"type_hebergement_key":{"Field":"type_hebergement_key","Type":"varchar(16)","Null":"NO","Key":"","Default":null,"Extra":""},"libelle":{"Field":"libelle","Type":"varchar(64)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}},"versions":{"Engine":"InnoDB","Column":{"id":{"Field":"id","Type":"int(10)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},"value":{"Field":"value","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},"nature":{"Field":"nature","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},"product":{"Field":"product","Type":"int(4)","Null":"YES","Key":"","Default":null,"Extra":""},"sugar_id":{"Field":"sugar_id","Type":"varchar(64)","Null":"NO","Key":"","Default":null,"Extra":""}},"Index":{"PRIMARY":{"type":"BTREE","col":["id"],"unique":true}}}}
\ No newline at end of file