[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4106 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4106 - phpcompta/trunk/sql |
Date: |
Mon, 16 May 2011 18:31:19 +0200 (CEST) |
Author: danydb
Date: 2011-05-16 18:31:19 +0200 (Mon, 16 May 2011)
New Revision: 4106
Modified:
phpcompta/trunk/sql/upgrade.sql
Log:
upgrade93a
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2011-05-16 16:02:25 UTC (rev 4105)
+++ phpcompta/trunk/sql/upgrade.sql 2011-05-16 16:31:19 UTC (rev 4106)
@@ -1,7 +1,3 @@
-create unique index qs_j_id on quant_sold(j_id);
-create unique index qp_j_id on quant_purchase(j_id);
-create unique index qf_jr_id on quant_fin(jr_id);
-update jrn_def set
jrn_def_code=substr(jrn_def_code,1,1)||substr(jrn_def_code,length(jrn_def_code)-1,length(jrn_def_code));
alter table operation_analytique drop column pa_id;
ALTER TABLE operation_analytique ADD CONSTRAINT
operation_analytique_oa_amount_check CHECK (oa_amount >= 0::numeric);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4106 - phpcompta/trunk/sql,
phpcompta-dev <=