ext_tables.sql

#
# Table structure for table 'tx_myredirects_domain_model_redirect'
#
CREATE TABLE tx_myredirects_domain_model_redirect (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) unsigned DEFAULT '0' NOT NULL,
    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    crdate int(11) unsigned DEFAULT '0' NOT NULL,
    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
    editlock tinyint(3) unsigned DEFAULT '0' NOT NULL,

    url_hash varchar(40) DEFAULT '',
    url text,
    destination text,
    last_referrer text,
    counter int(11) unsigned DEFAULT '0' NOT NULL,
    http_response int(11) DEFAULT '301' NOT NULL,
    domain int(11) unsigned DEFAULT '0' NOT NULL,
    root_page_domain varchar(100) DEFAULT '0-0' NOT NULL,
    backend_note text,
    active tinyint(3) unsigned DEFAULT '1' NOT NULL,
    last_hit int(11) unsigned DEFAULT '0' NOT NULL,
    last_checked int(11) unsigned DEFAULT '0' NOT NULL,
    inactive_reason text,

    PRIMARY KEY (uid),
    KEY parent (pid),
    UNIQUE KEY active (url_hash,pid,domain)
);