-- MySQL dump 10.13  Distrib 5.7.11, for Win64 (x86_64)
--
-- Host: localhost    Database: a1pukr
-- ------------------------------------------------------
-- Server version	5.7.11-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 */;

--
-- Table structure for table `attlocass`
--

DROP TABLE IF EXISTS `attlocass`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attlocass` (
  `locKey` int(11) unsigned NOT NULL,
  `assKey` int(11) NOT NULL,
  `isAss` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`locKey`,`assKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attlocation`
--

DROP TABLE IF EXISTS `attlocation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attlocation` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `schKey` int(11) unsigned NOT NULL,
  `stationcode` char(3) DEFAULT NULL,
  `typ` char(2) NOT NULL,
  `tiploc` char(7) NOT NULL,
  `pubArr` time DEFAULT NULL,
  `pubDep` time DEFAULT NULL,
  `platform` varchar(3) DEFAULT NULL,
  `cerKey` int(11) unsigned DEFAULT NULL,
  `mcaLocKey` int(10) unsigned NOT NULL,
  PRIMARY KEY (`autokey`),
  KEY `tiploc` (`tiploc`),
  KEY `stationcode` (`stationcode`),
  KEY `pubArr` (`pubArr`),
  KEY `typ` (`typ`),
  KEY `pubDep` (`pubDep`),
  KEY `schKey` (`schKey`),
  KEY `stationcodeSchKey` (`schKey`,`stationcode`)
) ENGINE=MyISAM AUTO_INCREMENT=156442863 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcaassociations`
--

