Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- +--------------------------------------------------------------------+ |
2 | -- | CiviCRM version 3.2 | | |
3 | -- +--------------------------------------------------------------------+ | |
4 | -- | Copyright CiviCRM LLC (c) 2004-2010 | | |
5 | -- +--------------------------------------------------------------------+ | |
6 | -- | This file is a part of CiviCRM. | | |
7 | -- | | | |
8 | -- | CiviCRM is free software; you can copy, modify, and distribute it | | |
9 | -- | under the terms of the GNU Affero General Public License | | |
10 | -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
11 | -- | | | |
12 | -- | CiviCRM is distributed in the hope that it will be useful, but | | |
13 | -- | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
14 | -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
15 | -- | See the GNU Affero General Public License for more details. | | |
16 | -- | | | |
17 | -- | You should have received a copy of the GNU Affero General Public | | |
18 | -- | License and the CiviCRM Licensing Exception along | | |
19 | -- | with this program; if not, contact CiviCRM LLC | | |
20 | -- | at info[AT]civicrm[DOT]org. If you have questions about the | | |
21 | -- | GNU Affero General Public License or the licensing of CiviCRM, | | |
22 | -- | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
23 | -- +--------------------------------------------------------------------+ | |
24 | -- /******************************************************* | |
25 | -- * | |
26 | -- * Select DomainID | |
27 | -- * | |
28 | -- *******************************************************/ | |
29 | SELECT @domain_id := id from civicrm_domain; | |
30 | ||
31 | -- /******************************************************* | |
32 | -- * | |
33 | -- * civicrm_dedupe_rule_group | |
34 | -- * | |
35 | -- * Dedupe rule groups | |
36 | -- * | |
37 | -- *******************************************************/ | |
38 | CREATE TABLE civicrm_dedupe_rule_group ( | |
39 | ||
40 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique dedupe rule group id', | |
41 | domain_id int unsigned NOT NULL COMMENT 'The id of the domain this rule group belongs to', | |
42 | contact_type enum('Individual', 'Organization', 'Household') COMMENT 'The type of contacts this group applies to', | |
43 | threshold int NOT NULL COMMENT 'The weight threshold the sum of the rule weights has to cross to consider two contacts the same' | |
44 | ||
45 | , PRIMARY KEY ( id ) | |
46 | ||
47 | , CONSTRAINT FK_civicrm_dedupe_rule_group_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
48 | ||
49 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
50 | ||
51 | -- /******************************************************* | |
52 | -- * | |
53 | -- * civicrm_dedupe_rule | |
54 | -- * | |
55 | -- * Dedupe rules for use by rule groups | |
56 | -- * | |
57 | -- *******************************************************/ | |
58 | CREATE TABLE civicrm_dedupe_rule ( | |
59 | ||
60 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique dedupe rule id', | |
61 | dedupe_rule_group_id int unsigned NOT NULL COMMENT 'The id of the rule group this rule belongs to', | |
62 | rule_table varchar(64) NOT NULL COMMENT 'The name of the table this rule is about', | |
63 | rule_field varchar(64) NOT NULL COMMENT 'The name of the field of the table referenced in rule_table', | |
64 | rule_length int unsigned COMMENT 'The lenght of the matching substring', | |
65 | rule_weight int NOT NULL COMMENT 'The weight of the rule' | |
66 | ||
67 | , PRIMARY KEY ( id ) | |
68 | ||
69 | , CONSTRAINT FK_civicrm_dedupe_rule_dedupe_rule_group_id FOREIGN KEY (dedupe_rule_group_id) REFERENCES civicrm_dedupe_rule_group(id) | |
70 | ||
71 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
72 | ||
73 | -- /******************************************************* | |
74 | -- * | |
75 | -- * civicrm_participant | |
76 | -- * | |
77 | -- *******************************************************/ | |
78 | ALTER TABLE civicrm_participant | |
79 | ADD INDEX index_status_id (status_id), | |
80 | ADD INDEX index_role_id (role_id); | |
81 | ||
82 | -- /******************************************************* | |
83 | -- * | |
84 | -- * civicrm_payment_processor | |
85 | -- * | |
86 | -- *******************************************************/ | |
87 | CREATE TABLE civicrm_payment_processor ( | |
88 | ||
89 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payment Processor ID', | |
90 | domain_id int unsigned NOT NULL COMMENT 'Which Domain owns this payment processor.', | |
91 | name varchar(64) COMMENT 'Payment Processor Name.', | |
92 | description varchar(255) COMMENT 'Payment Processor Description.', | |
93 | payment_processor_type varchar(255) COMMENT 'Payment Processor Type.', | |
94 | is_active tinyint COMMENT 'Is this processor active?', | |
95 | is_default tinyint COMMENT 'Is this processor the default?', | |
96 | is_test tinyint COMMENT 'Is this processor for a test site?', | |
97 | user_name varchar(255), | |
98 | password varchar(255), | |
99 | signature varchar(255), | |
100 | url_site varchar(255), | |
101 | url_recur varchar(255), | |
102 | url_button varchar(255), | |
103 | subject varchar(255), | |
104 | class_name varchar(255), | |
105 | billing_mode int unsigned NOT NULL COMMENT 'Billing Mode', | |
106 | is_recur tinyint COMMENT 'Can process recurring contributions' | |
107 | ||
108 | , PRIMARY KEY ( id ) | |
109 | ||
110 | , UNIQUE INDEX UI_name_test( name, is_test ) | |
111 | ||
112 | , CONSTRAINT FK_civicrm_payment_processor_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
113 | ||
114 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
115 | ||
116 | -- /******************************************************* | |
117 | -- * | |
118 | -- * civicrm_payment_processor_type | |
119 | -- * | |
120 | -- *******************************************************/ | |
121 | CREATE TABLE civicrm_payment_processor_type ( | |
122 | ||
123 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payment Processor Type ID', | |
124 | domain_id int unsigned NOT NULL COMMENT 'Which Domain owns this payment processor.', | |
125 | name varchar(64) COMMENT 'Payment Processor Name.', | |
126 | title varchar(64) COMMENT 'Payment Processor Name.', | |
127 | description varchar(255) COMMENT 'Payment Processor Description.', | |
128 | is_active tinyint COMMENT 'Is this processor active?', | |
129 | is_default tinyint COMMENT 'Is this processor the default?', | |
130 | user_name_label varchar(255), | |
131 | password_label varchar(255), | |
132 | signature_label varchar(255), | |
133 | subject_label varchar(255), | |
134 | class_name varchar(255), | |
135 | url_site_default varchar(255), | |
136 | url_recur_default varchar(255), | |
137 | url_button_default varchar(255), | |
138 | url_site_test_default varchar(255), | |
139 | url_recur_test_default varchar(255), | |
140 | url_button_test_default varchar(255), | |
141 | billing_mode int unsigned NOT NULL COMMENT 'Billing Mode', | |
142 | is_recur tinyint COMMENT 'Can process recurring contributions' | |
143 | , | |
144 | PRIMARY KEY ( id ) | |
145 | ||
146 | , UNIQUE INDEX UI_name( name ) | |
147 | ||
148 | , CONSTRAINT FK_civicrm_payment_processor_type_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
149 | ||
150 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
151 | ||
152 | ||
153 | -- /******************************************************* | |
154 | -- * | |
155 | -- * civicrm_preferences | |
156 | -- * | |
157 | -- * Define preferences for the site and users | |
158 | -- * | |
159 | -- *******************************************************/ | |
160 | CREATE TABLE civicrm_preferences ( | |
161 | ||
162 | ||
163 | id int unsigned NOT NULL AUTO_INCREMENT , | |
164 | domain_id int unsigned NOT NULL COMMENT 'Which Domain owns this contact', | |
165 | contact_id int unsigned COMMENT 'FK to Contact ID', | |
166 | is_domain tinyint COMMENT 'Is this the record for the domain setting?', | |
167 | location_count int unsigned COMMENT 'Number of locations to be displayed on edit page?', | |
168 | contact_view_options varchar(128) COMMENT 'What tabs are displayed in the contact summary', | |
169 | contact_edit_options varchar(128) COMMENT 'What tabs are displayed in the contact edit', | |
170 | advanced_search_options varchar(128) COMMENT 'What tabs are displayed in the advanced search screen', | |
171 | user_dashboard_options varchar(128) COMMENT 'What tabs are displayed in the contact edit', | |
172 | address_options varchar(128) COMMENT 'What fields are displayed from the address table', | |
173 | address_format text COMMENT 'Format to display the address', | |
174 | mailing_format text COMMENT 'Format to display a mailing label', | |
175 | individual_name_format text COMMENT 'Format to display a individual name', | |
176 | address_standardization_provider varchar(64) COMMENT 'object name of provider for address standarization', | |
177 | address_standardization_userid varchar(64) COMMENT 'user id for provider login', | |
178 | address_standardization_url varchar(255) COMMENT 'url of address standardization service' | |
179 | , | |
180 | PRIMARY KEY ( id ) | |
181 | ||
182 | , INDEX index_contact_view_options( | |
183 | contact_view_options | |
184 | ) | |
185 | , INDEX index_contact_edit_options( | |
186 | contact_edit_options | |
187 | ) | |
188 | , INDEX index_advanced_search_options( | |
189 | advanced_search_options | |
190 | ) | |
191 | , INDEX index_user_dashboard_options( | |
192 | user_dashboard_options | |
193 | ) | |
194 | , INDEX index_address_options( | |
195 | address_options | |
196 | ) | |
197 | ||
198 | , | |
199 | CONSTRAINT FK_civicrm_preferences_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
200 | , | |
201 | CONSTRAINT FK_civicrm_preferences_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id) | |
202 | ||
203 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
204 | ||
205 | ||
206 | -- /******************************************************* | |
207 | -- * | |
208 | -- * civicrm_price_set | |
209 | -- * | |
210 | -- *******************************************************/ | |
211 | CREATE TABLE civicrm_price_set ( | |
212 | ||
213 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price Set', | |
214 | domain_id int unsigned NOT NULL COMMENT 'Which domain owns this price set', | |
215 | name varchar(64) NOT NULL COMMENT 'Variable name/programmatic handle for this group', | |
216 | title varchar(64) NOT NULL COMMENT 'Friendly name', | |
217 | is_active tinyint DEFAULT 1 COMMENT 'Is this price set active', | |
218 | help_pre text COMMENT 'Description and/or help text to display before fields in form.', | |
219 | help_post text COMMENT 'Description and/or help text to display after fields in form.', | |
220 | javascript varchar(64) COMMENT 'Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional' | |
221 | ||
222 | , PRIMARY KEY ( id ) | |
223 | ||
224 | , UNIQUE INDEX UI_name( name ) | |
225 | ||
226 | , UNIQUE INDEX UI_title( title ) | |
227 | ||
228 | , CONSTRAINT FK_civicrm_price_set_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) | |
229 | ||
230 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
231 | ||
232 | -- /******************************************************* | |
233 | -- * | |
234 | -- * civicrm_price_field | |
235 | -- * | |
236 | -- *******************************************************/ | |
237 | CREATE TABLE civicrm_price_field ( | |
238 | ||
239 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price Field', | |
240 | price_set_id int unsigned NOT NULL COMMENT 'FK to civicrm_price_set', | |
241 | name varchar(64) NOT NULL COMMENT 'Variable name/programmatic handle for this field', | |
242 | label varchar(64) NOT NULL COMMENT 'Text for form field label (also friendly name for administering this field)', | |
243 | html_type enum('Text', 'Select', 'Radio', 'CheckBox') NOT NULL , | |
244 | is_enter_qty tinyint DEFAULT 0 COMMENT 'Enter a quantity for this field?', | |
245 | help_pre text COMMENT 'Description and/or help text to display before this field.', | |
246 | help_post text COMMENT 'Description and/or help text to display after this field.', | |
247 | weight int DEFAULT 1 COMMENT 'Order in which the fields should appear', | |
248 | is_display_amounts tinyint DEFAULT 1 COMMENT 'Should the price be displayed next to the label for each option?', | |
249 | options_per_line int unsigned DEFAULT 1 COMMENT 'number of options per line for checkbox and radio', | |
250 | is_active tinyint DEFAULT 1 COMMENT 'Is this price field active', | |
251 | is_required tinyint DEFAULT 1 COMMENT 'Is this price field required (value must be > 1)', | |
252 | active_on datetime DEFAULT 0 COMMENT 'If non-zero, do not show this field before the date specified', | |
253 | expire_on datetime DEFAULT 0 COMMENT 'If non-zero, do not show this field after the date specified', | |
254 | javascript varchar(255) COMMENT 'Optional scripting attributes for field' | |
255 | ||
256 | , PRIMARY KEY ( id ) | |
257 | ||
258 | , INDEX index_name( name ) | |
259 | ||
260 | , CONSTRAINT FK_civicrm_price_field_price_set_id FOREIGN KEY (price_set_id) REFERENCES civicrm_price_set(id) | |
261 | ||
262 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
263 | ||
264 | ||
265 | -- /******************************************************* | |
266 | -- * | |
267 | -- * civicrm_price_set_entity | |
268 | -- * | |
269 | -- *******************************************************/ | |
270 | CREATE TABLE civicrm_price_set_entity ( | |
271 | ||
272 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price Set Entity', | |
273 | entity_table varchar(64) NOT NULL COMMENT 'Table which uses this price set', | |
274 | entity_id int unsigned NOT NULL COMMENT 'Item in table', | |
275 | price_set_id int unsigned NOT NULL COMMENT 'price set being used' | |
276 | ||
277 | , PRIMARY KEY ( id ) | |
278 | ||
279 | , UNIQUE INDEX UI_entity( entity_table, entity_id ) | |
280 | ||
281 | , CONSTRAINT FK_civicrm_price_set_entity_price_set_id FOREIGN KEY (price_set_id) REFERENCES civicrm_price_set(id) | |
282 | ||
283 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
284 | ||
285 | ||
286 | -- /******************************************************* | |
287 | -- * | |
288 | -- * civicrm_line_item | |
289 | -- * | |
290 | -- *******************************************************/ | |
291 | CREATE TABLE civicrm_line_item ( | |
292 | ||
293 | id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Line Item', | |
294 | entity_table varchar(64) NOT NULL COMMENT 'table which has the transaction', | |
295 | entity_id int unsigned NOT NULL COMMENT 'entry in table', | |
296 | price_field_id int unsigned NOT NULL COMMENT 'FK to price_field', | |
297 | custom_option_id int unsigned NOT NULL COMMENT 'FK to custom_option', | |
298 | label varchar(255) NOT NULL COMMENT 'descriptive label for item - from custom_option.label', | |
299 | qty int unsigned NOT NULL COMMENT 'How many items ordered', | |
300 | unit_price decimal(20,2) NOT NULL COMMENT 'price of each item', | |
301 | line_total decimal(20,2) NOT NULL COMMENT 'qty * unit_price' | |
302 | ||
303 | , PRIMARY KEY ( id ) | |
304 | ||
305 | , CONSTRAINT FK_civicrm_line_item_price_field_id FOREIGN KEY (price_field_id) REFERENCES civicrm_price_field(id) | |
306 | ||
307 | , CONSTRAINT FK_civicrm_line_item_custom_option_id FOREIGN KEY (custom_option_id) REFERENCES civicrm_custom_option(id) | |
308 | ||
309 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; | |
310 | ||
311 | ||
312 | -- /******************************************************* | |
313 | -- * | |
314 | -- * Modifying Tables | |
315 | -- * | |
316 | -- *******************************************************/ | |
317 | ||
318 | -- /******************************************************* | |
319 | -- * | |
320 | -- * civicrm_activity_history | |
321 | -- * | |
322 | -- *******************************************************/ | |
323 | ALTER TABLE civicrm_activity_history | |
324 | ADD is_test tinyint(4) NULL DEFAULT '0'; | |
325 | ||
326 | ||
327 | -- /******************************************************* | |
328 | -- * | |
329 | -- * civicrm_contribution_page | |
330 | -- * | |
331 | -- *******************************************************/ | |
332 | ALTER TABLE civicrm_contribution_page | |
333 | ADD `start_date` datetime NULL DEFAULT NULL, | |
334 | ADD `end_date` datetime NULL DEFAULT NULL, | |
335 | ADD payment_processor_id int(10) unsigned NULL DEFAULT NULL, | |
336 | ADD CONSTRAINT FK_civicrm_contribution_page_payment_processor_id FOREIGN KEY (payment_processor_id) REFERENCES civicrm_payment_processor(id); | |
337 | ||
338 | ||
339 | -- /******************************************************* | |
340 | -- * | |
341 | -- * civicrm_custom_field | |
342 | -- * | |
343 | -- *******************************************************/ | |
344 | ALTER TABLE civicrm_custom_field | |
345 | MODIFY data_type enum('String','Int','Float','Money','Memo','Date','Boolean','StateProvince','Country','File','Link') NULL DEFAULT NULL, | |
346 | MODIFY html_type enum('Text','TextArea','Select','Multi-Select','Radio','CheckBox','Select Date','Select State/Province','Select Country','File','Link') NULL DEFAULT NULL; | |
347 | ||
348 | ||
349 | -- /******************************************************* | |
350 | -- * | |
351 | -- * civicrm_event | |
352 | -- * | |
353 | -- *******************************************************/ | |
354 | ALTER TABLE civicrm_event | |
355 | ADD registration_start_date datetime NULL DEFAULT NULL, | |
356 | ADD registration_end_date datetime NULL DEFAULT NULL, | |
357 | ADD fee_label varchar(255) NULL DEFAULT NULL, | |
358 | ADD is_show_location tinyint(4) NULL DEFAULT '1', | |
359 | ADD payment_processor_id int(10) unsigned NULL DEFAULT NULL AFTER contribution_type_id, | |
360 | ADD CONSTRAINT FK_civicrm_event_payment_processor_id FOREIGN KEY (payment_processor_id) REFERENCES civicrm_payment_processor(id), | |
361 | ADD INDEX index_event_type_id (event_type_id); | |
362 | ||
363 | ||
364 | -- /******************************************************* | |
365 | -- * | |
366 | -- * civicrm_household | |
367 | -- * | |
368 | -- *******************************************************/ | |
369 | ALTER TABLE civicrm_household | |
370 | ADD INDEX index_household_name (household_name); | |
371 | ||
372 | -- /******************************************************* | |
373 | -- * | |
374 | -- * civicrm_individual | |
375 | -- * | |
376 | -- *******************************************************/ | |
377 | ALTER TABLE civicrm_individual | |
378 | ADD INDEX index_first_name (first_name), | |
379 | ADD INDEX index_last_name (last_name); | |
380 | ||
381 | -- /******************************************************* | |
382 | -- * | |
383 | -- * civicrm_line_item | |
384 | -- * | |
385 | -- *******************************************************/ | |
386 | ALTER TABLE civicrm_line_item | |
387 | ADD INDEX index_entity (entity_table, entity_id); | |
388 | ||
389 | ||
390 | ||
391 | -- /******************************************************* | |
392 | -- * | |
393 | -- * civicrm_location | |
394 | -- * | |
395 | -- *******************************************************/ | |
396 | ALTER TABLE civicrm_location | |
397 | MODIFY location_type_id int(10) unsigned NULL DEFAULT NULL; | |
398 | ||
399 | ||
400 | -- /******************************************************* | |
401 | -- * | |
402 | -- * civicrm_membership | |
403 | -- * | |
404 | -- *******************************************************/ | |
405 | ALTER TABLE civicrm_membership | |
406 | ADD is_test tinyint(4) NULL DEFAULT '0'; | |
407 | ||
408 | ||
409 | -- /******************************************************* | |
410 | -- * | |
411 | -- * civicrm_membership_type | |
412 | -- * | |
413 | -- *******************************************************/ | |
414 | ALTER TABLE civicrm_membership_type ALTER fixed_period_start_day DROP DEFAULT; | |
415 | ALTER TABLE civicrm_membership_type ALTER fixed_period_rollover_day DROP DEFAULT; | |
416 | ||
417 | ||
418 | -- /******************************************************* | |
419 | -- * | |
420 | -- * civicrm_option_group | |
421 | -- * | |
422 | -- *******************************************************/ | |
423 | ALTER TABLE civicrm_option_group | |
424 | ADD label varchar(255) NULL DEFAULT NULL; | |
425 | ||
426 | -- /******************************************************* | |
427 | -- * | |
428 | -- * civicrm_option_value | |
429 | -- * | |
430 | -- *******************************************************/ | |
431 | ALTER TABLE civicrm_option_value | |
432 | MODIFY filter int(10) unsigned DEFAULT NULL; | |
433 | ||
434 | -- /******************************************************* | |
435 | -- * | |
436 | -- * civicrm_organization | |
437 | -- * | |
438 | -- *******************************************************/ | |
439 | ALTER TABLE civicrm_organization | |
440 | ADD INDEX index_organization_name (organization_name); | |
441 | ||
442 | ||
443 | ||
444 | -- /******************************************************* | |
445 | -- * | |
446 | -- * Insert data into civicrm_payment_processor_type | |
447 | -- * | |
448 | -- *******************************************************/ | |
449 | ||
450 | INSERT INTO civicrm_payment_processor_type | |
451 | (domain_id, name, title, description, is_active, is_default, user_name_label, password_label, signature_label, subject_label, class_name, url_site_default, url_recur_default, url_button_default, url_site_test_default, url_recur_test_default, url_button_test_default, billing_mode, is_recur ) | |
452 | VALUES | |
453 | (@domain_id,'Dummy','Dummy Payment Processor',NULL,1,1,'User Name',NULL,NULL,NULL,'Payment_Dummy',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL), | |
454 | (@domain_id,'PayPal_Standard','PayPal - Website Payments Standard',NULL,1,0,'Merchant Account Email',NULL,NULL,NULL,'Payment_PayPalImpl','https://www.paypal.com/','https://www.paypal.com/',NULL,'https://www.sandbox.paypal.com/','https://www.sandbox.paypal.com/',NULL,4,1), | |
455 | (@domain_id,'PayPal','PayPal - Website Payments Pro',NULL,1,0,'User Name','Password','Signature',NULL,'Payment_PayPalImpl','https://www.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',3,NULL), | |
456 | (@domain_id,'PayPal_Express','PayPal - Express',NULL,1,0,'User Name','Password','Signature',NULL,'Payment_PayPalImpl','https://www.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',3,NULL), | |
457 | (@domain_id,'Google_Checkout','Google Checkout',NULL,1,0,'Merchant ID','Key',NULL,NULL,'Payment_Google','https://checkout.google.com/',NULL,'http://checkout.google.com/buttons/checkout.gif','https://sandbox.google.com/checkout',NULL,'http://sandbox.google.com/checkout/buttons/checkout.gif',4,NULL), | |
458 | (@domain_id,'Moneris','Moneris',NULL,1,0,'User Name','Password','Store ID',NULL,'Payment_Moneris','https://www3.moneris.com/',NULL,NULL,'https://esqa.moneris.com/',NULL,NULL,1,1), | |
459 | (@domain_id,'AuthNet_AIM','Authorize.Net - AIM',NULL,1,0,'API Login','Payment Key','MD5 Hash',NULL,'Payment_AuthorizeNet','https://secure.authorize.net/gateway/transact.dll','https://api.authorize.net/xml/v1/request.api',NULL,'https://secure.authorize.net/gateway/transact.dll','https://apitest.authorize.net/xml/v1/request.api',NULL,1,1); | |
460 | ||
461 | ||
462 | -- /******************************************************* | |
463 | -- * | |
464 | -- * civicrm_uf_group | |
465 | -- * | |
466 | -- *******************************************************/ | |
467 | ALTER TABLE civicrm_uf_group | |
468 | ADD is_cms_user tinyint(4) NULL DEFAULT '0', | |
469 | ADD notify varchar(255) NULL DEFAULT NULL COMMENT 'If you want member(s) of your organization to receive a notification email whenever this Profile form is used to enter or update contact information, enter one or more email addresses here separated by a comma'; | |
470 | ||
471 | ||
472 | -- /******************************************************* | |
473 | -- * | |
474 | -- * civicrm_option_group and civicrm_option_value | |
475 | -- * | |
476 | -- *******************************************************/ | |
477 | ||
478 | INSERT INTO | |
479 | civicrm_option_group (domain_id, name, description, is_reserved, is_active) | |
480 | VALUES | |
481 | (@domain_id, 'contact_view_options', 'Contact View Options', 0, 1), | |
482 | (@domain_id, 'contact_edit_options', 'Contact Edit Options', 0, 1), | |
483 | (@domain_id, 'advanced_search_options', 'Advanced Search Options', 0, 1), | |
484 | (@domain_id, 'user_dashboard_options', 'User Dashboard Options', 0, 1), | |
485 | (@domain_id, 'address_options', 'Addressing Options', 0, 1); | |
486 | ||
487 | SELECT @option_group_id_cvOpt := max(id) from civicrm_option_group where name = 'contact_view_options'; | |
488 | SELECT @option_group_id_ceOpt := max(id) from civicrm_option_group where name = 'contact_edit_options'; | |
489 | SELECT @option_group_id_asOpt := max(id) from civicrm_option_group where name = 'advanced_search_options'; | |
490 | SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options'; | |
491 | SELECT @option_group_id_adOpt := max(id) from civicrm_option_group where name = 'address_options'; | |
492 | ||
493 | INSERT INTO | |
494 | civicrm_option_value (option_group_id, label, value, name, grouping, filter, is_default, weight, description, is_optgroup, is_reserved, is_active) | |
495 | VALUES | |
496 | (@option_group_id_cvOpt, 'Activities' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
497 | (@option_group_id_cvOpt, 'Relationships', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
498 | (@option_group_id_cvOpt, 'Groups' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
499 | (@option_group_id_cvOpt, 'Notes' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
500 | (@option_group_id_cvOpt, 'Tags' , 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1 ), | |
501 | (@option_group_id_cvOpt, 'Change Log' , 6, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1 ), | |
502 | (@option_group_id_cvOpt, 'Contributions', 7, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1 ), | |
503 | (@option_group_id_cvOpt, 'Memberships' , 8, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1 ), | |
504 | (@option_group_id_cvOpt, 'Events' , 9, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1 ), | |
505 | ||
506 | (@option_group_id_ceOpt, 'Communication Preferences', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
507 | (@option_group_id_ceOpt, 'Demographics' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
508 | (@option_group_id_ceOpt, 'Tags and Groups' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
509 | (@option_group_id_ceOpt, 'Notes' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
510 | ||
511 | (@option_group_id_asOpt, 'Address Fields' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
512 | (@option_group_id_asOpt, 'Custom Fields' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
513 | (@option_group_id_asOpt, 'Activity History' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
514 | (@option_group_id_asOpt, 'Scheduled Activities', 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
515 | (@option_group_id_asOpt, 'Relationships' , 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1 ), | |
516 | (@option_group_id_asOpt, 'Notes' , 6, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1 ), | |
517 | (@option_group_id_asOpt, 'Change Log' , 7, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1 ), | |
518 | (@option_group_id_asOpt, 'Contributions' , 8, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1 ), | |
519 | (@option_group_id_asOpt, 'Memberships' , 9, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1 ), | |
520 | (@option_group_id_asOpt, 'Events' , 10, NULL, NULL, 0, NULL, 10, NULL, 0, 0, 1 ), | |
521 | ||
522 | (@option_group_id_udOpt, 'Groups' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
523 | (@option_group_id_udOpt, 'Contributions', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
524 | (@option_group_id_udOpt, 'Memberships' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
525 | (@option_group_id_udOpt, 'Events' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
526 | ||
527 | (@option_group_id_adOpt, 'Street Address' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1 ), | |
528 | (@option_group_id_adOpt, 'Addt\'l Address 1' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1 ), | |
529 | (@option_group_id_adOpt, 'Addt\'l Address 2' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1 ), | |
530 | (@option_group_id_adOpt, 'City' , 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1 ), | |
531 | (@option_group_id_adOpt, 'Zip / Postal Code', 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1 ), | |
532 | (@option_group_id_adOpt, 'Postal Code Suffix', 6, NULL, NULL, 0, NULL, 6, NULL, 0, 0, 1 ), | |
533 | (@option_group_id_adOpt, 'County' , 7, NULL, NULL, 0, NULL, 7, NULL, 0, 0, 1 ), | |
534 | (@option_group_id_adOpt, 'State / Province' , 8, NULL, NULL, 0, NULL, 8, NULL, 0, 0, 1 ), | |
535 | (@option_group_id_adOpt, 'Country' , 9, NULL, NULL, 0, NULL, 9, NULL, 0, 0, 1 ), | |
536 | (@option_group_id_adOpt, 'Latitude' , 10, NULL, NULL, 0, NULL, 10, NULL, 0, 0, 1 ), | |
537 | (@option_group_id_adOpt, 'Longitude' , 11, NULL, NULL, 0, NULL, 11, NULL, 0, 0, 1 ); | |
538 | ||
539 | ||
540 | -- /******************************************************* | |
541 | -- * | |
542 | -- * civicrm_preferences | |
543 | -- * | |
544 | -- *******************************************************/ | |
545 | INSERT INTO | |
546 | civicrm_preferences(domain_id, contact_id, is_domain, location_count, contact_view_options, contact_edit_options, advanced_search_options, user_dashboard_options, address_options, address_format, mailing_format, individual_name_format, address_standardization_provider, address_standardization_userid, address_standardization_url ) | |
547 | VALUES | |
548 | (@domain_id,NULL,1,1,'\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 1','\ 11\ 12\ 13\ 14\ 1','\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 110\ 1','\ 11\ 12\ 13\ 14\ 1','\ 11\ 12\ 13\ 14\ 15\ 16\ 18\ 19\ 110\ 111\ 1','{street_address}\n{supplemental_address_1}\n{supplemental_address_2}\n{city}{, }{state_province}{ }{postal_code}\n{country}','{street_address}\n{supplemental_address_1}\n{supplemental_address_2}\n{city}{, }{state_province}{ }{postal_code}\n{country}','{individual_prefix}{ } {first_name}{ }{middle_name}{ }{last_name}{ }{individual_suffix}',NULL,NULL,NULL); | |
549 | ||
550 | -- /******************************************************* | |
551 | -- * | |
552 | -- * CRM-2064 | |
553 | -- * | |
554 | -- *******************************************************/ | |
555 | UPDATE civicrm_location_type SET name = 'Billing' WHERE name IN ('Facturering', 'Facturation', 'Faturamento'); | |
556 | ||
557 | ||
558 | -- /******************************************************* | |
559 | -- * | |
560 | -- * dupe rule defaults | |
561 | -- * | |
562 | -- *******************************************************/ | |
563 | ||
564 | INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Individual', 20); | |
565 | ||
566 | SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group; | |
567 | ||
568 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
569 | VALUES | |
570 | (@dedupe_rule_group_id, 'civicrm_individual', 'first_name', 5), | |
571 | (@dedupe_rule_group_id, 'civicrm_individual', 'last_name', 7), | |
572 | (@dedupe_rule_group_id, 'civicrm_email', 'email', 10); | |
573 | ||
574 | INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Organization', 10); | |
575 | ||
576 | SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group; | |
577 | ||
578 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
579 | VALUES | |
580 | (@dedupe_rule_group_id, 'civicrm_organization', 'organization_name', 5), | |
581 | (@dedupe_rule_group_id, 'civicrm_email', 'email', 5); | |
582 | ||
583 | INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Household', 10); | |
584 | ||
585 | SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group; | |
586 | ||
587 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
588 | VALUES | |
589 | (@dedupe_rule_group_id, 'civicrm_household', 'household_name', 5), | |
590 | (@dedupe_rule_group_id, 'civicrm_email', 'email', 5); | |
591 | ||
592 | -- /******************************************************* | |
593 | -- * | |
594 | -- * CRM-2125 | |
595 | -- * | |
596 | -- *******************************************************/ | |
597 | INSERT IGNORE INTO civicrm_state_province (id,country_id, abbreviation, name) VALUES | |
598 | (5177, 1098, "CW", "Central and Western"), | |
599 | (5178, 1098, "EA", "Eastern"), | |
600 | (5179, 1098, "SO", "Southern"), | |
601 | (5180, 1098, "WC", "Wan Chai"), | |
602 | (5181, 1098, "KC", "Kowloon City"), | |
603 | (5182, 1098, "KU", "Kwun Tong"), | |
604 | (5183, 1098, "SS", "Sham Shui Po"), | |
605 | (5184, 1098, "WT", "Wong Tai Sin"), | |
606 | (5185, 1098, "YT", "Yau Tsim Mong"), | |
607 | (5186, 1098, "IS", "Islands"), | |
608 | (5187, 1098, "KI", "Kwai Tsing"), | |
609 | (5188, 1098, "NO", "North"), | |
610 | (5189, 1098, "SK", "Sai Kung"), | |
611 | (5190, 1098, "ST", "Sha Tin"), | |
612 | (5191, 1098, "TP", "Tai Po"), | |
613 | (5192, 1098, "TW", "Tsuen Wan"), | |
614 | (5193, 1098, "TM", "Tuen Mun"), | |
615 | (5194, 1098, "YL", "Yuen Long"); | |
616 | ||
617 | -- /******************************************************* | |
618 | -- * | |
619 | -- * CRM-2130 | |
620 | -- * | |
621 | -- *******************************************************/ | |
622 | INSERT IGNORE INTO civicrm_country (id, name, iso_code) VALUES ("1242", "Serbia", "RS"); | |
623 | INSERT IGNORE INTO civicrm_country (id, name, iso_code) VALUES ("1243", "Montenegro", "ME"); | |
624 | ||
625 | -- /******************************************************* | |
626 | -- * | |
627 | -- * CRM-2131 | |
628 | -- * | |
629 | -- *******************************************************/ | |
630 | INSERT IGNORE INTO civicrm_country (id, name, iso_code) VALUES ("1244", "Jersey", "JE"); | |
631 | INSERT IGNORE INTO civicrm_country (id, name, iso_code) VALUES ("1245", "Guernsey", "GG"); | |
632 | INSERT IGNORE INTO civicrm_country (id, name, iso_code) VALUES ("1246", "Isle of Man", "IM"); |