-- http://www.phpmyadmin.net
--
-- Serveur: 127.0.0.1
-- Généré le : Sam 21 Octobre 2023 à 21:29
-- Version du serveur: 5.1.54
-- Version de PHP: 5.3.4

--
-- dbfgeii
--



--
-- Base de données: `dblefort`
--

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

--
-- Structure de la table `commentaires`
--

CREATE TABLE IF NOT EXISTS `commentaires` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `nom` varchar(25) NOT NULL,
  `auteur` varchar(40) NOT NULL,
  `email` varchar(45) NOT NULL,
  `texte` text NOT NULL,
  `date` varchar(20) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `mli_invoices`
--

CREATE TABLE IF NOT EXISTS `mli_invoices` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` text,
  `date_end` text,
  `quote` text,
  `quote_number` text,
  `archived` text,
  `payment` text,
  `order_number` text,
  `customer_id` text,
  `customer` text,
  `products` text,
  `infos` text,
  `footer_infos` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `mli_invoices`
--


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

--
-- Structure de la table `mli_options`
--

CREATE TABLE IF NOT EXISTS `mli_options` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` text,
  `option_value` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;

--
-- Contenu de la table `mli_options`
--

INSERT INTO `mli_options` (`id`, `option_name`, `option_value`) VALUES
(80, 'money_symbole', '€'),
(81, 'default_taxs', '0'),
(82, 'default_invoice_informations', ''),
(83, 'default_quote_validity', '90'),
(84, 'default_invoice_term', '30'),
(85, 'default_invoice_footer', ''),
(86, 'entreprise_contact', 'a:17:{s:8:"civility";s:0:"";s:4:"name";s:3:"WIW";s:11:"namecomplet";s:17:"Michel Boussekeyt";s:12:"adressnumber";s:1:"3";s:6:"adress";s:21:"rue Victor Schoelcher";s:13:"adresscomplet";s:0:"";s:10:"postalcode";s:5:"59790";s:4:"city";s:7:"Ronchin";s:7:"country";s:6:"France";s:5:"phone";s:0:"";s:6:"mobile";s:10:"1234567890";s:3:"fax";s:0:"";s:4:"mail";s:16:"fatima@gmail.com";s:7:"website";s:0:"";s:6:"divers";s:0:"";s:3:"rcs";s:9:"2345IU456";s:4:"taxe";s:0:"";}'),
(87, 'logo', '../uploads/_logo_appli.jpg'),
(88, 'unknow', 'unknow');

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

--
-- Structure de la table `mli_payments`
--

CREATE TABLE IF NOT EXISTS `mli_payments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` text,
  `id_invoice` text,
  `mode` text,
  `amount` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

--
-- Contenu de la table `mli_payments`
--

INSERT INTO `mli_payments` (`id`, `date`, `id_invoice`, `mode`, `amount`) VALUES
(1, '', '', '', ''),
(2, '', '', '', ''),
(3, '', '', '', ''),
(4, '', '', '', ''),
(5, '', '', '', ''),
(6, '', '', '', ''),
(7, '', '', '', ''),
(8, '', '', '', ''),
(9, '', '', '', ''),
(10, '', '', '', ''),
(11, '', '', '', ''),
(12, '', '', '', ''),
(13, '', '', '', ''),
(14, '', '', '', ''),
(15, '', '', '', ''),
(16, '', '', '', ''),
(17, '', '', '', ''),
(18, '', '', '', ''),
(19, '', '', '', ''),
(20, '', '', '', ''),
(21, '', '', '', '');

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

--
-- Structure de la table `mli_quotes`
--

CREATE TABLE IF NOT EXISTS `mli_quotes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` text,
  `date_end` text,
  `invoice` text,
  `invoice_number` text,
  `archived` text,
  `display_payment` text,
  `order_number` text,
  `customer_id` text,
  `customer` text,
  `products` text,
  `infos` text,
  `footer_infos` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

--
-- Contenu de la table `mli_quotes`
--

