DELETE FROM `mn_DuesReportItems` WHERE `mn_DuesReportItems`.`id` =10 LIMIT 1 ;
DELETE FROM `mn_DuesReportItems` WHERE `mn_DuesReportItems`.`id` =11 LIMIT 1 ;

CREATE TABLE IF NOT EXISTS `mn_DuesReportMncarL` (
  `id` int(10) NOT NULL auto_increment,
  `number` varchar(16) NOT NULL default '',
  `description` varchar(128) NOT NULL default '',
  `quantity` int(11) NOT NULL default '0',
  `price` decimal(6,2) NOT NULL default '0.00',
  `sorter` int(11) NOT NULL default '0',
  `subsorter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mn_DuesReportMncarL`
--

INSERT INTO `mn_DuesReportMncarL` (`id`, `number`, `description`, `quantity`, `price`, `sorter`, `subsorter`) VALUES
(1, 'MNCAR-AFFIL', 'MNCAR AFFILIATE MEMBERSHIP', 1, 195.00, 0, 0),
(2, 'MNCAR-LIC', 'LICENSED MEMBERSHIP DUES', 1, 205.00, 1, 0),
(3, 'MNCAR-CED', 'MNCAR COMMUNITY/ECON DEVEL MEMBERSHIP', 1, 195.00, 2, 0);

--
-- Table structure for table `mn_DuesReportMncarL2MemberType`
--

CREATE TABLE IF NOT EXISTS `mn_DuesReportMncarL2MemberType` (
  `id_dues_report` int(11) NOT NULL default '0',
  `member_type` enum('mncar','mncar_l','misc') NOT NULL default 'mncar_l',
  `id_member_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_dues_report`,`member_type`,`id_member_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mn_DuesReportMncarL2MemberType`
--

INSERT INTO `mn_DuesReportMncarL2MemberType` (`id_dues_report`, `member_type`, `id_member_type`) VALUES
(1, 'mncar_l', 2),
(2, 'mncar_l', 1),
(3, 'mncar_l', 3),
(3, 'mncar_l', 4);


CREATE TABLE IF NOT EXISTS `mn_DuesReportItems2MemberType` (
  `id_dues_report` int(11) NOT NULL default '0',
  `member_type` enum('mncar','mncar_l','misc') NOT NULL default 'mncar',
  `id_member_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_dues_report`,`member_type`,`id_member_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `mn_DuesReportItems2MemberType`
SELECT id, 'mncar', id_mncar_type
FROM `mn_DuesReportItems`;

ALTER TABLE `mn_DuesReportItems`
  DROP `id_mncar_type`,
  DROP `id_mncar_l_type`;
