# ************************************************************ # 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 */;