1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| CREATE TABLE `t_products` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(80) NOT NULL ,
`end_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY (`id`) )
ENGINE = MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
INSERT INTO `t_products` (id, name, end_date)
VALUES
(1, "Synthétiseur", "2014-11-29 06:08:13"),
(2, "Ordinateur portable", "2014-11-29 07:41:09"),
(3, "Voiture", "2014-11-30 07:41:09"),
(4, "Jeux video", "2014-11-28 14:37:21"),
(5, "Téléviseur", "2014-11-10 08:23:40"),
(6, "Film DVD", "2014-11-29 09:17:50"),
(7, "Console de jeux", "2014-11-28 08:42:25"),
(8, "Sac de voyage", "2014-11-30 07:16:03");
CREATE TABLE `t_offers` (
`product_id` INT UNSIGNED NOT NULL DEFAULT 0 ,
`user_id` INT UNSIGNED NOT NULL DEFAULT 0 ,
`offer` DECIMAL(14,5) UNSIGNED NOT NULL ,
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' )
ENGINE = MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `t_offers` (product_id, user_id, offer,`date`)
VALUES
(5, 612, 500.0000, "2014-11-05 06:08:13"),
(5, 608, 700.0000, "2014-11-05 14:20:13"),
(5, 612, 580.0000, "2014-11-06 09:08:13"),
(5, 608, 680.0000, "2014-11-06 15:08:13"),
(5, 612, 600.0000, "2014-11-06 17:08:13"),
(5, 608, 620.0000, "2014-11-06 19:08:13"),
(5, 612, 620.0000, "2014-11-06 23:08:13"),
(1, 607, 150.0000, "2014-11-08 06:08:13"),
(1, 605, 150.0000, "2014-11-08 10:08:13"),
(1, 608, 160.0000, "2014-11-08 14:20:13"),
(1, 605, 280.0000, "2014-11-08 22:20:13"),
(1, 608, 180.0000, "2014-11-09 10:20:13"),
(1, 605, 260.0000, "2014-11-09 14:20:13"),
(1, 605, 260.0000, "2014-11-10 10:20:13"),
(1, 612, 200.0000, "2014-11-10 15:08:13"),
(2, 607, 300.0000, "2014-11-09 16:08:13"),
(2, 609, 400.0000, "2014-11-09 19:20:13"),
(2, 607, 320.0000, "2014-11-09 23:08:13"),
(2, 609, 390.0000, "2014-11-10 05:20:13"),
(8, 607, 250.0000, "2014-11-12 15:20:13"),
(4, 607, 40.0000, "2014-11-11 07:08:13"),
(4, 606, 70.0000, "2014-11-11 22:02:13"); |
Partager