Bug #80311 » typo3_2017-03-18.sql

Georg Ringer, 2017-03-18 07:40

 
1
# ************************************************************
2
# Sequel Pro SQL dump
3
# Version 4541
4
#
5
# http://www.sequelpro.com/
6
# https://github.com/sequelpro/sequelpro
7
#
8
# Host: 192.168.56.2 (MySQL 5.6.30-log)
9
# Datenbank: typo3
10
# Erstellt am: 2017-03-18 06:39:28 +0000
11
# ************************************************************
12

    
13

    
14
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17
/*!40101 SET NAMES utf8 */;
18
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21

    
22

    
23
# Export von Tabelle tx_powermail_domain_model_answer
24
# ------------------------------------------------------------
25

    
26
DROP TABLE IF EXISTS `tx_powermail_domain_model_answer`;
27

    
28
CREATE TABLE `tx_powermail_domain_model_answer` (
29
  `uid` int(11) NOT NULL AUTO_INCREMENT,
30
  `pid` int(11) NOT NULL DEFAULT '0',
31
  `mail` int(10) unsigned NOT NULL DEFAULT '0',
32
  `value` text COLLATE utf8_unicode_ci NOT NULL,
33
  `value_type` int(10) unsigned NOT NULL DEFAULT '0',
34
  `field` int(10) unsigned NOT NULL DEFAULT '0',
35
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
36
  `crdate` int(10) unsigned NOT NULL DEFAULT '0',
37
  `cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
38
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
39
  `hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
40
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
41
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
42
  `t3ver_oid` int(11) NOT NULL DEFAULT '0',
43
  `t3ver_id` int(11) NOT NULL DEFAULT '0',
44
  `t3ver_wsid` int(11) NOT NULL DEFAULT '0',
45
  `t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
46
  `t3ver_state` smallint(6) NOT NULL DEFAULT '0',
47
  `t3ver_stage` int(11) NOT NULL DEFAULT '0',
48
  `t3ver_count` int(11) NOT NULL DEFAULT '0',
49
  `t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
50
  `t3ver_move_id` int(11) NOT NULL DEFAULT '0',
51
  `t3_origuid` int(11) NOT NULL DEFAULT '0',
52
  `sys_language_uid` int(11) NOT NULL DEFAULT '0',
53
  `l10n_parent` int(11) NOT NULL DEFAULT '0',
54
  `l10n_diffsource` mediumblob,
55
  `l10n_state` text COLLATE utf8_unicode_ci,
56
  PRIMARY KEY (`uid`),
57
  KEY `parent` (`pid`),
58
  KEY `mail` (`mail`),
59
  KEY `deleted` (`deleted`),
60
  KEY `hidden` (`hidden`),
61
  KEY `starttime` (`starttime`),
62
  KEY `endtime` (`endtime`),
63
  KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
64
  KEY `language` (`l10n_parent`,`sys_language_uid`)
65
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
66

    
67

    
68

    
69
# Export von Tabelle tx_powermail_domain_model_field
70
# ------------------------------------------------------------
71

    
72
DROP TABLE IF EXISTS `tx_powermail_domain_model_field`;
73

    
74
CREATE TABLE `tx_powermail_domain_model_field` (
75
  `uid` int(11) NOT NULL AUTO_INCREMENT,
76
  `pid` int(11) NOT NULL DEFAULT '0',
77
  `pages` int(10) unsigned NOT NULL DEFAULT '0',
78
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
79
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
80
  `settings` text COLLATE utf8_unicode_ci NOT NULL,
81
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
82
  `content_element` int(11) NOT NULL DEFAULT '0',
83
  `text` text COLLATE utf8_unicode_ci NOT NULL,
84
  `prefill_value` text COLLATE utf8_unicode_ci NOT NULL,
85
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
86
  `create_from_typoscript` text COLLATE utf8_unicode_ci NOT NULL,
87
  `validation` int(11) NOT NULL DEFAULT '0',
88
  `validation_configuration` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
89
  `css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
90
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
91
  `multiselect` smallint(5) unsigned NOT NULL DEFAULT '0',
92
  `datepicker_settings` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
93
  `feuser_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
94
  `sender_email` smallint(5) unsigned NOT NULL DEFAULT '0',
95
  `sender_name` smallint(5) unsigned NOT NULL DEFAULT '0',
96
  `mandatory` smallint(5) unsigned NOT NULL DEFAULT '0',
97
  `own_marker_select` smallint(5) unsigned NOT NULL DEFAULT '0',
98
  `marker` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
99
  `auto_marker` smallint(5) unsigned NOT NULL DEFAULT '0',
100
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
101
  `crdate` int(10) unsigned NOT NULL DEFAULT '0',
102
  `cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
103
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
104
  `hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
105
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
106
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
107
  `sorting` int(11) NOT NULL DEFAULT '0',
108
  `t3ver_oid` int(11) NOT NULL DEFAULT '0',
109
  `t3ver_id` int(11) NOT NULL DEFAULT '0',
110
  `t3ver_wsid` int(11) NOT NULL DEFAULT '0',
111
  `t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
112
  `t3ver_state` smallint(6) NOT NULL DEFAULT '0',
113
  `t3ver_stage` int(11) NOT NULL DEFAULT '0',
114
  `t3ver_count` int(11) NOT NULL DEFAULT '0',
115
  `t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
116
  `t3ver_move_id` int(11) NOT NULL DEFAULT '0',
117
  `t3_origuid` int(11) NOT NULL DEFAULT '0',
118
  `sys_language_uid` int(11) NOT NULL DEFAULT '0',
119
  `l10n_parent` int(11) NOT NULL DEFAULT '0',
120
  `l10n_diffsource` mediumblob,
121
  `l10n_state` text COLLATE utf8_unicode_ci,
122
  PRIMARY KEY (`uid`),
123
  KEY `parent` (`pid`),
124
  KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
125
  KEY `language` (`l10n_parent`,`sys_language_uid`)
126
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
127

    
128
LOCK TABLES `tx_powermail_domain_model_field` WRITE;
129
/*!40000 ALTER TABLE `tx_powermail_domain_model_field` DISABLE KEYS */;
130

    
131
INSERT INTO `tx_powermail_domain_model_field` (`uid`, `pid`, `pages`, `title`, `type`, `settings`, `path`, `content_element`, `text`, `prefill_value`, `placeholder`, `create_from_typoscript`, `validation`, `validation_configuration`, `css`, `description`, `multiselect`, `datepicker_settings`, `feuser_value`, `sender_email`, `sender_name`, `mandatory`, `own_marker_select`, `marker`, `auto_marker`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `sorting`, `t3ver_oid`, `t3ver_id`, `t3ver_wsid`, `t3ver_label`, `t3ver_state`, `t3ver_stage`, `t3ver_count`, `t3ver_tstamp`, `t3ver_move_id`, `t3_origuid`, `sys_language_uid`, `l10n_parent`, `l10n_diffsource`, `l10n_state`)
132
VALUES
133
	(1,138,1,'field 1','input','','',0,'','','','',0,'','','',0,'','',0,0,0,0,'field1',0,1489702910,1489702633,1,0,0,0,0,1,0,0,0,'',0,0,0,0,0,0,0,0,X'613A313A7B733A363A2268696464656E223B4E3B7D',NULL),
134
	(2,138,1,'field 1 translated','input','','',0,'','','','',0,'','','',0,'','',0,0,0,0,'field1',0,1489702910,1489702662,1,0,0,0,0,2,0,0,0,'',0,0,0,0,0,1,3,1,X'613A32343A7B733A353A227469746C65223B733A373A226669656C642031223B733A343A2274797065223B733A353A22696E707574223B733A31323A2273656E6465725F656D61696C223B693A303B733A31313A2273656E6465725F6E616D65223B693A303B733A393A226D616E6461746F7279223B693A303B733A31303A2276616C69646174696F6E223B693A303B733A31333A2270726566696C6C5F76616C7565223B733A303A22223B733A31313A22706C616365686F6C646572223B733A303A22223B733A31323A226665757365725F76616C7565223B733A303A22223B733A333A22637373223B733A303A22223B733A31313A226465736372697074696F6E223B733A303A22223B733A31373A226F776E5F6D61726B65725F73656C656374223B693A303B733A31363A227379735F6C616E67756167655F756964223B693A303B733A363A2268696464656E223B693A303B733A393A22737461727474696D65223B693A303B733A373A22656E6474696D65223B693A303B733A31313A226C31306E5F706172656E74223B693A303B733A343A2270617468223B733A303A22223B733A32343A2276616C69646174696F6E5F636F6E66696775726174696F6E223B733A303A22223B733A31313A226D756C746973656C656374223B693A303B733A31393A22646174657069636B65725F73657474696E6773223B733A303A22223B733A31313A226175746F5F6D61726B6572223B693A303B733A363A226D61726B6572223B733A363A226669656C6431223B733A353A227061676573223B693A313B7D',NULL);
135

    
136
/*!40000 ALTER TABLE `tx_powermail_domain_model_field` ENABLE KEYS */;
137
UNLOCK TABLES;
138

    
139

    
140
# Export von Tabelle tx_powermail_domain_model_form
141
# ------------------------------------------------------------
142

    
143
DROP TABLE IF EXISTS `tx_powermail_domain_model_form`;
144

    
145
CREATE TABLE `tx_powermail_domain_model_form` (
146
  `uid` int(11) NOT NULL AUTO_INCREMENT,
147
  `pid` int(11) NOT NULL DEFAULT '0',
148
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
149
  `note` smallint(5) unsigned NOT NULL DEFAULT '0',
150
  `css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
151
  `pages` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
152
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
153
  `crdate` int(10) unsigned NOT NULL DEFAULT '0',
154
  `cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
155
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
156
  `hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
157
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
158
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
159
  `is_dummy_record` smallint(6) NOT NULL DEFAULT '0',
160
  `t3ver_oid` int(11) NOT NULL DEFAULT '0',
161
  `t3ver_id` int(11) NOT NULL DEFAULT '0',
162
  `t3ver_wsid` int(11) NOT NULL DEFAULT '0',
163
  `t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
164
  `t3ver_state` smallint(6) NOT NULL DEFAULT '0',
165
  `t3ver_stage` int(11) NOT NULL DEFAULT '0',
166
  `t3ver_count` int(11) NOT NULL DEFAULT '0',
167
  `t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
168
  `t3ver_move_id` int(11) NOT NULL DEFAULT '0',
169
  `t3_origuid` int(11) NOT NULL DEFAULT '0',
170
  `sys_language_uid` int(11) NOT NULL DEFAULT '0',
171
  `l10n_parent` int(11) NOT NULL DEFAULT '0',
172
  `l10n_diffsource` mediumblob,
173
  `l10n_state` text COLLATE utf8_unicode_ci,
174
  PRIMARY KEY (`uid`),
175
  KEY `parent` (`pid`),
176
  KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
177
  KEY `language` (`l10n_parent`,`sys_language_uid`)
178
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
179

    
180
LOCK TABLES `tx_powermail_domain_model_form` WRITE;
181
/*!40000 ALTER TABLE `tx_powermail_domain_model_form` DISABLE KEYS */;
182

    
183
INSERT INTO `tx_powermail_domain_model_form` (`uid`, `pid`, `title`, `note`, `css`, `pages`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `is_dummy_record`, `t3ver_oid`, `t3ver_id`, `t3ver_wsid`, `t3ver_label`, `t3ver_state`, `t3ver_stage`, `t3ver_count`, `t3ver_tstamp`, `t3ver_move_id`, `t3_origuid`, `sys_language_uid`, `l10n_parent`, `l10n_diffsource`, `l10n_state`)
184
VALUES
185
	(1,138,'form 1',0,'','1',1489702910,1489702633,1,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,0,0,X'613A383A7B733A353A227469746C65223B4E3B733A353A227061676573223B4E3B733A343A226E6F7465223B4E3B733A333A22637373223B4E3B733A31363A227379735F6C616E67756167655F756964223B4E3B733A363A2268696464656E223B4E3B733A393A22737461727474696D65223B4E3B733A373A22656E6474696D65223B4E3B7D',NULL),
186
	(2,138,'form 1 trans',0,'','1',1489702685,1489702662,1,0,0,0,0,0,0,0,0,'',0,0,0,0,0,1,3,1,X'613A393A7B733A353A227469746C65223B733A363A22666F726D2031223B733A353A227061676573223B733A313A2231223B733A333A22637373223B733A303A22223B733A31363A227379735F6C616E67756167655F756964223B693A303B733A363A2268696464656E223B693A303B733A393A22737461727474696D65223B693A303B733A373A22656E6474696D65223B693A303B733A31313A226C31306E5F706172656E74223B693A303B733A343A226E6F7465223B693A303B7D',NULL);
187

    
188
/*!40000 ALTER TABLE `tx_powermail_domain_model_form` ENABLE KEYS */;
189
UNLOCK TABLES;
190

    
191

    
192
# Export von Tabelle tx_powermail_domain_model_page
193
# ------------------------------------------------------------
194

    
195
DROP TABLE IF EXISTS `tx_powermail_domain_model_page`;
196

    
197
CREATE TABLE `tx_powermail_domain_model_page` (
198
  `uid` int(11) NOT NULL AUTO_INCREMENT,
199
  `pid` int(11) NOT NULL DEFAULT '0',
200
  `forms` int(10) unsigned NOT NULL DEFAULT '0',
201
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
202
  `css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
203
  `fields` int(10) unsigned NOT NULL DEFAULT '0',
204
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
205
  `crdate` int(10) unsigned NOT NULL DEFAULT '0',
206
  `cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
207
  `deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
208
  `hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
209
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
210
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
211
  `sorting` int(11) NOT NULL DEFAULT '0',
212
  `t3ver_oid` int(11) NOT NULL DEFAULT '0',
213
  `t3ver_id` int(11) NOT NULL DEFAULT '0',
214
  `t3ver_wsid` int(11) NOT NULL DEFAULT '0',
215
  `t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
216
  `t3ver_state` smallint(6) NOT NULL DEFAULT '0',
217
  `t3ver_stage` int(11) NOT NULL DEFAULT '0',
218
  `t3ver_count` int(11) NOT NULL DEFAULT '0',
219
  `t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
220
  `t3ver_move_id` int(11) NOT NULL DEFAULT '0',
221
  `t3_origuid` int(11) NOT NULL DEFAULT '0',
222
  `sys_language_uid` int(11) NOT NULL DEFAULT '0',
223
  `l10n_parent` int(11) NOT NULL DEFAULT '0',
224
  `l10n_diffsource` mediumblob,
225
  `l10n_state` text COLLATE utf8_unicode_ci,
226
  PRIMARY KEY (`uid`),
227
  KEY `parent` (`pid`),
228
  KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
229
  KEY `language` (`l10n_parent`,`sys_language_uid`)
230
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
231

    
232
LOCK TABLES `tx_powermail_domain_model_page` WRITE;
233
/*!40000 ALTER TABLE `tx_powermail_domain_model_page` DISABLE KEYS */;
234

    
235
INSERT INTO `tx_powermail_domain_model_page` (`uid`, `pid`, `forms`, `title`, `css`, `fields`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `sorting`, `t3ver_oid`, `t3ver_id`, `t3ver_wsid`, `t3ver_label`, `t3ver_state`, `t3ver_stage`, `t3ver_count`, `t3ver_tstamp`, `t3ver_move_id`, `t3_origuid`, `sys_language_uid`, `l10n_parent`, `l10n_diffsource`, `l10n_state`)
236
VALUES
237
	(1,138,1,'page1','',2,1489702910,1489702633,1,0,0,0,0,1,0,0,0,'',0,0,0,0,0,0,0,0,X'613A373A7B733A353A227469746C65223B4E3B733A363A226669656C6473223B4E3B733A333A22637373223B4E3B733A31363A227379735F6C616E67756167655F756964223B4E3B733A363A2268696464656E223B4E3B733A393A22737461727474696D65223B4E3B733A373A22656E6474696D65223B4E3B7D',NULL),
238
	(2,138,2,'page1 trnas','',1,1489702685,1489702662,1,0,0,0,0,1,0,0,0,'',0,0,0,0,0,1,3,1,X'613A383A7B733A353A227469746C65223B733A353A227061676531223B733A363A226669656C6473223B693A313B733A333A22637373223B733A303A22223B733A31363A227379735F6C616E67756167655F756964223B693A303B733A363A2268696464656E223B693A303B733A393A22737461727474696D65223B693A303B733A373A22656E6474696D65223B693A303B733A31313A226C31306E5F706172656E74223B693A303B7D',NULL);
239

    
240
/*!40000 ALTER TABLE `tx_powermail_domain_model_page` ENABLE KEYS */;
241
UNLOCK TABLES;
242

    
243

    
244

    
245
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
246
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
247
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
248
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
249
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
250
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
(2-2/2)