File indexing completed on 2024-04-14 05:53:07
0001 0002 0003 CREATE TABLE `media_views` 0004 ( 0005 `media_view_id` BIGINT(20) NOT NULL, 0006 `media_view_type_id` INT(1) NOT NULL, 0007 `project_id` INT(11) NOT NULL, 0008 `collection_id` INT(11) NOT NULL, 0009 `file_id` INT(11) NOT NULL, 0010 `member_id` INT(11) NULL DEFAULT NULL, 0011 `referer` VARCHAR(255) NULL DEFAULT NULL, 0012 `start_timestamp` DATETIME NULL DEFAULT NULL, 0013 `stop_timestamp` DATETIME NULL DEFAULT NULL, 0014 `ip` VARCHAR(39) NULL DEFAULT NULL, 0015 `source` VARCHAR(39) NULL DEFAULT NULL, 0016 PRIMARY KEY (`media_view_id`) 0017 ) 0018 COLLATE = 'utf8_general_ci' 0019 ENGINE = InnoDB 0020 ; 0021 0022 ALTER TABLE `media_views` 0023 ADD INDEX `idx_file` (`collection_id`, `file_id`), 0024 ADD INDEX `idx_media_type` (`media_view_type_id`); 0025 0026 0027 CREATE TABLE `media_view_type` 0028 ( 0029 `media_view_type_id` INT(1) NOT NULL, 0030 `name` VARCHAR(35) NULL DEFAULT NULL, 0031 `full_name` VARCHAR(255) NULL DEFAULT NULL, 0032 `description` VARCHAR(255) NULL DEFAULT NULL, 0033 PRIMARY KEY (`media_view_type_id`) 0034 ) 0035 COLLATE = 'utf8_general_ci' 0036 ENGINE = InnoDB 0037 ; 0038 0039 INSERT INTO `media_view_type` (`media_view_type_id`, `NAME`, `full_name`, `description`) 0040 VALUES (1, 'video', 'Video', 'Video'); 0041 INSERT INTO `media_view_type` (`media_view_type_id`, `NAME`, `full_name`, `description`) 0042 VALUES (2, 'music', 'Music', 'Music'); 0043 INSERT INTO `media_view_type` (`media_view_type_id`, `NAME`, `full_name`, `description`) 0044 VALUES (3, 'book', 'Book', 'Book'); 0045 0046 0047 SELECT * 0048 FROM `media_views` `m` 0049 JOIN `media_view_type` `mp` ON `mp`.`media_view_type_id` = `m`.`media_view_type_id` 0050 ; 0051 0052