Enter password: -- MySQL dump 9.08
--
-- Host: localhost    Database: sungard
---------------------------------------------------------
-- Server version	4.0.13-nt

--
-- Table structure for table 'company'
--

CREATE TABLE company (
  mpid char(4) NOT NULL default '',
  name char(50) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table 'company'
--

INSERT INTO company VALUES ('EFGI','Empire Financial Group, Inc.');
INSERT INTO company VALUES ('FACT','First Albany');
INSERT INTO company VALUES ('BWNC','STC Securities Corporation');
INSERT INTO company VALUES ('SIBI','SunGard Institutional Brokerage, Inc.');
INSERT INTO company VALUES ('JIMK','Sunstate Equity Trading');
INSERT INTO company VALUES ('WEDB','Wedbush Morgan Securities');
INSERT INTO company VALUES ('DEMO','Demo Trading, Inc.');
INSERT INTO company VALUES ('SNDS','Sands Brothers & Co., LTD');
INSERT INTO company VALUES ('RAGN','Wells Fargo Investments, LLC');
INSERT INTO company VALUES ('TDCO','Thomson Davis & Co.');
INSERT INTO company VALUES ('SOAR','Sterling Financial Investment Group');
INSERT INTO company VALUES ('EKNS','Ehrenkrantz King Nussbaum');
INSERT INTO company VALUES ('HDSN','Hudson Securities Inc.');
INSERT INTO company VALUES ('JPTC','JP Turner & Co. Inc.');
INSERT INTO company VALUES ('SUNB','SunGard Institutional Brokerage, Inc');
INSERT INTO company VALUES ('ANSR','Anderson & Strudwick, Inc.');
INSERT INTO company VALUES ('VFIN','VFinance Ivestments, Inc');
INSERT INTO company VALUES ('VNDM','Vandham Securities');
INSERT INTO company VALUES ('STCS','First American Capital and Trading');
INSERT INTO company VALUES ('HDSI','Hudson Securities Inc., Institutional DMA');
INSERT INTO company VALUES ('BRGE','(NUBG) Newbridge Securities');
INSERT INTO company VALUES ('ALLN','Allen & Company LLC');
INSERT INTO company VALUES ('FLTL','Feltl & Co.');
INSERT INTO company VALUES ('WMIN','Westminster Securities');
INSERT INTO company VALUES ('BWAL','Broadwall Capital LLC');
INSERT INTO company VALUES ('BSIC','Basic Investor');
INSERT INTO company VALUES ('GARC','ICAP Corporates, LLC');
INSERT INTO company VALUES ('PNTE','Pointe Capital');
INSERT INTO company VALUES ('PONT','Pointe_Capital');
INSERT INTO company VALUES ('JGUN','Joesph Gunnar');
INSERT INTO company VALUES ('GARB','ICAP Corporates, LLC');
INSERT INTO company VALUES ('PAUL','Paulson Investment');
INSERT INTO company VALUES ('WDCO','Wilson Davis Company');
INSERT INTO company VALUES ('ACPL','American Capital');
INSERT INTO company VALUES ('POLW','ICAP Corporates, LLC');
INSERT INTO company VALUES ('LTCO','Ladenburg Thalmann & Co. Inc.');
INSERT INTO company VALUES ('NACI','North American Clearing');
INSERT INTO company VALUES ('DOMS','Domestic Securities');
INSERT INTO company VALUES ('KOSE','Koonce Securities');
INSERT INTO company VALUES ('RMCI','Rushmore Capital Inc.');
INSERT INTO company VALUES ('BPSG','Broadpoint Securities');
INSERT INTO company VALUES ('WSWW','Westminster Securities Corp.');
INSERT INTO company VALUES ('KEYB','Keybanc Capital Markets Inc.');
INSERT INTO company VALUES ('STXG','Stockcross Financial Services');
INSERT INTO company VALUES ('NATL','National Securities, Corp.');
INSERT INTO company VALUES ('BKRT','Buckman, Buckman & Reid, Inc.');
INSERT INTO company VALUES ('LAFC','RF Lafferty & Co.');
INSERT INTO company VALUES ('GNLR','Gunnallen Financial Inc.');
INSERT INTO company VALUES ('ANDZ','Assent LLC');
INSERT INTO company VALUES ('FATS','First Brokers Securities LLC');
INSERT INTO company VALUES ('HDSM','Hudson Securities, Inc. Institutional DMA');