-- +--------------------------------------------------------------------+
--- | CiviCRM version 4.3 |
+-- | CiviCRM version 4.4 |
-- +--------------------------------------------------------------------+
-- | Copyright CiviCRM LLC (c) 2004-2013 |
-- +--------------------------------------------------------------------+
-- | GNU Affero General Public License or the licensing of CiviCRM, |
-- | see the CiviCRM license FAQ at http://civicrm.org/licensing |
-- +--------------------------------------------------------------------+
+--
+-- Generated from {$smarty.template}
+-- {$generated}
+--
SELECT @domainID := id FROM civicrm_domain where name = 'Default Domain Name';
VALUES ( @priceSetId, 'contribution_amount', 'Contribution Amount', 'Radio', 0, 2, 1, 1, 1, 0, 1),
( @priceSetId, 'other_amount', 'Other Amount', 'Text', 0, 3, 0, 1, 1, 0, 1);
-INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
+INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
VALUES ('civicrm_contribution_page', 1, @priceSetId);
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'contribution_amount';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'friend','Friend','1.00',1,1,0,1),
(@priceFieldID,'supporter', 'Supporter','5.00',2,1,0,1),
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'other_amount';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID, 'other_amount', 'Other Amount', 1, 3, 1, 0, 1);
-
+
INSERT INTO civicrm_contribution_page
(title,intro_text,financial_type_id,is_monetary,is_allow_other_amount,default_amount_id,min_amount,max_amount,goal_amount,thankyou_title,thankyou_text,thankyou_footer,receipt_from_name,receipt_from_email,cc_receipt,bcc_receipt,receipt_text,is_active,footer_text,amount_block_is_active,honor_block_is_active,honor_block_title,honor_block_text,currency,is_email_receipt)
VALUES
('civicrm_contribution_page', 2, '{literal}a:2:{i:1;i:0;i:2;i:0;}{/literal}', 1, 1, 0, 'Membership Levels', 'Please select the appropriate membership level below. You will have a chance to review your selection and the corresponding dues on the next page prior to your credit card being charged.', 'Renew or Upgrade Your Membership', 'Information on your current membership level and expiration date is shown below. You may renew or upgrade at any time - but don''t let your membership lapse!', 1, 1);
INSERT INTO civicrm_pledge_block ( entity_table, entity_id, pledge_frequency_unit, is_pledge_interval, max_reminders, initial_reminder_day, additional_reminder_day)
-VALUES
+VALUES
('civicrm_contribution_page', 3, 'week\ 1month\ 1year', 1, 1, 5, 5),
('civicrm_contribution_page', 1, 'week\ 1month\ 1year', 0, 2, 5, 5);
-
-INSERT INTO civicrm_premiums
+
+INSERT INTO civicrm_premiums
VALUES (1, 'civicrm_contribution_page', 1, 1, 'Thank-you Gifts', 'We appreciate your support and invite you to choose from the exciting collection of thank-you gifts below. Minimum contribution amounts for each selection are included in the descriptions. (NOTE: These gifts are shown as examples only. No gifts will be sent to donors.)', 'premiums@example.org', NULL, 1, 'No thank-you', 1);
INSERT INTO civicrm_product VALUES (1, 'Coffee Mug', 'This heavy-duty mug is great for home or office, coffee or tea or hot chocolate. Show your support to family, friends and colleagues. Choose from three great colors.', 'MUG-101', 'White, Black, Green', NULL, NULL, 12.50, 'USD', NULL, 5.00, 2.25, 1, NULL, NULL, NULL, NULL, NULL, NULL);
SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type';
SELECT @option_value_max_val := max(ROUND(civicrm_option_value.value)) from civicrm_option_value where option_group_id = @option_group_id_act;
-INSERT INTO
- `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
+INSERT INTO
+ `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
VALUES
(@option_group_id_act, 'Interview', (SELECT @option_value_max_val := @option_value_max_val + 1), 'Interview', NULL, 0, NULL, @option_value_max_val, 'Conduct a phone or in person interview.', 0, 0, 1);
( 'Staff' , '{ts escape="sql"}Staff{/ts}' , NULL, 1, 1, 0),
( 'Team' , '{ts escape="sql"}Team{/ts}' , NULL, 3, 1, 0),
( 'Sponsor' , '{ts escape="sql"}Sponsor{/ts}' , NULL, 3, 1, 0);
-
+
SELECT @domain_id := min(id) FROM civicrm_domain;
SELECT @nav_indi := id FROM civicrm_navigation WHERE name = 'New Individual';
SELECT @nav_org := id FROM civicrm_navigation WHERE name = 'New Organization';
INSERT INTO `civicrm_navigation`
- ( domain_id, url, label, name,permission, permission_operator, parent_id, is_active, has_separator, weight )
+ ( domain_id, url, label, name,permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES
- ( @domain_id, 'civicrm/contact/add&ct=Individual&cst=Student&reset=1' , 'New Student', 'New Student', 'add contacts', '', @nav_indi, '1', NULL, 1 ),
+ ( @domain_id, 'civicrm/contact/add&ct=Individual&cst=Student&reset=1' , 'New Student', 'New Student', 'add contacts', '', @nav_indi, '1', NULL, 1 ),
( @domain_id, 'civicrm/contact/add&ct=Individual&cst=Parent&reset=1' , 'New Parent' , 'New Parent' , 'add contacts', '', @nav_indi, '1', NULL, 2 ),
( @domain_id, 'civicrm/contact/add&ct=Individual&cst=Staff&reset=1' , 'New Staff' , 'New Staff' , 'add contacts', '', @nav_indi, '1', NULL, 3 ),
( @domain_id, 'civicrm/contact/add&ct=Organization&cst=Team&reset=1' , 'New Team' , 'New Team' , 'add contacts', '', @nav_org , '1', NULL, 1 ),
( @domain_id, 'civicrm/contact/add&ct=Organization&cst=Sponsor&reset=1', 'New Sponsor', 'New Sponsor', 'add contacts', '', @nav_org , '1', NULL, 2 );
--- Add sample dashlets
+-- Add sample dashlets
-INSERT INTO `civicrm_dashboard`
- ( `domain_id`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `is_fullscreen`, `fullscreen_url`)
- VALUES
- ( @domain_id, '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Top Donors{/ts}' , 'civicrm/report/instance/13&reset=1§ion=2&snippet=5', 'access CiviContribute', 'AND', 0, 0,'1', 5, '1', 'civicrm/report/instance/13&reset=1§ion=2&snippet=5&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen'),
- ( @domain_id, '{ts escape="sql"}Membership Summary{/ts}' , 'civicrm/report/instance/20&reset=1§ion=2&snippet=5', 'access CiviMember' , 'AND', 0, 0,'1', 7, '1', 'civicrm/report/instance/20&reset=1§ion=2&snippet=5&context=dashletFullscreen');
-
--- INSERT sample data for membership
+INSERT INTO `civicrm_dashboard`
+ ( `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `is_fullscreen`, `fullscreen_url`)
+ VALUES
+ ( @domain_id, 'report/6', '{ts escape="sql"}Donor Summary{/ts}' , 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart', 'access CiviContribute', 'AND', 0, 0,'1', 4, '1', 'civicrm/report/instance/6&reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen'),
+ ( @domain_id, 'report/13', '{ts escape="sql"}Top Donors{/ts}' , 'civicrm/report/instance/13&reset=1§ion=2&snippet=5', 'access CiviContribute', 'AND', 0, 0,'1', 5, '1', 'civicrm/report/instance/13&reset=1§ion=2&snippet=5&context=dashletFullscreen'),
+ ( @domain_id, 'report/25', '{ts escape="sql"}Event Income Summary{/ts}', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart', 'access CiviEvent' , 'AND', 0, 0,'1', 6, '1', 'civicrm/report/instance/25&reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen'),
+ ( @domain_id, 'report/20', '{ts escape="sql"}Membership Summary{/ts}' , 'civicrm/report/instance/20&reset=1§ion=2&snippet=5', 'access CiviMember' , 'AND', 0, 0,'1', 7, '1', 'civicrm/report/instance/20&reset=1§ion=2&snippet=5&context=dashletFullscreen');
+
+-- INSERT sample data for membership
SELECT @financial_type_id := max(id) FROM `civicrm_financial_type` WHERE `name` = 'Member Dues';
SELECT @priceSetID := max(id) FROM `civicrm_price_set` WHERE `name` LIKE 'default_membership_type_amount' AND `is_quick_config` = 1;
-INSERT INTO `civicrm_price_field` ( `price_set_id`, `name`, `label`, `html_type` )
+INSERT INTO `civicrm_price_field` ( `price_set_id`, `name`, `label`, `html_type` )
VALUES ( @priceSetID, '1', 'Membership Amount', 'Radio' );
SELECT @priceFieldId := max(id) FROM `civicrm_price_field` WHERE `name` LIKE '1';
SELECT @membershipIdS := max(id) FROM `civicrm_membership_type` WHERE name= 'Student';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `membership_type_id`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `membership_type_id`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'General','General','100.00', 1, @membershipIdG, 1, 1, @financial_type_id),
(@priceFieldID,'Student','Student','50.00', 1, @membershipIdS , 1, 0, @financial_type_id);
INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `visibility_id`)
VALUES ( @priceSetId, 'other_amount', 'Contribution Amount', 'Text', 0, 3, 0, 1, 1, 1, 1);
-INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
+INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
VALUES ('civicrm_contribution_page', 3, @priceSetId);
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'other_amount';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'other_amount','Contribution Amount','1',1,1,0,1);
INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `visibility_id`)
VALUES ( @priceSetId, 'tournament_fees', 'Tournament Fees', 'Radio', 0, 1, 1, 1, 1, 1, 1);
-INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
+INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
VALUES ('civicrm_event', 3, @priceSetId);
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'tournament_fees';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'tiny_tots__ages_5_8_','Tiny-tots (ages 5-8)','800',1,1,1,4),
(@priceFieldID,'junior_Stars__ages_9_12_','Junior Stars (ages 9-12)','1000',2,1,0,4),
INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `visibility_id`)
VALUES ( @priceSetId, 'dinner_contribution', 'Dinner Contribution', 'Radio', 0, 1, 1, 1, 1, 1, 1);
-INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
+INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
VALUES ('civicrm_event', 1, @priceSetId);
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'dinner_contribution';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'single','Single','50',1,1,1,4),
(@priceFieldID,'couple','Couple','100',2,1,0,4),
INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`, `is_enter_qty`, `weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`, `visibility_id`)
VALUES ( @priceSetId, 'festival_fee', 'Festival Fee', 'Radio', 0, 1, 1, 1, 1, 1, 1);
-INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
+INSERT INTO `civicrm_price_set_entity` (`entity_table`,`entity_id`,`price_set_id`)
VALUES ('civicrm_event', 2, @priceSetId);
SELECT @priceFieldID := max(id) FROM `civicrm_price_field` WHERE `price_set_id` = @priceSetId AND name = 'festival_fee';
-INSERT INTO
- `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
+INSERT INTO
+ `civicrm_price_field_value` (`price_field_id`,`name`,`label`, `amount`, `weight`, `is_active`, `is_default`, `financial_type_id`)
VALUES
(@priceFieldID,'bass','Bass','25',1,1,1,2),
(@priceFieldID,'tenor','Tenor','40',2,1,0,2),
(@priceFieldID,'soprano','Soprano','50',3,1,0,2);
-
projects / civicrm-core.git / blobdiff