tests/phpunit/tests/MediaWikiTestCaseSchemaTest.sql

   1 CREATE TABLE /*_*/MediaWikiTestCaseTestTable (
   2   id INT NOT NULL,
   3   name VARCHAR(20) NOT NULL,
   4   PRIMARY KEY (id)
   5 ) /*$wgDBTableOptions*/;
   6
   7 CREATE TABLE /*_*/imagelinks (
   8   il_from int NOT NULL DEFAULT 0,
   9   il_from_namespace int NOT NULL DEFAULT 0,
  10   il_to varchar(127) NOT NULL DEFAULT '',
  11   il_frobnitz varchar(127) NOT NULL DEFAULT 'FROB',
  12   PRIMARY KEY (il_from,il_to)
  13 ) /*$wgDBTableOptions*/;
  14
  15 ALTER TABLE /*_*/pagelinks
  16 ADD pl_frobnitz varchar(127) NOT NULL DEFAULT 'FROB';
  17
  18 DROP TABLE /*_*/oldimage;