diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-09 15:26:55 +0100 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-09 15:26:55 +0100 |
commit | a742500840276ec694a6d25230ee52c05b385661 (patch) | |
tree | b02eebec6f385efa057feea15a17112e1f97e0d4 /src/main/resources/ddl-gitorious.sql | |
parent | 8b3db6ef6307191609d2dab837032db16aa13375 (diff) | |
download | esper-testing-a742500840276ec694a6d25230ee52c05b385661.tar.gz esper-testing-a742500840276ec694a6d25230ee52c05b385661.tar.bz2 esper-testing-a742500840276ec694a6d25230ee52c05b385661.tar.xz esper-testing-a742500840276ec694a6d25230ee52c05b385661.zip |
wip
Diffstat (limited to 'src/main/resources/ddl-gitorious.sql')
-rw-r--r-- | src/main/resources/ddl-gitorious.sql | 43 |
1 files changed, 43 insertions, 0 deletions
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; |