| commit | author | age | ||
| 734b13 | 1 | create table app.sender |
| U | 2 | ( |
| 3 | sender_id int not null, | |
| 4 | sender_name varchar(1024) not null, | |
| 5 | sender_url varchar(1024), | |
| 6 | sender_logo varchar(1024), | |
| 7 | primary key (sender_id) | |
| 8 | ); | |
| 9 | create index sname on app.sender (sender_name); | |
| 87af61 | 10 | insert into app.sender (sender_id, sender_name, sender_url, sender_logo) values (1, 'hr info', 'http://hr-hrinfo-live.cast.addradio.de/hr/hrinfo/live/mp3/128/stream.mp3', '../bilder/hr-info.png'); |
| U | 11 | insert into app.sender (sender_id, sender_name, sender_url, sender_logo) values (2, 'radiobob', 'http://bob.hoerradar.de/radiobob-live-mp3-hq', '../bilder/radio-bob-logo-80.png'); |
| 12 | insert into app.sender (sender_id, sender_name, sender_url, sender_logo) values (3, 'hr3', 'http://mp3.ffh.de/radioffh/hqlivestream.mp3', '../bilder/hr3.png'); | |
| 13 | insert into app.sender (sender_id, sender_name, sender_url, sender_logo) values (4, 'ffh', 'http://mp3.ffh.de/radioffh/hqlivestream.mp3', '../bilder/ffh.svg'); | |
| 734b13 | 14 | |
| 40d4a4 | 15 | create table app.abspieler |
| U | 16 | ( |
| 17 | abs_id int not null, | |
| 18 | abs_name varchar(1024) not null, | |
| 19 | abs_url varchar(1024), | |
| 20 | abs_typ varchar(1024), | |
| 21 | abs_bild varchar(1024), | |
| 22 | abs_zustand varchar(1024), | |
| 5eee56 | 23 | primary key (abs_id) |
| 40d4a4 | 24 | ); |
| 52f455 | 25 | create index aname on app.abspieler (abs_name); |
| 40d4a4 | 26 | |
| 734b13 | 27 | create table app.keytable ( |
| 5d0e42 | 28 | key_name varchar(80) not null primary key, |
| U | 29 | key_next int |
| 30 | ); | |
| 734b13 | 31 | create index key_name_next ON app.keytable (key_name,key_next); |
| 87af61 | 32 | insert into app.keytable (key_name, key_next) values ('sender_id',5); |
| 40d4a4 | 33 | insert into app.keytable (key_name, key_next) values ('abs_id',1); |
