[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4964 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4964 - phpcompta/trunk/sql |
Date: |
Thu, 21 Jun 2012 16:18:14 +0200 (CEST) |
Author: danydb
Date: 2012-06-21 16:18:13 +0200 (Thu, 21 Jun 2012)
New Revision: 4964
Modified:
phpcompta/trunk/sql/upgrade.sql
Log:
Fix action_gestion add not null constraint + default =-1 for ag_dest
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2012-06-21 14:06:00 UTC (rev 4963)
+++ phpcompta/trunk/sql/upgrade.sql 2012-06-21 14:18:13 UTC (rev 4964)
@@ -388,8 +388,11 @@
ALTER TABLE stock_goods ADD CONSTRAINT stock_goods_c_id_fkey FOREIGN KEY
(c_id) REFERENCES stock_change (c_id) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE;
-update action_gestion set ag_id=-1 ;
+update action_gestion set ag_dest=-1 ;
+alter table action_gestion alter ag_dest set not null;
+alter table action_gestion alter ag_dest set default -1;
+
update menu_ref set me_code='CSV:reportinit' where me_code='CVS:reportinit';
update menu_ref set me_file='export_histo_csv.php' where me_code='CSV:histo';
update menu_ref set me_file='export_ledger_csv.php' where
me_code='CSV:ledger';
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4964 - phpcompta/trunk/sql,
phpcompta-dev <=