diff options
author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-03-27 00:05:09 +0100 |
---|---|---|
committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-03-27 00:05:09 +0100 |
commit | ba054ddf34df734463e5ffeb64ea247d8db87d6a (patch) | |
tree | 210297cbfbc73dcc6150b824e382f24fc64a4660 | |
parent | 335aa289498cdf80f7b05da78ed24c1ade2c870f (diff) | |
download | chd_gestion-ba054ddf34df734463e5ffeb64ea247d8db87d6a.zip chd_gestion-ba054ddf34df734463e5ffeb64ea247d8db87d6a.tar.gz chd_gestion-ba054ddf34df734463e5ffeb64ea247d8db87d6a.tar.bz2 |
Partly undo ad46b97 : title column deleted by mistake
-rw-r--r-- | schema/enum-tables-data-mysql.sql | 10 | ||||
-rw-r--r-- | schema/schema-mysql.sql | 6 |
2 files changed, 10 insertions, 6 deletions
diff --git a/schema/enum-tables-data-mysql.sql b/schema/enum-tables-data-mysql.sql index 9e11bb5..e83e881 100644 --- a/schema/enum-tables-data-mysql.sql +++ b/schema/enum-tables-data-mysql.sql @@ -49,7 +49,9 @@ DROP TABLE IF EXISTS `adherent_statuts`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adherent_statuts` ( `id` int(11) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (`id`) + `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `title` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -59,7 +61,7 @@ CREATE TABLE `adherent_statuts` ( LOCK TABLES `adherent_statuts` WRITE; /*!40000 ALTER TABLE `adherent_statuts` DISABLE KEYS */; -INSERT INTO `adherent_statuts` VALUES (1),(2),(3),(4),(5),(6),(7),(8); +INSERT INTO `adherent_statuts` VALUES (2,'☐ Fiche ☐ Prélev'),(4,'☐ Fiche ☑ Prélev'),(3,'☑ Fiche ☐ Prélev'),(5,'☑ Fiche ☑ Prélev'),(7,'À relancer'),(8,'Bénévole sans service'),(6,'Incohérent'),(1,'Résilié'); /*!40000 ALTER TABLE `adherent_statuts` ENABLE KEYS */; UNLOCK TABLES; @@ -134,7 +136,7 @@ CREATE TABLE `equipement_modeles` ( LOCK TABLES `equipement_modeles` WRITE; /*!40000 ALTER TABLE `equipement_modeles` DISABLE KEYS */; -INSERT INTO `equipement_modeles` VALUES (1,'Mikrotik','RouterBoard 750UP','',''),(2,'TP-Link','TL-WR740ND v??','TLWR740','4'),(3,'TP-Link','TL-WR740ND v1-3','',''),(4,'TP-Link','TL-WR740ND v4','TLWR740','4'),(5,'TP-Link','TL-WR740ND v5','',''),(6,'TP-Link','TL-WR841ND v9','TLWR841','9'),(7,'TP-Link','TL-WR841ND v10','','10'),(8,'TP-Link','TL-WR841ND v11','','11'),(10,'Ubiquiti','AirFiber 5X + AF-5G30-S45','',''),(11,'Ubiquiti','AirFiber 5X + Mars 25dBi','',''),(12,'Ubiquiti','NanoBeam M5 16','',''),(13,'Ubiquiti','NanoBeam M5 19','',''),(14,'Ubiquiti','NanoBridge M5 G22','',''),(15,'Ubiquiti','NanoBridge M5 G25','',''),(16,'Ubiquiti','Nanostation M5','',''),(17,'Ubiquiti','Nanostation M5 Loco','',''),(18,'Ubiquiti','PowerBeam M5 400','',''),(19,'Ubiquiti','Rocket M5','',''),(20,'Ubiquiti','ToughSwitch TS5','',''),(21,'Ubiquiti','ToughSwitch TS8','',''),(40,'Netonix','WS-6-MINI','',''),(41,'Mikrotik','RB2011UiAS-2HnD-IN',' ',' '),(42,'Ubiquiti','EdgeMax EdgeSwitch 24-Port 250W','',''),(43,'VM','Linux KVM','',''); +INSERT INTO `equipement_modeles` VALUES (1,'Mikrotik','RouterBoard 750UP','',''),(2,'TP-Link','TL-WR740ND v??','TLWR740','4'),(3,'TP-Link','TL-WR740ND v1-3','',''),(4,'TP-Link','TL-WR740ND v4','TLWR740','4'),(5,'TP-Link','TL-WR740ND v5','TLWR740','5'),(6,'TP-Link','TL-WR841ND v9','TLWR841','9'),(7,'TP-Link','TL-WR841ND v10','TLWR841','10'),(8,'TP-Link','TL-WR841ND v11','','11'),(10,'Ubiquiti','AirFiber 5X + AF-5G30-S45','',''),(11,'Ubiquiti','AirFiber 5X + Mars 25dBi','',''),(12,'Ubiquiti','NanoBeam M5 16','',''),(13,'Ubiquiti','NanoBeam M5 19','',''),(14,'Ubiquiti','NanoBridge M5 G22','',''),(15,'Ubiquiti','NanoBridge M5 G25','',''),(16,'Ubiquiti','Nanostation M5','',''),(17,'Ubiquiti','Nanostation M5 Loco','',''),(18,'Ubiquiti','PowerBeam M5 400','',''),(19,'Ubiquiti','Rocket M5','',''),(20,'Ubiquiti','ToughSwitch TS5','',''),(21,'Ubiquiti','ToughSwitch TS8','',''),(40,'Netonix','WS-6-MINI','',''),(41,'Mikrotik','RB2011UiAS-2HnD-IN',' ',' '),(42,'Ubiquiti','EdgeMax EdgeSwitch 24-Port 250W','',''),(43,'VM','Linux KVM','',''); /*!40000 ALTER TABLE `equipement_modeles` ENABLE KEYS */; UNLOCK TABLES; @@ -271,4 +273,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-03-13 22:06:30 +-- Dump completed on 2016-03-27 0:04:25 diff --git a/schema/schema-mysql.sql b/schema/schema-mysql.sql index 0f14b79..908280a 100644 --- a/schema/schema-mysql.sql +++ b/schema/schema-mysql.sql @@ -61,7 +61,9 @@ DROP TABLE IF EXISTS `adherent_statuts`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adherent_statuts` ( `id` int(11) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (`id`) + `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `title` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -754,4 +756,4 @@ CREATE TABLE `villes` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-03-13 22:06:30 +-- Dump completed on 2016-03-27 0:04:25 |