crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/tools/sql/civiauction_sample.mysql

   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);