wip

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)
 );