-
Notifications
You must be signed in to change notification settings - Fork 9
/
ext_tables.sql
134 lines (121 loc) · 4.59 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
#
# Table structure for table 'tx_l10nmgr_cfg'
#
CREATE TABLE tx_l10nmgr_cfg
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
title tinytext,
depth int(11) DEFAULT '0' NOT NULL,
pages text,
displaymode int(11) DEFAULT '0' NOT NULL,
tablelist text,
exclude mediumtext,
include mediumtext,
flexformdiff mediumtext,
metadata text,
sourceLangStaticId char(3) NOT NULL default '',
forcedSourceLanguage text,
onlyForcedSourceLanguage tinyint(4) DEFAULT '0',
incfcewithdefaultlanguage int(11) DEFAULT '0' NOT NULL,
filenameprefix tinytext,
overrideexistingtranslations tinyint(4) DEFAULT '0',
pretranslatecontent tinyint(4) DEFAULT '0',
sortexports tinyint(4) DEFAULT '0',
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'sys_refindex'
#
CREATE TABLE tx_l10nmgr_index
(
hash varchar(32) DEFAULT '' NOT NULL,
tablename varchar(64) DEFAULT '' NOT NULL,
recuid int(11) DEFAULT '0' NOT NULL,
recpid int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
translation_lang int(11) DEFAULT '0' NOT NULL,
translation_recuid int(11) DEFAULT '0' NOT NULL,
workspace int(11) DEFAULT '0' NOT NULL,
serializedDiff mediumblob,
flag_new int(11) DEFAULT '0' NOT NULL,
flag_unknown int(11) DEFAULT '0' NOT NULL,
flag_noChange int(11) DEFAULT '0' NOT NULL,
flag_update int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (hash),
KEY lookup_rec (tablename, recuid, translation_lang, workspace),
KEY lookup_pid (recpid, translation_lang, workspace)
);
#
# Table structure for table 'tx_l10nmgr_priorities'
#
CREATE TABLE tx_l10nmgr_priorities
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title tinytext,
description text,
languages blob,
element blob,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_l10nmgr_exportdata'
#
CREATE TABLE tx_l10nmgr_exportdata
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
l10ncfg_id int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
title tinytext,
source_lang varchar(40) DEFAULT '' NOT NULL,
translation_lang varchar(40) DEFAULT '' NOT NULL,
tablelist text,
exportType blob,
filename text,
PRIMARY KEY (uid)
);
#
# Extend Table structure for table 'pages'
#
CREATE TABLE pages
(
l10nmgr_configuration tinyint(4) DEFAULT '0' NOT NULL,
l10nmgr_configuration_next_level tinyint(4) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'sys_language_l10nmgr_language_restricted_record_mm'
#
CREATE TABLE sys_language_l10nmgr_language_restricted_record_mm
(
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(255) DEFAULT '' NOT NULL,
fieldname varchar(255) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local_foreign (uid_local, uid_foreign),
KEY uid_foreign_tablefield (uid_foreign, tablenames(40), fieldname(3), sorting_foreign)
);
#
# Extend Table structure for table 'sys_language'
#
CREATE TABLE sys_language (
static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
description text,
);