CREATE TABLE IF NOT EXISTS `mwmberships` (
  `shopper_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) DEFAULT NULL,
  `shopper_group_name` varchar(32) DEFAULT NULL,
  `shopper_group_desc` text,
  `shopper_group_discount` decimal(5,2) NOT NULL DEFAULT '0.00',
  `show_price_including_tax` tinyint(1) NOT NULL DEFAULT '1',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`shopper_group_id`),
  KEY `idx_shopper_group_vendor_id` (`vendor_id`),
  KEY `idx_shopper_group_name` (`shopper_group_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Shopper Groups that users can be assigned to' AUTO_INCREMENT=24 ;

--
-- Dumping data for table `jos_vm_shopper_group`
--

INSERT INTO `jos_vm_shopper_group` (`shopper_group_id`, `vendor_id`, `shopper_group_name`, `shopper_group_desc`, `shopper_group_discount`, `show_price_including_tax`, `default`) VALUES
(5, 1, 'Non-Members', 'Group 5 - This is for people who do not want to be Members but wish to attend an OUPS event.<br />', 0.00, 0, 1),
(6, 1, 'Annual Members £15', '<p>Group 6 - This is for all OUPS Members who pay their subscriptions annually. All subscriptions expire on 31 December each year.</p>', 0.00, 1, 0),
(13, 1, 'Standing Order Members', '<p>Group - 13 This group is for those OUPS Members who pay their annual membership by Standing Order each year. All subscriptions expire on 31 December each year.</p>', 0.00, 0, 0),
(10, 1, 'At Cost', '<p>Group 10 - This category includes committee members, who stay in En-Suite accommodation at cost.</p>', 0.00, 0, 0),
(17, 1, 'Guest At Cost', '<p>Group - 17 Guests include speakers and speakers'' wives who stay in accommodation at cost but who do not pay membership fees.</p>', 0.00, 0, 0),
(14, 1, 'Honorary Members', '<p>Group 14 - Honorary Members do not pay membership fees and pay ordinary member rates at events. Their membership does not expire.</p>', 0.00, 0, 0),
(15, 1, 'Introductory Members', '<p>Group 15 - Introductory Members are DSE212 students who have taken out OUPS Membership Sept-Dec. Their membership expires on 31&nbsp;December of teh following&nbsp;year and they must then be moved into the Annual Members £15 shopper group.</p>', 0.00, 0, 0),
(16, 1, 'Lifetime Members £150', '<p>Group 16 - Lifetime Members have paid £150 for lifetime mebership, so their membership does not expire.</p>', 0.00, 0, 0),
(18, 1, 'Member 2011', '<p>This is the category for people who are members in 2011 -&nbsp;for those&nbsp;joing from October 2010, and those renewing in 2011.&nbsp;</p>', 0.00, 1, 0),
(20, 1, 'Conference Day - Member', '<p>This is the day rate shopper group for the Annual Conferece for members at a cost of £75. </p>', 0.00, 1, 0),
(21, 1, 'Conference Day - Non-member', '<p>This is the day rate shopper group for the Annual Conferece for non-members at a cost of £90. </p>', 0.00, 0, 0),
(22, 1, 'DE100 Oct2014', '<p>&nbsp;This group is for DE100 students starting in October 2014 who are entitled to free membership for a year. Free membership expires after 12 months. They will only receive newsletters electronically.</p>', 0.00, 0, 0),
(23, 1, 'DE100Feb2015', '<p>&nbsp;T<span style="color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 11px; line-height: normal; background-color: #ffffdd">his group is for DE100 students starting in February 2015 who are entitled to free membership for a year. Free membership expires after 12 months. They will only receive newsletters electronically.</span></p>', 0.00, 0, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;