From e7ace496179388701697ae75c599a4f3992046b4 Mon Sep 17 00:00:00 2001 From: Maggie Date: Tue, 16 Sep 2014 10:48:53 -0400 Subject: [PATCH] CRM-15316 Updating coffee mug data, deleting cost to avoid bug --- sql/civicrm_generated.mysql | 2 +- xml/templates/civicrm_sample.tpl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/civicrm_generated.mysql b/sql/civicrm_generated.mysql index aaf5fbfde7..f21420f114 100644 --- a/sql/civicrm_generated.mysql +++ b/sql/civicrm_generated.mysql @@ -1215,7 +1215,7 @@ UNLOCK TABLES; LOCK TABLES `civicrm_product` WRITE; /*!40000 ALTER TABLE `civicrm_product` DISABLE KEYS */; -INSERT INTO `civicrm_product` (`id`, `name`, `description`, `sku`, `options`, `image`, `thumbnail`, `price`, `currency`, `financial_type_id`, `min_contribution`, `cost`, `is_active`, `period_type`, `fixed_period_start_day`, `duration_unit`, `duration_interval`, `frequency_unit`, `frequency_interval`) 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); +INSERT INTO `civicrm_product` (`id`, `name`, `description`, `sku`, `options`, `image`, `thumbnail`, `price`, `currency`, `financial_type_id`, `min_contribution`, `cost`, `is_active`, `period_type`, `fixed_period_start_day`, `duration_unit`, `duration_interval`, `frequency_unit`, `frequency_interval`) 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',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `civicrm_product` ENABLE KEYS */; UNLOCK TABLES; diff --git a/xml/templates/civicrm_sample.tpl b/xml/templates/civicrm_sample.tpl index 62086a7ad0..e16ecaa292 100644 --- a/xml/templates/civicrm_sample.tpl +++ b/xml/templates/civicrm_sample.tpl @@ -97,7 +97,7 @@ VALUES 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); +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, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO civicrm_premiums_product VALUES (1, 1, 1, 1, NULL); -- 2.25.1