NOTE: Test on In-Portal with Custom module installed.
Part 1
- add these lines to /modules/custom/install/project_upgrades.sql file (empty line on top !)
# r2: Revision 2 SELECT UNIX_TIMESTAMP(); # r3: Revision 3 SELECT UNIX_TIMESTAMP();
- login to admin console as root
- go to Tools → System Tools section
- press Deploy button
- confirm you see message, that contains:
Upgrading Database ... # r1: Initial Project Task (#TASK_ID) # r2: Revision 2 SELECT UNIX_TIMESTAMP() ... OK (1) # r3: Revision 3 SELECT UNIX_TIMESTAMP() ... OK (1)
Part 2
- add these lines to /modules/custom/install/project_upgrades.sql file (empty line on top !)
# r2: Revision 2 (duplicated) SELECT UNIX_TIMESTAMP();
- press Deploy button again
- confirm you see message
Verifying Database Revisions ... FAILED Duplicate revision #2 found
Part 3
- replace these lines in /modules/custom/install/project_upgrades.sql file (empty line on top !)
# r2: Revision 2 (duplicated) SELECT UNIX_TIMESTAMP();
by (empty line on top !)
# r4: Revision 4 SELECT UNIX_TIMESTAMP(); # r4: Revision 4 (duplicated) SELECT UNIX_TIMESTAMP();
- press Deploy button again
- confirm you see message
Verifying Database Revisions ... FAILED Duplicate revision #4 found