1 files changed, 29 insertions, 9 deletions
diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql
index 8201c31..fb85585 100644
--- a/src/main/resources/ddl-core.sql
+++ b/src/main/resources/ddl-core.sql
@@ -1,17 +1,37 @@
 BEGIN;
 
-DROP TABLE IF EXISTS subscription_gitorious_repository;
-DROP TABLE IF EXISTS subscriber;
+CREATE TABLE table_poller_status (
+  poller_name       VARCHAR(100) NOT NULL,
+  last_created_date TIMESTAMP,
+  last_run          TIMESTAMP,
+  duration          INT,
+  status            VARCHAR(1000),
+  CONSTRAINT pk_job_status PRIMARY KEY (poller_name)
+);
+
+CREATE TABLE person (
+  uuid          CHAR(36)  NOT NULL,
+  created_date  TIMESTAMP NOT NULL,
+--The users from the different jenkins servers this user has claimed
+  jenkins_users CHAR(36) [],
+  CONSTRAINT pk_person PRIMARY KEY (uuid)
+);
 
-CREATE TABLE subscriber (
-  name VARCHAR(100) PRIMARY KEY
+-- Badges received
+CREATE TABLE person_badge (
+  uuid         CHAR(36)  NOT NULL,
+  created_date TIMESTAMP NOT NULL,
+  CONSTRAINT pk_person_badge PRIMARY KEY (uuid)
 );
 
-CREATE TABLE subscription_gitorious_repository (
-  subscriber_name                   VARCHAR(100) REFERENCES subscriber (name),
-  gitorious_repository_project_slug VARCHAR(100),
-  gitorious_repository_name         VARCHAR(100),
-  CONSTRAINT gitorious_repository FOREIGN KEY (gitorious_repository_project_slug, gitorious_repository_name) REFERENCES gitorious_repository (project_slug, name)
+-- Badges the person is working on
+CREATE TABLE person_badge_progress (
+  uuid         CHAR(36)     NOT NULL,
+  created_date TIMESTAMP    NOT NULL,
+
+  name         VARCHAR(100) NOT NULL,
+
+  CONSTRAINT pk_person_badge_progress PRIMARY KEY (uuid)
 );
 
 COMMIT;