From 897a3e004a858ef68d989dad15dde91a69e151a5 Mon Sep 17 00:00:00 2001
From: sebdet <sebastien.determe@intl.att.com>
Date: Fri, 28 Feb 2020 06:03:51 -0800
Subject: Change json representation in op policy

Change the json generation for an operational policy instance and update all emulator response for all policy types

Issue-ID: CLAMP-653

Change-Id: I68525be3d5bfbf5dd7a4bcf6d59853df07fd4dd9
Signed-off-by: sebdet <sebastien.determe@intl.att.com>
---
 extra/sql/bulkload/create-tables.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'extra/sql/bulkload/create-tables.sql')

diff --git a/extra/sql/bulkload/create-tables.sql b/extra/sql/bulkload/create-tables.sql
index 2a7f4c1c..b4c5bf30 100644
--- a/extra/sql/bulkload/create-tables.sql
+++ b/extra/sql/bulkload/create-tables.sql
@@ -143,9 +143,9 @@
         pdp_group varchar(255),
         pdp_sub_group varchar(255),
         loop_element_model_id varchar(255),
-        loop_id varchar(255) not null,
         policy_model_type varchar(255),
         policy_model_version varchar(255),
+        loop_id varchar(255) not null,
         primary key (name)
     ) engine=InnoDB;
 
@@ -246,12 +246,12 @@
        foreign key (loop_element_model_id) 
        references loop_element_models (name);
 
-    alter table operational_policies 
-       add constraint FK1ddoggk9ni2bnqighv6ecmuwu 
-       foreign key (loop_id) 
-       references loops (name);
-
     alter table operational_policies 
        add constraint FKlsyhfkoqvkwj78ofepxhoctip 
        foreign key (policy_model_type, policy_model_version) 
        references policy_models (policy_model_type, version);
+
+    alter table operational_policies 
+       add constraint FK1ddoggk9ni2bnqighv6ecmuwu 
+       foreign key (loop_id) 
+       references loops (name);
-- 
cgit 

