User Tools

Site Tools


MySQL Reference Scripts

These are the default scripts that EASA 6.0 currently ships with. They would be of use to a customer who wanted to:

  • Run MySQL on a separate machine to the EASA Server
  • Run MariaDB on a separate machine
  • Migrate to another database vendor such as Oracle

The Table of Contents links on the right allow one to view or download each of the files→


easa_tbl_job.sql

easa_tbl_job.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: easa
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `tbl_job`
--
 
DROP TABLE IF EXISTS `tbl_job`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_job` (
  `JOB_ID` INT(11) NOT NULL AUTO_INCREMENT,
  `PARENT_JOB_ID` INT(11) DEFAULT NULL,
  `PATH` VARCHAR(255) DEFAULT NULL,
  `USERNAME` VARCHAR(45) DEFAULT NULL,
  `MODE` VARCHAR(45) DEFAULT NULL,
  `LDIR` VARCHAR(45) DEFAULT NULL,
  `APPDIR` VARCHAR(255) DEFAULT NULL,
  `JOB_STATUS` VARCHAR(255) DEFAULT NULL,
  `NON_BATCH_SOFTWARE` VARCHAR(45) DEFAULT NULL,
  `DATE_SUBMITTED` datetime DEFAULT NULL,
  `STATE` SMALLINT(6) DEFAULT NULL,
  `SIM_NUM` INT(11) DEFAULT NULL,
  `APP_TITLE` VARCHAR(255) DEFAULT NULL,
  `NOTE` VARCHAR(255) DEFAULT NULL,
  `REMOTE_ID` INT(11) DEFAULT NULL,
  `REMOTE_CS` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`JOB_ID`),
  KEY `FKA5AC7BBC25D6D952` (`PARENT_JOB_ID`),
  CONSTRAINT `FKA5AC7BBC25D6D952` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `tbl_job` (`JOB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `tbl_job`
--
 
