-
Notifications
You must be signed in to change notification settings - Fork 192
Expand file tree
/
Copy pathext_tables.sql
More file actions
110 lines (99 loc) · 3.74 KB
/
Copy pathext_tables.sql
File metadata and controls
110 lines (99 loc) · 3.74 KB
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
#
# Table structure for table 'tx_powermail_domain_model_form'
#
CREATE TABLE tx_powermail_domain_model_form (
title varchar(255) DEFAULT '' NOT NULL,
note tinyint(4) unsigned DEFAULT '0' NOT NULL,
css varchar(255) DEFAULT '' NOT NULL,
pages varchar(255) DEFAULT '' NOT NULL,
autocomplete_token varchar(3) DEFAULT '' NOT NULL,
is_dummy_record tinyint(1) DEFAULT '0' NOT NULL,
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_powermail_domain_model_page'
#
CREATE TABLE tx_powermail_domain_model_page (
form int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
css varchar(255) DEFAULT '' NOT NULL,
fields int(11) unsigned DEFAULT '0' NOT NULL,
KEY parent_form (form),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_powermail_domain_model_field'
#
CREATE TABLE tx_powermail_domain_model_field (
page int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
type varchar(255) DEFAULT '' NOT NULL,
settings text DEFAULT '' NOT NULL,
path varchar(255) DEFAULT '' NOT NULL,
content_element int(11) DEFAULT '0' NOT NULL,
text text DEFAULT '' NOT NULL,
prefill_value text DEFAULT '' NOT NULL,
placeholder text DEFAULT '' NOT NULL,
placeholder_repeat text DEFAULT '' NOT NULL,
create_from_typoscript text DEFAULT '' NOT NULL,
validation int(11) DEFAULT '0' NOT NULL,
validation_configuration varchar(255) DEFAULT '' NOT NULL,
css varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
multiselect tinyint(4) unsigned DEFAULT '0' NOT NULL,
datepicker_settings varchar(255) DEFAULT '' NOT NULL,
feuser_value varchar(255) DEFAULT '' NOT NULL,
sender_email tinyint(4) unsigned DEFAULT '0' NOT NULL,
sender_name tinyint(4) unsigned DEFAULT '0' NOT NULL,
mandatory tinyint(4) unsigned DEFAULT '0' NOT NULL,
own_marker_select tinyint(4) unsigned DEFAULT '0' NOT NULL,
marker varchar(255) DEFAULT '' NOT NULL,
mandatory_text varchar(255) DEFAULT '' NOT NULL,
autocomplete_token varchar(20) DEFAULT '' NOT NULL,
autocomplete_section varchar(100) DEFAULT '' NOT NULL,
autocomplete_type varchar(8) DEFAULT '' NOT NULL,
autocomplete_purpose varchar(8) DEFAULT '' NOT NULL,
# Dummy Fields
auto_marker tinyint(2) unsigned DEFAULT '0' NOT NULL,
KEY parent_page (page),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_powermail_domain_model_mail'
#
CREATE TABLE tx_powermail_domain_model_mail (
sender_name varchar(255) DEFAULT '' NOT NULL,
sender_mail varchar(255) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
receiver_mail varchar(1024) DEFAULT '' NOT NULL,
body text DEFAULT '' NOT NULL,
feuser int(11) DEFAULT '0' NOT NULL,
sender_ip tinytext DEFAULT '' NOT NULL,
user_agent text DEFAULT '' NOT NULL,
time int(11) DEFAULT '0' NOT NULL,
form int(11) DEFAULT '0' NOT NULL,
answers int(11) unsigned DEFAULT '0' NOT NULL,
marketing_referer_domain text DEFAULT '' NOT NULL,
marketing_referer text DEFAULT '' NOT NULL,
marketing_country text DEFAULT '' NOT NULL,
marketing_mobile_device tinyint(4) unsigned DEFAULT '0' NOT NULL,
marketing_frontend_language int(11) DEFAULT '0' NOT NULL,
marketing_browser_language text DEFAULT '' NOT NULL,
marketing_page_funnel text DEFAULT '' NOT NULL,
spam_factor varchar(255) DEFAULT '' NOT NULL,
KEY form (form),
KEY feuser (feuser)
);
#
# Table structure for table 'tx_powermail_domain_model_answer'
#
CREATE TABLE tx_powermail_domain_model_answer (
mail int(11) unsigned DEFAULT '0' NOT NULL,
value text DEFAULT '' NOT NULL,
value_type int(11) unsigned DEFAULT '0' NOT NULL,
field int(11) unsigned DEFAULT '0' NOT NULL,
KEY mail (mail),
KEY deleted (deleted),
KEY hidden (hidden),
KEY language (l10n_parent,sys_language_uid)
);