[TASK] Deprecate various TSFE methods
[Packages/TYPO3.CMS.git] / typo3 / sysext / redirects / ext_tables.sql
1 #
2 # Table structure for table 'sys_redirect'
3 #
4 CREATE TABLE sys_redirect (
5 uid int(11) unsigned NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
7
8 source_host varchar(255) DEFAULT '' NOT NULL,
9 source_path varchar(255) DEFAULT '' NOT NULL,
10 is_regexp tinyint(1) unsigned DEFAULT '0' NOT NULL,
11
12 force_https tinyint(1) unsigned DEFAULT '0' NOT NULL,
13 keep_query_parameters tinyint(1) unsigned DEFAULT '0' NOT NULL,
14 target varchar(255) DEFAULT '' NOT NULL,
15 target_statuscode int(11) DEFAULT '0' NOT NULL,
16
17 hitcount int(11) DEFAULT '0' NOT NULL,
18 lasthiton int(11) DEFAULT '0' NOT NULL,
19 disable_hitcount tinyint(1) unsigned DEFAULT '0' NOT NULL,
20
21 createdby int(11) unsigned DEFAULT '0' NOT NULL,
22 createdon int(11) unsigned DEFAULT '0' NOT NULL,
23 updatedon int(11) unsigned DEFAULT '0' NOT NULL,
24 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
25 disabled tinyint(4) unsigned DEFAULT '0' NOT NULL,
26 starttime int(11) unsigned DEFAULT '0' NOT NULL,
27 endtime int(11) unsigned DEFAULT '0' NOT NULL,
28
29 PRIMARY KEY (uid),
30 KEY parent (pid),
31 KEY index_source (source_host,source_path)
32 );