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 54 55 56 57 58 59 60 61 62 63 64 65 66
|
DROP TABLE IF EXISTS `lien_contrat`;
CREATE TABLE `lien_contrat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`partenaire` int(11) NOT NULL,
`type_contrat` varchar(30) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
LOCK TABLES `lien_contrat` WRITE;
INSERT INTO `lien_contrat` VALUES (1,1'TYPE 1'),(2,1,'TYPE 2'),(3,1,'TYPE 3');
UNLOCK TABLES;
DROP TABLE IF EXISTS `contrat`;
CREATE TABLE `contrat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_magasin` int(11) DEFAULT NULL,
`date_saisie` datetime DEFAULT CURRENT_TIMESTAMP,
`partenaire` int(11) NOT NULL,
`index_vente` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `iddatesaisie` (`date_saisie`),
KEY `index_jointure_type_vente` (`index_vente`),
KEY `index_magasin` (`id_magasin`)
KEY `index_partenaire` (`partenaire`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
LOCK TABLES `contrat` WRITE;
INSERT INTO `contrat` VALUES (1,2,'2022-01-12 09:44:50',1,1),(2,1,'2022-01-12 09:44:50',1,2),(3,3,'2022-01-12 09:44:50',1,3);
UNLOCK TABLES;
DROP TABLE IF EXISTS `magasin`;
CREATE TABLE `magasin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ville` varchar(45) COLLATE latin1_general_ci NOT NULL,
`id_partenaire` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
LOCK TABLES `magasin` WRITE;
INSERT INTO `magasin` VALUES (1,'MARSEILLE',1),(2,'PARIS',1),(3,'TOULOUSE',1),(4,'BORDEAUX',1)
UNLOCK TABLES;
DROP TABLE IF EXISTS `histo`;
CREATE TABLE `histo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`magasin` varchar(50) COLLATE latin1_general_ci NOT NULL,
`date_prod` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7216 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
LOCK TABLES `histo` WRITE;
INSERT INTO `histo` VALUES (16,'MARSEILLE','2022-01-12'),(16,'PARIS','2022-01-12'),(16,'TOULOUSE','2022-01-12'),(16,'BORDEAUX','2022-01-12');
UNLOCK TABLES; |
Partager