github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_csv/data/csv.threads-schema.sql (about)

     1  CREATE TABLE `threads` (
     2    `THREAD_ID` bigint(20) unsigned NOT NULL,
     3    `NAME` varchar(128) NOT NULL,
     4    `TYPE` varchar(10) NOT NULL,
     5    `PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL,
     6    `PROCESSLIST_USER` varchar(32) DEFAULT NULL,
     7    `PROCESSLIST_HOST` varchar(60) DEFAULT NULL,
     8    `PROCESSLIST_DB` varchar(64) DEFAULT NULL,
     9    `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL,
    10    `PROCESSLIST_TIME` bigint(20) DEFAULT NULL,
    11    `PROCESSLIST_STATE` varchar(64) DEFAULT NULL,
    12    `PROCESSLIST_INFO` longtext,
    13    `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
    14    `ROLE` varchar(64) DEFAULT NULL,
    15    `INSTRUMENTED` enum('YES','NO') NOT NULL,
    16    `HISTORY` enum('YES','NO') NOT NULL,
    17    `CONNECTION_TYPE` varchar(16) DEFAULT NULL,
    18    `THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL,
    19    `RESOURCE_GROUP` varchar(64) DEFAULT NULL,
    20    PRIMARY KEY (`THREAD_ID`),
    21    KEY `PROCESSLIST_ID` (`PROCESSLIST_ID`),
    22    KEY `THREAD_OS_ID` (`THREAD_OS_ID`),
    23    KEY `NAME` (`NAME`),
    24    KEY `PROCESSLIST_ACCOUNT` (`PROCESSLIST_USER`,`PROCESSLIST_HOST`),
    25    KEY `PROCESSLIST_HOST` (`PROCESSLIST_HOST`),
    26    KEY `RESOURCE_GROUP` (`RESOURCE_GROUP`)
    27  );