forked from felixsemmler/Realurl
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·141 lines (124 loc) · 3.6 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
#
# Table structure for table 'tx_realurl_pathcache'
#
CREATE TABLE tx_realurl_pathcache (
cache_id int(11) NOT NULL auto_increment,
page_id int(11) DEFAULT '0' NOT NULL,
language_id int(11) DEFAULT '0' NOT NULL,
rootpage_id int(11) DEFAULT '0' NOT NULL,
mpvar tinytext NOT NULL,
pagepath text NOT NULL,
expire int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (cache_id),
KEY pathq1 (rootpage_id,pagepath(32),expire),
KEY pathq2 (page_id,language_id,rootpage_id,expire),
KEY expire (expire)
) ENGINE=InnoDB;
#
# Table structure for table 'tx_realurl_uniqalias'
#
CREATE TABLE tx_realurl_uniqalias (
uid int(11) NOT NULL auto_increment,
tstamp int(11) DEFAULT '0' NOT NULL,
tablename varchar(255) DEFAULT '' NOT NULL,
field_alias varchar(255) DEFAULT '' NOT NULL,
field_id varchar(60) DEFAULT '' NOT NULL,
value_alias varchar(255) DEFAULT '' NOT NULL,
value_id int(11) DEFAULT '0' NOT NULL,
lang int(11) DEFAULT '0' NOT NULL,
expire int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY tablename (tablename),
KEY bk_realurl01 (field_alias(20),field_id,value_id,lang,expire),
KEY bk_realurl02 (tablename(32),field_alias(20),field_id,value_alias(20),expire)
);
#
# Table structure for table 'tx_realurl_chashcache'
#
CREATE TABLE tx_realurl_chashcache (
spurl_hash char(32) DEFAULT '' NOT NULL,
chash_string varchar(32) DEFAULT '' NOT NULL,
spurl_string text,
PRIMARY KEY (spurl_hash),
KEY chash_string (chash_string)
) ENGINE=InnoDB;
#
# Table structure for table 'tx_realurl_urldecodecache'
# Cache for Speaking URLS when translated to internal GET vars.
# Flushable
#
CREATE TABLE tx_realurl_urldecodecache (
url_hash char(32) DEFAULT '' NOT NULL,
spurl tinytext NOT NULL,
content blob NOT NULL,
page_id int(11) DEFAULT '0' NOT NULL,
rootpage_id int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (url_hash),
KEY page_id (page_id),
) ENGINE=InnoDB;
#
# Table structure for table 'tx_realurl_urlencodecache'
#
CREATE TABLE tx_realurl_urlencodecache (
url_hash char(32) DEFAULT '' NOT NULL,
origparams tinytext NOT NULL,
internalExtras tinytext NOT NULL,
content text NOT NULL,
page_id int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (url_hash),
KEY page_id (page_id)
) ENGINE=InnoDB;
CREATE TABLE tx_realurl_errorlog (
url_hash int(11) DEFAULT '0' NOT NULL,
url text NOT NULL,
error text NOT NULL,
last_referer text NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
cr_date int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
rootpage_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (url_hash,rootpage_id),
KEY counter (counter,tstamp)
);
CREATE TABLE tx_realurl_redirects (
uid int(11) NOT NULL auto_increment,
url_hash int(11) DEFAULT '0' NOT NULL,
url text NOT NULL,
destination text NOT NULL,
last_referer text NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
has_moved int(11) DEFAULT '0' NOT NULL,
domain_limit int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY sel01 (url_hash,domain_limit)
);
#
# Modifying pages table
#
CREATE TABLE pages (
tx_realurl_pathsegment varchar(255) DEFAULT '' NOT NULL,
tx_realurl_pathoverride int(1) DEFAULT '0' NOT NULL,
tx_realurl_exclude int(1) DEFAULT '0' NOT NULL,
tx_realurl_nocache int(1) DEFAULT '0' NOT NULL
);
#
# Modifying pages_language_overlay table
#
CREATE TABLE pages_language_overlay (
tx_realurl_pathsegment varchar(255) DEFAULT '' NOT NULL
);
#
# Modifying sys_domain table
#
CREATE TABLE sys_domain (
KEY tx_realurl (domainName,hidden)
);
#
# Modifying sys_template table
#
CREATE TABLE sys_template (
KEY tx_realurl (root,hidden)
);