noalyss-commit
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Noalyss-commit] [noalyss] 147/219: ANC : ANC_TABLE replace PGPLSQL proc


From: Dany De Bontridder
Subject: [Noalyss-commit] [noalyss] 147/219: ANC : ANC_TABLE replace PGPLSQL procedure by Php functions : Anc_Table:create_temp_account Anc_Table:create_temp_card
Date: Mon, 18 Dec 2017 13:22:54 -0500 (EST)

sparkyx pushed a commit to branch master
in repository noalyss.

commit 6631ddf1e51d298c443c89273fa116c420e77943
Author: Dany De Bontridder <address@hidden>
Date:   Tue Nov 7 13:25:25 2017 +0100

    ANC : ANC_TABLE replace PGPLSQL procedure by Php functions :
    Anc_Table:create_temp_account
    Anc_Table:create_temp_card
---
 sql/upgrade.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 4a342e2..5aeecfe 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -19,5 +19,5 @@ ALTER TABLE operation_analytique ADD COLUMN f_id bigint;
 ALTER TABLE operation_analytique  ADD CONSTRAINT 
operation_analytique_fiche_id_fk FOREIGN KEY (f_id)       REFERENCES fiche 
(f_id) MATCH SIMPLE       ON UPDATE cascade ON cascade;
 COMMENT ON COLUMN operation_analytique.f_id IS 'FK to fiche.f_id , used only 
with ODS';
 
-CREATE OR REPLACE FUNCTION comptaproc.table_analytic_account(text,text);
-CREATE OR REPLACE FUNCTION comptaproc.table_analytic_card(text,text);
\ No newline at end of file
+drop FUNCTION comptaproc.table_analytic_account(text,text);
+drop FUNCTION comptaproc.table_analytic_card(text,text);
\ No newline at end of file



reply via email to

[Prev in Thread] Current Thread [Next in Thread]