1 -- +--------------------------------------------------------------------+
2 -- | CiviCRM version 3.2 |
3 -- +--------------------------------------------------------------------+
4 -- | Copyright CiviCRM LLC (c) 2004-2010 |
5 -- +--------------------------------------------------------------------+
6 -- | This file is a part of CiviCRM. |
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. |
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. |
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 -- /*******************************************************
28 -- *******************************************************/
29 SELECT @domain_id := id from civicrm_domain;
31 -- /*******************************************************
33 -- * civicrm_dedupe_rule_group
35 -- * Dedupe rule groups
37 -- *******************************************************/
38 CREATE TABLE civicrm_dedupe_rule_group (
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'
47 , CONSTRAINT FK_civicrm_dedupe_rule_group_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
49 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
51 -- /*******************************************************
53 -- * civicrm_dedupe_rule
55 -- * Dedupe rules for use by rule groups
57 -- *******************************************************/
58 CREATE TABLE civicrm_dedupe_rule (
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'
69 , CONSTRAINT FK_civicrm_dedupe_rule_dedupe_rule_group_id FOREIGN KEY (dedupe_rule_group_id) REFERENCES civicrm_dedupe_rule_group(id)
71 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
73 -- /*******************************************************
75 -- * civicrm_participant
77 -- *******************************************************/
78 ALTER TABLE civicrm_participant
79 ADD INDEX index_status_id (status_id),
80 ADD INDEX index_role_id (role_id);
82 -- /*******************************************************
84 -- * civicrm_payment_processor
86 -- *******************************************************/
87 CREATE TABLE civicrm_payment_processor (
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'
110 , UNIQUE INDEX UI_name_test( name, is_test )
112 , CONSTRAINT FK_civicrm_payment_processor_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
114 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
116 -- /*******************************************************
118 -- * civicrm_payment_processor_type
120 -- *******************************************************/
121 CREATE TABLE civicrm_payment_processor_type (
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'
146 , UNIQUE INDEX UI_name( name )
148 , CONSTRAINT FK_civicrm_payment_processor_type_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
150 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
153 -- /*******************************************************
155 -- * civicrm_preferences
157 -- * Define preferences for the site and users
159 -- *******************************************************/
160 CREATE TABLE civicrm_preferences (
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'
182 , INDEX index_contact_view_options(
185 , INDEX index_contact_edit_options(
188 , INDEX index_advanced_search_options(
189 advanced_search_options
191 , INDEX index_user_dashboard_options(
192 user_dashboard_options
194 , INDEX index_address_options(
199 CONSTRAINT FK_civicrm_preferences_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
201 CONSTRAINT FK_civicrm_preferences_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id)
203 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
206 -- /*******************************************************
208 -- * civicrm_price_set
210 -- *******************************************************/
211 CREATE TABLE civicrm_price_set (
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'
224 , UNIQUE INDEX UI_name( name )
226 , UNIQUE INDEX UI_title( title )
228 , CONSTRAINT FK_civicrm_price_set_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
230 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
232 -- /*******************************************************
234 -- * civicrm_price_field
236 -- *******************************************************/
237 CREATE TABLE civicrm_price_field (
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'
258 , INDEX index_name( name )
260 , CONSTRAINT FK_civicrm_price_field_price_set_id FOREIGN KEY (price_set_id) REFERENCES civicrm_price_set(id)
262 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
265 -- /*******************************************************
267 -- * civicrm_price_set_entity
269 -- *******************************************************/
270 CREATE TABLE civicrm_price_set_entity (
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'
279 , UNIQUE INDEX UI_entity( entity_table, entity_id )
281 , CONSTRAINT FK_civicrm_price_set_entity_price_set_id FOREIGN KEY (price_set_id) REFERENCES civicrm_price_set(id)
283 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
286 -- /*******************************************************
288 -- * civicrm_line_item
290 -- *******************************************************/
291 CREATE TABLE civicrm_line_item (
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'
305 , CONSTRAINT FK_civicrm_line_item_price_field_id FOREIGN KEY (price_field_id) REFERENCES civicrm_price_field(id)
307 , CONSTRAINT FK_civicrm_line_item_custom_option_id FOREIGN KEY (custom_option_id) REFERENCES civicrm_custom_option(id)
309 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
312 -- /*******************************************************
314 -- * Modifying Tables
316 -- *******************************************************/
318 -- /*******************************************************
320 -- * civicrm_activity_history
322 -- *******************************************************/
323 ALTER TABLE civicrm_activity_history
324 ADD is_test tinyint(4) NULL DEFAULT '0';
327 -- /*******************************************************
329 -- * civicrm_contribution_page
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);
339 -- /*******************************************************
341 -- * civicrm_custom_field
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;
349 -- /*******************************************************
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);
364 -- /*******************************************************
366 -- * civicrm_household
368 -- *******************************************************/
369 ALTER TABLE civicrm_household
370 ADD INDEX index_household_name (household_name);
372 -- /*******************************************************
374 -- * civicrm_individual
376 -- *******************************************************/
377 ALTER TABLE civicrm_individual
378 ADD INDEX index_first_name (first_name),
379 ADD INDEX index_last_name (last_name);
381 -- /*******************************************************
383 -- * civicrm_line_item
385 -- *******************************************************/
386 ALTER TABLE civicrm_line_item
387 ADD INDEX index_entity (entity_table, entity_id);
391 -- /*******************************************************
393 -- * civicrm_location
395 -- *******************************************************/
396 ALTER TABLE civicrm_location
397 MODIFY location_type_id int(10) unsigned NULL DEFAULT NULL;
400 -- /*******************************************************
402 -- * civicrm_membership
404 -- *******************************************************/
405 ALTER TABLE civicrm_membership
406 ADD is_test tinyint(4) NULL DEFAULT '0';
409 -- /*******************************************************
411 -- * civicrm_membership_type
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;
418 -- /*******************************************************
420 -- * civicrm_option_group
422 -- *******************************************************/
423 ALTER TABLE civicrm_option_group
424 ADD label varchar(255) NULL DEFAULT NULL;
426 -- /*******************************************************
428 -- * civicrm_option_value
430 -- *******************************************************/
431 ALTER TABLE civicrm_option_value
432 MODIFY filter int(10) unsigned DEFAULT NULL;
434 -- /*******************************************************
436 -- * civicrm_organization
438 -- *******************************************************/
439 ALTER TABLE civicrm_organization
440 ADD INDEX index_organization_name (organization_name);
444 -- /*******************************************************
446 -- * Insert data into civicrm_payment_processor_type
448 -- *******************************************************/
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 )
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);
462 -- /*******************************************************
464 -- * civicrm_uf_group
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';
472 -- /*******************************************************
474 -- * civicrm_option_group and civicrm_option_value
476 -- *******************************************************/
479 civicrm_option_group (domain_id, name, description, is_reserved, is_active)
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);
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';
494 civicrm_option_value (option_group_id, label, value, name, grouping, filter, is_default, weight, description, is_optgroup, is_reserved, is_active)
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 ),
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 ),
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 ),
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 ),
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 );
540 -- /*******************************************************
542 -- * civicrm_preferences
544 -- *******************************************************/
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 )
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);
550 -- /*******************************************************
554 -- *******************************************************/
555 UPDATE civicrm_location_type SET name = 'Billing' WHERE name IN ('Facturering', 'Facturation', 'Faturamento');
558 -- /*******************************************************
560 -- * dupe rule defaults
562 -- *******************************************************/
564 INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Individual', 20);
566 SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group;
568 INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
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);
574 INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Organization', 10);
576 SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group;
578 INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
580 (@dedupe_rule_group_id, 'civicrm_organization', 'organization_name', 5),
581 (@dedupe_rule_group_id, 'civicrm_email', 'email', 5);
583 INSERT INTO civicrm_dedupe_rule_group (domain_id, contact_type, threshold) VALUES (@domain_id, 'Household', 10);
585 SELECT @dedupe_rule_group_id := MAX(id) FROM civicrm_dedupe_rule_group;
587 INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
589 (@dedupe_rule_group_id, 'civicrm_household', 'household_name', 5),
590 (@dedupe_rule_group_id, 'civicrm_email', 'email', 5);
592 -- /*******************************************************
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");
617 -- /*******************************************************
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");
625 -- /*******************************************************
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");