INSERT INTO `mli_quotes` (`id`, `date`, `date_end`, `invoice`, `invoice_number`, `archived`, `display_payment`, `order_number`, `customer_id`, `customer`, `products`, `infos`, `footer_infos`) VALUES
(18, '16/05/2022', '16/06/2022', '1', '1', 'false', '159', '1', '7', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:2:{i:0;a:5:{s:3:"qty";s:2:"24";s:3:"ref";s:4:"2351";s:11:"description";s:38:"4 cartons de 6 bouteilles de vin rosé";s:5:"price";s:3:"3.2";s:5:"taxes";s:2:"20";}i:1;a:5:{s:3:"qty";s:2:"12";s:3:"ref";s:4:"6543";s:11:"description";s:14:"bidons d''huile";s:5:"price";s:3:"4.7";s:5:"taxes";s:2:"10";}}', 'je sais pas infos', 'je sais pas footer'),
(19, '20/08/2022', '18/11/2022', NULL, '2', 'false', NULL, '2', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:2:{i:0;a:5:{s:3:"qty";s:2:"24";s:3:"ref";s:4:"2351";s:11:"description";s:38:"4 cartons de 6 bouteilles de vin rosé";s:5:"price";s:3:"3.2";s:5:"taxes";s:2:"20";}i:1;a:5:{s:3:"qty";s:2:"12";s:3:"ref";s:4:"6543";s:11:"description";s:14:"bidons d''huile";s:5:"price";s:3:"4.7";s:5:"taxes";s:2:"10";}}', '', ''),
(20, '20/08/2022', '19/11/2022', NULL, '3', 'true', NULL, '3', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:2:{i:0;a:5:{s:3:"qty";s:2:"24";s:3:"ref";s:4:"2351";s:11:"description";s:38:"4 cartons de 6 bouteilles de vin rosé";s:5:"price";s:3:"3.2";s:5:"taxes";s:2:"20";}i:1;a:5:{s:3:"qty";s:2:"12";s:3:"ref";s:4:"6543";s:11:"description";s:14:"bidons d''huile";s:5:"price";s:3:"4.7";s:5:"taxes";s:2:"10";}}', '', ''),
(21, '20/08/2022', '20/11/2022', NULL, '4', 'false', NULL, '4', '8', 'a:5:{i:0;s:17:"Michel BOussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:2:{i:0;a:5:{s:3:"qty";s:2:"34";s:3:"ref";s:4:"2351";s:11:"description";s:38:"4 cartons de 6 bouteilles de vin rosé";s:5:"price";s:3:"3.2";s:5:"taxes";s:2:"20";}i:1;a:5:{s:3:"qty";s:2:"12";s:3:"ref";s:4:"6543";s:11:"description";s:14:"bidons d''huile";s:5:"price";s:3:"4.7";s:5:"taxes";s:2:"10";}}', '', ''),
(22, '20/08/2022', '21/11/2022', NULL, '5', 'false', NULL, '5', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:2:{i:0;a:5:{s:3:"qty";s:2:"24";s:3:"ref";s:4:"2351";s:11:"description";s:38:"4 cartons de 6 bouteilles de vin rosé";s:5:"price";s:3:"3.2";s:5:"taxes";s:2:"20";}i:1;a:5:{s:3:"qty";s:2:"12";s:3:"ref";s:4:"6543";s:11:"description";s:14:"bidons d''huile";s:5:"price";s:3:"4.7";s:5:"taxes";s:2:"10";}}', '', ''),
(23, '04/09/2022', '22/12/2022', NULL, '6', 'false', NULL, '6', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:1:{i:0;a:5:{s:3:"qty";s:1:"2";s:3:"ref";s:4:"2143";s:11:"description";s:8:"bonbonne";s:5:"price";s:2:"34";s:5:"taxes";s:2:"20";}}', '', ''),
(24, '04/09/2022', '23/12/2022', NULL, '7', 'false', NULL, '7', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:1:{i:0;a:5:{s:3:"qty";s:1:"2";s:3:"ref";s:4:"2143";s:11:"description";s:8:"bonbonne";s:5:"price";s:2:"34";s:5:"taxes";s:2:"20";}}', '', ''),
(25, '04/09/2022', '24/12/2022', NULL, '8', 'false', NULL, '8', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:1:{i:0;a:5:{s:3:"qty";s:1:"2";s:3:"ref";s:4:"2143";s:11:"description";s:8:"bonbonne";s:5:"price";s:2:"34";s:5:"taxes";s:2:"20";}}', '', ''),
(26, '04/09/2022', '25/12/2022', NULL, '9', 'false', NULL, '9', '8', 'a:5:{i:0;s:17:"Michel Boussekeyt";i:1;s:23:"3 rue Victor Schoelcher";i:2;s:13:"59790 Ronchin";i:3;s:12:"+33781391043";i:4;s:16:"fatima@gmail.com";}', 'a:1:{i:0;a:5:{s:3:"qty";s:1:"2";s:3:"ref";s:4:"2143";s:11:"description";s:8:"bonbonne";s:5:"price";s:2:"34";s:5:"taxes";s:2:"20";}}', '', '');

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

--
-- Structure de la table `mli_snproducts`
--

CREATE TABLE IF NOT EXISTS `mli_snproducts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `product_name` text COMMENT 'SN=surname name=common products name',
  `product_value` text COMMENT 'SN=surname name=common products value',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;

--
-- Contenu de la table `mli_snproducts`
--

INSERT INTO `mli_snproducts` (`id`, `product_name`, `product_value`) VALUES
(88, 'unknowN', 'unknowV');

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

--
-- Structure de la table `note`
--

CREATE TABLE IF NOT EXISTS `note` (
  `matricule` varchar(20) NOT NULL,
  `matiere` varchar(100) NOT NULL,
  `controle` decimal(4,2) DEFAULT NULL,
  `examen` decimal(4,2) DEFAULT NULL,
  `tp` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`matricule`,`matiere`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `note`
--

INSERT INTO `note` (`matricule`, `matiere`, `controle`, `examen`, `tp`) VALUES
('8330', 'POO', 12.00, NULL, NULL),
('8330', 'SDD', 13.00, 12.00, 16.00),
('8331', 'POO', 13.00, NULL, NULL),
('8331', 'SDD', 14.75, 13.00, 15.00),
('8337', 'POO', 17.00, NULL, NULL),
('8337', 'SDD', 12.50, 14.00, 17.00),
('michelbj', 'VE.R4', 16.00, 16.00, 17.00);

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

--
-- Structure de la table `sujets`
--

CREATE TABLE IF NOT EXISTS `sujets` (
  `NomSujet` longtext NOT NULL,
  `DateHeure` varchar(18) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `sujets`
--

INSERT INTO `sujets` (`NomSujet`, `DateHeure`) VALUES
('', '01-04-2023 - 15:30'),
('un dossier', '01-04-2023 - 15:32'),
('un dossier', '01-04-2023 - 15:33');

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

--
-- Structure de la table `un dossier`
--

CREATE TABLE IF NOT EXISTS `un dossier` (
  `Nom` longtext NOT NULL,
  `Email` longtext NOT NULL,
  `Titre` longtext NOT NULL,
  `Message` longtext NOT NULL,
  `Date` varchar(10) NOT NULL DEFAULT '',
  `Heure` varchar(8) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `usr`
--

