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