LOCK TABLES `tbl_job` WRITE;
/*!40000 ALTER TABLE `tbl_job` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_job` 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 2017-05-18 11:02:14

stockdata_exchange.sql

stockdata_exchange.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: stockdata
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `exchange`
--
 
DROP TABLE IF EXISTS `exchange`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exchange` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `Symbol` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Company` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Industry` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `SPIndex` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Exchange` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Price` DOUBLE DEFAULT NULL,
  `Sector` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Revenue` DOUBLE DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `exchange`
--
 
LOCK TABLES `exchange` WRITE;
/*!40000 ALTER TABLE `exchange` DISABLE KEYS */;
INSERT INTO `exchange` VALUES (1,'GOOG','Google Inc','Internet Information Providers','S&P 500','NASDAQ    ',639.86,'Technology',13431130112),(2,'MITSY','Mitsui & Co Ltd Depository Receipt','Conglomerates','N/A','NASDAQ    ',501.1,'Consumer Services',43304321024),(3,'BIDU','Baidu.com Inc','Internet Information Providers','N/A','NASDAQ    ',324.38,'Technology',158065904),(4,'ISRG','Intuitive Surgical Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',254.25,'Health Care',462876992),(5,'NWLIA','National Western Life Insurance Co','Life Insurance','N/A','NASDAQ    ',246,'Finance',547768000),(6,'FCNCA','First Citizens Bancshares Class A Ord Shs','Regional - Mid-Atlantic Banks','N/A','NASDAQ    ',181.26,'Finance',870745024),(7,'STRA','Strayer Education Inc','Education & Training Services','N/A','NASDAQ    ',177.61,'Consumer Services',290068000),(8,'AAPL','Apple Inc','Personal Computers','S&P 500','NASDAQ    ',169.57,'Technology',22626000896),(9,'WYNN','Wynn Resorts Ltd','Resorts & Casinos','N/A','NASDAQ    ',161,'Consumer Services',2204519936),(10,'ARDNA','Arden Group Inc','Grocery Stores','N/A','NASDAQ    ',159.2,'Consumer Services',485823008),(11,'FWLT','Foster Wheeler Ord Shs','Heavy Construction','N/A','NASDAQ    ',153.84,'Capital Goods',4445787136),(12,'ESGR','Enstar Group Ltd','Property & Casualty Insurance','N/A','NASDAQ    ',146.75,'Finance',93265000),(13,'ANAT','American National Insurance Co','Life Insurance','N/A','NASDAQ    ',145,'Finance',3175904000),(14,'SHLD','Sears Holdings Corp','Department Stores','S&P 500','NASDAQ    ',142.81,'Consumer Services',52169998336),(15,'FSLR','First Solar Inc','Semiconductor - Specialized','N/A','NASDAQ    ',140.65,'N/A',237660992),(16,'LCAPA','Liberty Media Capital Common Series A When Issued Ord Shs','CATV Systems','N/A','NASDAQ    ',128.77,'Consumer Services',1274000000),(17,'LCAPB','Liberty Media Capital Common Series B When Issued Ord Shs','N/A','N/A','NASDAQ    ',128.58,'Consumer Services',0),(18,'DRYS','DryShips Inc','Shipping','N/A','NASDAQ    ',127.97,'N/A',338244992),(19,'CSWC','Capital Southwest Corp','Closed-End Fund - Equity','N/A','NASDAQ    ',125.52,'Finance',6939000),(20,'ATRI','Atrion Corp','Medical Instruments & Supplies','N/A','NASDAQ    ',121.97,'Health Care',86904000),(21,'IDXX','IDEXX Laboratories Inc','Diagnostic Substances','N/A','NASDAQ    ',116.25,'Health Care',827790016),(22,'GRMN','Garmin Ltd','Scientific & Technical Instruments','N/A','NASDAQ    ',115.65,'Technology',2253846016),(23,'DECK','Deckers Outdoor Corp','Textile - Apparel Footwear & Accessories','N/A','NASDAQ    ',114.95,'Consumer Non-Durables',332003008),(24,'RIMM','RESEARCH IN MOTION LIMITED','Diversified Communication Services','N/A','NASDAQ    ',114.9,'Technology',4235034624),(25,'APAGF','Apco Argentina Inc','Independent Oil & Gas','N/A','NASDAQ    ',111.99,'Energy',59314000),(26,'CETV','Central European Media Enterprises Ltd','Broadcasting - TV','N/A','NASDAQ    ',104.69,'Consumer Services',690968000),(27,'ITRI','Itron Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',102.13,'Technology',874148992),(28,'EQIX','Equinix Inc','Telecom Services - Domestic','N/A','NASDAQ    ',99.25,'Consumer Services',330444000),(29,'KTII','K-Tron International Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',99.2,'Capital Goods',173702000),(30,'OYOG','OYO Geospace Corporation','Scientific & Technical Instruments','N/A','NASDAQ    ',96.46,'Technology',136399008),(31,'PCLN','Priceline.Com Ord Shs','Internet Service Providers','N/A','NASDAQ    ',94.49,'Technology',1230807040),(32,'PATR','Patriot Transportation Holdings Inc','Trucking','N/A','NASDAQ    ',94.4,'Transportation',153690000),(33,'MICC','Millicom International Cellular Ord Shs','Diversified Communication Services','N/A','NASDAQ    ',93.88,'N/A',2068318976),(34,'SPWR','SunPower Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',92.99,'Technology',455969984),(35,'AMZN','Amazon.com Inc','Catalog & Mail Order Houses','S&P 500','NASDAQ    ',92.12,'Consumer Services',12193999872),(36,'GLDN','Golden Telecom, Inc','Wireless Communications','N/A','NASDAQ    ',91.99,'Consumer Services',1032916992),(37,'NILE','Blue Nile Inc','Jewelry Stores','N/A','NASDAQ    ',89.77,'Consumer Services',283980000),(38,'MSTR','MicroStrategy Inc','Business Software & Services','N/A','NASDAQ    ',87.38,'Technology',327452992),(39,'HAYN','Haynes International Inc','Steel & Iron','N/A','NASDAQ    ',87.22,'Basic Industries',512971008),(40,'VMSI','Ventana Medical Systems Inc','Medical Instruments & Supplies','N/A','NASDAQ    ',87,'Health Care',261266000),(41,'GFIG','GFI Group Inc','Investment Brokerage - Regional','N/A','NASDAQ    ',86.66,'Finance',842467968),(42,'DHIL','Diamond Hill Investment Group','Investment Brokerage - Regional','N/A','NASDAQ    ',86.36,'Finance',41389000),(43,'CHAP','Chaparral Steel Co','Machine Tools & Accessories','N/A','NASDAQ    ',85.97,'N/A',1722918016),(44,'BIIB','Biogen Idec Inc','Biotechnology','S&P 500','NASDAQ    ',84.75,'Health Care',2900919040),(45,'IVGN','Invitrogen Corp','Biotechnology','N/A','NASDAQ    ',84.23,'Health Care',1271186944),(46,'DNEX','Dionex Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',83.69,'Technology',327284000),(47,'CTSH','Cognizant Technology Solutions Corp','Business Software & Services','N/A','NASDAQ    ',81.66,'Technology',1778736000),(48,'RTRSY','Reuters ADR','Publishing-Periodicals','N/A','NASDAQ    ',81.5,'N/A',5202971136),(49,'LECO','Lincoln Electric Holdings Inc','Small Tools & Accessories','N/A','NASDAQ    ',79.56,'Capital Goods',2136691968),(50,'BUCY','Bucyrus International Inc','Farm & Construction Machinery','N/A','NASDAQ    ',78.93,'Capital Goods',955755008),(51,'ALAB','Alabama National Bancorp','Regional - Southeast Banks','N/A','NASDAQ    ',78.48,'Finance',494552000),(52,'HURN','Huron Consulting Group Inc','Management Services','N/A','NASDAQ    ',78.4,'Finance',435052000),(53,'DWSN','Dawson Geophysical Co','Oil & Gas Equipment & Services','N/A','NASDAQ    ',78.28,'Energy',233716992),(54,'RSTI','Rofin-Sinar Technologies Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',76.92,'Technology',465275008),(55,'KALU','Kaiser Aluminum Corp','Aluminum','N/A','NASDAQ    ',76.91,'Basic Industries',1444800000),(56,'GENZ','Genzyme Corp','Biotechnology','S&P 500','NASDAQ    ',76.9,'Health Care',3479417088),(57,'LEAP','Leap Wireless International Inc','Wireless Communications','N/A','NASDAQ    ',76.85,'Consumer Services',1384788992),(58,'DADE','Dade Behring Holdings Inc','Diagnostic Substances','N/A','NASDAQ    ',76.75,'Health Care',1819000064),(59,'CRDN','Ceradyne Inc','Industrial Equipment & Components','N/A','NASDAQ    ',76.68,'Capital Goods',738326976),(60,'ACGL','Arch Capital Group Ord Shs','Property & Casualty Insurance','N/A','NASDAQ    ',75.5,'Finance',3480194048),(61,'CELG','Celgene Corp','Biotechnology','N/A','NASDAQ    ',74.74,'Health Care',1161115008),(62,'CEPH','Cephalon Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',74.71,'Health Care',1851261056),(63,'SCHN','Schnitzer Steel Industries Inc','Steel & Iron','N/A','NASDAQ    ',74.34,'Basic Industries',2428374016),(64,'EXBD','Corporate Executive Board Co (The)','Management Services','N/A','NASDAQ    ',74.28,'Consumer Services',498113984),(65,'MORN','Morningstar Inc','Asset Management','N/A','NASDAQ    ',73.97,'Finance',373990016),(66,'CHTT','Chattem Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',73.19,'Consumer Non-Durables',387868000),(67,'NIHD','NII Holdings Inc','Wireless Communications','N/A','NASDAQ    ',72.39,'Technology',2785913088),(68,'WPPGY','WPP Group ADR','Advertising Agencies','N/A','NASDAQ    ',72.13,'N/A',12136330240),(69,'CROX','Crocs Inc','Textile - Apparel Footwear & Accessories','N/A','NASDAQ    ',71.95,'Consumer Non-Durables',590524032),(70,'SHPGY','Shire ADR','Drug Manufacturers - Other','N/A','NASDAQ    ',71.79,'Health Care',2049500032),(71,'ALXN','Alexion Pharmaceuticals Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',71.68,'Health Care',16524000),(72,'GPRO','Gen Probe Inc','Research Services','N/A','NASDAQ    ',71.07,'Health Care',385617984),(73,'NTRS','Northern Trust Corp','Regional - Midwest Banks','S&P 500','NASDAQ    ',70.88,'Finance',2489999872),(74,'KYPH','Kyphon Ord Shs','Medical Instruments & Supplies','N/A','NASDAQ    ',70.63,'Health Care',487768000),(75,'GHCI','Genesis HealthCare Corp','N/A','N/A','NASDAQ    ',69.36,'N/A',0),(76,'HOLX','Hologic Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',69.23,'Health Care',689857024),(77,'AMAG','AMAG Pharmaceuticals Inc','Diagnostic Substances','N/A','NASDAQ    ',68.91,'Health Care',2628000),(78,'AMOV','America Movil Class A ADR','N/A','N/A','NASDAQ    ',68.49,'Consumer Services',0),(79,'ZION','Zions Bancorp Ord Shs','Regional - Pacific Banks','S&P 500','NASDAQ    ',68.45,'Finance',3052914944),(80,'COST','Costco Wholesale Corp','Discount, Variety Stores','S&P 500','NASDAQ    ',67.9,'Consumer Services',64400158720),(81,'WSFS','WSFS Financial Corp','Regional - Mid-Atlantic Banks','N/A','NASDAQ    ',67.78,'Finance',186587008),(82,'TECH','Techne Corp','Biotechnology','N/A','NASDAQ    ',67.61,'Health Care',223482000),(83,'VARI','Varian, Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',67.55,'Technology',894560000),(84,'DASTY','Dassault System ADR','Technical & System Software','N/A','NASDAQ    ',67.52,'Technology',1732184064),(85,'CBSS','Compass Bancshares Inc','N/A','N/A','NASDAQ    ',66.83,'N/A',2177379072),(86,'UTHR','United Therapeutics Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',66.63,'Health Care',178223008),(87,'AQNT','aQuantive Inc','N/A','N/A','NASDAQ    ',66.46,'N/A',0),(88,'APOL','Apollo Group Inc','Education & Training Services','S&P 500','NASDAQ    ',66.16,'Consumer Services',2635571968),(89,'MIDD','Middleby Corp','Diversified Machinery','N/A','NASDAQ    ',65.94,'Consumer Durables',420476000),(90,'UHAL','Amerco Ord Shs','Rental & Leasing Services','N/A','NASDAQ    ',65.44,'Consumer Services',2076728064),(91,'WGOV','Woodward Governor Co','Industrial Electrical Equipment','N/A','NASDAQ    ',65.33,'Capital Goods',984483008),(92,'HANS','Hansen Natural Corp','Beverages - Soft Drinks','N/A','NASDAQ    ',65.28,'Consumer Non-Durables',740606976),(93,'MCRS','Micros Systems Inc','Technical & System Software','N/A','NASDAQ    ',65.24,'Technology',785726976),(94,'ALOG','Analogic Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',64.07,'Technology',340782016),(95,'CERN','Cerner Corp','Healthcare Information Services','N/A','NASDAQ    ',63.96,'Technology',1478680960),(96,'GLYT','Genlyte Group Inc','Business Equipment','N/A','NASDAQ    ',63.82,'Capital Goods',1592843008),(97,'COKE','Coca Cola Ord Shs','Beverages - Soft Drinks','N/A','NASDAQ    ',63.79,'Consumer Non-Durables',1439201024),(98,'HSIC','Henry Schein Inc','Medical Equipment Wholesale','N/A','NASDAQ    ',63,'Consumer Services',5468101120),(99,'CPLA','Capella Education Co','Education & Training Services','N/A','NASDAQ    ',62.93,'N/A',201247008),(100,'ASEI','American Science & Engineering Inc','Industrial Equipment & Components','N/A','NASDAQ    ',62.88,'Capital Goods',167775008),(101,'TBSI','TBS International Ltd','Shipping','N/A','NASDAQ    ',62.4,'Transportation',278891008),(102,'VSEC','VSE Corp','Technical Services','N/A','NASDAQ    ',62.09,'Capital Goods',485923008),(103,'ILMN','Illumina Inc','Biotechnology','N/A','NASDAQ    ',61.56,'Health Care',270592000),(104,'ABCO','Advisory Board Co','Research Services','N/A','NASDAQ    ',61.52,'Consumer Services',196742000),(105,'ERTS','Electronic Arts Inc','Multimedia & Graphics Software','S&P 500','NASDAQ    ',61.4,'Technology',3072999936),(106,'PENN','Penn National Gaming Inc','Resorts & Casinos','N/A','NASDAQ    ',61.35,'Consumer Services',2380474112),(107,'DIGE','Digene Corp','N/A','N/A','NASDAQ    ',61.01,'N/A',0),(108,'CSGP','CoStar Group Inc','Internet Information Providers','N/A','NASDAQ    ',60.62,'Consumer Services',175294000),(109,'LUFK','Lufkin Industries Inc','Oil & Gas Equipment & Services','N/A','NASDAQ    ',60.62,'Energy',616998976),(110,'WBMD','WebMD Health Corp','Internet Information Providers','N/A','NASDAQ    ',60.59,'Health Care',298659008),(111,'FLIR','FLIR Systems Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',60.54,'Capital Goods',664769984),(112,'HURC','Hurco Cos Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',60.44,'Capital Goods',181091008),(113,'ASTE','Astec Industries Inc','Farm & Construction Machinery','N/A','NASDAQ    ',60.4,'Basic Industries',775598016),(114,'FMCN','Focus Media Holding Ltd','Advertising Agencies','N/A','NASDAQ    ',60,'Technology',299320000),(115,'LDSH','Ladish Co Inc','Metal Fabrication','N/A','NASDAQ    ',59.54,'Basic Industries',395371008),(116,'ERIE','Erie Indemnity Ord Shs Class A','Property & Casualty Insurance','N/A','NASDAQ    ',59.34,'Finance',1252621952),(117,'AMGN','Amgen Inc','Biotechnology','S&P 500','NASDAQ    ',59.08,'Health Care',14862000128),(118,'NAVG','Navigators Group Inc','Property & Casualty Insurance','N/A','NASDAQ    ',59.03,'Finance',600158016),(119,'BOBJ','Business Objects Depository Receipt','Business Software & Services','N/A','NASDAQ    ',58.99,'Technology',1378577024),(120,'TWIN','Twin Disc Inc','Diversified Machinery','N/A','NASDAQ    ',58.95,'Capital Goods',317200000),(121,'TROW','T Rowe Price Group Inc','Asset Management','S&P 500','NASDAQ    ',58.88,'Finance',2003863040),(122,'WACLY','Wacoal Hldg Depository Receipt','Textile - Apparel Clothing','N/A','NASDAQ    ',58.79,'N/A',1430963968),(123,'ESRX','Express Scripts Inc','Management Services','S&P 500','NASDAQ    ',58.58,'Health Care',17998800896),(124,'ARTC','Arthrocare Corp','Medical Appliances & Equipment','N/A','NASDAQ    ',58.38,'Health Care',287800000),(125,'HUGH','Hughes Communications Inc','Diversified Communication Services','N/A','NASDAQ    ',58,'Consumer Services',910403968),(126,'MLAN','Midland Co','Property & Casualty Insurance','N/A','NASDAQ    ',57.82,'Finance',847852032),(127,'SLGN','Silgan Holdings Inc','Packaging & Containers','N/A','NASDAQ    ',57.56,'Basic Industries',2834808064),(128,'USTR','United Stationers Inc','Wholesale, Other','N/A','NASDAQ    ',57.44,'Consumer Services',4622111744),(129,'CENX','Century Aluminum Co','Aluminum','N/A','NASDAQ    ',57.14,'Basic Industries',1717305984),(130,'CMTL','Comtech Telecommunications Corp','Communication Equipment','N/A','NASDAQ    ',57,'Technology',445684000),(131,'PCAR','Paccar Inc','Trucks & Other Vehicles','S&P 500','NASDAQ    ',56.64,'Capital Goods',16135100416),(132,'ICLR','ICON Plc Depository Receipt','Research Services','N/A','NASDAQ    ',56.48,'Consumer Services',532801984),(133,'STOSY','Santos ADR','Independent Oil & Gas','N/A','NASDAQ    ',56.19,'N/A',2369370112),(134,'VITL','Vital Signs Inc','Medical Instruments & Supplies','N/A','NASDAQ    ',55.96,'Health Care',200646000),(135,'SRCL','Stericycle Inc','Waste Management','N/A','NASDAQ    ',55.88,'Capital Goods',855857984),(136,'AAWW','Atlas Air Worldwide Holdings Inc','Air Services, Other','N/A','NASDAQ    ',55.78,'Transportation',1501752960),(137,'PXSL','Pharmaxis Depository Receipt','Drug Manufacturers - Other','N/A','NASDAQ    ',55.74,'N/A',185230),(138,'MYGN','Myriad Genetics Inc','Diagnostic Substances','N/A','NASDAQ    ',55.71,'Health Care',157126000),(139,'ENSI','Energysouth Inc','Gas Utilities','N/A','NASDAQ    ',55.7,'Energy',131175000),(140,'SINA','SINA Corp','Internet Software & Services','N/A','NASDAQ    ',55.7,'N/A',223552992),(141,'ATPG','ATP Oil & Gas Corporation','Independent Oil & Gas','N/A','NASDAQ    ',55.67,'Energy',544190976),(142,'GMRK','GulfMark Offshore Inc','Oil & Gas Equipment & Services','N/A','NASDAQ    ',55.67,'N/A',284667008),(143,'TONS','Novamerican Steel Inc','Steel & Iron','N/A','NASDAQ    ',55.25,'Basic Industries',795705024),(144,'LAYN','Layne Christensen Co','Heavy Construction','N/A','NASDAQ    ',55.17,'Capital Goods',798364032),(145,'LRCX','Lam Research Corp','Semiconductor Equipment & Materials','N/A','NASDAQ    ',54.97,'Technology',2413652992),(146,'NNDS','NDS GROUP PLC','CATV Systems','N/A','NASDAQ    ',54.7,'Technology',709491968),(147,'ATLS','Atlas America Inc','Oil & Gas Drilling & Exploration','N/A','NASDAQ    ',54.61,'Energy',821817984),(148,'FCBP','First Cmnty Bancp Ord Shs','Regional - Pacific Banks','N/A','NASDAQ    ',54.61,'Finance',347512992),(149,'FISV','Fiserv Inc','Business Software & Services','S&P 500','NASDAQ    ',54.6,'Technology',4652335104),(150,'SIGM','Sigma Designs Inc','Semiconductor - Specialized','N/A','NASDAQ    ',54.58,'Technology',134847008),(151,'LAMR','Lamar Advertising Co','Marketing Services','N/A','NASDAQ    ',54.48,'Consumer Services',1169591040),(152,'REXMY','Rexam Depository Receipt','Packaging & Containers','N/A','NASDAQ    ',54.36,'N/A',6820633088),(153,'HWAY','Healthways Inc','Specialized Health Services','N/A','NASDAQ    ',54.25,'Health Care',560112000),(154,'MAFB','MAF Bancorp Inc','N/A','N/A','NASDAQ    ',54.25,'N/A',586451968),(155,'NDSN','Nordson Corp','Diversified Machinery','N/A','NASDAQ    ',54.23,'Capital Goods',944393024),(156,'CHRW','CH Robinson Worldwide Inc','Air Delivery & Freight Services','N/A','NASDAQ    ',53.99,'Transportation',6855133184),(157,'JOYG','Joy Global Inc','Farm & Construction Machinery','N/A','NASDAQ    ',53.99,'Capital Goods',2500723968),(158,'CHDN','Churchill Downs Inc','Gaming Activities','N/A','NASDAQ    ',53.79,'Consumer Services',376112000),(159,'KLAC','KLA Tencor Corp','Semiconductor Equipment & Materials','S&P 500','NASDAQ    ',53.66,'Technology',2731228928),(160,'CRAI','CRA International Inc','Management Services','N/A','NASDAQ    ',53.4,'Finance',382264000),(161,'ALEX','Alexander & Baldwin Inc','Shipping','N/A','NASDAQ    ',53.28,'Transportation',1639399936),(162,'BOKF','BOK Financial Corp','Regional - Southwest  Banks','N/A','NASDAQ    ',52.97,'Finance',1085665024),(163,'PLMD','PolyMedica Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',52.92,'Health Care',710222976),(164,'VLGEA','Village SuperMkt Ord Shs','Grocery Stores','N/A','NASDAQ    ',52.83,'Consumer Services',1046435008),(165,'SRDX','SurModics, Inc','Diagnostic Substances','N/A','NASDAQ    ',52.45,'Health Care',69437000),(166,'CYTC','Cytyc Corp','Medical Instruments & Supplies','N/A','NASDAQ    ',52.31,'Health Care',675033984),(167,'SYNA','Synaptics Inc','Business Software & Services','N/A','NASDAQ    ',52.1,'Technology',266787008),(168,'PRAA','Portfolio Recovery Associates Inc','Business Services','N/A','NASDAQ    ',52.06,'Finance',205579008),(169,'AIRM','Air Methods Corp','Air Services, Other','N/A','NASDAQ    ',52.04,'Health Care',340188992),(170,'COLM','Columbia Sportswear Co','Textile - Apparel Clothing','N/A','NASDAQ    ',52.01,'Consumer Non-Durables',1324108032),(171,'IBKC','IBERIABANK Corp','Regional - Southeast Banks','N/A','NASDAQ    ',51.98,'Finance',210828000),(172,'INFY','Infosys Technologies Ltd','Technical & System Software','N/A','NASDAQ    ',51.8,'Technology',3633999872),(173,'WFMI','Whole Foods Market Inc','Grocery Stores','S&P 500','NASDAQ    ',51.72,'Consumer Services',6139378176),(174,'COGN','COGNOS INC','Application Software','N/A','NASDAQ    ',51.57,'Technology',1025089344),(175,'PLPC','Preformed Line Products Co','Heavy Construction','N/A','NASDAQ    ',51.55,'Technology',228488000),(176,'ZUMZ','Zumiez Inc','Apparel Stores','N/A','NASDAQ    ',51.55,'Consumer Non-Durables',345400992),(177,'RESP','Respironics Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',51.52,'Health Care',1195035008),(178,'SIAL','Sigma-Aldrich Corp','Specialty Chemicals','S&P 500','NASDAQ    ',51.45,'Basic Industries',1909299968),(179,'EMITF','Elbit Medical Imaging Ltd','Medical Instruments & Supplies','N/A','NASDAQ    ',51.41,'N/A',540944576),(180,'WABC','Westamerica Bancorp','Regional - Pacific Banks','N/A','NASDAQ    ',51.41,'Finance',240884992),(181,'JASO','JA Solar Holdings Co Ltd','Semiconductor - Specialized','N/A','NASDAQ    ',51.34,'N/A',184958096),(182,'ADVS','Advent Software Inc','Application Software','N/A','NASDAQ    ',51.23,'Technology',196432000),(183,'OFIX','Orthofix International NV','Medical Appliances & Equipment','N/A','NASDAQ    ',51.09,'Health Care',439876000),(184,'ADSK','Autodesk Inc','Technical & System Software','S&P 500','NASDAQ    ',51,'Technology',1988700032),(185,'EBIX','Ebix Inc','Business Software & Services','N/A','NASDAQ    ',51,'Technology',35408000),(186,'XNPT','XenoPort Inc','Biotechnology','N/A','NASDAQ    ',50.99,'Health Care',58848000),(187,'VALU','Value Line Inc','Asset Management','N/A','NASDAQ    ',50.79,'Finance',83045000),(188,'CTRP','Ctrip.com','Consumer Services','N/A','NASDAQ    ',50.74,'Consumer Services',127007104),(189,'SIVB','SVB Financial Group','Regional - Pacific Banks','N/A','NASDAQ    ',50.57,'Finance',420800992),(190,'HLND','Hiland Partners LP','Oil & Gas Drilling & Exploration','N/A','NASDAQ    ',50.5,'Energy',241208000),(191,'EXPD','Expeditors International','Air Delivery & Freight Services','N/A','NASDAQ    ',50.22,'Transportation',4849613824),(192,'KCLI','Kansas City Life Insurance Co','Life Insurance','N/A','NASDAQ    ',50.19,'Finance',447531008),(193,'PHRM','Pharmion Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',50.16,'Health Care',250204992),(194,'AVTR','Avatar Holdings Inc','Residential Construction','N/A','NASDAQ    ',50,'Finance',682876032),(195,'CLMT','Calumet Specialty Products Partners LP','Oil & Gas Refining & Marketing','N/A','NASDAQ    ',49.99,'Energy',1586268032),(196,'DRIV','Digital River Inc','Internet Software & Services','N/A','NASDAQ    ',49.96,'Technology',328199008),(197,'BOOM','Dynamic Materials Corp','Industrial Metals & Minerals','N/A','NASDAQ    ',49.9,'Basic Industries',128091000),(198,'RATE','Bankrate Inc','Internet Information Providers','N/A','NASDAQ    ',49.77,'Consumer Services',85703000),(199,'NGPS','NovAtel Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',49.69,'Technology',82281288),(200,'FSCI','Fisher Communications Inc','Broadcasting - TV','N/A','NASDAQ    ',49.43,'Consumer Services',158970000),(201,'SEB','Seaboard Corp','Meat Products','N/A','AMEX      ',1880,'Consumer Non-Durables',2854254080),(202,'NVR','NVR Inc','Residential Construction','N/A','AMEX      ',466.81,'Consumer Durables',5619184128),(203,'WSC','Wesco Financial Corp','Rental & Leasing Services','N/A','AMEX      ',403,'Finance',607865984),(204,'ATF','Equity Income Fund First Exchange','Closed-End Fund - Equity','N/A','AMEX      ',130.39,'N/A',26769000),(205,'USM','United States Cellular Corp','Wireless Communications','N/A','AMEX      ',97.96,'Public Utilities',3696962048),(206,'BIO','Bio Rad Class A Ord Shs','Scientific & Technical Instruments','N/A','AMEX      ',96.68,'Health Care',1309467008),(207,'PRK','Park National Corp','Regional - Midwest Banks','N/A','AMEX      ',90.5,'Finance',364326016),(208,'BTI','Brit Am Tobacco Series A ADR','Cigarettes','N/A','AMEX      ',71.81,'Consumer Non-Durables',19694780416),(209,'TDS','Telephone and Da Ord Shs','Wireless Communications','N/A','AMEX      ',69.15,'Public Utilities',4586144768),(210,'CTO','Consolidated Tomoka Land Co','Real Estate Development','N/A','AMEX      ',68.71,'Finance',40526000),(211,'TDS.S','Telephone and Da Special Ord Shs','N/A','N/A','AMEX      ',66.2,'Consumer Services',0),(212,'PSB','PS Business Parks Series A Ord Shs','REIT - Retail','N/A','AMEX      ',61.8,'Finance',257395008),(213,'LAQ','Latin America Equity Fund Inc','N/A','N/A','AMEX      ',59.8,'N/A',0),(214,'MWP','MarkWest Hydrocarbon Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',59.6,'Energy',697036032),(215,'IMA','Inverness Medical Innovations Inc','Scientific & Technical Instruments','N/A','AMEX      ',58.03,'Health Care',615864000),(216,'AIP','American Israeli Paper Mills Ltd','Paper & Paper Products','N/A','AMEX      ',57.7,'N/A',136204496),(217,'NHC','National HealthCare Corp','Long-Term Care Facilities','N/A','AMEX      ',54.65,'Health Care',581788032),(218,'IMO','IMPERIAL OIL LTD','Oil & Gas Refining & Marketing','N/A','AMEX      ',50.7,'Energy',25198829568),(219,'BKR','Michael Baker Corp','Management Services','N/A','AMEX      ',50.01,'Capital Goods',712510016),(220,'GHM','Graham Corp','Metal Fabrication','N/A','AMEX      ',50,'Capital Goods',71201000),(221,'FTK','Flotek Industries Inc','Specialty Chemicals','N/A','AMEX      ',49.25,'Capital Goods',135348992),(222,'BTJ','Bolt Technology Corp','Oil & Gas Equipment & Services','N/A','AMEX      ',47.75,'Capital Goods',50464000),(223,'CUB','Cubic Corp','Scientific & Technical Instruments','N/A','AMEX      ',46.46,'Capital Goods',871476992),(224,'MCF','Contango Oil & Gas Co','Independent Oil & Gas','N/A','AMEX      ',44.44,'Energy',18688000),(225,'CEP','Constellation Energy Partners LLC','Oil & Gas Drilling & Exploration','N/A','AMEX      ',42.5,'N/A',40408000),(226,'LNG','Cheniere Energy Inc','Oil & Gas Drilling & Exploration','N/A','AMEX      ',40.2,'Energy',1152000),(227,'TMP','Tompkins Financial Corp','Regional - Northeast Banks','N/A','AMEX      ',39.98,'Finance',127365000),(228,'TSH','Teche Holdings Company','Savings & Loans','N/A','AMEX      ',39.61,'Finance',42234000),(229,'SA','Seabridge Gold Inc','Gold','N/A','AMEX      ',38.73,'Basic Industries',0),(230,'GRC','Gorman-Rupp Co','Diversified Machinery','N/A','AMEX      ',38.3,'Capital Goods',290025984),(231,'BMI','Badger Meter Inc','Scientific & Technical Instruments','N/A','AMEX      ',36.48,'Technology',227748992),(232,'PLX','Protalix BioTherapeutics Inc','Biotechnology','N/A','AMEX      ',36.01,'Consumer Services',0),(233,'DIT','Amcon Distributing Co','Food Wholesale','N/A','AMEX      ',36,'Consumer Services',849180992),(234,'CAC','Camden National Corp','Regional - Northeast Banks','N/A','AMEX      ',34.6,'Finance',109313000),(235,'SAL','Salisbury Bancorp Inc','Savings & Loans','N/A','AMEX      ',32.8,'N/A',25277000),(236,'BHB','Bar Harbor Bankshares','Regional - Northeast Banks','N/A','AMEX      ',32.28,'Finance',49093000),(237,'AE','Adams Resources & Energy Inc','Basic Materials Wholesale','N/A','AMEX      ',31.15,'Energy',2219688960),(238,'ESC','Emeritus Corp','Long-Term Care Facilities','N/A','AMEX      ',30.8,'Health Care',438278016),(239,'MAM','Maine & Maritimes Corp','Electric Utilities','N/A','AMEX      ',30.73,'Public Utilities',37002000),(240,'JST','Jinpan International Ltd','Diversified Electronics','N/A','AMEX      ',30.32,'Capital Goods',87509752),(241,'MLP','Maui Land & Pineapple Co','Processed & Packaged Goods','N/A','AMEX      ',30.04,'Consumer Non-Durables',186036992),(242,'FRS','Frisch\'s Restaurants Inc','Restaurants','N/A','AMEX      ',30,'N/A',289934016),(243,'IOC','Interoil Ord Shs','Oil & Gas Refining & Marketing','N/A','AMEX      ',30,'Energy',552553920),(244,'GGN','Gabelli Global Gold Natural Resources & Income Trust','N/A','N/A','AMEX      ',29.65,'N/A',0),(245,'TA','TravelCenters of America LLC','Auto Parts Stores','N/A','AMEX      ',29.59,'N/A',4983744000),(246,'UTL','Unitil Corp','Diversified Utilities','N/A','AMEX      ',28.85,'Public Utilities',266732000),(247,'CET','Central Securities Corp (United States)','Closed-End Fund - Equity','N/A','AMEX      ',28.81,'N/A',11466000),(248,'GTU','Central Gold Trust','Closed-End Fund - Equity','N/A','AMEX      ',28.65,'N/A',4249000),(249,'RIV','Riviera Holdings Corp','Resorts & Casinos','N/A','AMEX      ',28.02,'Consumer Services',202510000),(250,'ETF','Emerging Markets Telecommunications Fund Inc (The)','N/A','N/A','AMEX      ',27.9,'N/A',0),(251,'ERH','Evergreen Utilities and High Income Fund','N/A','N/A','AMEX      ',27.75,'N/A',0),(252,'AFP','United Capital Corp','Industrial Equipment & Components','N/A','AMEX      ',26.5,'Finance',50844000),(253,'FEN','Energy Income and Growth Fund','Closed-End Fund - Equity','N/A','AMEX      ',26.42,'N/A',0),(254,'UTG','Reaves Utility Income Fund','Closed-End Fund - Equity','N/A','AMEX      ',26.1,'N/A',0),(255,'GEL','Genesis Energy LP','Oil & Gas Pipelines','N/A','AMEX      ',25.65,'N/A',806003968),(256,'STF','Merrill Lynch 9% Strides Linked to Caterpillar 24-09-2009','N/A','N/A','AMEX      ',25.6,'N/A',0),(257,'PHX','Panhandle Oil and Gas Inc','Independent Oil & Gas','N/A','AMEX      ',25.3,'Energy',37199000),(258,'CML','Compellent Technologies Inc','N/A','N/A','AMEX      ',24.87,'N/A',0),(259,'CVF','Castle Convertible Fund','Closed-End Fund - Debt','N/A','AMEX      ',24.85,'N/A',2163000),(260,'RAP','RMR Asia Pacific Real Estate Fund','Closed-End Fund - Equity','N/A','AMEX      ',24.77,'N/A',0),(261,'GOK','Geokinetics Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',24.62,'Energy',324907008),(262,'LXU','LSB Industries Ord Shs','General Building Materials','N/A','AMEX      ',24.48,'Basic Industries',551844992),(263,'APO','American Community Properties Trust','Real Estate Development','N/A','AMEX      ',24.4,'Finance',94885000),(264,'CVR','Chicago Rivet & Machine Co','Auto Manufacturers - Major','N/A','AMEX      ',24.25,'N/A',38449000),(265,'NDD','Neuberger Berman Dividend Advantage Fund Inc','N/A','N/A','AMEX      ',23.89,'N/A',0),(266,'NHR','National Health Realty  Inc','REIT - Healthcare Facilities','N/A','AMEX      ',23.8,'Finance',20090000),(267,'SRQ','DWS RREEF Real Estate Fund','Closed-End Fund - Debt','N/A','AMEX      ',23.74,'N/A',0),(268,'MBR','Mercantile Bp Ord Shs','Regional - Midwest Banks','N/A','AMEX      ',23.65,'Finance',87560000),(269,'SLI','SL Industries Inc','Diversified Electronics','N/A','AMEX      ',23.49,'Technology',195431008),(270,'IIG','Imergent Inc','Internet Software & Services','N/A','AMEX      ',23.44,'Consumer Services',151616992),(271,'JRS','Nuveen Real Estate Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',23.25,'N/A',0),(272,'MSL','Midsouth Bancorp Inc','Regional - Southeast Banks','N/A','AMEX      ',23.25,'Finance',54255000),(273,'ISL','First Israel Fund','N/A','N/A','AMEX      ',23.14,'N/A',0),(274,'ESP','Espey Manufacturing & Electronics Corp','Diversified Electronics','N/A','AMEX      ',23,'Capital Goods',27656000),(275,'UUU','Universal Security Instruments Inc','Electronics Wholesale','N/A','AMEX      ',22.81,'Consumer Services',40741000),(276,'GLU','Gabelli Global Utility & Income Trust','N/A','N/A','AMEX      ',22.7,'N/A',0),(277,'SHM','MS    13.250 03/20/07 MTN MATd','N/A','N/A','AMEX      ',22.49,'N/A',0),(278,'CH','Chile Fund Inc','Closed-End Fund - Foreign','N/A','AMEX      ',22.3,'N/A',4520000),(279,'BCV','Bancroft Fund Ltd','Closed-End Fund - Debt','N/A','AMEX      ',21.74,'N/A',5910000),(280,'ADY','American Dairy Inc','Dairy Products','N/A','AMEX      ',21.5,'N/A',148316992),(281,'SIL','Apex Silver Mines Ltd','Silver','N/A','AMEX      ',21.22,'Basic Industries',24660000),(282,'UNB','Union Bankshares Inc','Regional - Northeast Banks','N/A','AMEX      ',21.15,'Finance',25890000),(283,'GLV','Clough Global Allocation Fund','N/A','N/A','AMEX      ',21.13,'N/A',0),(284,'RVR','White River Capital Inc','Credit Services','N/A','AMEX      ',21,'N/A',58497000),(285,'WLB','Westmoreland Ord Shs','Industrial Metals & Minerals','N/A','AMEX      ',21,'Energy',509564000),(286,'CCF','Chase Corp (United States)','Industrial Equipment & Components','N/A','AMEX      ',20.75,'Basic Industries',124529000),(287,'EML','Eastern Co','Small Tools & Accessories','N/A','AMEX      ',20.6,'Basic Industries',167428000),(288,'GLQ','Clough Global Equity Fund','N/A','N/A','AMEX      ',20.41,'N/A',0),(289,'HTC','Hungarian Telephone and Cable Corp','Diversified Communication Services','N/A','AMEX      ',19.9,'Public Utilities',243026000),(290,'SIF','Sifco Industries','Aerospace/Defense Products & Services','N/A','AMEX      ',19.68,'Basic Industries',85017000),(291,'CQP','Cheniere Energy Partners L P','Oil & Gas Pipelines','N/A','AMEX      ',19.23,'Public Utilities',0),(292,'NG','NOVAGOLD RESOURCES INC','Gold','N/A','AMEX      ',19.1,'Basic Industries',7873106),(293,'BHV','Blackrock Virginia Municipal Bond Trust','N/A','N/A','AMEX      ',19.07,'N/A',0),(294,'DRY','Coinmach Service Units','N/A','N/A','AMEX      ',19,'Consumer Services',0),(295,'NGS','Natural Gas Services Group Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',19,'Energy',68029000),(296,'RHR','RMR Hospitality and Real Estate Fund','N/A','N/A','AMEX      ',19,'N/A',0),(297,'RFR','RMR F.I.R.E. Fund','N/A','N/A','AMEX      ',18.73,'N/A',0),(298,'OTT','Otelco Inc','Diversified Communication Services','N/A','AMEX      ',18.7,'N/A',68806000),(299,'SGB','Southwest Georgia Financial Corp','Regional - Mid-Atlantic Banks','N/A','AMEX      ',18.65,'Finance',16283000),(300,'IAF','Aberdeen Australia Equity Fund Inc','N/A','N/A','AMEX      ',18.64,'N/A',0),(301,'BHO','B&H Ocean Carriers Ltd','Shipping','N/A','AMEX      ',18.5,'N/A',106360000),(302,'BQY','BlackRock S&P Quality Rankings Global Equity Managed Trust','N/A','N/A','AMEX      ',18.43,'N/A',0),(303,'AQQ','American Spectrum Realty Inc','REIT - Retail','N/A','AMEX      ',18,'Finance',29408000),(304,'SRO','DWS RREEF Real Estate Fund II','Closed-End Fund - Debt','N/A','AMEX      ',17.87,'N/A',0),(305,'GLO','Clough Global Opportunities Fund','N/A','N/A','AMEX      ',17.84,'N/A',0),(306,'BLJ','Blackrock New Jersey Municipal Bond Trust','N/A','N/A','AMEX      ',17.8,'N/A',0),(307,'FSP','Franklin Street Properties Corp','REIT - Diversified','N/A','AMEX      ',17.75,'Finance',128962000),(308,'RCH','China Architectural Engineering Inc','General Contractors','N/A','AMEX      ',17.6,'N/A',70773000),(309,'FRH.U','Freedom Acquisition Units','Diversified Investments','N/A','AMEX      ',17.35,'N/A',0),(310,'DLA','Delta Apparel Inc','Textile - Apparel Clothing','N/A','AMEX      ',17.04,'Consumer Non-Durables',312438016),(311,'ACY','Aerocentury Corp','Rental & Leasing Services','N/A','AMEX      ',16.99,'Finance',18028000),(312,'JPK','Morgan Stanley Performance Leveraged Upside Redeemable for C','N/A','N/A','AMEX      ',16.77,'N/A',0),(313,'PMD','Psychemedics Corp','Medical Laboratories & Research','N/A','AMEX      ',16.7,'Health Care',24391000),(314,'DXR','Daxor Corp','Medical Instruments & Supplies','N/A','AMEX      ',16.59,'Consumer Non-Durables',1807000),(315,'UUY','Merrill Lynch Pref Shs Select Utilities Index','N/A','N/A','AMEX      ',16.52,'N/A',0),(316,'EVV','Eaton Vance Limited Duration Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',16.5,'N/A',211076000),(317,'ERC','Evergreen Multi Sector Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',16.28,'N/A',0),(318,'FCM','First Trust/Four Corners Senior Floating Rate Income Fund','N/A','N/A','AMEX      ',16.25,'N/A',0),(319,'NRO','Neuberger Berman Real Estate Securities Income Fund Inc','Closed-End Fund - Debt','N/A','AMEX      ',16.24,'N/A',0),(320,'NMZ','Nuveen Municipal High Income Opportunity Fund','N/A','N/A','AMEX      ',16.19,'N/A',0),(321,'CPD','Caraco Pharmaceutical Laboratories Ltd','Drugs - Generic','N/A','AMEX      ',16.15,'Consumer Non-Durables',127676000),(322,'MEH','Midwest Air Group Inc','Regional Airlines','N/A','AMEX      ',16.15,'Transportation',697177984),(323,'BWL.A','Bowl America Ord Shs','Sporting Activities','N/A','AMEX      ',16.05,'N/A',31975000),(324,'CVP','Centerplate Units','Diversified Investments','N/A','AMEX      ',16.05,'N/A',703088000),(325,'BZM','Blackrock Maryland Municipal Bond Trust','N/A','N/A','AMEX      ',16.04,'N/A',0),(326,'UTK','UTEK Corp','Business Services','N/A','AMEX      ',16,'Technology',36423000),(327,'HEM','HemoSense Inc','Medical Instruments & Supplies','N/A','AMEX      ',15.92,'Health Care',28131000),(328,'BLE','BlackRock Municipal Income Trust II','Closed-End Fund - Debt','N/A','AMEX      ',15.69,'N/A',0),(329,'RZ','Raser Technologies Inc','Industrial Electrical Equipment','N/A','AMEX      ',15.6,'N/A',208000),(330,'CRF','Cornerstone Total Return Fund Inc','N/A','N/A','AMEX      ',15.55,'N/A',0),(331,'FRN','Friendly Ice Cream Corp','N/A','N/A','AMEX      ',15.51,'N/A',528727008),(332,'NXZ','Nuveen Dividend Advantage Municipal Fund 2','Closed-End Fund - Debt','N/A','AMEX      ',15.45,'N/A',0),(333,'VCF','Delaware Investments Colorado Insured Municipal Income Fund','N/A','N/A','AMEX      ',15.4,'N/A',0),(334,'BRN','Barnwell Industries Inc','Independent Oil & Gas','N/A','AMEX      ',15.35,'Energy',45989000),(335,'SVT','Servotronics Inc','Industrial Electrical Equipment','N/A','AMEX      ',15.3,'Capital Goods',27287000),(336,'EIM','Eaton Vance Insured Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',15.28,'N/A',0),(337,'BPS','Blackrock Pennsylvania Strategic Municipal Trust Fund','N/A','N/A','AMEX      ',15.25,'N/A',0),(338,'BCL','BlackRock California Municipal Income Trust II','N/A','N/A','AMEX      ',15.21,'N/A',0),(339,'SEA','Star Maritime Acquisition Corp','Diversified Investments','N/A','AMEX      ',15.21,'N/A',0),(340,'VMV','Van Kampen Massachusetts Value Municipal','N/A','N/A','AMEX      ',15.2,'N/A',0),(341,'BCT','Blackrock Broad Investment Grade 2009 TM Trust','N/A','N/A','AMEX      ',15.1,'N/A',0),(342,'AZS','Arizona Star Resource Corp','Gold','N/A','AMEX      ',15.03,'Basic Industries',0),(343,'TF','Thai Capital Fund Inc','N/A','N/A','AMEX      ',15,'N/A',0),(344,'HWK','Hawk Corp','Aerospace/Defense Products & Services','N/A','AMEX      ',14.95,'Capital Goods',222844000),(345,'RMR','RMR Real Estate Fund','N/A','N/A','AMEX      ',14.92,'N/A',0),(346,'EIV','Eaton Vance Insured Municipal Bond Fund II','N/A','N/A','AMEX      ',14.9,'N/A',0),(347,'ACU','Acme United Corp','Office Supplies','N/A','AMEX      ',14.85,'Health Care',58862000),(348,'MAB','Eaton Vance Insured Massachusets Municipal Bond Fund','N/A','N/A','AMEX      ',14.85,'N/A',0),(349,'EMJ','Eaton Vance Insured New Jersey Municipal Bond Fund','N/A','N/A','AMEX      ',14.82,'N/A',0),(350,'BFY','BlackRock New York Municipal Income Trust II','N/A','N/A','AMEX      ',14.74,'N/A',0),(351,'EVM','Eaton Vance Insured California Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.7,'N/A',0),(352,'MHJ','Man Sang Holdings Inc','Wholesale, Other','N/A','AMEX      ',14.68,'Consumer Services',51716140),(353,'MVG','MAG Silver Corp','Silver','N/A','AMEX      ',14.65,'Basic Industries',0),(354,'RDR','RMR Preferred Dividend Fund','N/A','N/A','AMEX      ',14.65,'N/A',0),(355,'ENX','Eaton Vance Insured New York Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.6,'N/A',0),(356,'NUJ','Nuveen New Jersey Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.53,'N/A',0),(357,'EVY','Eaton Vance New York Municipal Income Trust Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.52,'N/A',8166000),(358,'NEA','Nuveen Insured Tax Free Advantage Municipal Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.51,'N/A',0),(359,'NFC','Nuveen Connecticut Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.51,'N/A',0),(360,'NXK','Nuveen NY Div Advantage Muni Fund Closed Fund','N/A','N/A','AMEX      ',14.49,'N/A',0),(361,'NNB','Nuveen Virginia Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.47,'N/A',0),(362,'NKR','Nuveen Arizona Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.35,'N/A',0),(363,'NMB','Nuveen Mass Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.35,'N/A',0),(364,'NOX','Neuberger Berman Income Opportunity Fund Inc','N/A','N/A','AMEX      ',14.32,'N/A',0),(365,'NYH','Eaton Vance Insured New York Municipal Bond Fund II','N/A','N/A','AMEX      ',14.28,'N/A',0),(366,'MMV','Eaton Vance Massachusetts Municipal Income Trust Fund','N/A','N/A','AMEX      ',14.27,'N/A',0),(367,'MCX','MC Shipping Inc','N/A','N/A','AMEX      ',14.25,'N/A',64268000),(368,'NKX','Nuveen Insured California Tax Free Advantage Municipal Fund','N/A','N/A','AMEX      ',14.23,'N/A',0),(369,'EIA','Eaton Vance Insured California Municipal Bond Fund II','N/A','N/A','AMEX      ',14.21,'N/A',0),(370,'NGB','Nuveen Virginia Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.13,'N/A',0),(371,'NGX','Nuveen Insured Massachusetts Tax Free Advantage Municipal Fu','N/A','N/A','AMEX      ',14.1,'N/A',0),(372,'NVJ','Nuveen Ohio Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',14.1,'N/A',0),(373,'NKL','Nuveen Insured California Dividend Advantage Municipal Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.07,'N/A',0),(374,'NZF','Nuveen Dividend Advantage Municipal Fund 3','Closed-End Fund - Debt','N/A','AMEX      ',14.02,'N/A',0),(375,'CEV','Eaton Vance California Municipal Income Trust Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.01,'N/A',0),(376,'NKG','Nuveen Georgia Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14,'N/A',0),(377,'NOM','Nuveen Missouri Premium Income Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(378,'NRK','Nuveen Insured New York Tax Free Advantage Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(379,'NZW','Nuveen Michigan Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(380,'IF','Indonesia Fund Inc','N/A','N/A','AMEX      ',13.97,'N/A',0),(381,'MIW','Eaton Vance Insured Michigan Municipal Bond Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(382,'NKO','Nuveen Insured New York Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(383,'NVG','Nuveen Insured Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(384,'NZR','Nuveen Maryland Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.93,'N/A',0),(385,'NFM','Nuveen Maryland Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.89,'N/A',0),(386,'MYH','MS     9.000 12/20/07 \'07 MTN','N/A','N/A','AMEX      ',13.82,'N/A',0),(387,'NII','Nuveen North Carolina Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',13.81,'N/A',0),(388,'SCB','Community Bankshares Inc (South Carolina)','Regional - Mid-Atlantic Banks','N/A','AMEX      ',13.81,'N/A',38522000),(389,'EVJ','Eaton Vance New Jersey Municipal Income Trust Fund','N/A','N/A','AMEX      ',13.79,'N/A',0),(390,'NVY','Nuveen Pennsylvania Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.77,'N/A',0),(391,'NXI','Nuveen Ohio Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.75,'N/A',0),(392,'NBJ','Nuveen Ohio Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.74,'N/A',0),(393,'NXJ','Nuveen New Jersey Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.68,'N/A',0),(394,'EIO','Eaton Vance Insured Ohio Municipal Bond Fund','N/A','N/A','AMEX      ',13.66,'N/A',0),(395,'NXE','Nuveen Arizona Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',13.65,'N/A',0),(396,'NVX','Nuveen California Dividend Advantage Muni Fund 2','N/A','N/A','AMEX      ',13.64,'N/A',0),(397,'VMM','Delaware Investments Minnesota Municipal Income Fund II','N/A','N/A','AMEX      ',13.6,'N/A',0),(398,'EIF','Eaton Vance Insured Florida Municipal Bond Fund','N/A','N/A','AMEX      ',13.59,'N/A',0),(399,'JAX','J Alexander\'s Corp','Restaurants','N/A','AMEX      ',13.54,'Consumer Services',140346000),(400,'MZA','BlackRock MuniYield Arizona Fund Inc','N/A','N/A','AMEX      ',13.52,'N/A',0),(401,'BRK.A','Berkshire Hatha Class A Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',127500,'N/A',111856001024),(402,'BRK.B','Berkshire Hatha Class B Ord Shs','N/A','N/A','NYSE      ',4257,'N/A',0),(403,'WPO','Washington Post Co','Publishing-Newspapers','N/A','NYSE      ',808.85,'Consumer Services',4019986944),(404,'CME','CME Group Inc','Business Services','N/A','NYSE      ',629.55,'Finance',1217361024),(405,'WTM','White Mountains Insurance Group Ltd','Property & Casualty Insurance','N/A','NYSE      ',561.95,'Finance',4912200192),(406,'MKL','Markel Corp','Property & Casualty Insurance','N/A','NYSE      ',521.63,'Finance',2563440896),(407,'ALX','Alexander\'s Inc','Property Management','N/A','NYSE      ',413.83,'Finance',207362000),(408,'Y','Alleghany Corp','Property & Casualty Insurance','N/A','NYSE      ',410.54,'Finance',1336125952),(409,'RTP','Rio Tinto ADR','Steel & Iron','N/A','NYSE      ',375.79,'Basic Industries',23899000832),(410,'AW-D','Allied Waste Ind Conv Pref','N/A','N/A','NYSE      ',340.15,'N/A',0),(411,'SGP-B','SGP    6.000 08/13/10 CVT','N/A','N/A','NYSE      ',283.22,'N/A',0),(412,'PTR','Petrochina Depository Receipt','Major Integrated Oil & Gas','N/A','NYSE      ',242.15,'N/A',100520296448),(413,'FFH','Fairfax Finl Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',236.3,'Finance',6381948416),(414,'GS','Goldman Sachs Ord Shs','Investment Brokerage - National','S&P 500','NYSE      ',234.31,'Finance',84560003072),(415,'SQM','Sociedad Quimica y Minera de Chile Rep 10 B Ord Shs ADR','Synthetics','N/A','NYSE      ',202.9,'Basic Industries',1096953984),(416,'CEO','CNOOC ADR representing 100 Class H Shares','Independent Oil & Gas','N/A','NYSE      ',192.34,'N/A',11025370112),(417,'PKX','Posco Depository Receipt','Steel & Iron','N/A','NYSE      ',186.83,'N/A',28143020032),(418,'STU','Student Loan Corp','Credit Services','N/A','NYSE      ',186,'Finance',1596326016),(419,'BLK','Blackrock Inc','Investment Brokerage - Regional','N/A','NYSE      ',183.62,'Finance',3443980032),(420,'SQA.A','Sequa Class A Ord Shs','Aerospace/Defense - Major Diversified','N/A','NYSE      ',170.59,'N/A',2180626944),(421,'FCX-M','FCX    6.750 05/01/10 CVT','N/A','N/A','NYSE      ',169.92,'N/A',0),(422,'SNP','China Petroleum and Chemical (Sinopec) ADR Repstng 100 H Ord','Independent Oil & Gas','N/A','NYSE      ',168.22,'N/A',152426496000),(423,'FLR','Fluor Corp','Heavy Construction','S&P 500','NYSE      ',164.51,'Capital Goods',14860539904),(424,'MA','MasterCard Inc','Business Services','N/A','NYSE      ',163.65,'Finance',3653193984),(425,'ICE','IntercontinentalExchange Inc','Business Services','N/A','NYSE      ',162.26,'Finance',453188000),(426,'IPS','IPSCO INC','N/A','N/A','NYSE      ',159.97,'N/A',0),(427,'DE','Deere & Co','Farm & Construction Machinery','S&P 500','NYSE      ',155.44,'Capital Goods',23058800640),(428,'VNO-A','VNO    6.500 Perp     CVT','N/A','N/A','NYSE      ',154.3,'N/A',0),(429,'ACL','Alcon Inc','Drug Manufacturers - Major','N/A','NYSE      ',149.48,'N/A',5222900224),(430,'PCP','Precision Castparts Corp','Metal Fabrication','N/A','NYSE      ',145.28,'Basic Industries',5908899840),(431,'HCH','Merrill Lynch Canada Canadian Pacific HOLDRs','N/A','N/A','NYSE      ',145,'N/A',0),(432,'UBB','Unibanco Depository Receipt','Foreign Money Center Banks','N/A','NYSE      ',143.32,'N/A',9105775616),(433,'CLB','Core Laboratories NV','Oil & Gas Equipment & Services','N/A','NYSE      ',142.28,'N/A',622452992),(434,'BEN','Franklin Resources Inc','Asset Management','S&P 500','NYSE      ',141.47,'Finance',5873861120),(435,'CMI','Cummins Inc','Diversified Machinery','S&P 500','NYSE      ',140.81,'Capital Goods',12001999872),(436,'MLM','Martin Marietta Materials Inc','General Building Materials','N/A','NYSE      ',140.56,'Basic Industries',2190659072),(437,'LVS','Las Vegas Sands Corp','Resorts & Casinos','N/A','NYSE      ',140.53,'Consumer Services',2430631936),(438,'PCU','Southern Copper Corp','Copper','N/A','NYSE      ',139.68,'Basic Industries',6246980096),(439,'SHG','Shinhan Financial Each Rep 2 Ord Krw5000 ADR','Foreign Regional Banks','N/A','NYSE      ',137.88,'Finance',9684332544),(440,'SI','Sielspon ADR','Telecom Services - Foreign','N/A','NYSE      ',137.18,'Capital Goods',118747496448),(441,'AMG','Affiliated Managers Group Inc','Asset Management','N/A','NYSE      ',136.51,'Finance',1250504960),(442,'WBK','Westpac Banking Depository Receipt','Foreign Money Center Banks','N/A','NYSE      ',135,'N/A',17911900160),(443,'TNH','Terra Nitrogen Co LP','Agricultural Chemicals','N/A','NYSE      ',133.47,'N/A',516086016),(444,'DB','DEUTSCHE BANK','Money Center Banks','N/A','NYSE      ',130.91,'N/A',87451107328),(445,'IEP','Icahn Enterprises Units','Property Management','N/A','NYSE      ',130.9,'N/A',1177981952),(446,'NMX','NYMEX Holdings Inc','Diversified Investments','N/A','NYSE      ',130.89,'N/A',590886976),(447,'CRS','Carpenter Technology Corp','Steel & Iron','N/A','NYSE      ',130.77,'Basic Industries',1944800000),(448,'ESI','ITT Educational Services Inc','Education & Training Services','N/A','NYSE      ',129,'Consumer Services',817032000),(449,'ANZ','Australia and New Zealand Banking ADR Reptg Five Ord Shs','Money Center Banks','N/A','NYSE      ',128.44,'N/A',21723060224),(450,'AZO','AutoZone Inc','Auto Parts Stores','S&P 500','NYSE      ',124.68,'Consumer Durables',6169803776),(451,'ESS','Essex Property Ord Shs','REIT - Residential','N/A','NYSE      ',124.38,'Finance',365756000),(452,'BSC','Bear Stearns Ord Shs','Investment Brokerage - National','S&P 500','NYSE      ',123.16,'Finance',18586949632),(453,'CMG','Chipotle Mexican Grill Ord Shs','Restaurants','N/A','NYSE      ',122.43,'Consumer Services',941420032),(454,'GNI','Great Northern Iron Ore Properties','Steel & Iron','N/A','NYSE      ',122.25,'Basic Industries',18334000),(455,'DO','Diamond Offshore Drilling Inc','Oil & Gas Drilling & Exploration','N/A','NYSE      ',121.38,'Energy',2349712896),(456,'AVB','AvalonBay Comm Ord Shs','REIT - Residential','N/A','NYSE      ',121.12,'Finance',778568000),(457,'SLG','SL Green Rlty Ord Shs','REIT - Retail','N/A','NYSE      ',121.09,'Finance',861526976),(458,'UNP','Union Pacific Corp','Railroads','S&P 500','NYSE      ',119.82,'Transportation',15840000000),(459,'HDB','HDFC Bank Ltd','Foreign Regional Banks','N/A','NYSE      ',118.68,'N/A',1937944960),(460,'FCX','Freeport McMoRan Copper & Gold Ord Shs','Copper','S&P 500','NYSE      ',118.65,'Basic Industries',11388080128),(461,'IBM','IBM Ord Shs','Diversified Computer Systems','S&P 500','NYSE      ',118.37,'Technology',94674001920),(462,'RIG','Transocean Inc','Oil & Gas Drilling & Exploration','S&P 500','NYSE      ',117.5,'Energy',4973700096),(463,'ENR','Energizer Holdings Inc','Industrial Electrical Equipment','N/A','NYSE      ',116.78,'Consumer Non-Durables',3320199936),(464,'NVO','Novo-Nordisk A/S Depository Receipt','Drug Manufacturers - Other','N/A','NYSE      ',116.78,'Health Care',7694033920),(465,'ETR','Entergy Corp Ord Shs','Electric Utilities','S&P 500','NYSE      ',115.88,'Public Utilities',11199039488),(466,'IX','Orix Corp Depository Receipt','Credit Services','N/A','NYSE      ',114.99,'Finance',9838458880),(467,'SLB','SCHLUMBERGER','Oil & Gas Equipment & Services','S&P 500','NYSE      ',114.84,'Energy',21746589696),(468,'POT','POTASH CORPORATION OF SASKATCHEWAN INC','Nonmetallic Mineral Mining','N/A','NYSE      ',114.41,'Basic Industries',4484199936),(469,'VNO','Vornado Realty Trust Ord Shs','REIT - Retail','S&P 500','NYSE      ',113.99,'Finance',2932239104),(470,'WCG','WellCare Health Plans Inc','Health Care Plans','N/A','NYSE      ',113.73,'Health Care',4758921216),(471,'RE','Everest Re Group Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',113.31,'Finance',4757935104),(472,'ATK','Alliant Techsys Ord Shs','Aerospace/Defense Products & Services','N/A','NYSE      ',112.43,'Capital Goods',3700893952),(473,'LMT','Lockheed Martin Corp','Aerospace/Defense Products & Services','S&P 500','NYSE      ',112.11,'Capital Goods',40370999296),(474,'NC','NACCO Industries Class A Ord Shs','Farm & Construction Machinery','N/A','NYSE      ',111.89,'Capital Goods',3416499968),(475,'X','United States Steel Corp','Metal Fabrication','S&P 500','NYSE      ',111.47,'Basic Industries',15864000512),(476,'CMG.B','Chipotle Mexican Grill Class B Ord Shs','N/A','N/A','NYSE      ',110.5,'N/A',0),(477,'TM','Toyota Motor ADR','Auto Manufacturers - Major','N/A','NYSE      ',110.05,'Consumer Durables',211476398080),(478,'HAN','Hanson ADR','N/A','N/A','NYSE      ',109.65,'N/A',0),(479,'WBD','Wimm-Bill-Dann OAO','Dairy Products','N/A','NYSE      ',109.64,'Consumer Non-Durables',2096292992),(480,'YZC','Yanzhou Coal Mining Level III ADR','Industrial Metals & Minerals','N/A','NYSE      ',109.6,'N/A',1804199040),(481,'BXP','Boston Properties Inc','REIT - Office','S&P 500','NYSE      ',109.57,'Finance',1510947968),(482,'TKG','Telkom ADR','Diversified Communication Services','N/A','NYSE      ',108.5,'N/A',7646410240),(483,'FDX','Fedex Corp','Air Delivery & Freight Services','S&P 500','NYSE      ',107.54,'Transportation',35868000256),(484,'DAI','Daimler AG','Auto Manufacturers - Major','N/A','NYSE      ',107,'N/A',174389198848),(485,'CEA','China East Air Depository Receipt','Major Airlines','N/A','NYSE      ',106.5,'N/A',5267924992),(486,'MTD','Mettler-Toledo International Inc','Scientific & Technical Instruments','N/A','NYSE      ',106.2,'Capital Goods',1677902976),(487,'CM','Canadian Imperial Bank Ord Shs','Money Center Banks','N/A','NYSE      ',106.11,'Finance',15652484096),(488,'LLL','L-3 Communications Holdings Inc','Security & Protection Services','S&P 500','NYSE      ',106,'Technology',13196900352),(489,'CAM','Cameron International Corp','Oil & Gas Equipment & Services','N/A','NYSE      ',105.51,'Energy',4191574016),(490,'VMW','VMware Inc','Business Software & Services','N/A','NYSE      ',105.5,'N/A',973920000),(491,'CLF','Cleveland Cliffs Ord Shs','Steel & Iron','N/A','NYSE      ',104.8,'Basic Industries',2002200064),(492,'SPG','Simon Property Ord Shs','REIT - Retail','S&P 500','NYSE      ',104.75,'Finance',3453839872),(493,'ARE','Alexandria RE Eq Ord Shs','REIT - Industrial','N/A','NYSE      ',104.73,'Finance',371892000),(494,'CHK-D','Chesapeake Enrgy 4.5 Conv Pref','N/A','N/A','NYSE      ',104.25,'N/A',0),(495,'BG','Bunge Ord Shs','Farm Products','N/A','NYSE      ',103.9,'Basic Industries',32752001024),(496,'AMN','Ameron International Corp','General Building Materials','N/A','NYSE      ',103.45,'Capital Goods',592769024),(497,'MTB','M&T Bank Corp','Regional - Northeast Banks','S&P 500','NYSE      ',102.5,'Finance',3503312896),(498,'PRU','Prudential Finl Ord Shs','Life Insurance','S&P 500','NYSE      ',101.11,'Finance',34524999680),(499,'SU','SUNCOR ENERGY INC','Independent Oil & Gas','N/A','NYSE      ',101.1,'Energy',16635029504),(500,'AL','ALCAN INC','Aluminum','N/A','NYSE      ',100.61,'Basic Industries',25013000192),(501,'BHI','Baker Hughes Inc','Oil & Gas Equipment & Services','S&P 500','NYSE      ',99.46,'Energy',9772399616),(502,'ATI','Allegheny Technologies Inc','Industrial Metals & Minerals','S&P 500','NYSE      ',99.31,'Basic Industries',5529200128),(503,'JLL','Jones Lang LaSalle Inc','Property Management','N/A','NYSE      ',98.85,'Finance',2332830976),(504,'LFC','China Life Insurance ADR Rep 15 H Ord','Life Insurance','N/A','NYSE      ',98.64,'N/A',23437600768),(505,'HBC','HSBC ADR','Foreign Money Center Banks','N/A','NYSE      ',98.44,'N/A',75878998016),(506,'APD','Air Products and Chemicals Inc','Chemicals - Major Diversified','S&P 500','NYSE      ',98.15,'Basic Industries',9860200448),(507,'HIG','Hartford Financial Services Group Inc','Property & Casualty Insurance','S&P 500','NYSE      ',97.98,'Finance',29404999680),(508,'DEG','Delhaize Group ADR','Grocery Stores','N/A','NYSE      ',97.75,'N/A',27188369408),(509,'MGM','MGM Mirage','Resorts & Casinos','N/A','NYSE      ',97.25,'Consumer Services',7506931200),(510,'WNG','Washington Group International Inc','Technical Services','N/A','NYSE      ',97.15,'Capital Goods',3468935936),(511,'VMI','Valmont Industries Inc','Metal Fabrication','N/A','NYSE      ',97.09,'Capital Goods',1381804032),(512,'APA','Apache Corp Ord Shs','Independent Oil & Gas','S&P 500','NYSE      ',97.05,'Energy',8693167104),(513,'BA','Boeing Ord Shs','Aerospace/Defense - Major Diversified','S&P 500','NYSE      ',96.5,'Capital Goods',64673001472),(514,'GWW','WW Grainger Inc','Electronics Wholesale','S&P 500','NYSE      ',96,'Capital Goods',6129326080),(515,'DNB','Dun & Bradstreet Corp','Information & Delivery Services','N/A','NYSE      ',95.3,'Consumer Services',1585799936),(516,'ETN','Eaton Corp','Industrial Electrical Equipment','S&P 500','NYSE      ',95.28,'Consumer Durables',12577999872),(517,'SPW','SPX Corp','Appliances','N/A','NYSE      ',95.2,'Consumer Durables',4671600128),(518,'XOM','Exxon Mobil Ord Shs','Major Integrated Oil & Gas','S&P 500','NYSE      ',95.15,'Energy',375193993216),(519,'MMM','3M Co','Conglomerates','S&P 500','NYSE      ',94.73,'Consumer Services',23719000064),(520,'CKH','SEACOR Holdings Inc','Shipping','N/A','NYSE      ',94.69,'Energy',1322760960),(521,'MGA','Magna International Subordinate Voting Ord Shs Class A','Auto Parts','N/A','NYSE      ',94.61,'Consumer Durables',24945999872),(522,'BWA','BorgWarner Inc','Auto Parts','N/A','NYSE      ',94.17,'Consumer Durables',4903600128),(523,'MON','Monsanto Co','Agricultural Chemicals','S&P 500','NYSE      ',94.13,'Basic Industries',8562999808),(524,'VMC','Vulcan Materials Co','General Building Materials','S&P 500','NYSE      ',94.04,'Basic Industries',3311656960),(525,'CHA','China Telecom ADR','Telecom Services - Foreign','N/A','NYSE      ',93.71,'N/A',23531579392),(526,'ITY','Imperial Tobacco Depository Receipt','Tobacco Products, Other','N/A','NYSE      ',93.56,'N/A',23758270464),(527,'CVX','Chevron Ord Shs','Major Integrated Oil & Gas','S&P 500','NYSE      ',92.94,'Energy',206279000064),(528,'TEF','Telefonica ADR rep 3 ord shs','Telecom Services - Foreign','N/A','NYSE      ',92.45,'N/A',78743412736),(529,'CHL','China Mobile ADR','Wireless Communications','N/A','NYSE      ',91.99,'N/A',43255771136),(530,'FRT','Federal Realty Investment Trust Ord Shs','REIT - Retail','N/A','NYSE      ',91.94,'Finance',478244992),(531,'PEG','Public Srvce Ent Ord Shs','Diversified Utilities','S&P 500','NYSE      ',91.44,'Public Utilities',12574000128),(532,'MHS','Medco Health Solutions Inc','Drug Stores','S&P 500','NYSE      ',91.4,'Health Care',43600498688),(533,'CEG','Constellation Energy Group Ord Shs','Electric Utilities','S&P 500','NYSE      ',91.07,'Public Utilities',19922599936),(534,'MAC','Macerich Ord Shs','REIT - Retail','N/A','NYSE      ',91.03,'Finance',863329024),(535,'AB','AllianceBernstein Holding LP','Asset Management','N/A','NYSE      ',90.95,'Finance',4324517888),(536,'GD','General Dynamics Corp','Aerospace/Defense Products & Services','S&P 500','NYSE      ',90.95,'Capital Goods',25474000896),(537,'DEO','Diageo ADR Reptg 4 Ord Shs','Beverages - Wineries & Distillers','N/A','NYSE      ',90.64,'N/A',15222299648),(538,'KYO','Kyocera Corp Depository Receipt','Diversified Electronics','N/A','NYSE      ',90.03,'Technology',11127539712),(539,'DVN','Devon Energy Ord Shs','Independent Oil & Gas','S&P 500','NYSE      ',89.85,'Energy',11130000384),(540,'WHR','Whirlpool Corp','Appliances','S&P 500','NYSE      ',89.81,'Consumer Durables',19040000000),(541,'ED-A','Consolidated Edison 4.65% Series C Cumulative Pref Shs','N/A','N/A','NYSE      ',89.4,'N/A',0),(542,'VE','Vivendi Environ Depository Receipt','Foreign Utilities','N/A','NYSE      ',89.25,'N/A',42634059776),(543,'STN','Station Casinos Inc','Resorts & Casinos','N/A','NYSE      ',89.13,'Consumer Services',1440097024),(544,'XEL-C','Xcel Energy 4.10% Cumulative Pref Shs','N/A','N/A','NYSE      ',89,'N/A',0),(545,'TEX','Terex Corp','Farm & Construction Machinery','N/A','NYSE      ',88.4,'Capital Goods',8288099840),(546,'D','Dominion Resources Inc','Electric Utilities','S&P 500','NYSE      ',88.21,'Public Utilities',16359999488),(547,'HET','Harrah\'s Entertainment Inc','Resorts & Casinos','S&P 500','NYSE      ',88.05,'Consumer Services',10300499968),(548,'AH','Armor Holdings Inc','N/A','N/A','NYSE      ',88,'N/A',0),(549,'EXH','Exterran Holdings Inc','Oil & Gas Equipment & Services','N/A','NYSE      ',87.7,'N/A',1728715008),(550,'BCR','C.R. Bard Inc','Medical Instruments & Supplies','S&P 500','NYSE      ',87.12,'Health Care',2093699968),(551,'HAR','Harman International Industries Inc','Electronic Equipment','S&P 500','NYSE      ',87,'Consumer Services',3551143936),(552,'JEC','Jacobs Engineering Group Inc','Technical Services','N/A','NYSE      ',86.97,'Capital Goods',8173192192),(553,'COP','ConocoPhillips','Major Integrated Oil & Gas','S&P 500','NYSE      ',86.86,'Energy',184383995904),(554,'LM','Legg Mason Inc','Investment Brokerage - Regional','S&P 500','NYSE      ',86.74,'Finance',4511422976),(555,'PBR','Petroleo Brasileiro ADR Reptg 2 Ord Shs','Oil & Gas Drilling & Exploration','N/A','NYSE      ',86.63,'Energy',77790003200),(556,'PE-C','PECO Energy 4.40 Cumulative Pref Shs Series 1','N/A','N/A','NYSE      ',86.5,'N/A',0),(557,'PE-D','PECO Energy 4.68 Cumulative Pref Shs Series 4','N/A','N/A','NYSE      ',86.5,'N/A',0),(558,'TDK','TDK ADR','Diversified Electronics','N/A','NYSE      ',86.29,'Technology',7367119872),(559,'DST','DST Systems Inc','Information & Delivery Services','N/A','NYSE      ',86.12,'Technology',2241600000),(560,'AGE','AG Edwards Inc','N/A','N/A','NYSE      ',85.97,'N/A',3311390976),(561,'BHP','BHP Billiton ADR','Industrial Metals & Minerals','N/A','NYSE      ',85.92,'N/A',39497998336),(562,'SHI','Shanghai Pechem Depository Receipt','Synthetics','N/A','NYSE      ',85.51,'N/A',7089785856),(563,'AXE','Anixter International Inc','Electronics Wholesale','N/A','NYSE      ',85.37,'Technology',5468499968),(564,'CG','Carolina Group Ord Shs','Cigarettes','N/A','NYSE      ',84.83,'Consumer Non-Durables',4016100096),(565,'RDS.A','Royal Dutch Shell ADR Each Repstg Two Class A Ord Shs','Oil & Gas Refining & Marketing','N/A','NYSE      ',84.72,'N/A',318129995776),(566,'RDS.B','Royal Dutch Shel ADR Rep 2 Class B Ord Shs','N/A','N/A','NYSE      ',84.6,'N/A',0),(567,'PX','Praxair Inc','Synthetics','S&P 500','NYSE      ',84.58,'Basic Industries',8728999936),(568,'FO','Fortune Brands Ord Shs','Home Furnishings & Fixtures','S&P 500','NYSE      ',84.46,'Consumer Non-Durables',8798699520),(569,'KB','Kookmin Bank ADR Representing One Ord Shs','Foreign Regional Banks','N/A','NYSE      ',84.3,'Finance',12420310016),(570,'BDX','Becton Dickinson & Co','Medical Instruments & Supplies','S&P 500','NYSE      ',84,'Health Care',6171223040),(571,'BNI','Burlington Northern Santa Fe Corp','Railroads','S&P 500','NYSE      ',84,'Transportation',15308999680),(572,'NYX','NYSE Euronext','Diversified Investments','N/A','NYSE      ',83.82,'Finance',3041441024),(573,'CMS-B','Consumers Energy Series B Pref Shs','N/A','N/A','NYSE      ',83.5,'N/A',0),(574,'OII','Oceaneering International Inc','Oil & Gas Equipment & Services','N/A','NYSE      ',83.5,'Energy',1455671040),(575,'KMT','Kennametal Inc','Machine Tools & Accessories','N/A','NYSE      ',83.48,'Basic Industries',2385492992),(576,'EOG','EOG Resources Inc','Independent Oil & Gas','S&P 500','NYSE      ',83.28,'Energy',3831247104),(577,'ATW','Atwood Oceanics Inc','Oil & Gas Drilling & Exploration','N/A','NYSE      ',83.12,'Energy',363249984),(578,'ZMH','Zimmer Holdings Inc','Medical Appliances & Equipment','S&P 500','NYSE      ',83.12,'Health Care',3674200064),(579,'DHR','Danaher Corp','Conglomerates','S&P 500','NYSE      ',83.11,'Capital Goods',10330229760),(580,'PSA','Public Storage Ord Shs','REIT - Industrial','S&P 500','NYSE      ',83.03,'Finance',1688791040),(581,'SPG-I','Simon Property 6.00% Convertible I Pref Shs','N/A','N/A','NYSE      ',83,'N/A',0),(582,'ANF','Abercrombie & Fitch Co','Apparel Stores','N/A','NYSE      ',82.81,'Consumer Services',3549138944),(583,'MHK','Mohawk Industries Inc','Textile Manufacturing','N/A','NYSE      ',82.53,'Consumer Durables',7763685888),(584,'XEL-E','Xcel Energy Series E Pref Shs','N/A','N/A','NYSE      ',82.5,'N/A',0),(585,'NOV','National Oilwell Varco Inc','Oil & Gas Equipment & Services','S&P 500','NYSE      ',82,'Energy',8407199744),(586,'TGI','Triumph Group Ord Shs','Aerospace/Defense Products & Services','N/A','NYSE      ',81.75,'Capital Goods',1006916992),(587,'UTX','UNITED TECHNOLOGIE','Conglomerates','S&P 500','NYSE      ',81.17,'Capital Goods',51131998208),(588,'TOT','Total Conv Into 1/2 Shs ADR','Major Integrated Oil & Gas','N/A','NYSE      ',81.08,'Energy',182247292928),(589,'BDK','Black & Decker Corp','Small Tools & Accessories','S&P 500','NYSE      ',81.05,'Consumer Durables',6498599936),(590,'ACH','Aluminum Corporation of China ADR Rep 25 Class H Ord Shs','Aluminum','N/A','NYSE      ',81,'N/A',8239104000),(591,'PPL-B','PPL Electric Utilities 4.5% Pref Shs','N/A','N/A','NYSE      ',81,'N/A',0),(592,'PRE','PartnerRe Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',80.93,'Finance',4190654976),(593,'UIC','United Industrial Corp','Aerospace/Defense Products & Services','N/A','NYSE      ',80.75,'Capital Goods',641953024),(594,'RTI','RTI International Metals, Inc (Holding Co)','Industrial Metals & Minerals','N/A','NYSE      ',80.61,'Basic Industries',572246016),(595,'FLS','Flowserve Corp','Diversified Machinery','N/A','NYSE      ',80.48,'Capital Goods',3388423936),(596,'CAT','Caterpillar Ord Shs','Farm & Construction Machinery','S&P 500','NYSE      ',80.1,'Capital Goods',42892001280),(597,'NGG','National Grid ADR','Gas Utilities','N/A','NYSE      ',80.05,'N/A',17861429248),(598,'XL','XL Capital Class A Ord Shs','Property & Casualty Insurance','S&P 500','NYSE      ',80,'Finance',9940746240),(599,'PPG','PPG Industries Inc','Conglomerates','S&P 500','NYSE      ',79.95,'Basic Industries',11665000448),(600,'NOC','Northrop Corp Ord Shs','Aerospace/Defense Products & Services','S&P 500','NYSE      ',79.88,'Capital Goods',30727000064);
/*!40000 ALTER TABLE `exchange` 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 2017-05-18 11:02:14

exceltesting_cases.sql

exceltesting_cases.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: exceltesting
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `cases`
--
 
DROP TABLE IF EXISTS `cases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cases` (
  `id` BIGINT(20) NOT NULL,
  `created` datetime DEFAULT NULL,
  `created_by` VARCHAR(255) DEFAULT NULL,
  `pricing_id` VARCHAR(255) DEFAULT NULL,
  `data_file_image` longblob,
  `last_modified` datetime DEFAULT NULL,
  `last_modified_by` VARCHAR(255) DEFAULT NULL,
  `status` VARCHAR(255) DEFAULT NULL,
  `excel_file_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3CEF323277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FK3CEF323277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

exceltesting_data.sql

exceltesting_data.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: exceltesting
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `data`
--
 
DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `type` INT(11) DEFAULT NULL,
  `value` longtext,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `named_range_fk` VARCHAR(255) NOT NULL,
  `case_fk` BIGINT(20) NOT NULL,
  PRIMARY KEY (`case_fk`,`excel_file_fk`,`named_range_fk`),
  KEY `FK1FE7AA6F969779` (`case_fk`),
  KEY `FK1FE7AA7DAE806` (`excel_file_fk`,`named_range_fk`),
  CONSTRAINT `FK1FE7AA6F969779` FOREIGN KEY (`case_fk`) REFERENCES `cases` (`id`),
  CONSTRAINT `FK1FE7AA7DAE806` FOREIGN KEY (`excel_file_fk`, `named_range_fk`) REFERENCES `named_range` (`excel_file_fk`, `name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

exceltesting_easaps.sql

exceltesting_easaps.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: exceltesting
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `easaps`
--
 
DROP TABLE IF EXISTS `easaps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `easaps` (
  `id` BIGINT(20) NOT NULL,
  `easap_name` VARCHAR(255) DEFAULT NULL,
  `easap_uniqueId` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `easap_name` (`easap_name`),
  UNIQUE KEY `easap_uniqueId` (`easap_uniqueId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

exceltesting_excel_file.sql

exceltesting_excel_file.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: exceltesting
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `excel_file`
--
 
DROP TABLE IF EXISTS `excel_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `excel_file` (
  `id` BIGINT(20) NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `save_type` VARCHAR(255) DEFAULT NULL,
  `easap_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKC85A522452EA222F` (`easap_fk`),
  CONSTRAINT `FKC85A522452EA222F` FOREIGN KEY (`easap_fk`) REFERENCES `easaps` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

exceltesting_named_range.sql

exceltesting_named_range.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: exceltesting
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `named_range`
--
 
DROP TABLE IF EXISTS `named_range`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `named_range` (
  `name` VARCHAR(255) NOT NULL,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `value` longtext,
  PRIMARY KEY (`excel_file_fk`,`name`),
  KEY `FKB0810C77277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FKB0810C77277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

excel_cases.sql

excel_cases.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: excel
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `cases`
--
 
DROP TABLE IF EXISTS `cases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cases` (
  `id` BIGINT(20) NOT NULL,
  `created` datetime DEFAULT NULL,
  `created_by` VARCHAR(255) DEFAULT NULL,
  `pricing_id` VARCHAR(255) DEFAULT NULL,
  `data_file_image` longblob,
  `last_modified` datetime DEFAULT NULL,
  `last_modified_by` VARCHAR(255) DEFAULT NULL,
  `status` VARCHAR(255) DEFAULT NULL,
  `excel_file_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3CEF323277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FK3CEF323277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

excel_data.sql

excel_data.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: excel
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `data`
--
 
DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `type` INT(11) DEFAULT NULL,
  `value` longtext,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `named_range_fk` VARCHAR(255) NOT NULL,
  `case_fk` BIGINT(20) NOT NULL,
  PRIMARY KEY (`case_fk`,`excel_file_fk`,`named_range_fk`),
  KEY `FK1FE7AA6F969779` (`case_fk`),
  KEY `FK1FE7AA7DAE806` (`excel_file_fk`,`named_range_fk`),
  CONSTRAINT `FK1FE7AA6F969779` FOREIGN KEY (`case_fk`) REFERENCES `cases` (`id`),
  CONSTRAINT `FK1FE7AA7DAE806` FOREIGN KEY (`excel_file_fk`, `named_range_fk`) REFERENCES `named_range` (`excel_file_fk`, `name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

excel_easaps.sql

excel_easaps.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: excel
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `easaps`
--
 
DROP TABLE IF EXISTS `easaps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `easaps` (
  `id` BIGINT(20) NOT NULL,
  `easap_name` VARCHAR(255) DEFAULT NULL,
  `easap_uniqueId` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `easap_name` (`easap_name`),
  UNIQUE KEY `easap_uniqueId` (`easap_uniqueId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

excel_excel_file.sql

excel_excel_file.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: excel
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `excel_file`
--
 
DROP TABLE IF EXISTS `excel_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `excel_file` (
  `id` BIGINT(20) NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `save_type` VARCHAR(255) DEFAULT NULL,
  `easap_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKC85A522452EA222F` (`easap_fk`),
  CONSTRAINT `FKC85A522452EA222F` FOREIGN KEY (`easap_fk`) REFERENCES `easaps` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

excel_named_range.sql

excel_named_range.sql
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: excel
-- ------------------------------------------------------
-- Server version	5.7.17
 
/*!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 `named_range`
--
 
DROP TABLE IF EXISTS `named_range`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `named_range` (
  `name` VARCHAR(255) NOT NULL,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `value` longtext,
  PRIMARY KEY (`excel_file_fk`,`name`),
  KEY `FKB0810C77277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FKB0810C77277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2017-05-18 11:03:46

Page Tools