| commit | author | age | ||
| 314fea | 1 | <?xml version="1.0" encoding="UTF-8" standalone="no"?> |
| U | 2 | <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> |
| 3 | <properties> | |
| 4 | <comment> | |
| 5 | SQL-Kommandos der Anwendung Nutzerverwaltung | |
| 6 | </comment> | |
| 7 | <entry key="dbVorhanden"> | |
| 8 | select s.schemaname, t.tablename | |
| 9 | from SYS.SYSSCHEMAS as s, | |
| 10 | SYS.SYSTABLES as t | |
| 11 | where s.schemaid = t.schemaid | |
| 12 | and s.schemaname = 'APP' | |
| 8b423e | 13 | and t.tablename = 'USERS' |
| 314fea | 14 | </entry> |
| U | 15 | <entry key="incrementKey"> |
| 16 | update app.keytable | |
| 17 | set key_next = ? | |
| 18 | where key_name = ? | |
| 19 | and key_next = ? | |
| 20 | </entry> | |
| 21 | <entry key="getNextKey"> | |
| 22 | select key_next from | |
| 23 | app.keytable | |
| 24 | where key_name = ? | |
| 25 | </entry> | |
| 725d10 | 26 | <entry key="getUserNameList"> |
| ff2dff | 27 | select user_name from app.users |
| 725d10 | 28 | </entry> |
| U | 29 | <entry key="getUserList"> |
| 30 | select * from app.users | |
| 314fea | 31 | </entry> |
| 87e382 | 32 | <entry key="getRoleList"> |
| U | 33 | select distinct role_name from app.user_roles order by role_name |
| 34 | </entry> | |
| c79c12 | 35 | <entry key="getUserRoles"> |
| 51edf4 | 36 | select role_name from app.user_roles where user_name = ? order by role_name |
| c79c12 | 37 | </entry> |
| 4f4b29 | 38 | <entry key="deleteUserRoles"> |
| U | 39 | delete from app.user_roles where user_name = ? |
| 40 | </entry> | |
| 70a614 | 41 | <entry key="getUserData"> |
| U | 42 | select user_name,user_first,user_last,user_email from app.users where user_name = ? |
| 43 | </entry> | |
| 48a649 | 44 | <entry key="getUser"> |
| U | 45 | select * from app.users where user_name = ? |
| 46 | </entry> | |
| 314fea | 47 | <entry key="getDateList"> |
| U | 48 | select substr(or_zeit,1,8) as tag, count(*) as anz from app.orte as orte |
| 49 | where or_pers_id = ? | |
| 50 | and substr(or_zeit,1,8) like ? | |
| 51 | group by substr(or_zeit,1,8) | |
| 52 | </entry> | |
| 53 | </properties> | |
