28 lines
1.1 KiB
SQL
28 lines
1.1 KiB
SQL
CREATE TABLE `threads` (
|
|
`THREAD_ID` bigint(20) unsigned NOT NULL,
|
|
`NAME` varchar(128) NOT NULL,
|
|
`TYPE` varchar(10) NOT NULL,
|
|
`PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`PROCESSLIST_USER` varchar(32) DEFAULT NULL,
|
|
`PROCESSLIST_HOST` varchar(60) DEFAULT NULL,
|
|
`PROCESSLIST_DB` varchar(64) DEFAULT NULL,
|
|
`PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL,
|
|
`PROCESSLIST_TIME` bigint(20) DEFAULT NULL,
|
|
`PROCESSLIST_STATE` varchar(64) DEFAULT NULL,
|
|
`PROCESSLIST_INFO` longtext,
|
|
`PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`ROLE` varchar(64) DEFAULT NULL,
|
|
`INSTRUMENTED` enum('YES','NO') NOT NULL,
|
|
`HISTORY` enum('YES','NO') NOT NULL,
|
|
`CONNECTION_TYPE` varchar(16) DEFAULT NULL,
|
|
`THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL,
|
|
`RESOURCE_GROUP` varchar(64) DEFAULT NULL,
|
|
PRIMARY KEY (`THREAD_ID`),
|
|
KEY `PROCESSLIST_ID` (`PROCESSLIST_ID`),
|
|
KEY `THREAD_OS_ID` (`THREAD_OS_ID`),
|
|
KEY `NAME` (`NAME`),
|
|
KEY `PROCESSLIST_ACCOUNT` (`PROCESSLIST_USER`,`PROCESSLIST_HOST`),
|
|
KEY `PROCESSLIST_HOST` (`PROCESSLIST_HOST`),
|
|
KEY `RESOURCE_GROUP` (`RESOURCE_GROUP`)
|
|
);
|