| Index: trunk/extensions/CodeReview/codereview.sql |
| — | — | @@ -170,3 +170,29 @@ |
| 171 | 171 | key (cc_repo_id,cc_rev_id,cc_sortkey), |
| 172 | 172 | key cc_repo_time (cc_repo_id,cc_timestamp) |
| 173 | 173 | ) /*$wgDBTableOptions*/; |
| | 174 | + |
| | 175 | +-- |
| | 176 | +-- Changes to review metadata for a single code revision. |
| | 177 | +-- |
| | 178 | +CREATE TABLE /*$wgDBprefix*/code_prop_changes ( |
| | 179 | + -- Repository ID |
| | 180 | + cpc_repo_id int not null, |
| | 181 | + -- Native ID number of this revision within the repository. |
| | 182 | + cpc_rev_id int not null, |
| | 183 | + |
| | 184 | + -- The item that was changed |
| | 185 | + cpc_attrib enum('status','tags') not null, |
| | 186 | + -- How it was changed |
| | 187 | + cpc_removed blob, |
| | 188 | + cpc_added blob, |
| | 189 | + |
| | 190 | + -- Timestamp of the change, in MediaWiki format. |
| | 191 | + cpc_timestamp binary(14) not null default '', |
| | 192 | + |
| | 193 | + -- User id/name of the commentor |
| | 194 | + cpc_user int not null, |
| | 195 | + cpc_user_text varchar(255) not null, |
| | 196 | + |
| | 197 | + key cpc_repo_rev_time (cpc_repo_id, cpc_rev_id, cpc_timestamp), |
| | 198 | + key cpc_repo_time (cpc_repo_id, cpc_timestamp) |
| | 199 | +) /*$wgDBTableOptions*/; |