wip

1 files changed, 20 insertions, 0 deletions

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;