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=9634210c216f4f5065e8c5fbe870bbe2aa1c3a00;hpb=641a6c47b4ee74412e9386b3c95693adda3cafc9;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 9634210..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 
 	(
+	ID int null,
 	macid varchar(255) not null,
 	file_content mediumtext not null,
-	primary key(macid)
-);
\ No newline at end of file
+	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