From 5d0e42c9453df03253a110a8c05766ad4a768d7b Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Sun, 04 Feb 2018 11:51:07 +0000
Subject: [PATCH] DB-Skript in Arbeit
---
web/WEB-INF/create_database.sql | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index e037968..522f3b7 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -7,3 +7,10 @@
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);
--
Gitblit v1.9.3