-- SQL tables for DMCANotice extension
 
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/dmca_notice (
  notice_id INT AUTO_INCREMENT PRIMARY KEY,
  notice_goodfaith BOOLEAN DEFAULT 0 NOT NULL,
  notice_infringingmaterial TEXT  NOT NULL,
  notice_mailingaddress TEXT NOT NULL,
  notice_originalmaterial TEXT NOT NULL,
  notice_penalty BOOLEAN DEFAULT 0 NOT NULL,
  notice_telephone VARCHAR(15) NOT NULL,
  notice_righttorelease BOOLEAN DEFAULT 0 NOT NULL,
  notice_status VARCHAR(16) NOT NULL,
  notice_timestamp VARCHAR(32) NOT NULL,
  notice_user INT(10) NOT NULL
) /*$wgDBTableOptions*/;
 
