Merge branch 'phpunit-ob-fix' of https://github.com/giant-rabbit/civicrm-core into...

[civicrm-core.git] / tools / sql / civiauction_sample.mysql

-- +--------------------------------------------------------------------+
-- | CiviCRM version 3.2                                                |
-- +--------------------------------------------------------------------+
-- | Copyright CiviCRM LLC (c) 2004-2010                                |
-- +--------------------------------------------------------------------+
-- | This file is a part of CiviCRM.                                    |
-- |                                                                    |
-- | CiviCRM is free software; you can copy, modify, and distribute it  |
-- | under the terms of the GNU Affero General Public License           |
-- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
-- |                                                                    |
-- | CiviCRM is distributed in the hope that it will be useful, but     |
-- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
-- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
-- | See the GNU Affero General Public License for more details.        |
-- |                                                                    |
-- | You should have received a copy of the GNU Affero General Public   |
-- | License and the CiviCRM Licensing Exception along                  |
-- | with this program; if not, contact CiviCRM LLC                     |
-- | at info[AT]civicrm[DOT]org. If you have questions about the        |
-- | GNU Affero General Public License or the licensing of CiviCRM,     |
-- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
-- +--------------------------------------------------------------------+
-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 27, 2009 at 04:02 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Create Donors / Bidders.
--

INSERT INTO `civicrm_contact` (`contact_type`, `sort_name`, `display_name`, `first_name`, `last_name`)
VALUES
('Individual', 'Mouse Micky', 'Mouse Micky', 'Mickey', 'Mouse');

SELECT @donorID := id FROM `civicrm_contact` where `display_name` like 'Mouse Micky';

INSERT INTO `civicrm_contact` (`contact_type`, `sort_name`, `display_name`, `first_name`, `last_name`)
VALUES
('Individual', 'Doo Scooby', 'Doo Scooby', 'Scooby', 'Doo');

SELECT @bidderID := id FROM `civicrm_contact` where `display_name` like 'Doo Scooby';

--
-- data for Auction
--

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
(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),
(2, 'toys', '<p>Nice and Cutiest toys, Children love to have one.........</p>', NULL, NULL, NULL, NULL, 0, 1, 12, 2, NULL, NULL, 1);

SELECT @auctionCollectID := id FROM `civicrm_auction` where `title` like 'collectibles';
SELECT @auctionToysID    := id FROM `civicrm_auction` where `title` like 'toys';

--
-- data for Auction Items
--

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
(@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'),
(@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),
(@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),

(@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),
(@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);


INSERT INTO `civicrm_auction_bid` (`contact_id`, `auction_item_id`, `bid_value`, `quantity`, `bid_date`, `is_active`, `is_winner`, `quantity_won`, `contribution_id`) VALUES
(@bidderID, 1, 12.00,   1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL),
(@bidderID, 2, 100.00,  1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL),
(@bidderID, 3, 1500.00, 1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL),
(@bidderID, 4, 45.00,   1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL),
(@bidderID, 5, 30.00,   1, DATE_ADD(NOW(), INTERVAL 30 MINUTE), 1, 0, NULL, NULL);