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

[phpcompta-dev]

Author: danydb
Date: 2011-11-22 23:44:52 +0100 (Tue, 22 Nov 2011)
New Revision: 4446

Modified:
   phpcompta/trunk/sql/account-update.sql
   phpcompta/trunk/sql/account_alphanum.sql
   phpcompta/trunk/sql/account_compute.sql
   phpcompta/trunk/sql/account_insert.sql
   phpcompta/trunk/sql/ajax-direct-form.sql
   phpcompta/trunk/sql/format_account.sql
   phpcompta/trunk/sql/tmp_pcmn_alphanum_ins_upd.sql
   phpcompta/trunk/sql/tmp_pcmn_ins.sql
   phpcompta/trunk/sql/trigger.tmp_pcmn.sql
   phpcompta/trunk/sql/tva.sql
Log:

update script SQL


Modified: phpcompta/trunk/sql/account-update.sql
===================================================================
--- phpcompta/trunk/sql/account-update.sql      2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/account-update.sql      2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,7 +1,3 @@
--- Function: comptaproc.account_update(integer, account_type)
-
--- DROP FUNCTION comptaproc.account_update(integer, account_type);
-
 CREATE OR REPLACE FUNCTION comptaproc.account_update(p_f_id integer, p_account 
account_type)
   RETURNS integer AS
 $BODY$
@@ -50,5 +46,4 @@
 return 0;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+LANGUAGE plpgsql;

Modified: phpcompta/trunk/sql/account_alphanum.sql
===================================================================
--- phpcompta/trunk/sql/account_alphanum.sql    2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/account_alphanum.sql    2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,7 +1,3 @@
--- Function: comptaproc.account_auto(integer)
-
--- DROP FUNCTION comptaproc.account_auto(integer);
-
 CREATE OR REPLACE FUNCTION comptaproc.account_alphanum()
   RETURNS boolean AS
 $BODY$
@@ -16,5 +12,4 @@
        return l_auto;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+  LANGUAGE plpgsql;

Modified: phpcompta/trunk/sql/account_compute.sql
===================================================================
--- phpcompta/trunk/sql/account_compute.sql     2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/account_compute.sql     2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,7 +1,3 @@
--- Function: comptaproc.account_compute(integer)
-
--- DROP FUNCTION comptaproc.account_compute(integer);
-
 CREATE OR REPLACE FUNCTION comptaproc.account_compute(p_f_id integer)
   RETURNS account_type AS
 $BODY$
@@ -44,5 +40,5 @@
        return sResult;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+LANGUAGE plpgsql;
+  

Modified: phpcompta/trunk/sql/account_insert.sql
===================================================================
--- phpcompta/trunk/sql/account_insert.sql      2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/account_insert.sql      2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,5 +1,3 @@
--- Function: comptaproc.account_insert(integer, text)
-
  DROP FUNCTION comptaproc.account_insert(integer, text);
 
 CREATE OR REPLACE FUNCTION comptaproc.account_insert(p_f_id integer, p_account 
text)
@@ -85,5 +83,5 @@
 return 0;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+LANGUAGE plpgsql;
+

Modified: phpcompta/trunk/sql/ajax-direct-form.sql
===================================================================
--- phpcompta/trunk/sql/ajax-direct-form.sql    2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/ajax-direct-form.sql    2011-11-22 22:44:52 UTC (rev 
4446)
@@ -57,5 +57,5 @@
        return;
 end;
 $BODY$
-  LANGUAGE plpgsql;
+LANGUAGE plpgsql;
        

Modified: phpcompta/trunk/sql/format_account.sql
===================================================================
--- phpcompta/trunk/sql/format_account.sql      2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/format_account.sql      2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,7 +1,3 @@
--- Function: comptaproc.format_account(account_type)
-
--- DROP FUNCTION comptaproc.format_account(account_type);
-
 CREATE OR REPLACE FUNCTION comptaproc.format_account(p_account account_type)
   RETURNS account_type AS
 $BODY$
@@ -22,10 +18,10 @@
 
 return upper(sResult);
 
-end;$BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
-
+end;
+$BODY$
+LANGUAGE plpgsql;
+  
 COMMENT ON FUNCTION comptaproc.format_account(account_type) IS 'format the 
accounting :
 - upper case
 - remove space and special char.

Modified: phpcompta/trunk/sql/tmp_pcmn_alphanum_ins_upd.sql
===================================================================
--- phpcompta/trunk/sql/tmp_pcmn_alphanum_ins_upd.sql   2011-11-22 22:31:40 UTC 
(rev 4445)
+++ phpcompta/trunk/sql/tmp_pcmn_alphanum_ins_upd.sql   2011-11-22 22:44:52 UTC 
(rev 4446)
@@ -11,5 +11,4 @@
 return r_record;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+LANGUAGE plpgsql;

Modified: phpcompta/trunk/sql/tmp_pcmn_ins.sql
===================================================================
--- phpcompta/trunk/sql/tmp_pcmn_ins.sql        2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/tmp_pcmn_ins.sql        2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,8 +1,4 @@
--- Function: comptaproc.tmp_pcmn_ins()
-
--- DROP FUNCTION comptaproc.tmp_pcmn_ins();
-
-CREATE OR REPLACE FUNCTION comptaproc.tmp_pcmn_ins()
+ZCREATE OR REPLACE FUNCTION comptaproc.tmp_pcmn_ins()
   RETURNS trigger AS
 $BODY$
 declare
@@ -16,5 +12,5 @@
 return NEW;
 end;
 $BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
+LANGUAGE plpgsql;
+

Modified: phpcompta/trunk/sql/trigger.tmp_pcmn.sql
===================================================================
--- phpcompta/trunk/sql/trigger.tmp_pcmn.sql    2011-11-22 22:31:40 UTC (rev 
4445)
+++ phpcompta/trunk/sql/trigger.tmp_pcmn.sql    2011-11-22 22:44:52 UTC (rev 
4446)
@@ -1,7 +1,3 @@
--- Trigger: t_tmp_pcm_alphanum_ins_upd on tmp_pcmn
-
--- DROP TRIGGER t_tmp_pcm_alphanum_ins_upd ON tmp_pcmn;
-
 CREATE TRIGGER t_tmp_pcm_alphanum_ins_upd
   BEFORE INSERT OR UPDATE
   ON tmp_pcmn

Modified: phpcompta/trunk/sql/tva.sql
===================================================================
--- phpcompta/trunk/sql/tva.sql 2011-11-22 22:31:40 UTC (rev 4445)
+++ phpcompta/trunk/sql/tva.sql 2011-11-22 22:44:52 UTC (rev 4446)
@@ -40,7 +40,7 @@
 return 0;
 end;
 $function$
- LANGUAGE plpgsql;
+LANGUAGE plpgsql;
 
 ----------------------------------------------------------------------
 -- TVA INSERT
@@ -82,4 +82,4 @@
 return 0;
 end;
 $function$
- LANGUAGE plpgsql;
+LANGUAGE plpgsql;