-- 2007-04-26
SELECT DISTINCT (
lead_source
), count( lead_source ) 
FROM contacts
GROUP BY lead_source


update contacts set lead_source='direct_mail' where lead_source='Direct Mail' ;

update contacts set lead_source='public_relations' where lead_source='Public Relations' ;

update contacts set lead_source='self_generated' where lead_source='Self Generated' ;

update contacts set lead_source='fair' where lead_source='Trade Show' ;

update contacts set lead_source='other' where lead_source='Other' ;

update contacts set lead_source='hp' where lead_source='Web Site' ;

update contacts set lead_source='partner' where lead_source='Partner' ;


INSERT INTO `productcategory` VALUES ('3480fa69-e858-3edb-3f55-47104903606e', 0, '2007-10-13 04:30:44', '2007-10-13 04:30:44', '1', '1', 'TechnoSMS', 17, NULL);
INSERT INTO `productcategory` VALUES ('2d2d650d-0a0a-4aec-d7ce-471049966827', 0, '2007-10-13 04:30:56', '2007-10-13 04:30:56', '1', '1', 'Infra Solutions', 18, NULL);
INSERT INTO `productcategory` VALUES ('acf66893-0cf6-8d13-f451-47104a366ed7', 0, '2007-10-13 04:31:14', '2007-10-13 04:31:14', '1', '1', 'Home Page Related', 19, NULL);
        
INSERT INTO `product` VALUES ('12ceab27-cdf5-2654-48d8-47104e2f9fc0', 0, '2007-10-13 04:49:14', '2007-10-13 05:28:29', '1', '1', NULL, 'Home Page Related', 'acf66893-0cf6-8d13-f451-47104a366ed7', 'Home Page Maintenance', NULL, '2006-10-02', 30000.00, 0.00, 60000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100001, NULL, '302', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('d89b4797-05ce-9475-3ac8-47104e5573c9', 0, '2007-10-13 04:48:48', '2007-10-13 04:48:48', '1', '1', NULL, NULL, 'acf66893-0cf6-8d13-f451-47104a366ed7', 'Home Page Design', NULL, '2006-10-02', 250000.00, 0.00, 300000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100000, NULL, '301', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('e8d48426-b55d-b6bb-e1b1-47104d43ba56', 0, '2007-10-13 04:47:36', '2007-10-13 04:47:36', '1', '1', NULL, NULL, '2d2d650d-0a0a-4aec-d7ce-471049966827', 'File Server Maintenance', NULL, '2006-10-02', 30000.00, 0.00, 50000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100000, NULL, '202', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('581665d7-207a-2f2f-fa15-47104d24ae5e', 0, '2007-10-13 04:45:41', '2007-10-13 04:46:53', '1', '1', NULL, 'Infra Solutions', '2d2d650d-0a0a-4aec-d7ce-471049966827', 'Network Maintenance', NULL, '2006-10-02', 100000.00, 0.00, 150000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100001, NULL, '212', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('3484f459-3e68-e4c8-1c1b-47104d124d27', 0, '2007-10-13 04:45:09', '2007-10-13 04:46:33', '1', '1', NULL, 'Infra Solutions', '2d2d650d-0a0a-4aec-d7ce-471049966827', 'Network Setup', NULL, '2006-10-02', 400000.00, 0.00, 500000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100000, NULL, '211', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('ada85582-30d9-57d9-aea6-47104de1ee99', 0, '2007-10-13 04:44:28', '2007-10-13 04:44:28', '1', '1', NULL, NULL, '2d2d650d-0a0a-4aec-d7ce-471049966827', 'File Server Setting', NULL, '2006-10-02', 200000.00, 0.00, 300000.00, NULL, NULL, 5, 'www.technopian.com', NULL, NULL, 100000, NULL, '201', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('db9daf6c-6aec-6822-fd85-47104c8a03a1', 0, '2007-10-13 04:43:07', '2007-10-13 04:43:33', '1', '1', NULL, 'TechnoSMS', '3480fa69-e858-3edb-3f55-47104903606e', 'TechnoSMS Monthly Fee', NULL, '2006-10-02', 120000.00, 0.00, 150000.00, NULL, NULL, 5, 'www.technosms.com', NULL, NULL, 100001, NULL, '104', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('17fd4379-eeac-8f05-ba47-47104c6dfae5', 0, '2007-10-13 04:42:36', '2007-10-13 04:42:36', '1', '1', NULL, NULL, '3480fa69-e858-3edb-3f55-47104903606e', 'TechnoSMS Import Fee', NULL, '2006-10-02', 300000.00, 0.00, 500000.00, NULL, NULL, 5, 'www.technosms.com', NULL, NULL, 100000, NULL, '103', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('6cf6a7fc-c11f-29d7-65c5-47104c196a3d', 0, '2007-10-13 04:42:07', '2007-10-13 04:42:07', '1', '1', NULL, NULL, '3480fa69-e858-3edb-3f55-47104903606e', 'TechnoSMS Customization Fee', NULL, '2006-10-02', 800000.00, 0.00, 1000000.00, NULL, NULL, 5, 'www.technosms.com', NULL, NULL, 100000, NULL, '102', NULL, NULL, 'sssssss-1111');
INSERT INTO `product` VALUES ('dd433ad9-1696-dff7-4af5-47104c64c432', 0, '2007-10-13 04:41:13', '2007-10-13 04:41:13', '1', '1', NULL, NULL, '3480fa69-e858-3edb-3f55-47104903606e', 'TechnoSMS Initial Fee', NULL, '2006-10-02', 400000.00, 0.00, 500000.00, NULL, NULL, 5, 'www.technosms.com', NULL, NULL, 100000, NULL, '101', NULL, NULL, 'sssssss-1111');
        
-- freesms users import  2008-10-19
-- freesms users list are created into c1 table in metehan's local PC (c0 is the original contacts table)

UPDATE c0, c1 SET c0.company_name= c1.company_name WHERE c1.email1 = c0.email1 AND c0.company_name IS NULL ;
UPDATE c0, c1 SET c0.lead_source = c1.lead_source WHERE c1.email1 = c0.email1 AND c0.lead_source IS NULL ;
UPDATE c0, c1 SET c0.custom_var13 = c1.custom_var13 WHERE c1.email1 = c0.email1 AND c0.custom_var13 IS NULL ;
UPDATE c0, c1 SET c0.custom_var15 = c1.custom_var15 WHERE c1.email1 = c0.email1 AND c0.custom_var15 IS NULL ;
UPDATE c0, c1 SET c0.date_modified = '2008-10-19 09:11:11' WHERE c1.email1 = c0.email1 ;
UPDATE c0, c1 SET c0.custom_var15 = 'using_freeSMS' WHERE c1.email1 = c0.email1 AND c0.custom_var15 = c1.company_name ;
UPDATE c0, c1 SET c1.existing = '1' WHERE c1.email1 = c0.email1 ;

-- opportunities who is to be guided to basic are created into c2 table in metehan's local PC (c0 is the original contacts table)


-- set the applied_contact default to 0 (56763) mon
ALTER TABLE sms_fee CHANGE applied_contact applied_contact TINYINT(4) DEFAULT 0 NULL;