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




--
-- Database: `hay`
--

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

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL,
  `source` varchar(50) DEFAULT NULL,
  `reference` varchar(100) NOT NULL,
  `referencemere` varchar(100) DEFAULT NULL,
  `fournisseur` varchar(100) DEFAULT NULL,
  `constructeur` varchar(100) DEFAULT NULL,
  `prixunitaire` varchar(20) NOT NULL,
  `prixremise` varchar(20) DEFAULT NULL,
  `valeurremisepourcentage` varchar(20) DEFAULT NULL,
  `disponibilitedelai` varchar(20) DEFAULT NULL,
  `disponibiliteetat` varchar(20) DEFAULT NULL,
  `publie` varchar(11) DEFAULT NULL,
  `ean` varchar(100) DEFAULT NULL,
  `isbn` varchar(100) DEFAULT NULL,
  `gammeprincipale` varchar(100) DEFAULT NULL,
  `nom` varchar(500) DEFAULT NULL,
  `resume` text,
  `description` text,
  `marqueid` varchar(20) DEFAULT NULL,
  `marquenom` varchar(100) DEFAULT NULL,
  `stock` varchar(11) DEFAULT NULL,
  `emplacement` varchar(100) DEFAULT NULL,
  `stockadd` varchar(11) DEFAULT NULL,
  `stockalerte` varchar(20) DEFAULT NULL,
  `stockindisponible` varchar(20) DEFAULT NULL,
  `tva` varchar(20) DEFAULT NULL,
  `tvaid` varchar(20) DEFAULT NULL,
  `poids` varchar(20) DEFAULT NULL,
  `visuel` varchar(500) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  `datemodification` varchar(20) DEFAULT NULL,
  `del` int(11) DEFAULT NULL,
  `serviceid` int(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `article`
--

INSERT INTO `article` (`id`, `source`, `reference`, `referencemere`, `fournisseur`, `constructeur`, `prixunitaire`, `prixremise`, `valeurremisepourcentage`, `disponibilitedelai`, `disponibiliteetat`, `publie`, `ean`, `isbn`, `gammeprincipale`, `nom`, `resume`, `description`, `marqueid`, `marquenom`, `stock`, `emplacement`, `stockadd`, `stockalerte`, `stockindisponible`, `tva`, `tvaid`, `poids`, `visuel`, `date`, `datemodification`, `del`, `serviceid`) VALUES
(1, 'PS', 'demo_1', NULL, '', 'Fashion Manufacturer', '16.51', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'T-shirt délavé à manches courtes', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/1/1', NULL, NULL, NULL, 36),
(2, 'PS', 'demo_2', NULL, '', 'Fashion Manufacturer', '27.00', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Chemisier', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/2/7', NULL, NULL, NULL, 36),
(3, 'PS', 'demo_3', NULL, '', 'Fashion Manufacturer', '26.00', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Robe imprimée', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/3/8', NULL, NULL, NULL, 36),
(4, 'PS', 'demo_4', NULL, '', 'Fashion Manufacturer', '50.99', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Robe imprimée', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/4/10', NULL, NULL, NULL, 36),
(5, 'PS', 'demo_5', NULL, '', 'Fashion Manufacturer', '30.51', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Robe d\'été imprimée', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/5/12', NULL, NULL, NULL, 36),
(6, 'PS', 'demo_6', NULL, '', 'Fashion Manufacturer', '30.50', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Robe d\'été imprimée', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/6/16', NULL, NULL, NULL, 36),
(7, 'PS', 'demo_7', NULL, '', 'Fashion Manufacturer', '20.50', NULL, NULL, NULL, NULL, '1', '0', '', NULL, 'Robe en mousseline imprimée', NULL, NULL, NULL, 'Fashion Manufacturer', '', NULL, NULL, NULL, NULL, '', NULL, '0.000000', 'http://www.presta.hubasyou.com/api/images/products/7/20', NULL, NULL, NULL, 36);

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

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` int(11) NOT NULL,
  `idclient` varchar(100) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `datecreated` varchar(20) NOT NULL,
  `datemodified` varchar(20) NOT NULL,
  `email` varchar(40) NOT NULL,
  `firstname` varchar(40) NOT NULL,
  `lastname` varchar(40) NOT NULL,
  `userrole` varchar(40) NOT NULL,
  `username` varchar(40) NOT NULL,
  `billingfirstname` varchar(40) NOT NULL,
  `billinglastname` varchar(40) NOT NULL,
  `billingcompany` varchar(40) DEFAULT NULL,
  `billingaddress1` varchar(200) NOT NULL,
  `billingaddress2` varchar(200) NOT NULL,
  `billingcity` varchar(40) NOT NULL,
  `billingstate` varchar(40) NOT NULL,
  `billingpostcode` varchar(10) NOT NULL,
  `billingcountry` varchar(200) DEFAULT NULL,
  `billingemail` varchar(40) NOT NULL,
  `billingphone` varchar(200) NOT NULL,
  `shippingfirstname` varchar(40) DEFAULT NULL,
  `shippinglastname` varchar(40) DEFAULT NULL,
  `shippingcompany` varchar(40) DEFAULT NULL,
  `shippingaddress1` varchar(200) DEFAULT NULL,
  `shippingaddress2` varchar(200) DEFAULT NULL,
  `shippingcity` varchar(40) DEFAULT NULL,
  `shippingstate` varchar(40) DEFAULT NULL,
  `shippingpostcode` varchar(10) DEFAULT NULL,
  `shippingcountry` varchar(200) DEFAULT NULL,
  `ispayingcustomer` int(1) DEFAULT NULL,
  `orderscount` int(20) DEFAULT NULL,
  `totalspent` varchar(200) DEFAULT NULL,
  `avatarurl` varchar(200) DEFAULT NULL,
  `del` int(11) DEFAULT NULL,
  `majac` int(10) DEFAULT '0',
  `lastmodifac` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client`
--

INSERT INTO `client` (`id`, `idclient`, `iduser`, `datecreated`, `datemodified`, `email`, `firstname`, `lastname`, `userrole`, `username`, `billingfirstname`, `billinglastname`, `billingcompany`, `billingaddress1`, `billingaddress2`, `billingcity`, `billingstate`, `billingpostcode`, `billingcountry`, `billingemail`, `billingphone`, `shippingfirstname`, `shippinglastname`, `shippingcompany`, `shippingaddress1`, `shippingaddress2`, `shippingcity`, `shippingstate`, `shippingpostcode`, `shippingcountry`, `ispayingcustomer`, `orderscount`, `totalspent`, `avatarurl`, `del`, `majac`, `lastmodifac`) VALUES
(1, '3', 7, '2018-09-24 17:24:50', '2018-09-26 23:16:58', 'abdel@opteam-solutions.com', 'Patrick', 'DURANT', '', 'DURANT Patrick', 'Patrick', 'DURANT', NULL, 'Adresse 11 Adresse 22', '', 'BORDEAUX', '', '33000', 'France', 'abdel@opteam-solutions.com', '0646020304', 'Patrick', 'DURANT', NULL, 'Adresse 11 Adresse 22', '', 'BORDEAUX', NULL, '33000', 'France', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, '1', NULL, '2018-09-24 17:29:14', '2018-09-24 17:29:19', 'pub@prestashop.com', 'John', 'DOE', '', 'DOE John', 'John', 'DOE', NULL, '16, Main street 2nd floor', '', 'Miami', '', '33133', 'États-Unis', 'pub@prestashop.com', '', 'John', 'DOE', NULL, '16, Main street 2nd floor', '', 'Miami', NULL, '33133', 'États-Unis', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '2', NULL, '2018-09-24 17:29:20', '2018-09-26 01:16:34', 'moneamil@gmail.com', 'Abdel', 'Moumen', '', 'Moumen Abdel', 'Abdel', 'Moumen', NULL, 'adresse 11 ', '', 'Agen', '', '47000', 'France', 'moneamil@gmail.com', '0646020304', 'Abdel', 'Moumen', NULL, 'adresse 11 ', '', 'Agen', NULL, '47000', 'France', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '142', NULL, '2018-09-24 17:30:02', '2018-09-24 17:30:07', 'dupont@pasgmail.com', 'philippe', 'Dupont', '', 'Dupont philippe', 'philippe', 'Dupont', NULL, '17 rue du 8 mai 1945', '', 'Bordeaux', '', '33000', 'France métropolitaine', 'dupont@pasgmail.com', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '182', NULL, '2018-09-24 17:30:03', '2018-09-24 17:30:03', 'ssss@sss.ss', 'qsqs', 'sqsqs', '', 'sqsqs qsqs', 'qsqs', 'sqsqs', 'BOX OFFICE', 'qs', '', 'Toulouse', '', '31000', 'France métropolitaine', 'ssss@sss.ss', '0622222222', 'qsqs', 'sqsqs', 'BOX OFFICE', '36 RUE DU TAUR', '', 'TOULOUSE', NULL, '31000', 'France métropolitaine', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '202', NULL, '2018-09-24 17:30:08', '2018-09-24 17:30:08', 'wanatek.test@gmail.com', 'test', 'test', '', 'test test', 'test', 'test', 'FRANCE LOISIRS', 'ccc', '', 'Toulouse', '', '31000', 'France métropolitaine', 'wanatek.test@gmail.com', '', 'test', 'test', 'FRANCE LOISIRS', '12 RUE REMUSAT', '', 'TOULOUSE', NULL, '31000', 'France métropolitaine', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '212', NULL, '2018-09-24 17:30:10', '2018-09-24 17:30:10', 'xolasotemi@fxprix.com', 'te', 'saad', '', 'saad te', 'te', 'saad', NULL, 'paris', '', 'Saint-Brieuc', '', '22000', 'France métropolitaine', 'xolasotemi@fxprix.com', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '21', NULL, '2018-09-24 17:30:12', '2018-09-24 17:30:12', 'amoumen@powerboutique.com', 'Abdel', 'Moumen', '', 'Moumen Abdel', 'Abdel', 'Moumen', NULL, '17 place Semard', '', 'Béziers', '', '34500', 'France métropolitaine', 'amoumen@powerboutique.com', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `commande`
--

CREATE TABLE `commande` (
  `id` int(11) NOT NULL,
  `idcommande` varchar(100) NOT NULL,
  `source` varchar(100) DEFAULT NULL,
  `serviceid` int(11) DEFAULT NULL,
  `etatlivraison` int(11) DEFAULT NULL,
  `etatcommandecms` varchar(100) DEFAULT NULL,
  `etatexpeditor` tinyint(4) DEFAULT '0',
  `majadd` tinyint(4) DEFAULT '0',
  `datemajadd` varchar(20) DEFAULT NULL,
  `expeditormajdate` varchar(20) DEFAULT NULL,
  `datecommande` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `montantsdevise` varchar(100) DEFAULT NULL,
  `montantsmontantnetapayer` varchar(100) DEFAULT NULL,
  `montantsmontantnetapayertvaincluse` varchar(100) DEFAULT NULL,
  `montantsmontantsoustotal` varchar(100) DEFAULT NULL,
  `montantsmontantsoustotaltvaincluse` varchar(100) DEFAULT NULL,
  `montantsmontantport` varchar(20) DEFAULT NULL,
  `montantsmontantporttaux` varchar(100) DEFAULT NULL,
  `montantsmontantporttvaincluse` varchar(100) DEFAULT NULL,
  `montantsecotaxe` varchar(100) DEFAULT NULL,
  `montantsdetailtvatotal` varchar(100) DEFAULT NULL,
  `montantsdetailtvatva` varchar(20) DEFAULT NULL,
  `clientid` varchar(100) DEFAULT NULL,
  `clienttypeclient` varchar(100) DEFAULT NULL,
  `clientformejuridique` varchar(100) DEFAULT NULL,
  `clientcodeape` varchar(100) DEFAULT NULL,
  `clientsiret` varchar(100) DEFAULT NULL,
  `clientdatecreate` varchar(100) DEFAULT NULL,
  `clientconditionsreglementdiffere` varchar(100) DEFAULT NULL,
  `clientconditionsreglementhorstaxes` varchar(100) DEFAULT NULL,
  `clientconditionsreglementmessage` varchar(100) DEFAULT NULL,
  `clientadressefacturationemail` varchar(100) DEFAULT NULL,
  `clientadressefacturationsociete` varchar(100) DEFAULT NULL,
  `clientadressefacturationnom` varchar(100) DEFAULT NULL,
  `clientadressefacturationprenom` varchar(100) DEFAULT NULL,
  `clientadressefacturationadresse1` varchar(100) DEFAULT NULL,
  `clientadressefacturationadresse2` varchar(100) DEFAULT NULL,
  `clientadressefacturationcodepostal` varchar(100) DEFAULT NULL,
  `clientadressefacturationville` varchar(100) DEFAULT NULL,
  `clientadressefacturationpaysid` varchar(100) DEFAULT NULL,
  `clientadressefacturationpaysiso` varchar(100) DEFAULT NULL,
  `clientadressefacturationpaysnom` varchar(100) DEFAULT NULL,
  `clientadressefacturationtelfixe` varchar(100) DEFAULT NULL,
  `clientadressefacturationtelmobile` varchar(100) DEFAULT NULL,
  `clientadressefacturationsexe` varchar(100) DEFAULT NULL,
  `clientadressefacturationfax` varchar(100) DEFAULT NULL,
  `clientadresselivraisonemail` varchar(100) DEFAULT NULL,
  `clientadresselivraisonsociete` varchar(100) DEFAULT NULL,
  `clientadresselivraisonnom` varchar(100) DEFAULT NULL,
  `clientadresselivraisonprenom` varchar(100) DEFAULT NULL,
  `clientadresselivraisonadresse` varchar(100) DEFAULT NULL,
  `clientadresselivraisonadresse2` varchar(100) DEFAULT NULL,
  `clientadresselivraisoncodepostal` varchar(100) DEFAULT NULL,
  `clientadresselivraisonville` varchar(100) DEFAULT NULL,
  `clientadresselivraisonpaysid` varchar(100) DEFAULT NULL,
  `clientadresselivraisonpaysiso` varchar(100) DEFAULT NULL,
  `clientadresselivraisonpaysnom` varchar(100) DEFAULT NULL,
  `clientadresselivraisontelfixe` varchar(100) DEFAULT NULL,
  `clientadresselivraisontelmobile` varchar(100) DEFAULT NULL,
  `clientadresselivraisonsexe` varchar(100) DEFAULT NULL,
  `clientadresselivraisonfax` varchar(100) DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `statuscode` varchar(100) DEFAULT NULL,
  `statusdate` varchar(100) DEFAULT NULL,
  `coderemise` varchar(100) DEFAULT NULL,
  `remisetype` varchar(50) DEFAULT NULL,
  `remisevaleur` varchar(10) DEFAULT NULL,
  `remisedescription` varchar(500) DEFAULT NULL,
  `ipcommande` varchar(100) DEFAULT NULL,
  `reglementmodeid` varchar(100) DEFAULT NULL,
  `reglementmodenom` varchar(100) DEFAULT NULL,
  `reglementsigle` varchar(100) DEFAULT NULL,
  `reglementtype` varchar(100) DEFAULT NULL,
  `reglementstatus` varchar(100) DEFAULT NULL,
  `reglementstatuscode` varchar(100) DEFAULT NULL,
  `expeditionmodeid` varchar(100) DEFAULT NULL,
  `expeditionmodenom` varchar(100) DEFAULT NULL,
  `expeditionmodesigle` varchar(100) DEFAULT NULL,
  `expeditionmodecodepointrelais` varchar(20) DEFAULT NULL,
  `idpointrelais` varchar(20) DEFAULT NULL,
  `expeditionmodetype` varchar(100) DEFAULT NULL,
  `expeditiondelai` varchar(100) DEFAULT NULL,
  `expeditiondelaitype` varchar(100) DEFAULT NULL,
  `datemaj` varchar(20) DEFAULT NULL,
  `codetracking` varchar(20) DEFAULT NULL,
  `transporteurid` int(11) DEFAULT NULL,
  `transporteur` varchar(200) DEFAULT NULL,
  `codetrackingpartielle` varchar(20) DEFAULT NULL,
  `idtransporteurpartielle` int(11) DEFAULT NULL,
  `transporteurpartielle` varchar(50) DEFAULT NULL,
  `poidstotal` varchar(10) DEFAULT NULL,
  `del` int(11) DEFAULT NULL,
  `majac` int(4) DEFAULT '0',
  `lastmodifac` datetime DEFAULT '1970-01-01 00:00:01'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commande`
--

INSERT INTO `commande` (`id`, `idcommande`, `source`, `serviceid`, `etatlivraison`, `etatcommandecms`, `etatexpeditor`, `majadd`, `datemajadd`, `expeditormajdate`, `datecommande`, `montantsdevise`, `montantsmontantnetapayer`, `montantsmontantnetapayertvaincluse`, `montantsmontantsoustotal`, `montantsmontantsoustotaltvaincluse`, `montantsmontantport`, `montantsmontantporttaux`, `montantsmontantporttvaincluse`, `montantsecotaxe`, `montantsdetailtvatotal`, `montantsdetailtvatva`, `clientid`, `clienttypeclient`, `clientformejuridique`, `clientcodeape`, `clientsiret`, `clientdatecreate`, `clientconditionsreglementdiffere`, `clientconditionsreglementhorstaxes`, `clientconditionsreglementmessage`, `clientadressefacturationemail`, `clientadressefacturationsociete`, `clientadressefacturationnom`, `clientadressefacturationprenom`, `clientadressefacturationadresse1`, `clientadressefacturationadresse2`, `clientadressefacturationcodepostal`, `clientadressefacturationville`, `clientadressefacturationpaysid`, `clientadressefacturationpaysiso`, `clientadressefacturationpaysnom`, `clientadressefacturationtelfixe`, `clientadressefacturationtelmobile`, `clientadressefacturationsexe`, `clientadressefacturationfax`, `clientadresselivraisonemail`, `clientadresselivraisonsociete`, `clientadresselivraisonnom`, `clientadresselivraisonprenom`, `clientadresselivraisonadresse`, `clientadresselivraisonadresse2`, `clientadresselivraisoncodepostal`, `clientadresselivraisonville`, `clientadresselivraisonpaysid`, `clientadresselivraisonpaysiso`, `clientadresselivraisonpaysnom`, `clientadresselivraisontelfixe`, `clientadresselivraisontelmobile`, `clientadresselivraisonsexe`, `clientadresselivraisonfax`, `language`, `status`, `statuscode`, `statusdate`, `coderemise`, `remisetype`, `remisevaleur`, `remisedescription`, `ipcommande`, `reglementmodeid`, `reglementmodenom`, `reglementsigle`, `reglementtype`, `reglementstatus`, `reglementstatuscode`, `expeditionmodeid`, `expeditionmodenom`, `expeditionmodesigle`, `expeditionmodecodepointrelais`, `idpointrelais`, `expeditionmodetype`, `expeditiondelai`, `expeditiondelaitype`, `datemaj`, `codetracking`, `transporteurid`, `transporteur`, `codetrackingpartielle`, `idtransporteurpartielle`, `transporteurpartielle`, `poidstotal`, `del`, `majac`, `lastmodifac`) VALUES
(1, 'QUFAZANQS', 'PS', 36, 4, 'Paiement accepté', NULL, 1, '2018-09-24 17:27:35', NULL, '2018-09-24 09:26:38', NULL, '32.40', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aaaa@aaaa.com', NULL, 'Test', 'Test', 'Avenue de Paris ', NULL, '75001', 'Paris', NULL, 'FR', 'France', '', '0660606060', NULL, NULL, NULL, NULL, 'Test', 'Test', 'Avenue de Paris ', NULL, '75001', 'Paris', NULL, 'FR', 'France', '', '0660606060', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chèque', NULL, NULL, '5', NULL, 'Test Mondial Relay 2', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'XKBKNABJK', 'PS', 36, 8, 'Annulé', NULL, NULL, NULL, NULL, '2018-09-12 13:06:14', NULL, '55.00', NULL, NULL, NULL, '2.00', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pub@prestashop.com', NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment by check', NULL, NULL, '5', NULL, 'My carrier', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'OHSATSERP', 'PS', 36, 4, 'En attente de paiement par chèque', NULL, NULL, NULL, NULL, '2018-09-12 13:06:14', NULL, '75.90', NULL, NULL, NULL, '2.00', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pub@prestashop.com', NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment by check', NULL, NULL, '5', NULL, 'My carrier', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'UOYEVOLI', 'PS', 36, 3, 'Erreur de paiement', NULL, NULL, NULL, NULL, '2018-09-12 13:06:14', NULL, '76.01', NULL, NULL, NULL, '2.00', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pub@prestashop.com', NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment by check', NULL, NULL, '5', NULL, 'My carrier', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'FFATNOMMJ', 'PS', 36, 4, 'En attente de paiement par chèque', NULL, NULL, NULL, NULL, '2018-09-12 13:06:14', NULL, '89.89', NULL, NULL, NULL, '2.00', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pub@prestashop.com', NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment by check', NULL, NULL, '5', NULL, 'My carrier', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'KHWLILZLL', 'PS', 36, 2, 'En attente de virement bancaire', NULL, NULL, NULL, NULL, '2018-09-12 13:06:14', NULL, '71.51', NULL, NULL, NULL, '2.00', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pub@prestashop.com', NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, 'DOE', 'John', '16, Main street 2nd floor', NULL, '33133', 'Miami', NULL, 'US', 'États-Unis', '0102030405', '', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Bank wire', NULL, NULL, '5', NULL, 'My carrier', 'My carrier', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'JXRTWYFVL', 'PS', 36, 4, 'Expédié', NULL, 1, '2018-09-26 17:16:50', NULL, '2018-09-12 13:14:44', NULL, '19.81', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'monemail@gmail.com', NULL, 'Durand', 'Alain', '17 rue de Paris  ', NULL, '33000', 'Bordeaux', NULL, 'FR', 'France', '0102030405', '0601020304', NULL, NULL, NULL, NULL, 'Durand', 'Alain', '17 rue de Paris  ', NULL, '33000', 'Bordeaux', NULL, 'FR', 'France', '0102030405', '0601020304', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Virement bancaire', NULL, NULL, '5', NULL, 'PrestaHAY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'MFIRSNVMX', 'PS', 36, 4, 'Paiement accepté', 1, NULL, NULL, '04-10-2018', '2018-09-18 09:11:47', NULL, '19.81', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'aaaa@aaaa.com', NULL, 'Test', 'Test', 'Avenue de Paris ', NULL, '75001', 'Paris', NULL, 'FR', 'France', '', '0660606060', NULL, NULL, NULL, NULL, 'Test', 'Test', 'Avenue de Paris ', NULL, '75001', 'Paris', NULL, 'FR', 'France', '', '0660606060', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chèque', NULL, NULL, '5', NULL, 'Test Mondial Relay', 'CHRO', NULL, NULL, NULL, NULL, NULL, NULL, 'XF963805888FR', 4, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL),
(9, 'L2903750yH6e', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-03-23 10:54:58', 'EUR', '265.06', 'true', '214.54', 'false', '7.61', '20', 'true', '0', '44.18', NULL, '142', 'particulier', '', '', '', '2014-10-15T15:01:37Z', 'false', NULL, '', 'zzzzz@gmail.com', '', 'Cousin', 'philippe', '17 ru du 8 mai 1945', '', '33000', 'Bordeaux', '35', 'FR', 'France métropolitaine', '0102030405', '', 'M.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lg_fr', 'Commande valid&eacute;e', '10', '2018-03-23T10:55:23Z', '', 'Remise montant', '13.55', '', '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '106', 'Colissimo Suivi', 'COLI', '', '', 'offline', '2', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(10, 'L29037o4xh98', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-04-23 12:38:48', 'EUR', '38', 'true', '31.67', 'false', '0', '20', 'true', '0', '6.33', NULL, '182', 'particulier', '', '', '', '2018-04-03T16:40:00Z', 'false', NULL, '', 'ssss@sss.ss', 'sqs', 'sqsqs', 'qsqs', 'qs', 'qs', '31000', 'Toulouse', '35', 'FR', 'France métropolitaine', '0969999999', '0622222222', 'M.', NULL, 'ssss@sss.ss', 'BOX OFFICE', 'sqsqs', 'qsqs', '36 RUE DU TAUR', '', '31000', 'TOULOUSE', '35', 'FR', 'France métropolitaine', '', '0622222222', 'M.', '', 'lg_fr', 'Commande valid&eacute;e', '10', '2018-04-23T12:39:38Z', '', NULL, NULL, NULL, '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '1', 'ChronoRelais', 'CHRO', '3755S', '3755S', 'online', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(11, 'L29037ixYkJg', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-05-29 11:53:47', 'EUR', '15', 'true', '12.5', 'false', '0', '20', 'true', '0', '2.5', NULL, '142', 'particulier', '', '', '', '2014-10-15T15:01:37Z', 'false', NULL, '', 'dupont@pasgmail.com', '', 'Dupont', 'philippe', '17 rue du 8 mai 1945', '', '33000', 'Bordeaux', '35', 'FR', 'France métropolitaine', '0102030405', '', 'M.', NULL, 'dupont@pasgmail.com', 'POINT SERVICE MOBILE BORDEAUX', 'Dupont', 'philippe', '65 RUE JUDAIQUE', '', '33000', 'BORDEAUX', '35', 'FR', 'France métropolitaine', '', '', 'M.', '', 'lg_fr', 'Commande valid&eacute;e', '10', '2018-05-29T11:54:42Z', '', NULL, NULL, NULL, '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '1', 'ChronoRelais', 'CHRO', '0973S', '0973S', 'online', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(12, 'L29037UQO346', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-06-14 15:29:28', 'EUR', '15', 'true', '12.5', 'false', '0', '20', 'true', '0', '2.5', NULL, '142', 'particulier', '', '', '', '2014-10-15T15:01:37Z', 'false', NULL, '', 'dupont@pasgmail.com', '', 'Dupont', 'philippe', '17 rue du 8 mai 1945', '', '33000', 'Bordeaux', '35', 'FR', 'France métropolitaine', '0102030405', '', 'M.', NULL, 'dupont@pasgmail.com', 'OLIVART', 'Dupont', 'philippe', '4 RUE JUDAIQUEPROCHE PLACE GAMBETTA', '', '33000', 'BORDEAUX', '35', 'FR', 'France métropolitaine', '', '', 'M.', '', 'lg_fr', 'Commande valid&eacute;e', '10', '2018-06-14T15:29:41Z', '', NULL, NULL, NULL, '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '1', 'ChronoRelais', 'CHRO', '1825S', '1825S', 'online', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(13, 'L29037XXnuKY', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-06-14 15:31:22', 'EUR', '143.1', 'true', '109.25', 'false', '12', '20', 'true', '0', '23.85', NULL, '142', 'particulier', '', '', '', '2014-10-15T15:01:37Z', 'false', NULL, '', 'dupont@pasgmail.com', '', 'Dupont', 'philippe', '17 rue du 8 mai 1945', '', '33000', 'Bordeaux', '35', 'FR', 'France métropolitaine', '0102030405', '', 'M.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lg_fr', 'Commande valid&eacute;e', '10', '2018-06-14T16:01:41Z', '', 'Remise montant', '6.9', '', '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '0', 'Envoi Prioritaire', 'PRIO', '', '', 'offline', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(14, 'L290378FyWdW', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-07-11 16:21:41', 'EUR', '211.85', 'true', '176.54', 'false', '0', '20', 'true', '0', '35.31', NULL, '202', 'particulier', '', '', '', '2018-07-11T16:21:09Z', 'false', NULL, '', 'wanatek.test@gmail.com', 'ccc', 'test', 'test', 'ccc', '', '31000', 'Toulouse', '35', 'FR', 'France métropolitaine', '0655478521', '', 'Mme', NULL, 'wanatek.test@gmail.com', 'FRANCE LOISIRS', 'test', 'test', '12 RUE REMUSAT', '', '31000', 'TOULOUSE', '35', 'FR', 'France métropolitaine', '', '', 'Mme', '', 'lg_fr', 'Commande valid&eacute;e', '10', '2018-07-11T16:22:09Z', '', 'Remise montant', '11.15', '', '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '1', 'ChronoRelais', 'CHRO', '4333S', '4333S', 'online', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(15, 'L29037jzpAlc', 'PB', 37, 1, NULL, NULL, NULL, NULL, NULL, '2018-07-20 17:01:40', 'EUR', '15655.05', 'true', '13045.87', 'false', '0', '20', 'true', '0', '2609.18', NULL, '212', 'particulier', '', '', '', '2018-07-20T16:58:21Z', 'false', NULL, '', 'xolasotemi@fxprix.com', '', 'saad', 'te', 'paris', 'paris', '22000', 'Saint-Brieuc', '35', 'FR', 'France métropolitaine', '0648877458', '', 'M.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lg_fr', 'Commande valid&eacute;e', '10', '2018-07-20T17:04:00Z', '', 'Remise montant', '823.95', '', '160.174.130.195', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement valid&eacute;', '5', '0', 'Envoi Economique', 'ECO', '', '', 'offline', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(16, 'L29037SePoJh', 'PB', 37, 1, NULL, NULL, 1, '2018-09-24 17:30:24', NULL, '2018-08-10 23:53:57', 'EUR', '310.3', 'true', '248.58', 'false', '12', '20', 'true', '0', '51.72', NULL, '21', 'particulier', '', '', '', '2014-04-20T21:07:55Z', 'false', NULL, '', 'amoumen@powerboutique.com', '', 'Moumen', 'Abdel', '17 place Semard', '', '34500', 'Béziers', '35', 'FR', 'France métropolitaine', '0102030405', '', 'M.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lg_fr', 'Commande &agrave; valider', '12', '', '', 'Remise montant', '15.7', '', '89.2.161.49', '1', 'Cheque, ', 'CHQ', 'offline', 'Paiement à valider', '4', '0', 'Envoi Prioritaire', 'PRIO', '', '', 'offline', '1', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL),
(17, 'DTRBRWYSA', 'PS', 36, 4, 'Expédié', 1, NULL, NULL, '12-03-2019', '2018-09-25 23:08:39', NULL, '31.20', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'moneamil@gmail.com', NULL, 'Moumen', 'Abdel', 'adresse 11 ', NULL, '47000', 'Agen', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, 'Moumen', 'Abdel', 'adresse 11 ', NULL, '47000', 'Agen', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Virement bancaire', NULL, NULL, '5', NULL, 'Presta09', 'CHRO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 'HVUCYAIDG', 'PS', 36, 4, 'Expédié', 1, NULL, NULL, '07-03-2019', '2018-09-26 08:17:52', NULL, '62.86', NULL, NULL, NULL, '8.40', NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abdel@opteam-solutions.com', NULL, 'DURANT', 'Patrick', 'Adresse 11 Adresse 22', NULL, '33000', 'BORDEAUX', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, 'DURANT', 'Patrick', 'Adresse 11 Adresse 22', NULL, '33000', 'BORDEAUX', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chèque', NULL, NULL, '5', NULL, 'My carrier', 'CHRO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 'VYLTRLEYG', 'PS', 36, 4, 'En attente de virement bancaire', 1, NULL, NULL, '27-09-2018', '2018-09-26 21:13:04', NULL, '161.99', NULL, NULL, NULL, '8.40', NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abdel@opteam-solutions.com', NULL, 'DURANT', 'Patrick', 'Adresse 11 Adresse 22', NULL, '33000', 'BORDEAUX', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, 'DURANT', 'Patrick', 'Adresse 11 Adresse 22', NULL, '33000', 'BORDEAUX', NULL, 'FR', 'France', '0102030405', '0646020304', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Virement bancaire', NULL, NULL, '5', NULL, 'My carrier', 'GEOD-PLAT', NULL, NULL, NULL, NULL, NULL, NULL, '3315697000628212', 2, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL);

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

--
-- Table structure for table `commentaire`
--

CREATE TABLE `commentaire` (
  `id` int(11) NOT NULL,
  `idcommande` varchar(20) NOT NULL,
  `priorite` int(4) NOT NULL DEFAULT '0',
  `type` int(4) NOT NULL DEFAULT '0',
  `iduser` varchar(20) NOT NULL,
  `roleuser` varchar(50) DEFAULT NULL,
  `nomuser` varchar(100) NOT NULL,
  `nomclient` varchar(50) DEFAULT NULL,
  `prenomclient` varchar(50) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `commentaire` varchar(300) NOT NULL,
  `vu` tinyint(4) NOT NULL DEFAULT '0',
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `devis`
--

CREATE TABLE `devis` (
  `id` int(11) NOT NULL,
  `idclient` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `reference` varchar(11) NOT NULL,
  `montant` varchar(20) NOT NULL,
  `created` varchar(20) NOT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `devis`
--

INSERT INTO `devis` (`id`, `idclient`, `status`, `reference`, `montant`, `created`, `del`) VALUES
(1, 1, 1, '1524', '100.00', '2019-03-06 00:00:00', 1),
(2, 1, 2, '4545', '100.20', '2019-03-06 00:00:00', NULL),
(3, 1, 3, '7878745', '2000', '2019-03-06 00:00:00', NULL),
(4, 1, 4, '87878', '60', '2019-03-06 00:00:00', NULL);

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

--
-- Table structure for table `facture`
--

CREATE TABLE `facture` (
  `id` int(11) NOT NULL,
  `idcompte` int(11) NOT NULL,
  `statut` int(2) NOT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `numfacture` varchar(50) DEFAULT NULL,
  `montantttc` varchar(10) DEFAULT NULL,
  `file` varchar(200) DEFAULT NULL,
  `datepayement` timestamp NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `facture`
--

INSERT INTO `facture` (`id`, `idcompte`, `statut`, `reference`, `numfacture`, `montantttc`, `file`, `datepayement`, `created`) VALUES
(2, 1, 1, 'ERdssd', '12213', '121', NULL, '2019-04-02 14:37:53', '2019-04-02 14:37:53'),
(3, 1, 1, 'dfgdfg', '121212', '1211', NULL, '2019-04-02 14:39:13', '2019-04-02 14:39:13'),
(4, 1, 1, 'eeee', '2222', '1212', NULL, '2019-04-02 14:40:15', '2019-04-02 14:40:15'),
(6, 1, 0, 'aaa', 'aaa', 'aaaa', NULL, '2019-04-03 09:08:03', '2019-04-03 09:08:03'),
(12, 1, 0, 'qqqqqq', 'qqq', 'qqq', 'nomDuFichier7209 (2).pdf', '2019-04-04 22:42:21', '2019-04-04 22:42:21'),
(13, 1, 0, 'jkljlk', 'jlkjl', 'jkjlk', 'devis.pdf', '2019-04-04 22:47:07', '2019-04-04 22:47:07'),
(14, 1, 0, 'kkk', 'bbb', 'jjj', 'inscription-132842.pdf', '2019-04-04 22:48:53', '2019-04-04 22:48:53');

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

--
-- Table structure for table `filtres`
--

CREATE TABLE `filtres` (
  `id` int(11) NOT NULL,
  `idservice` int(11) NOT NULL,
  `typeservice` varchar(100) NOT NULL,
  `etatcommande` varchar(10) DEFAULT NULL,
  `etatreglement` varchar(10) DEFAULT NULL,
  `created` varchar(20) NOT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `filtres`
--

INSERT INTO `filtres` (`id`, `idservice`, `typeservice`, `etatcommande`, `etatreglement`, `created`, `del`) VALUES
(1, 36, 'PS', '', NULL, '2018-09-26 01:16:03', NULL);

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

--
-- Table structure for table `historique`
--

CREATE TABLE `historique` (
  `id` int(11) NOT NULL,
  `idcommande` varchar(20) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `nomuser` varchar(100) DEFAULT NULL,
  `etatavant` int(11) NOT NULL,
  `etatapres` int(11) NOT NULL,
  `transport` varchar(100) NOT NULL,
  `codetracking` varchar(100) NOT NULL,
  `transportpartielle` varchar(50) DEFAULT NULL,
  `codetrackingpartielle` varchar(50) DEFAULT NULL,
  `datemaj` varchar(20) NOT NULL,
  `typeliv` varchar(200) NOT NULL,
  `reference` varchar(20) DEFAULT NULL,
  `quantitecmd` int(11) NOT NULL DEFAULT '0',
  `quantiteliv` int(11) NOT NULL DEFAULT '0',
  `del` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `historique`
--

INSERT INTO `historique` (`id`, `idcommande`, `iduser`, `nomuser`, `etatavant`, `etatapres`, `transport`, `codetracking`, `transportpartielle`, `codetrackingpartielle`, `datemaj`, `typeliv`, `reference`, `quantitecmd`, `quantiteliv`, `del`) VALUES
(1, 'DTRBRWYSA', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 10:04:54', 'Impression bons', NULL, 0, 0, 0),
(2, 'QUFAZANQS', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 10:04:54', 'Impression bons', NULL, 0, 0, 0),
(3, 'DTRBRWYSA', 2, 'Administrateur', 2, 2, 'CHRO', '', NULL, NULL, '2018-09-26 10:11:39', 'Complète', NULL, 0, 0, 0),
(4, 'DTRBRWYSA', 2, 'Administrateur', 2, 4, 'CHRO', 'XF963364871FR', NULL, NULL, '2018-09-26 08:13:20', '<a href=\'labels/chronopost/chro_DTRBRWYSA_XF963364871FR_20180926081319.pdf\' target=\'_blank\'>Génération étiquette</a>', NULL, 0, 0, 0),
(5, 'HVUCYAIDG', 2, 'Administrateur', 1, 1, 'CHRO', '', NULL, NULL, '2018-09-26 10:22:10', 'Complète', NULL, 0, 0, 0),
(6, 'HVUCYAIDG', 2, 'Administrateur', 1, 4, 'CHRO', 'XF963365333FR', NULL, NULL, '2018-09-26 08:22:30', '<a href=\'labels/chronopost/chro_HVUCYAIDG_XF963365333FR_20180926082229.pdf\' target=\'_blank\'>Génération étiquette</a>', NULL, 0, 0, 0),
(7, 'DTRBRWYSA', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 16:53:22', 'Impression bons', NULL, 0, 0, 0),
(8, 'QUFAZANQS', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 16:53:22', 'Impression bons', NULL, 0, 0, 0),
(9, 'HVUCYAIDG', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 19:09:11', 'Impression bons', NULL, 0, 0, 0),
(10, 'HVUCYAIDG', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 23:06:30', 'Impression bons', NULL, 0, 0, 0),
(11, 'DTRBRWYSA', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 23:06:30', 'Impression bons', NULL, 0, 0, 0),
(12, 'FFATNOMMJ', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 23:07:58', 'Impression bons', NULL, 0, 0, 0),
(13, 'KHWLILZLL', 2, 'Administrateur', 1, 2, '', '', NULL, NULL, '2018-09-26 23:07:58', 'Impression bons', NULL, 0, 0, 0),
(14, 'VYLTRLEYG', 2, 'Administrateur', 1, 1, 'TNT', '', NULL, NULL, '2018-09-26 23:19:26', 'Complète', NULL, 0, 0, 0),
(15, 'VYLTRLEYG', 1, 'Support', 1, 4, 'TNT', '3315697000628212', NULL, NULL, '2018-09-27 15:12:07', '<a href=\'public/labels/tnt/tnt_VYLTRLEYG_3315697000628212.pdf\' target=\'_blank\'>Génération étiquette</a>', NULL, 0, 0, 0),
(16, 'OHSATSERP', 1, 'Support', 1, 3, '', '', NULL, NULL, '2018-09-28 08:42:04', 'Complète', NULL, 0, 0, 0),
(17, 'UOYEVOLI', 1, 'Support', 1, 3, '', '', NULL, NULL, '2018-09-28 08:44:06', 'Complète', NULL, 0, 0, 0),
(18, 'VYLTRLEYG', 1, 'Support', 4, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 08:55:05', 'Complète', NULL, 0, 0, 0),
(19, 'VYLTRLEYG', 1, 'Support', 3, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 08:55:54', 'Complète', NULL, 0, 0, 0),
(20, 'VYLTRLEYG', 1, 'Support', 3, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 08:56:30', 'Complète', NULL, 0, 0, 0),
(21, 'VYLTRLEYG', 1, 'Support', 3, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 09:19:16', 'Complète', NULL, 0, 0, 0),
(22, 'VYLTRLEYG', 1, 'Support', 3, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 09:19:44', 'Complète', NULL, 0, 0, 0),
(23, 'VYLTRLEYG', 1, 'Support', 3, 3, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 09:20:32', 'Complète', NULL, 0, 0, 0),
(24, 'JXRTWYFVL', 1, 'Support', 1, 3, '', '', NULL, NULL, '2018-09-28 09:21:37', 'Complète', NULL, 0, 0, 0),
(25, 'JXRTWYFVL', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 09:22:28', 'Complète', NULL, 0, 0, 0),
(26, 'JXRTWYFVL', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 09:26:17', 'Complète', NULL, 0, 0, 0),
(27, 'JXRTWYFVL', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 09:37:35', 'Complète', NULL, 0, 0, 0),
(28, 'XKBKNABJK', 1, 'Support', 1, 3, '', '', NULL, NULL, '2018-09-28 09:38:20', 'Complète', NULL, 0, 0, 0),
(29, 'XKBKNABJK', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 09:38:40', 'Complète', NULL, 0, 0, 0),
(30, 'VYLTRLEYG', 1, 'Support', 4, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:08:46', 'Complète', NULL, 0, 0, 0),
(31, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:23:23', 'Complète', NULL, 0, 0, 0),
(32, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:23:34', 'Complète', NULL, 0, 0, 0),
(33, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:26:21', 'Complète', NULL, 0, 0, 0),
(34, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:27:42', 'Complète', NULL, 0, 0, 0),
(35, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:27:47', 'Complète', NULL, 0, 0, 0),
(36, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:28:07', 'Complète', NULL, 0, 0, 0),
(37, 'UOYEVOLI', 1, 'Support', 3, 6, '', '', NULL, NULL, '2018-09-28 10:36:25', 'Complète', NULL, 0, 0, 0),
(38, 'OHSATSERP', 1, 'Support', 3, 6, '', '', NULL, NULL, '2018-09-28 10:38:57', 'Complète', NULL, 0, 0, 0),
(39, 'VYLTRLEYG', 1, 'Support', 7, 6, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:45:03', 'Complète', NULL, 0, 0, 0),
(40, 'VYLTRLEYG', 1, 'Support', 6, 6, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:45:25', 'Complète', NULL, 0, 0, 0),
(41, 'VYLTRLEYG', 1, 'Support', 6, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:45:55', 'Complète', NULL, 0, 0, 0),
(42, 'VYLTRLEYG', 1, 'Support', 7, 7, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 10:46:41', 'Complète', NULL, 0, 0, 0),
(43, 'QUFAZANQS', 1, 'Support', 2, 3, '', '', NULL, NULL, '2018-09-28 10:47:10', 'Complète', NULL, 0, 0, 0),
(44, 'QUFAZANQS', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 10:47:29', 'Complète', NULL, 0, 0, 0),
(45, 'MFIRSNVMX', 1, 'Support', 1, 3, '', '', NULL, NULL, '2018-09-28 10:48:51', 'Complète', NULL, 0, 0, 0),
(46, 'MFIRSNVMX', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 10:49:07', 'Complète', NULL, 0, 0, 0),
(47, 'XKBKNABJK', 1, 'Support', 4, 8, '', '', NULL, NULL, '2018-09-28 10:51:13', 'Complète', NULL, 0, 0, 0),
(48, 'VYLTRLEYG', 1, 'Support', 7, 8, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 11:22:56', 'Complète', NULL, 0, 0, 0),
(49, 'MFIRSNVMX', 1, 'Support', 4, 3, '', '', NULL, NULL, '2018-09-28 11:25:05', 'Complète', NULL, 0, 0, 0),
(50, 'OHSATSERP', 1, 'Support', 6, 3, '', '', NULL, NULL, '2018-09-28 11:25:39', 'Complète', NULL, 0, 0, 0),
(51, 'OHSATSERP', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 11:27:28', 'Complète', NULL, 0, 0, 0),
(52, 'VYLTRLEYG', 1, 'Support', 8, 4, 'TNT', '3315697000628212', NULL, NULL, '2018-09-28 11:28:23', 'Complète', NULL, 0, 0, 0),
(53, 'UOYEVOLI', 1, 'Support', 6, 3, '', '', NULL, NULL, '2018-09-28 11:30:10', 'Complète', NULL, 0, 0, 0),
(54, 'UOYEVOLI', 1, 'Support', 4, 3, '', '', NULL, NULL, '2018-09-28 11:30:23', 'Complète', NULL, 0, 0, 0),
(55, 'FFATNOMMJ', 1, 'Support', 2, 3, '', '', NULL, NULL, '2018-09-28 11:31:12', 'Complète', NULL, 0, 0, 0),
(56, 'FFATNOMMJ', 1, 'Support', 3, 3, '', '', NULL, NULL, '2018-09-28 11:31:25', 'Complète', NULL, 0, 0, 0),
(57, 'FFATNOMMJ', 1, 'Support', 4, 8, '', '', NULL, NULL, '2018-09-28 11:31:43', 'Complète', NULL, 0, 0, 0),
(58, 'FFATNOMMJ', 1, 'Support', 8, 4, '', '', NULL, NULL, '2018-09-28 11:32:14', 'Complète', NULL, 0, 0, 0),
(59, 'FFATNOMMJ', 1, 'Support', 4, 4, '', '', NULL, NULL, '2018-09-28 11:34:13', 'Complète', NULL, 0, 0, 0),
(60, 'MFIRSNVMX', 1, 'Support', 3, 2, 'CHRO', '', NULL, NULL, '2018-10-04 11:16:44', 'Complète', NULL, 0, 0, 0),
(61, 'MFIRSNVMX', 1, 'Support', 4, 4, 'CHRO', 'XF963805888FR', NULL, NULL, '2018-10-04 11:20:05', '<a href=\'labels/chronopost/chro_MFIRSNVMX_XF963805888FR_20181004112004.pdf\' target=\'_blank\'>Génération étiquette</a>', NULL, 0, 0, 0),
(62, 'VYLTRLEYG', 1, 'Support', 4, 4, 'GEOD-PLAT', '3315697000628212', NULL, NULL, '2018-10-18 16:55:45', 'Complète', NULL, 0, 0, 0),
(63, 'DTRBRWYSA', 1, 'Support', 1, 2, '', '', NULL, NULL, '2019-03-12 14:09:53', 'Impression bons', NULL, 0, 0, 0);

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

--
-- Table structure for table `historiquecommande`
--

CREATE TABLE `historiquecommande` (
  `id` int(11) NOT NULL,
  `idcommande` varchar(20) NOT NULL,
  `idlignecommande` varchar(20) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `nomuser` varchar(100) DEFAULT NULL,
  `etat` int(11) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `marque` varchar(400) DEFAULT NULL,
  `titre` varchar(500) DEFAULT NULL,
  `quantitecmd` int(11) NOT NULL DEFAULT '0',
  `quantiteliv` int(11) NOT NULL DEFAULT '0',
  `quantiteretour` int(11) NOT NULL DEFAULT '0',
  `poids` int(11) DEFAULT NULL,
  `datemaj` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `del` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `historiquecommande`
--

INSERT INTO `historiquecommande` (`id`, `idcommande`, `idlignecommande`, `iduser`, `nomuser`, `etat`, `reference`, `marque`, `titre`, `quantitecmd`, `quantiteliv`, `quantiteretour`, `poids`, `datemaj`, `del`) VALUES
(1, 'QUFAZANQS', '18', 1, 'Support', 4, 'demo_2', 'Fashion Manufacturer', 'Chemisier - Taille : S, Couleur : Noir', 1, 1, 0, 0, '2018-09-28 14:40:11', 0),
(2, 'QUFAZANQS', '18', 1, 'Support', 4, 'demo_2', 'Fashion Manufacturer', 'Chemisier - Taille : S, Couleur : Noir', 1, 1, 0, 0, '2018-09-28 14:40:15', 0),
(3, 'QUFAZANQS', '18', 1, 'Support', 4, 'demo_2', 'Fashion Manufacturer', 'Chemisier - Taille : S, Couleur : Noir', 1, 1, 0, 0, '2018-09-28 14:40:37', 0);

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

--
-- Table structure for table `incidentcommentaire`
--

CREATE TABLE `incidentcommentaire` (
  `id` int(11) NOT NULL,
  `idincident` varchar(20) NOT NULL,
  `iduser` varchar(20) NOT NULL,
  `roleuser` varchar(50) DEFAULT NULL,
  `nomuser` varchar(100) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `commentaire` text NOT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `incidents`
--

CREATE TABLE `incidents` (
  `id` int(11) NOT NULL,
  `titre` varchar(200) DEFAULT NULL,
  `etat` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `iduser` varchar(20) NOT NULL,
  `nomuser` varchar(100) NOT NULL,
  `roleuser` varchar(100) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `description` varchar(300) NOT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `incidents`
--

INSERT INTO `incidents` (`id`, `titre`, `etat`, `type`, `iduser`, `nomuser`, `roleuser`, `created`, `updated`, `description`, `del`) VALUES
(1, 'jk', '1', '5', '1', 'Support', 'superadmin', '2019-03-31 23:04:32', '2019-03-31 22:04:32', 'hkjhkj', NULL);

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

--
-- Table structure for table `lignecommande`
--

CREATE TABLE `lignecommande` (
  `id` int(11) NOT NULL,
  `idcommande` varchar(200) NOT NULL,
  `idlignecommande` varchar(20) NOT NULL,
  `etat` int(11) DEFAULT '1',
  `refproduit` varchar(100) NOT NULL,
  `marque` varchar(100) DEFAULT NULL,
  `fournisseur` varchar(100) DEFAULT NULL,
  `produitid` varchar(20) NOT NULL,
  `produitrelprincipalid` varchar(20) DEFAULT NULL,
  `quantite` varchar(10) NOT NULL,
  `quantitelivree` int(11) DEFAULT '0',
  `qantitealivrer` int(11) DEFAULT '0',
  `qantiteretourne` int(11) DEFAULT NULL,
  `quantiterembourse` int(11) DEFAULT NULL,
  `nom` varchar(500) NOT NULL,
  `prixunitaire` varchar(20) NOT NULL,
  `prixunitaireht` varchar(100) DEFAULT NULL,
  `prixligne` varchar(20) DEFAULT NULL,
  `tva` varchar(10) DEFAULT NULL,
  `tvataux` varchar(10) DEFAULT NULL,
  `poids` varchar(10) DEFAULT NULL,
  `remisetype` varchar(10) DEFAULT NULL,
  `remisevaleur` varchar(20) DEFAULT NULL,
  `remisedescription` varchar(100) DEFAULT NULL,
  `optioncmd` varchar(20) DEFAULT NULL,
  `datemaj` datetime DEFAULT NULL,
  `clientnom` varchar(20) DEFAULT NULL,
  `clientprenom` varchar(20) DEFAULT NULL,
  `clientemail` varchar(100) DEFAULT NULL,
  `datecommande` varchar(20) DEFAULT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lignecommande`
--

INSERT INTO `lignecommande` (`id`, `idcommande`, `idlignecommande`, `etat`, `refproduit`, `marque`, `fournisseur`, `produitid`, `produitrelprincipalid`, `quantite`, `quantitelivree`, `qantitealivrer`, `qantiteretourne`, `quantiterembourse`, `nom`, `prixunitaire`, `prixunitaireht`, `prixligne`, `tva`, `tvataux`, `poids`, `remisetype`, `remisevaleur`, `remisedescription`, `optioncmd`, `datemaj`, `clientnom`, `clientprenom`, `clientemail`, `datecommande`, `del`) VALUES
(1, 'QUFAZANQS', '18', 4, 'demo_2', 'Fashion Manufacturer', NULL, '2', NULL, '1', 12, NULL, 1, NULL, 'Chemisier - Taille : S, Couleur : Noir', '32.40', '27.00', '32.399822', '5.40', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'Test', 'Test', 'aaaa@aaaa.com', '2018-09-24 11:26:38', NULL),
(2, 'XKBKNABJK', '1', 4, 'demo_2', 'Fashion Manufacturer', NULL, '2', NULL, '1', 1, NULL, NULL, NULL, 'Blouse - Color : White, Size : M', '27.00', '27.00', '27', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(3, 'XKBKNABJK', '2', 4, 'demo_3', 'Fashion Manufacturer', NULL, '3', NULL, '1', 1, NULL, NULL, NULL, 'Printed Dress - Color : Orange, Size : S', '26.00', '26.00', '26', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(4, 'OHSATSERP', '3', 4, 'demo_2', 'Fashion Manufacturer', NULL, '2', NULL, '1', 1, NULL, 1, NULL, 'Blouse - Color : White, Size : M', '27.00', '27.00', '27', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(5, 'OHSATSERP', '4', 4, 'demo_6', 'Fashion Manufacturer', NULL, '6', NULL, '1', 1, NULL, 1, NULL, 'Printed Summer Dress - Color : Yellow, Size : M', '30.50', '30.50', '30.5', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(6, 'OHSATSERP', '5', 4, 'demo_7', 'Fashion Manufacturer', NULL, '7', NULL, '1', 1, NULL, 0, NULL, 'Printed Chiffon Dress - Color : Yellow, Size : S', '16.40', '16.40', '16.4', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(7, 'UOYEVOLI', '6', 4, 'demo_1', 'Fashion Manufacturer', NULL, '1', NULL, '1', 1, NULL, 1, NULL, 'Faded Short Sleeve T-shirts - Color : Orange, Size : S', '16.51', '16.51', '16.51', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(8, 'UOYEVOLI', '7', 4, 'demo_2', 'Fashion Manufacturer', NULL, '2', NULL, '1', 1, NULL, 1, NULL, 'Blouse - Color : White, Size : M', '27.00', '27.00', '27', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(9, 'UOYEVOLI', '8', 4, 'demo_6', 'Fashion Manufacturer', NULL, '6', NULL, '1', 1, NULL, 0, NULL, 'Printed Summer Dress - Color : Yellow, Size : M', '30.50', '30.50', '30.5', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(10, 'FFATNOMMJ', '9', 4, 'demo_1', 'Fashion Manufacturer', NULL, '1', NULL, '1', 1, NULL, NULL, NULL, 'Faded Short Sleeve T-shirts - Color : Orange, Size : S', '16.51', '16.51', '16.51', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(11, 'FFATNOMMJ', '10', 4, 'demo_3', 'Fashion Manufacturer', NULL, '3', NULL, '1', 1, NULL, NULL, NULL, 'Printed Dress - Color : Orange, Size : S', '26.00', '26.00', '26', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(12, 'FFATNOMMJ', '11', 4, 'demo_5', 'Fashion Manufacturer', NULL, '5', NULL, '1', 1, NULL, NULL, NULL, 'Printed Summer Dress - Color : Yellow, Size : S', '28.98', '28.98', '28.98', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(13, 'FFATNOMMJ', '12', 4, 'demo_7', 'Fashion Manufacturer', NULL, '7', NULL, '1', 1, NULL, NULL, NULL, 'Printed Chiffon Dress - Color : Yellow, Size : S', '16.40', '16.40', '16.4', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(14, 'KHWLILZLL', '13', NULL, 'demo_1', 'Fashion Manufacturer', NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, 'Faded Short Sleeve T-shirts - Color : Orange, Size : S', '16.51', '16.51', '16.51', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(15, 'KHWLILZLL', '14', NULL, 'demo_2', 'Fashion Manufacturer', NULL, '2', NULL, '1', NULL, NULL, NULL, NULL, 'Blouse - Color : Black, Size : S', '27.00', '27.00', '27', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(16, 'KHWLILZLL', '15', NULL, 'demo_3', 'Fashion Manufacturer', NULL, '3', NULL, '1', NULL, NULL, NULL, NULL, 'Printed Dress - Color : Orange, Size : S', '26.00', '26.00', '26', '0.00', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DOE', 'John', 'pub@prestashop.com', '2018-09-12 15:06:14', NULL),
(17, 'JXRTWYFVL', '16', 4, 'demo_1', 'Fashion Manufacturer', NULL, '1', NULL, '1', 1, NULL, NULL, NULL, 'T-shirt délavé à manches courtes - Taille : S, Couleur : Orange', '19.81', '16.51', '19.812', '3.30', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'Durand', 'Alain', 'monemail@gmail.com', '2018-09-12 15:14:44', NULL),
(18, 'MFIRSNVMX', '17', 4, 'demo_1', 'Fashion Manufacturer', NULL, '1', NULL, '1', 1, NULL, NULL, NULL, 'T-shirt délavé à manches courtes - Taille : S, Couleur : Orange', '19.81', '16.51', '19.812', '3.30', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'Test', 'Test', 'aaaa@aaaa.com', '2018-09-18 11:11:47', NULL),
(19, 'L2903750yH6e', '1552', NULL, 'YWS405G', 'Swatch Swiss', '', 'YWS405G', 'YWS405G', '1', NULL, NULL, NULL, NULL, 'BEAULIEU', '93', NULL, '93', '14.73', '20', '0', '1', '7', '', NULL, NULL, 'Cousin', 'philippe', 'zzzzz@gmail.com', '2018-03-23 11:54:58', NULL),
(20, 'L2903750yH6e', '1562', NULL, 'RB3016_2', 'Ray-Ban', '', 'RB3016_2', 'RB3016', '1', NULL, NULL, NULL, NULL, 'CLUBMASTER CLASSIC C Bleu', '178', NULL, '178', '28.18', '20', '0', '1', '7', '', NULL, NULL, 'Cousin', 'philippe', 'zzzzz@gmail.com', '2018-03-23 11:54:58', NULL),
(21, 'L29037o4xh98', '1652', NULL, 'SUSB402', 'Swatch Swiss', '18253015', 'SUSB402', 'SUSB402', '1', NULL, NULL, NULL, NULL, 'NITESPEED', '38', NULL, '38', '6.33', '20', '0', '1', '7', '', NULL, NULL, 'sqsqs', 'qsqs', 'ssss@sss.ss', '2018-04-23 14:38:48', NULL),
(22, 'L29037ixYkJg', '1742', NULL, 'tu47ni89qu', 'Orchestra', '', 'tu47ni89qu', 'tu47ni89qu', '1', NULL, NULL, NULL, NULL, 'Tunique rayée Violetta', '15', NULL, '15', '2.5', '20', '0', '1', '7', '', NULL, NULL, 'Dupont', 'philippe', 'dupont@pasgmail.com', '2018-05-29 13:53:47', NULL),
(23, 'L29037UQO346', '1752', NULL, 'tu47ni89qu', 'Orchestra', '', 'tu47ni89qu', 'tu47ni89qu', '1', NULL, NULL, NULL, NULL, 'Tunique rayée Violetta', '15', NULL, '15', '2.5', '20', '0', '1', '7', '', NULL, NULL, 'Dupont', 'philippe', 'dupont@pasgmail.com', '2018-06-14 17:29:28', NULL),
(24, 'L29037XXnuKY', '1762', NULL, '50272454', 'Hugo Boss', '', '50272454', '50272454', '1', NULL, NULL, NULL, NULL, 'Chemise à poignets mousquetaires Slim Fit « Jaiden » avec col italien par BOSS', '138', NULL, '138', '21.85', '20', '0', '1', '7', '', NULL, NULL, 'Dupont', 'philippe', 'dupont@pasgmail.com', '2018-06-14 17:31:22', NULL),
(25, 'L290378FyWdW', '1772', NULL, 'RB3025_2', 'Ray-Ban', '', 'RB3025_2', 'RB3025', '1', NULL, NULL, NULL, NULL, 'AVIATOR FLASH LENSES A Vert', '223', NULL, '223', '35.31', '20', '0', '1', '7', '', NULL, NULL, 'test', 'test', 'wanatek.test@gmail.com', '2018-07-11 18:21:41', NULL),
(26, 'L29037jzpAlc', '1782', NULL, '116400GV', 'Rolex', '', '116400GV', '116400GV', '3', NULL, NULL, NULL, NULL, 'Milgauss', '5493', NULL, '16479', '2609.18', '20', '0', '1', '21', '', NULL, NULL, 'saad', 'te', 'xolasotemi@fxprix.com', '2018-07-20 19:01:40', NULL),
(27, 'L29037SePoJh', '1792', NULL, 'SUSB402', 'Swatch Swiss', '18253015', 'SUSB402', 'SUSB402', '1', NULL, NULL, NULL, NULL, 'NITESPEED', '38', NULL, '38', '6.02', '20', '0', '1', '7', '', NULL, NULL, 'Moumen', 'Abdel', 'amoumen@powerboutique.com', '2018-08-11 01:53:57', NULL),
(28, 'L29037SePoJh', '1802', NULL, '50272454', 'Hugo Boss', '', '50272454', '50272454', '2', NULL, NULL, NULL, NULL, 'Chemise à poignets mousquetaires Slim Fit « Jaiden » avec col italien par BOSS', '138', NULL, '276', '43.7', '20', '0', '1', '14', '', NULL, NULL, 'Moumen', 'Abdel', 'amoumen@powerboutique.com', '2018-08-11 01:53:57', NULL),
(29, 'VYLTRLEYG', '19', 4, 'demo_4', 'Fashion Manufacturer', NULL, '4', NULL, '6', 6, NULL, 0, 3, 'Robe imprimée - Taille : M, Couleur : Beige', '61.19', '50.99', '122.385968', '10.20', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DURANT', 'Patrick', 'abdel@opteam-solutions.com', '2018-09-26 23:13:04', NULL),
(30, 'VYLTRLEYG', '20', 4, 'demo_3', 'Fashion Manufacturer', NULL, '3', NULL, '2', 2, NULL, 2, 2, 'Robe imprimée - Taille : L, Couleur : Orange', '31.20', '26.00', '31.199822', '5.20', NULL, '0.00', NULL, '0.00', NULL, NULL, NULL, 'DURANT', 'Patrick', 'abdel@opteam-solutions.com', '2018-09-26 23:13:04', NULL);

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

--
-- Table structure for table `marketing`
--

CREATE TABLE `marketing` (
  `id` int(11) NOT NULL,
  `nom` varchar(100) NOT NULL,
  `sigle` varchar(20) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `acurl` varchar(500) DEFAULT NULL,
  `ackey` varchar(500) DEFAULT NULL,
  `mailchimpurl` varchar(500) DEFAULT NULL,
  `mailchimpkey` varchar(500) DEFAULT NULL,
  `etat` varchar(2) NOT NULL,
  `del` int(11) NOT NULL,
  `synclist` int(10) NOT NULL,
  `idlist` varchar(100) DEFAULT NULL,
  `nomlist` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `moncompte`
--

CREATE TABLE `moncompte` (
  `id` int(11) NOT NULL,
  `licence` varchar(50) DEFAULT NULL,
  `dateactivation` varchar(20) DEFAULT NULL,
  `statutcompte` int(1) DEFAULT NULL,
  `statutabonnement` int(1) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `prenom` varchar(100) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `fix` varchar(20) DEFAULT NULL,
  `adresse` varchar(100) DEFAULT NULL,
  `cp` varchar(100) DEFAULT NULL,
  `ville` varchar(100) DEFAULT NULL,
  `pays` varchar(100) DEFAULT NULL,
  `societe` varchar(200) DEFAULT NULL,
  `siret` varchar(50) DEFAULT NULL,
  `site` varchar(250) DEFAULT NULL,
  `logo` varchar(250) DEFAULT NULL,
  `guideinstallation` varchar(500) DEFAULT NULL,
  `created` varchar(20) NOT NULL,
  `del` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `moncompte`
--

INSERT INTO `moncompte` (`id`, `licence`, `dateactivation`, `statutcompte`, `statutabonnement`, `email`, `nom`, `prenom`, `tel`, `fix`, `adresse`, `cp`, `ville`, `pays`, `societe`, `siret`, `site`, `logo`, `guideinstallation`, `created`, `del`) VALUES
(1, '', '', 0, 0, 'Test@test.com', 'hay02119', 'Test', '', '', '', '', '', '', '', '', '', '', 'a:4:{s:9:"moncompte";s:1:"1";s:11:"parametrage";s:1:"1";s:14:"administration";s:1:"1";s:6:"themes";s:1:"1";}', '2018-09-12 15:48:44', 0);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `statut` tinyint(4) NOT NULL,
  `servicename` varchar(100) NOT NULL,
  `servicesigle` varchar(100) NOT NULL,
  `servicestype` varchar(50) DEFAULT NULL,
  `sendcodetracking` tinyint(2) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `statut`, `servicename`, `servicesigle`, `servicestype`, `sendcodetracking`, `created`) VALUES
(32, 0, 'Ebay', 'EBAY', 'marketplace', 0, '2018-09-12 06:48:43'),
(36, 1, 'Prestashop', 'PS', 'cms', 0, '2018-09-17 16:58:33'),
(37, 0, 'PowerBoutique', 'PB', 'cms', 1, '2018-09-17 16:59:02'),
(38, 1, 'Dolibarr', 'DOL', 'erp', 0, '2018-09-24 15:01:19');

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

--
-- Table structure for table `services_attributs`
--

CREATE TABLE `services_attributs` (
  `id` int(11) NOT NULL,
  `cle` varchar(100) NOT NULL,
  `value` varchar(2000) DEFAULT NULL,
  `type` varchar(100) NOT NULL,
  `typeparam` varchar(100) NOT NULL,
  `libelle` varchar(100) NOT NULL,
  `required` tinyint(4) NOT NULL,
  `placeholder` varchar(500) DEFAULT NULL,
  `servicesigle` varchar(100) NOT NULL,
  `serviceid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services_attributs`
--

INSERT INTO `services_attributs` (`id`, `cle`, `value`, `type`, `typeparam`, `libelle`, `required`, `placeholder`, `servicesigle`, `serviceid`) VALUES
(109, 'token', '', 'text', 'attribut', 'TOKEN', 1, '', 'EBAY', 32),
(110, 'cle', '', 'text', 'attribut', 'Clé', 1, '', 'EBAY', 32),
(120, 'nomshop', 'Prestashop Test', 'text', 'info', 'Nom', 0, 'exemple: Ma boutique', 'PS', 36),
(121, 'url', 'http://www.presta.wanatek.com', 'text', 'attribut', 'URL de la boutique', 1, 'exemple: http://maboutique.com', 'PS', 36),
(122, 'cle', 'E85IPF4B9YKML9U66L2PRVGMUTWFNW31', 'text', 'attribut', 'Clé', 1, 'exemple: VGJM3HsqdsV5MWCsdA26', 'PS', 36),
(123, 'nomshop', 'PowerBoutique Test', 'text', 'info', 'Nom', 0, 'exemple: Ma boutique', 'PB', 37),
(124, 'domaineshop', 'http://back.ph1.powerboutique.net/', 'text', 'info', 'URL de la boutique', 0, 'exemple: http://maboutique.com', 'PB', 37),
(125, 'url', 'https://back.ph1.powerboutique.net/maj_489/api/', 'text', 'attribut', 'URL API', 1, 'exemple: http://back.ph1.powerboutique.net/maj_489/api/', 'PB', 37),
(126, 'licence', 'L29037', 'text', 'attribut', 'Licence', 1, 'exemple: L12112', 'PB', 37),
(127, 'username', '9a2pjt', 'text', 'attribut', 'Nom d\'utilisateur', 1, '', 'PB', 37),
(128, 'password', 'e6ro07', 'text', 'attribut', 'Mot de passe', 1, '', 'PB', 37),
(129, 'profil', 'api29037', 'text', 'attribut', 'Profil', 1, '', 'PB', 37),
(130, 'titre', 'Dolibarr test ', 'text', 'info', 'Titre', 0, '', 'DOL', 38),
(131, 'url', 'http://dolibarr.wanatek.fr:80/api/index.php/', 'text', 'attribut', 'URL', 1, 'exemple: http://dolibarurl:80/api/index.php/', 'DOL', 38),
(132, 'cle', '1aab04bad329a789ba7e3f180e7d03c8a090b0f6', 'text', 'attribut', 'Clé', 1, 'exemple: b8bef982egh6e015860er562ceb106241a4cc36', 'DOL', 38);

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

--
-- Table structure for table `transporteur`
--

CREATE TABLE `transporteur` (
  `id` int(11) NOT NULL,
  `nom` varchar(100) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sigle` varchar(20) NOT NULL,
  `url` varchar(500) DEFAULT NULL,
  `etat` varchar(2) NOT NULL,
  `idtransportpwb` varchar(100) DEFAULT NULL,
  `wslogin` varchar(200) DEFAULT NULL,
  `wspassword` varchar(200) DEFAULT NULL,
  `wsnumcompte` varchar(20) DEFAULT NULL,
  `adrcivilite` varchar(10) DEFAULT NULL,
  `adrname` varchar(100) DEFAULT NULL,
  `adremail` varchar(100) DEFAULT NULL,
  `adrtel` varchar(20) DEFAULT NULL,
  `adrville` varchar(20) DEFAULT NULL,
  `adrcp` varchar(20) DEFAULT NULL,
  `adrpays` varchar(100) DEFAULT NULL,
  `adrcodepays` varchar(10) DEFAULT NULL,
  `adradress1` varchar(500) DEFAULT NULL,
  `adradress2` varchar(500) DEFAULT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transporteur`
--

INSERT INTO `transporteur` (`id`, `nom`, `created`, `sigle`, `url`, `etat`, `idtransportpwb`, `wslogin`, `wspassword`, `wsnumcompte`, `adrcivilite`, `adrname`, `adremail`, `adrtel`, `adrville`, `adrcp`, `adrpays`, `adrcodepays`, `adradress1`, `adradress2`, `del`) VALUES
(1, 'Colissimo Suivi', '2018-10-17 08:21:22', 'COLI', 'vvvv', '0', NULL, '', 'vvv', NULL, 'M', 'vvv', 'vvv@vvvv.vv', '06548552', 'vvv', '1245', 'France', NULL, 'dddd', 'dd', NULL),
(2, 'Chronopost', '2018-10-17 14:17:12', 'CHRO', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'TNT', '2018-10-17 14:17:49', 'TNT', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Geodis', '2018-10-17 14:18:04', 'GEOD', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'Mondial Relais', '2018-10-17 14:18:16', 'MOND', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'Geodis - plat', '2018-10-18 14:57:43', 'GEOD', '', '0', NULL, '', 'dddddd', NULL, 'M', 'dd', 'dddd@dddd.d', '065254552', 'dddd', '41412', 'France', NULL, 'ssssss', '', NULL),
(7, 'Geodis', '2018-10-18 15:45:56', 'GEOD', '', '1', NULL, '', 'jhkhjk', NULL, 'M', 'hkhjk', 'hkhjk@iiii.jj', '04524545', 'mmmm', '42545', 'France', NULL, 'mù!lmù', 'lmù', NULL);

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

--
-- Table structure for table `typeexpedition`
--

CREATE TABLE `typeexpedition` (
  `id` int(11) NOT NULL,
  `idtransporteur` int(10) NOT NULL,
  `sigletransporteur` varchar(20) NOT NULL,
  `typeexpedition` varchar(250) NOT NULL,
  `titre` varchar(500) NOT NULL,
  `datacreation` varchar(100) NOT NULL,
  `del` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `typeexpedition`
--

INSERT INTO `typeexpedition` (`id`, `idtransporteur`, `sigletransporteur`, `typeexpedition`, `titre`, `datacreation`, `del`) VALUES
(8, 1, 'COLI', 'DOM', 'Colissimo Domicile - sans signature', '2018-10-18 15:07:25', NULL),
(9, 1, 'COLI', 'A2P', 'Colissimo - Point Retrait – en relais', '2018-10-18 15:07:25', NULL),
(13, 7, 'GEOD', 'GEOD-PLAT', 'Geodis - Fichier plat', '2018-10-18 16:55:02', NULL);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(10) UNSIGNED NOT NULL,
  `role` varchar(20) NOT NULL,
  `rolenom` varchar(500) DEFAULT NULL,
  `rolerights` varchar(500) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `nom` varchar(200) NOT NULL,
  `prenom` varchar(200) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `displayname` varchar(50) DEFAULT NULL,
  `password` varchar(128) NOT NULL,
  `state` smallint(5) UNSIGNED DEFAULT NULL,
  `photo` varchar(200) DEFAULT NULL,
  `lastacces` varchar(20) DEFAULT NULL,
  `firstacces` int(10) NOT NULL DEFAULT '0',
  `selectedtheme` varchar(100) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `role`, `rolenom`, `rolerights`, `username`, `nom`, `prenom`, `email`, `displayname`, `password`, `state`, `photo`, `lastacces`, `firstacces`, `selectedtheme`, `created`) VALUES
(1, 'superadmin', 'Super Admin', 'superadmin', 'administrateur', 'super', 'admin', 'administrateur@gmail.com', 'Support', '$2y$14$n40ySyjMLzJyveEPn51MieC8DBixkEa5WUoY/35pQoqQ9p3QZGXw.', 1, '5.png', NULL, 1, 'theme-1', '2018-05-22 14:22:11'),
(2, 'admin', 'admin', 'admin', 'admin', 'Admin', '1', 'admin@gmail.com', 'Administrateur', '$2y$14$SAuaT45BfoxST/ETCZSHQuBBytAIKBBg3xoNeI7n4aHc/cCqn0bOe', 1, NULL, NULL, 1, 'theme-1', '2018-06-20 14:46:50'),
(6, 'assistante', 'Rôle 4', 'assistante', 'hubasyou', 'Administrateur', 'administrateur', 'usertest@hubasyou.fr', 'Administrateur', '$2y$14$htvuZpjO256zqoW8NVSY8ONvKGM1jQfAt5XnXHIxBbK9hxRdpsdea', 1, NULL, NULL, 0, NULL, '2018-09-12 15:39:39'),
(7, 'client', 'Client', 'client', 'client1', 'client', 'test', 'client1@gmail.com', 'Mon Client1', '$2y$14$fUg8.yU3expaII9YMxoXjurc7mzsr94wleMR.GFFfazDOm55nWNye', 1, NULL, NULL, 1, 'theme-1', '2019-03-21 09:34:11');

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

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `id` int(11) NOT NULL,
  `nom` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `role_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_default` tinyint(1) DEFAULT '0',
  `rights` text COLLATE utf8_unicode_ci,
  `color` text COLLATE utf8_unicode_ci,
  `parent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`id`, `nom`, `role_id`, `is_default`, `rights`, `color`, `parent`, `created`) VALUES
(1, 'Rôle 1', 'superadmin', NULL, 'superadmin', '#e74c3c', NULL, '2017-06-01 13:19:09'),
(2, 'Rôle 2', 'admin', NULL, 'admin', '#3498db', NULL, '2017-06-01 13:19:09'),
(3, 'Rôle 3', 'livraison', NULL, 'livraison', '#795447', NULL, '2017-06-01 13:19:09'),
(4, 'Rôle 4', 'assistante', NULL, 'assistante', '#2ecd71', NULL, '2017-06-01 13:19:09'),
(5, 'Client', 'client', NULL, 'client', '#f1c40e', NULL, '2019-03-21 10:30:33');

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

--
-- Table structure for table `user_role_linker`
--

CREATE TABLE `user_role_linker` (
  `user_id` int(11) UNSIGNED NOT NULL,
  `role_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_role_linker`
--

INSERT INTO `user_role_linker` (`user_id`, `role_id`) VALUES
(2, 'admin'),
(6, 'assistante'),
(7, 'client'),
(1, 'superadmin');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `filtres`
--
ALTER TABLE `filtres`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idservice` (`idservice`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `user_role`
--
ALTER TABLE `user_role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_role` (`role_id`) USING BTREE,
  ADD KEY `idx_parent_id` (`parent`);

--
-- Indexes for table `user_role_linker`
--
ALTER TABLE `user_role_linker`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `role_id` (`role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `article`
--
ALTER TABLE `article`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `client`
--
ALTER TABLE `client`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `commande`
--
ALTER TABLE `commande`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `commentaire`
--
ALTER TABLE `commentaire`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `devis`
--
ALTER TABLE `devis`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `facture`
--
ALTER TABLE `facture`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `filtres`
--
ALTER TABLE `filtres`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `historique`
--
ALTER TABLE `historique`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `historiquecommande`
--
ALTER TABLE `historiquecommande`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `incidentcommentaire`
--
ALTER TABLE `incidentcommentaire`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `incidents`
--
ALTER TABLE `incidents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `lignecommande`
--
ALTER TABLE `lignecommande`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `marketing`
--
ALTER TABLE `marketing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `moncompte`
--
ALTER TABLE `moncompte`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `services_attributs`
--
ALTER TABLE `services_attributs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;
--
-- AUTO_INCREMENT for table `transporteur`
--
ALTER TABLE `transporteur`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `typeexpedition`
--
ALTER TABLE `typeexpedition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `user_role`
--
ALTER TABLE `user_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
