/*
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: 2019-04-22 14:51:08
*/

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',
  `type_conso` varchar(2) default '',
  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', 'XP00000001', 'A', 'E', '1', 'FO');
INSERT INTO `resto_cat_menu` VALUES ('2', 'XP00000001', 'A', 'P', '2', 'FO');
INSERT INTO `resto_cat_menu` VALUES ('3', 'XP00000001', 'A', 'D', '3', 'FO');
INSERT INTO `resto_cat_menu` VALUES ('4', 'XP00000001', 'A', 'B', '4', 'BE');
INSERT INTO `resto_cat_menu` VALUES ('5', 'XP00000001', 'A', 'U', '5', 'FO');
INSERT INTO `resto_cat_menu` VALUES ('6', 'XP00000001', 'A', 'F', '6', 'FO');
INSERT INTO `resto_cat_menu` VALUES ('8', 'XP00000001', 'A', 'S', '8', 'FO');

-- ----------------------------
-- 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', 'XP00000001', 'FR', 'E', 'ENTR�ES');
INSERT INTO `resto_cat_menu_lang` VALUES ('2', 'XP00000001', 'EN', 'E', 'STARTERS');
INSERT INTO `resto_cat_menu_lang` VALUES ('3', 'XP00000001', 'FR', 'P', 'PLATS');
INSERT INTO `resto_cat_menu_lang` VALUES ('4', 'XP00000001', 'EN', 'P', 'MAIN COURSES');
INSERT INTO `resto_cat_menu_lang` VALUES ('5', 'XP00000001', 'FR', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('6', 'XP00000001', 'EN', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('7', 'XP00000001', 'FR', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('8', 'XP00000001', 'EN', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('9', 'XP00000001', 'FR', 'U', 'A L\'UNIT�');
INSERT INTO `resto_cat_menu_lang` VALUES ('10', 'XP00000001', 'EN', 'U', 'SINGLE ITEM');
INSERT INTO `resto_cat_menu_lang` VALUES ('11', 'XP00000001', 'FR', 'F', 'FORMULES');
INSERT INTO `resto_cat_menu_lang` VALUES ('12', 'XP00000001', 'EN', 'F', 'SETS');
INSERT INTO `resto_cat_menu_lang` VALUES ('15', 'XP00000001', 'EN', 'S', 'EXTRAS');
INSERT INTO `resto_cat_menu_lang` VALUES ('16', 'XP00000001', '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 '0' 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',
  `err_compo` char(1) default '1' COMMENT 'composition manquante',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_items
-- ----------------------------
INSERT INTO `resto_items` VALUES ('1', 'XP00000001', 'D', 'IK', 'RES', 'E', null, 'E0001', null, '0', '48000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('2', 'XP00000001', 'A', 'IK', 'RES', 'E', null, 'E0002', null, '1', '65000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('3', 'XP00000001', 'D', 'IK', 'RES', 'P', null, 'P0001', null, '0', '115000.00', '0', '1', '1');
INSERT INTO `resto_items` VALUES ('4', 'XP00000001', 'D', 'IK', 'RES', 'P', null, 'P0002', null, '0', '125000.00', '0', '1', '1');
INSERT INTO `resto_items` VALUES ('5', 'XP00000001', 'A', 'IK', 'RES', 'P', null, 'P0003', null, '1', '131000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('6', 'XP00000001', 'A', 'IK', 'RES', 'P', null, 'P0004', null, '0', '95000.00', '0', '1', '0');
INSERT INTO `resto_items` VALUES ('7', 'XP00000001', 'D', 'IK', 'RES', 'P', null, 'P0005', null, '0', '11200.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('8', 'XP00000001', 'A', 'IK', 'RES', 'P', null, 'P0006', null, '1', '88000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('9', 'XP00000001', 'A', 'IK', 'RES', 'P', null, 'P0007', null, '1', '98000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('10', 'XP00000001', 'D', 'IK', 'RES', 'D', null, 'D0001', null, '0', '25000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('11', 'XP00000001', 'D', 'IK', 'RES', 'D', null, 'D0002', null, '0', '30000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('12', 'XP00000001', 'D', 'IK', 'RES', 'F', null, 'F0001', null, '0', '250000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('13', 'XP00000001', 'A', 'IK', 'RES', 'B', null, 'B0001', null, '0', '4000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('14', 'XP00000001', 'D', 'IK', 'RES', 'B', null, 'B0002', null, '1', '3500.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('15', 'XP00000001', 'D', 'IK', 'RES', 'B', null, 'U0001', null, '0', '18000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('16', 'XP00000001', 'D', 'IK', 'RES', 'B', null, 'B0004', null, '0', '3000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('17', 'XP00000001', 'D', 'IK', 'RES', 'B', null, 'B0005', null, '0', '5200.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('18', 'XP00000001', 'A', 'IK', 'RES', 'B', null, 'B0006', null, '0', '54500.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('19', 'XP00000001', 'A', 'IK', 'RES', 'B', null, 'B0007', null, '1', '25000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('21', 'XP00000001', 'D', 'IK', 'RES', 'P', null, 'P0008', null, '0', '80000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('22', 'XP00000001', 'A', 'IK', 'RES', 'E', null, 'E0003', null, '1', '10000.00', '0', '0', '0');
INSERT INTO `resto_items` VALUES ('23', 'XP00000001', 'D', 'IK', 'RES', 'E', null, 'E0004', null, '0', '12000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('24', 'XP00000001', 'D', 'IK', 'RES', 'E', null, 'E0005', null, '0', '19000.00', '0', '0', '1');
INSERT INTO `resto_items` VALUES ('25', 'XP00000001', 'A', 'IK', 'CRE', 'B', null, 'B0008', null, '1', '5000.00', '0', '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=39 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_items_compo
-- ----------------------------
INSERT INTO `resto_items_compo` VALUES ('1', 'XP00000001', 'D', 'E0003', 'FO-0048', '0.30', '0', '');
INSERT INTO `resto_items_compo` VALUES ('2', 'XP00000001', 'D', 'E0003', 'FO-0050', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('3', 'XP00000001', 'D', 'E0003', 'FO-0064', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('4', 'XP00000001', 'D', 'P0003', 'FO-0085', '0.50', '0', '');
INSERT INTO `resto_items_compo` VALUES ('5', 'XP00000001', 'D', 'P0003', 'FO-0064', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('6', 'XP00000001', 'D', 'P0003', 'FO-0073', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('7', 'XP00000001', 'D', 'E0002', 'FO-0072', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('8', 'XP00000001', 'D', 'E0002', 'FO-0021', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('9', 'XP00000001', 'D', 'E0002', 'FO-0068', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('10', 'XP00000001', 'D', 'P0006', 'FO-0074', '0.30', '0', '');
INSERT INTO `resto_items_compo` VALUES ('11', 'XP00000001', 'D', 'P0006', 'FO-0087', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('12', 'XP00000001', 'D', 'E0003', 'FO-0085', '0.20', '0', '');
INSERT INTO `resto_items_compo` VALUES ('14', 'XP00000001', 'D', 'B0002', 'BE-0128', '0.25', '0', '');
INSERT INTO `resto_items_compo` VALUES ('16', 'XP00000001', 'D', 'B0004', 'FO-0061', '1.00', '0', '');
INSERT INTO `resto_items_compo` VALUES ('17', 'XP00000001', 'D', 'B0005', 'BE-0004', '0.33', '0', '');
INSERT INTO `resto_items_compo` VALUES ('20', 'XP00000001', 'D', 'B0008', 'BE-0012', '0.25', '0', '');
INSERT INTO `resto_items_compo` VALUES ('21', 'XP00000001', 'D', 'B0006', 'BE-0086', '0.75', '0', '');
INSERT INTO `resto_items_compo` VALUES ('22', 'XP00000001', 'D', 'B0007', 'BE-0086', '0.10', '0', '');
INSERT INTO `resto_items_compo` VALUES ('23', 'XP00000001', 'D', 'E0002', 'FO-0097', '0.25', '0', '');
INSERT INTO `resto_items_compo` VALUES ('24', 'XP00000001', 'D', 'B0001', 'BE-0094', '1.00', '0', '');
INSERT INTO `resto_items_compo` VALUES ('32', 'XP00000001', 'D', 'P0004', 'FO-0007', '1.00', '0', '');
INSERT INTO `resto_items_compo` VALUES ('34', 'XP00000001', 'D', 'P0006', 'FO-0001', '0.20', '0', 'après cuisson');
INSERT INTO `resto_items_compo` VALUES ('38', 'XP00000001', 'D', 'P0007', 'FO-0117', '0.40', '0', 'cuisson');

-- ----------------------------
-- 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=51 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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

-- ----------------------------
-- 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,
  `lettre_lieu` char(1) default '',
  `lettres_doc` char(2) default '',
  `service_lieu` decimal(4,2) default NULL,
  `taxe_tva_lieu` decimal(4,2) default NULL,
  `adresse_mail` varchar(255) default '',
  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', 'XP00000001', 'IK', 'A', 'RES', '1', '10', 'R', 'RT', '11.00', '5.00', 'http://indiana-kenanga-villas.com');
INSERT INTO `resto_lieux_de_vente` VALUES ('3', 'XP00000001', 'IK', 'A', 'MNB', '3', '0', 'R', 'RS', '11.00', '5.00', 'http://indiana-kenanga-villas.com');
INSERT INTO `resto_lieux_de_vente` VALUES ('4', 'XP00000001', 'IK', 'A', 'CRE', '2', '0', 'C', 'CR', '11.00', '5.00', 'http://indiana-kenanga-villas.com');

-- ----------------------------
-- 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', 'XP00000001', 'FR', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('2', 'XP00000001', 'FR', 'CRE', 'CR�PERIE');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('3', 'XP00000001', 'FR', 'MNB', 'MINI BAR');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('4', 'XP00000001', 'EN', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('5', 'XP00000001', 'EN', 'CRE', 'CREPERY');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('6', 'XP00000001', 'EN', 'MNB', 'MINI BAR');

-- ----------------------------
-- Table structure for resto_subcat_menu
-- ----------------------------
DROP TABLE IF EXISTS `resto_subcat_menu`;
CREATE TABLE `resto_subcat_menu` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `act` char(1) default NULL,
  `code_subcat_menu` char(1) default NULL COMMENT 'code de sous 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=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_subcat_menu
-- ----------------------------
INSERT INTO `resto_subcat_menu` VALUES ('1', 'XPR1000001', 'A', 'F', '1');
INSERT INTO `resto_subcat_menu` VALUES ('2', 'XPR1000001', 'A', 'V', '2');

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

-- ----------------------------
-- Records of resto_subcat_menu_lang
-- ----------------------------
INSERT INTO `resto_subcat_menu_lang` VALUES ('1', 'XPR1000001', 'FR', 'F', 'FRUIT');
INSERT INTO `resto_subcat_menu_lang` VALUES ('2', 'XPR1000001', 'EN', 'F', 'FRUIT');
INSERT INTO `resto_subcat_menu_lang` VALUES ('3', 'XPR1000001', 'FR', 'V', 'VEGETARIEN');
INSERT INTO `resto_subcat_menu_lang` VALUES ('4', 'XPR1000001', 'EN', 'V', 'VEGETARIAN');

-- ----------------------------
-- 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=29 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tables
-- ----------------------------
INSERT INTO `resto_tables` VALUES ('1', 'XP00000001', 'IK', 'A', '01', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('2', 'XP00000001', 'IK', 'A', '02', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('3', 'XP00000001', 'IK', 'A', '03', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('4', 'XP00000001', 'IK', 'A', '04', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('5', 'XP00000001', 'IK', 'A', '05', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('6', 'XP00000001', 'IK', 'A', '06', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('7', 'XP00000001', 'IK', 'A', '07', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('8', 'XP00000001', 'IK', 'A', '08', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('9', 'XP00000001', 'IK', 'A', '09', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('10', 'XP00000001', 'IK', 'A', '10', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('21', 'XP00000001', 'IK', 'A', '11', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('22', 'XP00000001', 'IK', 'A', '12', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('23', 'XP00000001', 'IK', 'A', '13', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('24', 'XP00000001', 'IK', 'A', '14', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('25', 'XP00000001', 'IK', 'A', '15', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('26', 'XP00000001', 'IK', 'A', '16', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('27', 'XP00000001', 'IK', 'A', '17', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('28', 'XP00000001', 'IK', 'A', '18', '2', 'RES');

-- ----------------------------
-- 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=19 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tables_encours
-- ----------------------------
INSERT INTO `resto_tables_encours` VALUES ('1', 'XP00000001', 'IK', 'RES', '01', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('2', 'XP00000001', 'IK', 'RES', '02', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('3', 'XP00000001', 'IK', 'RES', '03', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('4', 'XP00000001', 'IK', 'RES', '04', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('5', 'XP00000001', 'IK', 'RES', '05', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('6', 'XP00000001', 'IK', 'RES', '06', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('7', 'XP00000001', 'IK', 'RES', '07', 'TI20171125-001', 'occ', 'PASSAGE', null, '09:13', null, '1', null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('8', 'XP00000001', 'IK', 'RES', '08', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('9', 'XP00000001', 'IK', 'RES', '09', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('10', 'XP00000001', 'IK', 'RES', '10', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('11', 'XP00000001', 'IK', 'RES', '11', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('12', 'XP00000001', 'IK', 'RES', '12', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('13', 'XP00000001', 'IK', 'RES', '13', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('14', 'XP00000001', 'IK', 'RES', '14', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('15', 'XP00000001', 'IK', 'RES', '15', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('16', 'XP00000001', 'IK', 'RES', '16', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('17', 'XP00000001', 'IK', 'RES', '17', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('18', 'XP00000001', 'IK', 'RES', '18', 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',
  `num_doc_htl` varchar(20) default NULL,
  `tx_service` decimal(13,2) default '0.00',
  `tx_tva` decimal(13,2) default '0.00',
  `prix_ht` decimal(13,2) default '0.00',
  `mnt_total` decimal(12,2) default '0.00',
  `qte_items` smallint(6) default '0',
  `date_cmd` char(8) default '' COMMENT 'date de commande du plat',
  `date_stock` char(8) default '' COMMENT 'date quantite hors stock',
  `num_bs_stock` varchar(20) default '' COMMENT 'numéro de document de sortie stock',
  `ticket_paye` char(1) default '0' COMMENT 'ticket payé par le client',
  `fini` char(1) default '0' COMMENT 'clients partis - de passage ont paye - de hotel paieront fin de séjour',
  `dep_ext` varchar(5) default '',
  `fk_emp` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets
-- ----------------------------
INSERT INTO `resto_tickets` VALUES ('1', 'XP00000001', 'IK', 'RES', 'TI20180419-001', '07', '15', 'FA201804185', '28078.00', '14167.00', '255255.00', '297500.00', '5', '20180419', '', '', '0', '1', '', '0');
INSERT INTO `resto_tickets` VALUES ('2', 'XP00000001', 'IK', 'RES', 'TI20180419-002', '03', '05', 'FA201804162', '27748.00', '14000.00', '252252.00', '294000.00', '4', '20180419', '', '', '0', '1', '', '0');
INSERT INTO `resto_tickets` VALUES ('3', 'XP00000001', 'IK', 'RES', 'TI20180419-003', '01', '', '', '19442.00', '9810.00', '176748.00', '206000.00', '3', '20180419', '', '', '1', '1', '', '0');
INSERT INTO `resto_tickets` VALUES ('4', 'XP00000001', 'IK', 'RES', 'TI20180419-004', '02', '15', 'FA201804185', '21613.00', '10905.00', '196482.00', '229000.00', '3', '20180419', '', '', '0', '1', '', '0');

-- ----------------------------
-- 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=16 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets_lignes
-- ----------------------------
INSERT INTO `resto_tickets_lignes` VALUES ('1', 'XP00000001', 'TI20180419-001', 'E0002', '1', '65000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('2', 'XP00000001', 'TI20180419-001', 'E0003', '1', '10000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('3', 'XP00000001', 'TI20180419-001', 'P0003', '1', '131000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('4', 'XP00000001', 'TI20180419-001', 'P0006', '1', '88000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('5', 'XP00000001', 'TI20180419-002', 'E0002', '1', '65000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('6', 'XP00000001', 'TI20180419-002', 'E0003', '1', '10000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('7', 'XP00000001', 'TI20180419-002', 'P0003', '1', '131000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('8', 'XP00000001', 'TI20180419-003', 'E0002', '1', '65000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('9', 'XP00000001', 'TI20180419-003', 'E0003', '1', '10000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('10', 'XP00000001', 'TI20180419-003', 'P0003', '1', '131000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('11', 'XP00000001', 'TI20180419-001', 'B0002', '1', '3500', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('12', 'XP00000001', 'TI20180419-002', 'P0006', '1', '88000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('13', 'XP00000001', 'TI20180419-004', 'P0006', '1', '88000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('14', 'XP00000001', 'TI20180419-004', 'P0003', '1', '131000', 'S0P', '2');
INSERT INTO `resto_tickets_lignes` VALUES ('15', 'XP00000001', 'TI20180419-004', 'E0003', '1', '10000', 'S0P', '2');

-- ----------------------------
-- 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_hotel` varchar(10) default '',
  `num_bs_stock` varchar(20) default '',
  `fk_num_ticket` varchar(20) default NULL,
  `date_cmd` char(8) default '',
  `fk_code_item` char(5) default NULL,
  `fk_code_ingredient` varchar(20) default NULL,
  `qte_ingredient` decimal(13,2) default NULL,
  `qte_cmd` decimal(13,2) default NULL,
  `recette` char(1) default '0' COMMENT 'si recette=0 pas de recette 1 ingredient',
  `fk_code_packing` varchar(15) default '',
  `unit_packing` decimal(13,2) default NULL,
  `qte_conso` decimal(13,2) default NULL,
  `qte_conso_pac` decimal(13,4) default NULL,
  `fk_code_lieu` varchar(5) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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

-- ----------------------------
-- Table structure for resto_tickets_recap
-- ----------------------------
DROP TABLE IF EXISTS `resto_tickets_recap`;
CREATE TABLE `resto_tickets_recap` (
  `id` int(11) NOT NULL auto_increment,
  `fk_hotel_main` varchar(10) default '',
  `fk_hotel` varchar(10) default NULL,
  `num_doc` char(14) default NULL,
  `montant` decimal(13,2) default NULL,
  `adresse_mail` varchar(125) default NULL,
  `date_envoi` char(8) default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of resto_tickets_recap
-- ----------------------------

-- ----------------------------
-- 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(14) default NULL,
  `fk_mode_reglement` varchar(10) default NULL,
  `montant` decimal(13,2) 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,
  `ch_numero` varchar(25) default NULL COMMENT 'numéro de chèque',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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