Device Software version management

[oam/tr069-adapter.git] / config-data / src / main / resources / schema-mariadb.sql

diff --git a/config-data/src/main/resources/schema-mariadb.sql b/config-data/src/main/resources/schema-mariadb.sql
index 9634210..bcb1c85 100644 (file)
--- a/config-data/src/main/resources/schema-mariadb.sql
+++ b/config-data/src/main/resources/schema-mariadb.sql
@@ -1,6 +1,11 @@
 CREATE TABLE IF NOT EXISTS config_file_content \r
        (\r
+       ID int null,\r
        macid varchar(255) not null,\r
        file_content mediumtext not null,\r
-       primary key(macid)\r
-);
\ No newline at end of file
+       SW_VERSION varchar(64) not null,\r
+       HW_VERSION varchar(64) not null,\r
+       primary key(macid, SW_VERSION, HW_VERSION)\r
+);\r
+\r
+CREATE SEQUENCE IF NOT EXISTS hibernate_sequence MINVALUE 1 MAXVALUE 4611686018427387903 CYCLE CACHE 10;
\ No newline at end of file