Skip to content

Instantly share code, notes, and snippets.

@nickvergessen

nickvergessen/gist:3155817

Created July 21, 2012 13:23
Show Gist options
  • Save nickvergessen/3155817 to your computer and use it in GitHub Desktop.
Save nickvergessen/3155817 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-12-todo' WHERE user_timezone = 'Etc/GMT-12';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-11-todo' WHERE user_timezone = 'Etc/GMT-11';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-10-todo' WHERE user_timezone = 'Etc/GMT-10';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-9-todo' WHERE user_timezone = 'Etc/GMT-9';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-8-todo' WHERE user_timezone = 'Etc/GMT-8';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-7-todo' WHERE user_timezone = 'Etc/GMT-7';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-6-todo' WHERE user_timezone = 'Etc/GMT-6';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-5-todo' WHERE user_timezone = 'Etc/GMT-5';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-4-todo' WHERE user_timezone = 'Etc/GMT-4';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-3-todo' WHERE user_timezone = 'Etc/GMT-3';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-2-todo' WHERE user_timezone = 'Etc/GMT-2';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-1-todo' WHERE user_timezone = 'Etc/GMT-1';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-12' WHERE user_timezone = 'Etc/GMT+12';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-11' WHERE user_timezone = 'Etc/GMT+11';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-10' WHERE user_timezone = 'Etc/GMT+10';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-9' WHERE user_timezone = 'Etc/GMT+9';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-8' WHERE user_timezone = 'Etc/GMT+8';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-7' WHERE user_timezone = 'Etc/GMT+7';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-6' WHERE user_timezone = 'Etc/GMT+6';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-5' WHERE user_timezone = 'Etc/GMT+5';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-4' WHERE user_timezone = 'Etc/GMT+4';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-3' WHERE user_timezone = 'Etc/GMT+3';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-2' WHERE user_timezone = 'Etc/GMT+2';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT-1' WHERE user_timezone = 'Etc/GMT+1';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+12' WHERE user_timezone = 'Etc/GMT-12-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+11' WHERE user_timezone = 'Etc/GMT-11-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+10' WHERE user_timezone = 'Etc/GMT-10-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+9' WHERE user_timezone = 'Etc/GMT-9-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+8' WHERE user_timezone = 'Etc/GMT-8-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+7' WHERE user_timezone = 'Etc/GMT-7-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+6' WHERE user_timezone = 'Etc/GMT-6-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+5' WHERE user_timezone = 'Etc/GMT-5-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+4' WHERE user_timezone = 'Etc/GMT-4-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+3' WHERE user_timezone = 'Etc/GMT-3-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+2' WHERE user_timezone = 'Etc/GMT-2-todo';
UPDATE phpbb_users SET user_timezone = 'Etc/GMT+1' WHERE user_timezone = 'Etc/GMT-1-todo';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment