forked from ctsit/redcapcustodian
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrcc_job_log.sql
18 lines (18 loc) · 889 Bytes
/
rcc_job_log.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TABLE `rcc_job_log` (
`id` bigint NOT NULL AUTO_INCREMENT,
`log_date` datetime NOT NULL,
`project` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`instance` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`script_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`script_run_time` datetime NOT NULL,
`job_summary_data` mediumtext DEFAULT NULL,
`job_duration` double not null,
`level` enum('SUCCESS','DEBUG','ERROR') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `log_date` (`log_date`),
KEY `project` (`project`),
KEY `instance` (`instance`),
KEY `script_name` (`script_name`),
KEY `script_run_time` (`script_run_time`),
KEY `level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;