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

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