maintenance/archives/patch-content.sql

   1 --
   2 -- The content table represents content objects. It's primary purpose is to provide the necessary
   3 -- meta-data for loading and interpreting a serialized data blob to create a content object.
   4 --
   5 CREATE TABLE /*_*/content (
   6
   7   -- ID of the content object
   8   content_id bigint unsigned PRIMARY KEY AUTO_INCREMENT,
   9
  10   -- Nominal size of the content object (not necessarily of the serialized blob)
  11   content_size int unsigned NOT NULL,
  12
  13   -- Nominal hash of the content object (not necessarily of the serialized blob)
  14   content_sha1 varbinary(32) NOT NULL,
  15
  16   -- reference to model_id
  17   content_model smallint unsigned NOT NULL,
  18
  19   -- URL-like address of the content blob
  20   content_address varbinary(255) NOT NULL
  21 ) /*$wgDBTableOptions*/;