Skip to content

Instantly share code, notes, and snippets.

@mikhailkozlov
Created September 10, 2013 19:22
Show Gist options
  • Save mikhailkozlov/6514292 to your computer and use it in GitHub Desktop.
Save mikhailkozlov/6514292 to your computer and use it in GitHub Desktop.
SI DB import clean up
-- set all user passwords to '[Mike Password]'
UPDATE users SET user_hash='md5('[Mike Password]')' WHERE user_name NOT IN ('mkozlov','portal','moofcart','bug_portal','case_portal2');
-- Update the mail settings so they don't e-mail users
UPDATE outbound_email set mail_smtptype = 'other', mail_sendtype = 'SMTP', mail_smtpserver = 'localhost',
mail_smtpport = '10026', mail_smtpauth_req = 0, mail_smtpssl = 2 WHERE type = 'system-override' OR user_id = '1';
-- Remove schedulers
UPDATE `schedulers` SET `deleted` = '1';
-- drop jobs
TRUNCATE TABLE `job_queue`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment