X-Git-Url: https://gerrit.akraino.org/r/gitweb?p=validation.git;a=blobdiff_plain;f=ui%2Fdb-scripts%2Fakraino_blueprint_validation_db.sql;fp=ui%2Fdb-scripts%2Fakraino_blueprint_validation_db.sql;h=06aa4a85f92387c97b55e6431c7ae24c3243d3c6;hp=0000000000000000000000000000000000000000;hb=b39e27ede8238ef63440810a8327b927c4c43ac0;hpb=088e841f4b5e1aba5469720033072e36c9679419

diff --git a/ui/db-scripts/akraino_blueprint_validation_db.sql b/ui/db-scripts/akraino_blueprint_validation_db.sql
new file mode 100644
index 0000000..06aa4a8
--- /dev/null
+++ b/ui/db-scripts/akraino_blueprint_validation_db.sql
@@ -0,0 +1,92 @@
+/*
+ * Copyright (c) 2019 AT&T Intellectual Property. All rights reserved.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *        http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+SET FOREIGN_KEY_CHECKS=1;
+
+use akraino;
+
+DROP TABLE IF EXISTS submission;
+DROP TABLE IF EXISTS blueprint_instance_for_validation;
+DROP TABLE IF EXISTS blueprint;
+DROP TABLE IF EXISTS silo;
+DROP TABLE IF EXISTS timeslot;
+DROP TABLE IF EXISTS lab;
+
+create table lab (
+   id bigint not NULL AUTO_INCREMENT,
+   lab text not NULL,
+   CONSTRAINT id_pk PRIMARY KEY (id)
+);
+
+create table timeslot (
+   id bigint not NULL AUTO_INCREMENT,
+   start_date_time text,
+   duration text,
+   lab_id bigint not NULL,
+   CONSTRAINT id_pk PRIMARY KEY (id),
+   CONSTRAINT lab_id_fk FOREIGN KEY (lab_id)
+      REFERENCES lab (id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+
+create table silo (
+   id bigint not NULL AUTO_INCREMENT,
+   silo text not NULL,
+   lab_id bigint not NULL,
+   CONSTRAINT id_pk PRIMARY KEY (id),
+   CONSTRAINT lab_id_fk2 FOREIGN KEY (lab_id)
+      REFERENCES lab (id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+
+CREATE TABLE blueprint
+(
+   id bigint not NULL AUTO_INCREMENT,
+   blueprint_name varchar(20) not NULL unique,
+   CONSTRAINT id_pk PRIMARY KEY (id)
+);
+
+CREATE TABLE blueprint_instance_for_validation
+(
+   id bigint not NULL AUTO_INCREMENT,
+   blueprint_id bigint not NULL,
+   version text not NULL,
+   layer text not NULL,
+   layer_description text not NULL,
+   CONSTRAINT id_pk PRIMARY KEY (id),
+   CONSTRAINT blueprint_id_fk FOREIGN KEY (blueprint_id)
+      REFERENCES blueprint (id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+
+CREATE TABLE submission
+(
+   id bigint not NULL AUTO_INCREMENT,
+   status text not NULL,
+   jenkins_queue_job_item_url text,
+   nexus_result_url text,
+   blueprint_instance_for_validation_id bigint not NULL,
+   timeslot_id bigint not NULL,
+   CONSTRAINT id_pk PRIMARY KEY (id),
+   CONSTRAINT blueprint_instance_for_validation_id_fk FOREIGN KEY (blueprint_instance_for_validation_id)
+      REFERENCES blueprint_instance_for_validation (id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION,
+   CONSTRAINT timeslot_id_fk FOREIGN KEY (timeslot_id)
+      REFERENCES timeslot (id) MATCH SIMPLE
+      ON UPDATE NO ACTION ON DELETE NO ACTION
+);
+
+commit;