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.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/main/resources/ddl.sql b/src/main/resources/ddl.sql
index 6f213dc..279e544 100644
--- a/src/main/resources/ddl.sql
+++ b/src/main/resources/ddl.sql
@@ -1,6 +1,6 @@
BEGIN;
-DROP TABLE IF EXISTS gitorious_change;
+DROP TABLE IF EXISTS gitorious_event;
DROP TABLE IF EXISTS gitorious_repository;
DROP TABLE IF EXISTS gitorious_project;
DROP TABLE IF EXISTS atom_feed;
@@ -11,18 +11,18 @@ CREATE TABLE atom_feed (
);
CREATE TABLE gitorious_project (
- slug VARCHAR(1000) PRIMARY KEY
+ slug VARCHAR(1000) PRIMARY KEY,
+ atom_feed VARCHAR(1000) NOT NULL
);
CREATE TABLE gitorious_repository (
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 (
+CREATE TABLE gitorious_event (
entry_id VARCHAR(1000) PRIMARY KEY,
text VARCHAR(1000)
);