Anomalie #1125 » 0002-Update-fields-category-names-in-the-database-on-next.patch
| galette/install/scripts/upgrade-to-0.93-mysql.sql | ||
|---|---|---|
|
ALTER TABLE galette_cotisations CHANGE date_fin_cotis date_fin_cotis date NOT NULL default '1901-01-01';
|
||
|
ALTER TABLE galette_transactions CHANGE trans_date trans_date date NOT NULL default '1901-01-01';
|
||
|
UPDATE galette_fields_categories SET category = 'Indentity:' WHERE id_field_category = 1;
|
||
|
UPDATE galette_fields_categories SET category = 'Galette-related data:' WHERE id_field_category = 2;
|
||
|
UPDATE galette_fields_categories SET category = 'Contact information:' WHERE id_field_category = 3;
|
||
|
UPDATE galette_database SET version = 0.93;
|
||
|
SET FOREIGN_KEY_CHECKS=1;
|
||
| galette/install/scripts/upgrade-to-0.93-pgsql.sql | ||
|---|---|---|
|
-- add unicity on searches
|
||
|
CREATE INDEX galette_searches_idx ON galette_searches (form, parameters_sum, id_adh);
|
||
|
UPDATE galette_fields_categories SET category = 'Indentity:' WHERE id_field_category = 1;
|
||
|
UPDATE galette_fields_categories SET category = 'Galette-related data:' WHERE id_field_category = 2;
|
||
|
UPDATE galette_fields_categories SET category = 'Contact information:' WHERE id_field_category = 3;
|
||
|
UPDATE galette_database SET version = 0.93;
|
||