-- MySQL dump 10.13  Distrib 5.1.49, for Win32 (ia32)
--
-- Host: localhost    Database: sungard
-- ------------------------------------------------------
-- Server version	5.1.49-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company` (
  `mpid` char(4) NOT NULL DEFAULT '',
  `name` char(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company`
--

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

--
-- Table structure for table `company_bkp`
--

DROP TABLE IF EXISTS `company_bkp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_bkp` (
  `mpid` char(4) NOT NULL DEFAULT '',
  `name` char(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_bkp`
--

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

--
-- Table structure for table `company_old`
--

DROP TABLE IF EXISTS `company_old`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_old` (
  `mpid` varchar(4) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`mpid`),
  UNIQUE KEY `mpid` (`mpid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_old`
--

LOCK TABLES `company_old` WRITE;
/*!40000 ALTER TABLE `company_old` DISABLE KEYS */;
INSERT INTO `company_old` VALUES ('EFGI','Empire Financial Group, Inc.'),('FACT','First Albany'),('BWNC','STC Securities Corporation'),('SIBI','SunGard Institutional Brokerage, Inc.'),('JIMK','Sunstate Equity Trading'),('WEDB','Wedbush Morgan Securities'),('DEMO','Demo Trading, Inc.'),('SNDS','Sands Brothers & Co., LTD'),('RAGN','Wells Fargo Investments, LLC'),('TDCO','Thomson Davis & Co.'),('SOAR','Sterling Financial Investment Group'),('EKNS','Ehrenkrantz King Nussbaum'),('HDSN','Hudson Securities Inc.'),('JPTC','JP Turner & Co. Inc.'),('SUNB','SunGard Institutional Brokerage, Inc'),('ANSR','Anderson & Strudwick, Inc.'),('VFIN','VFinance Ivestments, Inc'),('VNDM','Vandham Securities'),('STCS','First American Capital and Trading'),('HDSI','Hudson Securities'),('BRGE','(NUBG) Newbridge Securities'),('ALLN','Allen & Company LLC'),('FLTL','Feltl & Co.'),('WMIN','Westminster Securities'),('BWAL','Broadwall Capital LLC'),('BSIC','Basic Investor'),('GARC','ICAP North America INC.'),('PNTE','Pointe Capital'),('PONT','Pointe_Capital'),('JGUN','Joesph Gunnar'),('GARB','ICAP North America. INC.'),('PAUL','Paulson Investment'),('WDCO','Wilson Davis Company'),('ACPL','American Capital'),('POLW','ICAP Corporates, LLC'),('LTCO','Ladenburg Thalmann & Co. Inc.'),('NACI','North American Clearing'),('DOMS','Domestic Securities'),('KOSE','Koonce Securities'),('RMCI','Rushmore Capital Inc.'),('BPSG','Broadpoint Securities'),('WSWW','Westminster Securities Corp.'),('KEYB','Keybanc Capital Markets Inc.'),('STXG','Stockcross Financial Services'),('NATL','National Securities, Corp.');
/*!40000 ALTER TABLE `company_old` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-09-03 14:20:42