From a742500840276ec694a6d25230ee52c05b385661 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Fri, 9 Nov 2012 15:26:55 +0100
Subject: wip

---
 src/main/resources/ddl-core.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 src/main/resources/ddl-core.sql

(limited to 'src/main/resources/ddl-core.sql')

diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql
new file mode 100644
index 0000000..662ed10
--- /dev/null
+++ b/src/main/resources/ddl-core.sql
@@ -0,0 +1,20 @@
+BEGIN;
+
+DROP TABLE IF EXISTS subscription_gitorious_repository;
+DROP TABLE IF EXISTS subscriber;
+
+CREATE TABLE subscriber (
+  name VARCHAR(100) PRIMARY KEY
+);
+
+CREATE TABLE subscription_gitorious_repository (
+  subscriber_name                   VARCHAR(100) REFERENCES subscriber (name),
+  gitorious_repository_project_slug VARCHAR(100),
+  gitorious_repository_name         VARCHAR(100)
+--   CONSTRAINT subscription_gitorious_repository_2_gitorious_repository FOREIGN KEY (gitorious_repository_project_slug, gitorious_repository_name) REFERENCES gitorious_repository (project_slug, name)
+);
+
+INSERT INTO subscriber VALUES ('trygvis');
+INSERT INTO subscription_gitorious_repository VALUES ('trygvis','esper-test-project', 'esper-test-project');
+
+COMMIT;
-- 
cgit v1.2.3