galette/install/scripts/upgrade-to-0.95-pgsql.sql

   1 -- Update fields length
   2 ALTER TABLE galette_adherents ALTER COLUMN nom_adh TYPE varchar(255);
   3 ALTER TABLE galette_adherents ALTER COLUMN prenom_adh TYPE varchar(255);
   4 ALTER TABLE galette_adherents ALTER COLUMN pseudo_adh TYPE varchar(255);
   5 ALTER TABLE galette_adherents ALTER COLUMN adresse_adh TYPE text;
   6 ALTER TABLE galette_adherents ALTER COLUMN ville_adh TYPE varchar(200);
   7 ALTER TABLE galette_adherents ALTER COLUMN pays_adh TYPE varchar(200);
   8 ALTER TABLE galette_adherents ALTER COLUMN tel_adh TYPE varchar(50);
   9 ALTER TABLE galette_adherents ALTER COLUMN gsm_adh TYPE varchar(50);
  10 ALTER TABLE galette_adherents ALTER COLUMN url_adh TYPE varchar(255);
  11 ALTER TABLE galette_adherents ALTER COLUMN login_adh TYPE varchar(255);
  12 ALTER TABLE galette_adherents ALTER COLUMN mdp_adh TYPE varchar(255);
  13 ALTER TABLE galette_adherents ALTER COLUMN fingerprint TYPE varchar(255);
  14
  15 ALTER TABLE galette_transactions ALTER COLUMN trans_desc TYPE varchar(255);
  16
  17 ALTER TABLE galette_statuts ALTER COLUMN libelle_statut TYPE varchar(255);
  18
  19 ALTER TABLE galette_titles ALTER COLUMN long_label TYPE varchar(100);
  20
  21 ALTER TABLE galette_preferences ALTER COLUMN val_pref TYPE varchar(255);
  22
  23 ALTER TABLE galette_logs ALTER COLUMN adh_log TYPE varchar(255);
  24
  25 ALTER TABLE galette_field_types ALTER COLUMN field_name TYPE varchar(255);
  26
  27 ALTER TABLE galette_l10n ALTER COLUMN text_orig TYPE varchar(255);
  28 ALTER TABLE galette_l10n ALTER COLUMN text_trans TYPE varchar(255);
  29
  30 ALTER TABLE galette_tmppasswds ALTER COLUMN tmp_passwd TYPE varchar(250);
  31
  32 ALTER TABLE galette_texts ALTER COLUMN tcomment TYPE varchar(255);
  33
  34 ALTER TABLE galette_fields_categories ALTER COLUMN category TYPE varchar(100);
  35
  36 ALTER TABLE galette_mailing_history ALTER COLUMN mailing_sender_name TYPE varchar(255);
  37
  38 ALTER TABLE galette_groups ALTER COLUMN group_name TYPE varchar(250);
  39
  40 ALTER TABLE galette_pdfmodels ALTER COLUMN model_title TYPE varchar(250);
  41 ALTER TABLE galette_pdfmodels ALTER COLUMN model_subtitle TYPE varchar(250);
  42
  43 ALTER TABLE galette_tmplinks ALTER COLUMN hash hash varchar(250);
  44
  45 UPDATE galette_database SET version = 0.950;