Home
last modified time | relevance | path

Searched refs:INDEX (Results 1 – 25 of 61) sorted by relevance

123

/plugin/blogtng/db/
H A Dupdate0001.sql13 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);
H A Dupdate0004.sql33 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);
H A Dupdate0005.sql33 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);
H A Dupdate0003.sql6 CREATE INDEX idx_subscriptions_pid ON subscriptions(pid);
7 CREATE INDEX idx_subscriptions_mail ON subscriptions(mail);
/plugin/statistics/
H A Ddb.sql168 ALTER TABLE `stats_search` ADD INDEX `engine` (`engine`);
194 ALTER TABLE `stats_edits` ADD INDEX `dt` (`dt`);
195 ALTER TABLE `stats_edits` ADD INDEX `type` (`type`);
196 ALTER TABLE `stats_logins` ADD INDEX `dt` (`dt`);
197 ALTER TABLE `stats_logins` ADD INDEX `type` (`type`);
198 ALTER TABLE `stats_outlinks` ADD INDEX `dt` (`dt`);
199 ALTER TABLE `stats_search` ADD INDEX `dt` (`dt`);
200 ALTER TABLE `stats_session` ADD INDEX `dt` (`dt`);
201 ALTER TABLE `stats_session` ADD INDEX `views` (`views`);
202 ALTER TABLE `stats_session` ADD INDEX `ui
[all...]
/plugin/timetrack/db/
H A Dupdate0001.sql2 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 Dupdate0012.sql7 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 Dupdate0018.sql9 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 Dupdate0015.sql6 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 Dupdate0017.sql3 CREATE INDEX PAGES_PAGE_ID_ABBR_UK ON PAGES (PAGE_ID_ABBR);
5 DROP INDEX PAGES_UK;
H A Dupdate0002.sql7 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 Dupdate0002.sql3 DROP INDEX idx_pid;
14 CREATE INDEX idx_taggings_pid ON taggings(pid);
15 CREATE INDEX idx_taggings_lang ON taggings(lang)
/plugin/data-au/db/
H A Dupdate0006.sql1 CREATE INDEX idx_class ON pages(class);
2 CREATE INDEX idx_pid ON dataau(pid);
H A Dupdate0001.sql2 CREATE INDEX idx_key ON dataau(key);
4 CREATE UNIQUE INDEX idx_page ON pages(page);
/plugin/data/db/
H A Dupdate0006.sql1 CREATE INDEX idx_class ON pages (class);
2 CREATE INDEX idx_pid ON data (pid);
H A Dupdate0001.sql8 CREATE INDEX idx_key ON data (key);
15 CREATE UNIQUE INDEX idx_page ON pages (page);
/plugin/bibtex4dw/db/
H A Dupdate0001.sql3 CREATE UNIQUE INDEX idx_key ON bibtex(key);
4 CREATE UNIQUE INDEX idx_string ON strings(string);
/plugin/do/db/
H A Dupdate0001.sql9 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/labeled/db/
H A Dupdate0001.sql3 CREATE INDEX idx_id ON labeled(id);
4 CREATE INDEX idx_name ON labels(name);
/plugin/strata/sql/
H A Dsetup-pgsql.sql9 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));
H A Dsetup-mysql.sql9 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
H A Dsetup-sqlite.sql9 CREATE INDEX idx_spo ON data(subject, predicate, object);
12 CREATE INDEX idx_pso ON data(predicate, subject, object);
/plugin/approve/db/
H A Dupdate0001.sql30 CREATE INDEX idx_revision_current
33 CREATE INDEX idx_page_maintainer
/plugin/bez/db/
H A Dupdate0001.sql29 CREATE INDEX thread_ix_last_activity_date
73 CREATE INDEX thread_comment_ix_thread_id
86 CREATE INDEX label_ix_name
168 CREATE INDEX task_ix_thread_id_thread_comment_id
171 CREATE INDEX task_ix_task_program_id
/plugin/webdavclient/db/
H A Dupdate0001.sql40 CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken);
62 CREATE INDEX addressbookid_synctoken ON addressbookchanges (addressbookid, synctoken);

123