diff options
Diffstat (limited to 'components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql')
-rw-r--r-- | components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql b/components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql index 9b391d0f..34e4ece8 100644 --- a/components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql +++ b/components/datalake-handler/des/src/assembly/init_db/db_scripts/init_db.sql @@ -32,7 +32,7 @@ CREATE TABLE db_type ( id varchar(255) NOT NULL, default_port int DEFAULT NULL, name varchar(255) NOT NULL, - tool bit(1) NOT NULL, + tool boolean NOT NULL, PRIMARY KEY (id) ); CREATE SEQUENCE db_seq; @@ -40,8 +40,8 @@ CREATE SEQUENCE db_seq; CREATE TABLE db ( id int NOT NULL DEFAULT NEXTVAL ('db_seq'), database_name varchar(255) DEFAULT NULL, - enabled bit(1) NOT NULL, - encrypt bit(1) DEFAULT NULL, + enabled boolean NOT NULL, + encrypt boolean DEFAULT NULL, host varchar(255) DEFAULT NULL, login varchar(255) DEFAULT NULL, name varchar(255) DEFAULT NULL, @@ -74,7 +74,7 @@ CREATE TABLE design ( body text DEFAULT NULL, name varchar(255) DEFAULT NULL, note varchar(255) DEFAULT NULL, - submitted bit(1) DEFAULT NULL, + submitted boolean DEFAULT NULL, design_type_id varchar(255) NOT NULL, topic_name_id varchar(255) NOT NULL, PRIMARY KEY (id), @@ -90,14 +90,14 @@ CREATE TABLE kafka ( id int NOT NULL DEFAULT NEXTVAL ('kafka_seq'), broker_list varchar(255) NOT NULL, consumer_count int DEFAULT 3, - enabled bit(1) NOT NULL, + enabled boolean NOT NULL, excluded_topic varchar(1023) DEFAULT '__consumer_offsets,__transaction_state', "group" varchar(255) DEFAULT 'datalake', included_topic varchar(255) DEFAULT NULL, login varchar(255) DEFAULT NULL, name varchar(255) NOT NULL, pass varchar(255) DEFAULT NULL, - secure bit(1) DEFAULT b'0', + secure boolean DEFAULT FALSE, security_protocol varchar(255) DEFAULT NULL, timeout_sec int DEFAULT 10, zk varchar(255) NOT NULL, @@ -108,14 +108,14 @@ CREATE SEQUENCE topic_seq; CREATE TABLE topic ( id int NOT NULL DEFAULT NEXTVAL ('topic_seq'), aggregate_array_path varchar(255) DEFAULT NULL, - correlate_cleared_message bit(1) NOT NULL DEFAULT b'0', + correlate_cleared_message boolean NOT NULL DEFAULT FALSE, data_format varchar(255) DEFAULT NULL, - enabled bit(1) NOT NULL, + enabled boolean NOT NULL, flatten_array_path varchar(255) DEFAULT NULL, login varchar(255) DEFAULT NULL, message_id_path varchar(255) DEFAULT NULL, pass varchar(255) DEFAULT NULL, - save_raw bit(1) NOT NULL DEFAULT b'0', + save_raw boolean NOT NULL DEFAULT FALSE, ttl_day int DEFAULT NULL, topic_name_id varchar(255) NOT NULL, PRIMARY KEY (id), |