2 files changed, 41 insertions, 3 deletions
diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql
index fb85585..25f373b 100644
--- a/src/main/resources/ddl-core.sql
+++ b/src/main/resources/ddl-core.sql
@@ -1,5 +1,13 @@
 BEGIN;
 
+DROP TABLE IF EXISTS build_participant;
+DROP TABLE IF EXISTS build;
+DROP TABLE IF EXISTS person_badge_progress;
+DROP TABLE IF EXISTS person_badge;
+DROP TABLE IF EXISTS person_jenkins_user;
+DROP TABLE IF EXISTS person;
+DROP TABLE IF EXISTS table_poller_status;
+
 CREATE TABLE table_poller_status (
   poller_name       VARCHAR(100) NOT NULL,
   last_created_date TIMESTAMP,
@@ -12,11 +20,19 @@ CREATE TABLE table_poller_status (
 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) [],
+  name          VARCHAR(100),
   CONSTRAINT pk_person PRIMARY KEY (uuid)
 );
 
+--The users from the different jenkins servers this user has claimed
+CREATE TABLE person_jenkins_user (
+  person       CHAR(36),
+  jenkins_user CHAR(36),
+  CONSTRAINT pk_person_jenkins_user PRIMARY KEY (person, jenkins_user),
+  CONSTRAINT fk_person_jenkins_user__person FOREIGN KEY (person) REFERENCES person (uuid),
+  CONSTRAINT fk_person_jenkins_user__jenkins_user FOREIGN KEY (jenkins_user) REFERENCES jenkins_user (uuid)
+);
+
 -- Badges received
 CREATE TABLE person_badge (
   uuid         CHAR(36)  NOT NULL,
@@ -34,4 +50,25 @@ CREATE TABLE person_badge_progress (
   CONSTRAINT pk_person_badge_progress PRIMARY KEY (uuid)
 );
 
+CREATE TABLE build (
+  uuid           CHAR(36)     NOT NULL,
+  created_date   TIMESTAMP    NOT NULL,
+
+  timestamp      TIMESTAMP    NOT NULL,
+  success        BOOL         NOT NULL,
+
+  reference_type VARCHAR(100) NOT NULL,
+  reference_uuid CHAR(36)     NOT NULL,
+
+  CONSTRAINT pk_build PRIMARY KEY (uuid)
+);
+
+CREATE TABLE build_participant (
+  build  CHAR(36) NOT NULL,
+  person CHAR(36) NOT NULL,
+  CONSTRAINT pk_build_participant PRIMARY KEY (build, person),
+  CONSTRAINT fk_build_participant_build FOREIGN KEY (build) REFERENCES build (uuid),
+  CONSTRAINT fk_build_participant_person FOREIGN KEY (person) REFERENCES person (uuid)
+);
+
 COMMIT;
diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql
index 45de998..bdda74b 100644
--- a/src/main/resources/ddl-jenkins.sql
+++ b/src/main/resources/ddl-jenkins.sql
@@ -62,6 +62,7 @@ CREATE TABLE jenkins_user (
 INSERT INTO jenkins_server (uuid, created_date, url, enabled) VALUES
 ('782a75f6-40a4-11e2-aca6-20cf30557fa0', CURRENT_TIMESTAMP, 'https://builds.apache.org', FALSE),
 ('4c473c86-40ad-11e2-ae61-20cf30557fa0', CURRENT_TIMESTAMP, 'http://ci.jruby.org', FALSE),
-('518c6162-411b-11e2-b63c-20cf30557fa0', CURRENT_TIMESTAMP, 'http://www.simantics.org/jenkins', FALSE);
+('518c6162-411b-11e2-b63c-20cf30557fa0', CURRENT_TIMESTAMP, 'http://www.simantics.org/jenkins', FALSE),
+('3c1a1448-422c-11e2-a7b3-20cf30557fa0', CURRENT_TIMESTAMP, 'https://jenkins.puppetlabs.com', FALSE);
 
 COMMIT;