Query Template: ../../test4.utilities.tenanthandbooks.com/httpdocs/core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.26 ms Record Count: 15 Cached: No Lazy: No SQL: SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_SCALE, COLUMN_KEY, COLUMN_DEFAULT, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, COLUMN_TYPE, EXTRA, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'queuedevents' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION | |||||||||||
COLUMN_NAME | DATA_TYPE | NUMERIC_SCALE | COLUMN_KEY | COLUMN_DEFAULT | IS_NULLABLE | CHARACTER_MAXIMUM_LENGTH | COLUMN_TYPE | EXTRA | CHARACTER_SET_NAME | ||
1 | id | int | 0 | PRI | NO | int | auto_increment | ||||
2 | DateEntered | datetime | YES | datetime | |||||||
3 | DateRun | datetime | YES | datetime | |||||||
4 | Component | varchar | YES | 255 | varchar(255) | latin1 | |||||
5 | Method | varchar | YES | 255 | varchar(255) | latin1 | |||||
6 | Arguments | longtext | YES | 4294967295 | longtext | latin1 | |||||
7 | Status | varchar | MUL | YES | 50 | varchar(50) | latin1 | ||||
8 | StatusMessage | longtext | YES | 4294967295 | longtext | utf8mb4 | |||||
9 | RunStart | datetime | YES | datetime | |||||||
10 | RunUUID | varchar | YES | 255 | varchar(255) | latin1 | |||||
11 | ScheduledDate | datetime | YES | datetime | |||||||
12 | Priority | int | 0 | YES | int | ||||||
13 | Result | text | YES | 65535 | text | latin1 | |||||
14 | SuccessEvent | longtext | YES | 4294967295 | longtext | latin1 | |||||
15 | FailureEvent | longtext | YES | 4294967295 | longtext | latin1 |