Lines Matching refs:INDEX

32 CREATE INDEX `idx_session_dt` ON `sessions` (`dt`);
33 CREATE INDEX `idx_session_uid` ON `sessions` (`uid`);
34 CREATE INDEX `idx_session_ua_type` ON `sessions` (`ua_type`);
45 CREATE UNIQUE INDEX `idx_referers_url` ON `referers` (`url`);
46 CREATE INDEX `idx_referers_dt` ON `referers` (`dt`);
47 CREATE INDEX `idx_referers_engine` ON `referers` (`engine`);
64 CREATE INDEX `idx_pageviews_page` ON `pageviews` (`page`);
65 CREATE INDEX `idx_pageviews_dt` ON `pageviews` (`dt`);
76 CREATE INDEX `idx_iplocation_code` ON `iplocation` (`code`);
86 CREATE INDEX `idx_outlinks_link` ON `outlinks` (`link`);
87 CREATE INDEX `idx_outlinks_dt` ON `outlinks` (`dt`);
99 CREATE INDEX `idx_search_dt` ON `search` (`dt`);
119 CREATE INDEX `idx_edits_dt` ON `edits` (`dt`);
120 CREATE INDEX `idx_edits_type` ON `edits` (`type`);
131 CREATE INDEX `idx_logins_dt` ON `logins` (`dt`);
132 CREATE INDEX `idx_logins_type` ON `logins` (`type`);
148 CREATE INDEX `idx_media_media` ON `media` (`media`);
149 CREATE INDEX `idx_media_dt` ON `media` (`dt`);
150 CREATE INDEX `idx_media_mime1` ON `media` (`mime1`);