diff options
| author | Jeff Balogh <me@jeffbalogh.org> | 2010-06-11 03:00:56 (GMT) |
|---|---|---|
| committer | Jeff Balogh <me@jeffbalogh.org> | 2010-06-23 22:02:37 (GMT) |
| commit | 4dadc1d980cfc1655c19aec088aa99f7276db357 (patch) | |
| tree | d8f19a45caab3d331bb2d5a46991d89e0ad4d66e /migrations | |
| parent | 5bcfae394590ef2afcca8d87cd651b7a91f9ad8e (diff) | |
denormalize reviews.is_latest and reviews.prev_count for easy queries
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/47-reviews-cheat.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/migrations/47-reviews-cheat.sql b/migrations/47-reviews-cheat.sql new file mode 100644 index 0000000..fad237e --- /dev/null +++ b/migrations/47-reviews-cheat.sql @@ -0,0 +1,3 @@ +ALTER TABLE `reviews` + ADD COLUMN `previous_count` int(11) UNSIGNED DEFAULT 0, + ADD COLUMN `is_latest` bool DEFAULT 1; |