Overview
| Comment: | Just in case ther's a mixed position and outside of 6/7 account codes |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
04a0506fd24a451f635a3ba349f61432 |
| User & Date: | bohwaz on 2020-12-09 18:20:33 |
| Other Links: | manifest | tags |
Context
|
2020-12-09
| ||
| 18:23 | Improve design of list of years, and add number of transactions check-in: 95f0daf9e2 user: bohwaz tags: trunk | |
| 18:20 | Just in case ther's a mixed position and outside of 6/7 account codes check-in: 04a0506fd2 user: bohwaz tags: trunk | |
| 18:19 | Don't set "expense or revenue" positions to 0, instead match them to something valid check-in: 0d0115af98 user: bohwaz tags: trunk | |
Changes
Modified src/include/data/1.0.0_migration.sql from [c04d39f6e6] to [7cad22fc7d].
| ︙ | ︙ | |||
24 25 26 27 28 29 30 31 32 33 34 35 36 37 | WHEN position = 2 THEN 1 WHEN position = 3 THEN 3 WHEN position = 4 THEN 5 WHEN position = 8 THEN 4 -- Suppression de la position "charge ou produit" qui n'a aucun sens WHEN position = 12 AND code LIKE '6%' THEN 4 WHEN position = 12 AND code LIKE '7%' THEN 5 ELSE 0 END, CASE WHEN plan_comptable = 1 THEN 0 ELSE 1 END FROM compta_comptes; -- Migrations projets vers comptes analytiques INSERT INTO acc_accounts (id_chart, code, label, position, user, type) | > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | WHEN position = 2 THEN 1 WHEN position = 3 THEN 3 WHEN position = 4 THEN 5 WHEN position = 8 THEN 4 -- Suppression de la position "charge ou produit" qui n'a aucun sens WHEN position = 12 AND code LIKE '6%' THEN 4 WHEN position = 12 AND code LIKE '7%' THEN 5 WHEN position = 12 THEN 0 ELSE 0 END, CASE WHEN plan_comptable = 1 THEN 0 ELSE 1 END FROM compta_comptes; -- Migrations projets vers comptes analytiques INSERT INTO acc_accounts (id_chart, code, label, position, user, type) |
| ︙ | ︙ |