| 1 | -- +--------------------------------------------------------------------+ |
| 2 | -- | CiviCRM version 3.2 | |
| 3 | -- +--------------------------------------------------------------------+ |
| 4 | -- | Copyright CiviCRM LLC (c) 2004-2015 | |
| 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 | -- phpMyAdmin SQL Dump |
| 25 | -- version 2.11.3deb1ubuntu1.1 |
| 26 | -- http://www.phpmyadmin.net |
| 27 | -- |
| 28 | -- Host: localhost |
| 29 | -- Generation Time: Jan 27, 2009 at 04:02 PM |
| 30 | -- Server version: 5.0.51 |
| 31 | -- PHP Version: 5.2.4-2ubuntu5.4 |
| 32 | |
| 33 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 34 | |
| 35 | -- |
| 36 | -- Create Donors / Bidders. |
| 37 | -- |
| 38 | |
| 39 | INSERT INTO `civicrm_contact` (`contact_type`, `sort_name`, `display_name`, `first_name`, `last_name`) |
| 40 | VALUES |
| 41 | ('Individual', 'Mouse Micky', 'Mouse Micky', 'Mickey', 'Mouse'); |
| 42 | |
| 43 | SELECT @donorID := id FROM `civicrm_contact` where `display_name` like 'Mouse Micky'; |
| 44 | |
| 45 | INSERT INTO `civicrm_contact` (`contact_type`, `sort_name`, `display_name`, `first_name`, `last_name`) |
| 46 | VALUES |
| 47 | ('Individual', 'Doo Scooby', 'Doo Scooby', 'Scooby', 'Doo'); |
| 48 | |
| 49 | SELECT @bidderID := id FROM `civicrm_contact` where `display_name` like 'Doo Scooby'; |
| 50 | |
| 51 | -- |
| 52 | -- data for Auction |
| 53 | -- |
| 54 | |
| 55 | INSERT INTO `civicrm_auction` (`id`, `title`, `description`, `start_date`, `end_date`, `item_start_date`, `item_end_date`, `is_approval_needed`, `is_item_groups`, `max_items`, `max_items_user`, `event_id`, `donor_profile_id`, `is_active`) VALUES |
| 56 | (1, 'collectibles', 'collectibles such as stamps, coins, classic cars, fine art, and luxury real estate', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 2, 1), |
| 57 | (2, 'toys', '<p>Nice and Cutiest toys, Children love to have one.........</p>', NULL, NULL, NULL, NULL, 0, 1, 12, 2, NULL, NULL, 1); |
| 58 | |
| 59 | SELECT @auctionCollectID := id FROM `civicrm_auction` where `title` like 'collectibles'; |
| 60 | SELECT @auctionToysID := id FROM `civicrm_auction` where `title` like 'toys'; |
| 61 | |
| 62 | -- |
| 63 | -- data for Auction Items |
| 64 | -- |
| 65 | |
| 66 | INSERT INTO `civicrm_auction_item` (`auction_id`, `donor_id`, `auction_item_type_id`, `title`, `description`, `url`, `sku`, `options`, `image`, `quantity`, `retail_value`, `min_bid_value`, `min_bid_increment`, `buy_now_value`, `bid_start_date`, `bid_end_date`, `is_active`, `is_group`, `parent_id`, `creator_id`, `created_date`, `approver_id`, `approval_date`) VALUES |
| 67 | (@auctionCollectID, @donorID, 3, 'coins', '<p>Frequently collected coins include those that were in circulation for only a brief time, coins minted with errors, or especially beautiful or historically interesting pieces.</p>', NULL, NULL, NULL, NULL, 5, 60.00, 15.00, 3.00, 55.00, NOW(), DATE_ADD(NOW(), INTERVAL 2 DAY), 1, 0, NULL, NULL, NULL, NULL, '2009-01-22 14:48:58'), |
| 68 | (@auctionCollectID, @donorID, 2, 'Stamps', '<p>Collections such as covers (envelopes or packages with stamps on them).</p>', NULL, NULL, NULL, NULL, 200, 500.00, 600.00, 50.00, 700.00, NOW(), DATE_ADD(NOW(), INTERVAL 2 DAY), 1, 0, NULL, @donorID, '2009-01-27 14:27:28', NULL, NULL), |
| 69 | (@auctionCollectID, @donorID, 1, 'Classic car', '<p>Term frequently used to describe an older car, but the exact meaning is subject to differences in opinion.</p>', NULL, NULL, NULL, NULL, 25, 3000.00, 2800.00, 100.00, 3500.00, NOW(), DATE_ADD(NOW(), INTERVAL 2 DAY), 1, 0, NULL, @donorID, '2009-01-27 15:56:49', NULL, NULL), |
| 70 | |
| 71 | (@auctionToysID, @donorID, 3, 'Tom Cat', '<p>The Most Dangerous but Sweet Friend of Jerry in the World</p>', NULL, NULL, NULL, NULL, 12, 65.00, 20.00, 4.50, 62.00, NOW(), DATE_ADD(NOW(), INTERVAL 2 DAY), 1, 0, NULL, @donorID, '2009-01-27 15:56:49', NULL, NULL), |
| 72 | (@auctionToysID, @donorID, 3, 'Jerry Mouse', '<p>The Most Mischievous in the Universe.</p>', NULL, NULL, NULL, NULL, 14, 55.00, 23.00, 3.00, 50.00, NOW(), DATE_ADD(NOW(), INTERVAL 2 DAY), 1, 0, NULL, @donorID, '2009-04-03 22:16:48', NULL, NULL); |
| 73 | |
| 74 | |
| 75 | INSERT INTO `civicrm_auction_bid` (`contact_id`, `auction_item_id`, `bid_value`, `quantity`, `bid_date`, `is_active`, `is_winner`, `quantity_won`, `contribution_id`) VALUES |
| 76 | (@bidderID, 1, 12.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL), |
| 77 | (@bidderID, 2, 100.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL), |
| 78 | (@bidderID, 3, 1500.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL), |
| 79 | (@bidderID, 4, 45.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL), |
| 80 | (@bidderID, 5, 30.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL); |