[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 12/16: force login user to lower case for ACT
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 12/16: force login user to lower case for ACTION_GESTION |
Date: |
Tue, 20 Oct 2015 14:26:34 +0000 |
sparkyx pushed a commit to branch master
in repository noalyss.
commit bf2f4fa0891836c04dd18733209ce3720a860003
Author: Dany De Bontridder <address@hidden>
Date: Tue Oct 20 11:46:57 2015 +0200
force login user to lower case for ACTION_GESTION
---
sql/upgrade.sql | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 9fcce26..870dac2 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -165,4 +165,16 @@ CREATE TRIGGER todo_list_shared_ins_upd
ON todo_list_shared
FOR EACH ROW
EXECUTE PROCEDURE comptaproc.trg_todo_list_shared_ins_upd();
-COMMENT ON TRIGGER todo_list_shared_ins_upd ON todo_list_shared IS 'Force the
column ua_login to lowercase';
\ No newline at end of file
+COMMENT ON TRIGGER todo_list_shared_ins_upd ON todo_list_shared IS 'Force the
column ua_login to lowercase';
+
+CREATE OR REPLACE FUNCTION comptaproc.action_gestion_ins_upd()
+ RETURNS trigger AS
+$BODY$
+begin
+NEW.ag_title := substr(trim(NEW.ag_title),1,70);
+NEW.ag_hour := substr(trim(NEW.ag_hour),1,5);
+NEW.ag_owner := lower(NEW.ag_owner);
+return NEW;
+end;
+$BODY$
+LANGUAGE plpgsql;
- [Noalyss-commit] [noalyss] 01/16: Move Admin_repo to include , add setup.php for redirecting Move user_menu to include/lib, (continued)
- [Noalyss-commit] [noalyss] 01/16: Move Admin_repo to include , add setup.php for redirecting Move user_menu to include/lib, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 06/16: System information : display variable from config.inc.php, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 08/16: Administration : add information about system update all the databases + account_repository, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 11/16: Force the login in lower case in table where it is used, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 09/16: System information : display variable from config.inc.php, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 07/16: Administration : add information about system update all the databases + account_repository, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 04/16: Restructure file , remove html/admin/sql , backup ..., Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 10/16: Administration : update MULTI, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 14/16: remove obsolete file, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 15/16: Improve installation system, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 12/16: force login user to lower case for ACTION_GESTION,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 03/16: Restructure file , remove html/admin , backup ..., Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 16/16: Remove admin folder and use another system installation, it is now possible to upgrade DB thanks the administration page, Dany De Bontridder, 2015/10/20
- [Noalyss-commit] [noalyss] 13/16: Improve installation system, Dany De Bontridder, 2015/10/20