[Phpcompta-dev] r5033 - phpcompta/trunk/html/admin/sql/patch

[phpcompta-dev]

Author: danydb
Date: 2012-06-29 00:55:44 +0200 (Fri, 29 Jun 2012)
New Revision: 5033

Modified:
   phpcompta/trunk/html/admin/sql/patch/upgrade102.sql
Log:
Change table tmp_stockgoods_detail ajout col. f_id

Modified: phpcompta/trunk/html/admin/sql/patch/upgrade102.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade102.sql 2012-06-28 22:55:19 UTC 
(rev 5032)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade102.sql 2012-06-28 22:55:44 UTC 
(rev 5033)
@@ -346,7 +346,7 @@
 
 create table tmp_stockgood (s_id bigserial primary key,s_date timestamp 
default now());
 create table tmp_stockgood_detail(d_id bigserial primary key,s_id bigint 
references tmp_stockgood(s_id) on delete cascade,
-sg_code text,s_qin numeric(20,4),s_qout numeric(20,4),r_id bigint);
+sg_code text,s_qin numeric(20,4),s_qout numeric(20,4),r_id bigint,f_id bigint);
 
 
 



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu