1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
| create table app.sender
| (
| sender_id int not null,
| sender_name varchar(1024) not null,
| sender_url varchar(1024),
| sender_logo varchar(1024),
| primary key (sender_id)
| );
| create index sname on app.sender (sender_name);
| 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');
| 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');
| 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');
| 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');
|
| create table app.abspieler
| (
| abs_id int not null,
| abs_name varchar(1024) not null,
| abs_url varchar(1024),
| abs_typ varchar(1024),
| abs_bild varchar(1024),
| abs_zustand varchar(1024),
| primary key (abs_id)
| );
| create index aname on app.abspieler (abs_name);
|
| create table app.keytable (
| key_name varchar(80) not null primary key,
| key_next int
| );
| create index key_name_next ON app.keytable (key_name,key_next);
| insert into app.keytable (key_name, key_next) values ('sender_id',5);
| insert into app.keytable (key_name, key_next) values ('abs_id',1);
|
|
