-
Notifications
You must be signed in to change notification settings - Fork 2
/
ext_tables.sql
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_hellurl_pathcache'
#
CREATE TABLE tx_hellurl_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_hellurl_uniqalias'
#
CREATE TABLE tx_hellurl_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_hellurl01 (field_alias(20),field_id,value_id,lang,expire),
KEY bk_hellurl02 (tablename(32),field_alias(20),field_id,value_alias(20),expire)
);
#
# Table structure for table 'tx_hellurl_chashcache'
#
CREATE TABLE tx_hellurl_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_hellurl_urldecodecache'
# Cache for Speaking URLS when translated to internal GET vars.
# Flushable
#
CREATE TABLE tx_hellurl_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_hellurl_urlencodecache'
#
CREATE TABLE tx_hellurl_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_hellurl_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_hellurl_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_hellurl_pathsegment varchar(255) DEFAULT '' NOT NULL,
tx_hellurl_pathoverride int(1) DEFAULT '0' NOT NULL,
tx_hellurl_exclude int(1) DEFAULT '0' NOT NULL,
tx_hellurl_nocache int(1) DEFAULT '0' NOT NULL
);
#
# Modifying pages_language_overlay table
#
CREATE TABLE pages_language_overlay (
tx_hellurl_pathsegment varchar(255) DEFAULT '' NOT NULL
);
#
# Modifying sys_domain table
#
CREATE TABLE sys_domain (
KEY tx_hellurl (domainName,hidden)
);
#
# Modifying sys_template table
#
CREATE TABLE sys_template (
KEY tx_hellurl (root,hidden)
);