-
Notifications
You must be signed in to change notification settings - Fork 15
/
magento2.yml
173 lines (173 loc) · 4.48 KB
/
magento2.yml
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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
# https://github.com/meanbee/magedbm2/blob/fc8bbf9a97db2c27d0cd8a1153dda8c95b6f5996/etc/config.yml#L82
# https://github.com/DivanteLtd/anonymizer/blob/afac8e2f8f0ab49216ed1f5a6aca50bd13d67253/lib/anonymizer/project/basic/magento_2_0.json
tables:
- name: admin_user
columns:
firstname: firstname
lastname: lastname
email: unique_email
username: username
password: password
- name: customer_entity
columns:
email: unique_email
firstname: firstname
lastname: lastname
vat_id: vat_number
- name: customer_grid_flat
columns:
name: fullname
email: unique_email
dob: date
gender: gender
taxvat: vat_number
shipping_full: street
billing_full: street
billing_firstname: firstname
billing_lastname: lastname
billing_telephone: telephone
billing_postcode: postcode
billing_country_id: country_code
billing_region: state
billing_street: street
billing_city: city
billing_fax: telephone
billing_vat_id: vat_number
billing_company: company
- name: customer_address_entity
columns:
city: city
company: company
fax: telephone
firstname: firstname
lastname: lastname
postcode: postcode
street: street
telephone: telephone
vat_id: vat_number
- name: newsletter_subscriber
columns:
subscriber_email: unique_email
subscriber_confirm_code: md5
- name: quote
columns:
customer_email: unique_email
customer_prefix: title
customer_firstname: firstname
customer_middlename: firstname
customer_lastname: lastname
customer_suffix: customer_suffix
customer_dob: datetime
customer_note: note255
remote_ip: ipv4
- name: quote_address
columns:
email: unique_email
prefix: title
firstname: firstname
lastname: lastname
suffix: customer_suffix
company: company
street: street
city: city
region: state
region_id: region_id
postcode: postcode
country_id: country_code
telephone: telephone
fax: telephone
vat_id: vat_number
- name: rating_option_vote
columns:
remote_ip: ipv4
- name: review_detail
columns:
nickname: username
- name: sales_creditmemo_grid
columns:
billing_name: fullname
billing_address: street
shipping_address: street
customer_name: fullname
customer_email: unique_email
- name: sales_invoice_grid
columns:
customer_name: fullname
customer_email: unique_email
billing_name: fullname
billing_address: street
shipping_address: street
- name: sales_order
columns:
customer_dob: datetime
customer_email: unique_email
customer_prefix: title
customer_firstname: firstname
customer_middlename: firstname
customer_lastname: lastname
customer_suffix: customer_suffix
remote_ip: ipv4
x_forwarded_for: ipv4
- name: sales_order_address
columns:
region: state
postcode: postcode
lastname: lastname
street: street
city: city
email: unique_email
telephone: telephone
firstname: firstname
prefix: title
middlename: firstname
suffix: customer_suffix
company: company
- name: sales_order_grid
columns:
shipping_name: fullname
billing_name: fullname
billing_address: street
shipping_address: street
customer_email: unique_email
cutomer_name: fullname
- name: sales_shipment_grid
columns:
customer_name: fullname
billing_address: street
shipping_address: street
billing_name: fullname
shipping_name: fullname
customer_email: unique_email
- name: sendfriend_log
columns:
ip: ipv4
eav:
- name: customer
attributes:
email: unique_email
prefix: title
firstname: firstname
middlename: firstname
lastname: lastname
suffix: customer_suffix
dob: datetime
password_hash: password
taxvat: vat_number
gender: gender
- name: customer_address
attributes:
city: city
company: company
country_id: country_code
fax: telephone
firstname: firstname
lastname: lastname
middlename: firstname
postcode: postcode
prefix: title
region: state
region_id: region_id
street: street
suffix: customer_suffix
telephone: telephone
vat_id: vat_number