/*
Navicat MySQL Data Transfer

Source Server         : MAISON
Source Server Version : 50626
Source Host           : localhost:3306
Source Database       : expertre_xx

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

Date: 2017-02-16 19:22:43
*/

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,
  `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;

-- ----------------------------
-- Records of resto_cat_menu
-- ----------------------------
INSERT INTO `resto_cat_menu` VALUES ('1', 'A', 'E', '1');
INSERT INTO `resto_cat_menu` VALUES ('2', 'A', 'P', '2');
INSERT INTO `resto_cat_menu` VALUES ('3', 'A', 'D', '3');
INSERT INTO `resto_cat_menu` VALUES ('4', 'A', 'B', '4');
INSERT INTO `resto_cat_menu` VALUES ('5', 'A', 'U', '5');
INSERT INTO `resto_cat_menu` VALUES ('6', 'A', 'F', '6');
INSERT INTO `resto_cat_menu` VALUES ('7', 'A', 'R', '7');
INSERT INTO `resto_cat_menu` VALUES ('8', '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,
  `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;

-- ----------------------------
-- Records of resto_cat_menu_lang
-- ----------------------------
INSERT INTO `resto_cat_menu_lang` VALUES ('1', 'FR', 'E', 'ENTRÉES');
INSERT INTO `resto_cat_menu_lang` VALUES ('2', 'EN', 'E', 'STARTERS');
INSERT INTO `resto_cat_menu_lang` VALUES ('3', 'FR', 'P', 'PLATS');
INSERT INTO `resto_cat_menu_lang` VALUES ('4', 'EN', 'P', 'MAIN COURSES');
INSERT INTO `resto_cat_menu_lang` VALUES ('5', 'FR', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('6', 'EN', 'D', 'DESSERTS');
INSERT INTO `resto_cat_menu_lang` VALUES ('7', 'FR', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('8', 'EN', 'B', 'BOISSONS');
INSERT INTO `resto_cat_menu_lang` VALUES ('9', 'FR', 'U', 'A L\'UNITÉ');
INSERT INTO `resto_cat_menu_lang` VALUES ('10', 'EN', 'U', 'SINGLE ITEM');
INSERT INTO `resto_cat_menu_lang` VALUES ('11', 'FR', 'F', 'FORMULES');
INSERT INTO `resto_cat_menu_lang` VALUES ('12', 'EN', 'F', 'SETS');
INSERT INTO `resto_cat_menu_lang` VALUES ('13', 'FR', 'R', 'SERVICE EN CHAMBRE');
INSERT INTO `resto_cat_menu_lang` VALUES ('14', 'EN', 'R', 'ROOM SERVICE');
INSERT INTO `resto_cat_menu_lang` VALUES ('15', 'EN', 'S', 'EXTRAS');
INSERT INTO `resto_cat_menu_lang` VALUES ('16', '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,
  `act` char(1) DEFAULT NULL,
  `fk_hotel` varchar(5) DEFAULT '',
  `fk_code_lieu` varchar(5) DEFAULT '',
  `fk_cat_code_menu` char(1) DEFAULT NULL,
  `photo` varchar(100) DEFAULT NULL,
  `code_plat` 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=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resto_items
-- ----------------------------
INSERT INTO `resto_items` VALUES ('1', 'A', 'IK', 'RES', 'E', null, 'E0001', null, null, '48.00', '0', '0');
INSERT INTO `resto_items` VALUES ('2', 'A', 'IK', 'RES', 'E', null, 'E0002', null, null, '65.00', '0', '0');
INSERT INTO `resto_items` VALUES ('3', 'A', 'IK', 'RES', 'P', null, 'P0001', null, null, '115.00', '0', '1');
INSERT INTO `resto_items` VALUES ('4', 'A', 'IK', 'RES', 'P', null, 'P0002', null, null, '125.00', '0', '1');
INSERT INTO `resto_items` VALUES ('5', 'A', 'IK', 'RES', 'P', null, 'P0003', null, null, '130.00', '0', '0');
INSERT INTO `resto_items` VALUES ('6', 'A', 'IK', 'RES', 'P', null, 'P0004', null, null, '95.00', '0', '1');
INSERT INTO `resto_items` VALUES ('7', 'A', 'IK', 'RES', 'P', null, 'P0005', null, null, '112.00', '0', '0');
INSERT INTO `resto_items` VALUES ('8', 'A', 'IK', 'RES', 'P', null, 'P0006', null, null, '88.00', '0', '0');
INSERT INTO `resto_items` VALUES ('9', 'A', 'IK', 'RES', 'P', null, 'P0007', null, null, '98.00', '0', '0');
INSERT INTO `resto_items` VALUES ('10', 'A', 'IK', 'RES', 'D', null, 'D0001', null, null, '25.00', '0', '0');
INSERT INTO `resto_items` VALUES ('11', 'A', 'IK', 'RES', 'D', null, 'D0002', null, null, '30.00', '0', '0');
INSERT INTO `resto_items` VALUES ('12', 'A', 'IK', 'RES', 'F', null, 'F0001', null, null, '250.00', '0', '0');
INSERT INTO `resto_items` VALUES ('13', 'A', 'IK', 'RES', 'B', null, 'B0001', null, null, '40.00', '0', '0');
INSERT INTO `resto_items` VALUES ('14', 'A', 'IK', 'RES', 'B', null, 'B0002', null, null, '35.00', '0', '0');
INSERT INTO `resto_items` VALUES ('15', 'A', 'IK', 'RES', 'B', null, 'B0003', null, null, '18.00', '0', '0');
INSERT INTO `resto_items` VALUES ('16', 'A', 'IK', 'RES', 'B', null, 'B0004', null, null, '30.00', '0', '0');
INSERT INTO `resto_items` VALUES ('17', 'A', 'IK', 'RES', 'B', null, 'B0005', null, null, '52.00', '0', '0');
INSERT INTO `resto_items` VALUES ('18', 'A', 'IK', 'RES', 'B', null, 'B0006', null, null, '45.00', '0', '0');
INSERT INTO `resto_items` VALUES ('19', 'A', 'IK', 'RES', 'B', null, 'B0007', null, null, '37.00', '0', '0');
INSERT INTO `resto_items` VALUES ('20', 'A', 'IK', 'RES', 'R', null, 'R0001', null, null, '85.00', '0', '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,
  `lang` char(2) DEFAULT NULL,
  `fk_code_plat` varchar(15) DEFAULT NULL,
  `intitule` varchar(100) DEFAULT NULL,
  `descro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

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

-- ----------------------------
-- 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,
  `entite` char(3) 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;

-- ----------------------------
-- Records of resto_lieux_de_vente
-- ----------------------------
INSERT INTO `resto_lieux_de_vente` VALUES ('2', 'IK', 'A', 'RES', '1', '7');
INSERT INTO `resto_lieux_de_vente` VALUES ('3', 'IK', 'A', 'MBA', '3', '0');
INSERT INTO `resto_lieux_de_vente` VALUES ('4', '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,
  `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;

-- ----------------------------
-- Records of resto_lieux_de_vente_lang
-- ----------------------------
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('1', 'FR', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('2', 'FR', 'CRE', 'CRÈPERIE');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('3', 'FR', 'MBA', 'MINI BAR');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('4', 'EN', 'RES', 'RESTAURANT');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('5', 'EN', 'CRE', 'CREPERY');
INSERT INTO `resto_lieux_de_vente_lang` VALUES ('6', 'EN', 'MBA', 'MINI BAR');

-- ----------------------------
-- Table structure for resto_tables
-- ----------------------------
DROP TABLE IF EXISTS `resto_tables`;
CREATE TABLE `resto_tables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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;

-- ----------------------------
-- Records of resto_tables
-- ----------------------------
INSERT INTO `resto_tables` VALUES ('1', 'A', '01', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('2', 'A', '02', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('3', 'A', '03', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('4', 'A', '04', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('5', 'A', '05', '2', 'RES');
INSERT INTO `resto_tables` VALUES ('6', 'A', '01', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('7', 'A', '02', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('8', 'A', '03', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('9', 'A', '04', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('10', 'A', '05', '2', 'CRE');
INSERT INTO `resto_tables` VALUES ('11', '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,
  `entite` char(3) DEFAULT NULL,
  `fk_code_lieu` char(3) DEFAULT NULL,
  `num_table` char(2) DEFAULT NULL,
  `fk_num_ticket` char(12) 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;

-- ----------------------------
-- Records of resto_tables_encours
-- ----------------------------
INSERT INTO `resto_tables_encours` VALUES ('1', 'XX', 'RES', '01', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('2', 'XX', 'RES', '02', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('3', 'XX', 'RES', '03', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('4', 'XX', 'RES', '04', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('5', 'XX', 'RES', '05', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('6', 'XX', 'RES', '06', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('7', 'XX', 'RES', '07', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('8', 'XX', 'RES', '08', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('9', 'XX', 'RES', '09', null, 'LIB', null, null, null, null, null, null, null, null);
INSERT INTO `resto_tables_encours` VALUES ('10', 'XX', '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,
  `entite` char(3) DEFAULT NULL,
  `fk_code_lieu` char(3) DEFAULT NULL,
  `numero` char(12) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resto_tickets
-- ----------------------------

-- ----------------------------
-- 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_num_ticket` char(13) DEFAULT NULL,
  `fk_code_plat` char(5) DEFAULT NULL,
  `prix_plat` decimal(10,0) DEFAULT NULL,
  `statut_plat` char(1) DEFAULT NULL COMMENT 'Indique l''�tat d''avancement de la commande',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resto_tickets_lignes
-- ----------------------------

-- ----------------------------
-- 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_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;

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