-- MySQL dump 10.13 Distrib 5.1.35, for sun-solaris2.10 (sparc) -- -- Host: localhost Database: aNumberDB -- ------------------------------------------------------ -- Server version 5.1.35-enterprise-commercial-pro-log /*!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 */; -- -- Current Database: `aNumberDB` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `aNumberDB` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_cs */; USE `aNumberDB`; -- -- Table structure for table `ANI` -- DROP TABLE IF EXISTS `ANI`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ANI` ( `aniIndex` smallint(6) NOT NULL, `ani` varchar(10) COLLATE latin1_general_cs NOT NULL, `vns` tinyint(3) unsigned NOT NULL DEFAULT '0', `natlBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `intlBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `operBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `allBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `block8XX` tinyint(3) unsigned NOT NULL DEFAULT '0', `cosIndex` smallint(6) NOT NULL DEFAULT '0', `pacFeatureIndex` smallint(6) NOT NULL DEFAULT '0', `pacCodeIndex` int(11) NOT NULL DEFAULT '0', `treatment` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`aniIndex`,`ani`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ANI` -- LOCK TABLES `ANI` WRITE; /*!40000 ALTER TABLE `ANI` DISABLE KEYS */; INSERT INTO `ANI` VALUES (1,'4808021234',0,0,0,0,0,0,480,0,0,76),(1,'6022770123',0,0,0,0,0,0,0,1,0,0),(1,'6072220001',0,0,0,0,0,0,0,0,0,0),(1,'6072220011',0,1,0,0,0,0,0,0,0,0),(1,'6072220021',0,0,1,0,0,0,0,0,0,123),(1,'6072220031',0,0,0,1,0,0,0,0,0,123),(1,'6072220041',0,0,0,0,1,0,0,0,0,0),(1,'6072220051',0,0,0,0,0,1,0,0,0,0),(1,'6072300001',0,0,0,0,0,0,0,101,0,0),(1,'6072300002',0,0,0,0,0,0,0,102,0,0),(1,'6072300003',0,0,0,0,0,0,0,103,0,0),(1,'6072300004',0,0,0,0,0,0,0,104,0,0),(1,'6072300005',0,0,0,0,0,0,0,105,0,0),(1,'6072300006',0,0,0,0,0,0,0,106,0,0),(1,'6072300007',0,0,0,0,0,0,0,107,0,0),(1,'6072300008',0,0,0,0,0,0,0,108,0,0),(1,'6072300009',0,0,0,0,0,0,0,109,0,0),(1,'6072300010',0,0,0,0,0,0,0,110,0,0),(1,'6072300011',0,0,0,0,0,0,0,111,0,0),(1,'6072300012',0,0,0,0,0,0,0,112,0,0),(1,'6072310001',0,1,0,0,0,0,0,1,0,123),(1,'6072310002',0,1,0,0,0,0,0,2,0,123),(1,'6072310003',0,1,0,0,0,0,0,3,0,0),(1,'6072310004',0,1,0,0,0,0,0,4,0,0),(1,'6072310005',0,1,0,0,0,0,0,5,0,0),(1,'6072310006',0,1,0,0,0,0,0,6,0,0),(1,'6072310007',0,1,0,0,0,0,0,7,0,0),(1,'6072310008',0,1,0,0,0,0,0,8,0,0),(1,'6072310009',0,1,0,0,0,0,0,9,0,0),(1,'6072310010',0,1,0,0,0,0,0,10,0,0),(1,'6072310011',0,1,0,0,0,0,0,11,0,0),(1,'6072310012',0,1,0,0,0,0,0,12,0,0),(1,'6072320001',0,0,1,0,0,0,0,1,0,123),(1,'6072320002',0,0,1,0,0,0,0,2,0,123),(1,'6072320003',0,0,1,0,0,0,0,3,0,0),(1,'6072320004',0,0,1,0,0,0,0,4,0,0),(1,'6072320005',0,0,1,0,0,0,0,5,0,0),(1,'6072320006',0,0,1,0,0,0,0,6,0,0),(1,'6072320007',0,0,1,0,0,0,0,7,0,0),(1,'6072320008',0,0,1,0,0,0,0,8,0,0),(1,'6072320009',0,0,1,0,0,0,0,9,0,0),(1,'6072320010',0,0,1,0,0,0,0,10,0,0),(1,'6072320011',0,0,1,0,0,0,0,11,0,0),(1,'6072320012',0,0,1,0,0,0,0,12,0,0),(1,'6072330001',0,0,0,1,0,0,0,1,0,123),(1,'6072330002',0,0,0,1,0,0,0,2,0,123),(1,'6072330003',0,0,0,1,0,0,0,3,0,0),(1,'6072330004',0,0,0,1,0,0,0,4,0,0),(1,'6072330005',0,0,0,1,0,0,0,5,0,0),(1,'6072330006',0,0,0,1,0,0,0,6,0,0),(1,'6072330007',0,0,0,1,0,0,0,7,0,0),(1,'6072330008',0,0,0,1,0,0,0,8,0,0),(1,'6072330009',0,0,0,1,0,0,0,9,0,0),(1,'6072330010',0,0,0,1,0,0,0,10,0,0),(1,'6072330011',0,0,0,1,0,0,0,11,0,0),(1,'6072330012',0,0,0,1,0,0,0,12,0,0),(1,'6072340001',0,0,0,0,1,0,0,1,0,123),(1,'6072340002',0,0,0,0,1,0,0,2,0,123),(1,'6072340003',0,0,0,0,1,0,0,3,0,0),(1,'6072340004',0,0,0,0,1,0,0,4,0,0),(1,'6072340005',0,0,0,0,1,0,0,5,0,0),(1,'6072340006',0,0,0,0,1,0,0,6,0,0),(1,'6072340007',0,0,0,0,1,0,0,7,0,0),(1,'6072340008',0,0,0,0,1,0,0,8,0,0),(1,'6072340009',0,0,0,0,1,0,0,9,0,0),(1,'6072340010',0,0,0,0,1,0,0,10,0,0),(1,'6072340011',0,0,0,0,1,0,0,11,0,0),(1,'6072340012',0,0,0,0,1,0,0,12,0,0),(1,'6072350001',0,0,0,0,0,1,0,1,0,123),(1,'6072350002',0,0,0,0,0,1,0,2,0,123),(1,'6072350003',0,0,0,0,0,1,0,3,0,0),(1,'6072350004',0,0,0,0,0,1,0,4,0,0),(1,'6072350005',0,0,0,0,0,1,0,5,0,0),(1,'6072350006',0,0,0,0,0,1,0,6,0,0),(1,'6072350007',0,0,0,0,0,1,0,7,0,0),(1,'6072350008',0,0,0,0,0,1,0,8,0,0),(1,'6072350009',0,0,0,0,0,1,0,9,0,0),(1,'6072350010',0,0,0,0,0,1,0,10,0,0),(1,'6072350011',0,0,0,0,0,1,0,11,0,0),(1,'6072350012',0,0,0,0,0,1,0,12,0,0),(1,'6142222002',0,0,1,1,0,0,2,0,0,123),(1,'9499580003',0,1,1,1,0,0,0,0,0,9),(212,'9404441234',0,0,0,0,0,0,0,0,0,76),(250,'9404441234',0,0,0,0,0,0,0,0,0,76),(602,'4808551568',1,0,0,0,0,0,0,0,0,0),(602,'6022770123',0,0,0,0,0,0,0,1,0,0),(602,'6026302261',0,0,1,0,0,0,0,0,0,0),(602,'6026302271',0,1,0,0,0,0,0,0,0,0),(602,'6026302272',0,0,0,0,0,0,0,0,0,0),(602,'6026302273',0,0,0,0,0,0,602,0,0,0),(602,'6026302274',0,0,0,0,0,0,603,0,0,0),(602,'6026304451',0,0,1,0,0,0,0,600,600,0),(602,'6026304453',0,0,0,0,0,0,480,600,600,0),(602,'6026304454',0,0,0,0,0,0,481,600,600,0),(602,'6026304455',0,0,0,0,0,0,482,600,600,0),(602,'6026304461',0,0,1,0,0,0,0,600,600,6),(602,'6026304470',0,0,0,0,0,0,0,600,600,0),(602,'6026304471',0,1,0,0,0,0,0,600,600,0),(602,'6026304472',0,0,0,0,0,0,0,600,600,0),(602,'6026304473',0,0,0,0,0,0,602,600,600,0),(602,'6026304476',0,0,0,0,0,0,0,602,0,0),(602,'6026304481',0,1,0,0,0,0,0,600,600,6),(775,'6147918354',0,0,0,0,0,0,1003,2312,2312,68),(775,'775',0,0,0,0,0,0,0,0,0,0),(775,'775210',0,1,1,1,1,1,0,0,0,0),(775,'7752300002',0,0,0,0,0,0,1003,2302,0,68),(775,'7752300003',0,0,0,0,0,0,1003,2303,2303,68),(775,'7752300012',0,0,0,0,0,0,1003,2312,2312,68),(775,'7752301000',0,0,0,0,0,0,1018,0,0,68),(775,'7752301001',0,0,0,0,0,0,1018,0,0,68),(775,'7759965000',0,0,0,0,0,0,0,0,0,0),(775,'7759965100',0,0,0,0,0,0,0,0,0,203),(775,'7759965101',0,1,0,0,0,0,0,0,0,203),(775,'7759965102',0,0,1,0,0,0,0,0,0,203),(775,'7759965103',0,0,0,1,0,0,0,0,0,203),(775,'7759965104',0,0,0,0,1,0,0,0,0,203),(775,'7759965105',0,0,0,0,0,1,0,0,0,203),(775,'7759965106',0,0,0,0,0,0,100,0,0,203),(775,'7759965107',0,0,0,0,0,0,0,775,0,203),(775,'7759965108',0,0,0,0,0,0,0,702,702,203),(775,'7759965109',0,1,1,1,1,1,1,702,702,203),(775,'7759965110',0,0,0,0,1,0,0,0,0,175),(775,'7759965111',1,1,1,1,1,1,1,702,702,203),(775,'7759968288',0,0,0,0,0,0,0,0,0,0),(775,'7759969000',1,0,0,0,0,0,0,0,0,203),(775,'7759969001',1,0,0,0,0,0,0,0,0,203),(775,'7759969002',1,0,0,0,0,0,0,0,0,203),(775,'7759969003',1,0,0,0,0,0,0,0,0,203),(775,'7759969004',1,0,0,0,0,0,0,0,0,203),(775,'7759969005',1,0,0,0,0,0,0,0,0,203),(775,'7759969006',1,0,0,0,0,0,0,0,0,203),(775,'7759969200',1,0,0,0,0,0,0,0,0,203),(775,'7759969201',1,0,0,0,0,0,0,0,0,203),(775,'7759969202',1,0,0,0,0,0,0,0,0,203),(775,'7759969203',1,0,0,0,0,0,0,0,0,203),(775,'7759969204',1,0,0,0,0,0,0,0,0,203),(775,'7759969205',1,0,0,0,0,0,0,0,0,203),(775,'7759969206',1,0,0,0,0,0,0,0,0,203),(775,'7759969398',1,0,0,0,0,0,0,0,0,203),(775,'7759969399',1,0,0,0,0,0,0,0,0,185),(775,'7759969400',1,0,0,0,0,0,0,0,0,203),(775,'7759969401',1,0,0,0,0,0,0,0,0,203),(775,'7759969402',1,0,0,0,0,0,0,0,0,203),(775,'7759969403',1,0,0,0,0,0,0,0,0,203),(775,'7759969404',1,0,0,0,0,0,0,0,0,203),(775,'7759969420',1,0,0,0,0,0,0,0,0,203),(775,'7759969421',1,0,0,0,0,0,0,0,0,203),(775,'7759969422',1,0,0,0,0,0,0,0,0,203),(775,'7759969423',1,0,0,0,0,0,0,0,0,203),(775,'7759969424',1,0,0,0,0,0,0,0,0,203),(775,'7759969430',1,0,0,0,0,0,0,0,0,203),(775,'7759969431',1,0,0,0,0,0,0,0,0,203),(775,'7759969432',1,0,0,0,0,0,0,0,0,203),(775,'7759969433',1,0,0,0,0,0,0,0,0,203),(775,'7759969434',1,0,0,0,0,0,0,0,0,203),(775,'7759969440',1,0,0,0,0,0,0,0,0,203),(775,'7759969441',1,0,0,0,0,0,0,0,0,203),(775,'7759969442',1,0,0,0,0,0,0,0,0,203),(775,'7759969443',1,0,0,0,0,0,0,0,0,203),(775,'7759969444',1,0,0,0,0,0,0,0,0,203),(775,'7759969450',1,0,0,0,0,0,0,0,0,203),(775,'7759969451',1,0,0,0,0,0,0,0,0,203),(775,'7759969452',1,0,0,0,0,0,0,0,0,203),(775,'7759969453',1,0,0,0,0,0,0,0,0,203),(775,'7759969454',1,0,0,0,0,0,0,0,0,203),(775,'7759969460',1,0,0,0,0,0,0,0,0,203),(775,'7759969461',1,0,0,0,0,0,0,0,0,203),(775,'7759969462',1,0,0,0,0,0,0,0,0,203),(775,'7759969463',1,0,0,0,0,0,0,0,0,203),(775,'7759969464',1,0,0,0,0,0,0,0,0,203),(775,'940',0,1,1,1,1,1,0,0,0,222),(775,'9404441234',0,0,0,0,0,0,0,0,0,76); /*!40000 ALTER TABLE `ANI` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ANI_NPANXX` -- DROP TABLE IF EXISTS `ANI_NPANXX`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ANI_NPANXX` ( `aniIndex` smallint(6) NOT NULL, `aniNPANXX` varchar(6) COLLATE latin1_general_cs NOT NULL, `natlBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `intlBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `operBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `allBlock` tinyint(3) unsigned NOT NULL DEFAULT '0', `block8XX` tinyint(3) unsigned NOT NULL DEFAULT '0', `cosIndex` smallint(6) NOT NULL DEFAULT '0', `pacFeatureIndex` smallint(6) NOT NULL DEFAULT '0', `pacCodeIndex` int(11) NOT NULL DEFAULT '0', `treatment` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`aniIndex`,`aniNPANXX`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ANI_NPANXX` -- LOCK TABLES `ANI_NPANXX` WRITE; /*!40000 ALTER TABLE `ANI_NPANXX` DISABLE KEYS */; INSERT INTO `ANI_NPANXX` VALUES (1,'607223',0,0,0,0,0,0,0,0,0),(1,'607224',1,0,0,0,0,0,0,0,123),(1,'607225',0,1,0,0,0,0,0,0,123),(1,'607226',0,0,1,0,0,0,0,0,123),(1,'607227',0,0,0,1,0,0,0,0,123),(1,'607228',0,0,0,0,1,0,0,0,123),(250,'940444',0,0,0,0,0,0,0,0,0),(775,'702211',0,0,0,1,0,0,0,0,0),(775,'702230',0,0,0,0,0,0,0,0,0),(775,'702996',0,0,0,0,0,0,0,0,0),(775,'775211',0,0,0,1,0,0,0,0,0),(775,'775230',0,0,0,0,0,0,0,0,0),(775,'775996',0,0,0,0,0,0,0,0,0),(775,'777599',0,0,0,0,0,0,0,0,0); /*!40000 ALTER TABLE `ANI_NPANXX` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ANumber` -- DROP TABLE IF EXISTS `ANumber`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ANumber` ( `aNumIndex` smallint(6) NOT NULL, `aniIndex` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`aNumIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ANumber` -- LOCK TABLES `ANumber` WRITE; /*!40000 ALTER TABLE `ANumber` DISABLE KEYS */; INSERT INTO `ANumber` VALUES (212,212),(250,250),(666,602),(775,775),(999,999); /*!40000 ALTER TABLE `ANumber` ENABLE KEYS */; UNLOCK TABLES; DELIMITER ;