<?xml version="1.0" encoding="UTF-8" standalone="no"?>
|
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
|
<properties>
|
<comment>
|
SQL-Kommandos der Anwendung Nutzerverwaltung
|
</comment>
|
<entry key="dbVorhanden">
|
select s.schemaname, t.tablename
|
from SYS.SYSSCHEMAS as s,
|
SYS.SYSTABLES as t
|
where s.schemaid = t.schemaid
|
and s.schemaname = 'APP'
|
and t.tablename = 'USERS'
|
</entry>
|
<entry key="incrementKey">
|
update app.keytable
|
set key_next = ?
|
where key_name = ?
|
and key_next = ?
|
</entry>
|
<entry key="getNextKey">
|
select key_next from
|
app.keytable
|
where key_name = ?
|
</entry>
|
<entry key="getUserNameList">
|
select user_name from app.users
|
</entry>
|
<entry key="getUserList">
|
select * from app.users
|
</entry>
|
<entry key="getRoleList">
|
select distinct role_name from app.user_roles order by role_name
|
</entry>
|
<entry key="getUserRoles">
|
select role_name from app.user_roles where user_name = ? order by role_name
|
</entry>
|
<entry key="deleteUserRoles">
|
delete from app.user_roles where user_name = ?
|
</entry>
|
<entry key="getUserData">
|
select user_name,user_first,user_last,user_email from app.users where user_name = ?
|
</entry>
|
<entry key="getUser">
|
select * from app.users where user_name = ?
|
</entry>
|
<entry key="getDateList">
|
select substr(or_zeit,1,8) as tag, count(*) as anz from app.orte as orte
|
where or_pers_id = ?
|
and substr(or_zeit,1,8) like ?
|
group by substr(or_zeit,1,8)
|
</entry>
|
</properties>
|
