-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·181 lines (159 loc) · 4.75 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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
#
# 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,
rootpage_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY tablename (tablename),
KEY bk_realurl01 (rootpage_id, field_alias(20),field_id,value_id,lang,expire),
KEY bk_realurl02 (rootpage_id, 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 (
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 (url_hash)
);
#
# 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,
tx_realurl_pathoverride int(1) DEFAULT '0' NOT NULL,
tx_realurl_exclude int(1) DEFAULT '0' 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)
);
#
# Table structure for table 'tx_realurl_cache'
#
CREATE TABLE tx_realurl_cache (
tstamp int(11) DEFAULT '0' NOT NULL,
mpvar tinytext NOT NULL,
workspace int(11) DEFAULT '0' NOT NULL,
rootpid int(11) DEFAULT '0' NOT NULL,
languageid int(11) DEFAULT '0' NOT NULL,
pageid int(11) DEFAULT '0' NOT NULL,
path text NOT NULL,
dirty tinyint(3) DEFAULT '0' NOT NULL
PRIMARY KEY (pageid,workspace,rootpid,languageid),
KEY `path_k` (path(100)),
KEY `path_branch_k` (rootpid,path(100)),
KEY `ws_lang_k` (workspace,languageid)
) ENGINE=InnoDB;
#
# Table structure for table 'tx_realurl_cachehistory'
#
CREATE TABLE tx_realurl_cachehistory (
uid int(11) NOT NULL auto_increment,
tstamp int(11) DEFAULT '0' NOT NULL,
mpvar tinytext NOT NULL,
workspace int(11) DEFAULT '0' NOT NULL,
rootpid int(11) DEFAULT '0' NOT NULL,
languageid int(11) DEFAULT '0' NOT NULL,
pageid int(11) DEFAULT '0' NOT NULL,
path text NOT NULL,
PRIMARY KEY (uid),
KEY `path_k` (path(100)),
KEY `path_branch_k` (rootpid,path(100)),
KEY `ws_lang_k` (workspace,languageid)
) ENGINE=InnoDB;