Scott Driscoll scottdriscoll
scottdriscoll
/ booklets_downgrade.sql
Last active
December 14, 2015 12:09
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- SQL Script to remove all booklet entries and schema. | |
| -- item.type range is 251 - 280 | |
| -- revrec sku cat ids are 92 - 121 | |
| -- Product types are 'booklets-85x11' and 'booklets-55x85' | |
| BEGIN; | |
| -- Delete Booklet entries from migration_log | |
| DELETE FROM migration_log WHERE patch_file IN ( | |
| 'option.sql', |
scottdriscoll
/ booklets_downgrade.sql
Last active
December 14, 2015 09:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- SQL Script to remove all booklet entries and schema. | |
| -- item.type range is 251 - 280 | |
| -- revrec sku cat ids are 92 - 121 | |
| -- Product types are 'booklets-85x11' and 'booklets-55x85' | |
| BEGIN; | |
| -- Delete Booklet entries from migration_log | |
| DELETE FROM migration_log WHERE patch_file IN ( | |
| 'option.sql', |