*
* PHP version 5
*
- * Copyright © 2009-2018 The Galette Team
+ * Copyright © 2009-2021 The Galette Team
*
* This file is part of Galette (http://galette.tuxfamily.org).
*
* @package Galette
*
* @author Johan Cwiklinski <johan@x-tnd.be>
- * @copyright 2007-2018 The Galette Team
+ * @copyright 2007-2021 The Galette Team
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
* @link http://galette.tuxfamily.org
* @since Available since 0.7-dev - 2007-10-07
}
define('GALETTE_COMPAT_VERSION', '0.9.5');
-define('GALETTE_DB_VERSION', '0.940');
+define('GALETTE_DB_VERSION', '0.950');
if (!defined('GALETTE_MODE')) {
define('GALETTE_MODE', 'PROD'); //DEV, PROD, MAINT or DEMO
}
CREATE TABLE galette_adherents (
id_adh int(10) unsigned NOT NULL auto_increment,
id_statut int(10) unsigned NOT NULL default '4',
- nom_adh varchar(50) NOT NULL default '',
- prenom_adh varchar(50) NOT NULL default '',
- pseudo_adh varchar(20) NOT NULL default '',
+ nom_adh varchar(255) NOT NULL default '',
+ prenom_adh varchar(255) NOT NULL default '',
+ pseudo_adh varchar(255) NOT NULL default '',
societe_adh varchar(200) default NULL,
titre_adh int(10) unsigned default NULL,
ddn_adh date default '1901-01-01',
sexe_adh tinyint(1) NOT NULL default '0',
- adresse_adh varchar(150) NOT NULL default '',
- adresse2_adh varchar(150) default NULL,
+ adresse_adh text NOT NULL default '',
+ adresse2_adh varchar(150) default NULL, -- TODO: remove
cp_adh varchar(10) NOT NULL default '',
- ville_adh varchar(50) NOT NULL default '',
- pays_adh varchar(50) default NULL,
- tel_adh varchar(20) default NULL,
- gsm_adh varchar(20) default NULL,
+ ville_adh varchar(200) NOT NULL default '',
+ pays_adh varchar(200) default NULL,
+ tel_adh varchar(50) default NULL,
+ gsm_adh varchar(50) default NULL,
email_adh varchar(255) default NULL,
- url_adh varchar(200) default NULL,
- icq_adh varchar(20) default NULL,
- msn_adh varchar(150) default NULL,
+ url_adh varchar(255) default NULL,
+ icq_adh varchar(20) default NULL, -- TODO: remove
+ msn_adh varchar(150) default NULL, -- TODO: remove
jabber_adh varchar(150) default NULL,
info_adh text,
info_public_adh text,
prof_adh varchar(150) default NULL,
- login_adh varchar(20) NOT NULL default '',
- mdp_adh varchar(60) NOT NULL default '',
+ login_adh varchar(200) NOT NULL default '',
+ mdp_adh varchar(255) NOT NULL default '',
date_crea_adh date NOT NULL default '1901-01-01',
date_modif_adh date NOT NULL default '1901-01-01',
activite_adh tinyint(1) NOT NULL default 0,
pref_lang varchar(20) default 'fr_FR',
lieu_naissance text,
gpgid text DEFAULT NULL,
- fingerprint varchar(50) DEFAULT NULL,
+ fingerprint varchar(255) DEFAULT NULL,
parent_id int(10) unsigned DEFAULT NULL,
PRIMARY KEY (id_adh),
UNIQUE (login_adh),
trans_id int(10) unsigned NOT NULL auto_increment,
trans_date date NOT NULL default '1901-01-01',
trans_amount decimal(15, 2) default '0',
- trans_desc varchar(150) NOT NULL default '',
+ trans_desc varchar(255) NOT NULL default '',
id_adh int(10) unsigned default NULL,
PRIMARY KEY (trans_id),
FOREIGN KEY (id_adh) REFERENCES galette_adherents (id_adh) ON DELETE RESTRICT ON UPDATE CASCADE
DROP TABLE IF EXISTS galette_statuts;
CREATE TABLE galette_statuts (
id_statut int(10) unsigned NOT NULL auto_increment,
- libelle_statut varchar(100) NOT NULL default '',
+ libelle_statut varchar(255) NOT NULL default '',
priorite_statut tinyint(4) NOT NULL default '0',
PRIMARY KEY (id_statut)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE galette_titles (
id_title int(10) unsigned NOT NULL auto_increment,
short_label varchar(10) NOT NULL default '',
- long_label varchar(30) default '',
+ long_label varchar(100) default '',
PRIMARY KEY (id_title)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
DROP TABLE IF EXISTS galette_types_cotisation;
CREATE TABLE galette_types_cotisation (
id_type_cotis int(10) unsigned NOT NULL auto_increment,
- libelle_type_cotis varchar(100) NOT NULL default '',
+ libelle_type_cotis varchar(255) NOT NULL default '',
cotis_extension tinyint(1) NOT NULL default 0,
PRIMARY KEY (id_type_cotis)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE galette_preferences (
id_pref int(10) unsigned NOT NULL auto_increment,
nom_pref varchar(100) NOT NULL default '',
- val_pref varchar(200) NOT NULL default '',
+ val_pref varchar(255) NOT NULL default '',
PRIMARY KEY (id_pref),
UNIQUE (nom_pref)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
id_log int(10) unsigned NOT NULL auto_increment,
date_log datetime NOT NULL,
ip_log varchar(46) NOT NULL default '',
- adh_log varchar(41) NOT NULL default '',
+ adh_log varchar(255) NOT NULL default '', -- see galette_adherents.login_adh
text_log text,
action_log text,
sql_log text,
field_id int(10) unsigned NOT NULL auto_increment,
field_form varchar(10) NOT NULL,
field_index int(10) NOT NULL default '0',
- field_name varchar(40) NOT NULL default '',
+ field_name varchar(255) NOT NULL default '',
field_perm int(10) NOT NULL default '0',
field_type int(10) NOT NULL default '0',
field_required tinyint(1) NOT NULL default 0,
-- Table for dynamic translation of strings;
DROP TABLE IF EXISTS galette_l10n;
CREATE TABLE galette_l10n (
- text_orig varchar(100) NOT NULL,
+ text_orig varchar(255) NOT NULL,
text_locale varchar(15) NOT NULL,
text_nref int(10) NOT NULL default '1',
- text_trans varchar(100) NOT NULL default '',
+ text_trans varchar(255) NOT NULL default '',
PRIMARY KEY (text_orig, text_locale)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
DROP TABLE IF EXISTS galette_tmppasswds;
CREATE TABLE galette_tmppasswds (
id_adh int(10) unsigned NOT NULL,
- tmp_passwd varchar(60) NOT NULL,
+ tmp_passwd varchar(250) NOT NULL,
date_crea_tmp_passwd datetime NOT NULL,
PRIMARY KEY (id_adh),
FOREIGN KEY (id_adh) REFERENCES galette_adherents (id_adh) ON DELETE CASCADE ON UPDATE CASCADE
tsubject varchar(256) NOT NULL,
tbody text NOT NULL,
tlang varchar(16) NOT NULL,
- tcomment varchar(64) NOT NULL,
+ tcomment varchar(255) NOT NULL,
PRIMARY KEY (tid),
UNIQUE KEY `localizedtxt` (tref, tlang)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE galette_fields_categories (
id_field_category int(2) NOT NULL AUTO_INCREMENT,
table_name varchar(30) NOT NULL,
- category varchar(50) COLLATE utf8_unicode_ci NOT NULL,
+ category varchar(100) COLLATE utf8_unicode_ci NOT NULL,
position int(2) NOT NULL,
PRIMARY KEY (id_field_category)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
mailing_date datetime NOT NULL,
mailing_recipients text NOT NULL,
mailing_sent tinyint(1) NOT NULL,
- mailing_sender_name varchar(100) DEFAULT NULL,
+ mailing_sender_name varchar(255) DEFAULT NULL,
mailing_sender_address varchar(255) DEFAULT NULL,
PRIMARY KEY (mailing_id),
FOREIGN KEY (mailing_sender) REFERENCES galette_adherents (id_adh) ON DELETE RESTRICT ON UPDATE CASCADE
DROP TABLE IF EXISTS galette_groups;
CREATE TABLE galette_groups (
id_group int(10) NOT NULL AUTO_INCREMENT,
- group_name varchar(50) COLLATE utf8_unicode_ci NOT NULL,
+ group_name varchar(250) COLLATE utf8_unicode_ci NOT NULL,
creation_date datetime NOT NULL,
parent_group int(10) DEFAULT NULL,
PRIMARY KEY (id_group),
model_footer text,
model_body text,
model_styles text,
- model_title varchar(100),
- model_subtitle varchar(100),
+ model_title varchar(250),
+ model_subtitle varchar(250),
model_parent int(10) unsigned DEFAULT NULL REFERENCES galette_pdfmodels (model_id) ON DELETE RESTRICT ON UPDATE CASCADE,
PRIMARY KEY (model_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- new table for temporary links
DROP TABLE IF EXISTS galette_tmplinks;
CREATE TABLE galette_tmplinks (
- hash varchar(60) NOT NULL,
+ hash varchar(250) NOT NULL,
target smallint(1) NOT NULL,
id int(10) unsigned,
creation_date datetime NOT NULL,
CREATE TABLE galette_database (
version DECIMAL(4,3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-INSERT INTO galette_database(version) VALUES(0.94);
+INSERT INTO galette_database(version) VALUES(0.95);
SET FOREIGN_KEY_CHECKS=1;
DROP TABLE IF EXISTS galette_statuts CASCADE;
CREATE TABLE galette_statuts (
id_statut integer DEFAULT nextval('galette_statuts_id_seq'::text) NOT NULL,
- libelle_statut character varying(100) DEFAULT '' NOT NULL,
+ libelle_statut character varying(255) DEFAULT '' NOT NULL,
priorite_statut smallint DEFAULT '0' NOT NULL,
PRIMARY KEY (id_statut)
);
CREATE TABLE galette_titles (
id_title integer DEFAULT nextval('galette_titles_id_seq'::text) NOT NULL,
short_label character varying(10) DEFAULT '' NOT NULL,
- long_label character varying(30) DEFAULT '',
+ long_label character varying(100) DEFAULT '',
PRIMARY KEY (id_title)
);
CREATE TABLE galette_adherents (
id_adh integer DEFAULT nextval('galette_adherents_id_seq'::text) NOT NULL,
id_statut integer DEFAULT '4' REFERENCES galette_statuts(id_statut) ON DELETE RESTRICT ON UPDATE CASCADE,
- nom_adh character varying(50) DEFAULT '' NOT NULL,
- prenom_adh character varying(50) DEFAULT '' NOT NULL,
+ nom_adh character varying(255) DEFAULT '' NOT NULL,
+ prenom_adh character varying(255) DEFAULT '' NOT NULL,
societe_adh character varying(200) DEFAULT NULL,
- pseudo_adh character varying(20) DEFAULT '' NOT NULL,
+ pseudo_adh character varying(255) DEFAULT '' NOT NULL,
titre_adh integer DEFAULT NULL REFERENCES galette_titles(id_title) ON DELETE RESTRICT ON UPDATE CASCADE,
ddn_adh date DEFAULT '19010101',
sexe_adh smallint DEFAULT '0' NOT NULL,
- adresse_adh character varying(150) DEFAULT '' NOT NULL,
- adresse2_adh character varying(150) DEFAULT NULL,
+ adresse_adh text DEFAULT '' NOT NULL,
+ adresse2_adh character varying(150) DEFAULT NULL, -- TODO: remove
cp_adh character varying(10) DEFAULT '' NOT NULL,
- ville_adh character varying(50) DEFAULT '' NOT NULL,
- pays_adh character varying(50) DEFAULT NULL,
- tel_adh character varying(20),
- gsm_adh character varying(20),
+ ville_adh character varying(200) DEFAULT '' NOT NULL,
+ pays_adh character varying(200) DEFAULT NULL,
+ tel_adh character varying(50),
+ gsm_adh character varying(50),
email_adh character varying(255),
- url_adh character varying(200),
- icq_adh character varying(20),
- msn_adh character varying(150),
+ url_adh character varying(255),
+ icq_adh character varying(20), -- TODO: remove
+ msn_adh character varying(150), -- TODO: remove
jabber_adh character varying(150),
info_adh text,
info_public_adh text,
prof_adh character varying(150),
- login_adh character varying(20) DEFAULT '' NOT NULL,
- mdp_adh character varying(60) DEFAULT '' NOT NULL,
+ login_adh character varying(255) DEFAULT '' NOT NULL,
+ mdp_adh character varying(255) DEFAULT '' NOT NULL,
date_crea_adh date DEFAULT '19010101' NOT NULL,
date_modif_adh date DEFAULT '19010101' NOT NULL,
activite_adh boolean DEFAULT FALSE,
pref_lang character varying(20) DEFAULT 'fr_FR',
lieu_naissance text DEFAULT '',
gpgid text DEFAULT NULL,
- fingerprint character varying(50) DEFAULT NULL,
+ fingerprint character varying(255) DEFAULT NULL,
parent_id integer DEFAULT NULL REFERENCES galette_adherents(id_adh) ON DELETE RESTRICT ON UPDATE CASCADE,
PRIMARY KEY (id_adh)
);
DROP TABLE IF EXISTS galette_types_cotisation CASCADE;
CREATE TABLE galette_types_cotisation (
id_type_cotis integer DEFAULT nextval('galette_types_cotisation_id_seq'::text) NOT NULL,
- libelle_type_cotis character varying(100) DEFAULT '' NOT NULL,
+ libelle_type_cotis character varying(255) DEFAULT '' NOT NULL,
cotis_extension boolean DEFAULT FALSE,
PRIMARY KEY (id_type_cotis)
);
trans_id integer DEFAULT nextval('galette_transactions_id_seq'::text) NOT NULL,
trans_date date DEFAULT '19010101' NOT NULL,
trans_amount real DEFAULT '0',
- trans_desc character varying(150) NOT NULL DEFAULT '',
+ trans_desc character varying(255) NOT NULL DEFAULT '',
id_adh integer REFERENCES galette_adherents (id_adh) ON DELETE RESTRICT ON UPDATE CASCADE,
PRIMARY KEY (trans_id)
);
CREATE TABLE galette_preferences (
id_pref integer DEFAULT nextval('galette_preferences_id_seq'::text) NOT NULL,
nom_pref character varying(100) DEFAULT '' NOT NULL,
- val_pref character varying(200) DEFAULT '' NOT NULL,
+ val_pref character varying(255) DEFAULT '' NOT NULL,
PRIMARY KEY (id_pref)
);
-- add index, nom_pref is used as foreign key elsewhere
id_log integer DEFAULT nextval('galette_logs_id_seq'::text) NOT NULL,
date_log timestamp NOT NULL,
ip_log character varying(46) DEFAULT '' NOT NULL,
- adh_log character varying(41) DEFAULT '' NOT NULL,
+ adh_log character varying(255) DEFAULT '' NOT NULL, -- see galette_adherents.login_adh
text_log text,
action_log text,
sql_log text,
field_id integer DEFAULT nextval('galette_field_types_id_seq'::text) NOT NULL,
field_form character varying(10) NOT NULL,
field_index integer DEFAULT '0' NOT NULL,
- field_name character varying(40) DEFAULT '' NOT NULL,
+ field_name character varying(255) DEFAULT '' NOT NULL,
field_perm integer DEFAULT '0' NOT NULL,
field_type integer DEFAULT '0' NOT NULL,
field_required boolean DEFAULT FALSE,
-- Table for dynamic translation of strings;
DROP TABLE IF EXISTS galette_l10n;
CREATE TABLE galette_l10n (
- text_orig character varying(100) NOT NULL,
+ text_orig character varying(255) NOT NULL,
text_locale character varying(15) NOT NULL,
text_nref integer DEFAULT '1' NOT NULL,
- text_trans character varying(100) DEFAULT '' NOT NULL,
+ text_trans character varying(255) DEFAULT '' NOT NULL,
PRIMARY KEY (text_orig, text_locale)
);
DROP TABLE IF EXISTS galette_tmppasswds;
CREATE TABLE galette_tmppasswds (
id_adh integer REFERENCES galette_adherents (id_adh) ON DELETE CASCADE ON UPDATE CASCADE,
- tmp_passwd character varying(60) NOT NULL,
+ tmp_passwd character varying(250) NOT NULL,
date_crea_tmp_passwd timestamp NOT NULL,
PRIMARY KEY (id_adh)
);
tsubject character varying(256) NOT NULL,
tbody text NOT NULL,
tlang character varying(16) NOT NULL,
- tcomment character varying(64) NOT NULL,
+ tcomment character varying(255) NOT NULL,
PRIMARY KEY (tid)
);
CREATE UNIQUE INDEX galette_texts_localizedtxt_idx ON galette_texts (tref, tlang);
CREATE TABLE galette_fields_categories (
id_field_category integer DEFAULT nextval('galette_fields_categories_id_seq'::text) NOT NULL,
table_name character varying(30) NOT NULL,
- category character varying(50) NOT NULL,
+ category character varying(100) NOT NULL,
position integer NOT NULL,
PRIMARY KEY (id_field_category)
);
mailing_date timestamp NOT NULL,
mailing_recipients text NOT NULL,
mailing_sent boolean DEFAULT FALSE,
- mailing_sender_name character varying(100) DEFAULT NULL,
+ mailing_sender_name character varying(255) DEFAULT NULL,
mailing_sender_address character varying(255) DEFAULT NULL,
PRIMARY KEY (mailing_id)
);
DROP TABLE IF EXISTS galette_groups CASCADE;
CREATE TABLE galette_groups (
id_group integer DEFAULT nextval('galette_groups_id_seq'::text) NOT NULL,
- group_name character varying(50) NOT NULL CONSTRAINT name UNIQUE,
+ group_name character varying(250) NOT NULL CONSTRAINT name UNIQUE,
creation_date timestamp NOT NULL,
parent_group integer DEFAULT NULL REFERENCES galette_groups(id_group) ON DELETE RESTRICT ON UPDATE CASCADE,
PRIMARY KEY (id_group)
model_footer text,
model_body text,
model_styles text,
- model_title character varying(100),
- model_subtitle character varying(100),
+ model_title character varying(250),
+ model_subtitle character varying(250),
model_parent integer DEFAULT NULL REFERENCES galette_pdfmodels (model_id) ON DELETE RESTRICT ON UPDATE CASCADE,
PRIMARY KEY (model_id)
);
-- new table for temporary links
DROP TABLE IF EXISTS galette_tmplinks;
CREATE TABLE galette_tmplinks (
- hash character varying(60) NOT NULL,
+ hash character varying(250) NOT NULL,
target smallint NOT NULL,
id integer NOT NULL,
creation_date timestamp NOT NULL,
CREATE TABLE galette_database (
version decimal NOT NULL
);
-INSERT INTO galette_database (version) VALUES(0.94);
+INSERT INTO galette_database (version) VALUES(0.95);
--- /dev/null
+-- Update fields length
+ALTER TABLE galette_adherents CHANGE nom_adh nom_adh varchar(255) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE prenom_adh prenom_adh varchar(255) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE pseudo_adh pseudo_adh varchar(255) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE adresse_adh adresse_adh text NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE ville_adh ville_adh varchar(200) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE pays_adh pays_adh varchar(200) default NULL;
+ALTER TABLE galette_adherents CHANGE tel_adh tel_adh varchar(50) default NULL;
+ALTER TABLE galette_adherents CHANGE gsm_adh gsm_adh varchar(50) default NULL;
+ALTER TABLE galette_adherents CHANGE url_adh url_adh varchar(255) default NULL;
+ALTER TABLE galette_adherents CHANGE login_adh login_adh varchar(255) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE mdp_adh mdp_adh varchar(255) NOT NULL default '';
+ALTER TABLE galette_adherents CHANGE fingerprint fingerprint varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_transactions CHANGE trans_desc trans_desc varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_statuts CHANGE libelle_statut libelle_statut varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_titles CHANGE long_label long_label varchar(100) default '';
+
+ALTER TABLE galette_preferences CHANGE val_pref val_pref varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_logs CHANGE adh_log adh_log varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_field_types CHANGE field_name field_name varchar(255) NOT NULL default '';
+
+ALTER TABLE galette_l10n CHANGE text_orig text_orig varchar(255) NOT NULL;
+ALTER TABLE galette_l10n CHANGE text_trans text_trans varchar(255) NOT NULL;
+
+ALTER TABLE galette_tmppasswds CHANGE tmp_passwd tmp_passwd varchar(250) NOT NULL;
+
+ALTER TABLE galette_texts CHANGE tcomment tcomment varchar(255) NOT NULL;
+
+ALTER TABLE galette_fields_categories CHANGE category category varchar(100) NOT NULL default '';
+
+ALTER TABLE galette_mailing_history CHANGE mailing_sender_name mailing_sender_name varchar(255) DEFAULT NULL;
+
+ALTER TABLE galette_groups CHANGE group_name group_name varchar(250) NOT NULL;
+
+ALTER TABLE galette_pdfmodels CHANGE model_title model_title varchar(250);
+ALTER TABLE galette_pdfmodels CHANGE model_subtitle model_subtitle varchar(250);
+
+ALTER TABLE galette_tmplinks CHANGE hash hash varchar(250) NOT NULL;
+
+UPDATE galette_database SET version = 0.950;
--- /dev/null
+-- Update fields length
+ALTER TABLE galette_adherents ALTER COLUMN nom_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN prenom_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN pseudo_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN adresse_adh TYPE text;
+ALTER TABLE galette_adherents ALTER COLUMN ville_adh TYPE varchar(200);
+ALTER TABLE galette_adherents ALTER COLUMN pays_adh TYPE varchar(200);
+ALTER TABLE galette_adherents ALTER COLUMN tel_adh TYPE varchar(50);
+ALTER TABLE galette_adherents ALTER COLUMN gsm_adh TYPE varchar(50);
+ALTER TABLE galette_adherents ALTER COLUMN url_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN login_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN mdp_adh TYPE varchar(255);
+ALTER TABLE galette_adherents ALTER COLUMN fingerprint TYPE varchar(255);
+
+ALTER TABLE galette_transactions ALTER COLUMN trans_desc TYPE varchar(255);
+
+ALTER TABLE galette_statuts ALTER COLUMN libelle_statut TYPE varchar(255);
+
+ALTER TABLE galette_titles ALTER COLUMN long_label TYPE varchar(100);
+
+ALTER TABLE galette_preferences ALTER COLUMN val_pref TYPE varchar(255);
+
+ALTER TABLE galette_logs ALTER COLUMN adh_log TYPE varchar(255);
+
+ALTER TABLE galette_field_types ALTER COLUMN field_name TYPE varchar(255);
+
+ALTER TABLE galette_l10n ALTER COLUMN text_orig TYPE varchar(255);
+ALTER TABLE galette_l10n ALTER COLUMN text_trans TYPE varchar(255);
+
+ALTER TABLE galette_tmppasswds ALTER COLUMN tmp_passwd TYPE varchar(250);
+
+ALTER TABLE galette_texts ALTER COLUMN tcomment TYPE varchar(255);
+
+ALTER TABLE galette_fields_categories ALTER COLUMN category TYPE varchar(100);
+
+ALTER TABLE galette_mailing_history ALTER COLUMN mailing_sender_name TYPE varchar(255);
+
+ALTER TABLE galette_groups ALTER COLUMN group_name TYPE varchar(250);
+
+ALTER TABLE galette_pdfmodels ALTER COLUMN model_title TYPE varchar(250);
+ALTER TABLE galette_pdfmodels ALTER COLUMN model_subtitle TYPE varchar(250);
+
+ALTER TABLE galette_tmplinks ALTER COLUMN hash hash varchar(250);
+
+UPDATE galette_database SET version = 0.950;
*
* PHP version 5
*
- * Copyright © 2014 The Galette Team
+ * Copyright © 2014-2021 The Galette Team
*
* This file is part of Galette (http://galette.tuxfamily.org).
*
* @package GaletteTests
*
* @author Johan Cwiklinski <johan@x-tnd.be>
- * @copyright 2014 The Galette Team
+ * @copyright 2014-2021 The Galette Team
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
* @version SVN: $Id$
* @link http://galette.tuxfamily.org
* @name Db
* @package GaletteTests
* @author Johan Cwiklinski <johan@x-tnd.be>
- * @copyright 2014 The Galette Team
+ * @copyright 2014-2021 The Galette Team
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
* @link http://galette.tuxfamily.org
* @since 2014-01-03
'0.92' => 'upgrade-to-0.92-pgsql.sql',
'0.93' => 'upgrade-to-0.93-pgsql.sql',
'0.931' => 'upgrade-to-0.931-pgsql.sql',
- '0.94' => 'upgrade-to-0.94-pgsql.sql'
+ '0.94' => 'upgrade-to-0.94-pgsql.sql',
+ '0.95' => 'upgrade-to-0.95-pgsql.sql'
);
$this->array($update_scripts)
Projects / galette.git / commitdiff