DROP TABLE IF EXISTS `attmcaassociations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcaassociations` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tuid1` char(6) NOT NULL,
  `tuid2` char(6) NOT NULL,
  `startdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  `daysMon` char(1) DEFAULT NULL,
  `daysTue` char(1) DEFAULT NULL,
  `daysWed` char(1) DEFAULT NULL,
  `daysThu` char(1) DEFAULT NULL,
  `daysFri` char(1) DEFAULT NULL,
  `daysSat` char(1) DEFAULT NULL,
  `daysSun` char(1) DEFAULT NULL,
  `category` char(2) DEFAULT NULL,
  `dateInd` char(1) DEFAULT NULL,
  `tiploc` varchar(7) DEFAULT NULL,
  `baseLocSuffix` char(1) DEFAULT NULL,
  `assocLocSuffix` char(1) DEFAULT NULL,
  `diagType` char(1) DEFAULT NULL,
  `type` char(1) DEFAULT NULL,
  `stpInd` char(1) DEFAULT NULL,
  PRIMARY KEY (`autokey`),
  KEY `tuid1` (`tuid1`),
  KEY `tuid2` (`tuid2`)
) ENGINE=MyISAM AUTO_INCREMENT=170552 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcacer`
--

DROP TABLE IF EXISTS `attmcacer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcacer` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tiploc` varchar(7) DEFAULT NULL,
  `tsuffix` char(1) DEFAULT NULL,
  `tcat` char(2) DEFAULT NULL,
  `trainident` char(4) DEFAULT NULL,
  `headcode` char(4) DEFAULT NULL,
  `courseind` char(1) DEFAULT NULL,
  `servicecode` char(8) DEFAULT NULL,
  `portionid` char(1) DEFAULT NULL,
  `powertype` varchar(3) DEFAULT NULL,
  `timingload` varchar(4) DEFAULT NULL,
  `speed` varchar(3) DEFAULT NULL,
  `opchar1` char(1) DEFAULT NULL,
  `opchar2` char(1) DEFAULT NULL,
  `opchar3` char(1) DEFAULT NULL,
  `opchar4` char(1) DEFAULT NULL,
  `opchar5` char(1) DEFAULT NULL,
  `opchar6` char(1) DEFAULT NULL,
  `trainclass` char(1) DEFAULT NULL,
  `sleepers` char(1) DEFAULT NULL,
  `rescode` char(1) DEFAULT NULL,
  `connind` char(1) DEFAULT NULL,
  `catering1` char(1) DEFAULT NULL,
  `catering2` char(1) DEFAULT NULL,
  `catering3` char(1) DEFAULT NULL,
  `catering4` char(1) DEFAULT NULL,
  `branding1` char(1) DEFAULT NULL,
  `branding2` char(1) DEFAULT NULL,
  `branding3` char(1) DEFAULT NULL,
  `branding4` char(1) DEFAULT NULL,
  `tractionclass` char(4) DEFAULT NULL,
  `uiccode` char(5) DEFAULT NULL,
  `rsid` char(8) DEFAULT NULL,
  PRIMARY KEY (`autokey`)
) ENGINE=MyISAM AUTO_INCREMENT=2503687 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcaheader`
--

DROP TABLE IF EXISTS `attmcaheader`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcaheader` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `dt` datetime DEFAULT NULL,
  `mid` char(20) DEFAULT NULL,
  `currref` char(7) DEFAULT NULL,
  `prevref` char(7) DEFAULT NULL,
  `typ` char(1) DEFAULT NULL,
  `v` char(1) DEFAULT NULL,
  `usdt` date DEFAULT NULL,
  `uedt` date DEFAULT NULL,
  PRIMARY KEY (`autokey`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcalocation`
--

DROP TABLE IF EXISTS `attmcalocation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcalocation` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tiploc` varchar(7) NOT NULL,
  `schKey` int(11) DEFAULT NULL,
  `typ` char(2) NOT NULL,
  `cerKey` int(11) unsigned DEFAULT NULL,
  `tsuffix` char(1) DEFAULT NULL,
  `schArr` time DEFAULT NULL,
  `schDep` time DEFAULT NULL,
  `schPass` time DEFAULT NULL,
  `pubArr` time DEFAULT NULL,
  `pubDep` time DEFAULT NULL,
  `platform` varchar(3) DEFAULT NULL,
  `line` varchar(3) DEFAULT NULL,
  `path` varchar(3) DEFAULT NULL,
  `act1` varchar(2) DEFAULT NULL,
  `act2` varchar(2) DEFAULT NULL,
  `act3` varchar(2) DEFAULT NULL,
  `act4` varchar(2) DEFAULT NULL,
  `act5` varchar(2) DEFAULT NULL,
  `act6` varchar(2) DEFAULT NULL,
  `engAll` varchar(2) DEFAULT NULL,
  `pathAll` varchar(2) DEFAULT NULL,
  `perfAll` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`autokey`),
  KEY `tiploc_typ` (`tiploc`,`typ`),
  KEY `schKey` (`schKey`)
) ENGINE=MyISAM AUTO_INCREMENT=257820213 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcaschedule`
--

DROP TABLE IF EXISTS `attmcaschedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcaschedule` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `datefrom` date DEFAULT NULL,
  `dateto` date DEFAULT NULL,
  `daysMon` char(1) DEFAULT NULL,
  `daysTue` char(1) DEFAULT NULL,
  `daysWed` char(1) DEFAULT NULL,
  `daysThu` char(1) DEFAULT NULL,
  `daysFri` char(1) DEFAULT NULL,
  `daysSat` char(1) DEFAULT NULL,
  `daysSun` char(1) DEFAULT NULL,
  `bhx` char(1) DEFAULT NULL,
  `pubDep` time DEFAULT NULL,
  `transtype` char(1) DEFAULT NULL,
  `tuid` char(6) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `tcat` char(2) DEFAULT NULL,
  `trainident` char(4) DEFAULT NULL,
  `headcode` char(4) DEFAULT NULL,
  `courseind` char(1) DEFAULT NULL,
  `servicecode` char(8) DEFAULT NULL,
  `portionid` char(1) DEFAULT NULL,
  `powertype` char(3) DEFAULT NULL,
  `timingload` char(4) DEFAULT NULL,
  `speed` char(3) DEFAULT NULL,
  `opchar1` char(1) DEFAULT NULL,
  `opchar2` char(1) DEFAULT NULL,
  `opchar3` char(1) DEFAULT NULL,
  `opchar4` char(1) DEFAULT NULL,
  `opchar5` char(1) DEFAULT NULL,
  `opchar6` char(1) DEFAULT NULL,
  `trainclass` char(1) DEFAULT NULL,
  `sleepers` char(1) DEFAULT NULL,
  `rescode` char(1) DEFAULT NULL,
  `connind` char(1) DEFAULT NULL,
  `catering1` char(1) DEFAULT NULL,
  `catering2` char(1) DEFAULT NULL,
  `catering3` char(1) DEFAULT NULL,
  `catering4` char(1) DEFAULT NULL,
  `branding1` char(1) DEFAULT NULL,
  `branding2` char(1) DEFAULT NULL,
  `branding3` char(1) DEFAULT NULL,
  `branding4` char(1) DEFAULT NULL,
  `stp` char(1) DEFAULT NULL,
  `tractionclass` char(4) DEFAULT NULL,
  `uiccode` char(5) DEFAULT NULL,
  `atoccode` char(2) DEFAULT NULL,
  `atcode` char(1) DEFAULT NULL,
  `rsid` char(8) DEFAULT NULL,
  `datasource` char(1) DEFAULT NULL,
  `effDateFrom` date DEFAULT NULL,
  `effDateTo` date DEFAULT NULL,
  `effDaysMon` tinyint(1) DEFAULT '0',
  `effDaysTue` tinyint(1) DEFAULT '0',
  `effDaysWed` tinyint(1) DEFAULT '0',
  `effDaysThu` tinyint(1) DEFAULT '0',
  `effDaysFri` tinyint(1) DEFAULT '0',
  `effDaysSat` tinyint(1) DEFAULT '0',
  `effDaysSun` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`autokey`),
  KEY `dateFrom` (`datefrom`),
  KEY `dateTo` (`dateto`),
  KEY `daysMon` (`daysMon`),
  KEY `daysTue` (`daysTue`),
  KEY `daysWed` (`daysWed`),
  KEY `daysThu` (`daysThu`),
  KEY `daysFri` (`daysFri`),
  KEY `daysSat` (`daysSat`),
  KEY `daysSun` (`daysSun`),
  KEY `bhx` (`bhx`),
  KEY `pubDep` (`pubDep`),
  KEY `stp` (`stp`),
  KEY `tuid` (`tuid`),
  KEY `effDateFrom` (`effDateFrom`),
  KEY `effDateTo` (`effDateTo`),
  KEY `effDaysMon` (`effDaysMon`),
  KEY `effDaysTue` (`effDaysTue`),
  KEY `effDaysWed` (`effDaysWed`),
  KEY `effDaysThu` (`effDaysThu`),
  KEY `effDaysFri` (`effDaysFri`),
  KEY `effDaysSat` (`effDaysSat`),
  KEY `effDaysSun` (`effDaysSun`)
) ENGINE=MyISAM AUTO_INCREMENT=17969150 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmcatiploc`
--

