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

0001 CREATE TABLE ppload.ppload_file_preview (
0002         `id` BIGINT(20) NOT NULL,
0003         `collection_id` INT(11) NOT NULL,
0004         `file_id` INT(11) NOT NULL,
0005         `url_preview` VARCHAR(255) NULL DEFAULT NULL,
0006         `url_thumb` VARCHAR(255) NULL DEFAULT NULL,
0007         `create_timestamp` DATETIME NULL DEFAULT NULL,
0008         PRIMARY KEY (`id`)
0009 )
0010 COLLATE='utf8_general_ci'
0011 ENGINE=InnoDB
0012 ;
0013 
0014 ALTER TABLE ppload.ppload_file_preview
0015         ADD INDEX `idx_file` (`collection_id`, `file_id`);
0016 
0017 ALTER TABLE `ppload_file_preview`
0018         ADD UNIQUE INDEX `UK` (`collection_id`, `file_id`);