create_table.sql - master - kev/Nextcloud_File-Changes-Tracker

create_table.sql
61 строка2 KB
Evgeny Konovalov
first_commit
16 фев 2026, 18:03
16 фев 2026, 18:0393e4b7a
-- �������� �������
CREATE TABLE IF NOT EXISTS `oc_fct_folder_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `folder_path` varchar(4000) NOT NULL,
  `folder_id` bigint(20) unsigned DEFAULT NULL,
  `responsible_type` varchar(10) NOT NULL,
  `responsible_id` varchar(64) NOT NULL,
  `notifications_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fct_folder_path_idx` (`folder_path`(768)),
  KEY `fct_folder_id_idx` (`folder_id`),
  KEY `fct_responsible_idx` (`responsible_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS `oc_fct_event_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `folder_config_id` bigint(20) unsigned NOT NULL,
  `event_type` varchar(20) NOT NULL,
  `file_path` varchar(4000) NOT NULL,
  `file_id` bigint(20) unsigned DEFAULT NULL,
  `old_file_path` varchar(4000) DEFAULT NULL,
  `user_id` varchar(64) NOT NULL,
  `user_display_name` varchar(255) NOT NULL,
  `event_timestamp` datetime NOT NULL,
  `file_size` bigint(20) unsigned DEFAULT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `notification_sent` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `fct_event_folder_idx` (`folder_config_id`),
  KEY `fct_event_time_idx` (`event_timestamp`),
  KEY `fct_event_user_idx` (`user_id`),
  KEY `fct_event_path_idx` (`file_path`(768)),
  KEY `fct_event_type_idx` (`event_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS `oc_fct_notification_settings` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `folder_config_id` BIGINT UNSIGNED NOT NULL,
   
    -- ���������� �����������
    `instant_notifications` TINYINT(1) NOT NULL DEFAULT 1,
    `notify_on_create` TINYINT(1) NOT NULL DEFAULT 1,
    `notify_on_modify` TINYINT(1) NOT NULL DEFAULT 1,
    `notify_on_delete` TINYINT(1) NOT NULL DEFAULT 1,
    `notify_on_rename` TINYINT(1) NOT NULL DEFAULT 1,
    
    -- ���������� ������
    `daily_digest_enabled` TINYINT(1) NOT NULL DEFAULT 0,
    `digest_time` VARCHAR(5) NOT NULL DEFAULT '09:00',
    `digest_email` VARCHAR(255) DEFAULT NULL,
    
    -- ��������� �����
    `created_at` DATETIME NOT NULL,
    `updated_at` DATETIME NOT NULL,
    
    PRIMARY KEY (`id`),
    INDEX `fct_notif_folder_config_id` (`folder_config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;