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

[phpcompta-dev]

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