File indexing completed on 2024-04-21 06:00:36 

0001 CREATE TABLE `project_moderation_type`
0002 (
0003     `project_moderation_type_id` INT(11)      NOT NULL AUTO_INCREMENT,
0004     `name`                       VARCHAR(100) NOT NULL,
0005     `tag_id`                     INT(11) DEFAULT NULL
0006         COMMENT 'if exist insert/remove project tag_id relation',
0007     PRIMARY KEY (`project_moderation_type_id`)
0008 )
0009     ENGINE = INNODB;
0010 
0011 
0012 CREATE TABLE `project_moderation`
0013 (
0014     `project_moderation_id`      INT(11)   NOT NULL AUTO_INCREMENT,
0015     `project_moderation_type_id` INT(11)   NOT NULL,
0016     `project_id`                 INT(11)   NOT NULL,
0017     `created_by`                 INT(11)   NOT NULL,
0018     `updated_by`                 INT(11)            DEFAULT NULL,
0019     `note`                       TEXT      NOT NULL,
0020     `is_deleted`                 INT(1)    NOT NULL DEFAULT '0',
0021     `is_valid`                   INT(1)    NOT NULL DEFAULT '0'
0022         COMMENT 'Admin can mark a report as valid',
0023     `created_at`                 TIMESTAMP NULL     DEFAULT CURRENT_TIMESTAMP,
0024     `updated_at`                 DATETIME           DEFAULT NULL,
0025     PRIMARY KEY (`project_moderation_id`),
0026     FOREIGN KEY (`project_moderation_type_id`)
0027         REFERENCES `project_moderation_type` (`project_moderation_type_id`)
0028 )
0029     ENGINE = INNODB;
0030