File indexing completed on 2024-04-21 06:00:36
0001 CREATE TABLE `project_clone` 0002 ( 0003 `project_clone_id` INT(11) NOT NULL AUTO_INCREMENT, 0004 `project_id` INT(11) NOT NULL, 0005 `project_id_parent` INT(11) NULL DEFAULT NULL COMMENT 'Project Id of the clone on opendesktop', 0006 `external_link` VARCHAR(255) NULL DEFAULT NULL COMMENT 'External Link to the original project', 0007 `member_id` INT(11) NULL DEFAULT NULL COMMENT 'Who send the report', 0008 `text` TEXT NULL, 0009 `is_deleted` INT(1) NOT NULL DEFAULT '0', 0010 `is_valid` INT(1) NOT NULL DEFAULT '0' COMMENT 'Admin can mark a report as valid', 0011 `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, 0012 `changed_at` TIMESTAMP NULL DEFAULT NULL, 0013 `deleted_at` TIMESTAMP NULL DEFAULT NULL, 0014 PRIMARY KEY (`project_clone_id`), 0015 INDEX `idxReport` (`project_id`, `member_id`, `is_deleted`, `created_at`) 0016 ) 0017 ENGINE = InnoDB 0018 ;