| commit | author | age | ||
| 5eee56 | 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 radiozentrale | |
| 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' | |
| 13 | and t.tablename = 'SENDER' | |
| 14 | </entry> | |
| 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> | |
| 74f15b | 26 | <entry key="getSenderList"> |
| a0ec7b | 27 | select * from |
| U | 28 | app.sender |
| 29 | </entry> | |
| 74f15b | 30 | <entry key="getSender"> |
| U | 31 | select * from |
| 32 | app.sender | |
| 33 | where sender_id = ? | |
| 34 | </entry> | |
| 35 | <entry key="getAbspielerList"> | |
| b6585c | 36 | select * from |
| U | 37 | app.abspieler |
| 38 | </entry> | |
| 74f15b | 39 | <entry key="getAbspieler"> |
| U | 40 | select * from |
| 41 | app.abspieler | |
| 42 | where abs_id = ? | |
| 43 | </entry> | |
| 647739 | 44 | <entry key="unselectAbspieler"> |
| U | 45 | update app.abspieler |
| 46 | set abs_zustand = ? | |
| 47 | where abs_zustand = ? | |
| 48 | </entry> | |
| 5eee56 | 49 | </properties> |
