-- 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
+ LAST_FAILED_ATTEMPT_TIME Timestamp,\r
+ CONN_STATUS BOOLEAN,\r
+ ERROR_MESSGAE varchar(256)\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