Author: danydb Date: 2012-06-15 10:47:03 +0200 (Fri, 15 Jun 2012) New Revision: 4905
Modified: phpcompta/trunk/sql/upgrade.sql Log: correct SQL Modified: phpcompta/trunk/sql/upgrade.sql =================================================================== --- phpcompta/trunk/sql/upgrade.sql 2012-06-15 00:51:26 UTC (rev 4904) +++ phpcompta/trunk/sql/upgrade.sql 2012-06-15 08:47:03 UTC (rev 4905) @@ -262,12 +262,11 @@ COMMENT ON COLUMN user_sec_repository.p_id IS 'fk to profile'; COMMENT ON COLUMN user_sec_repository.r_id IS 'fk to stock_repository'; COMMENT ON COLUMN user_sec_repository.ur_right IS 'Type of right : R for readonly W for write'; -alter table stock_good add r_id bigint; +alter table stock_goods add r_id bigint; alter table user_sec_repository add constraint user_sec_repository_r_id_p_id_u unique (r_id,p_id); alter table user_sec_action_profile add constraint user_sec_action_profile_p_id_p_granted_u unique (p_id,p_granted); ALTER TABLE stock_goods ADD COLUMN r_id bigint; update stock_goods set r_id=1; -ALTER TABLE stock_goods ADD CONSTRAINT stock_goods_sg_type CHECK (sg_type = 'c'::bpchar OR sg_type = 'd'::bpchar); CREATE INDEX fk_stock_good_repository_r_id ON stock_goods (r_id ); alter table action_gestion drop ag_cal; \ No newline at end of file --- 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
