INSERT INTO  `mn_ExchangeDuesReportItems` (
`id` ,
`number` ,
`description` ,
`price` ,
`mncar_market_id` ,
`member` ,
`first_user` ,
`sorter`
)
VALUES (
16 ,  'OLM-QTR-PP-Duluth',  'First User - Duluth Discount',  '80',  '4',  'n',  'y',  '0'
), (
17 ,  'OLM-QTR-AP-Duluth',  'Additional User - Duluth Discount',  '30',  '4',  'n',  'n',  '0'
);

UPDATE  `mn_ExchangeDuesReportItems` SET  `sorter` =  '16' WHERE  `mn_ExchangeDuesReportItems`.`id` =14 LIMIT 1 ;

UPDATE  `mn_ExchangeDuesReportItems` SET  `sorter` =  '17' WHERE  `mn_ExchangeDuesReportItems`.`id` =15 LIMIT 1 ;

UPDATE  `mn_ExchangeDuesReportItems` SET  `sorter` =  '14' WHERE  `mn_ExchangeDuesReportItems`.`id` =16 LIMIT 1 ;

UPDATE  `mn_ExchangeDuesReportItems` SET  `sorter` =  '15' WHERE  `mn_ExchangeDuesReportItems`.`id` =17 LIMIT 1 ;


ALTER TABLE  `mn_ExchangeDuesReportItems` ADD  `edam` ENUM( 'n',  'y' ) NOT NULL DEFAULT  'n' AFTER  `member` ;

INSERT INTO  `mn_ExchangeDuesReportItems` (
`id` ,
`number` ,
`description` ,
`price` ,
`mncar_market_id` ,
`member` ,
`edam` ,
`first_user` ,
`sorter`
)
VALUES (
18 ,  'OLM-QTR-PP-EDAM',  'First User - EDAM Discount',  '90',  '0',  'n',  'y',  'y',  '6'
), (
19 ,  'OLM-QTR-AP-EDAM',  'Additional User - EDAM Discount',  '40',  '0',  'n',  'y',  'n',  '7'
);

UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '8' WHERE `mn_ExchangeDuesReportItems`.`id` = 6 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '9' WHERE `mn_ExchangeDuesReportItems`.`id` = 7 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '10' WHERE `mn_ExchangeDuesReportItems`.`id` = 8 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '11' WHERE `mn_ExchangeDuesReportItems`.`id` = 9 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '12' WHERE `mn_ExchangeDuesReportItems`.`id` = 10 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '13' WHERE `mn_ExchangeDuesReportItems`.`id` = 11 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '14' WHERE `mn_ExchangeDuesReportItems`.`id` = 12 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '15' WHERE `mn_ExchangeDuesReportItems`.`id` = 13 LIMIT 1;  
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '16' WHERE `mn_ExchangeDuesReportItems`.`id` = 16 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '17' WHERE `mn_ExchangeDuesReportItems`.`id` = 17 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '18' WHERE `mn_ExchangeDuesReportItems`.`id` = 14 LIMIT 1; 
UPDATE `mn_ExchangeDuesReportItems` SET `sorter` = '19' WHERE `mn_ExchangeDuesReportItems`.`id` = 15 LIMIT 1; 

UPDATE  `mn_ExchangeDuesReportItems` SET  `number` =  'Data Feed-CO',
`description` =  'Data Feed Quarterly Subscription for Office Listings' WHERE  `mn_ExchangeDuesReportItems`.`id` =15 LIMIT 1 ;

INSERT INTO `mn_ExchangeDuesReportItems` (
`id` ,
`number` ,
`description` ,
`price` ,
`mncar_market_id` ,
`member` ,
`edam` ,
`first_user` ,
`sorter`
)
VALUES (
'20',  'Data Feed-INDV',  'Data Feed Quarterly Subscription for Individual Listings',  '75',  '0',  'n',  'n',  'n',  '20'
);

INSERT INTO  `mn_ExchangeDuesReportItems` (
`id` ,
`number` ,
`description` ,
`price` ,
`mncar_market_id` ,
`member` ,
`edam` ,
`first_user` ,
`sorter`
)
VALUES (
'21',  'Raw Data Feed',  'Raw Data Feed Quarterly Subscription',  '76',  '0',  'n',  'n',  'n',  '21'
);
