fp_newsletter/ext_tables.sql at master · mtness/fp_newsletter · GitHub

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
#
# Table structure for table 'tx_fpnewsletter_domain_model_log'
#
CREATE TABLE tx_fpnewsletter_domain_model_log (

	gender int(11) DEFAULT '0' NOT NULL,
	title varchar(255) DEFAULT '' NOT NULL,
	firstname varchar(255) DEFAULT '' NOT NULL,
	lastname varchar(255) DEFAULT '' NOT NULL,
	email varchar(255) DEFAULT '' NOT NULL,
	status int(11) DEFAULT '0' NOT NULL,
	securityhash varchar(255) DEFAULT '' NOT NULL,
	retoken text,
	mathcaptcha varchar(5) DEFAULT '' NOT NULL,
	extras varchar(255) DEFAULT '' NOT NULL,
	gdpr tinyint(3) unsigned DEFAULT '0' NOT NULL,
	address varchar(255) DEFAULT '' NOT NULL,
	zip varchar(255) DEFAULT '' NOT NULL,
	city varchar(255) DEFAULT '' NOT NULL,
	region varchar(255) DEFAULT '' NOT NULL,
	country varchar(255) DEFAULT '' NOT NULL,
	phone varchar(255) DEFAULT '' NOT NULL,
	mobile varchar(255) DEFAULT '' NOT NULL,
	fax varchar(255) DEFAULT '' NOT NULL,
	www varchar(255) DEFAULT '' NOT NULL,
	position varchar(255) DEFAULT '' NOT NULL,
	company varchar(255) DEFAULT '' NOT NULL,
	categories varchar(255) DEFAULT '' NOT NULL,
	nl_table varchar(255) DEFAULT '' NOT NULL,
	nl_extension varchar(255) DEFAULT '' NOT NULL,
	cg_table varchar(255) DEFAULT '' NOT NULL,
	ex_uid int(11) DEFAULT '0' NOT NULL

);