Artifact 6227606b97cd3aa1296c0c2e7b884ae0b6aa2085:
- File archives/0.9.1_migration.sql — part of check-in [e807e8f5d7] at 2020-10-25 01:07:04 on branch dev — Add 2018 accounting chart for France, use it for upgrade and install, and archive old SQL schemas and migrations (user: bohwaz, size: 506) [annotate] [blame] [check-ins using] [more...]
- File src/include/data/0.9.1_migration.sql — part of check-in [757810afbb] at 2020-01-20 00:12:49 on branch dev — Garder les anciens schémas SQL pour les migrations qui les utilisent (user: bohwaz, size: 506) [annotate] [blame] [check-ins using]
-- Il manquait une clause ON DELETE SET NULL sur la foreign key -- de cotisations quand on faisait une mise à jour depuis une -- ancienne version ALTER TABLE cotisations RENAME TO cotisations_old; .read 0.9.1_schema.sql INSERT INTO cotisations SELECT * FROM cotisations_old; DROP TABLE cotisations_old; -- Changer le compte des reports automatiques UPDATE compta_journal SET compte_debit = '890' WHERE compte_debit IS NULL; UPDATE compta_journal SET compte_credit = '890' WHERE compte_credit IS NULL;