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
|
CREATE TABLE IF NOT EXISTS `insertions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`symbole` varchar(10) NOT NULL,
`code` smallint(6) DEFAULT NULL,
`derniere_insertion` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
INSERT INTO `insertions` (`id`, `symbole`, `code`, `derniere_insertion`) VALUES
(1, 'ubi', 297, '2011-01-09 17:35:01'),
(2, 'teo', 56, '2011-01-09 17:35:02'),
(3, 'tch', NULL, '2011-01-09 17:35:38'),
(4, 'tam', NULL, '2011-01-06 17:35:02'),
(5, 'sk', NULL, '2011-01-06 17:35:01'),
(6, 'siph', NULL, '2011-01-06 17:35:02'),
(7, 'rod', NULL, '2011-01-06 17:28:57'),
(8, 'pony', NULL, '2011-01-06 17:37:37'),
(9, 'oxi', NULL, '2011-01-06 17:35:02'),
(10, 'kn', NULL, '2011-01-06 17:38:15'),
(11, 'jxr', NULL, '2011-01-06 17:35:02'),
(12, 'gecp', NULL, '2011-01-06 17:24:31'),
(13, 'eur', NULL, '2011-01-06 17:03:25'),
(14, 'cri', NULL, '2011-01-06 17:35:02'),
(15, 'cei', NULL, '2011-01-06 17:36:49'),
(16, 'bvd', NULL, '2011-01-06 17:35:42'),
(17, 'bna', NULL, '2011-01-06 17:35:02'),
(18, 'alaup', NULL, '2011-01-06 17:29:20'),
(19, 'va', NULL, '2011-01-06 17:21:31'),
(20, 'cib', NULL, '2011-01-06 17:35:02');
CREATE TABLE IF NOT EXISTS `historique` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date_heure` datetime NOT NULL,
`cours` decimal(7,3) unsigned NOT NULL,
`quantite` mediumint(5) unsigned NOT NULL,
`symbole` varchar(10) CHARACTER SET utf8 NOT NULL,
`sens` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=572053 ;
INSERT INTO `boursier`.`historique` (`id`, `date_heure`, `cours`, `quantite`, `symbole`, `sens`) VALUES (NULL, '2011-01-09 10:33:09', '2', '1000', 'ubi', '1');
INSERT INTO `boursier`.`historique` (`id`, `date_heure`, `cours`, `quantite`, `symbole`, `sens`) VALUES (NULL, '2011-01-09 10:33:09', '2.2', '10000', 'ubi', '2');
INSERT INTO `boursier`.`historique` (`id`, `date_heure`, `cours`, `quantite`, `symbole`, `sens`) VALUES (NULL, '2011-01-09 10:33:09', '2', '200', 'teo', '0');
INSERT INTO `boursier`.`historique` (`id`, `date_heure`, `cours`, `quantite`, `symbole`, `sens`) VALUES (NULL, '2011-01-09 10:33:09', '2.8', '50', 'va', '1'); |
Partager