| Index: branches/wmf/1.16wmf4/extensions/GlobalUsage/patches/patch-globalimagelinks_wiki_nsid_title.sql |
| — | — | @@ -0,0 +1,7 @@ |
| | 2 | +-- |
| | 3 | +-- Add the globalimagelinks_wiki_nsid_title index |
| | 4 | +-- |
| | 5 | + |
| | 6 | +CREATE INDEX globalimagelinks_wiki_nsid_title |
| | 7 | + ON /*_*/globalimagelinks (gil_wiki, gil_page_namespace_id, gil_page_title); |
| | 8 | + |
| Property changes on: branches/wmf/1.16wmf4/extensions/GlobalUsage/patches/patch-globalimagelinks_wiki_nsid_title.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 9 | + native |
| Index: branches/wmf/1.16wmf4/extensions/CodeReview/archives/code_signoffs.sql |
| — | — | @@ -0,0 +1,21 @@ |
| | 2 | +CREATE TABLE /*_*/code_signoffs ( |
| | 3 | + -- Repository ID and revision ID |
| | 4 | + cs_repo_id int not null, |
| | 5 | + cs_rev_id int not null, |
| | 6 | + |
| | 7 | + -- User that signed off |
| | 8 | + cs_user int not null, |
| | 9 | + cs_user_text varchar(255) not null, |
| | 10 | + |
| | 11 | + -- Type of signoff. Current values: 'inspected', 'tested' |
| | 12 | + -- See CodeRevision::getPossibleFlags() (in backend/CodeRevision.php) for most up to date list |
| | 13 | + cs_flag varchar(25) not null, |
| | 14 | + |
| | 15 | + -- Timestamp of the sign-off |
| | 16 | + cs_timestamp binary(14) not null default '', |
| | 17 | + |
| | 18 | + -- Timestamp the sign-off was struck, or Block::infinity() if not struck |
| | 19 | + cs_timestamp_struck varbinary(14) not null default 'infinity' |
| | 20 | +) /*$wgDBTableOptions*/; |
| | 21 | +CREATE UNIQUE INDEX /*i*/cs_repo_rev_user_flag_tstruck ON /*_*/code_signoffs (cs_repo_id, cs_rev_id, cs_user_text, cs_flag, cs_timestamp_struck); |
| | 22 | +CREATE INDEX /*i*/cs_repo_repo_rev_timestamp ON /*_*/code_signoffs (cs_repo_id, cs_rev_id, cs_timestamp); |
| Property changes on: branches/wmf/1.16wmf4/extensions/CodeReview/archives/code_signoffs.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 23 | + native |