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: 04a0506fd24a451f635a3ba349f614322cb48fc8
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
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)