-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
97 lines (87 loc) · 4.04 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
#
# Table structure for table 'tx_nrtextdb_domain_model_environment'
#
CREATE TABLE tx_nrtextdb_domain_model_environment
(
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,
deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY environment (name, pid, deleted),
KEY parent (pid, deleted, hidden),
KEY default_index (name, pid, deleted, hidden, starttime, endtime)
);
#
# Table structure for table 'tx_nrtextdb_domain_model_component'
#
CREATE TABLE tx_nrtextdb_domain_model_component
(
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,
deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY component (name, pid, deleted),
KEY parent (pid, deleted, hidden),
KEY default_index (name, pid, deleted, hidden, starttime, endtime)
);
#
# Table structure for table 'tx_nrtextdb_domain_model_type'
#
CREATE TABLE tx_nrtextdb_domain_model_type
(
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,
deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY type (name, pid, deleted),
KEY parent (pid, deleted, hidden),
KEY default_index (name, pid, deleted, hidden, starttime, endtime)
);
#
# Table structure for table 'tx_nrtextdb_domain_model_translation'
#
CREATE TABLE tx_nrtextdb_domain_model_translation
(
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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
l10n_source int(11) DEFAULT '0' NOT NULL,
deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
environment int(10) unsigned DEFAULT '0',
component int(10) unsigned DEFAULT '0',
type int(10) unsigned DEFAULT '0',
placeholder varchar(255) DEFAULT '' NOT NULL,
value varchar(2000) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY translation (sys_language_uid, pid, environment, component, type, placeholder, deleted),
KEY parent (pid, deleted, hidden),
KEY default_index (placeholder, pid, type, component, sys_language_uid, deleted),
KEY translated (placeholder, pid, type, component, sys_language_uid, deleted, l10n_parent),
KEY subquery (sys_language_uid, deleted, l10n_parent, hidden),
KEY sys_language_uid_l10n_parent (sys_language_uid, l10n_parent)
);