This repository has been archived by the owner on Nov 19, 2017. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
152 lines (145 loc) · 5.16 KB
/
ext_tables.sql
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
#
# Table structure for table 'tx_srsendcard_domain_model_card'
#
CREATE TABLE tx_srsendcard_domain_model_card (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL
sorting int(10) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
card tinytext NOT NULL,
image blob NOT NULL,
cardaltText tinytext NOT NULL,
selection_image blob NOT NULL,
selection_imagealtText tinytext NOT NULL,
img_width varchar(20) DEFAULT '' NOT NULL,
img_height varchar(20) DEFAULT '' NOT NULL,
selection_image_width varchar(20) DEFAULT '' NOT NULL,
selection_image_height varchar(20) DEFAULT '' NOT NULL,
link_pid int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_srsendcard_domain_model_sendcard'
#
CREATE TABLE tx_srsendcard_domain_model_sendcard (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
id varchar(25) DEFAULT '' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
image varchar(150) DEFAULT '',
card_image_path varchar(100) DEFAULT '',
selection_image varchar(150) DEFAULT '',
caption text,
cardaltText varchar(255) DEFAULT '' NOT NULL,
selection_imagealtText varchar(255) DEFAULT '' NOT NULL,
link_pid int(11) unsigned DEFAULT '0',
bgcolor varchar(7) DEFAULT '',
towho varchar(50) DEFAULT '',
to_email varchar(50) DEFAULT '' NOT NULL,
fromwho varchar(50) DEFAULT '',
from_email varchar(50) DEFAULT '' NOT NULL,
fontcolor varchar(7) DEFAULT '',
fontface varchar(100) DEFAULT '',
fontfile varchar(70) DEFAULT '',
fontsize char(2) DEFAULT '',
message text,
card_title text,
card_signature text,
music varchar(70) DEFAULT '',
card_url varchar(150) DEFAULT '',
notify char(1) DEFAULT '1',
emailsent char(1) DEFAULT '1',
img_width char(3) DEFAULT '',
img_height char(3) DEFAULT '',
selection_image_width char(3) DEFAULT '',
selection_image_height char(3) DEFAULT '',
send_time int(11) unsigned DEFAULT '0',
time_created int(11) unsigned DEFAULT '0',
ip_address varchar(15) DEFAULT '',
language char(2) DEFAULT 'es',
charset varchar(30) DEFAULT 'iso-8859-1',
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_srsendcard_card'
#
CREATE TABLE tx_srsendcard_card (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL
sorting int(10) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
card tinytext NOT NULL,
image blob NOT NULL,
cardaltText tinytext NOT NULL,
selection_image blob NOT NULL,
selection_imagealtText tinytext NOT NULL,
img_width varchar(20) DEFAULT '' NOT NULL,
img_height varchar(20) DEFAULT '' NOT NULL,
selection_image_width varchar(20) DEFAULT '' NOT NULL,
selection_image_height varchar(20) DEFAULT '' NOT NULL,
link_pid int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_srsendcard_sendcard'
#
CREATE TABLE tx_srsendcard_sendcard (
uid varchar(25) DEFAULT '' NOT NULL,
pid int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
image varchar(150) DEFAULT '',
card_image_path varchar(100) DEFAULT '',
selection_image varchar(150) DEFAULT '',
caption text,
cardaltText varchar(255) DEFAULT '' NOT NULL,
selection_imagealtText varchar(255) DEFAULT '' NOT NULL,
link_pid int(11) unsigned DEFAULT '0',
bgcolor varchar(7) DEFAULT '',
towho varchar(50) DEFAULT '',
to_email varchar(50) DEFAULT '' NOT NULL,
fromwho varchar(50) DEFAULT '',
from_email varchar(50) DEFAULT '' NOT NULL,
fontcolor varchar(7) DEFAULT '',
fontface varchar(100) DEFAULT '',
fontfile varchar(70) DEFAULT '',
fontsize char(2) DEFAULT '',
message text,
card_title text,
card_signature text,
music varchar(70) DEFAULT '',
card_url varchar(150) DEFAULT '',
notify char(1) DEFAULT '1',
emailsent char(1) DEFAULT '1',
img_width char(3) DEFAULT '',
img_height char(3) DEFAULT '',
selection_image_width char(3) DEFAULT '',
selection_image_height char(3) DEFAULT '',
send_time int(11) unsigned DEFAULT '0',
time_created int(11) unsigned DEFAULT '0',
ip_address varchar(15) DEFAULT '',
language char(2) DEFAULT 'es',
charset varchar(30) DEFAULT 'iso-8859-1',
PRIMARY KEY (uid),
KEY parent (pid)
);