[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4550 - in phpcompta/trunk: html/admin/sql/patch include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4550 - in phpcompta/trunk: html/admin/sql/patch include sql |
Date: |
Sat, 3 Dec 2011 21:33:41 +0100 (CET) |
Author: danydb
Date: 2011-12-03 21:33:40 +0100 (Sat, 03 Dec 2011)
New Revision: 4550
Added:
phpcompta/trunk/html/admin/sql/patch/upgrade98.sql
Modified:
phpcompta/trunk/include/constant.php
phpcompta/trunk/sql/upgrade.sql
Log:
champs dans attr_def
Ajout dans PCMN poste comptable manquant
Added: phpcompta/trunk/html/admin/sql/patch/upgrade98.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade98.sql
(rev 0)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade98.sql 2011-12-03 20:33:40 UTC
(rev 4550)
@@ -0,0 +1,10 @@
+begin;
+
+update attr_def set ad_type='numeric' where ad_id=20;
+insert into tmp_pcmn (pcm_val,pcm_lib,pcm_val_parent,pcm_type) select
split_part(tva_poste,',',1),tva_comment,substring(split_part(tva_poste,',',1),1,3),'PAS'
from tva_rate where split_part(tva_poste,',',1) not in (select pcm_val from
tmp_pcmn);
+insert into tmp_pcmn (pcm_val,pcm_lib,pcm_val_parent,pcm_type) select
split_part(tva_poste,',',2),tva_comment,substring(split_part(tva_poste,',',2),1,3),'ACT'
from tva_rate where split_part(tva_poste,',',2) not in (select pcm_val from
tmp_pcmn);
+
+
+update version set val=99;
+
+commit;
\ No newline at end of file
Modified: phpcompta/trunk/include/constant.php
===================================================================
--- phpcompta/trunk/include/constant.php 2011-12-03 20:25:30 UTC (rev
4549)
+++ phpcompta/trunk/include/constant.php 2011-12-03 20:33:40 UTC (rev
4550)
@@ -42,7 +42,7 @@
/* $version_phpcompta=4444;
define ("DEBUG",false);
*/
-define ("DBVERSION",98);
+define ("DBVERSION",99);
define ("DBVERSIONREPO",14);
define ('NOTFOUND','--not found--');
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2011-12-03 20:25:30 UTC (rev 4549)
+++ phpcompta/trunk/sql/upgrade.sql 2011-12-03 20:33:40 UTC (rev 4550)
@@ -1 +1,3 @@
update attr_def set ad_type='numeric' where ad_id=20;
+insert into tmp_pcmn (pcm_val,pcm_lib,pcm_val_parent,pcm_type) select
split_part(tva_poste,',',1),tva_comment,substring(split_part(tva_poste,',',1),1,3),'PAS'
from tva_rate where split_part(tva_poste,',',1) not in (select pcm_val from
tmp_pcmn);
+insert into tmp_pcmn (pcm_val,pcm_lib,pcm_val_parent,pcm_type) select
split_part(tva_poste,',',2),tva_comment,substring(split_part(tva_poste,',',2),1,3),'ACT'
from tva_rate where split_part(tva_poste,',',2) not in (select pcm_val from
tmp_pcmn);
\ No newline at end of file
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4550 - in phpcompta/trunk: html/admin/sql/patch include sql,
phpcompta-dev <=