| Index: trunk/extensions/Review/Review.sql |
| — | — | @@ -10,6 +10,6 @@ |
| 11 | 11 | val_ip varchar(255) NOT NULL default '', |
| 12 | 12 | |
| 13 | 13 | PRIMARY KEY (val_id), |
| 14 | | - UNIQUE KEY (val_user,val_revision), |
| 15 | | - UNIQUE KEY (val_ip,val_revision) |
| | 14 | + UNIQUE KEY (val_user,val_revision,val_type), |
| | 15 | + UNIQUE KEY (val_ip,val_revision,val_type) |
| 16 | 16 | ) TYPE=InnoDB; |
| \ No newline at end of file |
| Index: trunk/extensions/Review/Review.pg.sql |
| — | — | @@ -15,4 +15,4 @@ |
| 16 | 16 | PRIMARY KEY (val_id) |
| 17 | 17 | ); |
| 18 | 18 | |
| 19 | | -CREATE INDEX validate_index ON validate(val_user,val_revision); |
| | 19 | +CREATE INDEX validate_index ON validate(val_user,val_revision,val_type); |