Skip to content

Instantly share code, notes, and snippets.

@danpoltawski
Created December 5, 2011 15:17
Show Gist options
  • Save danpoltawski/1433924 to your computer and use it in GitHub Desktop.
Save danpoltawski/1433924 to your computer and use it in GitHub Desktop.
pre 1.5 upgrades
UPDATE mdl_user set lastip = '127.0.0.1' WHERE lastip IS NULL;
UPDATE mdl_user set city = 'London' WHERE city IS NULL;
UPDATE mdl_resource SET reference = course WHERE type = 'directory' AND reference IS NULL;
UPDATE mdl_resource SET reference = '' WHERE type = 'text' AND reference IS NULL;
UPDATE mdl_resource SET reference = '' WHERE type = 'html' AND reference IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment