From a742500840276ec694a6d25230ee52c05b385661 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Fri, 9 Nov 2012 15:26:55 +0100 Subject: wip --- src/main/resources/ddl-core.sql | 20 +++++++++++++++++ src/main/resources/ddl-gitorious.sql | 43 ++++++++++++++++++++++++++++++++++++ src/main/resources/ddl.sql | 26 ---------------------- 3 files changed, 63 insertions(+), 26 deletions(-) create mode 100644 src/main/resources/ddl-core.sql create mode 100644 src/main/resources/ddl-gitorious.sql delete mode 100644 src/main/resources/ddl.sql (limited to 'src/main/resources') 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; diff --git a/src/main/resources/ddl-gitorious.sql b/src/main/resources/ddl-gitorious.sql new file mode 100644 index 0000000..929a326 --- /dev/null +++ b/src/main/resources/ddl-gitorious.sql @@ -0,0 +1,43 @@ +BEGIN; + +DROP TABLE IF EXISTS gitorious_event; +DROP TABLE IF EXISTS gitorious_repository; +DROP TABLE IF EXISTS gitorious_project; + +CREATE TABLE gitorious_project ( + slug VARCHAR(1000) PRIMARY KEY +); + +CREATE TABLE gitorious_repository ( + project_slug VARCHAR(1000) NOT NULL, + name VARCHAR(1000) NOT NULL, + atom_feed VARCHAR(1000) NOT NULL, + last_update TIMESTAMP, + last_successful_update TIMESTAMP, + CONSTRAINT gitorious_repository_pk PRIMARY KEY (project_slug, name), + CONSTRAINT gitorious_repository_2_gitorious_project FOREIGN KEY (project_slug) REFERENCES gitorious_project (slug) +); + +CREATE TABLE gitorious_event ( + project_slug VARCHAR(1000) NOT NULL, + name VARCHAR(1000) NOT NULL, + +-- The raw values for debugging + entry_id VARCHAR(1000) PRIMARY KEY, + published TIMESTAMP NOT NULL, + title VARCHAR(1000), + content VARCHAR(1000), + + event_type VARCHAR(20), + who VARCHAR(100), +-- Push + "from" CHAR(40), + "to" CHAR(40), + branch VARCHAR(100), + commit_count INTEGER +); + +INSERT INTO gitorious_project VALUES ('esper-test-project'); +INSERT INTO gitorious_repository VALUES ('esper-test-project', 'esper-test-project', 'https://gitorious.org/esper-test-project/esper-test-project.atom'); + +COMMIT; diff --git a/src/main/resources/ddl.sql b/src/main/resources/ddl.sql deleted file mode 100644 index 4e641cc..0000000 --- a/src/main/resources/ddl.sql +++ /dev/null @@ -1,26 +0,0 @@ -BEGIN; - -DROP TABLE IF EXISTS gitorious_event; -DROP TABLE IF EXISTS gitorious_repository; -DROP TABLE IF EXISTS gitorious_project; - -CREATE TABLE gitorious_project ( - slug VARCHAR(1000) PRIMARY KEY -); - -CREATE TABLE gitorious_repository ( - project_slug VARCHAR(1000) NOT NULL, - name VARCHAR(1000) NOT NULL, - atom_feed VARCHAR(1000) NOT NULL, - last_update TIMESTAMP, - last_successful_update TIMESTAMP, - CONSTRAINT gitorious_repository_pk PRIMARY KEY (project_slug, name), - CONSTRAINT gitorious_repository_2_gitorious_project FOREIGN KEY (project_slug) REFERENCES gitorious_project (slug) -); - -CREATE TABLE gitorious_event ( - entry_id VARCHAR(1000) PRIMARY KEY, - text VARCHAR(1000) -); - -COMMIT; -- cgit v1.2.3