update-keys.sql 1.5 KB

12345678910111213141516171819202122232425262728293031
  1. -- Update keys for Microsoft SQL Server
  2. -- SQL to insert update keys into the initial tables after a
  3. -- fresh installation of MediaWiki's database.
  4. -- This is read and executed by the install script; you should
  5. -- not have to run it by itself unless doing a manual install.
  6. -- Insert keys here if either the unnecessary would cause heavy
  7. -- processing or could potentially cause trouble by lowering field
  8. -- sizes, adding constraints, etc.
  9. -- When adjusting field sizes, it is recommended removing old
  10. -- patches but to play safe, update keys should also inserted here.
  11. --
  12. -- The /*_*/ comments in this and other files are
  13. -- replaced with the defined table prefix by the installer
  14. -- and updater scripts. If you are installing or running
  15. -- updates manually, you will need to manually insert the
  16. -- table prefix if any when running these scripts.
  17. --
  18. INSERT INTO /*_*/updatelog
  19. SELECT 'filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql' AS ul_key, null as ul_value
  20. UNION SELECT 'image-img_major_mime-patch-img_major_mime-chemical.sql', null
  21. UNION SELECT 'oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', null
  22. UNION SELECT 'cl_type-category_types-ck', null
  23. UNION SELECT 'fa_major_mime-major_mime-ck', null
  24. UNION SELECT 'fa_media_type-media_type-ck', null
  25. UNION SELECT 'img_major_mime-major_mime-ck', null
  26. UNION SELECT 'img_media_type-media_type-ck', null
  27. UNION SELECT 'oi_major_mime-major_mime-ck', null
  28. UNION SELECT 'oi_media_type-media_type-ck', null
  29. UNION SELECT 'us_media_type-media_type-ck', null;