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 _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
