From 70595c41ce404ca68aaa6d1b531c6a858492553b Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sun, 23 Dec 2012 23:55:05 +0100
Subject: o Adding Apache Shiro for security.

---
 src/main/resources/ddl-core.sql | 11 +----------
 src/main/resources/ddl-file.sql | 14 ++++++++++++++
 src/main/resources/logback.xml  |  2 ++
 3 files changed, 17 insertions(+), 10 deletions(-)
 create mode 100644 src/main/resources/ddl-file.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql
index 376ca9f..b145438 100644
--- a/src/main/resources/ddl-core.sql
+++ b/src/main/resources/ddl-core.sql
@@ -8,16 +8,6 @@ DROP TABLE IF EXISTS person_badge;
 DROP TABLE IF EXISTS person_jenkins_user;
 DROP TABLE IF EXISTS person;
 DROP TABLE IF EXISTS table_poller_status;
-DROP TABLE IF EXISTS file;
-
-CREATE TABLE file (
-  uuid         CHAR(36)      NOT NULL,
-  created_date TIMESTAMP     NOT NULL,
-  url          VARCHAR(1000) NOT NULL,
-  content_type VARCHAR(100)  NOT NULL,
-  data         BYTEA,
-  CONSTRAINT pk_file PRIMARY KEY (uuid)
-);
 
 CREATE TABLE table_poller_status (
   poller_name VARCHAR(100) NOT NULL,
@@ -32,6 +22,7 @@ CREATE TABLE person (
   uuid         CHAR(36)  NOT NULL,
   created_date TIMESTAMP NOT NULL,
   name         VARCHAR(100),
+  mail         VARCHAR(100),
   CONSTRAINT pk_person PRIMARY KEY (uuid)
 );
 
diff --git a/src/main/resources/ddl-file.sql b/src/main/resources/ddl-file.sql
new file mode 100644
index 0000000..99e8bf6
--- /dev/null
+++ b/src/main/resources/ddl-file.sql
@@ -0,0 +1,14 @@
+BEGIN;
+
+DROP TABLE IF EXISTS file;
+
+CREATE TABLE file (
+  uuid         CHAR(36)      NOT NULL,
+  created_date TIMESTAMP     NOT NULL,
+  url          VARCHAR(1000) NOT NULL,
+  content_type VARCHAR(100)  NOT NULL,
+  data         BYTEA,
+  CONSTRAINT pk_file PRIMARY KEY (uuid)
+);
+
+COMMIT;
diff --git a/src/main/resources/logback.xml b/src/main/resources/logback.xml
index 1a63a5f..1f6becf 100644
--- a/src/main/resources/logback.xml
+++ b/src/main/resources/logback.xml
@@ -14,6 +14,8 @@
 
   <logger name="io.trygvis.esper.testing.util.HttpClient" level="INFO"/>
 
+  <logger name="org.apache.shiro" level="DEBGU"/>
+
   <root level="INFO">
     <appender-ref ref="STDOUT"/>
   </root>
-- 
cgit v1.2.3