Overview
Comment:Fix migration from 0.9.8
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7da1bb41de4a37eb79fa83b670f488424651b085
User & Date: bohwaz on 2020-12-10 12:40:54
Other Links: manifest | tags
Context
2020-12-10
13:08
Message for IE/Edge was not working, lol check-in: f4551764d9 user: bohwaz tags: trunk, stable
12:40
Fix migration from 0.9.8 check-in: 7da1bb41de user: bohwaz tags: trunk
12:17
Use todays date in new transaction check-in: 7efebf836d user: bohwaz tags: trunk
Changes

Modified src/include/data/1.0.0_migration.sql from [7cad22fc7d] to [4e16391488].

22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
	CASE
		WHEN position = 1 THEN 2
		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







|
|







22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
	CASE
		WHEN position = 1 THEN 2
		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 id LIKE '6%' THEN 4
		WHEN position = 12 AND id 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