From ba054ddf34df734463e5ffeb64ea247d8db87d6a Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
Date: Sun, 27 Mar 2016 00:05:09 +0100
Subject: Partly undo ad46b97 : title column deleted by mistake

---
 schema/schema-mysql.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'schema/schema-mysql.sql')

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
-- 
cgit v1.1

