X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=extra%2Fsql%2Fbulkload%2Fcreate-tables.sql;h=819d92591214d1378f65ba394dc104c113b99636;hb=81c1344c018e995e4f6f906435d0faab3480e13b;hp=1032765019f9525ad3b87f650e8b4cc63ef5d530;hpb=8d91398da6162c19643f3f7cae83327dd4e81263;p=clamp.git

diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 10327650..819d9259 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -62,6 +62,7 @@
         dcae_blueprint_id varchar(255),
         maximum_instances_allowed integer,
         svg_representation MEDIUMTEXT,
+        unique_blueprint boolean default false,
         service_uuid varchar(255),
         primary key (name)
     ) engine=InnoDB;
@@ -84,7 +85,7 @@
         global_properties_json json,
         last_computed_state varchar(255) not null,
         svg_representation MEDIUMTEXT,
-        loop_template_name varchar(255),
+        loop_template_name varchar(255) not null,
         service_uuid varchar(255),
         primary key (name)
     ) engine=InnoDB;