aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/ddl.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/ddl.sql')
-rw-r--r--src/main/resources/ddl.sql26
1 files changed, 0 insertions, 26 deletions
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;