2018/Feb/28 -i állapot hozzáadva, mint a módosítások kiindulási állapota

1 files changed, 15 insertions, 0 deletions

diff --git a/mayor-orig/install/module-naplo/mysql/createAccount.txt b/mayor-orig/install/module-naplo/mysql/createAccount.txt
new file mode 100644
index 00000000..57b17ac5
--- /dev/null
+++ b/mayor-orig/install/module-naplo/mysql/createAccount.txt
@@ -0,0 +1,15 @@
+
+select
+        trim(concat_ws(' ',viseltNevElotag,viseltCsaladiNev,viseltUtonev)) as nev,
+	substring_index(substring(dn,5),',',1) as userAccount,
+	'1212' as jelszo,
+	substring_index(substring_index(dn,',ou=diak',1),'=',-1) as kategoria,
+	oId as studyId
+    from diak
+    where dn like '%ou=7b%'
+    into outfile '/tmp/7b.dat';
+
+select trim(concat_ws(' ',viseltNevElotag,viseltCsaladiNev,viseltUtonev)) as nev,
+substring_index(substring(dn,5),',',1) as userAccount, '1212' as jelszo,
+'diák' as kategoria, oId as studyId
+from diak where dn like '%ou=7b%' into outfile '/tmp/7b.dat';