Home
last modified time | relevance | path

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

12

/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);
H A Dupdate0006.sql1 CREATE INDEX idx_optin_key ON optin(key);
/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 `uid` (`uid`);
[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/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/db/
H A Dupdate0006.sql1 CREATE INDEX idx_class ON pages(class);
2 CREATE INDEX idx_pid ON data(pid);
H A Dupdate0001.sql2 CREATE INDEX idx_key ON data(key);
4 CREATE UNIQUE INDEX idx_page ON pages(page);
/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/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);
H A Dupdate0008.sql1 CREATE UNIQUE INDEX idx_tasks_page_md5 ON tasks(page, md5);
/plugin/combo/db/
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/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/labeled/db/
H A Dupdate0001.sql3 CREATE INDEX idx_id ON labeled(id);
4 CREATE INDEX idx_name ON labels(name);
/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);
/plugin/davcal/db/
H A Dupdate0001.sql37 CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken);
64 CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri);
/plugin/sqlite/
H A Ddb.sql3 CREATE UNIQUE INDEX idx_opt ON opts(opt);
/plugin/starred/db/
H A Dupdate0001.sql7 CREATE UNIQUE INDEX idx_stars_pid_login ON stars(pid, login);

12