-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `adrili_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `conso`
--

CREATE TABLE `conso` (
  `id` int(11) NOT NULL,
  `consoid` varchar(255) NOT NULL,
  `menuid` varchar(255) NOT NULL,
  `prix` int(11) DEFAULT NULL,
  `quantite` int(11) NOT NULL,
  `montant` int(11) NOT NULL,
  `consofactureid` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `conso`
--

INSERT INTO `conso` (`id`, `consoid`, `menuid`, `prix`, `quantite`, `montant`, `consofactureid`, `status`) VALUES
(1, '7er4r44r4r4r4bv444bhb', 'dbe7f28e-df8e-482f-92ca-9917007520b7', 6000, 3, 18000, 'hshsds8s5ss41s2s5ss4s', 1),
(2, '7er4r44r4r4r4bf14v444bhb', 'e0a95574-30ba-4c80-8f0c-314405bb3574', 10000, 1, 10000, 'hshsds8s5ss41s2s5ss4s', 1);

-- --------------------------------------------------------

--
-- Table structure for table `consocoupon`
--

CREATE TABLE `consocoupon` (
  `id` int(11) NOT NULL,
  `consocouponid` varchar(255) NOT NULL,
  `consoid` varchar(255) NOT NULL,
  `couponid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `consofacture`
--

