Add database APIs to update device service payload info

[platform/core/connectivity/ua-manager.git] / ua-daemon / src / ua-manager-db.c

diff --git a/ua-daemon/src/ua-manager-db.c b/ua-daemon/src/ua-manager-db.c
index f4abfcc..de1a01d 100644 (file)
--- a/ua-daemon/src/ua-manager-db.c
+++ b/ua-daemon/src/ua-manager-db.c
@@ -77,10 +77,12 @@
 #define CREATE_DEVICE_SERVICES_TABLE "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) " \
        "); "