/*Table structure for table `crpNPCTickerNames` */

DROP TABLE IF EXISTS `crpNPCTickerNames`;

CREATE TABLE `crpNPCTickerNames` (
  `corporationID` int(10) unsigned NOT NULL default '0',
  `tickerName` varchar(64) NOT NULL default '',
  `shape1` int(10) unsigned default NULL,
  `shape2` int(10) unsigned default NULL,
  `shape3` int(10) unsigned default NULL,
  `color1` text,
  `color2` text,
  `color3` text,
  PRIMARY KEY  (`corporationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `crpNPCTickerNames` */

insert  into `crpNPCTickerNames`(`corporationID`,`tickerName`,`shape1`,`shape2`,`shape3`,`color1`,`color2`,`color3`) values (1000001,'666',NULL,NULL,NULL,NULL,NULL,NULL),(1000002,'CBDC',NULL,NULL,NULL,NULL,NULL,NULL),(1000003,'PD',NULL,NULL,NULL,NULL,NULL,NULL),(1000004,'Y',NULL,NULL,NULL,NULL,NULL,NULL),(1000005,'HC',NULL,NULL,NULL,NULL,NULL,NULL),(1000006,'DCMI',NULL,NULL,NULL,NULL,NULL,NULL),(1000007,'PMG',NULL,NULL,NULL,NULL,NULL,NULL),(1000008,'M',NULL,NULL,NULL,NULL,NULL,NULL),(1000009,'CP',NULL,NULL,NULL,NULL,NULL,NULL),(1000010,'KC',NULL,NULL,NULL,NULL,NULL,NULL),(1000011,'WC',NULL,NULL,NULL,NULL,NULL,NULL),(1000012,'TD',NULL,NULL,NULL,NULL,NULL,NULL),(1000013,'RA',NULL,NULL,NULL,NULL,NULL,NULL),(1000014,'P',NULL,NULL,NULL,NULL,NULL,NULL),(1000015,'CS',NULL,NULL,NULL,NULL,NULL,NULL),(1000016,'ZA',NULL,NULL,NULL,NULL,NULL,NULL),(1000017,'NC',NULL,NULL,NULL,NULL,NULL,NULL),(1000018,'EE',NULL,NULL,NULL,NULL,NULL,NULL),(1000019,'ISH',NULL,NULL,NULL,NULL,NULL,NULL),(1000020,'LDC',NULL,NULL,NULL,NULL,NULL,NULL),(1000021,'ZGRF',NULL,NULL,NULL,NULL,NULL,NULL),(1000022,'PRO',NULL,NULL,NULL,NULL,NULL,NULL),(1000023,'ED',NULL,NULL,NULL,NULL,NULL,NULL),(1000024,'CBDSD',NULL,NULL,NULL,NULL,NULL,NULL),(1000025,'SC',NULL,NULL,NULL,NULL,NULL,NULL),(1000026,'CC',NULL,NULL,NULL,NULL,NULL,NULL),(1000027,'EH',NULL,NULL,NULL,NULL,NULL,NULL),(1000028,'CFU',NULL,NULL,NULL,NULL,NULL,NULL),(1000029,'SRB',NULL,NULL,NULL,NULL,NULL,NULL),(1000030,'MF',NULL,NULL,NULL,NULL,NULL,NULL),(1000031,'CEP',NULL,NULL,NULL,NULL,NULL,NULL),(1000032,'MC',NULL,NULL,NULL,NULL,NULL,NULL),(1000033,'CBT',NULL,NULL,NULL,NULL,NULL,NULL),(1000034,'HR',NULL,NULL,NULL,NULL,NULL,NULL),(1000035,'CN',NULL,NULL,NULL,NULL,NULL,NULL),(1000036,'IN',NULL,NULL,NULL,NULL,NULL,NULL),(1000037,'LDPS',NULL,NULL,NULL,NULL,NULL,NULL),(1000038,'IW',NULL,NULL,NULL,NULL,NULL,NULL),(1000039,'HG',NULL,NULL,NULL,NULL,NULL,NULL),(1000040,'POU',NULL,NULL,NULL,NULL,NULL,NULL),(1000041,'SP',NULL,NULL,NULL,NULL,NULL,NULL),(1000042,'WPC',NULL,NULL,NULL,NULL,NULL,NULL),(1000043,'CPF',NULL,NULL,NULL,NULL,NULL,NULL),(1000044,'SAK',NULL,NULL,NULL,NULL,NULL,NULL),(1000045,'STI',NULL,NULL,NULL,NULL,NULL,NULL),(1000046,'S',NULL,NULL,NULL,NULL,NULL,NULL),(1000047,'K',NULL,NULL,NULL,NULL,NULL,NULL),(1000048,'V',NULL,NULL,NULL,NULL,NULL,NULL),(1000049,'B',NULL,NULL,NULL,NULL,NULL,NULL),(1000050,'RP',NULL,NULL,NULL,NULL,NULL,NULL),(1000051,'RF',NULL,NULL,NULL,NULL,NULL,NULL),(1000052,'RJD',NULL,NULL,NULL,NULL,NULL,NULL),(1000053,'UM',NULL,NULL,NULL,NULL,NULL,NULL),(1000054,'RSS',NULL,NULL,NULL,NULL,NULL,NULL),(1000055,'MMC',NULL,NULL,NULL,NULL,NULL,NULL),(1000056,'CCI',NULL,NULL,NULL,NULL,NULL,NULL),(1000057,'BC',NULL,NULL,NULL,NULL,NULL,NULL),(1000058,'EC',NULL,NULL,NULL,NULL,NULL,NULL),(1000059,'SKD',NULL,NULL,NULL,NULL,NULL,NULL),(1000060,'NF',NULL,NULL,NULL,NULL,NULL,NULL),(1000061,'FE',NULL,NULL,NULL,NULL,NULL,NULL),(1000062,'TLG',NULL,NULL,NULL,NULL,NULL,NULL),(1000063,'AC',NULL,NULL,NULL,NULL,NULL,NULL),(1000064,'C',NULL,NULL,NULL,NULL,NULL,NULL),(1000065,'IA',NULL,NULL,NULL,NULL,NULL,NULL),(1000066,'VI',NULL,NULL,NULL,NULL,NULL,NULL),(1000067,'ZS',NULL,NULL,NULL,NULL,NULL,NULL),(1000068,'NA',NULL,NULL,NULL,NULL,NULL,NULL),(1000069,'DF',NULL,NULL,NULL,NULL,NULL,NULL),(1000070,'HZOR',NULL,NULL,NULL,NULL,NULL,NULL),(1000071,'II',NULL,NULL,NULL,NULL,NULL,NULL),(1000072,'IS',NULL,NULL,NULL,NULL,NULL,NULL),(1000073,'ACN',NULL,NULL,NULL,NULL,NULL,NULL),(1000074,'JH',NULL,NULL,NULL,NULL,NULL,NULL),(1000075,'N',NULL,NULL,NULL,NULL,NULL,NULL),(1000076,'FU',NULL,NULL,NULL,NULL,NULL,NULL),(1000077,'RIN',NULL,NULL,NULL,NULL,NULL,NULL),(1000078,'IC',NULL,NULL,NULL,NULL,NULL,NULL),(1000079,'ACS',NULL,NULL,NULL,NULL,NULL,NULL),(1000080,'MW',NULL,NULL,NULL,NULL,NULL,NULL),(1000081,'MI',NULL,NULL,NULL,NULL,NULL,NULL),(1000082,'MIO',NULL,NULL,NULL,NULL,NULL,NULL),(1000083,'ATR',NULL,NULL,NULL,NULL,NULL,NULL),(1000084,'AN',NULL,NULL,NULL,NULL,NULL,NULL),(1000085,'CO',NULL,NULL,NULL,NULL,NULL,NULL),(1000086,'EF',NULL,NULL,NULL,NULL,NULL,NULL),(1000087,'KF',NULL,NULL,NULL,NULL,NULL,NULL),(1000088,'SF',NULL,NULL,NULL,NULL,NULL,NULL),(1000089,'KAF',NULL,NULL,NULL,NULL,NULL,NULL),(1000090,'AF',NULL,NULL,NULL,NULL,NULL,NULL),(1000091,'TMF',NULL,NULL,NULL,NULL,NULL,NULL),(1000092,'CI',NULL,NULL,NULL,NULL,NULL,NULL),(1000093,'T',NULL,NULL,NULL,NULL,NULL,NULL),(1000094,'TSS',NULL,NULL,NULL,NULL,NULL,NULL),(1000095,'FF',NULL,NULL,NULL,NULL,NULL,NULL),(1000096,'IZS',NULL,NULL,NULL,NULL,NULL,NULL),(1000097,'MA',NULL,NULL,NULL,NULL,NULL,NULL),(1000098,'AMI',NULL,NULL,NULL,NULL,NULL,NULL),(1000099,'CH',NULL,NULL,NULL,NULL,NULL,NULL),(1000100,'QC',NULL,NULL,NULL,NULL,NULL,NULL),(1000101,'CD',NULL,NULL,NULL,NULL,NULL,NULL),(1000102,'RS',NULL,NULL,NULL,NULL,NULL,NULL),(1000103,'AI',NULL,NULL,NULL,NULL,NULL,NULL),(1000104,'PP',NULL,NULL,NULL,NULL,NULL,NULL),(1000105,'I',NULL,NULL,NULL,NULL,NULL,NULL),(1000106,'EI',NULL,NULL,NULL,NULL,NULL,NULL),(1000107,'TS',NULL,NULL,NULL,NULL,NULL,NULL),(1000108,'CT',NULL,NULL,NULL,NULL,NULL,NULL),(1000109,'DL',NULL,NULL,NULL,NULL,NULL,NULL),(1000110,'FM',NULL,NULL,NULL,NULL,NULL,NULL),(1000111,'A',NULL,NULL,NULL,NULL,NULL,NULL),(1000112,'BL',NULL,NULL,NULL,NULL,NULL,NULL),(1000113,'PI',NULL,NULL,NULL,NULL,NULL,NULL),(1000114,'GIB',NULL,NULL,NULL,NULL,NULL,NULL),(1000115,'UC',NULL,NULL,NULL,NULL,NULL,NULL),(1000116,'PR',NULL,NULL,NULL,NULL,NULL,NULL),(1000117,'SE',NULL,NULL,NULL,NULL,NULL,NULL),(1000118,'SU',NULL,NULL,NULL,NULL,NULL,NULL),(1000119,'FA',NULL,NULL,NULL,NULL,NULL,NULL),(1000120,'FN',NULL,NULL,NULL,NULL,NULL,NULL),(1000121,'FIO',NULL,NULL,NULL,NULL,NULL,NULL),(1000122,'FC',NULL,NULL,NULL,NULL,NULL,NULL),(1000123,'ATF',NULL,NULL,NULL,NULL,NULL,NULL),(1000124,'ARCA',NULL,NULL,NULL,NULL,NULL,NULL),(1000125,'CONCO',NULL,NULL,NULL,NULL,NULL,NULL),(1000126,'ATC',NULL,NULL,NULL,NULL,NULL,NULL),(1000127,'G',NULL,NULL,NULL,NULL,NULL,NULL),(1000128,'MLG',NULL,NULL,NULL,NULL,NULL,NULL),(1000129,'ORE',NULL,NULL,NULL,NULL,NULL,NULL),(1000130,'SEVE',NULL,NULL,NULL,NULL,NULL,NULL),(1000131,'SCT',NULL,NULL,NULL,NULL,NULL,NULL),(1000132,'SCC',NULL,NULL,NULL,NULL,NULL,NULL),(1000133,'SAG',NULL,NULL,NULL,NULL,NULL,NULL),(1000134,'TBR',NULL,NULL,NULL,NULL,NULL,NULL),(1000135,'SPC',NULL,NULL,NULL,NULL,NULL,NULL),(1000136,'GA',NULL,NULL,NULL,NULL,NULL,NULL),(1000137,'DED',NULL,NULL,NULL,NULL,NULL,NULL),(1000138,'DOM',NULL,NULL,NULL,NULL,NULL,NULL),(1000139,'FRL',NULL,NULL,NULL,NULL,NULL,NULL),(1000140,'GNL',NULL,NULL,NULL,NULL,NULL,NULL),(1000141,'GUP',NULL,NULL,NULL,NULL,NULL,NULL),(1000142,'IPR',NULL,NULL,NULL,NULL,NULL,NULL),(1000143,'ICR',NULL,NULL,NULL,NULL,NULL,NULL),(1000144,'IBK',NULL,NULL,NULL,NULL,NULL,NULL),(1000145,'ICM',NULL,NULL,NULL,NULL,NULL,NULL),(1000146,'ISP',NULL,NULL,NULL,NULL,NULL,NULL),(1000147,'ISD',NULL,NULL,NULL,NULL,NULL,NULL),(1000148,'INB',NULL,NULL,NULL,NULL,NULL,NULL),(1000149,'JVN',NULL,NULL,NULL,NULL,NULL,NULL),(1000150,'JDR',NULL,NULL,NULL,NULL,NULL,NULL),(1000151,'KIV',NULL,NULL,NULL,NULL,NULL,NULL),(1000152,'KTP',NULL,NULL,NULL,NULL,NULL,NULL),(1000153,'KWK',NULL,NULL,NULL,NULL,NULL,NULL),(1000154,'NMA',NULL,NULL,NULL,NULL,NULL,NULL),(1000155,'PRP',NULL,NULL,NULL,NULL,NULL,NULL),(1000156,'RKN',NULL,NULL,NULL,NULL,NULL,NULL),(1000157,'SPI',NULL,NULL,NULL,NULL,NULL,NULL),(1000158,'SPS',NULL,NULL,NULL,NULL,NULL,NULL),(1000159,'SAN',NULL,NULL,NULL,NULL,NULL,NULL),(1000160,'TMX',NULL,NULL,NULL,NULL,NULL,NULL),(1000161,'TCR',NULL,NULL,NULL,NULL,NULL,NULL),(1000162,'TPW',NULL,NULL,NULL,NULL,NULL,NULL),(1000163,'TPT',NULL,NULL,NULL,NULL,NULL,NULL),(1000164,'XSN',NULL,NULL,NULL,NULL,NULL,NULL),(1000165,'HU',NULL,NULL,NULL,NULL,NULL,NULL),(1000166,'IAC',NULL,NULL,NULL,NULL,NULL,NULL),(1000167,'SWA',NULL,NULL,NULL,NULL,NULL,NULL),(1000168,'FNA',NULL,NULL,NULL,NULL,NULL,NULL),(1000169,'CAS',NULL,NULL,NULL,NULL,NULL,NULL),(1000170,'RMS',NULL,NULL,NULL,NULL,NULL,NULL),(1000171,'RUN',NULL,NULL,NULL,NULL,NULL,NULL),(1000172,'PTS',NULL,NULL,NULL,NULL,NULL,NULL),(1000173,'POLAR',NULL,NULL,NULL,NULL,NULL,NULL),(1000174,'POLBU',NULL,NULL,NULL,NULL,NULL,NULL),(1000175,'POLEV',511,507,450,NULL,NULL,NULL),(1000176,'PANNS',NULL,NULL,NULL,NULL,NULL,NULL),(1000177,'MAI',NULL,NULL,NULL,NULL,NULL,NULL),(1000178,'AAB',NULL,NULL,NULL,NULL,NULL,NULL);

