update-keys.sql 1.5 KB

1234567891011121314151617181920212223242526272829
  1. -- SQL to insert update keys into the initial tables after a
  2. -- fresh installation of MediaWiki's database.
  3. -- This is read and executed by the install script; you should
  4. -- not have to run it by itself unless doing a manual install.
  5. -- Insert keys here if either the unnecessary would cause heavy
  6. -- processing or could potentially cause trouble by lowering field
  7. -- sizes, adding constraints, etc.
  8. -- When adjusting field sizes, it is recommended removing old
  9. -- patches but to play safe, update keys should also inserted here.
  10. -- This is a shared file used for both MySQL and SQLite installs.
  11. -- Therefore inserting multiple values is not possible using the
  12. -- INSERT INTO VALUES syntax.
  13. --
  14. --
  15. -- The /*_*/ comments in this and other files are
  16. -- replaced with the defined table prefix by the installer
  17. -- and updater scripts. If you are installing or running
  18. -- updates manually, you will need to manually insert the
  19. -- table prefix if any when running these scripts.
  20. --
  21. INSERT IGNORE INTO /*_*/updatelog
  22. SELECT 'filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql' AS ul_key, null as ul_value
  23. UNION SELECT 'image-img_major_mime-patch-img_major_mime-chemical.sql', null
  24. UNION SELECT 'oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', null
  25. UNION SELECT 'user_groups-ug_group-patch-ug_group-length-increase-255.sql', null
  26. UNION SELECT 'user_former_groups-ufg_group-patch-ufg_group-length-increase-255.sql', null
  27. UNION SELECT 'user_properties-up_property-patch-up_property.sql', null;