github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_column_permutation/data/perm.test_perm-schema.sql (about)

     1  CREATE TABLE `test_perm` (
     2  	`id` int(11) NOT NULL,
     3  	`contract_no` varchar(64) DEFAULT NULL,
     4  	`fund_seq_no` varchar(64) DEFAULT NULL,
     5  	`term_no` int(11) DEFAULT NULL,
     6  	`contract_type` varchar(8) DEFAULT NULL,
     7  	`internal_transfer_tag` varchar(8) DEFAULT NULL,
     8  	`prin_amt` int(11) DEFAULT NULL,
     9  	`start_date` varchar(8) DEFAULT NULL,
    10  	`end_date` varchar(8) DEFAULT NULL,
    11  	`batch_date` varchar(32) DEFAULT NULL,
    12  	`crt_time` timestamp DEFAULT CURRENT_TIMESTAMP,
    13  	`region_code` varchar(8) DEFAULT NULL,
    14  	`credit_code` varchar(64) DEFAULT NULL
    15  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
    16  PARTITION BY RANGE COLUMNS(batch_date) (
    17  	PARTITION `P20200224` VALUES LESS THAN ("2020-02-05 00:00:00"),
    18  	PARTITION `P20200324` VALUES LESS THAN ("2020-03-05 00:00:00"),
    19  	PARTITION `P20200424` VALUES LESS THAN ("2020-04-05 00:00:00"),
    20  	PARTITION `P20200524` VALUES LESS THAN ("2020-05-05 00:00:00"),
    21  	PARTITION `P_MAXVALUE` VALUES LESS THAN MAXVALUE
    22  );