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 50 51 52 53
| -- Structure de la table `table1`
--
CREATE TABLE `table1` (
`num_ligne` int NOT NULL,
`date` datetime DEFAULT NULL,
`test` decimal(10,1) DEFAULT NULL COMMENT 'ceci est un commentaire',
`test2` decimal(65,30) DEFAULT NULL COMMENT 'ceci est un commentaire',
`aberrant` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Déchargement des données de la table `table1`
--
INSERT INTO `table1` (`num_ligne`, `date`, `test`, `test2`, `aberrant`) VALUES
(1, '2022-01-01 00:00:00', 4.0, NULL, NULL),
(2, '2022-01-05 00:00:00', 4.0, NULL, NULL),
(3, '2022-01-08 00:00:00', 489.0, 76.000000078974698400000000000000, NULL),
(4, '2022-01-10 10:54:03', -456.0, -500.000000000000000000000000000000, NULL),
(5, '2022-01-15 00:00:00', 7445.0, NULL, NULL),
(6, '2022-01-17 00:00:00', 45.0, 325.046860000000000000000000000000, NULL),
(7, '2022-01-19 00:00:00', -4.0, NULL, NULL),
(8, '2022-01-20 00:00:00', -5000.0, 164.000000000000000000000000000000, NULL),
(9, '2022-01-22 00:00:00', -4.0, 5.000000000000000000000000000000, NULL),
(10, '2022-01-23 00:00:00', 78.0, -30.000000000000000000000000000000, NULL),
(11, '2022-01-24 00:00:00', NULL, 4999.000000000000000000000000000000, NULL),
(12, '2022-01-25 00:00:00', 7.0, 289.000000000000000000000000000000, NULL),
(13, '2022-01-26 00:00:00', NULL, 456.000000000000000000000000000000, NULL),
(14, '2022-01-28 00:00:00', 78.0, NULL, NULL),
(15, '2022-01-30 00:00:00', 12600.0, NULL, NULL);
--
-- Index pour les tables déchargées
--
--
-- Index pour la table `table1`
--
ALTER TABLE `table1`
ADD PRIMARY KEY (`num_ligne`),
ADD UNIQUE KEY `test num ligne` (`test`,`num_ligne`);
--
-- AUTO_INCREMENT pour les tables déchargées
--
--
-- AUTO_INCREMENT pour la table `table1`
--
ALTER TABLE `table1`
MODIFY `num_ligne` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
COMMIT; |
Partager