X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=config-data%2Fsrc%2Fmain%2Fresources%2Fschema-mariadb.sql;h=bcb1c85da79a3fa7d23078a4e00d22c5e7c13f81;hb=HEAD;hp=5f3606687e144df41ef892a350350f1550ed3799;hpb=a58ada8fd244e69cf2ebe48a251fcdd4d48acec4;p=oam%2Ftr069-adapter.git

diff --git a/config-data/src/main/resources/schema-mariadb.sql b/config-data/src/main/resources/schema-mariadb.sql
index 5f36066..bcb1c85 100644
--- 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 
-  (
-  macid varchar(255) not null,
-  file_content mediumtext not null,
-  primary key(macid)
-);
\ No newline at end of file
+	(
+	ID int null,
+	macid varchar(255) not null,
+	file_content mediumtext not null,
+	SW_VERSION varchar(64) not null,
+	HW_VERSION varchar(64) not null,
+	primary key(macid, SW_VERSION, HW_VERSION)
+);
+
+CREATE SEQUENCE IF NOT EXISTS hibernate_sequence MINVALUE 1 MAXVALUE 4611686018427387903 CYCLE CACHE 10;
\ No newline at end of file