Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- +--------------------------------------------------------------------+ |
2 | -- | CiviCRM version 3.2 | | |
3 | -- +--------------------------------------------------------------------+ | |
4 | -- | Copyright CiviCRM LLC (c) 2004-2010 | | |
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); |