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

0001 CREATE TABLE `stat_downloads_quarter_year`
0002 (
0003     `project_id`           INT(11)      NOT NULL DEFAULT '0',
0004     `project_category_id`  INT(11)      NOT NULL DEFAULT '0',
0005     `ppload_collection_id` VARCHAR(255) NULL     DEFAULT NULL COLLATE 'utf8_general_ci',
0006     `amount`               BIGINT(21)   NOT NULL DEFAULT '0',
0007     `category_title`       VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci',
0008     INDEX `idx_project_id` (`project_id`),
0009     INDEX `idx_collection_id` (`ppload_collection_id`)
0010 )
0011     ENGINE = InnoDB
0012 ;