DROP TABLE IF EXISTS `attmcatiploc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmcatiploc` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tiploc` varchar(7) NOT NULL,
  `crs` char(3) DEFAULT NULL,
  `TLC` char(3) DEFAULT NULL,
  `nlc` char(6) DEFAULT NULL,
  `stanox` char(5) DEFAULT NULL,
  `tpsDesc` varchar(26) NOT NULL,
  `tiplocCapId` char(2) DEFAULT NULL,
  `nlcCheck` char(1) DEFAULT NULL,
  `poCode` char(4) DEFAULT NULL,
  `capriDesc` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`autokey`),
  UNIQUE KEY `tiploc_UNIQUE` (`tiploc`),
  KEY `crs` (`crs`)
) ENGINE=MyISAM AUTO_INCREMENT=568784 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmsnheader`
--

DROP TABLE IF EXISTS `attmsnheader`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmsnheader` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `v` char(8) NOT NULL,
  `dt` datetime NOT NULL,
  `seq` varchar(45) NOT NULL,
  PRIMARY KEY (`autokey`),
  UNIQUE KEY `autokey_UNIQUE` (`autokey`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attmsnstation`
--

DROP TABLE IF EXISTS `attmsnstation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attmsnstation` (
  `autokey` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tiploc` char(7) NOT NULL,
  `stationcode` char(3) NOT NULL,
  `name` varchar(30) NOT NULL,
  `ictype` char(1) NOT NULL,
  `code2` char(3) DEFAULT NULL,
  `easting` char(5) DEFAULT NULL,
  `northing` char(5) DEFAULT NULL,
  `est` char(1) DEFAULT NULL,
  `ctime` char(2) DEFAULT NULL,
  `alias` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`autokey`),
  UNIQUE KEY `tiploc` (`tiploc`)
) ENGINE=MyISAM AUTO_INCREMENT=167865 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attstatra`
--

DROP TABLE IF EXISTS `attstatra`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attstatra` (
  `stationcode` char(3) NOT NULL,
  `tuid` char(6) NOT NULL,
  PRIMARY KEY (`stationcode`,`tuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `infologs`
--

DROP TABLE IF EXISTS `infologs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `infologs` (
  `autokey` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(8) NOT NULL,
  `msg` blob NOT NULL,
  PRIMARY KEY (`autokey`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
/*!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 2016-05-14 11:24:43
