/* =================================================================================================================================
*
* IF YOU ARE MOVING YOUR IMPRESSPAGES TO DEMOTIC CMS THIS SQL FILE HAS THE MySQL COMMANDS TO DO JUST THAT
* FOLLOW THESE INSTRUCTIONS CAREFULLY
* NOTE: BACKUP YOUR ENTIRE IMPRESSPAGES DATABASE BEFORE RUNNING THESE STATEMENTS
* DIFFICULTY: INTERMEDIATE DB ADMIN
*
===================================================================================================================================*/


/*
* INSTUCTION 1
* UPDATE PLUGIN KEY (VERY IMPORTANT)
* IF YOUR STORAGE TABLE IS NOT `ip_storage` REPLACE WITH THE APPROPRIATE TABLE NAME
*/
UPDATE `ip_storage` SET `plugin` = 'Demotic' WHERE `dm_storage`.`plugin` = 'Ip';

/*
* INSTUCTION 2
* UPDATE RESERVED DIRECTORIES KEY (VERY IMPORTANT)
* IF YOUR STORAGE TABLE IS NOT `ip_storage` REPLACE WITH THE APPROPRIATE TABLE NAME
*/
UPDATE `ip_storage` SET `value` = '[\"file\",\"install\",\"Demotic\",\"Plugin\",\"update\",\"Theme\",\"index.php\",\"admin\",\"admin.php\"]' WHERE `dm_storage`.`plugin` = 'Config' AND `dm_storage`.`key` = 'Config.reservedDirs'; 