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 | 25 +++++++++++++------------
1 files changed, 13 insertions(+), 12 deletions(-)
diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
index 522f3b7..7aeb910 100644
--- a/web/WEB-INF/create_database.sql
+++ b/web/WEB-INF/create_database.sql
@@ -1,16 +1,17 @@
-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.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);
--
Gitblit v1.9.3