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 /schema/schema-mysql.sql | |
| 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
Diffstat (limited to 'schema/schema-mysql.sql')
| -rw-r--r-- | schema/schema-mysql.sql | 6 |
1 files changed, 4 insertions, 2 deletions
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 |