diff options
Diffstat (limited to 'src/main/resources/ddl-gitorious.sql')
-rw-r--r-- | src/main/resources/ddl-gitorious.sql | 40 |
1 files changed, 0 insertions, 40 deletions
diff --git a/src/main/resources/ddl-gitorious.sql b/src/main/resources/ddl-gitorious.sql deleted file mode 100644 index 121a4ff..0000000 --- a/src/main/resources/ddl-gitorious.sql +++ /dev/null @@ -1,40 +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 ( - 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 -); - -COMMIT; |