| Index: trunk/extensions/CodeReview/archives/code_signoffs.sql |
| — | — | @@ -12,7 +12,10 @@ |
| 13 | 13 | cs_flag varchar(25) not null, |
| 14 | 14 | |
| 15 | 15 | -- Timestamp of the sign-off |
| 16 | | - cs_timestamp binary(14) not null default '' |
| | 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' |
| 17 | 20 | ) /*$wgDBTableOptions*/; |
| 18 | | -CREATE UNIQUE INDEX /*i*/cs_repo_rev_user_flag ON /*_*/code_signoffs (cs_repo_id, cs_rev_id, cs_user_text, cs_flag); |
| | 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); |
| 19 | 22 | CREATE INDEX /*i*/cs_repo_repo_rev_timestamp ON /*_*/code_signoffs (cs_repo_id, cs_rev_id, cs_timestamp); |