[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4946 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4946 - phpcompta/trunk/sql |
Date: |
Tue, 19 Jun 2012 19:48:03 +0200 (CEST) |
Author: danydb
Date: 2012-06-19 19:48:03 +0200 (Tue, 19 Jun 2012)
New Revision: 4946
Modified:
phpcompta/trunk/sql/upgrade.sql
Log:
Correct script SQL
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2012-06-19 17:47:26 UTC (rev 4945)
+++ phpcompta/trunk/sql/upgrade.sql 2012-06-19 17:48:03 UTC (rev 4946)
@@ -188,7 +188,7 @@
ALTER TABLE document_type ADD COLUMN dt_prefix text;
COMMENT ON COLUMN document_type.dt_prefix IS 'Prefix for ag_ref';
-update document_type set dt_prefix= upper(substr(replace(dt_value,'
',''),0,7))||dt_id::text
+update document_type set dt_prefix= upper(substr(replace(dt_value,'
',''),0,7))||dt_id::text;
CREATE TABLE user_sec_action_profile
(
@@ -268,7 +268,6 @@
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;
CREATE INDEX fk_stock_good_repository_r_id ON stock_goods (r_id );
alter table action_gestion drop ag_cal;
@@ -371,10 +370,8 @@
CREATE TRIGGER fiche_detail_upd_trg BEFORE UPDATE ON fiche_detail FOR
EACH ROW EXECUTE PROCEDURE comptaproc.fiche_detail_qcode_upd();
update menu_ref set me_description='Gestion des attributs de fiches ' where
me_code='CFGATCARD';
+ALTER TABLE stock_goods ADD COLUMN c_id bigint;
-ALTER TABLE stock_goods ADD CONSTRAINT stock_goods_c_id_fkey FOREIGN KEY
(c_id) REFERENCES stock_change (c_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE;
-
CREATE TABLE stock_change
(
c_id bigserial NOT NULL,
@@ -389,6 +386,5 @@
ON UPDATE CASCADE ON DELETE CASCADE
);
-ALTER TABLE stock_goods ADD COLUMN c_id bigint;
-ALTER TABLE stock_goods ADD CONSTRAINT stock_goods_c_id_fkey FOREIGN KEY
(c_id) REFERENCES stock_change (c_id) MATCH SIMPLE
- ON UPDATE CASCADE ON DELETE CASCADE;
\ No newline at end of file
+ALTER TABLE stock_goods ADD CONSTRAINT stock_goods_c_id_fkey FOREIGN KEY
(c_id) REFERENCES stock_change (c_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE;
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4946 - phpcompta/trunk/sql,
phpcompta-dev <=