Searched refs:INDEX (Results 1 – 25 of 64) sorted by relevance
123
| /plugin/statistics/db/ |
| D | update0001.sql | 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`);
[all …]
|
| D | update0003.sql | 9 CREATE INDEX `idx_campaigns_campaign` ON `campaigns` (`campaign`);
10 CREATE INDEX `idx_campaigns_source` ON `campaigns` (`source`);
11 CREATE INDEX `idx_campaigns_medium` ON `campaigns` (`medium`);
|
| D | update0004.sql | 21 CREATE INDEX idx_campaigns_campaign ON campaigns (campaign);
22 CREATE INDEX idx_campaigns_source ON campaigns (source);
23 CREATE INDEX idx_campaigns_medium ON campaigns (medium);
|
| /plugin/blogtng/db/ |
| D | update0001.sql | 13 CREATE UNIQUE INDEX idx_entries_pid ON entries(pid);
14 CREATE INDEX idx_entries_title ON entries(title);
15 CREATE INDEX idx_entries_created ON entries(created);
16 CREATE INDEX idx_entries_blog ON entries(blog);
30 CREATE INDEX idx_comments_created ON comments(created);
31 CREATE INDEX idx_comments_pid ON comments(pid);
32 CREATE INDEX idx_comments_status ON comments(status);
39 CREATE INDEX idx_tags_pid ON tags(pid);
40 CREATE INDEX idx_tags_tag ON tags(tag);
|
| D | update0004.sql | 33 CREATE INDEX idx_comments_created ON comments(created);
34 CREATE INDEX idx_comments_pid ON comments(pid);
35 CREATE INDEX idx_comments_status ON comments(status);
75 CREATE UNIQUE INDEX idx_entries_pid ON entries(pid);
76 CREATE INDEX idx_entries_title ON entries(title);
77 CREATE INDEX idx_entries_created ON entries(created);
78 CREATE INDEX idx_entries_blog ON entries(blog);
|
| D | update0005.sql | 33 CREATE UNIQUE INDEX idx_entries_pid ON entries(pid);
34 CREATE INDEX idx_entries_title ON entries(title);
35 CREATE INDEX idx_entries_created ON entries(created);
36 CREATE INDEX idx_entries_blog ON entries(blog);
|
| D | update0003.sql | 6 CREATE INDEX idx_subscriptions_pid ON subscriptions(pid);
7 CREATE INDEX idx_subscriptions_mail ON subscriptions(mail);
|
| /plugin/timetrack/db/ |
| D | update0001.sql | 2 CREATE UNIQUE INDEX idx_user ON user(user);
5 CREATE UNIQUE INDEX idx_page ON page(page);
8 CREATE UNIQUE INDEX idx_project ON project(page_id,abbr);
11 CREATE UNIQUE INDEX idx_task ON task(project_id,abbr);
14 CREATE UNIQUE INDEX idx_user_time ON user_time(user_id,task_id,date);
|
| /plugin/combo/db/combo/ |
| H A D | update0012.sql | 7 CREATE UNIQUE INDEX PAGE_REFERENCES_IDX ON PAGE_REFERENCES (SOURCE_ID,TARGET_ID);
8 CREATE INDEX PAGE_REFERENCES_IDX_SOURCE ON PAGE_REFERENCES (SOURCE_ID);
9 CREATE INDEX PAGE_REFERENCES_IDX_TARGET ON PAGE_REFERENCES (TARGET_ID);
|
| H A D | update0018.sql | 9 CREATE UNIQUE INDEX PAGE_REFERENCES_IDX ON PAGE_REFERENCES (PAGE_ID,REFERENCE);
10 CREATE INDEX PAGE_REFERENCES_IDX_SOURCE ON PAGE_REFERENCES (PAGE_ID);
11 CREATE INDEX PAGE_REFERENCES_IDX_TARGET ON PAGE_REFERENCES (REFERENCE);
|
| H A D | update0015.sql | 6 DROP INDEX PAGES_ALIAS_UK;
7 CREATE INDEX DEPRECATED_PAGES_ALIAS_UK ON DEPRECATED_PAGES_ALIAS (ALIAS);
16 CREATE UNIQUE INDEX PAGE_ALIAS_UK ON PAGE_ALIASES (PAGE_ID,PATH);
|
| H A D | update0017.sql | 3 CREATE INDEX PAGES_PAGE_ID_ABBR_UK ON PAGES (PAGE_ID_ABBR);
5 DROP INDEX PAGES_UK;
|
| H A D | update0002.sql | 7 CREATE UNIQUE INDEX PAGES_UK ON PAGES (ID, CANONICAL);
17 CREATE UNIQUE INDEX PAGES_ALIAS_UK ON PAGES_ALIAS (CANONICAL, ALIAS);
|
| /plugin/tagging/db/ |
| H A D | update0002.sql | 3 DROP INDEX idx_pid;
14 CREATE INDEX idx_taggings_pid ON taggings(pid);
15 CREATE INDEX idx_taggings_lang ON taggings(lang);
|
| /plugin/data/db/ |
| D | update0006.sql | 1 CREATE INDEX idx_class ON pages (class);
2 CREATE INDEX idx_pid ON data (pid);
|
| D | update0001.sql | 8 CREATE INDEX idx_key ON data (key);
15 CREATE UNIQUE INDEX idx_page ON pages (page);
|
| /plugin/data-au/db/ |
| D | update0006.sql | 1 CREATE INDEX idx_class ON pages(class);
2 CREATE INDEX idx_pid ON dataau(pid);
|
| D | update0001.sql | 2 CREATE INDEX idx_key ON dataau(key);
4 CREATE UNIQUE INDEX idx_page ON pages(page);
|
| /plugin/bibtex4dw/db/ |
| D | update0001.sql | 3 CREATE UNIQUE INDEX idx_key ON bibtex(key);
4 CREATE UNIQUE INDEX idx_string ON strings(string);
|
| /plugin/do/db/ |
| D | update0001.sql | 9 CREATE UNIQUE INDEX idx_tasks_page_md5 ON tasks(page, md5);
17 CREATE UNIQUE INDEX idx_task_status_page_md5 ON task_status(page, md5);
|
| /plugin/aichat/db/ |
| D | update0003.sql | 2 CREATE INDEX embeddings_lang_idx ON embeddings (lang);
12 CREATE INDEX clusters_lang_idx ON clusters (lang);
|
| /plugin/strata/sql/ |
| D | setup-pgsql.sql | 9 CREATE INDEX idx_spo ON data(lower(subject), lower(predicate), lower(object));
12 CREATE INDEX idx_pso ON data(lower(predicate), lower(subject), lower(object));
|
| D | setup-mysql.sql | 9 CREATE INDEX idx_spo ON data(subject(32), predicate(32), object(32)); -- Prefix length is arbitrary
12 CREATE INDEX idx_pso ON data(predicate(32), subject(32), object(32)); -- Prefix length is arbitrary
|
| D | setup-sqlite.sql | 9 CREATE INDEX idx_spo ON data(subject, predicate, object);
12 CREATE INDEX idx_pso ON data(predicate, subject, object);
|
| /plugin/labeled/db/ |
| D | update0001.sql | 3 CREATE INDEX idx_id ON labeled(id);
4 CREATE INDEX idx_name ON labels(name);
|
123