[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 01/01: Typo SQL
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 01/01: Typo SQL |
Date: |
Thu, 12 Nov 2015 23:26:33 +0000 |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 5fc71e8e2737894082c6372bc3da29eb251bc71f
Author: Dany De Bontridder <address@hidden>
Date: Fri Nov 13 00:20:15 2015 +0100
Typo SQL
---
include/sql/patch/upgrade121.sql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/include/sql/patch/upgrade121.sql b/include/sql/patch/upgrade121.sql
index 321deec..efcbc56 100644
--- a/include/sql/patch/upgrade121.sql
+++ b/include/sql/patch/upgrade121.sql
@@ -56,7 +56,7 @@ COMMENT ON TRIGGER profile_user_ins_upd ON profile_user IS
'Force the column use
delete from user_sec_jrn where uj_id in (select b.uj_id
from user_sec_jrn as a , user_sec_jrn as b
where
- upper(a.uj_login) = b.uj_login and a.uj_id<> b.uj_id and
a.uj_jrn_id=b.uj_jrn_id and b.uj_login=upper(b.uj_login);
+ upper(a.uj_login) = b.uj_login and a.uj_id<> b.uj_id and
a.uj_jrn_id=b.uj_jrn_id and b.uj_login=upper(b.uj_login));
update user_sec_jrn set uj_login = lower(uj_login);