Add database APIs to update device service payload info

[platform/core/connectivity/ua-manager.git] / ua-daemon / data / ua_db.sql

diff --git a/ua-daemon/data/ua_db.sql b/ua-daemon/data/ua_db.sql
index dac1447..c83282d 100644 (file)
--- a/ua-daemon/data/ua_db.sql
+++ b/ua-daemon/data/ua_db.sql
@@ -63,10 +63,12 @@ CREATE TABLE IF NOT EXISTS services (
 CREATE TABLE IF NOT EXISTS device_services (
   device_number INTEGER,
   service_number INTEGER,
+  payload_number INTEGER,
   discriminant INTEGER,
   last_seen LONG,
   FOREIGN KEY(device_number) REFERENCES devices(device_number),
   FOREIGN KEY(service_number) REFERENCES services(service_number),
+  FOREIGN KEY(payload_number) REFERENCES payloads(payload_number),
   PRIMARY KEY(device_number, service_number)
 );