VES Heartbeat and Software Management Feature

[oam/tr069-adapter.git] / acs / application-booter / src / main / resources / schema-mariadb.sql

diff --git a/acs/application-booter/src/main/resources/schema-mariadb.sql b/acs/application-booter/src/main/resources/schema-mariadb.sql
index 664cb66..f39500d 100644 (file)
--- a/acs/application-booter/src/main/resources/schema-mariadb.sql
+++ b/acs/application-booter/src/main/resources/schema-mariadb.sql
@@ -1,40 +1,40 @@
 -- ACS Module related tables - START\r
 \r
 CREATE TABLE IF NOT EXISTS tr069_device \r
-  (\r
-  ID int null,\r
-  DEVICE_ID varchar(30) not null,\r
-  USER_NAME varchar(256),\r
-  PASSWORD varchar(256),\r
-  SW_VERSION varchar(20),\r
-  HW_VERSION varchar(20),\r
-  CONNECTION_REQUEST_URL varchar(1024),\r
-  LAST_UPDATED_TIME Timestamp\r
+       (\r
+       ID int null,\r
+       DEVICE_ID varchar(30) not null,\r
+       USER_NAME varchar(256),\r
+       PASSWORD varchar(256),\r
+       SW_VERSION varchar(20),\r
+       HW_VERSION varchar(20),\r
+       CONNECTION_REQUEST_URL varchar(1024),\r
+       LAST_UPDATED_TIME Timestamp\r
 );\r
 \r
 \r
 CREATE TABLE IF NOT EXISTS tr069_nbi_request \r
-  (\r
-  ID int null, \r
-  DEVICE_ID varchar(30) not null, \r
-  OPERATION_ID bigint unsigned not null,\r
-  OPERATION_CODE int null,\r
-  ATTRIBUTE_JSON1 varchar(4000),\r
-  ATTRIBUTE_JSON2 varchar(4000),\r
-  ATTRIBUTE_JSON3 varchar(4000),\r
-  REQUEST_TIME_OUT int,\r
-  CREATE_TIME DATETIME(6),\r
-  IS_PROCESSED int DEFAULT 0\r
+       (\r
+       ID int null, \r
+       DEVICE_ID varchar(30) not null, \r
+       OPERATION_ID bigint unsigned not null,\r
+       OPERATION_CODE int null,\r
+       ATTRIBUTE_JSON1 varchar(4000),\r
+       ATTRIBUTE_JSON2 varchar(4000),\r
+       ATTRIBUTE_JSON3 varchar(4000),\r
+       REQUEST_TIME_OUT int,\r
+       CREATE_TIME DATETIME(6),\r
+       IS_PROCESSED int DEFAULT 0\r
 );\r
 \r
-\r
+       \r
 CREATE TABLE IF NOT EXISTS tr069_session \r
-  (\r
-  DEVICE_ID varchar(30) not null,\r
-  SESSION_ID varchar(64) not null,\r
-  STATE int,\r
-  CURRENT_OPERATION_ID bigint unsigned,\r
-  SESSION_START_TIME TIMESTAMP\r
+       (\r
+       DEVICE_ID varchar(30) not null,\r
+       SESSION_ID varchar(64) not null,\r
+       STATE int,\r
+       CURRENT_OPERATION_ID bigint unsigned,\r
+       SESSION_START_TIME TIMESTAMP\r
 );\r
 \r
 CREATE SEQUENCE IF NOT EXISTS hibernate_sequence MINVALUE 1 MAXVALUE 4611686018427387903 CYCLE CACHE 10;\r