Searched refs:INDEX (Results 1 – 25 of 61) sorted by relevance
123
/plugin/blogtng/db/ |
H A 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);
|
H A 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);
|
H A 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);
|
H A D | update0003.sql | 6 CREATE INDEX idx_subscriptions_pid ON subscriptions(pid); 7 CREATE INDEX idx_subscriptions_mail ON subscriptions(mail);
|
/plugin/statistics/ |
H A D | db.sql | 168 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 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-au/db/ |
H A D | update0006.sql | 1 CREATE INDEX idx_class ON pages(class); 2 CREATE INDEX idx_pid ON dataau(pid);
|
H A D | update0001.sql | 2 CREATE INDEX idx_key ON dataau(key); 4 CREATE UNIQUE INDEX idx_page ON pages(page);
|
/plugin/data/db/ |
H A D | update0006.sql | 1 CREATE INDEX idx_class ON pages (class); 2 CREATE INDEX idx_pid ON data (pid);
|
H A D | update0001.sql | 8 CREATE INDEX idx_key ON data (key); 15 CREATE UNIQUE INDEX idx_page ON pages (page);
|
/plugin/bibtex4dw/db/ |
H A D | update0001.sql | 3 CREATE UNIQUE INDEX idx_key ON bibtex(key); 4 CREATE UNIQUE INDEX idx_string ON strings(string);
|
/plugin/do/db/ |
H A 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/labeled/db/ |
H A D | update0001.sql | 3 CREATE INDEX idx_id ON labeled(id); 4 CREATE INDEX idx_name ON labels(name);
|
/plugin/strata/sql/ |
H A 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));
|
H A 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
|
H A 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/approve/db/ |
H A D | update0001.sql | 30 CREATE INDEX idx_revision_current 33 CREATE INDEX idx_page_maintainer
|
/plugin/bez/db/ |
H A D | update0001.sql | 29 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 D | update0001.sql | 40 CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken); 62 CREATE INDEX addressbookid_synctoken ON addressbookchanges (addressbookid, synctoken);
|
123