[Summary view] [Print] [Text view]

   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  --
  13  -- The /*_*/ comments in this and other files are
  14  -- replaced with the defined table prefix by the installer
  15  -- and updater scripts. If you are installing or running
  16  -- updates manually, you will need to manually insert the
  17  -- table prefix if any when running these scripts.
  18  --
  19  
  20  INSERT INTO /*_*/updatelog
  21      SELECT 'filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql' AS ul_key, null as ul_value
  22      UNION SELECT 'image-img_major_mime-patch-img_major_mime-chemical.sql', null
  23      UNION SELECT 'oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', null
  24      UNION SELECT 'cl_type-category_types-ck', null
  25      UNION SELECT 'fa_major_mime-major_mime-ck', null
  26      UNION SELECT 'fa_media_type-media_type-ck', null
  27      UNION SELECT 'img_major_mime-major_mime-ck', null
  28      UNION SELECT 'img_media_type-media_type-ck', null
  29      UNION SELECT 'oi_major_mime-major_mime-ck', null
  30      UNION SELECT 'oi_media_type-media_type-ck', null
  31      UNION SELECT 'us_media_type-media_type-ck', null;