From 734b13c1c31fd6e8adec87ce9446a2972cc755c0 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Sun, 04 Feb 2018 12:02:56 +0000
Subject: [PATCH] DB-Skript in Arbeit
---
web/WEB-INF/create_database.sql | 22 +++++++++++++++-------
1 files changed, 15 insertions(+), 7 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index e037968..7aeb910 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -1,9 +1,17 @@
-CREATE TABLE APP.SENDER
+
+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)
+ 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 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);
--
Gitblit v1.9.3