From 24036ef94687300e98c742cfc268a2b5e9e87a88 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sat, 5 Jan 2013 17:24:07 +0100
Subject: o Trying out dbdeploy.

---
 src/main/sql/base-schema/ddl-file.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 src/main/sql/base-schema/ddl-file.sql

(limited to 'src/main/sql/base-schema/ddl-file.sql')

diff --git a/src/main/sql/base-schema/ddl-file.sql b/src/main/sql/base-schema/ddl-file.sql
new file mode 100644
index 0000000..99e8bf6
--- /dev/null
+++ b/src/main/sql/base-schema/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;
-- 
cgit v1.2.3

