diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-08 22:24:01 +0100 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-08 22:24:01 +0100 |
| commit | 2eae4836279646050e7e342752cde6e8f7c5b6cb (patch) | |
| tree | d768a8ec4ef09cf62a09f73c499ae5a17677287a /src/main/resources | |
| parent | ddbf5d1ac05d0f03f7cbe9275c303541cca945be (diff) | |
| download | esper-testing-2eae4836279646050e7e342752cde6e8f7c5b6cb.tar.gz esper-testing-2eae4836279646050e7e342752cde6e8f7c5b6cb.tar.bz2 esper-testing-2eae4836279646050e7e342752cde6e8f7c5b6cb.tar.xz esper-testing-2eae4836279646050e7e342752cde6e8f7c5b6cb.zip | |
wip
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/ddl.sql | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/src/main/resources/ddl.sql b/src/main/resources/ddl.sql index a8bec8f..6f213dc 100644 --- a/src/main/resources/ddl.sql +++ b/src/main/resources/ddl.sql @@ -1,6 +1,8 @@ BEGIN; DROP TABLE IF EXISTS gitorious_change; +DROP TABLE IF EXISTS gitorious_repository; +DROP TABLE IF EXISTS gitorious_project; DROP TABLE IF EXISTS atom_feed; CREATE TABLE atom_feed ( @@ -8,9 +10,16 @@ CREATE TABLE atom_feed ( last_update TIMESTAMP NOT NULL ); +CREATE TABLE gitorious_project ( + slug VARCHAR(1000) PRIMARY KEY +); + CREATE TABLE gitorious_repository ( - entry_id VARCHAR(1000) PRIMARY KEY, - text VARCHAR(1000) + project_slug VARCHAR(1000) NOT NULL, + name VARCHAR(1000) NOT NULL, + atom_feed VARCHAR(1000) NOT NULL, + 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_change ( |