|
# ************************************************************
|
|
# Sequel Pro SQL dump
|
|
# Version 4541
|
|
#
|
|
# http://www.sequelpro.com/
|
|
# https://github.com/sequelpro/sequelpro
|
|
#
|
|
# Host: 192.168.56.2 (MySQL 5.6.30-log)
|
|
# Datenbank: typo3
|
|
# Erstellt am: 2017-03-18 06:39:28 +0000
|
|
# ************************************************************
|
|
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
|
|
# Export von Tabelle tx_powermail_domain_model_answer
|
|
# ------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `tx_powermail_domain_model_answer`;
|
|
|
|
CREATE TABLE `tx_powermail_domain_model_answer` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`pid` int(11) NOT NULL DEFAULT '0',
|
|
`mail` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`value` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`value_type` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`field` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`t3ver_oid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_wsid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT '0',
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_count` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3_origuid` int(11) NOT NULL DEFAULT '0',
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_parent` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_diffsource` mediumblob,
|
|
`l10n_state` text COLLATE utf8_unicode_ci,
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`),
|
|
KEY `mail` (`mail`),
|
|
KEY `deleted` (`deleted`),
|
|
KEY `hidden` (`hidden`),
|
|
KEY `starttime` (`starttime`),
|
|
KEY `endtime` (`endtime`),
|
|
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
|
|
KEY `language` (`l10n_parent`,`sys_language_uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
|
|
|
|
# Export von Tabelle tx_powermail_domain_model_field
|
|
# ------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `tx_powermail_domain_model_field`;
|
|
|
|
CREATE TABLE `tx_powermail_domain_model_field` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`pid` int(11) NOT NULL DEFAULT '0',
|
|
`pages` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`settings` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`content_element` int(11) NOT NULL DEFAULT '0',
|
|
`text` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`prefill_value` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`placeholder` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`create_from_typoscript` text COLLATE utf8_unicode_ci NOT NULL,
|
|
`validation` int(11) NOT NULL DEFAULT '0',
|
|
`validation_configuration` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`multiselect` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`datepicker_settings` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`feuser_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`sender_email` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`sender_name` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`mandatory` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`own_marker_select` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`marker` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`auto_marker` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`sorting` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_oid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_wsid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT '0',
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_count` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3_origuid` int(11) NOT NULL DEFAULT '0',
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_parent` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_diffsource` mediumblob,
|
|
`l10n_state` text COLLATE utf8_unicode_ci,
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`),
|
|
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
|
|
KEY `language` (`l10n_parent`,`sys_language_uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
LOCK TABLES `tx_powermail_domain_model_field` WRITE;
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_field` DISABLE KEYS */;
|
|
|
|
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`)
|
|
VALUES
|
|
(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),
|
|
(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);
|
|
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_field` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
|
|
# Export von Tabelle tx_powermail_domain_model_form
|
|
# ------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `tx_powermail_domain_model_form`;
|
|
|
|
CREATE TABLE `tx_powermail_domain_model_form` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`pid` int(11) NOT NULL DEFAULT '0',
|
|
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`note` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`pages` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`is_dummy_record` smallint(6) NOT NULL DEFAULT '0',
|
|
`t3ver_oid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_wsid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT '0',
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_count` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3_origuid` int(11) NOT NULL DEFAULT '0',
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_parent` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_diffsource` mediumblob,
|
|
`l10n_state` text COLLATE utf8_unicode_ci,
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`),
|
|
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
|
|
KEY `language` (`l10n_parent`,`sys_language_uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
LOCK TABLES `tx_powermail_domain_model_form` WRITE;
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_form` DISABLE KEYS */;
|
|
|
|
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`)
|
|
VALUES
|
|
(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),
|
|
(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);
|
|
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_form` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
|
|
# Export von Tabelle tx_powermail_domain_model_page
|
|
# ------------------------------------------------------------
|
|
|
|
DROP TABLE IF EXISTS `tx_powermail_domain_model_page`;
|
|
|
|
CREATE TABLE `tx_powermail_domain_model_page` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`pid` int(11) NOT NULL DEFAULT '0',
|
|
`forms` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`css` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`fields` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`hidden` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`sorting` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_oid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_wsid` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT '0',
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_count` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int(11) NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int(11) NOT NULL DEFAULT '0',
|
|
`t3_origuid` int(11) NOT NULL DEFAULT '0',
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_parent` int(11) NOT NULL DEFAULT '0',
|
|
`l10n_diffsource` mediumblob,
|
|
`l10n_state` text COLLATE utf8_unicode_ci,
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`),
|
|
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
|
|
KEY `language` (`l10n_parent`,`sys_language_uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
LOCK TABLES `tx_powermail_domain_model_page` WRITE;
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_page` DISABLE KEYS */;
|
|
|
|
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`)
|
|
VALUES
|
|
(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),
|
|
(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);
|
|
|
|
/*!40000 ALTER TABLE `tx_powermail_domain_model_page` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
|
|
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
