[Phpcompta-dev] r4935 - phpcompta/trunk/sql

[phpcompta-dev]

Author: danydb
Date: 2012-06-18 18:26:43 +0200 (Mon, 18 Jun 2012)
New Revision: 4935

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
upgrade create table stock_change and add column to stock_goods

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2012-06-18 16:23:36 UTC (rev 4934)
+++ phpcompta/trunk/sql/upgrade.sql     2012-06-18 16:26:43 UTC (rev 4935)
@@ -377,8 +377,16 @@
 
 CREATE TABLE stock_change
 (
-  c_id bigserial NOT NULL,
+   c_id bigserial NOT NULL,
   c_comment text,
   c_date date,
-  CONSTRAINT stock_change_pkey PRIMARY KEY (c_id )
-);
\ No newline at end of file
+  tech_user text,
+  r_id bigint,
+  tech_date time with time zone NOT NULL DEFAULT now(),
+  CONSTRAINT stock_change_pkey PRIMARY KEY (c_id ),
+  CONSTRAINT stock_change_r_id_fkey FOREIGN KEY (r_id)
+      REFERENCES stock_repository (r_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+);
+
+ALTER TABLE stock_goods ADD COLUMN c_id bigint;



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