Overview
Comment: | Fix upgrade from 0.9.8 versions |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk | stable |
Files: | files | file ages | folders |
SHA3-256: |
6f3d72d02cd2615c09371a3cf4070316 |
User & Date: | bohwaz on 2021-06-28 13:32:03 |
Other Links: | manifest | tags |
Context
2021-06-29
| ||
01:51 | Fix migration from 0.9.8 when service duration was zero instead of NULL, and when some services were not added back check-in: a22b11d69c user: bohwaz tags: trunk, stable | |
2021-06-28
| ||
13:32 | Fix upgrade from 0.9.8 versions check-in: 6f3d72d02c user: bohwaz tags: trunk, stable | |
13:31 | Update doc links check-in: 1df606f73f user: bohwaz tags: trunk | |
Changes
Modified src/include/data/1.0.0_migration.sql from [4e16391488] to [218d7afd21].
︙ | |||
172 173 174 175 176 177 178 | 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 | + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + | DROP TABLE compta_comptes; DROP TABLE compta_exercices; DROP TABLE membres_operations_old; DROP TABLE compta_projets; DROP TABLE compta_comptes_bancaires; DROP TABLE compta_moyens_paiement; INSERT INTO acc_charts (country, code, label) VALUES ('FR', 'PCA2018', 'Plan comptable associatif 2018'); CREATE TEMP TABLE tmp_accounts (code,label,description,position,type); .import charts/fr_2018.csv tmp_accounts INSERT INTO acc_accounts (id_chart, code, label, description, position, type) SELECT (SELECT id FROM acc_charts WHERE code = 'PCA2018'), code, label, description, CASE position WHEN 'Actif' THEN 1 WHEN 'Passif' THEN 2 WHEN 'Actif ou passif' THEN 3 WHEN 'Charge' THEN 4 WHEN 'Produit' THEN 5 ELSE 0 END, CASE type WHEN 'Banque' THEN 1 WHEN 'Caisse' THEN 2 WHEN 'Attente d''encaissement' THEN 3 WHEN 'Tiers' THEN 4 WHEN 'Dépenses' THEN 5 WHEN 'Recettes' THEN 6 WHEN 'Analytique' THEN 7 WHEN 'Bénévolat' THEN 8 WHEN 'Ouverture' THEN 9 WHEN 'Clôture' THEN 10 WHEN 'Résultat excédentaire' THEN 11 WHEN 'Résultat déficitaire' THEN 12 ELSE 0 END FROM tmp_accounts; DROP TABLE tmp_accounts; |
Modified src/include/lib/Garradin/Upgrade.php from [afc0149baa] to [ef2fdce049].
︙ | |||
55 56 57 58 59 60 61 | 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | - - - - - - - - | try { if (version_compare($v, '1.0.0-rc1', '<')) { $db->beginSchemaUpdate(); $db->import(ROOT . '/include/data/1.0.0_migration.sql'); $db->commitSchemaUpdate(); |
︙ |