CREATE TABLE `consofacture` (
  `id` int(11) NOT NULL,
  `consofactureid` varchar(255) NOT NULL,
  `typeconso` int(11) NOT NULL COMMENT '1: encaissement\r\n2: Livraison \r\n3: Paiement direct \r\n4: Réservation',
  `restaurantid` varchar(255) NOT NULL,
  `userbeneid` varchar(255) DEFAULT NULL,
  `montanttotal` int(11) NOT NULL DEFAULT '0',
  `fraislivraison` int(11) NOT NULL DEFAULT '0',
  `montant` int(11) NOT NULL DEFAULT '0',
  `nfacture` varchar(255) DEFAULT NULL,
  `etatpay` int(11) NOT NULL DEFAULT '0' COMMENT '0: non soldé ; 1 : soldé',
  `datereglement` date DEFAULT NULL COMMENT 'date ou adrili à soldé les facture',
  `daterestau` datetime DEFAULT NULL COMMENT 'date insertion ligne coté restaurant',
  `datebene` datetime DEFAULT NULL COMMENT 'date insertion ligne coté bénéficiaire',
  `etatcommande` int(11) DEFAULT NULL COMMENT 'Etat commande (en attente: 1; en cours : 2; terminé : 3; annulé : 4)',
  `fraislivraisonid` int(11) DEFAULT NULL,
  `commentaire` varchar(500) DEFAULT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `consofacture`
--

INSERT INTO `consofacture` (`id`, `consofactureid`, `typeconso`, `restaurantid`, `userbeneid`, `montanttotal`, `fraislivraison`, `montant`, `nfacture`, `etatpay`, `datereglement`, `daterestau`, `datebene`, `etatcommande`, `fraislivraisonid`, `commentaire`, `createdon`, `status`) VALUES
(1, 'hshsds8s5ss41s2s5ss4s', 0, 'fd3c03c4-eff0-4590-94cf-56db80b8436c', 'a6a42ff2-8902-439c-e7be-395782a09ded', 1900, 0, 1900, '22FT0001', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-22 05:02:07', 1),
(2, 'hshsds8s5ss41s2s5ss4srgg22', 0, 'fd3c03c4-eff0-4590-94cf-56db80b8436c', 'a6a42ff2-8902-439c-e7be-395782a09ded', 5000, 0, 5000, '22FT0002', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-22 05:02:45', 1),
(4, '12b49fe8-40c8-4c6b-aa76-48afbf57af58', 1, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', NULL, 20000, 0, 20000, 'FT2200003', 0, NULL, '2022-07-29 00:00:00', NULL, 2, NULL, NULL, '2022-07-29 18:57:56', 1),
(5, '04c6e3f6-3de0-4a38-bc8b-41a2a887f88d', 1, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', 'f210bae9-f247-4cf4-beb5-f79606b9d7c5', 20000, 0, 20000, 'FT2200001', 0, NULL, '2022-07-29 00:00:00', '2022-07-29 00:00:00', 3, NULL, NULL, '2022-07-29 19:02:35', 1),
(6, 'e964458e-2582-44a7-dc5b-c8a6af94d7c6', 1, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', NULL, 8000, 0, 8000, 'FT2200002', 0, NULL, '2022-07-29 00:00:00', NULL, 2, NULL, NULL, '2022-07-29 19:33:35', 1),
(7, '04c6e3f6-3de0-4a38-bc8b-41a2a887f88d', 1, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '21528863-6faa-48ad-c408-5516803d564d', 15000, 0, 15000, 'FT2200001', 0, NULL, '2022-07-29 00:00:00', '2022-07-29 00:00:00', 3, NULL, NULL, '2022-07-29 19:02:35', 1);

-- --------------------------------------------------------

--
-- Table structure for table `consolivraison`
--

CREATE TABLE `consolivraison` (
  `id` int(11) NOT NULL,
  `consolivraisonid` varchar(255) NOT NULL,
  `consoid` varchar(255) NOT NULL,
  `menuid` varchar(255) NOT NULL,
  `fraislivraisonid` varchar(255) NOT NULL,
  `lieulivraison` varchar(255) NOT NULL,
  `heure` time NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL,
  `couponid` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `valeur` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `dateexpiration` date NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `coupon`
--

INSERT INTO `coupon` (`id`, `couponid`, `type`, `valeur`, `code`, `dateexpiration`, `createdon`, `createdby`, `status`) VALUES
(3, 'fd2edc9a-50b2-42a6-f65f-c7b92a8fc20c', 'MONTANT', 1000, NULL, '2022-09-18', '2022-09-18 13:14:02', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(4, '16a8313d-afcf-4b8f-cb3a-af33148f7afc', 'MONTANT', 1000, NULL, '2022-09-18', '2022-09-18 13:38:08', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(5, 'e63268c7-3c8e-40d6-99a1-7a1e42191c26', 'POURCENTAGE', 5, NULL, '2022-09-18', '2022-09-18 13:39:01', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, 'c34f4a3a-abbf-4d0e-d693-c2d620ec4103', 'MONTANT', 20000, NULL, '2022-09-18', '2022-09-18 13:39:15', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(7, '7f609235-580c-4c49-fa2f-4bec62050550', 'MONTANT', 20000, NULL, '2022-09-18', '2022-09-18 13:39:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(8, 'b3bd2eb8-1ef6-4cf5-bdcf-8c25193cf098', 'MONTANT', 1500, NULL, '2022-09-17', '2022-09-18 13:50:33', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(9, '8e3b580c-0448-48e1-b8d4-4d1b9fb004cc', 'MONTANT', 1500, 'dcdee', '2022-09-18', '2022-09-18 13:53:29', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(10, 'acd03371-ce77-47cb-eb78-d7c92b8bb336', 'MONTANT', 500, 'f5e24b02', '2022-09-15', '2022-09-18 14:06:01', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(11, '13a5b87b-67ca-4a54-a0eb-602961f2118d', 'MONTANT', 2000, 'F557ab2b', '2022-09-22', '2022-09-18 14:08:28', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(12, 'e1fa3f15-b7b2-48ba-882a-414c162d6836', 'MONTANT', 3000, '1FB51D4B', '2022-09-18', '2022-09-18 14:11:36', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(13, 'c7c9b40e-f463-4660-a5e3-9d3e5da76ddd', 'POURCENTAGE', 2, 'C3961107', '2022-09-18', '2022-09-18 14:12:30', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `departement`
--

CREATE TABLE `departement` (
  `id` int(11) NOT NULL,
  `departementid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `departement`
--

INSERT INTO `departement` (`id`, `departementid`, `libelle`, `entrepriseid`, `createdon`, `createdby`, `status`) VALUES
(1, '4ea93860-2018-42de-897c-aedeb9bb0994', 'Achat', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-05-29 13:32:11', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(2, '1076d737-d6d7-4fe7-9752-f6b15d61c062', 'mon libbelé', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-10 11:40:03', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, '731c5dd3-49b3-4ca6-8015-29cf3988c07c', 'mon libbelé', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-20 14:22:11', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, '6143a880-a94e-421d-dbe5-bfe6e4d7068b', 'Depart 2', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-08-14 14:33:53', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(5, '6839c462-c52e-421d-fd89-f174b9bc0cb6', 'Despart 1', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 16:21:08', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 1),
(6, 'a7f6b8e4-a7c3-435b-9055-ccde3ee8a67d', 'Depart 2', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 16:21:21', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 1),
(7, '529db934-5fa2-45de-9551-c5ff0064282b', 'gsgsgsgsggfvccffff', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 16:21:49', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0);

-- --------------------------------------------------------

--
-- Table structure for table `dotation`
--

CREATE TABLE `dotation` (
  `id` int(11) NOT NULL,
  `dotationid` varchar(255) NOT NULL,
  `montant` int(11) NOT NULL,
  `commentaire` varchar(255) NOT NULL,
  `userbeneid` varchar(255) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `datecreation` datetime NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dotation`
--

INSERT INTO `dotation` (`id`, `dotationid`, `montant`, `commentaire`, `userbeneid`, `entrepriseid`, `datecreation`, `createdon`, `createdby`, `status`) VALUES
(3, 'bb69b842-064e-4427-8aa6-5fcc518b4287', 5000, 'Commentaire', 'f210bae9-f247-4cf4-beb5-f79606b9d7c5', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-24 00:00:00', '2022-06-24 13:24:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, '34d4129c-292d-462a-80a1-b16f8d20c577', 5000, 'Commentaire', 'f210bae9-f247-4cf4-beb5-f79606b9d7c5', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-24 00:00:00', '2022-06-24 13:39:46', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, 'ae960808-19c5-45b8-98aa-7ebf2245de5d', 13000, 'Commentaire', '4464d372-a0e5-470c-bfb8-21652bb08b40', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-24 00:00:00', '2022-06-24 13:46:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '75d9b7e5-0807-45a2-8c7c-e10e8e86f2ea', 1000, 'gsggs 2', 'a6a42ff2-8902-439c-e7be-395782a09ded', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-27 00:00:00', '2022-06-26 13:39:42', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(7, 'b869c480-04b4-45ed-d0a6-903b45911762', 13000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 07:31:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(8, 'a41411b5-d173-4196-b7fc-6521548f6e8c', 12000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:08:11', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(9, '4a8d1dbb-b30b-4d8c-8084-345d71aa5255', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:08:36', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(10, '8ec98c9f-9c55-4ac3-be4f-6e6bbec15959', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:11:18', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(11, '9e21264f-ee67-4fe7-e79d-50b048c07ffb', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:13:48', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(12, '7924e8fd-2d1d-4f73-8ac8-3754fef015e8', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:30:55', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(13, '1dbe66b5-f270-40a5-dc02-8f3f980fda7e', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:31:24', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(14, 'bb30c6fe-cf72-42c5-955f-d9c1ba26ee27', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:50:41', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(15, 'b7ae8eb9-647a-49ec-9147-0f805e08a975', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:50:43', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(16, '3cb9699a-f591-47db-83d7-62b186405775', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:51:07', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(17, '1e828121-0800-4644-806a-fd7e9e4e52e0', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:51:52', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(18, 'e4f2c251-805c-47e6-eb38-ed9850afc506', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 08:52:33', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(19, '750f65e3-7dd2-4f48-bdbb-329e0461169f', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 00:00:00', '2022-06-30 09:32:12', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(20, 'f2238985-a211-4d39-a9f3-ebf0a3700b35', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 10:38:00', '2022-06-30 09:38:29', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(21, '9229e1c8-5e17-4578-c717-39e4cd3fd6c4', 5000, 'Commentaire', '21528863-6faa-48ad-c408-5516803d564d', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-30 11:41:00', '2022-06-30 09:42:03', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(22, '7f813ff3-a90d-4176-c919-4321938f7f3d', 10000, 'Commentaire', 'f0e44bd2-bf04-4684-e97f-18e574f362d1', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 19:39:00', '2022-08-14 17:39:23', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(23, '019c318e-9e52-4d45-b447-eb3c9e139e29', 10000, 'Commentaire', 'f0e44bd2-bf04-4684-e97f-18e574f362d1', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 19:48:00', '2022-08-14 17:49:40', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(24, '918f17a7-19f4-4eb7-e654-1febf588f3a4', 20000, 'Commentaire', '8de8eefc-5fbd-46eb-f2fa-40d2918431c6', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 20:36:00', '2022-08-14 18:36:56', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(25, 'dca38875-4676-415f-c21e-af667ed865c4', 15000, 'Commentaire', 'f0e44bd2-bf04-4684-e97f-18e574f362d1', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 21:07:00', '2022-08-14 19:07:51', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(26, '186ed33b-a266-4183-84e1-9f07bcd81a2d', 15000, 'Commentaire', '8de8eefc-5fbd-46eb-f2fa-40d2918431c6', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 21:07:00', '2022-08-14 19:08:14', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(27, '3a32518c-6423-443d-d768-a0c9277252c2', 15000, 'Commentaire', '12e4659e-ab45-41ec-ebdd-b0d05f8d5323', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 21:08:00', '2022-08-14 19:08:24', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(28, '72ba464b-5854-44d7-df08-f53d65acd890', 10000, 'Commentaire', 'f1962223-eddb-4f1b-f84d-746b17ebabc6', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 21:21:00', '2022-08-14 19:44:04', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 1),
(29, 'bd9eb915-7672-489a-f7e1-584aa0634baf', 5000, 'efff', '12e4659e-ab45-41ec-ebdd-b0d05f8d5323', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-09-04 17:13:00', '2022-09-04 15:13:28', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `entreprise`
--

CREATE TABLE `entreprise` (
  `id` int(11) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `contact1` varchar(255) NOT NULL,
  `contact2` varchar(255) NOT NULL,
  `rccm` varchar(255) NOT NULL,
  `secteurproid` varchar(255) NOT NULL,
  `nombreemploye` int(11) NOT NULL,
  `nombrebene` int(11) NOT NULL,
  `paysid` varchar(255) NOT NULL,
  `villeid` varchar(255) NOT NULL,
  `adresse` varchar(255) NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  `datecreation` date NOT NULL,
  `rib` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `solde` int(11) NOT NULL DEFAULT '0',
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entreprise`
--

INSERT INTO `entreprise` (`id`, `entrepriseid`, `nom`, `contact1`, `contact2`, `rccm`, `secteurproid`, `nombreemploye`, `nombrebene`, `paysid`, `villeid`, `adresse`, `longitude`, `latitude`, `datecreation`, `rib`, `logo`, `solde`, `createdon`, `createdby`, `status`) VALUES
(1, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'SYABE', 'Test', 'Test', 'Test', 'b8e66bf7-4afa-45dd-ae5a-58a7f474e2a1', 12, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'Test', -5.986787, 6.35354, '2022-05-09', 'Test477', NULL, -19000, '2022-05-25 01:42:38', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(3, '71c04eff-5c14-464b-fa04-4024899c315b', 'Entre 2', '555555', '78253667', 'rccm45221025447', 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 2, 4, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', -5.986787, 6.35354, '2022-06-16', '45210236577', NULL, 15000, '2022-06-16 12:19:35', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, '04HFFFF-5c14-464b-fa04-4024899c0', 'SYABE TECHNOLOGIE', '0768026868', '0101833833', 'rccm45221025448', 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 2, 4, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'ANGRE CHATEAU', -5.986787, 6.35354, '2022-06-16', '45210236577', NULL, 40000, '2022-06-16 12:19:35', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, '8ee653a2-a9be-4280-d8ed-33a196197bac', 'DJERA SERVICE', '524400', '78253667', 'rccm45221025447', 'b8e66bf7-4afa-45dd-ae5a-58a7f474e2a1', 10, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', -5.986787, 6.35354, '2022-08-18', 'Test111', 'no_image.png', 0, '2022-08-19 04:56:53', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '3882d5ca-8cc7-4057-ee67-590f338412a1', 'DJERA SERVICE 2', '555555', 'l5555', 'kififi', 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 10, 13, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 41454555, 55444444, '2022-08-18', '45210236577', 'no_image.png', 0, '2022-08-19 05:00:55', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(7, '5ffeced0-efb4-4c78-cd7a-b774306aa234', 'DJERA SERVICE 4', '555555', '754222', 'ghdyydydydy', 'b8e66bf7-4afa-45dd-ae5a-58a7f474e2a1', 2, 20, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 41454555, 55444444, '2022-08-18', '45210236577', 'no_image.png', 0, '2022-08-19 05:05:10', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(8, 'fb06d7fb-3cc2-4af6-ed37-9f5e13d01d27', 'DJERA SERVICE 5', '524400', '78253667', 'rccm45221025447', 'b8e66bf7-4afa-45dd-ae5a-58a7f474e2a1', 1, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 41454555, 55444444, '2022-08-17', '45210236577', 'TOjk0GvCLPXtLz6tLdihdXH0mxgiKVeQOG3GrN37.png', 0, '2022-08-19 05:06:36', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(9, 'b6318a64-2b62-4fed-ba8c-c6f7b95b8481', 'DJERA SERVICE 5', '524400', '754222', 'rccm45221025447', 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 2, 13, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 52444, 4444, '2022-08-19', '45210236577', 'CqkKtzSitRkUJrJlWD7YeCWdZ4y0Im1PuS5LkEUS.jpg', 0, '2022-08-19 05:07:51', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(10, '471135fa-2a65-447a-cfc6-0f453fead38a', 'DJERA SERVICE 5', '524400', '754222', 'rccm45221025447', 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 2, 13, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 524445235565, 4444, '2022-08-19', '45210236577', 'svEn6n9UHw3gVzhjpnYCzyc1oCSZaoMGNryObGFc.jpg', 0, '2022-08-19 05:21:53', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `fraislivraison`
--

CREATE TABLE `fraislivraison` (
  `id` int(11) NOT NULL,
  `fraislivraisonid` varchar(255) NOT NULL,
  `zone` varchar(255) NOT NULL,
  `prix` int(11) NOT NULL,
  `restaurantid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fraislivraison`
--

INSERT INTO `fraislivraison` (`id`, `fraislivraisonid`, `zone`, `prix`, `restaurantid`, `createdon`, `createdby`, `status`) VALUES
(1, 'jdjdhryrggg5420jfhjf', 'Zone 1', 5000, '3d90e882-f22a-4748-bf04-620de549178e', '2022-06-09 12:53:44', '', 1),
(2, 'c5ff231b-6604-4bc9-f765-6a77c2bd5096', 'Zone Sud', 2400, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-06-09 13:35:25', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, '836ed3e7-2785-492b-ab9f-f496d3f6ae22', 'Zone 3', 5000, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-06-09 14:23:50', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, 'ea3ebdcb-10c4-4f9d-aa4c-1b38ba588f01', 'Zone Sud', 5000, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-07-05 16:45:36', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, 'da23c9ba-cf44-4ad1-e816-e32f87fc308a', 'Zone Nord', 10000, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-07-05 16:46:35', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '28e1d925-0017-4757-a44b-1521a301af2b', 'Zone Sud', 5000, '51732956-8c8e-40e7-e180-cda928813ca7', '2022-07-05 17:19:50', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `id` int(11) NOT NULL,
  `logid` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `module` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `menuid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `restaurantid` varchar(255) NOT NULL,
  `typemenuid` varchar(255) NOT NULL,
  `prix` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `menuid`, `libelle`, `description`, `restaurantid`, `typemenuid`, `prix`, `photo`, `createdon`, `createdby`, `status`) VALUES
(1, 'hsghsgdhhdhdhdhdd5d4d2d', 'Menu 1', 'Descrr menu', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '484f2f51-1f6b-4057-84b5-837532d6b796', 1000, '', '2022-06-07 14:13:03', '', 0),
(3, 'f629c687-bf0b-4f45-b9fa-ffb6a470fd20', 'Menu 1', 'Descr 1', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'hshsbgdgfefefrggrgr45r', 1000, '', '2022-06-07 17:42:32', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, 'e3ac914b-27c8-4db0-ac66-46a0c5c4934d', 'Menu 2', 'Descr 2', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'fa1b3b9f-278f-468e-abba-99c46044ec70', 1500, '', '2022-06-07 17:54:21', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, '1a404268-2d20-420e-ad6e-15476b710809', 'Menu 3', 'Descr 3', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'fa1b3b9f-278f-468e-abba-99c46044ec70', 2000, '', '2022-06-07 18:12:38', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '7185298b-3d93-4c2d-dcbe-6127f1752ea9', 'Menu 3', 'Descr 3', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'hshsbgd774gfefefrggrgr45r', 1000, '', '2022-06-07 18:12:39', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(7, '0c378caf-a825-40e5-fef0-522bef6d8e83', 'Menu 12', 'Descr 12', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'hshsbgd774gfefefrggrgr45r', 500, '', '2022-06-08 18:24:28', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(8, 'e0a95574-30ba-4c80-8f0c-314405bb3574', 'Riz sauce graine', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', 'hshsbgdgfefefrggrgr45r', 1000, '', '2022-06-08 21:05:14', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(9, 'c4bfcf7f-e334-4a22-a488-84c9bc5796e7', 'mon libbelé 2', 'Softhotels', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'fa1b3b9f-278f-468e-abba-99c46044ec70', 1000, '', '2022-06-14 15:20:45', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(10, 'dbe7f28e-df8e-482f-92ca-9917007520b7', 'mon libbelé 2', 'Softhotels', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'hshsbgd774gfefefrggrgr45r', 5000, '', '2022-06-14 15:23:04', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(11, '46c0f25e-e6c5-4d19-9177-d5a41ec8151b', 'Menu 3', 'descr 3', '51732956-8c8e-40e7-e180-cda928813ca7', '3e643900-cd2a-4519-a3c9-51b167636bd9', 1500, '', '2022-06-23 21:10:16', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(12, 'd0cc3424-6e89-4957-feae-b58cba10f6dd', 'mon libbelé 2', 'Descr 2', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', 'hshsbgd774gfefefrggrgr45r', 2500, '', '2022-07-05 17:19:24', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(13, '56c59408-ec9a-4fd8-d4f9-d57c975bcc25', 'mon libbelé', 'siteweb appligel', '51732956-8c8e-40e7-e180-cda928813ca7', '3e643900-cd2a-4519-a3c9-51b167636bd9', 2500, '', '2022-07-05 17:20:41', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(14, 'a650d423-e195-4d23-e62e-31683c38fde9', 'Menu', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 5677, '', '2022-07-17 15:40:25', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(15, '017a80ba-ba66-483f-eb5d-fb199910df20', 'Menu', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 5000, 'mPEzgXsqWdRlTXaWXgHZMJCrOUbbFfGyYU2CY6t1.jpg', '2022-07-17 16:10:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(16, '253b8c13-dc08-4d7a-de6c-f2079dfaa758', 'Menu 6', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 20000, 'B8S23eDCl7Xk2WkMqakK600hiVt3TK0vVpIxVPeL.jpg', '2022-07-17 16:32:07', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(17, 'aab5883c-429c-40df-ac67-27600175399f', 'Menu 7', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 50000, 'wwuVXLfpFToC0sDRKHBxl4my3dooGbtsdr8JxwZq.jpg', '2022-07-17 16:51:33', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(18, '99f64e79-6807-4b34-daf3-4cd0a249d345', 'Menu 1', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 3555, 'FE88jHAezLUHpIhtnEsWnG8jf3mOVVjF6xXaqVdp.png', '2022-07-17 17:09:36', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(19, 'a976d1c1-4010-44a4-84cc-832ea57919cf', 'mon libbelé', 'siteweb appligel', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 2500, 'y2BcZUEJS7nZrLMiRdhPcp7almBL22dpf7OUVN5u.jpg', '2022-07-21 05:13:45', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(20, '439b699e-a297-4ba7-9109-a99ffecb24fd', 'mon libbelé', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 2400, '', '2022-07-21 05:23:54', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(21, '1dd57257-88a5-45a4-ff54-c96716c285d6', 'mon libbelé 2', 'Softhotels', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 5000, 'no_image.png', '2022-07-21 05:49:03', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(22, '9d14c40c-ddf1-42f3-d6d3-98ed0eca0fa1', 'mon libbelé', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 2400, 'no_image.png', '2022-07-21 07:45:19', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(23, '54bfc60a-f390-456e-ba1c-976ca2a8c98e', 'Béninois', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 412, '86ydSfnE4vSRupbpEjkTN1y9gqTuZFM7fLFSV4vg.png', '2022-07-21 07:48:54', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(24, '4e42aacd-9b06-4499-bd21-9409b7321ba9', 'mon libbelé1', 'siteweb appligel', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 2400, 'SeLKYjBVY0dZH2Tco93Fsk6TK3VUZXESDvWZ8qdb.jpg', '2022-07-21 07:52:47', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(25, '013f77e0-635d-413b-d05a-b4f9d25cc29b', 'mon libbelé 2', 'siteweb appligel', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 5000, 'P1k9Ju3ioiIqjS0mT7zNxdjV8wWX4ilEmLZVVz7Q.png', '2022-07-21 08:12:54', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(26, 'c1c3698a-cd69-4392-9c38-7dd9fda6cd2d', 'mon libbelé', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 2400, 'QgidbKlhwUKEBq5rBtTPz173BpysNPQNSyOQXHsZ.png', '2022-07-21 08:20:16', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(27, '5fa63065-effe-4afc-8503-1377436db828', 'mon libbelé1', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 2500, 'SGnyTLkKFMMNXPl4CLyTddH5Q3IdyHWXBp88Afoz.png', '2022-07-21 08:23:03', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(28, '84fff381-8007-445a-a7aa-fb69fefd7e7c', 'Béninois', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 2400, 'no_image.png', '2022-07-21 09:30:37', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(29, '7b75bd47-6475-4f1c-f37b-20d198b4ff10', 'mon libbelé 2', 'siteweb appligel', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 2400, 'no_image.png', '2022-07-21 09:31:06', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(30, '9717b76d-4c7b-4c17-f287-c9d6d3dac2a0', 'mon libbelé', 'Pas trop bon', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 5000, 'no_image.png', '2022-07-21 09:35:10', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(31, '4d6fd80d-90ad-422f-df99-9cbe7f38fe28', 'mon libbelé 2', 'siteweb appligel', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 2400, 'no_image.png', '2022-07-21 09:35:34', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(32, '3bd490d9-3459-4d8b-aecc-2cf0f90061e0', 'mon libbelé 2', 'Pas trop bon', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 5000, 'tfjQloJlLehvOjkC9acPifAp9AoUZX8pD5NpwzYI.jpg', '2022-07-21 09:36:46', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(33, '6c91d4e4-4cbb-4ea5-b7ff-c4679ff87d9a', 'mon libbelé 2', 'Softhotels', '51732956-8c8e-40e7-e180-cda928813ca7', '3e643900-cd2a-4519-a3c9-51b167636bd9', 5000, 'no_image.png', '2022-07-21 09:45:10', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(34, '99e6b723-13c9-4691-eba9-db8cfe27620b', 'mon libbelé', 'Descr 2', '51732956-8c8e-40e7-e180-cda928813ca7', '3e643900-cd2a-4519-a3c9-51b167636bd9', 5000, 'no_image.png', '2022-07-21 09:45:32', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(35, '5edd9fe8-14f1-4c44-9f04-e64fa3c2caa8', 'Menu 1', 'Descr', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '607eb969-c1eb-44ae-9915-dda68dc60714', 100, 'ZOr7d6Ltp4LhdOqiPfPfQrFWZ23BoloOamw2ZALo.jpg', '2022-08-21 15:42:22', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(36, 'a187097e-ce5f-4c6d-b2dc-df1e908c71b9', 'mon libbelé', 'Descr', '51732956-8c8e-40e7-e180-cda928813ca7', '3e643900-cd2a-4519-a3c9-51b167636bd9', 1000, 'no_image.png', '2022-08-19 04:07:55', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `pays`
--

CREATE TABLE `pays` (
  `id` int(11) NOT NULL,
  `paysid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pays`
--

INSERT INTO `pays` (`id`, `paysid`, `libelle`, `createdon`, `createdby`, `status`) VALUES
(1, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', 'Cote d\'Ivoire', '2022-05-25 01:47:16', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, 'f69dbe3e-dd8b-4240-ae14-eebf3167ab5a', 'mon libbelé', '2022-06-09 18:38:23', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `rechargement`
--

CREATE TABLE `rechargement` (
  `id` int(11) NOT NULL,
  `rechargementid` varchar(255) NOT NULL,
  `montant` int(11) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `commentaire` varchar(255) NOT NULL,
  `datecreation` date NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rechargement`
--

INSERT INTO `rechargement` (`id`, `rechargementid`, `montant`, `entrepriseid`, `commentaire`, `datecreation`, `createdon`, `createdby`, `status`) VALUES
(10, '18a19eec-98b4-415c-c909-24649852b18e', 10, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'gsggs', '2022-06-26', '2022-06-26 13:08:34', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(11, 'c0c2f789-41f7-40dc-e58b-6c8adec31383', 1000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'gsggs 2', '2022-06-26', '2022-06-26 13:09:04', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(12, 'f6ba100c-5210-4e69-a934-1a2294ab5b7f', 10000, '71c04eff-5c14-464b-fa04-4024899c315b', 'gsggs', '2022-06-26', '2022-06-26 13:09:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(13, '02f9a807-92eb-41e6-a8df-6c7643a20ce2', 5000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'gsggs', '2022-06-28', '2022-06-26 15:08:28', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(14, '538f7a60-2713-4e2a-f83e-02bd1d8ca0b7', 10000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'gsggs', '2022-06-26', '2022-06-26 15:22:42', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(15, '9eb9915e-3f95-4374-d927-b3bf3ffb4f34', 2000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'gsggs 2', '2022-06-26', '2022-06-26 15:22:59', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(16, 'c773b04a-1d0a-42fb-9c99-24c737c89d17', 11000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 'Commentaire', '2022-06-30', '2022-06-30 07:29:48', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(17, '69a7759d-d09a-4a66-ade0-cb7e86d57e25', 35000, '71c04eff-5c14-464b-fa04-4024899c315b', 'ras', '2022-08-06', '2022-08-06 03:42:02', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(18, '41b4ae99-be4d-4257-d6d4-1642335e7b70', 5000, '04HFFFF-5c14-464b-fa04-4024899c0', 'efff', '2022-09-04', '2022-09-04 15:09:58', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `restaurant`
--

CREATE TABLE `restaurant` (
  `id` int(11) NOT NULL,
  `restaurantid` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `rccm` varchar(255) NOT NULL,
  `prixmin` int(11) NOT NULL,
  `prixmax` int(11) NOT NULL,
  `paysid` varchar(255) NOT NULL,
  `villeid` varchar(255) NOT NULL,
  `adresse` varchar(255) NOT NULL,
  `zone` varchar(255) NOT NULL,
  `livraison` int(11) NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  `certificatsalubrite` varchar(255) NOT NULL DEFAULT 'OUI',
  `certificatexpiration` date NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `nomgerant` varchar(255) DEFAULT NULL,
  `moyenpay` varchar(255) DEFAULT NULL,
  `detailsmoyenpay` varchar(255) DEFAULT NULL,
  `frequence` varchar(255) DEFAULT NULL,
  `commission` int(11) DEFAULT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `restaurant`
--

INSERT INTO `restaurant` (`id`, `restaurantid`, `nom`, `contact`, `rccm`, `prixmin`, `prixmax`, `paysid`, `villeid`, `adresse`, `zone`, `livraison`, `longitude`, `latitude`, `certificatsalubrite`, `certificatexpiration`, `logo`, `nomgerant`, `moyenpay`, `detailsmoyenpay`, `frequence`, `commission`, `createdon`, `createdby`, `status`) VALUES
(1, 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', 'Restau2', '85745', 'rccm45221025447', 4, 4, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'Niangon sud', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-06-18', NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-06 09:28:11', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(2, '3d90e882-f22a-4748-bf04-620de549178e', 'DAGO LAYE HENOCH STAEPHANE', '05015943', 'rccm45221025447', 5, 6, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-06-19', NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-06 14:27:30', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, '9991fe7e-cd99-4ac7-af69-e454ed64ae90', 'Resto 1', '05015943', 'rccm45221025447', 4, 15, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-06-20', 'wig8heY4Y6GO8JIEmd0D6xDUi0a2ehRxCSm4PyIm.png', 'mon gerent', 'ESPECES', '2g4g56hj5h45hh74', '7', NULL, '2022-06-08 20:51:25', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, 'fd3c03c4-eff0-4590-94cf-56db80b8436c', 'Restao 2', '05015943', 'rccm45221025447', 4, 9, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-06-25', NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-09 19:32:21', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, '51732956-8c8e-40e7-e180-cda928813ca7', 'Restau 3', '0777007239', 'rccm333333333', 33333, 4444, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-06-23', NULL, NULL, NULL, NULL, NULL, NULL, '2022-06-23 21:07:53', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '49262940-55d1-4f5e-bb2d-f28350ed72db', 'DAGO LAYE HENOCH STAEPHANE', '05015943', 'hydhdhdhdh', 100, 100, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone 1', 0, 41454555, 6.35354, 'OUI', '2022-07-23', NULL, NULL, NULL, NULL, NULL, NULL, '2022-07-23 21:52:30', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(7, 'ccd4f6ca-5c7d-4ca7-b755-0ade3e66fbc2', 'DAGO LAYE HENOCH STAEPHANE', '05015943', 'rccm45221025447', 100, 100, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 55444444, 'OUI', '2022-07-23', NULL, NULL, NULL, NULL, NULL, NULL, '2022-07-23 21:55:32', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(8, '46136ee6-eb53-4088-83c5-b01c62406115', 'Restau 4', '05015943', 'rccm45221025447', 100, 200, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'abidjan23', 'Zone Sud', 0, -5.986787, 55444444, 'OUI', '2022-07-23', NULL, NULL, NULL, NULL, NULL, NULL, '2022-07-23 21:57:21', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(9, '3e958bf8-9831-42c3-ebc4-0040c763b461', 'restau 3', '05015943', 'rccm45221025447', 2, 3, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Nord', 0, -5.986787, 6.35354, 'OUI', '2022-07-23', NULL, NULL, NULL, NULL, NULL, NULL, '2022-07-23 22:47:00', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(10, '0c093734-635a-4cc2-8564-745eaaea070d', 'Amazon', '05015943', 'rccm45221025447', 12, 13, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 6.35354, 'NON', '2022-08-12', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-21 14:14:18', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(11, '3cb72c86-7346-46bb-9462-92e848fe8541', 'Djera 10', '05015943', 'rccm45221025447', 12, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 'ABIDJAN', 0, -5.986787, 55444444, 'OUI', '2022-08-24', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-24 19:00:34', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(12, '47e3c7da-1f3b-4613-9d32-90ea35c92f8b', 'Djera111', '05015943', 'rccm45221025447', 12, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 'ABIDJAN', 0, -5.986787, 6.35354, 'OUI', '2022-08-24', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-24 19:02:43', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(13, '0fd7ce17-fa5f-401c-ff28-71192715e31c', 'Djerer12', '05015943', 'rccm45221025447', 11, 10, 'f69dbe3e-dd8b-4240-ae14-eebf3167ab5a', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 'ABIDJAN', 0, 5555, 55444444, 'OUI', '2022-08-24', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-24 19:05:10', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(14, 'ce6f4be5-3c89-48fa-cf5b-a7d439cbe5a9', 'DJERA SERVICE', '05015943', 'rccm45221025447', 10, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 'ABIDJAN', 0, -5.986787, 55444444, 'OUI', '2022-08-25', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-24 19:06:05', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(15, 'e4bde479-922d-46ac-c8d0-901d305e9b2f', 'DJERA SERVICE 5', '05015943', 'Test', 12, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON', 'ABIDJAN', 0, -5.986787, 6.35354, 'OUI', '2022-08-24', NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-24 19:27:52', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(19, 'cdafa0dc-9aa7-46be-c9ac-40107f51a916', 'LAYE HENOCH STEPHANE DAGO', '05015943', 'rccm45221025447', 10, 10, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON', 'GAGNOA', 0, -5.986787, 6.35354, 'OUI', '2022-08-24', 's2lXUhtcn5KA7ogiG1E54YkOafeiCbg22Sg2t8W6.jpg', 'mon gerent', 'ORANGE MONEY', '2g4g56hj5h45hhgvf', '12', NULL, '2022-08-24 20:37:26', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(20, 'b70217a5-df59-4d60-91a5-5058b58368d5', 'DJERA SERVICE 5gsfs', '05015943', 'rccm45221025447', 56, 12, 'f69dbe3e-dd8b-4240-ae14-eebf3167ab5a', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 0, -5.986787, 6.35354, 'OUI', '2022-09-04', 'KW4jZjb99x6aDka2aaqF8JmSz4CcVlMBAteFRd1q.jpg', 'mon gerent', 'ESPECES', '2g4g56hj5h45hh74', '3', NULL, '2022-09-04 13:59:03', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(21, 'c0bb88e6-9359-49e3-ece8-8876f1d4ad70', 'ggsvscfc', '05015943', 'rccm45221025447', 223, 233, 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '15267d18-f57f-4bc1-8ac3-800eb42085df', 'YOPOUGON NIANGON, ABIDJAN', 'Zone Sud', 1, 524445, 4444, 'OUI', '2022-09-09', 'no_image.png', 'mon gerent', 'CHEQUE', '2g4g56hj5h45hh74', '23', NULL, '2022-09-04 14:00:02', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `restautypecuisine`
--

CREATE TABLE `restautypecuisine` (
  `id` int(11) NOT NULL,
  `restautypecuisineid` varchar(255) NOT NULL,
  `restaurantid` varchar(255) NOT NULL,
  `typecuisineid` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `restautypecuisine`
--

INSERT INTO `restautypecuisine` (`id`, `restautypecuisineid`, `restaurantid`, `typecuisineid`, `status`) VALUES
(10, '92462c7a-a7d1-4dd3-f83b-3b9afcfff539', '3e958bf8-9831-42c3-ebc4-0040c763b461', '339aed47-f3e0-45dd-bd66-06ab910df048', 1),
(11, '6a445eac-d9ca-4117-8b46-2e88bfb9af50', '3e958bf8-9831-42c3-ebc4-0040c763b461', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(12, '84416fb2-acee-4318-9aa9-ed4fa833f0b8', '3e958bf8-9831-42c3-ebc4-0040c763b461', '543f2bc6-7b68-451e-cc39-2b27ca35a777', 1),
(13, '9a3ea45a-d0ec-4b2b-f086-8e7f023a3c18', '0c093734-635a-4cc2-8564-745eaaea070d', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(14, '3b95f6e1-4964-4334-af7e-ff4fc79b3179', '3cb72c86-7346-46bb-9462-92e848fe8541', '339aed47-f3e0-45dd-bd66-06ab910df048', 1),
(15, 'd2af0471-3425-4db5-f2f6-b55c8ec921ed', '47e3c7da-1f3b-4613-9d32-90ea35c92f8b', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(16, '97490c60-498c-4dbb-d2cf-52aabfe72272', '0fd7ce17-fa5f-401c-ff28-71192715e31c', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(17, 'e49922ea-3d82-4a2d-bc71-5fabaa6027ac', 'ce6f4be5-3c89-48fa-cf5b-a7d439cbe5a9', '339aed47-f3e0-45dd-bd66-06ab910df048', 1),
(18, '1406c0fa-15f7-49bd-c497-77c57ce976fb', 'e4bde479-922d-46ac-c8d0-901d305e9b2f', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(19, 'c8e783c8-9580-43d8-c017-8f5ce8ae7729', '8f8e31d5-0bf8-415d-8c98-3b03e26cc753', '339aed47-f3e0-45dd-bd66-06ab910df048', 1),
(21, 'dc4863c8-5a7e-41f2-a107-284282e987f3', '5ee26d26-0a82-4277-94ee-153cc7da7201', '339aed47-f3e0-45dd-bd66-06ab910df048', 1),
(24, '525dd809-24ed-4b44-cc73-801694d1964b', '9d640fe3-324b-4ec0-a314-30d0d6c08512', 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 1),
(33, '21378644-ed89-47f0-dc19-2278e4a380c6', 'cdafa0dc-9aa7-46be-c9ac-40107f51a916', '', 1),
(34, '476ea2ff-2cbf-450f-92f0-fb385fce4b25', 'b70217a5-df59-4d60-91a5-5058b58368d5', '', 1),
(35, '3a780988-547f-4948-836d-411ff73f8a5d', 'c0bb88e6-9359-49e3-ece8-8876f1d4ad70', '', 1),
(36, '22dd8465-f1c9-479a-da6d-86c7fc0309fa', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `roleadrili`
--

CREATE TABLE `roleadrili` (
  `id` int(11) NOT NULL,
  `roleadriliid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roleadrili`
--

INSERT INTO `roleadrili` (`id`, `roleadriliid`, `libelle`, `description`, `createdon`, `createdby`, `status`) VALUES
(1, 'cce549ed-db3c-46af-b8e9-d655a81b3c4e', 'Administrateur', 'RAS', '2022-05-29 13:14:02', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(2, 'c734eb4a-1c72-4fb1-e9fd-9673b9dfd3dd', 'mon libbelé', 'Softhotels', '2022-06-11 10:24:35', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, '4f2da89a-34c3-4ce7-80a4-8adf2f548ba0', 'Sous admin', 'Descr', '2022-06-11 10:31:58', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `rolebene`
--

CREATE TABLE `rolebene` (
  `id` int(11) NOT NULL,
  `rolebeneid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `heuredebut` time NOT NULL,
  `heurefin` time NOT NULL,
  `plafond` int(11) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `transfertargent` int(11) NOT NULL DEFAULT '0',
  `recevoirargent` int(11) NOT NULL DEFAULT '0',
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rolebene`
--

INSERT INTO `rolebene` (`id`, `rolebeneid`, `libelle`, `description`, `heuredebut`, `heurefin`, `plafond`, `entrepriseid`, `transfertargent`, `recevoirargent`, `createdon`, `createdby`, `status`) VALUES
(1, '964b125c-9306-4799-8468-b77e04e31a10', 'Junior', 'RAS', '07:00:00', '16:00:00', 10000, '4464d372-a0e5-470c-bfb8-21652bb08b40', 1, 1, '2022-05-29 13:29:42', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(2, 'a9d14794-022a-4b85-da9a-ac978777622b', 'Role 2', 'Descr 2', '23:02:00', '23:05:00', 4, '4464d372-a0e5-470c-bfb8-21652bb08b40', 0, 0, '2022-06-10 22:03:13', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, '287d4083-cb95-4492-be43-31bb2ade6776', 'Role 2', 'Desc 2', '23:38:00', '02:43:00', 10, '4464d372-a0e5-470c-bfb8-21652bb08b40', 0, 0, '2022-06-10 22:39:07', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(4, '2053df6b-d505-4406-a421-655dd0014210', 'mon libbelé', 'Softhotels', '01:24:00', '06:22:00', 4, '71c04eff-5c14-464b-fa04-4024899c315b', 0, 0, '2022-06-23 00:22:21', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(5, '2c519226-f677-44d8-93c1-c6d415dc155e', 'Role 1', 'Descr 111', '16:56:00', '20:56:00', 1000, '04HFFFF-5c14-464b-fa04-4024899c0', 0, 0, '2022-08-14 16:56:52', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 1),
(6, '89c82eb5-552e-4604-ca04-097a33c99ff2', 'zzzzzzzzzzzzzz', 'Descr 1', '16:57:00', '16:58:00', 2555, '04HFFFF-5c14-464b-fa04-4024899c0', 0, 0, '2022-08-14 16:57:16', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 0),
(7, '6b94187b-f096-4307-f674-5814ed6f2bb1', 'Role 2', 'Descr 2', '18:01:00', '17:06:00', 3000, '04HFFFF-5c14-464b-fa04-4024899c0', 0, 0, '2022-08-14 17:01:26', 'c1a059ae-aa38-4fb9-fa44-9c1537a9286b', 1),
(8, '09be5168-95b9-43e9-e8e2-571bb43e9639', 'Menu 1', 'gxgxgxggx', '13:43:00', '13:44:00', 3, '4464d372-a0e5-470c-bfb8-21652bb08b40', 1, 1, '2022-10-09 13:43:26', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(9, 'c619b897-f3c7-4d6a-bbdc-e03851866e1a', 'Menu 1', 'Descr 1', '14:06:00', '14:06:00', 4, '471135fa-2a65-447a-cfc6-0f453fead38a', 1, 1, '2022-10-09 14:06:29', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `roleentreprise`
--

CREATE TABLE `roleentreprise` (
  `id` int(11) NOT NULL,
  `roleentrepriseid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `entrepriseid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roleentreprise`
--

INSERT INTO `roleentreprise` (`id`, `roleentrepriseid`, `libelle`, `description`, `entrepriseid`, `createdon`, `createdby`, `status`) VALUES
(1, '4df10f22-e4c7-46b2-9d00-0bcf3c4efbd6', 'Administrateur', 'RAS', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-05-29 13:15:42', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(2, '10b44eb7-00bb-4382-9d38-9801e57336b9', 'mon libbelé', 'Softhotels', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-10 23:17:06', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(3, 'da3e0e22-f9fd-4ba6-da2d-9e63ea30fb17', 'mon libbelé', 'Softhotels', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-10 23:17:53', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(4, '41235509-f27d-4e80-8f8a-0a91601ef0ef', 'Sous admin', 'Gérer le sous mentor', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-06-10 23:40:16', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(5, 'fd82b43d-23e2-4db4-dba3-61264bbb4120', 'mon libbelé', 'Softhotels', '71c04eff-5c14-464b-fa04-4024899c315b', '2022-06-20 14:34:46', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(6, '303f0976-dd2a-409a-8daf-a9d0d7887729', 'Sous admin', 'RAS', '4464d372-a0e5-470c-bfb8-21652bb08b40', '2022-08-05 15:08:03', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(7, 'gdf543za-dd2a-409a-8daf-a9d0d7887729', 'Sous admin', 'RAS', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-05 15:08:03', '87981319-919a-4ac1-80d2-fc858a0a6f53', 1),
(8, 'b545578b-90a2-418f-855e-430faa3018b1', 'Role 2', 'Descr 2', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 15:39:08', 'ffdfdf6-9fe1-44ba-a03a-00304BFD', 1),
(9, '4cbf335e-7dcc-429b-c247-3a96dce3250f', 'gdggdggdg', 'gxgxgxggx', '04HFFFF-5c14-464b-fa04-4024899c0', '2022-08-14 15:47:54', 'ffdfdf6-9fe1-44ba-a03a-00304BFD', 0);

-- --------------------------------------------------------

--
-- Table structure for table `secteurpro`
--

CREATE TABLE `secteurpro` (
  `id` int(11) NOT NULL,
  `secteurproid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `secteurpro`
--

INSERT INTO `secteurpro` (`id`, `secteurproid`, `libelle`, `createdon`, `createdby`, `status`) VALUES
(1, 'b8e66bf7-4afa-45dd-ae5a-58a7f474e2a1', 'Batiment', '2022-05-25 01:51:05', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(2, 'b8e66bf7-4afa-45dd-ae5a-38a7f484e2f0', 'Construction', '2022-05-25 01:51:05', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(3, '099cbc49-91a5-40bb-9687-d05c1e6a526a', 'mon libbelé 2', '2022-06-06 11:12:23', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0);

-- --------------------------------------------------------

--
-- Table structure for table `transfertbene`
--

CREATE TABLE `transfertbene` (
  `id` int(11) NOT NULL,
  `transfertbeneid` varchar(255) NOT NULL,
  `emetteurid` varchar(255) NOT NULL COMMENT 'userbeneid',
  `destinateurid` varchar(255) NOT NULL COMMENT 'userbeneid',
  `montant` int(11) NOT NULL,
  `datetransfert` datetime NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transfertbene`
--

INSERT INTO `transfertbene` (`id`, `transfertbeneid`, `emetteurid`, `destinateurid`, `montant`, `datetransfert`, `createdon`, `status`) VALUES
(1, 'be054bda-577b-4613-8817-509440ba7b9e', 'a6a42ff2-8902-439c-e7be-395782a09ded', 'f210bae9-f247-4cf4-beb5-f79606b9d7c5', 200, '2022-10-16 14:47:16', '2022-10-16 14:47:16', 1);

-- --------------------------------------------------------

--
-- Table structure for table `typecuisine`
--

CREATE TABLE `typecuisine` (
  `id` int(11) NOT NULL,
  `typecuisineid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `typecuisine`
--

INSERT INTO `typecuisine` (`id`, `typecuisineid`, `libelle`, `description`, `createdon`, `createdby`, `status`) VALUES
(1, '339aed47-f3e0-45dd-bd66-06ab910df048', 'IVOIRIEN', 'Super cuisine', '2022-06-06 09:25:56', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(2, 'eb1ff153-1b54-4afa-96f3-b31a6f19e7fb', 'Marocain', 'Softhotels', '2022-06-09 18:39:12', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(3, '543f2bc6-7b68-451e-cc39-2b27ca35a777', 'Béninois', 'Pas trop bon', '2022-06-09 18:41:21', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `typemenu`
--

CREATE TABLE `typemenu` (
  `id` int(11) NOT NULL,
  `typemenuid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `restaurantid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `typemenu`
--

INSERT INTO `typemenu` (`id`, `typemenuid`, `libelle`, `description`, `restaurantid`, `createdon`, `createdby`, `status`) VALUES
(1, 'hshsbgdgfefefrggrgr45r', 'Type menu 1', 'Descrrrr', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-07 09:03:48', '', 1),
(2, 'hshsbgd774gfefefrggrgr45r', 'Type menu 2', 'Descrrrr', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-07 09:03:48', '', 1),
(3, 'hsbgdgfefefrggrgr45r', 'Type menu 3', 'Descrrrr', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-07 09:03:48', '', 0),
(4, '484f2f51-1f6b-4057-84b5-837532d6b796', 'mon libbelé', 'Softhotels', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-07 10:59:31', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(5, '176efb28-27aa-4d8f-f5f3-fcbb0d878a27', 'Pour échénce véhicule', 'siteweb appligel', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-07 11:09:59', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(6, 'fa1b3b9f-278f-468e-abba-99c46044ec70', 'Béninois', 'Descr benin', 'f84c0212-65e3-4dd2-f389-337b3c5fc1e3', '2022-06-08 18:27:24', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(7, '607eb969-c1eb-44ae-9915-dda68dc60714', 'Type menu 1', 'Descr 1', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-06-08 21:04:39', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(8, '7b7cdd6a-65c7-4a69-b37d-f88cf627dacd', 'Type menu 2', 'Softhotels', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-06-08 23:01:14', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(9, 'd596e6cb-b03b-4d60-c3b5-9ecf5c041a33', 'mon libbelé 2', 'Softhotels', '9991fe7e-cd99-4ac7-af69-e454ed64ae90', '2022-06-08 23:01:14', '9b416afd-a97a-41db-b2f9-795fa55b1187', 0),
(10, '3e643900-cd2a-4519-a3c9-51b167636bd9', 'Type menu 3', 'descr 333', '51732956-8c8e-40e7-e180-cda928813ca7', '2022-06-23 21:09:41', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1),
(11, 'c81abda5-f5a4-4f04-b99d-2d06a5216a0e', 'mon libbelé 2', 'Pas trop bon', '51732956-8c8e-40e7-e180-cda928813ca7', '2022-07-05 17:21:09', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

-- --------------------------------------------------------

--
-- Table structure for table `ville`
--

CREATE TABLE `ville` (
  `id` int(11) NOT NULL,
  `villeid` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `paysid` varchar(255) NOT NULL,
  `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdby` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ville`
--

INSERT INTO `ville` (`id`, `villeid`, `libelle`, `paysid`, `createdon`, `createdby`, `status`) VALUES
(1, '15267d18-f57f-4bc1-8ac3-800eb42085df', 'Abidjan', 'babb61ac-9173-4e0e-82c9-ae8c43589eaf', '2022-05-25 01:48:50', '9b416afd-a97a-41db-b2f9-795fa55b1187', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `conso`
--
ALTER TABLE `conso`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consoid` (`consoid`);

--
-- Indexes for table `consocoupon`
--
ALTER TABLE `consocoupon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consocouponid` (`consocouponid`);

--
-- Indexes for table `consofacture`
--
ALTER TABLE `consofacture`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `consolivraison`
--
ALTER TABLE `consolivraison`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupon`
--
ALTER TABLE `coupon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `couponid` (`couponid`);

--
-- Indexes for table `departement`
--
ALTER TABLE `departement`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departementid` (`departementid`);

--
-- Indexes for table `dotation`
--
ALTER TABLE `dotation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `entreprise`
--
ALTER TABLE `entreprise`
  ADD PRIMARY KEY (`id`),
  ADD KEY `entrepriseid` (`entrepriseid`);

--
-- Indexes for table `fraislivraison`
--
ALTER TABLE `fraislivraison`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fraislivraisonid` (`fraislivraisonid`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logid` (`logid`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menuid` (`menuid`);

--
-- Indexes for table `pays`
--
ALTER TABLE `pays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `paysid` (`paysid`);

--
-- Indexes for table `rechargement`
--
ALTER TABLE `rechargement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `restaurant`
--
ALTER TABLE `restaurant`
  ADD PRIMARY KEY (`id`),
  ADD KEY `restaurantid` (`restaurantid`);

--
-- Indexes for table `restautypecuisine`
--
ALTER TABLE `restautypecuisine`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roleadrili`
--
ALTER TABLE `roleadrili`
  ADD PRIMARY KEY (`id`),
  ADD KEY `roleadriliid` (`roleadriliid`);

--
-- Indexes for table `rolebene`
--
ALTER TABLE `rolebene`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rolebeneid` (`rolebeneid`);

--
-- Indexes for table `roleentreprise`
--
ALTER TABLE `roleentreprise`
  ADD PRIMARY KEY (`id`),
  ADD KEY `roleentrepriseid` (`roleentrepriseid`);

--
-- Indexes for table `secteurpro`
--
ALTER TABLE `secteurpro`
  ADD PRIMARY KEY (`id`),
  ADD KEY `secteurproid` (`secteurproid`);

--
-- Indexes for table `transfertbene`
--
ALTER TABLE `transfertbene`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transfertbeneid` (`transfertbeneid`);

--
-- Indexes for table `typecuisine`
--
ALTER TABLE `typecuisine`
  ADD PRIMARY KEY (`id`),
  ADD KEY `typecuisineid` (`typecuisineid`);

--
-- Indexes for table `typemenu`
--
ALTER TABLE `typemenu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `typemenuid` (`typemenuid`);

--
-- Indexes for table `ville`
--
ALTER TABLE `ville`
  ADD PRIMARY KEY (`id`),
  ADD KEY `villeid` (`villeid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `conso`
--
ALTER TABLE `conso`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `consocoupon`
--
ALTER TABLE `consocoupon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `consofacture`
--
ALTER TABLE `consofacture`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `consolivraison`
--
ALTER TABLE `consolivraison`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `coupon`
--
ALTER TABLE `coupon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `departement`
--
ALTER TABLE `departement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `dotation`
--
ALTER TABLE `dotation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `entreprise`
--
ALTER TABLE `entreprise`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `fraislivraison`
--
ALTER TABLE `fraislivraison`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `pays`
--
ALTER TABLE `pays`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `rechargement`
--
ALTER TABLE `rechargement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `restaurant`
--
ALTER TABLE `restaurant`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `restautypecuisine`
--
ALTER TABLE `restautypecuisine`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `roleadrili`
--
ALTER TABLE `roleadrili`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `rolebene`
--
ALTER TABLE `rolebene`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `roleentreprise`
--
ALTER TABLE `roleentreprise`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `secteurpro`
--
ALTER TABLE `secteurpro`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `transfertbene`
--
ALTER TABLE `transfertbene`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `typecuisine`
--
ALTER TABLE `typecuisine`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `typemenu`
--
ALTER TABLE `typemenu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `ville`
--
ALTER TABLE `ville`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

