-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 10.4.10-MariaDB - mariadb.org binary distribution -- Server OS: Win64 -- HeidiSQL Version: 11.0.0.5919 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- Dumping database structure for dbasesample CREATE DATABASE IF NOT EXISTS `dbasesample` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `dbasesample`; -- Dumping structure for table dbasesample.customers CREATE TABLE IF NOT EXISTS `customers` ( `Customerid` int(11) NOT NULL AUTO_INCREMENT, `company` char(40) NOT NULL DEFAULT '', `Lastname` char(15) NOT NULL DEFAULT '', `firstname` char(15) NOT NULL DEFAULT '', `Phone` char(20) NOT NULL DEFAULT '', `Address1` char(30) NOT NULL DEFAULT '', `Address2` char(30) NOT NULL DEFAULT '', `city` char(20) DEFAULT NULL, `State` char(2) DEFAULT NULL, `Zip` char(10) DEFAULT NULL, PRIMARY KEY (`Customerid`) ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1; -- Dumping data for table dbasesample.customers: ~102 rows (approximately) /*!40000 ALTER TABLE `customers` DISABLE KEYS */; REPLACE INTO `customers` (`Customerid`, `company`, `Lastname`, `firstname`, `Phone`, `Address1`, `Address2`, `city`, `State`, `Zip`) VALUES (1, 'Spire Corporation', 'B', 'Arlett', '(801) 534-1231', 'Cms, Inc.', '', 'Che', 'SD', '01730'), (2, 'Storage Technology Corp.', 'Cardwell', 'Bobbye', '860 694 2647', 'Bldg 20', '', 'Groton', 'OH', '80028'), (3, 'Halliburton Company', 'Hutchins', 'Pamala', '410-823-6700', 'Ste. 805', 'Suite 6000', 'Towson', 'MI', '77010'), (4, 'California Water Service Group', 'Flowers', 'Bethany', '520 746 7549', '2305 East 19th St.', 'Jalan Ang Cheng Ho', 'Tucson', 'NJ', '95112'), (5, 'The Rouse Company', 'Doran', 'Kecia', '(606)849-8471', 'R. 1 Box 107', '', 'Hillsboro', 'NY', '21044'), (6, 'HomeFed Corporation', 'Arrington', 'Shellie', '440 777 4569', '3969 West 227 St.', 'Suite 1250', 'Fairview Park', 'KY', '92008'), (7, 'John H. Harland Company', 'Belcher', 'Chong', '770 314-3065', '2134 Sara Ashley Way', 'Suite 500', 'Lithonia', 'NJ', '30035'), (8, 'Rogers Corporation', 'Flint', 'Christiane', '651 686 0405', '3195 Neil Armstrong Blvd.', '', 'Eagan', 'DC', '06263'), (9, 'International Electronics', 'Davila', 'Ellie', '609 522 2075', '1901 Surf Ave.', 'Bldg 3310', 'North Wildwood', 'IL', '02021'), (10, 'Security Investments Grp.', 'Aponte', 'Rufina', '360-753-7690', '3625 93rd Ave. Sw', '', 'Olympia', 'CA', '08360'), (11, 'Raytheon Company', 'Ransom', 'Tamar', '415-564-4763', '2114 28th Avenue', '', 'San Francisco', 'MD', '02451'), (12, 'Norstan, Inc.', 'Jeffers', 'Vergie', '206-767-4827', '8440 18th Ave Sw', 'Suite # 7', 'Seattle', 'NJ', '55343'), (13, 'Deere & Company', 'Hull', 'Lucile', '208 672 7230', '8948 West Barnes St.', 'Suite D', 'Boise', 'OR', '61265'), (14, 'Donegal Group Inc.', 'Weeks', 'Bianca', '270-441-6010', '6330 Waid Circle', 'Pharmacy - 119', 'Paducah', 'CA', '17547'), (15, 'Frozen Food Express Ind.', 'Goff', 'Dionne', '260 724 8946', '1001 West Commerce Dr.', 'Interior 5', 'Decatur', 'TX', '75247'), (16, 'Moore-Handley, Inc.', 'Trotter', 'Ileana', '941 351 5073', '7518 42nd Court East', 'Suite F', 'Sarasota', 'OR', '35124'), (17, 'First Horizon National Corporation', 'Stanton', 'Lynnette', '916 364 1000 x107', '3090 Fite Circle', 'Unit F', 'Sacramento', 'CA', '38103'), (18, 'AEP Industries', 'Wilson', 'Maria', '931 431 3153', '2489 Fort Campbell Blvd.', 'Amsam-rd-ws-id Bldg 7804', 'Clarksville', 'TN', '07606'), (19, 'Paulson Capital Corp.', 'Block', 'Stephani', '301-657-3600', '8808 Twin Creek Court', '', 'Potomac', 'CA', '97204'), (20, 'The St. Joe Company', 'Mckinnon', 'Zaida', '(423) 636-6216', '2245 Fall Creek Rd', '', 'Russellville', 'MA', '32202'), (21, 'Miracor Diagnostics, Inc.', 'Rangel', 'Emilie', '404-299-9373', '4708 Elam Forrest Dr', 'Suite 103', 'Stone Mountain', 'OK', '92122'), (22, 'Columbia Laboratories', 'Mosley', 'Maude', '480 807 0724', '4630 East Grandview St.', 'Lot 280', 'Mesa', 'NE', '07039'), (23, 'Suffolk Bancorp', 'Blalock', 'Dennise', '(440) 256-1411', '9030 Blue Jay Lane', '', 'Kirtland', 'GA', '11901'), (24, 'Inter-Tel, Inc.', 'Forrest', 'Phillis', '813 875 1095', '4048 West Kennedy Blvd.', 'Hannon Hall Rm 32', 'Tampa', 'FL', '85281'), (25, 'NL Industries, Inc.', 'Sadler', 'Daniella', '620-364-4064', '1550 Oxen Lane N.e.', 'Room C240', 'Burlington', 'MI', '75240'), (26, 'Environmental Power Corporation', 'Cabrera', 'Darcy', '815 226-9225', '9766 Olas Lane', 'P.o.box 810', 'Rockford', 'CA', '03801'), (27, 'INEI Corporation', 'Worley', 'Samatha', '919-929-8608', '1602 Lucy Lane', '11.00', 'Carrboro', 'NJ', '20785'), (28, 'Seitel, Inc.', 'Ryder', 'Alethea', '414-764-2659', '1977 East Montana Avenue', '', 'Oak Creek', 'UT', '77043'), (29, 'Taro Pharmaceutical Industries Ltd.', 'Priest', 'Gabriele', '407-895-5111', '2111 East Michigan St.', '', 'Orlando', 'IN', '10532'), (30, 'Trinity Industries, Inc.', 'High', 'Ayana', '405 736 2619', 'Bldg 3113 Ne Corner', '', 'Tinker AFB', 'VA', '75207'), (31, 'AutoInfo, Inc.', 'Chapman', 'Lucy', '602 952 8967', '3116 East Ocotillo Rd.', 'Suite 400', 'Phoenix', 'MD', '33487'), (32, 'COMARCO, Inc.', 'Fischer', 'Elva', '317-897-1818', '1927 West Plantation Row', 'Residence Inn', 'Greenfield', 'DC', '92618'), (33, 'Ronson Corporation', 'Pickens', 'Lai', '708-425-5527', '4041 99th Place', '', 'Oak Lawn', 'CO', '08875'), (34, 'Sonesta International Hotels Corporation', 'Willoughb', 'Mathilda', '920-794-1422', '2508 36th Place', '', 'Two Rivers', 'CA', '02116'), (35, 'Milastar Corporation', 'Biggs', 'Jeniffer', '410-464-1104', '6201 Loch Raven Boulevard', 'Suite 200', 'Baltimore', 'VA', '55426'), (36, 'Harrah\'s Entertainment, Inc.', 'Parson', 'Lyndsay', '727-784-9630', '1575 Owls Retreat', '', 'Tarpon Springs', 'VA', '89119'), (37, 'Wyeth', 'Freeman', 'Thelma', '509 534 3992', '1010 Lake Rd.', '3-chome', 'Spokane', 'WI', '07940'), (38, 'Kinder Morgan, Inc.', 'Pineda', 'Brenna', '202-333-7497', '1680 31st Street Nw', 'Taman Sg Besi Indah', 'WASHINGTON', 'CA', '77002'), (39, 'TouchStone Software Corporation', 'Pringle', 'Elodia', '806-698-0055', '6031 76th St.', '', 'Lubbock', 'AZ', '01845'), (40, 'ESNI, Inc.', 'Cavanaugh', 'Fredia', '510-845-5600', '2464 West St', '', 'Berkeley', 'OH', '06611'), (41, 'Virco Manufacturing Corp.', 'Montalvo', 'Glendora', '415 771 1924', '1930 Polk St.', '', 'San Francisco', 'OH', '90501'), (42, 'Parlex Corporation', 'Neff', 'Jacinta', '402-493-3313', '3805 Polk St', '', 'Omaha', 'MI', '01844'), (43, 'Banknorth Group, Inc.', 'Abel', 'Kristan', '800-325-8232', '2112 15th Street Nw', '', 'Rochester', 'NY', '04112'), (44, 'New Valley Corp.', 'Lorenz', 'Lera', '303 232 5297', '1370 Carr St', '', 'Lakewood', 'NY', '33131'), (45, 'Escalade, Inc.', 'Mcneil', 'Louisa', '(727) 528-8840', '5107 16th St N', 'Unit F', 'St Petersburg', 'HI', '47992'), (46, 'Educational Development', 'Berg', 'Neva', '619 574 1678', '1609 Fort Stockton Dr.', '1430 Broadway', 'San Diego', 'NY', '74146'), (47, 'Cuisine Solutions, Inc.', 'Amaya', 'Norman', '817.834.7098', '3012 Bert St. Apt #402', '', 'Haltom City', 'CA', '22312'), (48, 'A. Schulman, Inc.', 'Ludwig', 'Paris', '858 677 9560', '5375 Mira Sorrento Pl.', '', 'San Diego', 'CT', '44333'), (49, 'Parkvale Financial Corp.', 'Dow', 'Sade', '417-847-2221', '1501 Main St.', '', 'Cassville', 'OR', '15146'), (50, 'Fidelity Federal Bancorp', 'Mcfarland', 'Selena', '208 331 5667', '5987 West State St.', 'Suite 400', 'Boise', 'DC', '47708'), (51, 'Identix Incorporated', 'Beatty', 'Tessie', '(613) 834-0049', '2981 Ford Street Extension', 'Bonair Industrial Center', 'Ogdensburg', 'ID', '55343'), (52, 'Trimble Navigation Limited', 'Linn', 'Jesenia', '252 972 9772', '1502 West Thomas St.', '', 'Rocky Mount', 'AZ', '94085'), (53, 'United Systems Technology', 'Urban', 'Joye', '(909) 869-3032', '3801 West Temple Ave', '', 'Pomona', 'UT', '75234'), (54, 'ABC Dispensing Tech.', 'Bryant', 'Norma', '847-431-0422', '1125 Plum Tree Lane', 'Baker Library 6', 'Palatine', 'MA', '44305'), (55, 'Newpark Resources, Inc.', 'Grayson', 'Jenni', '925-279-0290', '2420 Tice Valley Boulevard', 'Suite 405', 'Walnut Creek', 'MD', '70002'), (56, 'CNS, Inc.', 'Cannon', 'Latoya', '5029682020.00', '5611 Fern Valley Rd.', 'Suite 521', 'Louisville', 'FL', '55344'), (57, 'Giga-tronics, Incorporated', 'Langley', 'Sharlene', '480 483 2700', '8687 East Via De Ventura', 'Apt21e', 'Scottsdale', 'CA', '94583'), (58, 'BWC Financial Corp.', 'Stanley', 'Colleen', '4068928600.00', '5565 Hwy2 W.', 'Apt. B', 'Columbia Falls', 'NV', '94596'), (59, 'West Pharmaceutical Services', 'Quarles', 'Samara', '410 664 8930`', '4800 East Wabash Ave.', '', 'Baltimore', 'NJ', '19341'), (60, 'Southwall Technologies', 'Whatley', 'Mickie', '801-561-5320', '8045 S 700 E Ste 7', '', 'Sandy', 'CA', '94303'), (61, 'Linear Technology Corp.', 'Marrero', 'Sabina', '305-274-4660', '8301 Sw 108 Street', 'Dept 1316', 'Miami', 'OK', '95035'), (62, 'Camera Platforms International, Inc.', 'Maxwell', 'Kendra', '360-396-1022', 'Nuwc Dk 610 Dowell St.', 'Apt 320', 'Keyport', 'MI', '91605'), (63, 'Nortel Networks Corporation', 'Hooker', 'Melony', '305-757-0602 x 117', '9076 Nw 112 Street', '19th Floor', 'Hialeah Gardens', 'MA', 'L6T 5'), (64, 'A.G. Edwards, Inc.', 'Mcintyre', 'Eve', '903-534-3276', 'P.o. Box 1411', 'Taman Sg Besi Indah', 'Tyler', 'TX', '63103'), (65, 'Science Dynamics Corporation', 'Sherrill', 'Lyla', '(336)727-2638', 'P.o. Box 2511', '', 'Winston-Salem', 'KS', '08109'), (66, 'Mine Safety Appliances', 'Kay', 'Altagracia', '918-495-5943', '4500 So 129th East Ave', 'Jalan Ang Cheng Ho', 'Tulsa', 'PR', '15238'), (67, 'Wendt-Bristol Health Serv', 'Jacques', 'Andrew', '305 228 5817', '1197 Sw 132nd Place Circle', '', 'miami', 'FL', '43215'), (68, 'Security National Financial Corp', 'Trejo', 'Janey', '605/866-4495', 'Hc 3 Box 38', '', 'Reva', 'OH', '84123'), (69, 'Warrantech Corporation', 'Foss', 'Carline', '(405) 720-8024', '5741 Nw 86th St', '', 'OKLAHOMA CITY', 'TX', '76021'), (70, 'Puget Energy, Inc.', 'Bergman', 'Nella', '903-967-3413', '1250 Fm 778', '', 'Quitman', 'TX', '98004'), (71, 'Raven Industries, Inc.', 'Cho', 'Amada', '352 376 3034', '4624 Nw 17th Pl.', '', 'Gainesville', 'IL', '57117'), (72, 'Meridian Resource Corp.', 'Patten', 'Stephane', '305 663 2721', '4708 Sw 67th Ave. St #l3', '', 'Miami', 'NY', '77077'), (73, 'Scott\'s Liquid Gold Inc.', 'Nunn', 'Dani', '(715) 720-1020', 'P.o. Box 814', '', 'Chippewa Falls', 'NY', '80239'), (74, 'Siliconix Incorporated', 'Daigle', 'Page', '301 614 6011', 'Code 920 Bldg 33', '', 'Greenbelt', 'NY', '95054'), (75, 'Candela Corporation', 'Guerrero', 'Ernestine', '404 366 7550', '5486 Old Dixie Hwy.', 'Dept 200', 'Forest Park', 'CA', '01778'), (76, 'Outlook Group Corp.', 'Belanger', 'Stephaine', '850-874-0801', '7402 Ray Glenn Circle', '', 'Panama City', 'TX', '54956'), (77, 'Bio-Logic Systems Corp.', 'Hale', 'Daisy', '703 587-5335', '9300 Lee Highway', 'Suite 101', 'Fairfax', 'MI', '60060'), (78, 'Bairnco Corporation', 'Brewer', 'Jo', '(201) 906-1066', '1099 Van Houten Avenue', 'Suite 616', 'Clifton', 'OR', '32746'), (79, 'Seneca Foods Corporation', 'Humphries', 'Kandace', '209-966-6277', '2536 Old Hwy', '', 'Cathys Valley', 'CA', '14505'), (80, 'Lincoln Logs Ltd.', 'Mcclendon', 'Joseph', '(928) 776-1881', '2054 Old Kettle Drive', 'Suite A', 'Prescott', 'MD', '12817'), (81, 'Computer Horizons Corp.', 'Garrison', 'Consuelo', '435 797 1660', '9100 Old Main Hill', 'Suite 400', 'Logan', 'CA', '07046'), (82, 'Coral Gold Corp.', 'Trevino', 'Joni', '818-768-2513', '7924 Via Magdalena', 'Amsam-rd-ws-id Bldg 7804', 'Burbank', 'MN', 'V6C 1'), (83, 'Sunrise Technologies International, Inc.', 'Watt', 'Particia', '865-694-6470', '8707 - 2 Old Colony Trail', '', 'Knoxville', 'MA', '94538'), (84, 'MGP Ingredients, Inc.', 'Gipson', 'Lulu', '323 442-1640', '1420 San Pablo #b105', 'Unit 1501', 'los angeles', 'TX', '66002'), (85, 'Deb Shops, Inc.', 'Ayers', 'Margo', '505-662-6904', '1105 Los Pueblos', 'Suite #200', 'Los Alamos', 'PA', '19114'), (86, 'AMCORE Financial, Inc.', 'Anderson', 'Dorothy', '(847) 835-8040', '1020 Oak Ridge Drive', 'Apt A', 'Glencoe', 'IL', '61104'), (87, 'Sun Bancorp, Inc.', 'Cottrell', 'Antonio', '919-304-2803', '4222 Elg Road', '', 'Efland', 'NJ', '17837'), (88, 'PAR Technology Corp.', 'Randle', 'Velva', '305-668-4276', '7600 Red Road', '', 'Coral Gables', 'TX', '13413'), (89, 'Liberty Homes, Inc.', 'Quintana', 'Idella', '573-449-2646', '1113 Fay Street', 'Dept 1316', 'Columbia', 'GA', '46527'), (90, 'Petroleum Development Corporation', 'Madrid', 'Gisele', '707--678-4281', '7800 Serpa Lane', '', 'Dixon', 'PA', '26330'), (91, 'PacifiCare Health Systems', 'Engle', 'Maribeth', '(404) 284-6995', '1253 Celia Way', '', 'Decatur', 'TX', '90630'), (92, 'Great American Financial', 'Kinsey', 'Regan', '760-744-8300', '1425 Linda Vista Drive', '', 'San Marcos', 'FL', '45202'), (93, 'Mesa Air Group, Inc.', 'Blanco', 'Windy', '719 638 1622', '2555 Villa Loma', 'Hilton Head', 'Colorado Springs', 'CA', '85008'), (94, 'ProCyte Corporation', 'Bartley', 'Zula', '805-239-9100', '3025 Buena Vista Dr.', '', 'Paso Robles', 'VA', '98052'), (95, 'CompuDyne Corporation', 'Schroeder', 'Dina', '913-906-6000', '2021 Massachusetts Avenue, Nw', 'Of 603 - Surco', 'Washington', 'CA', '21076'), (96, 'Interstate General Company L.P.', 'Mcgill', 'Jung', '8106949390.00', '8305 S. Saginaw Street', 'Apt 11-10', 'Grand Blanc', 'TX', '20118'), (97, 'Computer Network Technology', 'Shields', 'Rosetta', '361-661-7000', '1408 E. Main St.', 'Suite 400', 'Alice', 'CA', '55442'), (98, 'TELS Corporation', 'Dent', 'Chaya', '619-725-7062', '4100 Normal St.', '', 'San Diego', 'VA', '84003'), (99, 'ABM Industries, Inc.', 'Fisher', 'Rosa', '262 821 3555', '1810 S. Calhoun Rd.', 'Allen-460', 'New Berlin', 'OH', '94111'), (100, 'CREDO Petroleum Corporation', 'Merritt', 'Kirsten', '408-364-9200', '6250 Tillamook Drive', '2nd Fl', 'San Jose', 'NM', '80202'), (101, 'Ashland Inc.', 'Ryan', 'Carla', '505.260.4770', '4001 Indian School Road Ne', 'Unit F', 'Albuquerque', 'VA', '41012'), (106, 'Storage Technology Corp.', 'Cardwell', 'Bobbye', '', '', '', 'Groton', NULL, NULL); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;