| 1 |
- CREATE TABLE `test_columnar` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint NOT NULL,
`vault_id` bigint NOT NULL,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
`address_from` int NOT NULL DEFAULT '0' ,
`alias` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT 'MyAddress' ,
`balance` decimal(50, 0) NOT NULL DEFAULT '0' ,
`coin_type` int NOT NULL DEFAULT '0' ,
`height` bigint DEFAULT '0' ,
`shard` smallint NOT NULL DEFAULT '0' ,
`chain` int NOT NULL DEFAULT '0' ,
`status` smallint NOT NULL DEFAULT '0' ,
`account` int NOT NULL DEFAULT '0',
`is_change` tinyint DEFAULT '0' ,
`address_index` int DEFAULT '0' ,
`redeem_script` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
`nonce` bigint UNSIGNED NOT NULL DEFAULT '0',
`is_sync` tinyint NOT NULL DEFAULT '0',
`flag` tinyint NOT NULL DEFAULT '0',
`wallet_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '',
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modify_date` timestamp NULL DEFAULT NULL ,
`address_type` tinyint NOT NULL DEFAULT '0',
`risk_type` int NOT NULL DEFAULT '0' ,
`balance_source` int NOT NULL DEFAULT '0',
`tx_flag` tinyint NOT NULL DEFAULT '0' ,
`risk_flag` smallint NOT NULL DEFAULT '0',
`business_line` int NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
CLUSTERED COLUMNAR INDEX `cc_i_address` (`address`)
PARTITION BY HASH(`address`)
PARTITIONS 32,
UNIQUE KEY `idx_ct_addr` USING BTREE (`user_id`, `coin_type`, `address`)
) ENGINE = InnoDB AUTO_INCREMENT = 128498037 DEFAULT CHARSET = utf8mb3 DEFAULT COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC
PARTITION BY KEY(`address`)
PARTITIONS 32
|
