File indexing completed on 2024-04-21 06:00:37
0001 USE `pling`; 0002 0003 DROP TABLE IF EXISTS `stat_object_view`; 0004 CREATE TABLE `stat_object_view` ( 0005 `object_id` int(11) NOT NULL, 0006 `object_type` int(11) NOT NULL, 0007 `seen_at` datetime NOT NULL, 0008 `ip_inet` varbinary(16) NOT NULL, 0009 `member_id_viewer` int(11) DEFAULT '0', 0010 `ipv6` varchar(50) DEFAULT '', 0011 `ipv4` varchar(50) DEFAULT '', 0012 `fingerprint` varchar(50) DEFAULT '', 0013 `user_agent` varchar(255) DEFAULT '', 0014 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 0015 PRIMARY KEY (`object_id`,`object_type`,`seen_at`,`ip_inet`) 0016 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 0017 PARTITION BY HASH (EXTRACT(YEAR_MONTH FROM (`seen_at`))) 0018 PARTITIONS 48 0019 ; 0020 0021 INSERT stat_object_view SELECT object_id,object_type,from_unixtime(`seen_at` * 300) as seen_at, ip_inet, member_id_viewer, ipv6, ipv4, fingerprint, user_agent, created_at FROM stat_page_impression; 0022 0023 DROP TABLE IF EXISTS `stat_object_download`; 0024 CREATE TABLE `stat_object_download` ( 0025 `object_id` INT(11) NOT NULL, 0026 `object_type` INT(11) NOT NULL, 0027 `seen_at` DATETIME NOT NULL, 0028 `ip_inet` VARBINARY(16) NOT NULL, 0029 `member_id_viewer` INT(11) DEFAULT '0', 0030 `ipv6` VARCHAR(50) DEFAULT '', 0031 `ipv4` VARCHAR(50) DEFAULT '', 0032 `fingerprint` VARCHAR(50) DEFAULT '', 0033 `user_agent` VARCHAR(255) DEFAULT '', 0034 `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, 0035 PRIMARY KEY (`object_id` , `object_type` , `seen_at` , `ip_inet`) 0036 ) ENGINE=INNODB DEFAULT CHARSET=LATIN1 PARTITION BY HASH (EXTRACT(YEAR_MONTH FROM (`seen_at`))) PARTITIONS 48 0037 ; 0038 0039 INSERT stat_object_download SELECT object_id,object_type, seen_at, ip_inet, member_id_viewer, ipv6, ipv4, fingerprint, user_agent, created_at FROM stat_file_download;