X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=acs%2Fapplication-booter%2Fsrc%2Fmain%2Fresources%2Fschema-mariadb.sql;h=f39500d6f4be1aa23f094791cc205a74651b37d5;hb=c4ed11115cea02bb72770e74805081ddba12daef;hp=664cb66c31dfc0a77faf7d0c4eb9a165a13c207b;hpb=a58ada8fd244e69cf2ebe48a251fcdd4d48acec4;p=oam%2Ftr069-adapter.git

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
--- 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
 
 CREATE TABLE IF NOT EXISTS tr069_device 
-  (
-  ID int null,
-  DEVICE_ID varchar(30) not null,
-  USER_NAME varchar(256),
-  PASSWORD varchar(256),
-  SW_VERSION varchar(20),
-  HW_VERSION varchar(20),
-  CONNECTION_REQUEST_URL varchar(1024),
-  LAST_UPDATED_TIME Timestamp
+	(
+	ID int null,
+	DEVICE_ID varchar(30) not null,
+	USER_NAME varchar(256),
+	PASSWORD varchar(256),
+	SW_VERSION varchar(20),
+	HW_VERSION varchar(20),
+	CONNECTION_REQUEST_URL varchar(1024),
+	LAST_UPDATED_TIME Timestamp
 );
 
 
 CREATE TABLE IF NOT EXISTS tr069_nbi_request 
-  (
-  ID int null, 
-  DEVICE_ID varchar(30) not null, 
-  OPERATION_ID bigint unsigned not null,
-  OPERATION_CODE int null,
-  ATTRIBUTE_JSON1 varchar(4000),
-  ATTRIBUTE_JSON2 varchar(4000),
-  ATTRIBUTE_JSON3 varchar(4000),
-  REQUEST_TIME_OUT int,
-  CREATE_TIME DATETIME(6),
-  IS_PROCESSED int DEFAULT 0
+	(
+	ID int null, 
+	DEVICE_ID varchar(30) not null, 
+	OPERATION_ID bigint unsigned not null,
+	OPERATION_CODE int null,
+	ATTRIBUTE_JSON1 varchar(4000),
+	ATTRIBUTE_JSON2 varchar(4000),
+	ATTRIBUTE_JSON3 varchar(4000),
+	REQUEST_TIME_OUT int,
+	CREATE_TIME DATETIME(6),
+	IS_PROCESSED int DEFAULT 0
 );
 
-
+	
 CREATE TABLE IF NOT EXISTS tr069_session 
-  (
-  DEVICE_ID varchar(30) not null,
-  SESSION_ID varchar(64) not null,
-  STATE int,
-  CURRENT_OPERATION_ID bigint unsigned,
-  SESSION_START_TIME TIMESTAMP
+	(
+	DEVICE_ID varchar(30) not null,
+	SESSION_ID varchar(64) not null,
+	STATE int,
+	CURRENT_OPERATION_ID bigint unsigned,
+	SESSION_START_TIME TIMESTAMP
 );
 
 CREATE SEQUENCE IF NOT EXISTS hibernate_sequence MINVALUE 1 MAXVALUE 4611686018427387903 CYCLE CACHE 10;