CRM/Upgrade/Incremental/sql/5.23.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.23.alpha1 during upgrade *}
   2 UPDATE civicrm_payment_processor SET is_default = 0 WHERE is_default IS NULL;
   3 UPDATE civicrm_payment_processor SET is_active = 1 WHERE is_active IS NULL;
   4 UPDATE civicrm_payment_processor SET is_test = 0 WHERE is_test IS NULL;
   5 UPDATE civicrm_payment_processor_type SET is_active = 1 WHERE is_active IS NULL;
   6 UPDATE civicrm_payment_processor_type SET is_default = 0 WHERE is_default IS NULL;
   7 ALTER TABLE civicrm_payment_processor ALTER COLUMN is_default SET DEFAULT 0;
   8 ALTER TABLE civicrm_payment_processor ALTER COLUMN is_active SET DEFAULT 1;
   9 ALTER TABLE civicrm_payment_processor ALTER COLUMN is_test SET DEFAULT 0;
  10 ALTER TABLE civicrm_payment_processor_type ALTER COLUMN is_active SET DEFAULT 1;
  11 ALTER TABLE civicrm_payment_processor_type ALTER COLUMN is_default SET DEFAULT 0;