From 98e5c644ded2497b030fab8e29f3a8b64c22441d Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Tue, 06 Mar 2018 07:02:45 +0000
Subject: [PATCH] Abspieler speichern gebaut
---
web/WEB-INF/create_database.sql | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index 7aeb910..8ba79ef 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -1,4 +1,3 @@
-
create table app.sender
(
sender_id int not null,
@@ -8,10 +7,27 @@
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',1);
+insert into app.keytable (key_name, key_next) values ('sender_id',5);
+insert into app.keytable (key_name, key_next) values ('abs_id',1);
\ No newline at end of file
--
Gitblit v1.9.3