diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-05-22 12:12:13 +0200 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-05-22 12:12:13 +0200 |
| commit | 20f922a84d9e5b831654283d9f331fd0fe28c45d (patch) | |
| tree | ba90ba599f9d44324ae286fb3015ce09935ce136 | |
| parent | d290f73ffaff3ba9117beecceb8ee8f08576d6c0 (diff) | |
| download | chd_gestion-20f922a84d9e5b831654283d9f331fd0fe28c45d.zip chd_gestion-20f922a84d9e5b831654283d9f331fd0fe28c45d.tar.gz chd_gestion-20f922a84d9e5b831654283d9f331fd0fe28c45d.tar.bz2 | |
DB : reorder some colums for some auto-baked index.ctp
| -rw-r--r-- | schema/schema-mysql.sql | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/schema/schema-mysql.sql b/schema/schema-mysql.sql index aea9c0d..21fc549 100644 --- a/schema/schema-mysql.sql +++ b/schema/schema-mysql.sql @@ -177,13 +177,14 @@ DROP TABLE IF EXISTS `equipements`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `equipements` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `mac` char(17) COLLATE utf8_unicode_ci NOT NULL, `uplink_id` int(11) DEFAULT NULL, - `service_id` int(11) DEFAULT NULL, + `mac` char(17) COLLATE utf8_unicode_ci NOT NULL, `ipmgmt_id` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, + `hostname` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `equipement_modele_id` int(11) NOT NULL, - `equipement_mode_id` char(8) COLLATE utf8_unicode_ci NOT NULL, + `service_id` int(11) DEFAULT NULL, `relais_id` int(11) DEFAULT NULL, + `equipement_mode_id` char(8) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date_achat` date DEFAULT NULL, `date_hs` date DEFAULT NULL, @@ -266,12 +267,12 @@ DROP TABLE IF EXISTS `interesses`; CREATE TABLE `interesses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_demande` date NOT NULL, - `interesse_statut_id` int(11) NOT NULL, `civilite_id` int(11) NOT NULL, `nom` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `prenom` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `raison` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `ville_id` int(11) NOT NULL, + `interesse_statut_id` int(11) NOT NULL, `telephone` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, `mail` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL, `adresse1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, @@ -282,9 +283,9 @@ CREATE TABLE `interesses` ( KEY `civilite_id` (`civilite_id`), KEY `ville_id` (`ville_id`), KEY `interesse_statut_id` (`interesse_statut_id`), - CONSTRAINT `interesses_ibfk_3` FOREIGN KEY (`interesse_statut_id`) REFERENCES `interesse_statuts` (`id`) ON UPDATE CASCADE, CONSTRAINT `interesses_ibfk_1` FOREIGN KEY (`civilite_id`) REFERENCES `civilites` (`id`) ON UPDATE CASCADE, - CONSTRAINT `interesses_ibfk_2` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE + CONSTRAINT `interesses_ibfk_2` FOREIGN KEY (`ville_id`) REFERENCES `villes` (`id`) ON UPDATE CASCADE, + CONSTRAINT `interesses_ibfk_3` FOREIGN KEY (`interesse_statut_id`) REFERENCES `interesse_statuts` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -790,4 +791,4 @@ CREATE TABLE `villes` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-04-23 14:09:11 +-- Dump completed on 2016-05-22 12:10:25 |