diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-08-29 20:20:52 +0200 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-08-29 20:20:52 +0200 |
| commit | 6d3ad57a5c9b103fac081bb8eabd959a2f7baf1c (patch) | |
| tree | fe4ade615272b0ca0beb864a414bb7b3fa01aaee | |
| parent | 7c658d08729d4bff498abd2a52214a8248313e9e (diff) | |
| download | chd_gestion-6d3ad57a5c9b103fac081bb8eabd959a2f7baf1c.zip chd_gestion-6d3ad57a5c9b103fac081bb8eabd959a2f7baf1c.tar.gz chd_gestion-6d3ad57a5c9b103fac081bb8eabd959a2f7baf1c.tar.bz2 | |
sql : enforces service < 1 ---- 1 > equipement
| -rw-r--r-- | schema/enum-tables-data-mysql.sql | 2 | ||||
| -rw-r--r-- | schema/schema-mysql.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/schema/enum-tables-data-mysql.sql b/schema/enum-tables-data-mysql.sql index 3ba1971..32a531d 100644 --- a/schema/enum-tables-data-mysql.sql +++ b/schema/enum-tables-data-mysql.sql @@ -275,4 +275,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-08-28 10:56:15 +-- Dump completed on 2016-08-29 20:20:38 diff --git a/schema/schema-mysql.sql b/schema/schema-mysql.sql index 831fbcc..636ebd5 100644 --- a/schema/schema-mysql.sql +++ b/schema/schema-mysql.sql @@ -192,10 +192,10 @@ CREATE TABLE `equipements` ( PRIMARY KEY (`id`), UNIQUE KEY `mac` (`mac`), UNIQUE KEY `ipmgmt_id` (`ipmgmt_id`), + UNIQUE KEY `service_id` (`service_id`), KEY `relais_id` (`relais_id`), KEY `equipement_mode_id` (`equipement_mode_id`), KEY `equipement_modele_id` (`equipement_modele_id`), - KEY `service_id` (`service_id`), KEY `uplink_id` (`uplink_id`), CONSTRAINT `equipements_ibfk_1` FOREIGN KEY (`equipement_modele_id`) REFERENCES `equipement_modeles` (`id`) ON UPDATE CASCADE, CONSTRAINT `equipements_ibfk_4` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`), @@ -860,4 +860,4 @@ DELIMITER ; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-08-28 10:56:15 +-- Dump completed on 2016-08-29 20:20:38 |