vasya
20 lines
1.1 KiB
SQL
20 lines
1.1 KiB
SQL
-- custom.activity_log definition
|
|
|
|
CREATE TABLE `activity_log` (
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`business_event` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'кастомное событие',
|
|
`subject_id` bigint(20) unsigned DEFAULT NULL,
|
|
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
|
|
`batch_uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
`causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`causer_id` bigint(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `subject` (`subject_type`,`subject_id`),
|
|
KEY `activity_log_log_name_index` (`log_name`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |