-- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 01, 2008 at 11:02 AM -- Server version: 4.1.22 -- PHP Version: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `sandiego_sugarcrm` -- --CREATE DATABASE `sandiego_sugarcrm` DEFAULT CHARACTER SET utf8 COLLATE --utf8_general_ci; --USE `sandiego_sugarcrm`; -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE `accounts` ( `id` varchar(36) NOT NULL default '', `name` varchar(150) default NULL, `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `account_type` varchar(25) default NULL, `industry` varchar(25) default NULL, `annual_revenue` varchar(25) default NULL, `phone_fax` varchar(25) default NULL, `billing_address_street` varchar(150) default NULL, `billing_address_city` varchar(100) default NULL, `billing_address_state` varchar(100) default NULL, `billing_address_postalcode` varchar(20) default NULL, `billing_address_country` varchar(255) default NULL, `rating` varchar(25) default NULL, `phone_office` varchar(25) default NULL, `phone_alternate` varchar(25) default NULL, `website` varchar(255) default NULL, `ownership` varchar(100) default NULL, `employees` varchar(10) default NULL, `ticker_symbol` varchar(10) default NULL, `shipping_address_street` varchar(150) default NULL, `shipping_address_city` varchar(100) default NULL, `shipping_address_state` varchar(100) default NULL, `shipping_address_postalcode` varchar(20) default NULL, `shipping_address_country` varchar(255) default NULL, `parent_id` varchar(36) default NULL, `sic_code` varchar(10) default NULL, `campaign_id` varchar(36) default NULL, PRIMARY KEY (`id`), KEY `idx_accnt_id_del` (`id`,`deleted`), KEY `idx_accnt_assigned_del` (`deleted`,`assigned_user_id`), KEY `idx_accnt_parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` VALUES('47900aa6-20ac-3ecf-921f-47f0193acb79', 'Company Name', '2008-03-30 22:59:23', '2008-03-30 23:00:47', '1', '1', NULL, 1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('e3c75676-c136-a0cf-d969-47f01e7594b1', 'Account', '2008-03-30 23:11:41', '2008-03-30 23:12:25', '1', '1', 'Description', 1, '1', NULL, NULL, NULL, 'Fax Phone', NULL, NULL, 'State', NULL, NULL, NULL, 'Office Phone', NULL, 'website', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('95e50a7e-b3e4-ecab-67e8-47f019fc567d', 'Enviromold Solutions, Inc.', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Broward County, Fort Lauderdale, Miami Dade County, Miami, West Palm, Martin County, Port St. Lucie, Plantation, Hollywood, Palm Beach County,', 0, '1', NULL, NULL, NULL, '954-775-2599', NULL, NULL, 'Florida', NULL, NULL, NULL, '954-205-4044', '954-594-5027', 'enviromoldsolutions.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CMCA', NULL); INSERT INTO `accounts` VALUES('b09702d5-fad8-db7d-0d3e-47f019b91c05', 'ACME Home Inspection, Inc.', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Miami-Dade County', 0, '1', NULL, NULL, NULL, '305-385-7597', NULL, NULL, 'Florida', NULL, NULL, NULL, '305-382-5200', '305-338-8815', 'acmehomeinspections.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CIAQM', NULL); INSERT INTO `accounts` VALUES('c8b40a59-d1de-2fc3-8398-47f0194c8330', '1st Discovery Environmental', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Chandler, Gilbert, Mesa, QC, Gold Canyon, Apache Junction', 0, '1', NULL, NULL, NULL, '480 393.7392', NULL, NULL, 'Arizona', NULL, NULL, NULL, NULL, '480 234.2129', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('e4ec0493-0090-c126-b573-47f019410358', 'A Quality Indoor Environment, LLC', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Pinellas, Pasco, Hillsborough, Hernando, Manatee, Sarasota Counties', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, 'Florida', NULL, NULL, NULL, '727-521-0304', '727-458-6682', 'www.qualityindoor.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CMI', NULL); INSERT INTO `accounts` VALUES('f9910b79-d1cf-da01-f2af-47f0198e5f37', 'Air Quality Consultants, Inc.', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Northern California', 0, '1', NULL, NULL, NULL, '530-273-mold', NULL, NULL, 'California', NULL, NULL, NULL, '530-273-6653', '530-701-3936', 'www.airqualityconsultants.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CIEC', NULL); INSERT INTO `accounts` VALUES('11264508-b0d4-35ba-d302-47f019509a07', 'Advance Look Building Inspections & Environmental Testing', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Anchorage, MatSu & the Alaskan Bush', 0, '1', NULL, NULL, NULL, '907-357-3967', NULL, NULL, 'Alaska', NULL, NULL, NULL, '907-357-3967', '907-232-1007', 'www.advancelookak.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CRMI', NULL); INSERT INTO `accounts` VALUES('12a9282a-b11d-9ea2-f73f-47f019707ce7', 'ABB Environmental Services, Inc.', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Arkansas', 0, '1', NULL, NULL, NULL, '(866) 334-6925', NULL, NULL, 'Arkansas', NULL, NULL, NULL, '(501) 269 -4770', NULL, 'www.abbenvironmentalservices.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CRMI', NULL); INSERT INTO `accounts` VALUES('142a08b8-2031-e66e-a692-47f0196f66ed', 'Pillar to Post Home Inspection', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Tempe, Mesa, Apache Junction, Gold Canyon', 0, '1', NULL, NULL, NULL, '(480)357-4911', NULL, NULL, 'Arizona', NULL, NULL, NULL, '(480) 628-9175', NULL, 'pillartopost.com/mesa/local-home-inspection-services.aspx', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CRMI', NULL); INSERT INTO `accounts` VALUES('15aaa11b-50b4-d148-2f42-47f0198f7e8b', 'Mold Patrol', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Placer, Nevada, El Dorado, Sacramento Counties', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, 'California', NULL, NULL, NULL, '530-878-3688', NULL, 'MoldPatrol.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CRMI', NULL); INSERT INTO `accounts` VALUES('172860e5-cb84-1e42-0d50-47f01968d49f', 'Building Specs LLC', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Treasure and Magic Valleys', 0, '1', NULL, NULL, NULL, '(208) 323-4903', NULL, NULL, 'Idaho', NULL, NULL, NULL, '(208) 323-4900', '(208) 602-2112', 'www.buildingspecs.us/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CRMI', NULL); INSERT INTO `accounts` VALUES('18ac05c8-2df6-05ea-8100-47f019031a38', 'Professional Home & Building Inspectors', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'South and Central Jersey', 0, '1', NULL, NULL, NULL, '609-704-9408', NULL, NULL, 'New Jersey', NULL, NULL, NULL, '609-704-8547', '609-410-3770', 'www.PHBInspectors.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CMI', NULL); INSERT INTO `accounts` VALUES('1a2c7677-f403-4b38-e078-47f019de6e64', 'Bay Area Air Testing', '2008-03-30 22:51:54', '2008-03-30 22:51:54', '1', '1', 'Greater San Francisco Bay Area', 0, '1', NULL, NULL, NULL, '650 595-0775', NULL, NULL, 'California', NULL, NULL, NULL, '650 595-0775', '650 454-0651', 'bayareaairtesting.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CMI', NULL); INSERT INTO `accounts` VALUES('e52485ac-7c4b-dbec-aa79-47f01e12872c', 'Enviro-Rite Products & Services Inc.', '2008-03-30 23:11:41', '2008-03-30 23:11:41', '1', '1', 'Santa Barbara, San Luis Obispo, Santa Clara', 0, '1', NULL, NULL, NULL, '(805) 735-9938', NULL, NULL, 'California', NULL, NULL, NULL, '(805) 735-4848', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('e6d1bea0-3fa0-c5ac-fe32-47f01ee52c66', 'Applied Real Estate Inspections', '2008-03-30 23:11:41', '2008-03-30 23:11:41', '1', '1', 'Central Coast', 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('e809eaa2-5ab0-6a31-9b8d-47f01e77b4a3', 'J&P Inspections LLC', '2008-03-30 23:11:41', '2008-03-30 23:11:41', '1', '1', 'Offering home inspection services in Adel, Altoona, Ames, Ankeny, Baxter, Boone, Boone Co., Boonville, Cambridge, Clide, Collins, Dallas Co., Des Moines, Dexter, Harvey, Huxley, Indianola, Jasper Co., Johnston, Kellogg, Knoxville, Lacona, Macksburg, Madis', 0, '1', NULL, NULL, NULL, '515-953-6682', NULL, NULL, 'Iowa', NULL, NULL, NULL, '515-285-5422', NULL, 'rnpro.net/i/j&pinspections/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('e97f83ea-2d53-3e96-7f31-47f01e0f770d', 'Advanced Building Consultants', '2008-03-30 23:11:41', '2008-03-30 23:11:41', '1', '1', 'North Florida', 0, '1', NULL, NULL, NULL, '866.784.2597', NULL, NULL, 'Florida', NULL, NULL, NULL, '386.462.9144', NULL, 'rnpro.net/i/AdvancedBuildingConsultants/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('1d9bb805-185a-42bf-3324-47f0216fa5eb', 'Enviro Rite Products And Services', '2008-03-30 23:27:32', '2008-03-30 23:27:32', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, 'P.O. Box 1498', 'Lompoc', 'Ca', '93436-3120', NULL, NULL, '(805) 735-4848', NULL, NULL, NULL, NULL, NULL, '3000 Silver Sage Ln.', 'Lompoc', 'Ca', '93436-3120', NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('31c16efb-2984-95b3-adb9-47f02aac2e09', 'Benoit Exterior Designs', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '(760) 231-5552', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('332180b4-a6e1-1237-f383-47f02a38c74b', 'Bonsall United School District', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, '760-941-4409', NULL, NULL, NULL, NULL, NULL, NULL, '760-631-5200', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('345dab8f-1d96-5d12-ac42-47f02ad38720', 'Children''s Heritage Foundation', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('359adc85-fef6-bb7d-280a-47f02a802974', 'Demo Dawg', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('36e1d89e-b7f2-cf1d-774f-47f02a2c063f', 'Gold Coast Skylights', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, '(760) 758-1539', NULL, NULL, NULL, NULL, NULL, NULL, '(760) 758-2864', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('381e4f82-cb04-f096-6020-47f02ac9abff', 'HotSpring Spas of North County', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, '760-746-6799', NULL, NULL, NULL, NULL, NULL, NULL, '760-746-2900', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3960c0d3-75ff-7a15-8a77-47f02afc0759', 'Junglescapes', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3a95597f-1822-e9fa-57e3-47f02a15ef21', 'Kenyon Plastering, Inc', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, '(602) 278-6801', NULL, NULL, NULL, NULL, NULL, NULL, '(602) 233-1191', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3bc6a2cc-6a04-e0d7-3084-47f02ab37f90', 'Parkway Palms', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '858-484-9111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3cfcae1b-5172-df92-db4f-47f02a922313', 'Rolling Hills Production', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3e2b73ef-5b7c-f055-5855-47f02a4ff3c5', 'Sandpiper Pools', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, '(909) 672-6633', NULL, NULL, NULL, NULL, NULL, NULL, '909.237.3815', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('3f671082-0e9d-835f-e481-47f02a59c15d', 'Shred-it Connecticut', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '203-699-2458', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('4097fc32-eedf-1fec-4522-47f02ab3fcd2', 'Shred-it San Diego', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '760 598-5700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('41de3224-6e59-ab28-b1bd-47f02ac1aa88', 'Simply Ambrosia', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('430e9d40-5625-ed06-2ebf-47f02a28254d', 'thesmarternetwork.com', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('44504a99-ade3-1a32-6aad-47f02a80e2e8', 'Valley Operational Wear', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '865-577-2923 x226', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('45823b83-6f48-20a6-ba9d-47f02a08353a', 'World Buyers', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('46af885b-caef-eae8-e6b8-47f02a0a4ef5', 'Leaping Lotus', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('47e4ed1d-6a61-0c49-f663-47f02a90c8a1', 'ZibbyZabby', '2008-03-31 00:05:09', '2008-03-31 00:05:09', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('a38022a3-f3f7-2eee-1df1-47f06c90034a', 'Arizona Professional Home Inspection L.L.C.', '2008-03-31 04:45:54', '2008-03-31 04:45:54', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '480-510-5865', NULL, 'http://www.AzProHomeInspection.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `accounts` VALUES('190388c5-7a87-fd88-3f1f-47f1210ba5b4', 'US Mailing House', '2008-03-31 17:39:06', '2008-03-31 17:39:06', '1', '1', NULL, 0, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '760-940-9455', NULL, 'http://usmailinghouse.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `accounts_audit` -- CREATE TABLE `accounts_audit` ( `id` varchar(36) NOT NULL default '', `parent_id` varchar(36) NOT NULL default '', `date_created` datetime default NULL, `created_by` varchar(36) default NULL, `field_name` varchar(100) default NULL, `data_type` varchar(100) default NULL, `before_value_string` varchar(255) default NULL, `after_value_string` varchar(255) default NULL, `before_value_text` text, `after_value_text` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts_audit` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts_bugs` -- CREATE TABLE `accounts_bugs` ( `id` varchar(36) NOT NULL default '', `account_id` varchar(36) default NULL, `bug_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_acc_bug_acc` (`account_id`), KEY `idx_acc_bug_bug` (`bug_id`), KEY `idx_account_bug` (`account_id`,`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts_bugs` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts_cases` -- CREATE TABLE `accounts_cases` ( `id` varchar(36) NOT NULL default '', `account_id` varchar(36) default NULL, `case_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_acc_case_acc` (`account_id`), KEY `idx_acc_acc_case` (`case_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts_cases` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts_contacts` -- CREATE TABLE `accounts_contacts` ( `id` varchar(36) NOT NULL default '', `contact_id` varchar(36) default NULL, `account_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_account_contact` (`account_id`,`contact_id`), KEY `idx_contid_del_accid` (`contact_id`,`deleted`,`account_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts_contacts` -- INSERT INTO `accounts_contacts` VALUES('64d90073-fd1d-0dbf-f98c-47f01b14482e', 'd4d00632-46b4-d3b4-d85a-47f01b61098f', '47900aa6-20ac-3ecf-921f-47f0193acb79', '2008-03-30 23:15:34', 1); INSERT INTO `accounts_contacts` VALUES('8881095a-a5c1-8a14-60e9-47f01bc56d5c', '7ed80e67-f490-7683-b2d5-47f01b29feab', '95e50a7e-b3e4-ecab-67e8-47f019fc567d', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('af7e0b6b-f780-0ccb-3644-47f01b28f501', 'a60e03d0-225f-b23f-9fbd-47f01bf16c44', 'b09702d5-fad8-db7d-0d3e-47f019b91c05', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('d5ba056e-e18c-ee1f-1e25-47f01b33901a', 'cc400aed-5a4e-2b77-948a-47f01b06946d', 'c8b40a59-d1de-2fc3-8398-47f0194c8330', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('fc2b0c89-c73d-a1c0-e70e-47f01ba79681', 'f2de0275-8165-5dca-31e4-47f01bc6b8b4', 'e4ec0493-0090-c126-b573-47f019410358', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('1200cd4e-bdbb-7fe1-18a3-47f01b6e39e6', '11663b36-76b6-0c1f-e698-47f01b87d6b0', 'f9910b79-d1cf-da01-f2af-47f0198e5f37', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('14682961-a82f-4cb2-e9f4-47f01bb4228d', '13cfd405-4ea7-222e-2492-47f01bc04fbf', '11264508-b0d4-35ba-d302-47f019509a07', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('16eeab58-f808-1cab-3d25-47f01bf60889', '1652bf43-1abb-d30a-a72e-47f01b8a7ea5', '12a9282a-b11d-9ea2-f73f-47f019707ce7', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('1b0dd588-d082-fd2b-d611-47f01b194126', '1a5c825d-2066-2ddd-13ed-47f01b73f396', '142a08b8-2031-e66e-a692-47f0196f66ed', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('1e01c25a-0b60-7c25-d95c-47f01b05f37c', '1d614ca9-6029-39d8-668c-47f01b17b343', '15aaa11b-50b4-d148-2f42-47f0198f7e8b', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('208be69e-4fdb-debb-44ab-47f01bd91d09', '1febd321-703f-ade1-8934-47f01b4ecaa7', '172860e5-cb84-1e42-0d50-47f01968d49f', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('232aaefd-8e67-1d27-69ea-47f01bf3e9aa', '228c7da5-391f-e36f-9eee-47f01b9ec1fd', '18ac05c8-2df6-05ea-8100-47f019031a38', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('25a63814-409e-793a-1775-47f01b45ecf0', '250c2662-276b-d95e-d202-47f01b8d101c', '1a2c7677-f403-4b38-e078-47f019de6e64', '2008-03-30 22:59:24', 0); INSERT INTO `accounts_contacts` VALUES('f171d4bd-7a72-f628-c503-47f01fa971a1', '16234e87-5903-5682-954f-47f01e7c121c', 'e6d1bea0-3fa0-c5ac-fe32-47f01ee52c66', '2008-03-30 23:16:39', 0); INSERT INTO `accounts_contacts` VALUES('aa9233e4-14a3-9179-4b87-47f022e62732', '143f8c87-5d4b-eba7-613e-47f01edbba51', 'e52485ac-7c4b-dbec-aa79-47f01e12872c', '2008-03-30 23:28:36', 0); INSERT INTO `accounts_contacts` VALUES('31050085-7a3a-cb6e-d0e1-47f02267bf3c', '17b99060-b829-0866-59ad-47f01ea4624d', 'e809eaa2-5ab0-6a31-9b8d-47f01e77b4a3', '2008-03-30 23:30:24', 0); INSERT INTO `accounts_contacts` VALUES('4b930033-debe-c094-6dce-47f02bf88c8a', '79e99049-99fe-c64d-7106-47f02734fe9f', '45823b83-6f48-20a6-ba9d-47f02a08353a', '2008-03-31 00:09:02', 0); INSERT INTO `accounts_contacts` VALUES('ddd5d274-c107-f1fd-54f7-47f11b0f4a1b', '313a07a8-1428-5583-fae4-47f11b2b37f2', '3960c0d3-75ff-7a15-8a77-47f02afc0759', '2008-03-31 17:11:51', 0); INSERT INTO `accounts_contacts` VALUES('77dbec7d-d113-587e-b68b-47f121d5a5dd', '6ec33663-e413-b220-3377-47f121a0fb2d', '44504a99-ade3-1a32-6aad-47f02a80e2e8', '2008-03-31 17:36:48', 0); INSERT INTO `accounts_contacts` VALUES('14692df9-d8e4-cbc3-f61a-47f12602f861', '329e0387-d295-803a-3de7-47f12184cbe8', '190388c5-7a87-fd88-3f1f-47f1210ba5b4', '2008-03-31 17:58:28', 0); -- -------------------------------------------------------- -- -- Table structure for table `accounts_opportunities` -- CREATE TABLE `accounts_opportunities` ( `id` varchar(36) NOT NULL default '', `opportunity_id` varchar(36) default NULL, `account_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_account_opportunity` (`account_id`,`opportunity_id`), KEY `idx_oppid_del_accid` (`opportunity_id`,`deleted`,`account_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `accounts_opportunities` -- -- -------------------------------------------------------- -- -- Table structure for table `acl_actions` -- CREATE TABLE `acl_actions` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `created_by` varchar(36) default NULL, `name` varchar(150) default NULL, `category` varchar(100) default NULL, `acltype` varchar(100) default NULL, `aclaccess` int(3) default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclaction_id_del` (`id`,`deleted`), KEY `idx_category_name` (`category`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `acl_actions` -- INSERT INTO `acl_actions` VALUES('cfbc8b51-a6c8-db45-62b1-47eed9e53a1c', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'access', 'Leads', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('d02e2605-8249-15db-caa8-47eed99b6f70', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'view', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d097e6d9-0cbf-39e6-e040-47eed9f60b63', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'list', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d0f0d20a-99df-4239-f29c-47eed9008047', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'edit', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d15c4941-7cd3-3bb8-7b8f-47eed9195dd3', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'delete', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d1c2522d-fc71-0ddd-bac1-47eed939c4b4', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'import', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d227bbbc-801e-82de-f4db-47eed99aef79', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'export', 'Leads', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d95eb53e-11d3-958b-f195-47eed9013fa4', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'access', 'Contacts', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('d9b80ce7-98cb-9e32-2eba-47eed99a5cf8', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'view', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('da6fdac1-8559-33e6-f1be-47eed92dcbb7', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'list', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('daca79a8-1b62-8ba7-c03a-47eed96f2644', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'edit', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('db246c66-080b-3ed7-e811-47eed94271e3', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'delete', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('db9c53f8-63e1-b35d-a36b-47eed9d29602', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'import', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('dbf78012-36b3-c14d-7aa2-47eed9882f5d', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'export', 'Contacts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e3316225-0689-67ca-23d9-47eed946932e', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'access', 'Accounts', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('e38ce5a7-2f6a-03c5-5704-47eed9d40534', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'view', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e3e4f0f2-c460-0bd9-a08f-47eed99529cc', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'list', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e43c5bd0-5dee-3830-701b-47eed923aecf', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'edit', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e4923a52-9bd3-76ec-40b3-47eed91c9edc', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'delete', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e4e730e1-b3b9-dbdb-568c-47eed96fa56d', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'import', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e53c47d5-9cb5-c7a5-c56b-47eed915686d', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'export', 'Accounts', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('ebdfcbfc-480e-c4bb-d115-47eed9fbe9de', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'access', 'Opportunities', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('ec3924c5-8114-9f1e-d5a0-47eed9cfc0ac', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'view', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('ec8f4d9f-5036-5a6c-f9b0-47eed95a55e8', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'list', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('ece573c5-8f5a-d7c4-7453-47eed9239257', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'edit', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('ed3cf11f-cd1b-4cbb-dbc5-47eed969e549', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'delete', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('ed93fd1c-6889-36d4-f33c-47eed9d15b7a', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'import', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('edea2a86-fb01-16f7-0ecf-47eed9fab1c2', '2008-03-30 00:04:54', '2008-03-30 00:04:54', '1', NULL, 'export', 'Opportunities', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1e30070d-5ae5-d08f-76e7-47eed945e214', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Cases', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('78100c4a-44e4-9541-9240-47eed96a485d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('cf400f8d-64fa-9105-2ab3-47eed90d845e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('123f052b-0af7-5dbe-eaf5-47eed9695b4c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('178d036d-3226-2785-c4a4-47eed9ddd764', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1cd6048a-6197-7311-b074-47eed9401a76', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('22270258-fe21-babd-e208-47eed95bdb99', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Cases', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6f7009ff-0756-295c-19a1-47eed982ebbb', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Notes', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('75120f2e-933c-674f-3965-47eed9e96cc4', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7a830181-c2a4-f968-5ec5-47eed98d2f3b', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7ff60b8e-e59f-6426-f4cb-47eed93478f6', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('85650342-de03-968c-3109-47eed924b3fa', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8ad60c24-5369-9f02-b2c0-47eed9772341', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9043080e-269f-ce76-1cde-47eed9d1ded5', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Notes', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('c00a0691-04bf-1100-1841-47eed9f268df', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'EmailTemplates', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('c5a60f40-48e4-6f4f-385e-47eed90e3f85', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('cb22000d-1ea4-eaf6-5b63-47eed95afbdc', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d0880764-1241-ec02-a1f8-47eed94ccd88', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('d5fd04a6-b10a-0b3a-a88e-47eed986f02e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('db6a0596-d399-b099-b94e-47eed9c9b12d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('e0d30282-6ca1-6435-3333-47eed90d541d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'EmailTemplates', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('13ad9240-aafb-f8b2-2fec-47eed9c800c8', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Calls', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('140660a0-62b5-4b84-69db-47eed94580fc', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('145bb7c4-bec8-934b-a417-47eed9d725c0', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('14b06e85-1549-2d57-45f9-47eed9b82c58', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('150580a8-a98b-edad-cc4b-47eed92a6f4a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('155b69f8-042f-e261-2101-47eed9a472f0', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('15b13dd4-7982-dbdd-b88d-47eed9a33a1c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Calls', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1c51f42f-da4a-05ce-20c1-47eed997b7e8', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Emails', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('1cad06e6-ce5f-fed3-5e44-47eed9423550', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1d0398ea-c79c-ec6e-7bbf-47eed9cd004f', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1d59b650-056a-fa59-d6e3-47eed90f0d53', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1dafa5f8-a541-b68c-2584-47eed953cc7e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1e067c4f-1f09-d865-bf53-47eed9d05070', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('1e5e1c68-98c0-d8e8-8991-47eed98bb23f', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Emails', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('230310d6-3956-deae-0485-47eed9ec333a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Meetings', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('23644b0a-ddf6-1acc-2789-47eed98e0869', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('23c0a7e5-816d-fcb5-ef0a-47eed954e44c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('241b7f01-2d9a-45b1-fc4a-47eed9ac9451', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('247751ee-ef85-62ff-6354-47eed9854042', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('24d32723-1702-898a-8eb7-47eed979094c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('252ef3fd-e090-fd52-7fdd-47eed9f95a84', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Meetings', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2b08a8f1-7e52-18ad-4998-47eed9216209', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Tasks', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('2b6a7b65-408d-68bd-c346-47eed958637a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2bc7085c-55f4-f706-3fbd-47eed994fc7f', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2c22e642-c6fb-4a31-09d7-47eed9f2815d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2c7efd88-c5f2-cf22-251e-47eed9674175', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2cdc71f3-49df-1b50-1a81-47eed910cb9a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('2d39167e-9366-c7e7-4152-47eed9d0c3e6', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Tasks', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('44e9898c-7863-c287-c1dc-47eed9413f99', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Bugs', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('45431da1-326a-cfc0-85c4-47eed949961d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('459833ac-79ef-7e4d-98df-47eed9190b3d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('45ee9d50-ec53-7f5b-1c83-47eed91446d0', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('46441cd8-7f41-0e36-ae60-47eed9ce997c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('469ab4d2-e6c2-a14e-01a4-47eed9508475', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('46f04647-1a0f-9ab1-2273-47eed9e0a368', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Bugs', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6245d1da-d2af-bce8-caf8-47eed9cecd28', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Project', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('62a3c3ba-79c5-3555-27db-47eed974968e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('63251984-0a70-58e3-756a-47eed9196e9a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('639b9798-80e6-e5f0-7b13-47eed9ec8d5e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('63f4ffbc-355b-5ad8-a377-47eed94fcf6a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('648337f0-303c-97ca-3c62-47eed9e240bd', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('64e2fa20-b4f1-d0ba-83aa-47eed9f0cca5', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Project', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('69be4b4f-e67f-ddd2-13a4-47eed918141e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'ProjectTask', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('6a1ecb3e-4aaf-c95b-a4e9-47eed9751a23', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6a7c760a-eb46-6457-370a-47eed9705f9d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6ad8793a-af14-e02d-ac14-47eed94f5003', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6b3340f2-213c-c8c1-6f98-47eed92eb1ed', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6b8ea956-926d-f8d5-0397-47eed9aceea7', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('6beaa460-0cd4-1715-2784-47eed951b67f', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'ProjectTask', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7af3e1c0-e7c7-9408-3fae-47eed9aa3277', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'EmailMarketing', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('7b538758-5049-8f45-2174-47eed90fd58e', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7baf9780-b81f-a245-f9b3-47eed9d9b506', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7c0adeb9-2ae9-f97e-58ed-47eed9b02b93', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7c65dcca-eb7e-dc43-5786-47eed9df6b60', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7cbea74c-b26e-143d-4952-47eed9d8abf9', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('7d167e33-ea86-0647-f109-47eed91c8169', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'EmailMarketing', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8143cc1e-e486-081f-60c8-47eed9bd89f6', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Campaigns', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('819ebf32-0483-15c5-98a4-47eed91acf7d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('81f586a1-c97c-533d-9d62-47eed94d7157', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('824cc20c-228f-0703-7de4-47eed9546a81', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('82ab4943-8330-3c61-e69b-47eed99ee4e7', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8303735f-b066-3ed6-f3c0-47eed9cab8a5', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('835c1e0a-620f-c33e-25a5-47eed901132b', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Campaigns', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('89c53bd5-0e4e-f58f-c741-47eed96cc05d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'ProspectLists', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('8a244c05-5e22-df36-fa39-47eed9406f82', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8a7f551c-b838-e21d-8963-47eed9794b59', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8adbe431-e6cb-8fa3-955c-47eed9a537b4', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8b36508c-44ec-8949-082a-47eed9550174', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8b90f1d5-7d82-f106-c61e-47eed9d7b854', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('8beb2186-f692-d412-6ba7-47eed982ab92', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'ProspectLists', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('95335166-ca48-d73a-b320-47eed9ac4f2c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Prospects', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('95b18abe-c191-88ab-dcb3-47eed9f4064c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('961bec9a-ad0e-dd00-2bf9-47eed9d22b7a', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('967ec3db-1279-6a0a-701f-47eed9753301', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('96eab72d-7b42-677c-b576-47eed959ec7d', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('974b7df8-cb02-557e-5180-47eed94460c1', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('97ab0fee-7c17-2c99-4e78-47eed985e562', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Prospects', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9c346272-0cbf-662e-4418-47eed97401fc', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'access', 'Documents', 'module', 89, 0); INSERT INTO `acl_actions` VALUES('9c9309b1-6f49-10ae-ac23-47eed9d2a5b4', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'view', 'Documents', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9cee12ec-7315-cab7-5e68-47eed98d08ac', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'list', 'Documents', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9d4b8ced-0c38-97ae-1f02-47eed95a4305', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'edit', 'Documents', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9da5f628-7de1-b24f-1eaa-47eed9aad494', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'delete', 'Documents', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9e018d5c-8b6e-5c22-cd87-47eed946e84c', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'import', 'Documents', 'module', 90, 0); INSERT INTO `acl_actions` VALUES('9e5bd297-d4c6-34a7-4f35-47eed9267734', '2008-03-30 00:04:55', '2008-03-30 00:04:55', '1', NULL, 'export', 'Documents', 'module', 90, 0); -- -------------------------------------------------------- -- -- Table structure for table `acl_roles` -- CREATE TABLE `acl_roles` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `created_by` varchar(36) default NULL, `name` varchar(150) default NULL, `description` text, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclrole_id_del` (`id`,`deleted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `acl_roles` -- -- -------------------------------------------------------- -- -- Table structure for table `acl_roles_actions` -- CREATE TABLE `acl_roles_actions` ( `id` varchar(36) NOT NULL default '', `role_id` varchar(36) default NULL, `action_id` varchar(36) default NULL, `access_override` int(3) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_acl_role_id` (`role_id`), KEY `idx_acl_action_id` (`action_id`), KEY `idx_aclrole_action` (`role_id`,`action_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `acl_roles_actions` -- -- -------------------------------------------------------- -- -- Table structure for table `acl_roles_users` -- CREATE TABLE `acl_roles_users` ( `id` varchar(36) NOT NULL default '', `role_id` varchar(36) default NULL, `user_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclrole_id` (`role_id`), KEY `idx_acluser_id` (`user_id`), KEY `idx_aclrole_user` (`role_id`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `acl_roles_users` -- -- -------------------------------------------------------- -- -- Table structure for table `address_book` -- CREATE TABLE `address_book` ( `assigned_user_id` varchar(36) NOT NULL default '', `bean` varchar(50) NOT NULL default '', `bean_id` varchar(36) NOT NULL default '', KEY `ab_user_bean_idx` (`assigned_user_id`,`bean`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `address_book` -- -- -------------------------------------------------------- -- -- Table structure for table `bugs` -- CREATE TABLE `bugs` ( `id` varchar(36) NOT NULL default '', `name` varchar(255) default NULL, `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `bug_number` int(11) NOT NULL auto_increment, `type` varchar(255) default NULL, `status` varchar(25) default NULL, `priority` varchar(25) default NULL, `resolution` varchar(255) default NULL, `work_log` text, `found_in_release` varchar(255) default NULL, `fixed_in_release` varchar(255) default NULL, `source` varchar(255) default NULL, `product_category` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `bugsnumk` (`bug_number`), KEY `bug_number` (`bug_number`), KEY `idx_bug_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bugs` -- -- -------------------------------------------------------- -- -- Table structure for table `bugs_audit` -- CREATE TABLE `bugs_audit` ( `id` varchar(36) NOT NULL default '', `parent_id` varchar(36) NOT NULL default '', `date_created` datetime default NULL, `created_by` varchar(36) default NULL, `field_name` varchar(100) default NULL, `data_type` varchar(100) default NULL, `before_value_string` varchar(255) default NULL, `after_value_string` varchar(255) default NULL, `before_value_text` text, `after_value_text` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `bugs_audit` -- -- -------------------------------------------------------- -- -- Table structure for table `calls` -- CREATE TABLE `calls` ( `id` varchar(36) NOT NULL default '', `name` varchar(50) default NULL, `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `duration_hours` int(2) default NULL, `duration_minutes` int(2) default NULL, `date_start` datetime default NULL, `date_end` date default NULL, `parent_type` varchar(25) default NULL, `status` varchar(25) default NULL, `direction` varchar(25) default NULL, `parent_id` varchar(36) default NULL, `reminder_time` int(4) default '-1', `outlook_id` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `idx_call_name` (`name`), KEY `idx_status` (`status`), KEY `idx_calls_date_start` (`date_start`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `calls` -- INSERT INTO `calls` VALUES('31f01fcc-b0e1-5c26-4d28-47f06e605d86', 'PTP website inquiry', '2008-03-31 04:55:12', '2008-03-31 05:04:48', '1', '1', 'Explain process of purchasing and setting up new mold inspection website', 0, '1', 0, 15, '2008-03-31 17:00:00', '2008-03-31', 'Accounts', 'Planned', 'Inbound', '142a08b8-2031-e66e-a692-47f0196f66ed', 300, NULL); INSERT INTO `calls` VALUES('243bcbba-8147-9d04-c255-47f116fc3a0d', 'Checkin with Junglescapes', '2008-03-31 16:49:06', '2008-03-31 16:49:06', '1', '1', 'Update on their plans and next steps.', 0, '1', 0, 15, '2008-03-31 20:00:00', '2008-03-31', 'Accounts', 'Planned', 'Outbound', '3960c0d3-75ff-7a15-8a77-47f02afc0759', -1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `calls_contacts` -- CREATE TABLE `calls_contacts` ( `id` varchar(36) NOT NULL default '', `call_id` varchar(36) default NULL, `contact_id` varchar(36) default NULL, `required` char(1) default '1', `accept_status` varchar(25) default 'none', `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_con_call_call` (`call_id`), KEY `idx_con_call_con` (`contact_id`), KEY `idx_call_contact` (`call_id`,`contact_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `calls_contacts` -- INSERT INTO `calls_contacts` VALUES('7ac28bfa-59b4-b040-cd4e-47f07018e3ad', '31f01fcc-b0e1-5c26-4d28-47f06e605d86', '79e99049-99fe-c64d-7106-47f02734fe9f', '1', 'none', '2008-03-31 05:04:48', 0); -- -------------------------------------------------------- -- -- Table structure for table `calls_users` -- CREATE TABLE `calls_users` ( `id` varchar(36) NOT NULL default '', `call_id` varchar(36) default NULL, `user_id` varchar(36) default NULL, `required` char(1) default '1', `accept_status` varchar(25) default 'none', `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_usr_call_call` (`call_id`), KEY `idx_usr_call_usr` (`user_id`), KEY `idx_call_users` (`call_id`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `calls_users` -- INSERT INTO `calls_users` VALUES('39ff40a0-a8ad-d9db-f128-47f06e3ec2d5', '31f01fcc-b0e1-5c26-4d28-47f06e605d86', '1', '1', 'accept', '2008-03-31 05:04:48', 0); INSERT INTO `calls_users` VALUES('30c18d5c-6f28-49d1-5252-47f11628f1f1', '243bcbba-8147-9d04-c255-47f116fc3a0d', '1', '1', 'accept', '2008-03-31 16:49:06', 0); -- -------------------------------------------------------- -- -- Table structure for table `campaign_log` -- CREATE TABLE `campaign_log` ( `id` varchar(36) NOT NULL default '', `campaign_id` varchar(36) default NULL, `target_tracker_key` varchar(36) default NULL, `target_id` varchar(36) default NULL, `target_type` varchar(25) default NULL, `activity_type` varchar(25) default NULL, `activity_date` datetime default NULL, `related_id` varchar(36) default NULL, `related_type` varchar(25) default NULL, `archived` tinyint(1) default '0', `hits` int(11) default '0', `list_id` varchar(36) default NULL, `deleted` tinyint(1) default '0', `date_modified` datetime default NULL, `more_information` varchar(100) default NULL, `marketing_id` varchar(36) default NULL, PRIMARY KEY (`id`), KEY `idx_camp_tracker` (`target_tracker_key`), KEY `idx_camp_campaign_id` (`campaign_id`), KEY `idx_camp_more_info` (`more_information`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `campaign_log` -- -- -------------------------------------------------------- -- -- Table structure for table `campaign_trkrs` -- CREATE TABLE `campaign_trkrs` ( `id` varchar(36) NOT NULL default '', `tracker_name` varchar(30) default NULL, `tracker_url` varchar(255) default 'http://', `tracker_key` int(11) NOT NULL auto_increment, `campaign_id` varchar(36) default NULL, `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `is_optout` tinyint(1) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `campaign_tracker_key_idx` (`tracker_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `campaign_trkrs` -- -- -------------------------------------------------------- -- -- Table structure for table `campaigns` -- CREATE TABLE `campaigns` ( `id` varchar(36) NOT NULL default '', `name` varchar(50) default NULL, `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `tracker_key` int(11) NOT NULL auto_increment, `tracker_count` int(11) default '0', `refer_url` varchar(255) default 'http://', `tracker_text` varchar(255) default NULL, `start_date` date default NULL, `end_date` date default NULL, `status` varchar(25) default NULL, `impressions` int(11) default '0', `currency_id` varchar(36) default NULL, `budget` double default NULL, `expected_cost` double default NULL, `actual_cost` double default NULL, `expected_revenue` double default NULL, `campaign_type` varchar(25) default NULL, `objective` text, `content` text, `frequency` varchar(25) default NULL, PRIMARY KEY (`id`), KEY `camp_auto_tracker_key` (`tracker_key`), KEY `idx_campaign_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `campaigns` -- -- -------------------------------------------------------- -- -- Table structure for table `campaigns_audit` -- CREATE TABLE `campaigns_audit` ( `id` varchar(36) NOT NULL default '', `parent_id` varchar(36) NOT NULL default '', `date_created` datetime default NULL, `created_by` varchar(36) default NULL, `field_name` varchar(100) default NULL, `data_type` varchar(100) default NULL, `before_value_string` varchar(255) default NULL, `after_value_string` varchar(255) default NULL, `before_value_text` text, `after_value_text` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `campaigns_audit` -- -- -------------------------------------------------------- -- -- Table structure for table `cases` -- CREATE TABLE `cases` ( `id` varchar(36) NOT NULL default '', `name` varchar(255) default NULL, `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `case_number` int(11) NOT NULL auto_increment, `type` varchar(255) default NULL, `status` varchar(25) default NULL, `priority` varchar(25) default NULL, `resolution` text, `work_log` text, `account_id` varchar(36) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `casesnumk` (`case_number`), KEY `case_number` (`case_number`), KEY `idx_case_name` (`name`), KEY `idx_account_id` (`account_id`), KEY `idx_cases_stat_del` (`assigned_user_id`,`status`,`deleted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cases` -- -- -------------------------------------------------------- -- -- Table structure for table `cases_audit` -- CREATE TABLE `cases_audit` ( `id` varchar(36) NOT NULL default '', `parent_id` varchar(36) NOT NULL default '', `date_created` datetime default NULL, `created_by` varchar(36) default NULL, `field_name` varchar(100) default NULL, `data_type` varchar(100) default NULL, `before_value_string` varchar(255) default NULL, `after_value_string` varchar(255) default NULL, `before_value_text` text, `after_value_text` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `cases_audit` -- -- -------------------------------------------------------- -- -- Table structure for table `cases_bugs` -- CREATE TABLE `cases_bugs` ( `id` varchar(36) NOT NULL default '', `case_id` varchar(36) default NULL, `bug_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_cas_bug_cas` (`case_id`), KEY `idx_cas_bug_bug` (`bug_id`), KEY `idx_case_bug` (`case_id`,`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `cases_bugs` -- -- -------------------------------------------------------- -- -- Table structure for table `config` -- CREATE TABLE `config` ( `category` varchar(32) default NULL, `name` varchar(32) default NULL, `value` text, KEY `idx_config_cat` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `config` -- INSERT INTO `config` VALUES('notify', 'fromaddress', 'do_not_reply@example.com'); INSERT INTO `config` VALUES('notify', 'fromname', 'SugarCRM'); INSERT INTO `config` VALUES('notify', 'send_by_default', '1'); INSERT INTO `config` VALUES('notify', 'on', '0'); INSERT INTO `config` VALUES('notify', 'send_from_assigning_user', '0'); INSERT INTO `config` VALUES('info', 'sugar_version', '5.0.0'); INSERT INTO `config` VALUES('MySettings', 'tab', ''); INSERT INTO `config` VALUES('portal', 'on', '0'); INSERT INTO `config` VALUES('Update', 'CheckUpdates', 'automatic'); INSERT INTO `config` VALUES('system', 'name', 'My CRM'); INSERT INTO `config` VALUES('license', 'msg_admin', ''); INSERT INTO `config` VALUES('license', 'msg_all', ''); INSERT INTO `config` VALUES('license', 'last_validation', 'success'); INSERT INTO `config` VALUES('license', 'latest_versions', 'YToxOntpOjA7YToyOntzOjc6InZlcnNpb24iO3M6NjoiNS4wLjBiIjtzOjExOiJkZXNjcmlwdGlvbiI7czoxNjM6IlRoZSBsYXRlc3QgdmVyc2lvbiBvZiBTdWdhckNSTSBpcyA1LjAuMGIuICBQbGVhc2UgdmlzaXQgPGEgaHJlZj0iaHR0cDovL3N1cHBvcnQuc3VnYXJjcm0uY29tIiB0YXJnZXQ9Il9uZXciPnN1cHBvcnQuc3VnYXJjcm0uY29tPC9hPiB0byBhY3F1aXJlIHRoZSBsYXRlc3QgdmVyc2lvbi4iO319'); INSERT INTO `config` VALUES('Update', 'last_check_date', '1206835535'); INSERT INTO `config` VALUES('system', 'ldap_enabled', '0'); INSERT INTO `config` VALUES('ldap', 'hostname', ''); INSERT INTO `config` VALUES('ldap', 'port', ''); INSERT INTO `config` VALUES('ldap', 'base_dn', ''); INSERT INTO `config` VALUES('ldap', 'bind_attr', ''); INSERT INTO `config` VALUES('ldap', 'login_attr', ''); INSERT INTO `config` VALUES('ldap', 'admin_user', ''); INSERT INTO `config` VALUES('ldap', 'admin_password', ''); INSERT INTO `config` VALUES('ldap', 'auto_create_users', '0'); INSERT INTO `config` VALUES('ldap', 'enc_key', ''); INSERT INTO `config` VALUES('proxy', 'on', '0'); INSERT INTO `config` VALUES('proxy', 'host', ''); INSERT INTO `config` VALUES('proxy', 'port', ''); INSERT INTO `config` VALUES('proxy', 'auth', '0'); INSERT INTO `config` VALUES('proxy', 'username', ''); INSERT INTO `config` VALUES('proxy', 'password', ''); INSERT INTO `config` VALUES('system', 'skypeout_on', '1'); INSERT INTO `config` VALUES('system', 'mailmerge_on', '0'); -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `assigned_user_id` varchar(36) default NULL, `salutation` varchar(5) default NULL, `first_name` varchar(100) default NULL, `last_name` varchar(100) default NULL, `title` varchar(100) default NULL, `department` varchar(255) default NULL, `do_not_call` tinyint(1) default '0', `phone_home` varchar(25) default NULL, `phone_mobile` varchar(25) default NULL, `phone_work` varchar(25) default NULL, `phone_other` varchar(25) default NULL, `phone_fax` varchar(25) default NULL, `primary_address_street` varchar(150) default NULL, `primary_address_city` varchar(100) default NULL, `primary_address_state` varchar(100) default NULL, `primary_address_postalcode` varchar(20) default NULL, `primary_address_country` varchar(255) default NULL, `alt_address_street` varchar(150) default NULL, `alt_address_city` varchar(100) default NULL, `alt_address_state` varchar(100) default NULL, `alt_address_postalcode` varchar(20) default NULL, `alt_address_country` varchar(255) default NULL, `assistant` varchar(75) default NULL, `assistant_phone` varchar(25) default NULL, `lead_source` varchar(100) default NULL, `reports_to_id` varchar(36) default NULL, `birthdate` date default NULL, `portal_name` varchar(255) default NULL, `portal_active` tinyint(1) NOT NULL default '0', `portal_app` varchar(255) default NULL, `campaign_id` varchar(36) default NULL, PRIMARY KEY (`id`), KEY `idx_cont_last_first` (`last_name`,`first_name`,`deleted`), KEY `idx_contacts_del_last` (`deleted`,`last_name`), KEY `idx_cont_del_reports` (`deleted`,`reports_to_id`,`last_name`), KEY `idx_reports_to_id` (`reports_to_id`), KEY `idx_del_id_user` (`deleted`,`id`,`assigned_user_id`), KEY `idx_cont_assigned` (`assigned_user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `contacts` -- INSERT INTO `contacts` VALUES('ee8cdaa0-848b-2d20-c292-47f00a555dc0', '2008-03-30 21:46:44', '2008-03-30 21:46:44', '1', '1', 'Ron I know for sure that Cliff,\nAdriel, Holland,\nare mine. I am pretty sure that Dylan is mine too, that name sounds familiar. Not\nsure about Daniel Skinner. I cant find their numbers even to call them. \nRyan Elowe at 1st Discovery\nis calling Bill on Monday to order his website. He is a firefighter, cant\nafford the 500 all at once. I told him he could pay half and half if he works it\nout with you guys. I couldn’t see any listing on RespirNet for Daniel\nSkinners or Dylan Bucknavich so I couldn’t even call them. Are they\nnot approved yet?\n\n\n\nIAMHIS\n\n \n\nSue McLeod\n\nShepherds Way\n\n \n\n"The Lord your God is with you, He is\nmighty to save. He will take great delight in you ; He will quiet you with His\nlove, He will rejoice over you with singing." Zephaniah 3:17\n\n \n\n \n\n\n\n\n\n\n\n\n\n\n\nFrom: Ron Ford\n[mailto:ronford@respirnetpro.com] \nSent: Friday, March 28, 2008 12:56\nPM\nTo: Susan McLeod\nSubject: Re:\n\n\n\n \n\nGreat; I shot her an\nemail.\n\nron\n\n\n\nOn Fri, Mar 28, 2008 at 12:38 PM, Susan McLeod \nwrote:\n\n\n\n\n\nRon,\nI just talked to Gail Capshaw at Pillar to Post and they want you to email them\nabout doing a website. I didn''t know where to have her get in touch with you.\nThey have been listed she said for 2 years????? I didn''t understand that\nbecause of what I know. But, they haven''t gotten a single call and when I\nlooked at their website, I understood why. They need a MOLD inspector website.\nGo check it out. She got really excited about have a new website made for them.\nI think if you get in touch with her today, she will give you the\ngo-ahead. Her email is ptpmesa@cox.net\n and her name is Gail. Nice lady!\nShe''s expecting to hear from you. \n\n \n\nIAMHIS\n\n \n\nSue\nMcLeod\n\nShepherds\nWay\n\n \n\n"The\nLord your God is with you, He is mighty to save. He will take great delight in\nyou ; He will quiet you with His love, He will rejoice over you with\nsinging." Zephaniah 3:17\n\n \n\n \n\n \n\n\n\n\n\n\n\n\n\n\n-- \nRon Ford\nRespirNet\n\nWe help people build businesses that help people!\n\nToll Free: 800-369-7598\nFax: 760-634-6976\n\nEmail: ronford@respirnetpro.com\nWeb: www.respirnetpro.com, www.moldinspectordirectory.com', 0, '1', NULL, 'Sue', 'McLeod', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Email', NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('d4ed3900-5b2a-8a81-98b7-47f00a80ed1f', '2008-03-30 21:48:59', '2008-03-30 21:48:59', '1', '1', 'Ron, Do we have anything like what Sue\nis asking for?\n\n \n\n\n\n\n\n\n\n\n\nFrom: Susan McLeod [mailto:sue@shepherdswaycarlsbad.org] \nSent: Friday, March 28, 2008 2:50\nPM\nTo: Bill\nMcLeod\nSubject: \n\n\n\n \n\nBill can you\nsend this guy information on traffic that RespirNet gets. He was definitely one\nof the hardest guys to talk to. He knows computer stuff and asked me things I\ndon’t know. He is interested though. If you email him he will get back\nwith YOU. I’ll split the 10 bucks with you…..ha! \n\nstancrane@moldmasterpro.com\n He does remediation too, and says he is up front\nand doesn’t have ANY conflict of interests with it. Nice guy.\n\n \n\nIAMHIS\n\n \n\nSue McLeod\n\nShepherds Way\n\n \n\n"The Lord your God is with you,\nHe is mighty to save. He will take great delight in you ; He will quiet you\nwith His love, He will rejoice over you with singing." Zephaniah 3:17\n\n \n\n \n\n ', 0, '1', NULL, 'Bill', 'McLeod', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Email', NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('aad607ea-f5cd-66e8-405c-47f00cc40b25', '2008-03-30 21:54:50', '2008-03-30 21:54:50', '1', '1', 'There has been a submission made through your form, RNP_Associate_Application:\n\nID: 29\nFirst: John\nLast: Lozano\nAddress: 57 Mayo Loop\nAddress2: \nCity: Los Lunas\nState: New Mexico\nZip: 87031\nPhone: 505-866-5640\nEmailAddress: lozanofamilyof5@aol.com\nWebSiteAddress: www.NewMexicoHealthyHomes.com\nCompany: Healthy Home Solutions, Ltd\nCIEC: \nCIE: \nCMR: Yes\nCMRS: \nCMC: \nCMI: \nCMCA: \nCIAQM: \nCRMI: \nOther: \nOtherCertification: \nCertifyingBody: IAQ Council\nVendorAgreement: Yes, I agree to code of ethics\nInspectorAgreement: I agree to abide by the Inspector Code of Ethics\nDate Submitted: Mar 19th, 3:24 PM\nNotes: APPROVED\nIP Address: 67.54.150.107\nApproval: Yes\nCC Debit Agreement: I allow RespirNet to debit my Credit Card my monthly associate fees.\nApp Accepted Email Sent: 3/21/08\nWelcome to RNP Email Sent: \nPlan: \n\nSubmission made: Mar 19th, 3:24 PM', 0, '1', NULL, 'John', 'Lozano', NULL, 'Healthy Home Solutions, Ltd', 0, NULL, NULL, NULL, '505-866-5640', NULL, '57 Mayo Loop', 'Los Lunas', 'New Mexico', '87031', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Email', NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('75070a8c-bbbd-93ad-dd9c-47f01408d0fd', '2008-03-30 22:29:05', '2008-03-30 22:29:05', '1', '1', '---------- Forwarded message ----------From: Date: Sun, Mar 30, 2008 at 7:21 AM\nSubject: RNP_Associate_Application: SubmissionTo: ronford@respirnetpro.comThere has been a submission made through your form, RNP_Associate_Application:\n\nID: 32\nFirst: Stephen\nLast: Cash\nAddress: 413 Mesa Road\nAddress2:\nCity: Colorado Springs\nState: Colorado\nZip: 80905\nPhone: 719-473-8921\nEmailAddress: sjcash1@netzero.com\nWebSiteAddress:\nCompany: Environmental Assessment & Consulting\nCIEC:\nCIE:\nCMR:\nCMRS:\nCMC:\nCMI:\nCMCA:\nCIAQM:\nCRMI:\nOther:\nOtherCertification: CMIA, CIAQT, CESA, C\nCertifyingBody: ESA, IICRC\nVendorAgreement: Yes, I agree to code of ethics\nInspectorAgreement: I agree to abide by the Inspector Code of Ethics\nDate Submitted: Mar 30th, 9:21 AM\nNotes:\nIP Address: 64.136.26.225\nApproval:\nCC Debit Agreement: I allow RespirNet to debit my Credit Card my monthly associate fees.\nApp Accepted Email Sent:\nWelcome to RNP Email Sent:\nPlan:\n\nSubmission made: Mar 30th, 9:21 AM\n-- Ron FordRespirNetWe help people build businesses that help people!Toll Free: 800-369-7598Fax: 760-634-6976Email: ronford@respirnetpro.com\nWeb: www.respirnetpro.com, www.moldinspectordirectory.com', 0, '1', NULL, 'Stephen', 'Cash', NULL, 'Environmental Assessment & Consulting', 0, NULL, NULL, '719-473-8921', NULL, NULL, '413 Mesa Road', 'Colorado Springs', 'Colorado', '80905', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Email', NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('d4d00632-46b4-d3b4-d85a-47f01b61098f', '2008-03-30 22:59:24', '2008-03-30 23:15:34', '1', '1', NULL, 1, '1', NULL, 'First Name', 'Last Name', NULL, NULL, 0, NULL, 'Mobile Phone', 'Office Phone', 'Toll Free Phone', 'FaxPhone', NULL, NULL, 'State', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('7ed80e67-f490-7683-b2d5-47f01b29feab', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Cliff J.', 'Neyndorff', NULL, NULL, 0, NULL, '954-594-5027', '954-205-4044', NULL, '954-775-2599', NULL, NULL, 'Florida', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('a60e03d0-225f-b23f-9fbd-47f01bf16c44', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Adriel', 'Garcia', NULL, NULL, 0, NULL, '305-338-8815', '305-382-5200', NULL, '305-385-7597', NULL, NULL, 'Florida', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('cc400aed-5a4e-2b77-948a-47f01b06946d', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Ryan', 'Elowe', NULL, NULL, 0, NULL, '480 234.2129', NULL, NULL, '480 393.7392', NULL, NULL, 'Arizona', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('f2de0275-8165-5dca-31e4-47f01bc6b8b4', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Barbara', 'Frese', NULL, NULL, 0, NULL, '727-458-6682', '727-521-0304', NULL, NULL, NULL, NULL, 'Florida', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('11663b36-76b6-0c1f-e698-47f01b87d6b0', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'L. Russell (Rusty)', 'Vaughn', NULL, NULL, 0, NULL, '530-701-3936', '530-273-6653', '866-790-MOLD', '530-273-mold', NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('13cfd405-4ea7-222e-2492-47f01bc04fbf', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Patrick', 'Hartshorn', NULL, NULL, 0, NULL, '907-232-1007', '907-357-3967', '1-877-397-3967', '907-357-3967', NULL, NULL, 'Alaska', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('1652bf43-1abb-d30a-a72e-47f01b8a7ea5', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Lisa', 'Licht', NULL, NULL, 0, NULL, NULL, '(501) 269 -4770', '(866) 933-MOLD (6653', '(866) 334-6925', NULL, NULL, 'Arkansas', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('1a5c825d-2066-2ddd-13ed-47f01b73f396', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Dave', 'Capshaw', NULL, NULL, 0, NULL, NULL, '(480) 628-9175', NULL, '(480)357-4911', NULL, NULL, 'Arizona', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('1d614ca9-6029-39d8-668c-47f01b17b343', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Jeff', 'Thomas', NULL, NULL, 0, NULL, NULL, '530-878-3688', NULL, NULL, NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('1febd321-703f-ade1-8934-47f01b4ecaa7', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Matt', 'Dawes', NULL, NULL, 0, NULL, '(208) 602-2112', '(208) 323-4900', '(866) 323-4900', '(208) 323-4903', NULL, NULL, 'Idaho', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('228c7da5-391f-e36f-9eee-47f01b9ec1fd', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Dennis A.', 'Palma', NULL, NULL, 0, NULL, '609-410-3770', '609-704-8547', NULL, '609-704-9408', NULL, NULL, 'New Jersey', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('250c2662-276b-d95e-d202-47f01b8d101c', '2008-03-30 22:59:24', '2008-03-30 22:59:24', '1', '1', NULL, 0, '1', NULL, 'Daniel', 'Sullivan', NULL, NULL, 0, NULL, '650 454-0651', '650 595-0775', NULL, '650 595-0775', NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('12a44098-768a-249c-e826-47f01e4c8722', '2008-03-30 23:14:41', '2008-03-30 23:15:19', '1', '1', 'Description', 1, '1', NULL, NULL, 'Name', NULL, NULL, 0, NULL, 'Mobile Phone', 'Office Phone', 'Toll Free Phone', 'Fax Phone', NULL, NULL, 'State', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('143f8c87-5d4b-eba7-613e-47f01edbba51', '2008-03-30 23:14:41', '2008-03-30 23:28:36', '1', '1', 'Santa Barbara, San Luis Obispo, Santa Clara', 0, '1', NULL, 'Joel', 'Grant Jr', NULL, NULL, 0, NULL, '(805) 896-2008', '(805) 735-4848', NULL, '(805) 735-9938', NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('16234e87-5903-5682-954f-47f01e7c121c', '2008-03-30 23:14:41', '2008-03-30 23:16:39', '1', '1', 'Central Coast', 0, '1', NULL, 'Holland', 'Woolley', NULL, NULL, 0, NULL, '831-227-0805', NULL, '866-395-MOLD', NULL, NULL, NULL, 'California', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('17b99060-b829-0866-59ad-47f01ea4624d', '2008-03-30 23:14:41', '2008-03-30 23:30:24', '1', '1', 'Offering home inspection services in Adel, Altoona, Ames, Ankeny, Baxter, Boone, Boone Co., Boonville, Cambridge, Clide, Collins, Dallas Co., Des Moines, Dexter, Harvey, Huxley, Indianola, Jasper Co., Johnston, Kellogg, Knoxville, Lacona, Macksburg, Madis', 0, '1', NULL, 'John', 'Prohaska', NULL, NULL, 0, NULL, '515-201-3683', '515-285-5422', NULL, '515-953-6682', NULL, NULL, 'Iowa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('197a5eeb-18fc-c07b-c612-47f01eace493', '2008-03-30 23:14:41', '2008-03-30 23:14:41', '1', '1', 'North Florida', 0, '1', NULL, 'Clinton', 'J. Ford MS,', NULL, NULL, 0, NULL, '352.514.1087', '386.462.9144', '866.373.1831', '866.784.2597', NULL, NULL, 'Florida', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('79e99049-99fe-c64d-7106-47f02734fe9f', '2008-03-30 23:52:13', '2008-03-31 00:09:02', '1', '1', 'Ron, I spoke with Trent and he said to go ahead and purchase the module for Google Checkout.\r\nThanks Marie \r\nOn 3/27/08, Ron Ford wrote:\r\nMarie, the module we need can be purchased here: http://www.download3k.com/Web-Authoring/Site-Management/Download-CRE-Loaded-Google-Checkout-Level-2-payment-module.html\r\nI believe that I''ve found where to edit the emails, but it is in the php code of the store, so it will not be manageable by you. I can make changes for you, though when you need it done.The login to the Leaping Lotus site admin control panel is llAdmin and pa55word.\r\nI''ll also get you a number on creating a more self-managed merchant system.-- Ron FordIntegrity Web Services, LLCStrategic Business Partner & Internet Success Coach for Your Small Business\r\nEverything You Need to Succeed on the Web: Consulting, Custom Web Design,Hosting Services, eCommerce, Content Management Systems, GraphicDesign Services, Search Engine Optimization Services, and moreWeb: http://www.sandiego-websitedesign.com\r\nAddress: 1042 N. El Camino Real, Ste. B-311,Encinitas, CA 92024Email: ronford@iwsbiz.netToll free: 800.975.5304\r\nOffice: 760.634.6976Fax: 760.634.6976Cell: 760.809.1781Support channels:Help Desk: http://sandiego-websitedesign.com/helpDesk.php\r\nFAQs: http://sandiego-websitedesign.com/faq.php', 0, '1', NULL, 'Marie', 'May', 'Assistant', NULL, 0, NULL, NULL, '+1 760 734 4441 ext 105', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Existing Customer', NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('ad4f9977-7647-16de-5a83-47f02c0ff2e7', '2008-03-31 00:11:42', '2008-03-31 00:14:18', '1', '1', 'Arizona Professional Home Inspection\r\nwww.AzProHomeInspection.com', 0, '1', NULL, 'Dylan', 'Bucknavich', NULL, NULL, 0, NULL, NULL, '+1 480-510-5865', NULL, NULL, '1990 N. Alma School Rd., Suite 334', 'Chandler', 'Arizona', '85224', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('313a07a8-1428-5583-fae4-47f11b2b37f2', '2008-03-31 17:10:58', '2008-03-31 17:11:51', '1', '1', NULL, 0, '1', NULL, 'Todd', 'Yarborough', 'imported', NULL, 0, NULL, '619-507-3600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('e735c85f-d040-1413-8e41-47f120b57eba', '2008-03-31 17:33:25', '2008-03-31 17:33:25', '1', '1', NULL, 0, '1', NULL, 'Bob', 'Civello', 'imported', NULL, 0, NULL, NULL, '602-9321', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('783f040b-c5f1-6e97-83cc-47f120c7deda', '2008-03-31 17:34:09', '2008-03-31 17:34:48', '1', '1', NULL, 0, '1', NULL, 'Michele', 'Fair', 'imported', 'CDG Commerce', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('ec746a86-c0c1-2a2a-d6ec-47f12032cfd2', '2008-03-31 17:34:59', '2008-03-31 17:37:17', '1', '1', NULL, 1, '1', NULL, NULL, NULL, 'imported', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('3eab1014-0bba-778d-4c79-47f120dd04ba', '2008-03-31 17:35:24', '2008-03-31 17:35:24', '1', '1', NULL, 0, '1', NULL, 'Chris', 'Foley', 'imported', NULL, 0, NULL, '(888) 363-3697', '3106788970', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('329e0387-d295-803a-3de7-47f12184cbe8', '2008-03-31 17:36:05', '2008-03-31 17:58:28', '1', '1', NULL, 0, '1', NULL, 'Dan', 'Meyer', 'Owner', NULL, 0, NULL, NULL, '760-940-9455', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); INSERT INTO `contacts` VALUES('6ec33663-e413-b220-3377-47f121a0fb2d', '2008-03-31 17:36:27', '2008-03-31 17:36:48', '1', '1', NULL, 0, '1', NULL, 'Frank', 'Erwin', 'imported', NULL, 0, '865-938-2026', '865-387-1872', '865-577-2923 x226', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `contacts_audit` -- CREATE TABLE `contacts_audit` ( `id` varchar(36) NOT NULL default '', `parent_id` varchar(36) NOT NULL default '', `date_created` datetime default NULL, `created_by` varchar(36) default NULL, `field_name` varchar(100) default NULL, `data_type` varchar(100) default NULL, `before_value_string` varchar(255) default NULL, `after_value_string` varchar(255) default NULL, `before_value_text` text, `after_value_text` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `contacts_audit` -- INSERT INTO `contacts_audit` VALUES('47235f5f-7058-5b9e-a5b7-47f02bee64b9', '79e99049-99fe-c64d-7106-47f02734fe9f', '2008-03-31 00:09:02', '1', 'phone_work', 'phone', '+1 760 734 4441', '+1 760 734 4441 ext 105', NULL, NULL); INSERT INTO `contacts_audit` VALUES('6b4c86ea-68d9-6917-a325-47f02cea0457', 'ad4f9977-7647-16de-5a83-47f02c0ff2e7', '2008-03-31 00:14:18', '1', 'phone_work', 'phone', '', '+1 480-510-5865', NULL, NULL); INSERT INTO `contacts_audit` VALUES('d7cd6678-dbd7-28a3-a93a-47f11be519b7', '313a07a8-1428-5583-fae4-47f11b2b37f2', '2008-03-31 17:11:51', '1', 'phone_work', 'phone', '858-756-1095', '', NULL, NULL); INSERT INTO `contacts_audit` VALUES('3846a333-b2eb-d8b8-25dc-47f1202c2481', '783f040b-c5f1-6e97-83cc-47f120c7deda', '2008-03-31 17:34:48', '1', 'phone_work', 'phone', '757-410-0286', '', NULL, NULL); INSERT INTO `contacts_audit` VALUES('bd40a426-6602-64c8-1435-47f1214a7362', '329e0387-d295-803a-3de7-47f12184cbe8', '2008-03-31 17:37:59', '1', 'phone_work', 'phone', '760-940-9455', '', NULL, NULL); INSERT INTO `contacts_audit` VALUES('141508d7-1f7d-e018-0a4c-47f1265943c6', '329e0387-d295-803a-3de7-47f12184cbe8', '2008-03-31 17:58:28', '1', 'phone_work', 'phone', '', '760-940-9455', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `contacts_bugs` -- CREATE TABLE `contacts_bugs` ( `id` varchar(36) NOT NULL default '', `contact_id` varchar(36) default NULL, `bug_id` varchar(36) default NULL, `contact_role` varchar(50) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_con_bug_con` (`contact_id`), KEY `idx_con_bug_bug` (`bug_id`), KEY `idx_contact_bug` (`contact_id`,`bug_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `contacts_bugs` -- -- -------------------------------------------------------- -- -- Table structure for table `contacts_cases` -- CREATE TABLE `contacts_cases` ( `id` varchar(36) NOT NULL default '', `contact_id` varchar(36) default NULL, `case_id` varchar(36) default NULL, `contact_role` varchar(50) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_con_case_con` (`contact_id`), KEY `idx_con_case_case` (`case_id`), KEY `idx_contacts_cases` (`contact_id`,`case_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `contacts_cases` -- -- -------------------------------------------------------- -- -- Table structure for table `contacts_users` -- CREATE TABLE `contacts_users` ( `id` varchar(36) NOT NULL default '', `contact_id` varchar(36) default NULL, `user_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_con_users_con` (`contact_id`), KEY `idx_con_users_user` (`user_id`), KEY `idx_contacts_users` (`contact_id`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `contacts_users` -- -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` varchar(36) NOT NULL default '', `name` varchar(36) NOT NULL default '', `symbol` varchar(36) NOT NULL default '', `iso4217` varchar(3) NOT NULL default '', `conversion_rate` double NOT NULL default '0', `status` varchar(25) default NULL, `deleted` tinyint(1) NOT NULL default '0', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` varchar(36) NOT NULL default '', PRIMARY KEY (`id`), KEY `idx_currency_name` (`name`,`deleted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `currencies` -- -- -------------------------------------------------------- -- -- Table structure for table `custom_fields` -- CREATE TABLE `custom_fields` ( `bean_id` varchar(36) default NULL, `set_num` int(11) default '0', `field0` varchar(255) default NULL, `field1` varchar(255) default NULL, `field2` varchar(255) default NULL, `field3` varchar(255) default NULL, `field4` varchar(255) default NULL, `field5` varchar(255) default NULL, `field6` varchar(255) default NULL, `field7` varchar(255) default NULL, `field8` varchar(255) default NULL, `field9` varchar(255) default NULL, `deleted` tinyint(1) default '0', KEY `idx_beanid_set_num` (`bean_id`,`set_num`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `custom_fields` -- -- -------------------------------------------------------- -- -- Table structure for table `dashboards` -- CREATE TABLE `dashboards` ( `id` varchar(36) NOT NULL default '', `deleted` tinyint(1) NOT NULL default '0', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `assigned_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `name` varchar(100) default NULL, `description` text, `content` text, PRIMARY KEY (`id`), KEY `idx_dashboard_name` (`name`,`deleted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `dashboards` -- INSERT INTO `dashboards` VALUES('3f49a0b4-78d1-e8fe-75bb-47f0f4c6c9a0', 0, '2008-03-31 14:26:46', '2008-03-31 14:26:46', '1', '1', '1', 'Home', NULL, 'a:4:{i:0;a:2:{s:4:"type";s:4:"code";s:2:"id";s:29:"Chart_pipeline_by_sales_stage";}i:1;a:2:{s:4:"type";s:4:"code";s:2:"id";s:28:"Chart_lead_source_by_outcome";}i:2;a:2:{s:4:"type";s:4:"code";s:2:"id";s:22:"Chart_outcome_by_month";}i:3;a:2:{s:4:"type";s:4:"code";s:2:"id";s:29:"Chart_pipeline_by_lead_source";}}'); -- -------------------------------------------------------- -- -- Table structure for table `document_revisions` -- CREATE TABLE `document_revisions` ( `id` varchar(36) NOT NULL default '', `change_log` varchar(255) default NULL, `document_id` varchar(36) default NULL, `date_entered` datetime default NULL, `created_by` varchar(36) default NULL, `filename` varchar(255) NOT NULL default '', `file_ext` varchar(25) default NULL, `file_mime_type` varchar(100) default NULL, `revision` varchar(25) default NULL, `deleted` tinyint(1) default '0', `date_modified` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `document_revisions` -- -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE `documents` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime default NULL, `date_modified` datetime default NULL, `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `description` text, `deleted` tinyint(1) default '0', `document_name` varchar(255) NOT NULL default '', `active_date` date default NULL, `exp_date` date default NULL, `category_id` varchar(25) default NULL, `subcategory_id` varchar(25) default NULL, `status_id` varchar(25) default NULL, `document_revision_id` varchar(36) default NULL, `related_doc_id` varchar(36) default NULL, `related_doc_rev_id` varchar(36) default NULL, `is_template` tinyint(1) default '0', `template_type` varchar(25) default NULL, PRIMARY KEY (`id`), KEY `idx_doc_cat` (`category_id`,`subcategory_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `documents` -- -- -------------------------------------------------------- -- -- Table structure for table `email_addr_bean_rel` -- CREATE TABLE `email_addr_bean_rel` ( `id` varchar(36) NOT NULL default '', `email_address_id` varchar(36) NOT NULL default '', `bean_id` varchar(36) NOT NULL default '', `bean_module` varchar(25) NOT NULL default '', `primary_address` tinyint(1) default '0', `reply_to_address` tinyint(1) default '0', `date_created` datetime default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_email_address_id` (`email_address_id`), KEY `idx_bean_id` (`bean_id`,`bean_module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_addr_bean_rel` -- INSERT INTO `email_addr_bean_rel` VALUES('ef526ba4-b0ab-c4cf-c66a-47f00a9ea907', 'ef69f49e-51f9-28ba-bfcb-47f00af27734', 'ee8cdaa0-848b-2d20-c292-47f00a555dc0', 'Contacts', 1, 0, '2008-03-30 11:46:45', '2008-03-30 11:46:45', 0); INSERT INTO `email_addr_bean_rel` VALUES('d593df16-ee46-56b7-50a3-47f00ae21a91', '5be0a118-6186-87ee-657f-47f00a9f9d66', 'd4ed3900-5b2a-8a81-98b7-47f00a80ed1f', 'Contacts', 1, 0, '2008-03-30 11:48:59', '2008-03-30 11:48:59', 0); INSERT INTO `email_addr_bean_rel` VALUES('b70c08a6-3ccc-e66a-6353-47f00c13a833', 'b89e0641-61b6-d058-1ca6-47f00cec4692', 'aad607ea-f5cd-66e8-405c-47f00cc40b25', 'Contacts', 1, 0, '2008-03-30 11:54:50', '2008-03-30 11:54:50', 0); INSERT INTO `email_addr_bean_rel` VALUES('75d89f34-2f9e-72c1-2384-47f014c123f1', '75ee15b4-cc2e-67b6-2320-47f014f35298', '75070a8c-bbbd-93ad-dd9c-47f01408d0fd', 'Contacts', 1, 0, '2008-03-30 12:29:05', '2008-03-30 12:29:05', 0); INSERT INTO `email_addr_bean_rel` VALUES('9dec01f3-9087-01b7-b527-47f01955920b', '9f980513-52f1-15b8-8fc4-47f019b77e0f', '95e50a7e-b3e4-ecab-67e8-47f019fc567d', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('b7e90e33-6c66-8512-1e60-47f019f652cc', 'b91f05c1-9a68-fe40-40f7-47f019308e72', 'b09702d5-fad8-db7d-0d3e-47f019b91c05', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('d2b803e5-345b-0acc-b4c1-47f0191a8bb8', 'd4140508-23bd-7879-ec0a-47f019922b55', 'c8b40a59-d1de-2fc3-8398-47f0194c8330', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('100f7cd3-8007-0946-893d-47f019fb7487', '1027107b-e100-d55a-5c4e-47f01916df80', 'f9910b79-d1cf-da01-f2af-47f0198e5f37', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('119c5b25-ba37-f413-530f-47f019e1e0e2', '11b03121-359c-0d11-3d16-47f019165288', '11264508-b0d4-35ba-d302-47f019509a07', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('131aee63-ce59-a9d9-a240-47f0192d8d96', '132edeb5-c942-e30d-dcf7-47f01907589d', '12a9282a-b11d-9ea2-f73f-47f019707ce7', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('149bcc1b-7e23-2143-9d80-47f019730753', '14afa143-560d-c6a5-8d52-47f019707507', '142a08b8-2031-e66e-a692-47f0196f66ed', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('161af538-522d-ab95-d240-47f019ad8bca', '162fc89c-5567-dfa1-9752-47f01953a6d7', '15aaa11b-50b4-d148-2f42-47f0198f7e8b', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('179e4b59-2e99-1862-be8c-47f0193089d4', '17b2d0da-f765-7c25-5424-47f019105b24', '172860e5-cb84-1e42-0d50-47f01968d49f', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('191fb2d7-867e-5ad0-4fd0-47f0191c3289', '1933faa2-9f8d-80f9-49c8-47f019035280', '18ac05c8-2df6-05ea-8100-47f019031a38', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('1a9e6b49-6752-87ee-af35-47f019810f07', '1ab33122-f6e7-c6b0-97e5-47f019df9576', '1a2c7677-f403-4b38-e078-47f019de6e64', 'Accounts', 1, 0, '2008-03-30 12:51:54', '2008-03-30 12:51:54', 0); INSERT INTO `email_addr_bean_rel` VALUES('8bad0220-1d3c-cccb-e477-47f01bf85d7a', '9f980513-52f1-15b8-8fc4-47f019b77e0f', '7ed80e67-f490-7683-b2d5-47f01b29feab', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('8ea70347-94ee-847c-6c82-47f01bbf60c1', '8fe10d92-9f19-33dd-8360-47f01bd07eaa', '7ed80e67-f490-7683-b2d5-47f01b29feab', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('b29b09d4-de66-8a0a-a55c-47f01b84961d', 'b91f05c1-9a68-fe40-40f7-47f019308e72', 'a60e03d0-225f-b23f-9fbd-47f01bf16c44', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('b5200dce-9c25-f773-e3ee-47f01b5bc0fc', 'b65e0e50-c531-028b-10d0-47f01b897190', 'a60e03d0-225f-b23f-9fbd-47f01bf16c44', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('d8ed05df-8b71-1a9b-11c0-47f01b729130', 'd4140508-23bd-7879-ec0a-47f019922b55', 'cc400aed-5a4e-2b77-948a-47f01b06946d', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('db690633-d2dc-134c-c755-47f01b3315c4', 'dcd40191-a421-3f29-76d6-47f01bdfdd70', 'cc400aed-5a4e-2b77-948a-47f01b06946d', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('ff5500a3-bd37-e9a7-8c89-47f01b09c01d', '1009ce0a-8b8d-5617-40d6-47f01bc76146', 'f2de0275-8165-5dca-31e4-47f01bc6b8b4', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1233c74d-82a8-1ea4-4459-47f01b87c445', '1027107b-e100-d55a-5c4e-47f01916df80', '11663b36-76b6-0c1f-e698-47f01b87d6b0', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('125db389-80ea-910d-fa84-47f01b7ec900', '12718204-9f61-8da4-8c65-47f01b4f2e28', '11663b36-76b6-0c1f-e698-47f01b87d6b0', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('149a97d4-38e4-1f80-5a03-47f01b70bce9', '11b03121-359c-0d11-3d16-47f019165288', '13cfd405-4ea7-222e-2492-47f01bc04fbf', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('14c46382-6a55-6f3e-bd49-47f01b0a3727', '14dac1c7-e659-3964-6771-47f01bdb3864', '13cfd405-4ea7-222e-2492-47f01bc04fbf', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1721ec0e-7731-931f-2e94-47f01b5d39c8', '132edeb5-c942-e30d-dcf7-47f01907589d', '1652bf43-1abb-d30a-a72e-47f01b8a7ea5', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('174aace3-b77d-720e-c890-47f01ba97645', '175de7df-a6e0-34ea-2fa9-47f01bfce7a8', '1652bf43-1abb-d30a-a72e-47f01b8a7ea5', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1b423395-e72a-5ce1-2329-47f01b5a14a9', '14afa143-560d-c6a5-8d52-47f019707507', '1a5c825d-2066-2ddd-13ed-47f01b73f396', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1b8cf191-265e-4b0f-4d89-47f01bd24e3a', '1ba33d98-89bb-6467-2398-47f01b3ca6bf', '1a5c825d-2066-2ddd-13ed-47f01b73f396', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1e36c564-f3ac-4ac9-b685-47f01bb853df', '162fc89c-5567-dfa1-9752-47f01953a6d7', '1d614ca9-6029-39d8-668c-47f01b17b343', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('1e63edaa-d97b-c087-6b68-47f01b007bab', '1e7c8d1d-f6b6-f8d1-5c8a-47f01b5a7069', '1d614ca9-6029-39d8-668c-47f01b17b343', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('20c0db6a-951b-75aa-39b3-47f01b09b85e', '17b2d0da-f765-7c25-5424-47f019105b24', '1febd321-703f-ade1-8934-47f01b4ecaa7', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('20fb0cc8-4da1-e4b6-0f0c-47f01b265d73', '2110168a-506b-f5a1-9d7d-47f01b8de34a', '1febd321-703f-ade1-8934-47f01b4ecaa7', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('235fb89a-c219-0a81-85e5-47f01b36f399', '1933faa2-9f8d-80f9-49c8-47f019035280', '228c7da5-391f-e36f-9eee-47f01b9ec1fd', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('238b4cc5-7453-1967-c423-47f01b700c36', '23a0b6c4-a0fe-c390-c4dc-47f01b862759', '228c7da5-391f-e36f-9eee-47f01b9ec1fd', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('25d98b59-2257-1106-90c1-47f01b8e3fb3', '1ab33122-f6e7-c6b0-97e5-47f019df9576', '250c2662-276b-d95e-d202-47f01b8d101c', 'Contacts', 1, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('260cb278-d399-2c6b-a524-47f01bec22ed', '261fc1c3-6364-bac8-9eb2-47f01ba3bfe1', '250c2662-276b-d95e-d202-47f01b8d101c', 'Contacts', 0, 0, '2008-03-30 12:59:24', '2008-03-30 12:59:24', 0); INSERT INTO `email_addr_bean_rel` VALUES('e591e21b-f469-1366-1c39-47f01e58a1e8', 'e5b8c420-c0a8-c207-728d-47f01e3036f9', 'e52485ac-7c4b-dbec-aa79-47f01e12872c', 'Accounts', 1, 0, '2008-03-30 13:11:41', '2008-03-30 13:11:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('e877f6a1-7ec3-ec7f-82fe-47f01edfac92', 'e88d9991-c340-d733-290f-47f01e591cb8', 'e809eaa2-5ab0-6a31-9b8d-47f01e77b4a3', 'Accounts', 1, 0, '2008-03-30 13:11:41', '2008-03-30 13:11:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('e9f07079-7a5d-c288-e7a9-47f01e602c2d', 'ea04e775-99f8-1fac-f771-47f01e8dd285', 'e97f83ea-2d53-3e96-7f31-47f01e0f770d', 'Accounts', 1, 0, '2008-03-30 13:11:41', '2008-03-30 13:11:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('14bcdef4-82ef-cee3-b3df-47f01ec1e99c', 'e5b8c420-c0a8-c207-728d-47f01e3036f9', '143f8c87-5d4b-eba7-613e-47f01edbba51', 'Contacts', 1, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('1502cb93-dfe2-220f-b6a1-47f01e0007c3', '151795e9-35cd-0707-7a8e-47f01eafd3fa', '143f8c87-5d4b-eba7-613e-47f01edbba51', 'Contacts', 0, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('169fb132-6f1d-2456-f9b9-47f01e229e43', '16b3d37a-9f8a-995f-c1e7-47f01e9390e6', '16234e87-5903-5682-954f-47f01e7c121c', 'Contacts', 1, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('1838e96d-7640-00ac-7683-47f01e10e1aa', 'e88d9991-c340-d733-290f-47f01e591cb8', '17b99060-b829-0866-59ad-47f01ea4624d', 'Contacts', 1, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('185fba4f-ea1c-58db-160b-47f01e202bc2', '1873c4c1-ee3f-1be2-c9c7-47f01e974a9c', '17b99060-b829-0866-59ad-47f01ea4624d', 'Contacts', 0, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('19f75281-fcb8-b177-d3bb-47f01e3c1477', 'ea04e775-99f8-1fac-f771-47f01e8dd285', '197a5eeb-18fc-c07b-c612-47f01eace493', 'Contacts', 1, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('1a1eba1c-dd0c-9f0e-45c8-47f01eece67c', '1a3131af-4f76-1271-fa76-47f01ee48047', '197a5eeb-18fc-c07b-c612-47f01eace493', 'Contacts', 0, 0, '2008-03-30 13:14:41', '2008-03-30 13:14:41', 0); INSERT INTO `email_addr_bean_rel` VALUES('1e5ff2d4-a095-234e-b81a-47f0219e31c6', '151795e9-35cd-0707-7a8e-47f01eafd3fa', '1d9bb805-185a-42bf-3324-47f0216fa5eb', 'Accounts', 1, 0, '2008-03-30 13:27:32', '2008-03-30 13:27:32', 0); INSERT INTO `email_addr_bean_rel` VALUES('7aa6fcc7-cb1d-2ab7-54cc-47f0276bb7d5', '4d199bfa-5de4-cc61-b19b-47f026e6ee30', '79e99049-99fe-c64d-7106-47f02734fe9f', 'Contacts', 1, 0, '2008-03-30 13:52:13', '2008-03-30 13:52:13', 0); INSERT INTO `email_addr_bean_rel` VALUES('6b934795-8c5c-bbc1-4c15-47f02ce6f447', '6bafec49-3b3c-ea06-daf7-47f02c6203bb', 'ad4f9977-7647-16de-5a83-47f02c0ff2e7', 'Contacts', 1, 0, '2008-03-30 14:14:18', '2008-03-30 14:14:18', 0); INSERT INTO `email_addr_bean_rel` VALUES('31ecfc9a-4d93-70bb-d512-47f11bfd71da', '32045103-9a8c-ff32-f842-47f11b9d8f75', '313a07a8-1428-5583-fae4-47f11b2b37f2', 'Contacts', 1, 0, '2008-03-31 07:10:58', '2008-03-31 07:10:58', 0); -- -------------------------------------------------------- -- -- Table structure for table `email_addresses` -- CREATE TABLE `email_addresses` ( `id` varchar(36) NOT NULL default '', `email_address` varchar(255) NOT NULL default '', `email_address_caps` varchar(255) NOT NULL default '', `invalid_email` tinyint(1) default '0', `opt_out` tinyint(1) default '0', `date_created` datetime default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_ea_caps_opt_out_invalid` (`email_address_caps`,`opt_out`,`invalid_email`), KEY `idx_ea_opt_out_invalid` (`email_address`,`opt_out`,`invalid_email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_addresses` -- INSERT INTO `email_addresses` VALUES('98754486-d09f-bd22-866a-47ef267ddc8b', 'info@etelos.com', 'INFO@ETELOS.COM', 0, 0, '2008-03-30 05:34:27', '2008-03-30 05:34:27', 0); INSERT INTO `email_addresses` VALUES('9cb4d621-0543-fb33-c6b9-47ef2686ab19', 'ronford@iwsbiz.net', 'RONFORD@IWSBIZ.NET', 0, 0, '2008-03-30 05:34:27', '2008-03-30 05:34:27', 0); INSERT INTO `email_addresses` VALUES('ef69f49e-51f9-28ba-bfcb-47f00af27734', 'sue@shepherdsway.org', 'SUE@SHEPHERDSWAY.ORG', 0, 0, '2008-03-30 21:46:44', '2008-03-30 21:46:44', 0); INSERT INTO `email_addresses` VALUES('5ba304d6-7aaf-1aae-3460-47f00a4c3352', 'ronford@respirnetpro.com', 'RONFORD@RESPIRNETPRO.COM', 0, 0, '2008-03-30 21:46:46', '2008-03-30 21:46:46', 0); INSERT INTO `email_addresses` VALUES('5be0a118-6186-87ee-657f-47f00a9f9d66', 'bill@amitesting.com', 'BILL@AMITESTING.COM', 0, 0, '2008-03-30 21:46:46', '2008-03-30 21:46:46', 0); INSERT INTO `email_addresses` VALUES('b89e0641-61b6-d058-1ca6-47f00cec4692', 'lozanofamilyof5@aol.com', 'LOZANOFAMILYOF5@AOL.COM', 0, 0, '2008-03-30 21:54:50', '2008-03-30 21:54:50', 0); INSERT INTO `email_addresses` VALUES('75ee15b4-cc2e-67b6-2320-47f014f35298', 'sjcash1@netzero.com', 'SJCASH1@NETZERO.COM', 0, 0, '2008-03-30 22:29:05', '2008-03-30 22:29:05', 0); INSERT INTO `email_addresses` VALUES('cdfa4b2a-102d-5e5e-f038-47f01466cb85', 'ronford@respirnet.com', 'RONFORD@RESPIRNET.COM', 0, 0, '2008-03-30 22:29:06', '2008-03-30 22:29:06', 0); INSERT INTO `email_addresses` VALUES('9f980513-52f1-15b8-8fc4-47f019b77e0f', 'moldsolution@respirnetpro.com', 'MOLDSOLUTION@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('b91f05c1-9a68-fe40-40f7-47f019308e72', 'adrielcg@respirnetpro.com', 'ADRIELCG@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('d4140508-23bd-7879-ec0a-47f019922b55', 'ryanelowe@respirnetpro.com', 'RYANELOWE@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('1027107b-e100-d55a-5c4e-47f01916df80', 'aqconsultants@respirnetpro.com', 'AQCONSULTANTS@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('11b03121-359c-0d11-3d16-47f019165288', 'patrick@respirnetpro.com', 'PATRICK@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('132edeb5-c942-e30d-dcf7-47f01907589d', 'lisamelanie@respirnetpro.com', 'LISAMELANIE@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('14afa143-560d-c6a5-8d52-47f019707507', 'dave.capshaw@respirnetpro.com', 'DAVE.CAPSHAW@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('162fc89c-5567-dfa1-9752-47f01953a6d7', 'jeff@respirnetpro.com', 'JEFF@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('17b2d0da-f765-7c25-5424-47f019105b24', 'mattdawes@respirnetpro.com', 'MATTDAWES@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('1933faa2-9f8d-80f9-49c8-47f019035280', 'dpalma@respirnetpro.com', 'DPALMA@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('1ab33122-f6e7-c6b0-97e5-47f019df9576', 'dansullivan@respirnetpro.com', 'DANSULLIVAN@RESPIRNETPRO.COM', 0, 0, '2008-03-30 22:51:54', '2008-03-30 22:51:54', 0); INSERT INTO `email_addresses` VALUES('8fe10d92-9f19-33dd-8360-47f01bd07eaa', 'moldsolution@yahoo.com', 'MOLDSOLUTION@YAHOO.COM', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('b65e0e50-c531-028b-10d0-47f01b897190', 'adrielg_1@bellsouth.net', 'ADRIELG_1@BELLSOUTH.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('dcd40191-a421-3f29-76d6-47f01bdfdd70', 'RyanElowe@cox.net', 'RYANELOWE@COX.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('1009ce0a-8b8d-5617-40d6-47f01bc76146', 'barbara@qualityindoor.com', 'BARBARA@QUALITYINDOOR.COM', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('12718204-9f61-8da4-8c65-47f01b4f2e28', 'aqconsultants@comcast.net', 'AQCONSULTANTS@COMCAST.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('14dac1c7-e659-3964-6771-47f01bdb3864', 'patrick@advancelook.net', 'PATRICK@ADVANCELOOK.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('175de7df-a6e0-34ea-2fa9-47f01bfce7a8', 'abbinc@msn.com', 'ABBINC@MSN.COM', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('1ba33d98-89bb-6467-2398-47f01b3ca6bf', 'dave.capshaw@pillartopost.com', 'DAVE.CAPSHAW@PILLARTOPOST.COM', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('1e7c8d1d-f6b6-f8d1-5c8a-47f01b5a7069', 'info@moldpatrol.com', 'INFO@MOLDPATROL.COM', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('2110168a-506b-f5a1-9d7d-47f01b8de34a', 'mattdawes@buildingspecs.us', 'MATTDAWES@BUILDINGSPECS.US', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('23a0b6c4-a0fe-c390-c4dc-47f01b862759', 'professionalhomeinspectors@comcast.net', 'PROFESSIONALHOMEINSPECTORS@COMCAST.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('261fc1c3-6364-bac8-9eb2-47f01ba3bfe1', 'danpatsullivan@comcast.net', 'DANPATSULLIVAN@COMCAST.NET', 0, 0, '2008-03-30 22:59:24', '2008-03-30 22:59:24', 0); INSERT INTO `email_addresses` VALUES('e5b8c420-c0a8-c207-728d-47f01e3036f9', 'joel@respirnetpro.com', 'JOEL@RESPIRNETPRO.COM', 0, 0, '2008-03-30 23:11:41', '2008-03-30 23:11:41', 0); INSERT INTO `email_addresses` VALUES('e88d9991-c340-d733-290f-47f01e591cb8', 'enviropro@respirnetpro.com', 'ENVIROPRO@RESPIRNETPRO.COM', 0, 0, '2008-03-30 23:11:41', '2008-03-30 23:11:41', 0); INSERT INTO `email_addresses` VALUES('ea04e775-99f8-1fac-f771-47f01e8dd285', 'clinton.ford@respirnetpro.com', 'CLINTON.FORD@RESPIRNETPRO.COM', 0, 0, '2008-03-30 23:11:41', '2008-03-30 23:11:41', 0); INSERT INTO `email_addresses` VALUES('151795e9-35cd-0707-7a8e-47f01eafd3fa', 'envirorite@msn.com', 'ENVIRORITE@MSN.COM', 0, 0, '2008-03-30 23:14:41', '2008-03-30 23:14:41', 0); INSERT INTO `email_addresses` VALUES('16b3d37a-9f8a-995f-c1e7-47f01e9390e6', 'hjwoolley@areinspections.com', 'HJWOOLLEY@AREINSPECTIONS.COM', 0, 0, '2008-03-30 23:14:41', '2008-03-30 23:14:41', 0); INSERT INTO `email_addresses` VALUES('1873c4c1-ee3f-1be2-c9c7-47f01e974a9c', 'johnnypro2@mchsi.com', 'JOHNNYPRO2@MCHSI.COM', 0, 0, '2008-03-30 23:14:41', '2008-03-30 23:14:41', 0); INSERT INTO `email_addresses` VALUES('1a3131af-4f76-1271-fa76-47f01ee48047', 'constructionconsultant@windstream.net', 'CONSTRUCTIONCONSULTANT@WINDSTREAM.NET', 0, 0, '2008-03-30 23:14:41', '2008-03-30 23:14:41', 0); INSERT INTO `email_addresses` VALUES('4d199bfa-5de4-cc61-b19b-47f026e6ee30', 'marie.zibbyzabby@gmail.com', 'MARIE.ZIBBYZABBY@GMAIL.COM', 0, 0, '2008-03-30 23:45:10', '2008-03-30 23:45:10', 0); INSERT INTO `email_addresses` VALUES('6bafec49-3b3c-ea06-daf7-47f02c6203bb', 'dylanb@azprohomeinspection.com', 'DYLANB@AZPROHOMEINSPECTION.COM', 0, 0, '2008-03-31 00:14:18', '2008-03-31 00:14:18', 0); INSERT INTO `email_addresses` VALUES('a02557e0-6490-2297-49cb-47f06d8cf43e', 'registration@respirnetpro.com', 'REGISTRATION@RESPIRNETPRO.COM', 0, 0, '2008-03-31 04:51:08', '2008-03-31 04:51:08', 0); INSERT INTO `email_addresses` VALUES('bdca3e2a-2da2-381b-c798-47f07e42f234', 'danjr@sandpiperpools.com', 'DANJR@SANDPIPERPOOLS.COM', 0, 0, '2008-03-31 06:01:16', '2008-03-31 06:01:16', 0); INSERT INTO `email_addresses` VALUES('c2bb5e82-508b-48ab-fc94-47f0f366ccb9', 'ronford@sandiego-websitedesign.com', 'RONFORD@SANDIEGO-WEBSITEDESIGN.COM', 0, 0, '2008-03-31 14:23:58', '2008-03-31 14:23:58', 0); INSERT INTO `email_addresses` VALUES('32045103-9a8c-ff32-f842-47f11b9d8f75', 'todd@junglescape.com', 'TODD@JUNGLESCAPE.COM', 0, 0, '2008-03-31 17:10:58', '2008-03-31 17:10:58', 0); INSERT INTO `email_addresses` VALUES('63c85121-3e36-4c2e-5f09-47f17708a403', 'steve@goldcoastskylights.com', 'STEVE@GOLDCOASTSKYLIGHTS.COM', 0, 0, '2008-03-31 23:43:38', '2008-03-31 23:43:38', 0); -- -------------------------------------------------------- -- -- Table structure for table `email_cache` -- CREATE TABLE `email_cache` ( `ie_id` varchar(36) NOT NULL default '', `mbox` varchar(60) NOT NULL default '', `subject` varchar(255) default NULL, `fromaddr` varchar(100) default NULL, `toaddr` varchar(255) default NULL, `senddate` datetime NOT NULL default '0000-00-00 00:00:00', `message_id` varchar(255) default NULL, `mailsize` int(10) unsigned NOT NULL default '0', `imap_uid` int(10) unsigned NOT NULL default '0', `msgno` int(10) unsigned default NULL, `recent` tinyint(4) NOT NULL default '0', `flagged` tinyint(4) NOT NULL default '0', `answered` tinyint(4) NOT NULL default '0', `deleted` tinyint(4) NOT NULL default '0', `seen` tinyint(4) NOT NULL default '0', `draft` tinyint(4) NOT NULL default '0', KEY `idx_ie_id` (`ie_id`), KEY `idx_mail_date` (`ie_id`,`mbox`,`senddate`), KEY `idx_mail_from` (`ie_id`,`mbox`,`fromaddr`), KEY `idx_mail_subj` (`subject`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_cache` -- INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'FW: RNP_Associate_Application: Submission', 'Bill McLeod ', 'Ron Ford ', '2008-03-30 15:20:32', 'UID13-1206716042', 3587, 6, 6, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'RNP_Associate_Application: Submission', 'Applications@respirnetpro.com', 'ronford@respirnetpro.com', '2008-03-30 14:21:18', 'UID12-1206716042', 3632, 5, 5, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'RE: QUESTION', 'Bill McLeod ', '''RespirNet'' ', '2008-03-28 23:21:51', 'UID10-1206716042', 19651, 4, 4, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'RE: RE:', 'Sue McLeod ', '''RespirNet'' ', '2008-03-28 22:48:31', 'UID9-1206716042', 27783, 3, 3, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'QUESTION', 'Bill McLeod ', 'Ron Ford ', '2008-03-28 21:51:11', 'UID8-1206716042', 10423, 2, 2, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'RE:', 'Sue McLeod ', '''Ron Ford'' ', '2008-03-28 21:12:06', 'UID4-1206716042', 14138, 1, 1, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'Welcome to RespirNet! Your new RespirNet PRO Associate account is set up and ready to go.', 'Integrity Web Services ', 'dylanb@azprohomeinspection.com', '2008-03-31 22:41:14', 'UID21-1206716042', 13000, 12, 12, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'FW: CIH', 'Mike Buettner ', 'ronford@respirnetpro.com', '2008-03-31 18:09:56', 'UID20-1206716042', 15560, 11, 11, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('86eecabc-7fae-94cf-f712-47ef25a4c5b8', 'INBOX', 'RE: sandpiper website', 'Dan Jr ', '''Ron Ford'' ', '2008-03-28 18:27:58', 'UID234-1206033905', 90353, 1, 1, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'RE: FW: CIH', 'Mike Buettner ', '''Ron Ford'' ', '2008-03-31 23:24:08', 'UID22-1206716042', 19994, 13, 13, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('86eecabc-7fae-94cf-f712-47ef25a4c5b8', 'INBOX', 'Re: Module for Google Checkout', 'Marie May ', 'Ron Ford ', '2008-03-28 20:12:25', 'UID238-1206033905', 7600, 2, 2, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'Basic Plan Set-up: Submission', 'registration@respirnetpro.com', 'ronford@respirnetpro.com', '2008-03-31 03:02:04', 'UID19-1206716042', 3325, 10, 10, 1, 1, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('86eecabc-7fae-94cf-f712-47ef25a4c5b8', 'INBOX', 'Re: Module for Google Checkout', 'Marie May ', 'Ron Ford ', '2008-03-31 22:06:05', 'UID297-1206033905', 12524, 8, 8, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('86eecabc-7fae-94cf-f712-47ef25a4c5b8', 'INBOX', 'Fwd: Emailing: Baby_Guard_Pool_Fences, Baby_Guard_Pool_Fences-med, Baby_Guard_Pool_Fences-small, ccm01, ccm financial-med, ccm financial-small, CSLB-logo, CSLB-logo-med., CSLB-logo-small, gemstone logo, gemstone logo-med, gemstone logo-small, integri', 'Ron Ford ', 'ronford@sandiego-websitedesign.com', '2008-03-31 14:20:55', 'UID292-1206033905', 220145, 3, 3, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('86eecabc-7fae-94cf-f712-47ef25a4c5b8', 'INBOX', 'site', 'Steve Stogner ', 'Ron Ford ', '2008-03-31 18:14:48', 'UID294-1206033905', 3829, 5, 5, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'web site', 'Pillar to Post-Gail Capshaw ', 'ronford@respirnetpro.com', '2008-03-31 01:31:13', 'UID18-1206716042', 45202, 9, 9, 1, 1, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'Fwd: RNP_Associate_Application: Submission', 'Ron Ford ', 'ronford@respirnet.com', '2008-03-30 22:25:46', 'UID16-1206716042', 4708, 7, 7, 1, 0, 0, 0, 1, 0); INSERT INTO `email_cache` VALUES('cc8901ee-a47b-8ea8-c96d-47f008373546', 'INBOX', 'Your RespirNet PRO application has been accepted', 'RespirNet ', 'Stephen Cash ', '2008-03-30 22:32:04', 'UID17-1206716042', 5999, 8, 8, 1, 0, 0, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `email_marketing` -- CREATE TABLE `email_marketing` ( `id` varchar(36) NOT NULL default '', `deleted` tinyint(1) NOT NULL default '0', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `name` varchar(255) default NULL, `from_name` varchar(100) default NULL, `from_addr` varchar(100) default NULL, `reply_to_name` varchar(100) default NULL, `reply_to_addr` varchar(100) default NULL, `inbound_email_id` varchar(36) default NULL, `date_start` datetime default NULL, `template_id` varchar(36) NOT NULL default '', `status` varchar(25) NOT NULL default '', `campaign_id` varchar(36) default NULL, `all_prospect_lists` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_emmkt_name` (`name`), KEY `idx_emmkit_del` (`deleted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_marketing` -- -- -------------------------------------------------------- -- -- Table structure for table `email_marketing_prospect_lists` -- CREATE TABLE `email_marketing_prospect_lists` ( `id` varchar(36) NOT NULL default '', `prospect_list_id` varchar(36) default NULL, `email_marketing_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `email_mp_prospects` (`email_marketing_id`,`prospect_list_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_marketing_prospect_lists` -- -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- CREATE TABLE `email_templates` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `published` varchar(3) default NULL, `name` varchar(255) default NULL, `description` text, `subject` varchar(255) default NULL, `body` text, `body_html` text, `deleted` tinyint(1) NOT NULL default '0', `text_only` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_email_template_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` VALUES('bb2e2482-55b4-46c6-10fd-47f00d87863e', '2008-03-30 21:59:22', '2008-03-30 21:59:22', '1', '1', 'off', 'RNP Application Accepted Email', 'Instructions for next steps to purchase and submit set up information', 'Your RespirNet PRO application has been accepted', NULL, 'Congratulations, $contact_name, and welcome to the RespirNet community of IAQ professionals!

Your next step is to decide which RespirNet PRO plan you will sign up for. 

We offer two plans, both of which will be explained in detail at http://www.respirnetpro.com/rnp-order-form.html.
Please go to this page and make your selection. 

Once that is complete and your transaction has been approved, you will be directed to a set up page for the plan you selected.  There you will be prompted to give us all the various bits of information we will need to set up and configure your RespirNet PRO account and features.

If you have any questions, please feel free to call us at 800-369-7598 or email us at info@respirnetpro.com.', 0, 0); INSERT INTO `email_templates` VALUES('90036cb0-bb68-9e61-593c-47f012333284', '2008-03-30 22:21:22', '2008-03-31 22:27:35', '1', '1', 'off', 'RNP New Account Set Up Information', 'Welcome and instructions for login to RNP account', 'Welcome to RespirNet! Your new RespirNet PRO Associate account is set up and ready to go.', NULL, 'Dear $contact_name,

This is to inform you that your RespirNet PRO Associate account has been set up and is ready to use.

Your new membership in RespirNet includes many resources intended to help you to grow and manage your business well. 

Here is the information you will need to access these services.

Directory Listing: You now have a listing/advertisement on the RespirNet search directory for the state of Arizona.  You can review your listing at http://moldinspectordirectory.com/state-directories/mold-inspection-arizona-mold-inspector.html.

Associate User Name/Password: We have used one of your choices for your user name to create log-ins for you to the RespirNet PRO services that you now have access to as a RespirNet associate.

Your user name is: dylan
Your password is: 000000 

  • This user name and password will give you access to the following RespirNet PRO services or pages.  Please change it to whatever you wish.
  • To change the password to you use to log-in to the RespirNet PRO members only pages, click on the 'Change Your Password Here' link that is below the log-in on the top right column of each page on the RespirNetPro.com site.
  • If at a later point you decide to change the password to your Google Apps account, please contact us for help (at this point, once the password is set, Google requires the Administrator to change the password. Hopefully they will change that, but until they do, I'm more than happy to do it for you.)

Web Tools Account by Google Apps:  You now have a  account that includes a Gmail, documents and spreadsheets and calendar (and other things, too!) - you should have already received an email regarding your new email address and the link to the start page.  This is a repeat of that information. 

  • Your new RespirNet associate email address is 000000@respirnetpro.com and the temporary password you were assigned is 0000000. (If you have already logged in, you know that you were required to change it; if you haven't logged in yet, well, here's your warning - the first time you log-in to your Google Apps account, you will be asked to set a new password.
  • You can log-in to your RespirNet PRO/Google Apps domain services Start page - http://start.respirnetpro.com

RespirNet PRO MEMBERS ONLY content:  Please go to http://www.respirnetpro.com and use your log-in (above in #2) in the log-in field you will find at the top of the left column of the page.  This will take you to the main page of the Members Only section of the RespirNet PRO web site.

RespirNet Associate website: And finally, you now have your own personalized RespirNet Associate website configured with the information you submitted in the registration process.  You and your clients can reach your new website at http://www.rnpro.net/i/000000. Add this URL to your business cards, put it in fliers, news paper ads or any other advertising that you use.

If you have any questions or if we can be of help to you please don't hesitate to let us know.  Don't forget, can always use the contact form on RespirNet PRO (http://www.respirnetpro.com/contact-form.html) to let us know what we can do to help.  Or you can email us at info@respirnetpro.com.  Or call us- the 800 number is below.

If it is in our power to help you succeed in your IAQ business, we are determined to do it.', 0, 0); INSERT INTO `email_templates` VALUES('5d52a7e0-2547-7cfc-ac0c-47f17d817e54', '2008-04-01 00:12:22', '2008-04-01 00:12:22', '1', '1', 'off', '2nd Email re. new account sign-up', 'Follow up for new accounts that haven''t finished sign up process', 'Follow up from RespirNet regarding your application and setup process.', NULL, '$contact_name, this is just a follow up email regarding your incomplete application process with RespirNet. 

Now that your application has been accepted, your next step is to select the RespirNet Associate plan you wish to purchase and then give us the information we will need to set up your account's directory listing and logins that give you access to the various RespirNet Associate benefits and features.

For your convenience, here is the URL we send you before: http://www.respirnetpro.com/rnp-order-form.html Once this is complete we will finish the setup process and email you all the details you will need to begin using your RespirNet Associate tools and resources.

If you have any questions or if we can be of any help, please let us know.', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `emailman` -- CREATE TABLE `emailman` ( `date_entered` datetime default NULL, `date_modified` datetime default NULL, `user_id` varchar(36) default NULL, `id` int(11) NOT NULL auto_increment, `campaign_id` varchar(36) default NULL, `marketing_id` varchar(36) default NULL, `list_id` varchar(36) default NULL, `send_date_time` datetime default NULL, `modified_user_id` varchar(36) default NULL, `in_queue` tinyint(1) default '0', `in_queue_date` datetime default NULL, `send_attempts` int(11) default '0', `deleted` tinyint(1) default '0', `related_id` varchar(36) default NULL, `related_type` varchar(100) default NULL, PRIMARY KEY (`id`), KEY `idx_eman_list` (`list_id`,`user_id`,`deleted`), KEY `idx_eman_campaign_id` (`campaign_id`), KEY `idx_eman_relid_reltype_id` (`related_id`,`related_type`,`campaign_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1