diff options
Diffstat (limited to 'src/components/application_manager/src/resumption/resumption_sql_queries.cc')
-rw-r--r-- | src/components/application_manager/src/resumption/resumption_sql_queries.cc | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/components/application_manager/src/resumption/resumption_sql_queries.cc b/src/components/application_manager/src/resumption/resumption_sql_queries.cc index 67970fd0c8..1c1bcc3b35 100644 --- a/src/components/application_manager/src/resumption/resumption_sql_queries.cc +++ b/src/components/application_manager/src/resumption/resumption_sql_queries.cc @@ -39,6 +39,9 @@ const std::string kCreateSchema = " `idresumption` INTEGER PRIMARY KEY, " " `last_ign_off_time` INTEGER " " ); " + "CREATE TABLE IF NOT EXISTS `subscribedForWayPoints`( " + " `appID` INTEGER " + " ); " "CREATE TABLE IF NOT EXISTS `image`( " " `idimage` INTEGER PRIMARY KEY NOT NULL, " " `imageType` INTEGER, " @@ -316,6 +319,7 @@ const std::string kDropSchema = "DROP INDEX IF EXISTS " "`message.fk_message_consumer_friendly_messages1_idx`; " "DROP TABLE IF EXISTS `resumption`; " + "DROP TABLE IF EXISTS `subscribedForWayPoints`; " "DROP TABLE IF EXISTS `image`; " "DROP TABLE IF EXISTS `applicationChoiceSet`; " "DROP TABLE IF EXISTS `file`; " @@ -964,4 +968,13 @@ const std::string kUpdateGrammarID = "SET `grammarID` = ? " "WHERE `appID` = ? AND `deviceID` = ?;"; +const std::string kInsertSubscribedForWayPoints = + "INSERT INTO `subscribedForWayPoints` (`appID`) VALUES (?);"; + +const std::string kSelectSubscribedForWayPoints = + "SELECT `appID` FROM `subscribedForWayPoints`;"; + +const std::string kDeleteSubscribedForWayPoints = + "DELETE FROM `subscribedForWayPoints`;"; + } // namespace resumption |