From 876532ae51534cf9e40fd4871542e6bb9cd82d3d Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Sat, 24 Feb 2018 19:00:09 +0000
Subject: [PATCH] Alle Bestandteile der Grundkonfiguration einer Datenbank-App mitsamt initialer Datenbank-Erstellung fertiggestellt
---
web/WEB-INF/create_database.sql | 38 ++++++++++++++++++++++++++------------
1 files changed, 26 insertions(+), 12 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index 522f3b7..d1dfd5e 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -1,16 +1,30 @@
-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);
-create table APP.keytable (
+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);
+
+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);
+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