File indexing completed on 2024-04-28 17:16:11 

0001 DROP TABLE IF EXISTS `member_deactivation_log`;
0002 CREATE TABLE `member_deactivation_log`
0003 (
0004     `log_id`          INT       NOT NULL AUTO_INCREMENT,
0005     `deactivation_id` INT       NOT NULL DEFAULT '0' COMMENT 'Id of the deactivation',
0006     `object_type_id`  INT       NOT NULL DEFAULT '0',
0007     `object_id`       INT       NOT NULL DEFAULT '0',
0008     `member_id`       INT       NOT NULL DEFAULT '0' COMMENT 'Member was deactivated from this user',
0009     `created_at`      TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
0010     PRIMARY KEY (`log_id`)
0011 )
0012     COLLATE = 'utf8_general_ci'
0013 ;
0014 
0015 DROP TABLE IF EXISTS `member_deactivation_object_types`;
0016 CREATE TABLE `member_deactivation_object_types`
0017 (
0018     `object_type_id` INT         NULL,
0019     `object_system`  VARCHAR(50) NULL,
0020     `object_name`    VARCHAR(50) NULL,
0021     PRIMARY KEY (`object_type_id`)
0022 )
0023     COLLATE = 'utf8_general_ci'
0024 ;
0025 
0026 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0027 VALUES (1, 'opendesktop', 'member');
0028 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0029 VALUES (2, 'opendesktop', 'member_email');
0030 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0031 VALUES (3, 'opendesktop', 'project');
0032 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0033 VALUES (4, 'opendesktop', 'comments');
0034 
0035 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0036 VALUES (20, 'gitlab', 'user');
0037 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0038 VALUES (21, 'gitlab', 'project');
0039 
0040 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0041 VALUES (30, 'discourse', 'user');
0042 INSERT INTO `member_deactivation_object_types` (`object_type_id`, `object_system`, `object_name`)
0043 VALUES (31, 'discourse', 'topic');
0044 
0045 
0046 ALTER TABLE `member_deactivation_log`
0047     ADD COLUMN `is_deleted` INT NULL DEFAULT '0' COMMENT 'Is the user undeleted -> is_deleted = 1' AFTER `created_at`,
0048     ADD COLUMN `deleted_at` TIMESTAMP NULL AFTER `is_deleted`;