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
|
-- -----------------------------
-- creation de la table cotations
-- -----------------------------
CREATE TABLE `cotations` (
`cotation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`valeur_id_fk` smallint(5) unsigned NOT NULL,
`dernier` float(7,3) unsigned NOT NULL,
`variation` float(7,3) unsigned NOT NULL,
`ouverture` float(7,3) unsigned NOT NULL,
`plus_haut` float(7,3) unsigned NOT NULL,
`plus_bas` float(7,3) unsigned NOT NULL,
`volume` int(10) unsigned NOT NULL,
`h_cotation` int(10) unsigned NOT NULL,
PRIMARY KEY (`cotation_id`),
KEY `fk` (`valeur_id_fk`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
INSERT INTO cotations VALUES(125905, 168, 8.210, 5.260, 8.570, 8.570, 8.200, 18036, 1273131699);
INSERT INTO cotations VALUES(125987, 168, 8.210, 5.260, 8.570, 8.570, 8.200, 18036, 1273131727);
INSERT INTO cotations VALUES(126068, 168, 8.210, 5.260, 8.570, 8.570, 8.200, 18036, 1273131746);
INSERT INTO cotations VALUES(125906, 169, 30.000, 3.410, 29.300, 30.150, 29.300, 4414, 1273131699);
INSERT INTO cotations VALUES(125988, 169, 30.000, 3.410, 29.300, 30.150, 29.300, 4414, 1273131727);
INSERT INTO cotations VALUES(126151, 169, 30.000, 3.410, 29.300, 30.150, 29.300, 4414, 1273131770); |
Partager