From 40d4a40cbfda7439e50dc2f37b7ab90b5876c1f2 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Fri, 23 Feb 2018 07:56:14 +0000
Subject: [PATCH] Einstellungen fuer die Datenbank-Konfiguration ergaenzt
---
web/WEB-INF/create_database.sql | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index 7aeb910..9e596d0 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -9,9 +9,22 @@
);
create index sname on app.sender (sender_name);
+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 (sender_id)
+);
+create index sname on app.sender (sender_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 ('abs_id',1);
\ No newline at end of file
--
Gitblit v1.9.3