From a5d72fe639cc72e86b0cdcd53ebb2a88e234c8a6 Mon Sep 17 00:00:00 2001
From: ulrich <undisclosed>
Date: Sun, 04 Feb 2018 11:43:10 +0000
Subject: [PATCH] DB-Skript begonnen

---
 web/WEB-INF/create_database.sql |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/web/WEB-INF/create_database.sql b/web/WEB-INF/create_database.sql
new file mode 100644
index 0000000..e037968
--- /dev/null
+++ b/web/WEB-INF/create_database.sql
@@ -0,0 +1,9 @@
+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);

--
Gitblit v1.9.3