Add member number; closes #190

[galette.git] / galette / install / scripts / upgrade-to-0.96-pgsql.sql

diff --git a/galette/install/scripts/upgrade-to-0.96-pgsql.sql b/galette/install/scripts/upgrade-to-0.96-pgsql.sql
index a19b1cc0667e6128496dea2f5d35d01a6a5efedc..cef49cf2e2532274c2287e05b573ddc9447a236b 100644 (file)
--- a/galette/install/scripts/upgrade-to-0.96-pgsql.sql
+++ b/galette/install/scripts/upgrade-to-0.96-pgsql.sql
@@ -45,4 +45,7 @@ ALTER TABLE galette_adherents DROP column jabber_adh;
 -- cleanup fields config table
 DELETE FROM galette_fields_config WHERE field_id IN ('url_adh', 'icq_adh', 'msn_adh', 'jabber_adh');
 
+-- add num_adh column
+ALTER TABLE galette_adherents ADD COLUMN num_adh character varying (255) DEFAULT NULL;
+
 UPDATE galette_database SET version = 0.960;
\ No newline at end of file