snowbabel/ext_tables.sql at development · snowflakech/snowbabel · GitHub

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
#
# Add field to table 'be_groups'
#
CREATE TABLE be_groups (
	tx_snowbabel_extensions TEXT,
	tx_snowbabel_languages TEXT
);

#
# Add field to table 'be_users'
#
CREATE TABLE be_users (
	tx_snowbabel_extensions TEXT,
	tx_snowbabel_languages TEXT
);

#
# Add field to table 'static_languages'
#
CREATE TABLE static_languages (
	tx_snowbabel_override_language_key varchar(5) DEFAULT NULL
);

CREATE TABLE tx_snowbabel_users (
 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 tinyint(4) DEFAULT '0' NOT NULL,
	be_users_uid int(11) DEFAULT '0' NOT NULL,
	SelectedLanguages varchar(255) DEFAULT '0' NOT NULL,
	ShowColumnLabel tinyint(4) DEFAULT '1' NOT NULL,
	ShowColumnDefault tinyint(4) DEFAULT '1' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_temp (
	TableId int(11) DEFAULT '0' NOT NULL
);

CREATE TABLE tx_snowbabel_indexing_extensions_0 (
	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,

	ExtensionKey tinytext NOT NULL,
	ExtensionTitle tinytext NOT NULL,
	ExtensionDescription text,
	ExtensionCategory tinytext NOT NULL,
	ExtensionIcon tinytext NOT NULL,
	ExtensionLocation tinytext NOT NULL,
	ExtensionPath text,
	ExtensionLoaded tinyint(4) DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_extensions_1 (
	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,

	ExtensionKey tinytext NOT NULL,
	ExtensionTitle tinytext NOT NULL,
	ExtensionDescription text,
	ExtensionCategory tinytext NOT NULL,
	ExtensionIcon tinytext NOT NULL,
	ExtensionLocation tinytext NOT NULL,
	ExtensionPath text,
	ExtensionLoaded tinyint(4) DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_files_0 (
	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,

	ExtensionId int(11) DEFAULT '0' NOT NULL,
	FileKey tinytext NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_files_1 (
	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,

	ExtensionId int(11) DEFAULT '0' NOT NULL,
	FileKey tinytext NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_labels_0 (
	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,

	FileId int(11) DEFAULT '0' NOT NULL,
	LabelName tinytext NOT NULL,
	LabelDefault text,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_labels_1 (
	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,

	FileId int(11) DEFAULT '0' NOT NULL,
	LabelName tinytext NOT NULL,
	LabelDefault text,

	PRIMARY KEY (uid),
	KEY parent (pid)
);

CREATE TABLE tx_snowbabel_indexing_translations_0 (
	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,

	LabelId int(11) DEFAULT '0' NOT NULL,
	TranslationValue text,
	TranslationLanguage tinytext NOT NULL,
	TranslationEmpty tinyint(4) DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid),
	KEY labellang (LabelId,TranslationLanguage(4))
);

CREATE TABLE tx_snowbabel_indexing_translations_1 (
	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,

	LabelId int(11) DEFAULT '0' NOT NULL,
	TranslationValue text,
	TranslationLanguage tinytext NOT NULL,
	TranslationEmpty tinyint(4) DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid),
	KEY labellang (LabelId,TranslationLanguage(4))
);