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); _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
