/*
Navicat MySQL Data Transfer

Source Server         : Asus_i7
Source Server Version : 50095
Source Host           : localhost:3306
Source Database       : iklembon_expertresa

Target Server Type    : MYSQL
Target Server Version : 50095
File Encoding         : 65001

Date: 2018-02-08 10:41:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for resto_cat_menu
-- ----------------------------
DROP TABLE IF EXISTS `resto_cat_menu`;
CREATE TABLE `resto_cat_menu` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `act` char(1) default NULL,
  `code_cat_menu` char(1) default NULL COMMENT 'code de regroupement des menus',
  `ordre` smallint(6) default '0' COMMENT 'ordre affichage dans la grille, dans le resultat et dans la liste depenses clients',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_cat_menu
-- ----------------------------
INSERT INTO `resto_cat_menu` VALUES ('1', 'IK', 'A', 'E', '1');
INSERT INTO `resto_cat_menu` VALUES ('2', 'IK', 'A', 'P', '2');
INSERT INTO `resto_cat_menu` VALUES ('3', 'IK', 'A', 'D', '3');
INSERT INTO `resto_cat_menu` VALUES ('4', 'IK', 'A', 'B', '4');
INSERT INTO `resto_cat_menu` VALUES ('5', 'IK', 'A', 'U', '5');
INSERT INTO `resto_cat_menu` VALUES ('6', 'IK', 'A', 'F', '6');
INSERT INTO `resto_cat_menu` VALUES ('8', 'IK', 'A', 'S', '8');

-- ----------------------------
-- Table structure for resto_cat_menu_lang
-- ----------------------------
DROP TABLE IF EXISTS `resto_cat_menu_lang`;
CREATE TABLE `resto_cat_menu_lang` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `lang` char(2) default NULL,
  `fk_code_cat_menu` char(1) default NULL COMMENT 'code de regroupement des menus',
  `intitule` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_cat_menu_lang
-- ----------------------------
INSERT INTO `resto_cat_menu_lang` VALUES ('1', 'IK', 'FR', 'E', 'ENTR?ES');
INSERT INTO `resto_cat_menu_lang` VALUES ('2', 'IK', 'EN', 'E', 'STARTERS');
INSERT INTO `resto_cat_menu_lang` VALUES ('3', 'IK', 'FR', 'P', 'PLATS');
INSERT INTO `resto_cat_menu_lang` VALUES ('4', 'IK', 'EN', 'P', 'MAIN COURSES');
INSERT INTO `resto_cat_menu_lang` VALUES ('5', 'IK', 'FR', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('6', 'IK', 'EN', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('7', 'IK', 'FR', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('8', 'IK', 'EN', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('9', 'IK', 'FR', 'U', 'A L\'UNIT?');
INSERT INTO `resto_cat_menu_lang` VALUES ('10', 'IK', 'EN', 'U', 'SINGLE ITEM');
INSERT INTO `resto_cat_menu_lang` VALUES ('11', 'IK', 'FR', 'F', 'FORMULES');
INSERT INTO `resto_cat_menu_lang` VALUES ('12', 'IK', 'EN', 'F', 'SETS');
INSERT INTO `resto_cat_menu_lang` VALUES ('15', 'IK', 'EN', 'S', 'EXTRAS');
INSERT INTO `resto_cat_menu_lang` VALUES ('16', 'IK', 'FR', 'S', 'SUPPL?MENTS---');

-- ----------------------------
-- Table structure for resto_items
-- ----------------------------
DROP TABLE IF EXISTS `resto_items`;
CREATE TABLE `resto_items` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `act` char(1) default NULL,
  `entite` varchar(12) default '',
  `fk_code_lieu` varchar(5) default '',
  `fk_cat_code_menu` char(1) default NULL,
  `photo` varchar(100) default NULL,
  `code_item` varchar(15) default NULL,
  `fk_code_produit` int(11) default NULL,
  `recette` char(1) default NULL COMMENT 'Produit compos? 1 ou pas 0',
  `prix_plat` decimal(13,2) default NULL,
  `fk_emp` int(11) default NULL,
  `cuisson` char(1) default '0' COMMENT '0/1 commentaire cuisson non/oui',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_items
-- ----------------------------
INSERT INTO `resto_items` VALUES ('1', 'IK', 'D', 'IK', 'RES', 'E', null, 'E0001', null, null, '48.00', '0', '0');
INSERT INTO `resto_items` VALUES ('2', 'IK', 'A', 'IK', 'RES', 'E', null, 'E0002', null, '1', '65.00', '0', '0');
INSERT INTO `resto_items` VALUES ('3', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0001', null, null, '115.00', '0', '1');
INSERT INTO `resto_items` VALUES ('4', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0002', null, null, '125.00', '0', '1');
INSERT INTO `resto_items` VALUES ('5', 'IK', 'A', 'IK', 'RES', 'P', null, 'P0003', null, '1', '130.00', '0', '0');
INSERT INTO `resto_items` VALUES ('6', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0004', null, null, '95.00', '0', '1');
INSERT INTO `resto_items` VALUES ('7', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0005', null, null, '112.00', '0', '0');
INSERT INTO `resto_items` VALUES ('8', 'IK', 'A', 'IK', 'RES', 'P', null, 'P0006', null, '1', '88.00', '0', '0');
INSERT INTO `resto_items` VALUES ('9', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0007', null, null, '98.00', '0', '0');
INSERT INTO `resto_items` VALUES ('10', 'IK', 'D', 'IK', 'RES', 'D', null, 'D0001', null, null, '25.00', '0', '0');
INSERT INTO `resto_items` VALUES ('11', 'IK', 'D', 'IK', 'RES', 'D', null, 'D0002', null, null, '30.00', '0', '0');
INSERT INTO `resto_items` VALUES ('12', 'IK', 'D', 'IK', 'RES', 'F', null, 'F0001', null, null, '250.00', '0', '0');
INSERT INTO `resto_items` VALUES ('13', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0001', null, null, '40.00', '0', '0');
INSERT INTO `resto_items` VALUES ('14', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0002', null, null, '35.00', '0', '0');
INSERT INTO `resto_items` VALUES ('15', 'IK', 'D', 'IK', 'RES', 'B', null, 'U0001', null, null, '18.00', '0', '0');
INSERT INTO `resto_items` VALUES ('16', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0004', null, null, '30.00', '0', '0');
INSERT INTO `resto_items` VALUES ('17', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0005', null, null, '52.00', '0', '0');
INSERT INTO `resto_items` VALUES ('18', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0006', null, null, '45.00', '0', '0');
INSERT INTO `resto_items` VALUES ('19', 'IK', 'D', 'IK', 'RES', 'B', null, 'B0007', null, null, '37.00', '0', '0');
INSERT INTO `resto_items` VALUES ('21', 'IK', 'D', 'IK', 'RES', 'P', null, 'P0008', null, null, '80.00', '0', '0');
INSERT INTO `resto_items` VALUES ('22', 'IK', 'A', 'IK', 'RES', 'E', null, 'E0003', null, '1', '10.00', '0', '0');
INSERT INTO `resto_items` VALUES ('23', 'IK', 'D', 'IK', 'RES', 'E', null, 'E0004', null, null, '12.00', '0', '0');
INSERT INTO `resto_items` VALUES ('24', 'IK', 'D', 'IK', 'RES', 'E', null, 'E0005', null, null, '19.00', '0', '0');

-- ----------------------------
-- Table structure for resto_items_compo
-- ----------------------------
DROP TABLE IF EXISTS `resto_items_compo`;
CREATE TABLE `resto_items_compo` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `act` char(1) default NULL,
  `fk_code_item` varchar(15) default NULL,
  `fk_code_ingredient` varchar(20) default NULL,
  `qte` decimal(8,2) default NULL,
  `fk_emp` int(11) default NULL,
  `commentaire` varchar(255) default '' COMMENT 'commentaire sur ingredient',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_items_compo
-- ----------------------------
INSERT INTO `resto_items_compo` VALUES ('1', 'IK', 'D', 'E0003', 'FO-0048', '0.30', '0', '');
INSERT INTO `resto_items_compo` VALUES ('2', 'IK', 'D', 'E0003', 'FO-0050', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('3', 'IK', 'D', 'E0003', 'FO-0064', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('4', 'IK', 'D', 'P0003', 'FO-0085', '0.50', '0', '');
INSERT INTO `resto_items_compo` VALUES ('5', 'IK', 'D', 'P0003', 'FO-0064', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('6', 'IK', 'D', 'P0003', 'FO-0073', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('7', 'IK', 'D', 'E0002', 'FO-0072', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('8', 'IK', 'D', 'E0002', 'FO-0021', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('9', 'IK', 'D', 'E0002', 'FO-0068', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('10', 'IK', 'D', 'P0006', 'FO-0074', '0.30', '0', '');
INSERT INTO `resto_items_compo` VALUES ('11', 'IK', 'D', 'P0006', 'FO-0087', '0.10', '0', '');

-- ----------------------------
-- Table structure for resto_items_lang
-- ----------------------------
DROP TABLE IF EXISTS `resto_items_lang`;
CREATE TABLE `resto_items_lang` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `lang` char(2) default NULL,
  `fk_code_item` varchar(15) default NULL,
  `intitule` varchar(100) default NULL,
  `descro` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_items_lang
-- ----------------------------
INSERT INTO `resto_items_lang` VALUES ('1', 'IK', 'FR', 'E0001', 'SALADE D\'ENDIVES', 'Salade d\'endives craquantes avec sauce moutarde');
INSERT INTO `resto_items_lang` VALUES ('2', 'IK', 'EN', 'E0001', 'CHICORY SALAD', 'Chicory salad with mustard sauce');
INSERT INTO `resto_items_lang` VALUES ('3', 'IK', 'FR', 'E0002', 'CRUDITÉS DE SAISON', 'Plat de crudités de saison');
INSERT INTO `resto_items_lang` VALUES ('4', 'IK', 'EN', 'E0002', 'SEASONAL RAW VEGETABLES', 'Plate full of seasonal raw vegetables with vinegar sauce');
INSERT INTO `resto_items_lang` VALUES ('5', 'IK', 'FR', 'P0001', 'ESCALOPE DE VEAU A LA CRÈME', '');
INSERT INTO `resto_items_lang` VALUES ('6', 'IK', 'EN', 'P0001', 'ESCALOPE OF VEAL IN SOUR CREAM SAUCE', null);
INSERT INTO `resto_items_lang` VALUES ('7', 'IK', 'FR', 'P0002', 'POULET GRILLÉ SUR LIT DE LÉGUMES VERTS', null);
INSERT INTO `resto_items_lang` VALUES ('8', 'IK', 'EN', 'P0002', 'GRILLED CHICKEN ON GREENIES', null);
INSERT INTO `resto_items_lang` VALUES ('9', 'IK', 'FR', 'P0003', 'CREVETTES PERSILLADE', '');
INSERT INTO `resto_items_lang` VALUES ('10', 'IK', 'EN', 'P0003', 'PRAWNS IN PARSLEY SAUCE', '');
INSERT INTO `resto_items_lang` VALUES ('11', 'IK', 'FR', 'P0004', 'FILET DE BOEUF SAUCE ROMANOFF', null);
INSERT INTO `resto_items_lang` VALUES ('12', 'IK', 'EN', 'P0004', 'BEEF FILET IN ROMANOFF SAUCE', null);
INSERT INTO `resto_items_lang` VALUES ('13', 'IK', 'FR', 'P0005', 'SAUMON FUMÉ A LA MARJOLAINE', null);
INSERT INTO `resto_items_lang` VALUES ('14', 'IK', 'EN', 'P0005', 'SMOKED SALMON IN MARJORAM SAUCE', null);
INSERT INTO `resto_items_lang` VALUES ('15', 'IK', 'FR', 'P0006', 'ROTI DE PORC MAYONNAISE', '');
INSERT INTO `resto_items_lang` VALUES ('16', 'IK', 'EN', 'P0006', 'ROAST PORK MAYONNAISE', '');
INSERT INTO `resto_items_lang` VALUES ('17', 'IK', 'FR', 'P0007', 'FILET DE BARRAMUNDI SAUCE POIVRE VERT', null);
INSERT INTO `resto_items_lang` VALUES ('18', 'IK', 'EN', 'P0007', 'BARRAMUNDI FILET IN GREEN PEPPER SAUCE', null);
INSERT INTO `resto_items_lang` VALUES ('19', 'IK', 'FR', 'D0001', 'MOUSSE AU CHOCOLAT', null);
INSERT INTO `resto_items_lang` VALUES ('20', 'IK', 'EN', 'D0001', 'CHOCOLATE MOUSSE', null);
INSERT INTO `resto_items_lang` VALUES ('21', 'IK', 'FR', 'D0002', 'CRÈME ANGLAISE', null);
INSERT INTO `resto_items_lang` VALUES ('22', 'IK', 'EN', 'D0002', 'ENGLISH CREAM', null);
INSERT INTO `resto_items_lang` VALUES ('23', 'IK', 'FR', 'F0001', 'FORMULE DÉJEUNER', null);
INSERT INTO `resto_items_lang` VALUES ('24', 'IK', 'EN', 'F0001', 'LUNCH SET', null);
INSERT INTO `resto_items_lang` VALUES ('25', 'IK', 'FR', 'B0001', 'COCA COLA (33cl)', '');
INSERT INTO `resto_items_lang` VALUES ('26', 'IK', 'EN', 'B0001', 'COCA COLA (33cl)', '');
INSERT INTO `resto_items_lang` VALUES ('27', 'IK', 'FR', 'B0002', 'ORANGINA (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('28', 'IK', 'EN', 'B0002', 'ORANGINA (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('29', 'IK', 'FR', 'U0001', 'CAFE EXPRESSO', '');
INSERT INTO `resto_items_lang` VALUES ('30', 'IK', 'EN', 'U0001', 'CAFE EXPRESSO', '');
INSERT INTO `resto_items_lang` VALUES ('31', 'IK', 'FR', 'B0004', 'THE AU JASMIN (cup)', null);
INSERT INTO `resto_items_lang` VALUES ('32', 'IK', 'EN', 'B0004', 'JASMINE TEA (cup)', null);
INSERT INTO `resto_items_lang` VALUES ('33', 'IK', 'FR', 'B0005', 'BIÈRE BINTANG (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('34', 'IK', 'EN', 'B0005', 'BEER BINTANG (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('35', 'IK', 'FR', 'B0006', 'SEVEN UP (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('36', 'IK', 'EN', 'B0006', 'SEVEN UP (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('37', 'IK', 'FR', 'B0007', 'SPRITE (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('38', 'IK', 'EN', 'B0007', 'SPRITE (33cl)', null);
INSERT INTO `resto_items_lang` VALUES ('39', 'IK', 'FR', 'R0001', 'NEM (4 pièces)', 'Nems (4 pi?ces) avec du riz Basmati aux fines herbes, Sauce soja');
INSERT INTO `resto_items_lang` VALUES ('40', 'IK', 'EN', 'R0001', 'NEM (4 pièces)', 'Nems (4 pieces) with Basmati rice with fine herbs, Soya sauce');
INSERT INTO `resto_items_lang` VALUES ('41', 'IK', 'EN', 'P0008', 'POULET ROTI', '');
INSERT INTO `resto_items_lang` VALUES ('42', 'IK', 'FR', 'P0008', 'ROAST CHICKEN', '');
INSERT INTO `resto_items_lang` VALUES ('43', 'IK', 'EN', 'E0003', 'CHEESE CAKE', '');
INSERT INTO `resto_items_lang` VALUES ('44', 'IK', 'FR', 'E0003', 'CAKE AU FROMAGE', '');
INSERT INTO `resto_items_lang` VALUES ('45', 'IK', 'EN', 'E0004', 'CAKE', '');
INSERT INTO `resto_items_lang` VALUES ('46', 'IK', 'FR', 'E0004', 'CAKE', '');
INSERT INTO `resto_items_lang` VALUES ('47', 'IK', 'EN', 'E0005', 'NEM (4 pièces)', 'Nems (4 pieces) with Basmati rice with fine herbs, Soya sauce');
INSERT INTO `resto_items_lang` VALUES ('48', 'IK', 'FR', 'E0005', 'NEM (4 pièces)', 'Nems (4 pi?ces) avec du riz Basmati aux fines herbes, Sauce soja');

-- ----------------------------
-- Table structure for resto_lieux_de_vente
-- ----------------------------
DROP TABLE IF EXISTS `resto_lieux_de_vente`;
CREATE TABLE `resto_lieux_de_vente` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default NULL,
  `entite` varchar(12) default NULL,
  `act` char(1) default NULL,
  `fk_code_lieu` char(3) default NULL COMMENT 'code de regroupement des menus',
  `ordre` smallint(6) default '0' COMMENT 'ordre affichage dans la grille, dans le resultat et dans la liste depenses clients',
  `nb_tables` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_lieux_de_vente
-- ----------------------------
INSERT INTO `resto_lieux_de_vente` VALUES ('2', 'IK', 'IK', 'A', 'RES', '1', '7');
INSERT INTO `resto_lieux_de_vente` VALUES ('3', 'IK', 'IK', 'A', 'RSV', '3', '0');
INSERT INTO `resto_lieux_de_vente` VALUES ('4', 'IK', 'IK', 'A', 'CRE', '2', '6');

-- ----------------------------
-- Table structure for resto_lieux_de_vente_lang
-- ----------------------------
DROP TABLE IF EXISTS `resto_lieux_de_vente_lang`;
CREATE TABLE `resto_lieux_de_vente_lang` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default NULL,
  `lang` char(2) default NULL,
  `fk_code_lieu` char(3) default NULL COMMENT 'code de regroupement des menus',
  `intitule` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_lieux_de_vente_lang
-- ----------------------------
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('1', 'IK', 'FR', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('2', 'IK', 'FR', 'CRE', 'CR?PERIE');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('3', 'IK', 'FR', 'RSV', 'SERVICE EN CHAMBRE');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('4', 'IK', 'EN', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('5', 'IK', 'EN', 'CRE', 'CREPERY');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('6', 'IK', 'EN', 'RSV', 'ROOM SERVICE');

-- ----------------------------
-- Table structure for resto_tables
-- ----------------------------
DROP TABLE IF EXISTS `resto_tables`;
CREATE TABLE `resto_tables` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `entite` varchar(12) default NULL,
  `act` char(1) default NULL,
  `numero` char(2) default NULL,
  `nb_pers` char(2) default NULL,
  `fk_code_lieu` varchar(5) default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tables
-- ----------------------------
INSERT INTO `resto_tables` VALUES ('1', 'IK', 'IK', 'A', '01', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('2', 'IK', 'IK', 'A', '02', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('3', 'IK', 'IK', 'A', '03', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('4', 'IK', 'IK', 'A', '04', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('5', 'IK', 'IK', 'A', '05', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('6', 'IK', 'IK', 'A', '01', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('7', 'IK', 'IK', 'A', '02', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('8', 'IK', 'IK', 'A', '03', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('9', 'IK', 'IK', 'A', '04', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('10', 'IK', 'IK', 'A', '05', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('11', 'IK', 'IK', 'A', '06', '4', 'CRE');

-- ----------------------------
-- Table structure for resto_tables_encours
-- ----------------------------
DROP TABLE IF EXISTS `resto_tables_encours`;
CREATE TABLE `resto_tables_encours` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `entite` char(3) default NULL,
  `fk_code_lieu` char(3) default NULL,
  `num_table` char(2) default NULL,
  `fk_num_ticket` char(14) default NULL,
  `statut` char(3) default NULL,
  `client` varchar(255) default NULL,
  `heure_resa` char(5) default NULL,
  `heure_debut` char(5) default NULL,
  `etat_repas` varchar(30) default NULL,
  `nb_pers` smallint(6) default NULL,
  `client_resa_next` varchar(255) default NULL,
  `mnt_encours` decimal(11,2) default NULL,
  `qte_items` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tables_encours
-- ----------------------------
INSERT INTO `resto_tables_encours` VALUES ('1', 'IK', 'IK', 'RES', '01', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('2', 'IK', 'IK', 'RES', '02', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('3', 'IK', 'IK', 'RES', '03', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('4', 'IK', 'IK', 'RES', '04', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('5', 'IK', 'IK', 'RES', '05', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('6', 'IK', 'IK', 'RES', '06', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('7', 'IK', 'IK', 'RES', '07', 'TI20171125-001', 'occ', 'PASSAGE', null, '09:13', null, '1', null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('8', 'IK', 'IK', 'RES', '08', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('9', 'IK', 'IK', 'RES', '09', null, 'lib', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('10', 'IK', 'IK', 'RES', '10', null, 'lib', null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for resto_tickets
-- ----------------------------
DROP TABLE IF EXISTS `resto_tickets`;
CREATE TABLE `resto_tickets` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `entite` varchar(12) default NULL,
  `fk_code_lieu` char(3) default NULL,
  `numero` char(14) default NULL COMMENT '20160213-123',
  `fk_num_table_encours` char(2) default NULL,
  `code_chambre` varchar(50) default NULL COMMENT 'char(3) pour 999 chambres max',
  `mnt_total` decimal(12,2) default NULL,
  `qte_items` smallint(6) default NULL,
  `date_cmd` char(8) default '' COMMENT 'date de commande du plat',
  `date_stock` char(8) default '' COMMENT 'date quantite hors stock',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets
-- ----------------------------
INSERT INTO `resto_tickets` VALUES ('3', 'IK', 'IK', 'RES', 'TI20171125-001', '07', '', null, null, '20171125', '');

-- ----------------------------
-- Table structure for resto_tickets_lignes
-- ----------------------------
DROP TABLE IF EXISTS `resto_tickets_lignes`;
CREATE TABLE `resto_tickets_lignes` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `fk_num_ticket` char(14) default NULL,
  `fk_code_item` char(5) default NULL,
  `qte` tinyint(4) default '0',
  `prix_plat` decimal(10,0) default NULL,
  `statut_plat` char(3) default NULL COMMENT 'Indique l''état d''avancement de la commande',
  `ordre` char(1) default NULL COMMENT 'ordre d''affichage E1, P2, D3, B4, R5, F6',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets_lignes
-- ----------------------------
INSERT INTO `resto_tickets_lignes` VALUES ('1', 'IK', 'TI20171125-001', 'E0001', '1', '48', 'S0I', '1');
INSERT INTO `resto_tickets_lignes` VALUES ('2', 'IK', 'TI20171125-001', 'E0005', '2', '19', 'S0I', '1');
INSERT INTO `resto_tickets_lignes` VALUES ('3', 'IK', 'TI20171125-001', 'P0007', '2', '98', 'S0I', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('4', 'IK', 'TI20171125-001', 'B0005', '2', '52', 'S0I', '4');

-- ----------------------------
-- Table structure for resto_tickets_lignes_details
-- ----------------------------
DROP TABLE IF EXISTS `resto_tickets_lignes_details`;
CREATE TABLE `resto_tickets_lignes_details` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `fk_num_ticket` char(13) default NULL,
  `fk_code_item` char(5) default NULL,
  `fk_code_ingredient` varchar(20) default NULL,
  `qte_ingredient` decimal(8,2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets_lignes_details
-- ----------------------------

-- ----------------------------
-- Table structure for resto_tickets_reglements
-- ----------------------------
DROP TABLE IF EXISTS `resto_tickets_reglements`;
CREATE TABLE `resto_tickets_reglements` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `fk_num_ticket` char(13) default NULL,
  `fk_mode_reglement` varchar(10) default NULL,
  `montant` decimal(10,0) default NULL,
  `cb_type` varchar(20) default NULL,
  `cb_numero` varchar(25) default NULL,
  `cb_detenteur` varchar(50) default NULL,
  `cb_code_secu` varchar(4) default NULL,
  `cb_date_exp` varchar(5) default NULL,
  `cb_code_transaction` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets_reglements
-- ----------------------------
