-- phpMyAdmin SQL Dump
-- version 4.7.0
-- Généré par :  Gorenja.com
-- Version du serveur :  5.7.17
-- Version de PHP :  7.1.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

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

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

--
-- Structure de la table `articles`
--

CREATE TABLE `articles` (
  `article_id` int(11) NOT NULL,
  `reference` varchar(7) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `poids` float NOT NULL,
  `couleur` varchar(15) NOT NULL,
  `diametre` float DEFAULT NULL,
  `contenance` float DEFAULT NULL,
  `note` float NOT NULL,
  `votants` smallint(6) NOT NULL,
  `matiere_id` int(11) DEFAULT NULL,
  `categorie_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `articles`
--

INSERT INTO `articles` (`article_id`, `reference`, `designation`, `poids`, `couleur`, `diametre`, `contenance`, `note`, `votants`, `matiere_id`, `categorie_id`) VALUES
(1, 'QTJ431', 'bol rond a salade', 400, 'bois', 20, NULL, 1.2, 1702, 1, 3),
(2, 'CDP4516', 'bol serigraphie fleurs', 600, 'blanc', 13, NULL, 1.3, 1693, 2, 3),
(3, 'QOF6325', 'bol serigraphie mer', 600, 'blanc', 13, NULL, 4.1, 598, 2, 3),
(4, 'ONT2873', 'bol serigraphie oiseaux', 600, 'blanc', 13, NULL, 1.7, 673, 2, 3),
(5, 'XRD6453', 'bol serigraphie savane', 600, 'blanc', 13, NULL, 1.2, 1572, 2, 3),
(6, 'WVH3219', 'bol serigraphie animaux', 600, 'blanc', 13, NULL, 3.7, 315, 2, 3),
(7, 'CJY2641', 'bol serigraphie japon', 600, 'blanc', 13, NULL, 4.9, 2384, 2, 3),
(8, 'JGT6116', 'bol serigraphie sport', 600, 'blanc', 13, NULL, 3, 2689, 2, 3),
(9, 'RXX8554', 'bol uni 1', 750, 'gris', 12, NULL, 3.1, 769, 3, 3),
(10, 'MWG3415', 'bol uni 2', 750, 'noir', 12, NULL, 3.3, 1301, 3, 3),
(11, 'ODM2448', 'bol uni 3', 750, 'blanc', 12, NULL, 6, 1436, 3, 3),
(12, 'DXJ2146', 'bol uni 4', 750, 'beige', 12, NULL, 4.6, 515, 3, 3),
(13, 'AFA7763', 'bol uni 4', 750, 'antracite', 12, NULL, 0.6, 1031, 3, 3),
(14, 'FMG3989', 'bol serie celeste', 630, 'bleu', 14, NULL, 3.7, 848, 2, 3),
(15, 'RFQ5956', 'bol serie gaia', 630, 'rose', 14, NULL, 5.8, 1149, 2, 3),
(16, 'KIT7175', 'bol enfant manga', 300, 'rose', 11, NULL, 1.1, 436, 4, 3),
(17, 'EKY8139', 'bol enfant super heros', 300, 'bleu', 11, NULL, 1.9, 1499, 4, 3),
(18, 'LWM8298', 'bol enfant uni 1', 300, 'vert', 11, NULL, 3.8, 658, 4, 3),
(19, 'CXC8115', 'bol enfant uni 2', 300, 'rouge', 11, NULL, 5.4, 1559, 4, 3),
(20, 'CWR5799', 'bol enfant uni 3', 300, 'jaune', 11, NULL, 2.9, 296, 4, 3),
(21, 'LZI4545', 'mug bois', 350, 'bois', 8, NULL, 2.5, 2328, 1, 4),
(22, 'KBD8295', 'mug serigraphie humour 1', 430, 'blanc', 8, NULL, 0.7, 2463, 2, 4),
(23, 'FUM6762', 'mug serigraphie humour 2', 430, 'blanc', 8, NULL, 3, 2570, 2, 4),
(24, 'RHB4179', 'mug serigraphie monde', 430, 'blanc', 8, NULL, 3.5, 2698, 2, 4),
(25, 'UKD4353', 'mug serigraphie animaux', 430, 'blanc', 8, NULL, 5.2, 254, 2, 4),
(26, 'FVD8995', 'mug uni 1', 500, 'blanc', 9, NULL, 1.6, 1464, 3, 4),
(27, 'OTT8355', 'mug uni 2', 500, 'beige', 9, NULL, 3.1, 1036, 3, 4),
(28, 'TAI8536', 'mug uni 3', 500, 'antracite', 9, NULL, 5.2, 786, 3, 4),
(29, 'JRG5354', 'mug serie celeste', 450, 'bleu', 9, NULL, 2.2, 821, 2, 4),
(30, 'GRW4991', 'mug serie gaia', 450, 'rose', 9, NULL, 3.4, 1751, 2, 4),
(31, 'EFL8998', 'mug enfant manga', 170, 'rouge', 8, NULL, 3.5, 765, 4, 4),
(32, 'SCL3258', 'mug enfant super heros', 170, 'bleu', 8, NULL, 4.8, 1334, 4, 4),
(33, 'ZDL9656', 'mug enfant uni 1', 160, 'rouge', 8, NULL, 4.7, 1612, 4, 4),
(34, 'WFE6697', 'mug enfant uni 2', 160, 'jaune', 8, NULL, 1.4, 1295, 4, 4),
(35, 'AGW7758', 'galopin', 150, 'verre', NULL, 12.5, 3.8, 1640, 5, 10),
(36, 'XYZ2831', 'bock', 170, 'verre', NULL, 15, 5.9, 1555, 5, 10),
(37, 'DQM5827', 'demi', 250, 'verre', NULL, 25, 1.5, 91, 5, 10),
(38, 'GTX5753', 'chope', 260, 'verre', NULL, 25, 0.4, 1316, 5, 10),
(39, 'ERQ3715', 'pinte', 330, 'verre', NULL, 50, 1.5, 784, 5, 10),
(40, 'IOO2644', 'chopine', 400, 'verre', NULL, 56.8, 4.4, 2733, 5, 10),
(41, 'JTF1243', 'parfait', 550, 'verre', NULL, 100, 1.5, 262, 5, 10),
(42, 'TLA9886', 'verre a Bourgogne', 120, 'verre', NULL, 60, 4.5, 1400, 5, 11),
(43, 'SXX9266', 'verre a Bordeaux', 125, 'verre', NULL, 50, 3.1, 690, 5, 11),
(44, 'WCM2946', 'verre universel', 110, 'verre', NULL, 45, 0.9, 2011, 5, 11),
(45, 'CQJ8528', 'verre a vin blanc', 120, 'verre', NULL, 40, 1.2, 2463, 5, 11),
(46, 'JOW2965', 'verre a Porto', 110, 'verre', NULL, 35, 4.4, 754, 5, 11),
(47, 'XCK5257', 'verre a Cognac', 110, 'verre', NULL, 35, 1.1, 1909, 5, 11),
(48, 'IDG8482', 'verre a Grappa', 90, 'verre', NULL, 20, 4.7, 1758, 5, 11),
(49, 'JPN3715', 'coupe', 130, 'verre', NULL, 50, 1.2, 299, 5, 12),
(50, 'FMN5971', 'flute ', 120, 'verre', NULL, 60, 5.6, 1750, 5, 12),
(51, 'RLN4596', 'flute prestige', 160, 'verre', NULL, 55, 6.1, 2326, 6, 12),
(52, 'IQR9715', 'verre strie', 130, 'verre', NULL, 25, 5.9, 853, 5, 13),
(53, 'HDP8767', 'verre arabesques', 130, 'verre', NULL, 30, 4.1, 50, 5, 13),
(54, 'NBK6929', 'verre prestige', 150, 'verre', NULL, 25, 3.9, 456, 6, 13),
(55, 'ZIX7289', 'verre serigraphie manga', 120, 'verre', NULL, 25, 3.7, 2131, 5, 13),
(56, 'XSB9789', 'dessert serigraphie fleurs 1', 400, 'blanc', 20, NULL, 6.5, 1000, 2, 14),
(57, 'MMX4872', 'dessert serigraphie fleurs 2', 400, 'blanc', 20, NULL, 1.4, 1369, 2, 14),
(58, 'EYV1688', 'dessert serigraphie fleurs 3', 400, 'blanc', 20, NULL, 4.8, 1080, 2, 14),
(59, 'EBA6453', 'dessert assiette unie 1', 350, 'rose', 18, NULL, 3.9, 1297, 2, 14),
(60, 'GJJ9659', 'dessert assiette unie 2', 450, 'gris', 18, NULL, 5.3, 482, 3, 14),
(61, 'KIM5917', 'dessert assiette unie 3', 450, 'beige', 18, NULL, 4.6, 1282, 3, 14),
(62, 'MQM9436', 'dessert assiette serie celeste', 420, 'bleu', 21, NULL, 6.1, 2202, 2, 14),
(63, 'DGO6131', 'dessert assiette serie gaia', 420, 'rose', 21, NULL, 3.4, 1637, 2, 14),
(64, 'YBJ1632', 'assiette enfant unie 1', 200, 'rouge', 17, NULL, 6.2, 1580, 4, 14),
(65, 'ZHW7988', 'assiette enfant unie 2', 200, 'bleu', 17, NULL, 4.3, 228, 4, 14),
(66, 'UBV3746', 'serigraphie fleurs 1', 450, 'blanc', 26, NULL, 0.9, 1925, 2, 15),
(67, 'BGD1229', 'serigraphie fleurs 2', 450, 'blanc', 26, NULL, 4.4, 655, 2, 15),
(68, 'KBQ7344', 'serigraphie fleurs 3', 450, 'blanc', 26, NULL, 3.1, 261, 2, 15),
(69, 'DYJ9329', 'assiette unie 1', 400, 'rose', 25, NULL, 3.6, 2104, 2, 15),
(70, 'LDL4327', 'assiette unie 2', 470, 'gris', 24, NULL, 0.8, 1447, 3, 15),
(71, 'YJA3996', 'assiette unie 3', 470, 'beige', 24, NULL, 2.9, 925, 3, 15),
(72, 'GPC7832', 'assiette serie celeste', 470, 'bleu', 27, NULL, 1.6, 284, 2, 15),
(73, 'WOE1962', 'assiette serie gaia', 470, 'rose', 27, NULL, 5.1, 1410, 2, 15),
(74, 'CHX3598', 'assiette enfant unie 1', 250, 'rouge', 23, NULL, 3.4, 673, 4, 15),
(75, 'EOO6791', 'assiette enfant unie 2', 250, 'bleu', 23, NULL, 5.5, 1899, 4, 15),
(76, 'OVS2244', 'collection grande maree', 70, 'argent', NULL, NULL, 6.1, 1951, 7, 16),
(77, 'WPM7994', 'basique poisson', 53, 'argent', NULL, NULL, 6.1, 1293, 7, 16),
(78, 'LQP1584', 'prestige poisson', 60, 'argent', NULL, NULL, 4.3, 612, 7, 16),
(79, 'ZIZ3193', 'basique dessert', 43, 'argent', NULL, NULL, 6, 1945, 7, 17),
(80, 'ZJC6397', 'prestige dessert', 50, 'argent', NULL, NULL, 3.8, 2364, 7, 17),
(81, 'RWB9889', 'serie daily', 63, 'argent', NULL, NULL, 2.3, 459, 7, 18),
(82, 'YOT5569', 'huitre collection grande maree', 55, 'argent', NULL, NULL, 1.2, 730, 7, 19),
(83, 'HDE2653', 'basique', 52, 'argent', NULL, NULL, 2.8, 2273, 7, 19),
(84, 'FHD5358', 'prestige', 60, 'argent', NULL, NULL, 4.1, 885, 7, 19),
(85, 'MTA9714', 'fruits basique', 45, 'argent', NULL, NULL, 2.6, 369, 7, 20),
(86, 'NYW5872', 'basique', 60, 'argent', NULL, NULL, 3.6, 1957, 7, 21),
(87, 'OAS1317', 'prestige', 65, 'argent', NULL, NULL, 3.1, 387, 7, 21),
(88, 'YEZ3448', 'lame inox manche bois', 60, 'bois', NULL, NULL, 1, 1592, 7, 22),
(89, 'HIK5329', 'manche plastique 1', 55, 'noir', NULL, NULL, 6, 1272, 7, 22),
(90, 'MFB3137', 'manche plastique 2', 55, 'rouge', NULL, NULL, 4.3, 1586, 7, 22),
(91, 'ZTN6539', 'manche plastique 3', 55, 'bleu', NULL, NULL, 2.1, 1350, 7, 22),
(92, 'QAN8736', 'manche bois avec garde', 53, 'bois', NULL, NULL, 1.8, 1994, 7, 23),
(93, 'YDR8316', 'manche bois sans garde', 48, 'bois', NULL, NULL, 2.9, 394, 7, 23),
(94, 'MWP5646', 'manche plastique 1 avec garde', 48, 'noir', NULL, NULL, 5.2, 1513, 7, 23),
(95, 'LMC8363', 'manche plastique 1 sans garde', 42, 'noir', NULL, NULL, 1.8, 859, 7, 23),
(96, 'HGY7315', 'manche plastique 2 sans garde', 42, 'rouge', NULL, NULL, 2, 2519, 7, 23),
(97, 'AIC9925', 'manche plastique 3 sans garde', 42, 'bleu', NULL, NULL, 4.4, 1729, 7, 23),
(98, 'XAA6136', 'tout inox', 75, 'argent', NULL, NULL, 2, 1087, 7, 24),
(99, 'RAO5225', 'manche bois', 70, 'bois', NULL, NULL, 2.5, 250, 7, 24),
(100, 'KHE9256', 'manche plastique 1', 65, 'noir', NULL, NULL, 6.5, 752, 7, 24),
(101, 'XKQ1758', 'manche plastique 2', 65, 'bleu', NULL, NULL, 6.5, 249, 7, 24),
(102, 'WQV4248', 'tout inox basique', 90, 'argent', NULL, NULL, 5.9, 1751, 7, 25),
(103, 'AZO4952', 'tout inox cisele', 85, 'argent', NULL, NULL, 3, 2484, 7, 25),
(104, 'HNP2645', 'manche bois grave theme chasse', 80, 'bois', NULL, NULL, 4.9, 1639, 7, 25),
(105, 'VLV3923', 'manche bois precieux', 95, 'bois', NULL, NULL, 1.9, 743, 7, 25),
(106, 'HFE7886', 'manche corne', 100, 'creme', NULL, NULL, 6.8, 1564, 7, 25),
(107, 'YHL3123', 'manche plastique 1', 80, 'noir', NULL, NULL, 5.1, 63, 7, 25),
(108, 'XUX9929', 'manche plastique 2', 80, 'bleu', NULL, NULL, 6.4, 1151, 7, 25),
(109, 'IQT4658', 'manche plastique 3', 80, 'rouge', NULL, NULL, 3.9, 38, 7, 25),
(110, 'BEO4128', 'santoku manche bois', 200, 'bois', NULL, NULL, 5.2, 2265, 8, 26),
(111, 'MIR3229', 'tout acier', 250, 'argent', NULL, NULL, 3.6, 161, 8, 26),
(112, 'RWR6931', 'nakiri manche bois', 170, 'bois', NULL, NULL, 2.2, 2300, 8, 26),
(113, 'QGV2457', 'cuillere a expresso', 20, 'argent', NULL, NULL, 0.8, 2728, 7, 27),
(114, 'AFD2116', 'cuillere a cafe latte', 22, 'argent', NULL, NULL, 5.9, 1213, 7, 27),
(115, 'UUX1847', 'cuillere a cafe basique', 18, 'argent', NULL, NULL, 1.8, 644, 7, 27),
(116, 'LSF1131', 'motif chat', 25, 'argent', NULL, NULL, 4.2, 2346, 7, 27),
(117, 'THF7473', 'style retro', 26, 'argent', NULL, NULL, 4.9, 1508, 7, 27),
(118, 'HCL6766', 'serie prestige', 55, 'argent', NULL, NULL, 5.2, 505, 7, 28),
(119, 'WPC3668', 'basique', 48, 'argent', NULL, NULL, 3.4, 765, 7, 28),
(120, 'YTC7248', 'manche bois', 50, 'bois', NULL, NULL, 5.9, 2308, 7, 28),
(121, 'UXE9255', 'style retro', 24, 'argent', NULL, NULL, 1.3, 959, 7, 29),
(122, 'YEA5665', 'serie prestige', 26, 'argent', NULL, NULL, 3.4, 635, 7, 29),
(123, 'YFR3288', 'basique', 22, 'argent', NULL, NULL, 5, 296, 7, 29),
(124, 'BNN6163', 'manche plastique avec ejecteur', 35, 'noir', NULL, NULL, 4.8, 2338, 7, 30),
(125, 'HVW6394', 'basique manche plastique 1', 28, 'noir', NULL, NULL, 5.6, 2514, 7, 30),
(126, 'WKE1476', 'basique manche plastique 2', 28, 'rose', NULL, NULL, 6.4, 32, 7, 30);

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

--
-- Structure de la table `categories`
--

CREATE TABLE `categories` (
  `categorie_id` int(11) NOT NULL,
  `description` varchar(25) NOT NULL,
  `parent_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `categories`
--

INSERT INTO `categories` (`categorie_id`, `description`, `parent_id`) VALUES
(1, 'vaisselle', NULL),
(2, 'couverts', 1),
(3, 'bols', 1),
(4, 'mugs', 1),
(5, 'verres', 1),
(6, 'assiettes', 1),
(7, 'fourchettes', 2),
(8, 'couteaux', 2),
(9, 'cuilleres', 2),
(10, 'biere', 5),
(11, 'vin', 5),
(12, 'coupe', 5),
(13, 'autres', 5),
(14, 'petites', 6),
(15, 'standard', 6),
(16, 'poisson', 7),
(17, 'dessert', 7),
(18, 'service', 7),
(19, 'huitres', 7),
(20, 'fruits', 7),
(21, 'table', 7),
(22, 'pain', 8),
(23, 'huitres', 8),
(24, 'beurre', 8),
(25, 'viande', 8),
(26, 'japonais', 8),
(27, 'cafe', 9),
(28, 'soupe', 9),
(29, 'dessert', 9),
(30, 'glace', 9);

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

--
-- Structure de la table `matieres`
--

CREATE TABLE `matieres` (
  `matiere_id` int(11) NOT NULL,
  `description` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `matieres`
--

INSERT INTO `matieres` (`matiere_id`, `description`) VALUES
(1, 'bois'),
(2, 'porcelaine'),
(3, 'gres'),
(4, 'melamine'),
(5, 'verre'),
(6, 'cristal'),
(7, 'inox'),
(8, 'acier');

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

--
-- Structure de la table `prix`
--

CREATE TABLE `prix` (
  `prix_id` int(11) NOT NULL,
  `article_id` int(11) NOT NULL,
  `depuis` date NOT NULL,
  `prix_ttc` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `prix`
--

INSERT INTO `prix` (`prix_id`, `article_id`, `depuis`, `prix_ttc`) VALUES
(1, 1, '2017-01-29', 6.12),
(2, 2, '2017-02-04', 10.24),
(3, 3, '2017-02-05', 10.24),
(4, 4, '2017-01-22', 12.87),
(5, 5, '2017-01-31', 14.47),
(6, 6, '2017-02-11', 14.14),
(7, 7, '2017-02-01', 10.21),
(8, 8, '2017-01-28', 10.8),
(9, 9, '2017-01-01', 7.86),
(10, 10, '2017-01-13', 5.69),
(11, 11, '2017-02-06', 6.67),
(12, 12, '2017-02-11', 5.58),
(13, 13, '2017-02-09', 6.07),
(14, 14, '2017-01-08', 15.54),
(15, 15, '2017-01-21', 21.58),
(16, 16, '2017-02-18', 10.89),
(17, 17, '2017-01-15', 10.36),
(18, 18, '2017-02-17', 5.55),
(19, 19, '2017-01-11', 7.23),
(20, 20, '2017-01-05', 5.68),
(21, 21, '2017-01-14', 10.06),
(22, 22, '2017-01-21', 6.61),
(23, 23, '2017-01-22', 6.54),
(24, 24, '2017-01-17', 6.26),
(25, 25, '2017-01-18', 7.87),
(26, 26, '2017-01-02', 6.27),
(27, 27, '2017-01-23', 5.9),
(28, 28, '2017-02-04', 5.43),
(29, 29, '2017-02-05', 15.26),
(30, 30, '2017-01-29', 21.04),
(31, 31, '2017-02-05', 14.53),
(32, 32, '2017-01-08', 14.52),
(33, 33, '2017-01-09', 7.78),
(34, 34, '2017-02-05', 7.72),
(35, 35, '2017-01-08', 6.74),
(36, 36, '2017-01-27', 6.72),
(37, 37, '2017-01-18', 7.03),
(38, 38, '2017-01-17', 14.78),
(39, 39, '2017-01-03', 14.4),
(40, 40, '2017-02-09', 5.71),
(41, 41, '2017-02-16', 18.05),
(42, 42, '2017-01-08', 14.59),
(43, 43, '2017-02-05', 14.88),
(44, 44, '2017-02-11', 5.75),
(45, 45, '2017-02-04', 5.75),
(46, 46, '2017-01-24', 7.96),
(47, 47, '2017-02-15', 5.23),
(48, 48, '2017-01-11', 14.11),
(49, 49, '2017-02-12', 14.32),
(50, 50, '2017-01-30', 6.33),
(51, 51, '2017-01-10', 18.93),
(52, 52, '2017-02-13', 6.41),
(53, 53, '2017-01-14', 12.66),
(54, 54, '2017-02-20', 18.8),
(55, 55, '2017-02-20', 6.26),
(56, 56, '2017-02-14', 14.06),
(57, 57, '2017-01-30', 10.47),
(58, 58, '2017-01-14', 10.92),
(59, 59, '2017-01-19', 7.6),
(60, 60, '2017-01-30', 6.49),
(61, 61, '2017-01-06', 5.46),
(62, 62, '2017-01-04', 21.87),
(63, 63, '2017-02-06', 15.82),
(64, 64, '2017-01-08', 5.37),
(65, 65, '2017-01-20', 6.99),
(66, 66, '2017-02-10', 14.62),
(67, 67, '2017-01-27', 10.75),
(68, 68, '2017-02-15', 14.92),
(69, 69, '2017-02-04', 6.66),
(70, 70, '2017-01-26', 14.02),
(71, 71, '2017-02-03', 14.01),
(72, 72, '2017-01-27', 21.67),
(73, 73, '2017-02-01', 21.53),
(74, 74, '2017-01-09', 7.8),
(75, 75, '2017-01-19', 5.63),
(76, 76, '2017-01-22', 18.12),
(77, 77, '2017-02-04', 7.91),
(78, 78, '2017-01-05', 18.85),
(79, 79, '2017-01-12', 6.68),
(80, 80, '2017-01-25', 18.44),
(81, 81, '2017-01-05', 7.91),
(82, 82, '2017-01-14', 21.52),
(83, 83, '2017-02-17', 7.14),
(84, 84, '2017-01-22', 15.25),
(85, 85, '2017-02-07', 12.53),
(86, 86, '2017-01-14', 5.68),
(87, 87, '2017-01-13', 15.84),
(88, 88, '2017-01-03', 12.87),
(89, 89, '2017-02-08', 6.53),
(90, 90, '2017-01-07', 5.94),
(91, 91, '2017-01-13', 5.66),
(92, 92, '2017-01-13', 14.1),
(93, 93, '2017-01-05', 12.13),
(94, 94, '2017-01-18', 6.03),
(95, 95, '2017-01-29', 5.4),
(96, 96, '2017-01-21', 6.23),
(97, 97, '2017-01-13', 7.15),
(98, 98, '2017-01-10', 10.28),
(99, 99, '2017-02-19', 14.17),
(100, 100, '2017-02-07', 7.3),
(101, 101, '2017-02-19', 5.49),
(102, 102, '2017-02-07', 5.28),
(103, 103, '2017-01-06', 21.9),
(104, 104, '2017-01-29', 12.93),
(105, 105, '2017-01-30', 18.31),
(106, 106, '2017-01-21', 15.39),
(107, 107, '2017-02-02', 6.95),
(108, 108, '2017-01-17', 6.26),
(109, 109, '2017-01-24', 5.29),
(110, 110, '2017-02-08', 21.17),
(111, 111, '2017-02-20', 12.61),
(112, 112, '2017-01-27', 18.14),
(113, 113, '2017-01-05', 5.63),
(114, 114, '2017-02-16', 5.33),
(115, 115, '2017-01-09', 5.91),
(116, 116, '2017-02-12', 6.81),
(117, 117, '2017-01-02', 6.81),
(118, 118, '2017-02-11', 15.95),
(119, 119, '2017-02-01', 5.26),
(120, 120, '2017-02-07', 18.45),
(121, 121, '2017-02-20', 12.71),
(122, 122, '2017-01-20', 18.33),
(123, 123, '2017-02-02', 7.09),
(124, 124, '2017-02-05', 6.27),
(125, 125, '2017-01-08', 5.01),
(126, 126, '2017-02-04', 5.71),
(127, 1, '2017-06-30', 8.89),
(128, 2, '2017-05-18', 8.24),
(129, 6, '2017-05-30', 12.37),
(130, 7, '2017-05-17', 11.91),
(131, 8, '2017-07-27', 13.62),
(132, 10, '2017-07-03', 7.37),
(133, 12, '2017-05-23', 4.81),
(134, 14, '2017-06-22', 13.89),
(135, 17, '2017-05-28', 11.2),
(136, 19, '2017-06-27', 10.15),
(137, 20, '2017-06-03', 4.79),
(138, 22, '2017-05-28', 5.67),
(139, 24, '2017-06-19', 5.51),
(140, 25, '2017-06-17', 6.31),
(141, 26, '2017-05-29', 6.5),
(142, 27, '2017-05-17', 5.44),
(143, 28, '2017-06-15', 6.16),
(144, 30, '2017-06-14', 23.2),
(145, 31, '2017-06-11', 14.82),
(146, 32, '2017-04-18', 13.77),
(147, 33, '2017-05-21', 7.06),
(148, 34, '2017-08-23', 9.14),
(149, 35, '2017-05-20', 9.15),
(150, 36, '2017-07-11', 7.5),
(151, 37, '2017-07-30', 6.66),
(152, 39, '2017-07-01', 17.34),
(153, 40, '2017-07-18', 6.2),
(154, 41, '2017-07-17', 18.22),
(155, 42, '2017-04-25', 14.09),
(156, 43, '2017-06-04', 17.85),
(157, 44, '2017-07-24', 6.99),
(158, 46, '2017-08-08', 7.36),
(159, 47, '2017-06-04', 4.24),
(160, 49, '2017-06-16', 13.38),
(161, 50, '2017-07-04', 5.26),
(162, 52, '2017-06-26', 8.97),
(163, 55, '2017-07-21', 5.5),
(164, 56, '2017-06-24', 14.97),
(165, 57, '2017-06-26', 9.61),
(166, 59, '2017-07-09', 7.49),
(167, 60, '2017-07-12', 5.67),
(168, 61, '2017-06-28', 6.89),
(169, 64, '2017-04-21', 4.98),
(170, 65, '2017-05-03', 6.31),
(171, 66, '2017-07-19', 14.61),
(172, 67, '2017-05-22', 9.13),
(173, 70, '2017-06-11', 12.37),
(174, 72, '2017-08-13', 21.13),
(175, 74, '2017-06-22', 6.62),
(176, 75, '2017-05-11', 7.99),
(177, 77, '2017-07-02', 7.98),
(178, 78, '2017-06-18', 20.5),
(179, 82, '2017-07-31', 21.96),
(180, 83, '2017-06-29', 6.71),
(181, 84, '2017-07-03', 16.24),
(182, 85, '2017-07-02', 14.91),
(183, 86, '2017-05-28', 6.98),
(184, 87, '2017-07-05', 14.5),
(185, 88, '2017-04-22', 12.71),
(186, 90, '2017-04-30', 8.61),
(187, 92, '2017-06-03', 13.04),
(188, 95, '2017-05-16', 4.59),
(189, 96, '2017-08-03', 4.73),
(190, 101, '2017-07-06', 7.3),
(191, 102, '2017-08-10', 7.07),
(192, 103, '2017-05-20', 21.99),
(193, 104, '2017-05-19', 13.77),
(194, 106, '2017-06-11', 18.38),
(195, 108, '2017-06-17', 8.28),
(196, 112, '2017-07-13', 20.97),
(197, 113, '2017-05-14', 5.64),
(198, 114, '2017-07-20', 4.21),
(199, 115, '2017-06-24', 7.22),
(200, 117, '2017-07-20', 9.3),
(201, 118, '2017-07-15', 17.71),
(202, 119, '2017-06-17', 5.63),
(203, 121, '2017-08-04', 15.06),
(204, 122, '2017-07-20', 20.34),
(205, 123, '2017-06-13', 6.19),
(206, 124, '2017-07-12', 9.27),
(207, 126, '2017-08-05', 4.18),
(208, 1, '2017-11-11', 10.68),
(209, 2, '2017-09-27', 9.34),
(210, 6, '2017-09-30', 13.91),
(211, 8, '2017-12-22', 16.28),
(212, 19, '2017-10-13', 9.7),
(213, 22, '2017-11-03', 6.5),
(214, 25, '2017-11-01', 5.72),
(215, 26, '2017-09-28', 5.57),
(216, 28, '2017-11-01', 6.48),
(217, 31, '2017-09-22', 15.47),
(218, 33, '2017-10-28', 6.45),
(219, 37, '2018-02-03', 6.55),
(220, 39, '2017-10-17', 15.91),
(221, 41, '2017-11-10', 17.66),
(222, 42, '2017-10-29', 15.39),
(223, 43, '2017-11-16', 19),
(224, 44, '2017-12-06', 9.58),
(225, 46, '2017-12-25', 7.35),
(226, 49, '2017-11-23', 15.53),
(227, 50, '2017-11-17', 7.88),
(228, 52, '2018-01-12', 7.01),
(229, 55, '2017-11-08', 5.89),
(230, 56, '2017-10-30', 13.83),
(231, 57, '2017-10-11', 11.88),
(232, 59, '2017-12-30', 6.01),
(233, 61, '2017-10-30', 6.19),
(234, 64, '2017-08-06', 5.38),
(235, 65, '2017-09-08', 6.26),
(236, 66, '2017-12-24', 17.57),
(237, 70, '2017-11-07', 12.33),
(238, 75, '2017-10-21', 8.38),
(239, 78, '2017-12-12', 18.77),
(240, 83, '2017-11-09', 8.18),
(241, 84, '2017-12-02', 17.08),
(242, 85, '2017-10-15', 14.98),
(243, 86, '2017-09-24', 8.08),
(244, 90, '2017-09-15', 8.76),
(245, 92, '2017-10-26', 14.28),
(246, 96, '2017-11-26', 3.2),
(247, 101, '2017-11-17', 9.8),
(248, 102, '2018-01-15', 7.88),
(249, 103, '2017-11-11', 24.38),
(250, 104, '2017-10-31', 13.52),
(251, 106, '2017-10-25', 18.66),
(252, 108, '2017-11-07', 10.29),
(253, 113, '2017-11-07', 6.68),
(254, 115, '2018-01-01', 8.67),
(255, 118, '2017-12-28', 18.89),
(256, 121, '2018-01-16', 14.18),
(257, 122, '2017-11-20', 21.58),
(258, 123, '2017-12-19', 5.92),
(259, 124, '2017-12-01', 7.54);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`article_id`);

--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`categorie_id`);

--
-- Index pour la table `matieres`
--
ALTER TABLE `matieres`
  ADD PRIMARY KEY (`matiere_id`);

--
-- Index pour la table `prix`
--
ALTER TABLE `prix`
  ADD PRIMARY KEY (`prix_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `articles`
--
ALTER TABLE `articles`
  MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;
--
-- AUTO_INCREMENT pour la table `categories`
--
ALTER TABLE `categories`
  MODIFY `categorie_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT pour la table `matieres`
--
ALTER TABLE `matieres`
  MODIFY `matiere_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `prix`
--
ALTER TABLE `prix`
  MODIFY `prix_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=260;COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
