Removes non-primary RC groups processing from policy

1 files changed, 0 insertions, 45 deletions

diff --git a/src/components/policy/policy_external/src/sql_pt_queries.cc b/src/components/policy/policy_external/src/sql_pt_queries.cc
index 9f38b9aeaf..7919202cd1 100644
--- a/src/components/policy/policy_external/src/sql_pt_queries.cc
+++ b/src/components/policy/policy_external/src/sql_pt_queries.cc
@@ -370,26 +370,6 @@ const std::string kCreateSchema =
     "`app_group_primary.fk_application_has_functional_group_application1_idx` "
     "  ON `app_group_primary`(`application_id`); "
 
-    "CREATE TABLE IF NOT EXISTS `app_group_non_primary`( "
-    "  `application_id` VARCHAR(45) NOT NULL, "
-    "  `functional_group_id` INTEGER NOT NULL, "
-    "  PRIMARY KEY(`application_id`,`functional_group_id`), "
-    "  CONSTRAINT `fk_application_has_functional_group_application1` "
-    "    FOREIGN KEY(`application_id`) "
-    "    REFERENCES `application`(`id`), "
-    "  CONSTRAINT `fk_application_has_functional_group_functional_group1` "
-    "    FOREIGN KEY(`functional_group_id`) "
-    "    REFERENCES `functional_group`(`id`) "
-    "); "
-    "CREATE INDEX IF NOT EXISTS "
-    "`app_group_non_primary.fk_application_has_functional_group_functional_"
-    "group1_idx` "
-    "  ON `app_group_non_primary`(`functional_group_id`); "
-    "CREATE INDEX IF NOT EXISTS "
-    "`app_group_non_primary.fk_application_has_functional_group_application1_"
-    "idx` "
-    "  ON `app_group_non_primary`(`application_id`); "
-
     /* access_module */
     "CREATE TABLE `access_module`( "
     "  `id` INTEGER PRIMARY KEY NOT NULL, "
@@ -467,9 +447,6 @@ const std::string kInsertInitData =
 
 const std::string kDeleteAppGroupPrimary = "DELETE FROM `app_group_primary`";
 
-const std::string kDeleteAppGroupNonPrimary =
-    "DELETE FROM `app_group_non_primary`";
-
 const std::string kDeleteModuleTypes = "DELETE FROM `module_type`";
 
 const std::string kDeleteAllDevices = "DELETE FROM `device`;";
@@ -480,12 +457,6 @@ const std::string kSelectAppGroupsPrimary =
     "    ON (`f`.`id` = `a`.`functional_group_id`)"
     "  WHERE `a`.`application_id` = ?";
 
-const std::string kSelectAppGroupsNonPrimary =
-    "SELECT `f`.`name` FROM `app_group_non_primary` AS `a`"
-    "  LEFT JOIN `functional_group` AS `f` "
-    "    ON (`f`.`id` = `a`.`functional_group_id`)"
-    "  WHERE `a`.`application_id` = ?";
-
 const std::string kSelectRemoteControlDenied =
     "SELECT `remote_control_denied` FROM `application` WHERE `id` = ? LIMIT 1";
 
@@ -493,11 +464,6 @@ const std::string kInsertAppGroupPrimary =
     "INSERT INTO `app_group_primary` (`application_id`, `functional_group_id`)"
     "  SELECT ?, `id` FROM `functional_group` WHERE `name` = ? LIMIT 1";
 
-const std::string kInsertAppGroupNonPrimary =
-    "INSERT INTO `app_group_non_primary` (`application_id`, "
-    "`functional_group_id`)"
-    "  SELECT ?, `id` FROM `functional_group` WHERE `name` = ? LIMIT 1";
-
 const std::string kUpdateRemoteControlDenied =
     "UPDATE `application` SET `remote_control_denied` = ? WHERE `id` = ?";
 
@@ -512,9 +478,6 @@ const std::string kInsertAccessModule =
 const std::string kDeleteAppGroupPrimaryByApplicationId =
     "DELETE FROM `app_group_primary` WHERE `application_id` = ?";
 
-const std::string kDeleteAppGroupNonPrimaryByApplicationId =
-    "DELETE FROM `app_group_non_primary` WHERE `application_id` = ?";
-
 const std::string kSelectAccessModules =
     "SELECT `id`, `name` FROM `access_module` "
     "  WHERE `user_consent_needed` = ?";
@@ -579,13 +542,6 @@ const std::string kDropSchema =
     "`app_group_primary.fk_application_has_functional_group_functional_group1_"
     "idx`; "
     "DROP TABLE IF EXISTS `app_group_primary`; "
-    "DROP INDEX IF EXISTS "
-    "`app_group_non_primary.fk_application_has_functional_group_application1_"
-    "idx`; "
-    "DROP INDEX IF EXISTS "
-    "`app_group_non_primary.fk_application_has_functional_group_functional_"
-    "group1_idx`; "
-    "DROP TABLE IF EXISTS `app_group_non_primary`; "
     "DROP TABLE IF EXISTS `access_module`; "
     "DROP INDEX IF EXISTS `access_module.fk_module_1_idx`; "
     "DROP INDEX IF EXISTS "
@@ -638,7 +594,6 @@ const std::string kDeleteData =
     "DELETE FROM `application`; "
     "DELETE FROM `rpc`; "
     "DELETE FROM `app_group_primary`; "
-    "DELETE FROM `app_group_non_primary`; "
     "DELETE FROM `access_module`; "
     "DELETE FROM `version`; "
     "DELETE FROM `message_type`; "