User:VasilievVV/interproject.sql

CREATE TABLE /*_*/interprojlink_types (
  iplt_code varchar(64) NOT NULL,
  iplt_title blob NOT NULL,
  iplt_url blob NOT NULL,
  
  UNIQUE INDEX iplt_code (iplt_code)
) /*$wgDBTableOptions*/;

CREATE TABLE /*_*/interprojlinks (
  ipl_from int unsigned NOT NULL default 0,
  ipl_code varchar(64) NOT NULL default '',
  ipl_title varchar(255) binary NOT NULL default '',
  INDEX ipl_from(ipl_from),
  UNIQUE INDEX ipl_fromcode(ipl_from,ipl_code),
  INDEX ipl_codetitle(ipl_code,ipl_title)
) /*$wgDBTableOptions*/;