diff options
Diffstat (limited to 'src/main/resources/ddl-core.sql')
-rw-r--r-- | src/main/resources/ddl-core.sql | 20 |
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; |