File indexing completed on 2024-03-24 06:03:43
0001 CREATE TABLE `file_types` 0002 ( 0003 `filetype_id` INT NOT NULL AUTO_INCREMENT, 0004 `text` VARCHAR(255) NOT NULL, 0005 `order` INT NULL, 0006 `is_active` INT(1) NULL DEFAULT '1', 0007 PRIMARY KEY (`filetype_id`) 0008 ) 0009 ENGINE = InnoDB 0010 ; 0011 CREATE TABLE `project_file_type` 0012 ( 0013 `project_id` INT NOT NULL, 0014 `file_id` INT NOT NULL, 0015 `file_type_id` INT NOT NULL, 0016 PRIMARY KEY (`project_id`, `file_id`) 0017 ) 0018 ENGINE = InnoDB 0019 ; 0020 0021 INSERT INTO `file_types` (`filetype_id`, `text`, `order`) 0022 VALUES ('1', 'AppImage', '1'); 0023 INSERT INTO `file_types` (`filetype_id`, `text`, `order`) 0024 VALUES ('2', 'Android (APK)', '2'); 0025 INSERT INTO `file_types` (`filetype_id`, `text`, `order`) 0026 VALUES ('3', 'OS X compatible', '3'); 0027 INSERT INTO `file_types` (`filetype_id`, `text`, `order`) 0028 VALUES ('4', 'Windows executable', '4'); 0029 0030 ALTER TABLE `file_types` 0031 CHANGE COLUMN `text` `name` VARCHAR(255) NOT NULL; 0032 0033 ALTER TABLE `project_file_type` 0034 CHANGE COLUMN `file_type_id` `filetype_id` INT(11) NOT NULL , 0035 ADD INDEX `idx_type_id` (`filetype_id` ASC);