tests/phpunit/includes/Storage/drop-pre-mcr-fields.sqlite.sql

   1 DROP TABLE /*_*/revision;
   2
   3 CREATE TABLE /*_*/revision (
   4   rev_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   5   rev_page INTEGER NOT NULL,
   6   rev_comment BLOB NOT NULL,
   7   rev_user INTEGER NOT NULL default 0,
   8   rev_user_text varchar(255) NOT NULL default '',
   9   rev_timestamp blob(14) NOT NULL default '',
  10   rev_minor_edit INTEGER NOT NULL default 0,
  11   rev_deleted INTEGER NOT NULL default 0,
  12   rev_len INTEGER unsigned,
  13   rev_parent_id INTEGER default NULL,
  14   rev_sha1 varbinary(32) NOT NULL default ''
  15 ) /*$wgDBTableOptions*/;