Lines 175-181
CREATE TABLE `action_logs` (
Link Here
|
175 |
`object` int(11) DEFAULT NULL COMMENT 'the object that the action was taken against (could be a borrowernumber, itemnumber, etc)', |
175 |
`object` int(11) DEFAULT NULL COMMENT 'the object that the action was taken against (could be a borrowernumber, itemnumber, etc)', |
176 |
`info` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'information about the action (usually includes SQL statement)', |
176 |
`info` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'information about the action (usually includes SQL statement)', |
177 |
`interface` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the context this action was taken in', |
177 |
`interface` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the context this action was taken in', |
178 |
`script` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change', |
178 |
`script` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change', |
179 |
PRIMARY KEY (`action_id`), |
179 |
PRIMARY KEY (`action_id`), |
180 |
KEY `timestamp_idx` (`timestamp`), |
180 |
KEY `timestamp_idx` (`timestamp`), |
181 |
KEY `user_idx` (`user`), |
181 |
KEY `user_idx` (`user`), |
182 |
- |
|
|