X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=ves-agent%2Fsrc%2Fmain%2Fresources%2Fschema-mariadb.sql;fp=ves-agent%2Fsrc%2Fmain%2Fresources%2Fschema-mariadb.sql;h=3540aad39da1412ea7466022ab42e7d8481e2ad1;hb=641a6c47b4ee74412e9386b3c95693adda3cafc9;hp=0000000000000000000000000000000000000000;hpb=8c7432b8380a355e89df05f070e7d88e599912fd;p=oam%2Ftr069-adapter.git

diff --git a/ves-agent/src/main/resources/schema-mariadb.sql b/ves-agent/src/main/resources/schema-mariadb.sql
new file mode 100644
index 0000000..3540aad
--- /dev/null
+++ b/ves-agent/src/main/resources/schema-mariadb.sql
@@ -0,0 +1,15 @@
+
+CREATE TABLE IF NOT EXISTS ves_device_data 
+	(
+	ID bigint null,
+	DEVICE_ID varchar(30) not null,
+	ENODEB_NAME varchar(100),
+	OUI varchar(30),
+	PRODUCT_CLASS varchar(100),
+	ATTR_JSON varchar(4000),
+	ATTR_GROUP varchar(256) not null,
+	LAST_UPDATED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+	UNIQUE(DEVICE_ID,ATTR_GROUP)
+);
+
+