-- MySQL dump 10.13 Distrib 5.6.27, for Win64 (x86_64) -- /*!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 `despatch` -- DROP TABLE IF EXISTS `despatch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `despatch` ( `DES_ROWID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `DES_CO` varchar(1) COLLATE latin1_bin NOT NULL, `DES_INV_DATE` char(3) COLLATE latin1_bin NOT NULL, UNIQUE KEY `RowId` (`DES_ROWID`), KEY `INVDATE` (`DES_CO`,`DES_INV_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=507652 DEFAULT CHARSET=latin1 COLLATE=latin1_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `despatch` -- LOCK TABLES `despatch` WRITE; /*!40000 ALTER TABLE `despatch` DISABLE KEYS */; INSERT INTO `despatch` VALUES (505975,'D','s:1'),(505981,'D','s:1'),(505869,'D','s:3'),(505870,'D','s:3'),(505871,'D','s:3'),(505872,'D','s:3'),(505873,'D','s:3'),(505874,'D','s:3'),(505875,'D','s:3'),(505876,'D','s:3'),(505889,'D','s:3'),(505919,'D','s:3'),(505920,'D','s:3'),(505921,'D','s:3'),(505922,'D','s:3'),(505924,'D','s:3'),(505938,'D','s:3'),(505939,'D','s:3'),(505940,'D','s:3'),(505941,'D','s:3'),(505942,'D','s:3'),(505962,'D','s:3'),(505965,'D','s:3'),(505967,'D','s:3'),(505969,'D','s:3'),(506010,'D','s:3'),(506011,'D','s:3'),(506012,'D','s:3'),(506013,'D','s:3'),(506015,'D','s:3'),(506034,'D','s:3'),(506035,'D','s:3'),(506048,'D','s:3'),(506049,'D','s:3'),(506051,'D','s:3'),(506054,'D','s:3'),(506055,'D','s:3'),(506056,'D','s:3'),(506057,'D','s:3'),(506062,'D','s:3'),(506063,'D','s:3'),(506064,'D','s:3'),(506065,'D','s:3'),(506066,'D','s:3'),(506067,'D','s:3'),(506068,'D','s:3'),(506116,'D','s:3'),(506118,'D','s:3'),(506127,'D','s:3'),(506133,'D','s:3'),(506142,'D','s:3'),(505892,'D','s:4'),(505893,'D','s:4'),(505897,'D','s:4'),(505898,'D','s:4'),(505899,'D','s:4'),(505900,'D','s:4'),(505902,'D','s:4'),(505903,'D','s:4'),(505904,'D','s:4'),(505905,'D','s:4'),(505906,'D','s:4'),(505907,'D','s:4'),(505910,'D','s:4'),(505911,'D','s:4'),(505912,'D','s:4'),(505914,'D','s:4'),(505915,'D','s:4'),(505916,'D','s:4'),(505918,'D','s:4'),(505923,'D','s:4'),(505936,'D','s:4'),(505944,'D','s:4'),(505948,'D','s:4'),(505955,'D','s:4'),(505956,'D','s:4'),(505958,'D','s:4'),(505960,'D','s:4'),(505961,'D','s:4'),(505977,'D','s:4'),(505978,'D','s:4'),(505984,'D','s:4'),(505986,'D','s:4'),(505987,'D','s:4'),(505988,'D','s:4'),(505997,'D','s:4'),(505998,'D','s:4'),(506001,'D','s:4'),(506017,'D','s:4'),(506018,'D','s:4'),(506019,'D','s:4'),(506021,'D','s:4'),(506032,'D','s:4'),(506033,'D','s:4'),(506036,'D','s:4'),(506037,'D','s:4'),(506038,'D','s:4'),(506039,'D','s:4'),(506040,'D','s:4'),(506041,'D','s:4'),(506042,'D','s:4'),(506043,'D','s:4'),(506044,'D','s:4'),(506046,'D','s:4'),(506058,'D','s:4'),(506060,'D','s:4'),(506061,'D','s:4'),(506085,'D','s:4'),(506094,'D','s:4'),(506096,'D','s:4'),(506099,'D','s:4'),(506100,'D','s:4'),(506101,'D','s:4'),(506102,'D','s:4'),(506103,'D','s:4'),(506107,'D','s:4'),(506108,'D','s:4'),(506117,'D','s:4'),(506121,'D','s:4'),(506123,'D','s:4'),(506130,'D','s:4'),(506131,'D','s:4'),(506145,'D','s:4'),(506146,'D','s:4'),(506154,'D','s:4'),(506155,'D','s:4'),(506156,'D','s:4'),(506167,'D','s:4'),(506171,'D','s:4'),(506172,'D','s:4'),(505884,'D','s:5'),(505885,'D','s:5'),(505886,'D','s:5'),(505887,'D','s:5'),(505888,'D','s:5'),(505890,'D','s:5'),(506030,'D','s:5'),(506047,'D','s:5'),(506050,'D','s:5'),(506052,'D','s:5'),(506095,'D','s:5'),(506097,'D','s:5'),(506109,'D','s:5'),(506119,'D','s:5'),(506120,'D','s:5'),(506128,'D','s:5'),(506132,'D','s:5'),(506134,'D','s:5'),(506135,'D','s:5'),(506136,'D','s:5'),(506137,'D','s:5'),(506138,'D','s:5'),(506141,'D','s:5'),(506144,'D','s:5'),(506152,'D','s:5'),(506157,'D','s:5'),(506158,'D','s:5'),(506159,'D','s:5'),(506160,'D','s:5'),(506161,'D','s:5'),(506163,'D','s:5'),(506164,'D','s:5'),(506165,'D','s:5'),(506168,'D','s:5'),(506169,'D','s:5'),(506170,'D','s:5'),(506173,'D','s:5'),(506175,'D','s:5'),(506176,'D','s:5'),(506179,'D','s:5'),(506190,'D','s:5'),(506191,'D','s:5'),(506221,'D','s:5'),(506222,'D','s:5'),(506223,'D','s:5'),(506226,'D','s:5'),(506228,'D','s:5'),(506231,'D','s:5'),(506232,'D','s:5'),(506249,'D','s:5'),(506250,'D','s:5'),(506251,'D','s:5'),(506254,'D','s:5'),(506267,'D','s:5'),(506271,'D','s:5'),(506391,'D','s:5'),(505894,'D','s:6'),(505908,'D','s:6'),(505909,'D','s:6'),(505913,'D','s:6'),(505973,'D','s:6'),(506020,'D','s:6'),(506023,'D','s:6'),(506025,'D','s:6'),(506026,'D','s:6'),(506027,'D','s:6'),(506031,'D','s:6'),(506088,'D','s:6'),(506093,'D','s:6'),(506104,'D','s:6'),(506105,'D','s:6'),(506106,'D','s:6'),(506149,'D','s:6'),(506153,'D','s:6'),(506243,'D','s:6'),(506278,'D','s:6'),(506281,'D','s:6'),(506284,'D','s:6'),(506285,'D','s:6'),(506287,'D','s:6'),(506289,'D','s:6'),(506300,'D','s:6'),(506301,'D','s:6'),(506302,'D','s:6'),(506303,'D','s:6'),(506304,'D','s:6'),(506305,'D','s:6'),(506306,'D','s:6'),(506307,'D','s:6'),(506309,'D','s:6'),(506312,'D','s:6'),(506315,'D','s:6'),(506317,'D','s:6'),(506318,'D','s:6'),(506336,'D','s:6'),(506337,'D','s:6'),(506338,'D','s:6'),(506339,'D','s:6'),(506340,'D','s:6'),(506345,'D','s:6'),(506369,'D','s:6'),(506374,'D','s:6'),(506377,'D','s:6'),(506383,'D','s:6'),(506384,'D','s:6'),(506387,'D','s:6'),(506390,'D','s:6'),(505877,'D','s:7'),(505891,'D','s:7'),(505895,'D','s:7'),(505896,'D','s:7'),(505901,'D','s:7'),(505917,'D','s:7'),(505953,'D','s:7'),(505966,'D','s:7'),(506022,'D','s:7'),(506024,'D','s:7'),(506028,'D','s:7'),(506029,'D','s:7'),(506045,'D','s:7'),(506053,'D','s:7'),(506059,'D','s:7'),(506090,'D','s:7'),(506098,'D','s:7'),(506114,'D','s:7'),(506139,'D','s:7'),(506140,'D','s:7'),(506147,'D','s:7'),(506148,'D','s:7'),(506150,'D','s:7'),(506151,'D','s:7'),(506162,'D','s:7'),(506166,'D','s:7'),(506174,'D','s:7'),(506177,'D','s:7'),(506212,'D','s:7'),(506213,'D','s:7'),(506224,'D','s:7'),(506229,'D','s:7'),(506237,'D','s:7'),(506268,'D','s:7'),(506272,'D','s:7'),(506273,'D','s:7'),(506274,'D','s:7'),(506276,'D','s:7'),(506277,'D','s:7'),(506279,'D','s:7'),(506280,'D','s:7'),(506282,'D','s:7'),(506286,'D','s:7'),(506290,'D','s:7'),(506291,'D','s:7'),(506292,'D','s:7'),(506293,'D','s:7'),(506294,'D','s:7'),(506295,'D','s:7'),(506296,'D','s:7'),(506297,'D','s:7'),(506298,'D','s:7'),(506299,'D','s:7'),(506308,'D','s:7'),(506310,'D','s:7'),(506313,'D','s:7'),(506316,'D','s:7'),(506342,'D','s:7'),(506343,'D','s:7'),(506344,'D','s:7'),(506346,'D','s:7'),(506347,'D','s:7'),(506349,'D','s:7'),(506364,'D','s:7'),(506365,'D','s:7'),(506366,'D','s:7'),(506368,'D','s:7'),(506370,'D','s:7'),(506371,'D','s:7'),(506372,'D','s:7'),(506373,'D','s:7'),(506393,'D','s:7'),(506394,'D','s:7'),(506396,'D','s:7'),(506397,'D','s:7'),(506400,'D','s:7'),(506401,'D','s:7'),(506403,'D','s:7'),(506404,'D','s:7'),(506406,'D','s:7'),(506407,'D','s:7'),(506409,'D','s:7'),(506412,'D','s:7'),(506413,'D','s:7'),(506414,'D','s:7'),(506415,'D','s:7'),(506416,'D','s:7'),(506417,'D','s:7'),(506418,'D','s:7'),(506419,'D','s:7'),(506420,'D','s:7'),(506421,'D','s:7'),(506422,'D','s:7'),(506423,'D','s:7'),(506424,'D','s:7'),(506425,'D','s:7'),(506426,'D','s:7'),(506427,'D','s:7'),(506428,'D','s:7'),(506429,'D','s:7'),(506430,'D','s:7'),(506432,'D','s:7'),(506434,'D','s:7'),(506435,'D','s:7'),(506436,'D','s:7'),(506437,'D','s:7'),(506438,'D','s:7'),(506442,'D','s:7'),(506443,'D','s:7'),(506444,'D','s:7'),(506456,'D','s:7'),(506467,'D','s:7'),(506469,'D','s:7'),(506470,'D','s:7'),(506471,'D','s:7'),(506472,'D','s:7'),(506473,'D','s:7'),(506474,'D','s:7'),(506475,'D','s:7'),(506476,'D','s:7'),(506477,'D','s:7'),(506478,'D','s:7'),(506482,'D','s:7'),(506498,'D','s:7'),(506500,'D','s:7'),(506501,'D','s:7'),(506502,'D','s:7'),(506728,'D','s:7'),(506275,'D','s:8'),(506311,'D','s:8'),(506314,'D','s:8'),(506341,'D','s:8'),(506367,'D','s:8'),(506405,'D','s:8'),(506410,'D','s:8'),(506411,'D','s:8'),(506431,'D','s:8'),(506479,'D','s:8'),(506503,'D','s:8'),(506504,'D','s:8'),(506505,'D','s:8'),(506506,'D','s:8'),(506507,'D','s:8'),(506519,'D','s:8'),(506520,'D','s:8'),(506522,'D','s:8'),(506525,'D','s:8'),(506546,'D','s:8'),(506547,'D','s:8'),(506551,'D','s:8'),(506555,'D','s:8'),(506557,'D','s:8'),(506559,'D','s:8'),(506571,'D','s:8'),(506576,'D','s:8'),(506577,'D','s:8'),(506578,'D','s:8'),(506579,'D','s:8'),(506580,'D','s:8'),(506581,'D','s:8'),(506582,'D','s:8'),(506583,'D','s:8'),(506585,'D','s:8'),(506586,'D','s:8'),(506588,'D','s:8'),(506589,'D','s:8'),(506591,'D','s:8'),(506592,'D','s:8'),(506593,'D','s:8'),(506594,'D','s:8'),(506595,'D','s:8'),(506597,'D','s:8'),(506599,'D','s:8'),(506710,'D','s:8'),(505963,'D','s::'),(506178,'D','s::'),(506233,'D','s::'),(506283,'D','s::'),(506395,'D','s::'),(506399,'D','s::'),(506402,'D','s::'),(506439,'D','s::'),(506440,'D','s::'),(506441,'D','s::'),(506499,'D','s::'),(506511,'D','s::'),(506512,'D','s::'),(506513,'D','s::'),(506514,'D','s::'),(506515,'D','s::'),(506516,'D','s::'),(506517,'D','s::'),(506518,'D','s::'),(506535,'D','s::'),(506536,'D','s::'),(506538,'D','s::'),(506540,'D','s::'),(506541,'D','s::'),(506542,'D','s::'),(506544,'D','s::'),(506545,'D','s::'),(506548,'D','s::'),(506549,'D','s::'),(506550,'D','s::'),(506552,'D','s::'),(506553,'D','s::'),(506563,'D','s::'),(506564,'D','s::'),(506565,'D','s::'),(506566,'D','s::'),(506584,'D','s::'),(506587,'D','s::'),(506598,'D','s::'),(506600,'D','s::'),(506601,'D','s::'),(506604,'D','s::'),(506607,'D','s::'),(506608,'D','s::'),(506609,'D','s::'),(506622,'D','s::'),(506623,'D','s::'),(506624,'D','s::'),(506626,'D','s::'),(506627,'D','s::'),(506628,'D','s::'),(506629,'D','s::'),(506633,'D','s::'),(506638,'D','s::'),(506639,'D','s::'),(506640,'D','s::'),(506641,'D','s::'),(506642,'D','s::'),(506646,'D','s::'),(506647,'D','s::'),(506648,'D','s::'),(506649,'D','s::'),(506650,'D','s::'),(506651,'D','s::'),(506652,'D','s::'),(506653,'D','s::'),(506654,'D','s::'),(506655,'D','s::'),(506656,'D','s::'),(506657,'D','s::'),(506658,'D','s::'),(506661,'D','s::'),(506662,'D','s::'),(506663,'D','s::'),(506664,'D','s::'),(506670,'D','s::'),(506672,'D','s::'),(506703,'D','s::'),(506704,'D','s::'),(506707,'D','s::'),(506708,'D','s::'),(506709,'D','s::'),(506711,'D','s::'),(506724,'D','s::'),(506725,'D','s::'),(506726,'D','s::'),(506727,'D','s::'),(506757,'D','s::'),(506758,'D','s::'),(506288,'D','s:;'),(506398,'D','s:;'),(506510,'D','s:;'),(506529,'D','s:;'),(506530,'D','s:;'),(506531,'D','s:;'),(506533,'D','s:;'),(506534,'D','s:;'),(506537,'D','s:;'),(506543,'D','s:;'),(506596,'D','s:;'),(506602,'D','s:;'),(506610,'D','s:;'),(506621,'D','s:;'),(506625,'D','s:;'),(506630,'D','s:;'),(506631,'D','s:;'),(506632,'D','s:;'),(506643,'D','s:;'),(506644,'D','s:;'),(506645,'D','s:;'),(506706,'D','s:;'),(506408,'D','s:<'),(506468,'D','s:<'),(506480,'D','s:<'),(506509,'D','s:<'),(506521,'D','s:<'),(506524,'D','s:<'),(506526,'D','s:<'),(506532,'D','s:<'),(506539,'D','s:<'),(506603,'D','s:<'),(506605,'D','s:<'),(506606,'D','s:<'),(506611,'D','s:<'),(506619,'D','s:<'),(506620,'D','s:<'),(506634,'D','s:<'),(506635,'D','s:<'),(506636,'D','s:<'),(506637,'D','s:<'),(506659,'D','s:<'),(506665,'D','s:<'),(506666,'D','s:<'),(506668,'D','s:<'),(506674,'D','s:<'),(506695,'D','s:<'),(506705,'D','s:<'),(506712,'D','s:<'),(506713,'D','s:<'),(506714,'D','s:<'),(506716,'D','s:<'),(506722,'D','s:<'),(506732,'D','s:<'),(506737,'D','s:<'),(506738,'D','s:<'),(506739,'D','s:<'),(506740,'D','s:<'),(506741,'D','s:<'),(506742,'D','s:<'),(506743,'D','s:<'),(506744,'D','s:<'),(506745,'D','s:<'),(506746,'D','s:<'),(506747,'D','s:<'),(506748,'D','s:<'),(506749,'D','s:<'),(506750,'D','s:<'),(506751,'D','s:<'),(506752,'D','s:<'),(506753,'D','s:<'),(506754,'D','s:<'),(506755,'D','s:<'),(506759,'D','s:<'),(506760,'D','s:<'),(506761,'D','s:<'),(506763,'D','s:<'),(506764,'D','s:<'),(506766,'D','s:<'),(506767,'D','s:<'),(506768,'D','s:<'),(506769,'D','s:<'),(506770,'D','s:<'),(506771,'D','s:<'),(506772,'D','s:<'),(506773,'D','s:<'),(506774,'D','s:<'),(506775,'D','s:<'),(506777,'D','s:<'),(506779,'D','s:<'),(506780,'D','s:<'),(506781,'D','s:<'),(506782,'D','s:<'),(506783,'D','s:<'),(506784,'D','s:<'),(506785,'D','s:<'),(506790,'D','s:<'),(506791,'D','s:<'),(506792,'D','s:<'),(506816,'D','s:<'),(506818,'D','s:<'),(506819,'D','s:<'),(506820,'D','s:<'),(506821,'D','s:<'),(506822,'D','s:<'),(506823,'D','s:<'),(506824,'D','s:<'),(506825,'D','s:<'),(506826,'D','s:<'),(506827,'D','s:<'),(506841,'D','s:<'),(506847,'D','s:<'),(506848,'D','s:<'),(506850,'D','s:<'),(506851,'D','s:<'),(506883,'D','s:<'),(506936,'D','s:<'),(506943,'D','s:<'),(507049,'D','s:<'),(507051,'D','s:<'),(507074,'D','s:<'),(507085,'D','s:<'),(507087,'D','s:<'),(507144,'D','s:<'),(506613,'D','s:='),(506614,'D','s:='),(506762,'D','s:='),(506765,'D','s:='),(506817,'D','s:='),(506828,'D','s:='),(506829,'D','s:='),(506830,'D','s:='),(506831,'D','s:='),(506833,'D','s:='),(506834,'D','s:='),(506836,'D','s:='),(506837,'D','s:='),(506838,'D','s:='),(506839,'D','s:='),(506840,'D','s:='),(506843,'D','s:='),(506844,'D','s:='),(506852,'D','s:='),(506853,'D','s:='),(506854,'D','s:='),(506855,'D','s:='),(506856,'D','s:='),(506858,'D','s:='),(506860,'D','s:='),(506861,'D','s:='),(506862,'D','s:='),(506864,'D','s:='),(506865,'D','s:='),(506866,'D','s:='),(506867,'D','s:='),(506868,'D','s:='),(506869,'D','s:='),(506870,'D','s:='),(506871,'D','s:='),(506872,'D','s:='),(506873,'D','s:='),(506874,'D','s:='),(506875,'D','s:='),(506877,'D','s:='),(506878,'D','s:='),(506879,'D','s:='),(506880,'D','s:='),(506881,'D','s:='),(506908,'D','s:='),(506910,'D','s:='),(506914,'D','s:='),(506919,'D','s:='),(506920,'D','s:='),(506921,'D','s:='),(506922,'D','s:='),(506923,'D','s:='),(506924,'D','s:='),(506925,'D','s:='),(506927,'D','s:='),(506928,'D','s:='),(506929,'D','s:='),(506931,'D','s:='),(506932,'D','s:='),(506934,'D','s:='),(506935,'D','s:='),(506937,'D','s:='),(506944,'D','s:='),(506945,'D','s:='),(506947,'D','s:='),(506948,'D','s:='),(506949,'D','s:='),(506951,'D','s:='),(506952,'D','s:='),(506953,'D','s:='),(506954,'D','s:='),(506960,'D','s:='),(507041,'D','s:='),(506508,'D','s:>'),(506523,'D','s:>'),(506527,'D','s:>'),(506528,'D','s:>'),(506590,'D','s:>'),(506616,'D','s:>'),(506617,'D','s:>'),(506618,'D','s:>'),(506660,'D','s:>'),(506756,'D','s:>'),(506857,'D','s:>'),(506859,'D','s:>'),(506876,'D','s:>'),(506930,'D','s:>'),(506933,'D','s:>'),(506940,'D','s:>'),(506941,'D','s:>'),(506942,'D','s:>'),(506950,'D','s:>'),(506956,'D','s:>'),(506957,'D','s:>'),(506958,'D','s:>'),(506959,'D','s:>'),(506962,'D','s:>'),(506963,'D','s:>'),(506967,'D','s:>'),(506970,'D','s:>'),(506971,'D','s:>'),(506972,'D','s:>'),(506973,'D','s:>'),(506974,'D','s:>'),(506975,'D','s:>'),(506976,'D','s:>'),(506977,'D','s:>'),(506978,'D','s:>'),(506979,'D','s:>'),(506980,'D','s:>'),(506981,'D','s:>'),(506982,'D','s:>'),(506983,'D','s:>'),(506984,'D','s:>'),(506985,'D','s:>'),(506986,'D','s:>'),(506987,'D','s:>'),(506988,'D','s:>'),(506989,'D','s:>'),(506991,'D','s:>'),(507026,'D','s:>'),(507027,'D','s:>'),(507029,'D','s:>'),(507030,'D','s:>'),(507035,'D','s:>'),(507036,'D','s:>'),(507037,'D','s:>'),(507038,'D','s:>'),(507039,'D','s:>'),(507040,'D','s:>'),(507042,'D','s:>'),(507043,'D','s:>'),(507044,'D','s:>'),(507045,'D','s:>'),(507050,'D','s:>'),(507052,'D','s:>'),(507055,'D','s:>'),(507060,'D','s:>'),(507061,'D','s:>'),(507062,'D','s:>'),(507063,'D','s:>'),(507064,'D','s:>'),(507065,'D','s:>'),(507066,'D','s:>'),(507067,'D','s:>'),(507068,'D','s:>'),(507070,'D','s:>'),(507071,'D','s:>'),(507072,'D','s:>'),(507073,'D','s:>'),(507086,'D','s:>'),(507143,'D','s:>'),(507157,'D','s:>'),(506832,'D','s:?'),(506863,'D','s:?'),(507046,'D','s:?'),(507057,'D','s:?'),(507058,'D','s:?'),(507107,'D','s:?'),(507108,'D','s:?'),(507109,'D','s:?'),(507110,'D','s:?'),(507111,'D','s:?'),(507112,'D','s:?'),(507114,'D','s:?'),(507115,'D','s:?'),(507138,'D','s:?'),(507139,'D','s:?'),(507140,'D','s:?'),(507141,'D','s:?'),(507142,'D','s:?'),(507158,'D','s:?'),(507159,'D','s:?'),(507160,'D','s:?'),(507161,'D','s:?'),(507162,'D','s:?'),(507163,'D','s:?'),(507176,'D','s:?'),(507177,'D','s:?'),(507180,'D','s:?'),(507182,'D','s:?'),(507191,'D','s:?'),(507245,'D','s:@'),(507250,'D','s:@'),(507251,'D','s:@'),(507082,'D','s:A'),(507088,'D','s:A'),(507089,'D','s:A'),(507090,'D','s:A'),(507091,'D','s:A'),(507092,'D','s:A'),(507093,'D','s:A'),(507094,'D','s:A'),(507095,'D','s:A'),(507096,'D','s:A'),(507097,'D','s:A'),(507098,'D','s:A'),(507099,'D','s:A'),(507100,'D','s:A'),(507102,'D','s:A'),(507103,'D','s:A'),(507104,'D','s:A'),(507105,'D','s:A'),(507106,'D','s:A'),(507116,'D','s:A'),(507117,'D','s:A'),(507118,'D','s:A'),(507119,'D','s:A'),(507121,'D','s:A'),(507124,'D','s:A'),(507132,'D','s:A'),(507133,'D','s:A'),(507134,'D','s:A'),(507135,'D','s:A'),(507136,'D','s:A'),(507145,'D','s:A'),(507146,'D','s:A'),(507147,'D','s:A'),(507148,'D','s:A'),(507153,'D','s:A'),(507154,'D','s:A'),(507155,'D','s:A'),(507164,'D','s:A'),(507195,'D','s:A'),(507196,'D','s:A'),(507197,'D','s:A'),(507204,'D','s:A'),(507205,'D','s:A'),(507206,'D','s:A'),(507207,'D','s:A'),(507208,'D','s:A'),(507209,'D','s:A'),(507210,'D','s:A'),(507211,'D','s:A'),(507212,'D','s:A'),(507213,'D','s:A'),(507214,'D','s:A'),(507215,'D','s:A'),(507216,'D','s:A'),(507217,'D','s:A'),(507218,'D','s:A'),(507219,'D','s:A'),(507222,'D','s:A'),(507223,'D','s:A'),(507224,'D','s:A'),(507225,'D','s:A'),(507226,'D','s:A'),(507227,'D','s:A'),(507228,'D','s:A'),(507229,'D','s:A'),(507231,'D','s:A'),(507246,'D','s:A'),(507247,'D','s:A'),(507248,'D','s:A'),(507252,'D','s:A'),(507253,'D','s:A'),(507256,'D','s:A'),(507258,'D','s:A'),(507259,'D','s:A'),(507260,'D','s:A'),(507261,'D','s:A'),(507262,'D','s:A'),(507264,'D','s:A'),(507265,'D','s:A'),(507271,'D','s:A'),(507272,'D','s:A'),(507281,'D','s:A'),(507282,'D','s:A'),(507283,'D','s:A'),(507285,'D','s:A'),(507286,'D','s:A'),(507287,'D','s:A'),(507288,'D','s:A'),(507298,'D','s:A'),(507299,'D','s:A'),(507300,'D','s:A'),(507323,'D','s:A'),(507324,'D','s:A'),(507336,'D','s:A'),(507337,'D','s:A'),(507338,'D','s:A'),(506966,'D','s:B'),(506961,'D','s:C'),(506964,'D','s:C'),(506965,'D','s:C'),(506968,'D','s:C'),(506969,'D','s:C'),(507047,'D','s:C'),(507048,'D','s:C'),(507053,'D','s:C'),(507056,'D','s:C'),(507059,'D','s:C'),(507083,'D','s:C'),(507084,'D','s:C'),(507101,'D','s:C'),(507113,'D','s:C'),(507137,'D','s:C'),(507149,'D','s:C'),(507150,'D','s:C'),(507151,'D','s:C'),(507173,'D','s:C'),(507174,'D','s:C'),(507185,'D','s:C'),(507186,'D','s:C'),(507187,'D','s:C'),(507188,'D','s:C'),(507189,'D','s:C'),(507190,'D','s:C'),(507198,'D','s:C'),(507199,'D','s:C'),(507200,'D','s:C'),(507201,'D','s:C'),(507202,'D','s:C'),(507221,'D','s:C'),(507235,'D','s:C'),(507249,'D','s:C'),(507254,'D','s:C'),(507257,'D','s:C'),(507263,'D','s:C'),(507267,'D','s:C'),(507278,'D','s:C'),(507279,'D','s:C'),(507280,'D','s:C'),(507290,'D','s:C'),(507296,'D','s:C'),(507297,'D','s:C'),(507301,'D','s:C'),(507302,'D','s:C'),(507312,'D','s:C'),(507313,'D','s:C'),(507314,'D','s:C'),(507315,'D','s:C'),(507316,'D','s:C'),(507317,'D','s:C'),(507325,'D','s:C'),(507326,'D','s:C'),(507327,'D','s:C'),(507329,'D','s:C'),(507330,'D','s:C'),(507331,'D','s:C'),(507332,'D','s:C'),(507333,'D','s:C'),(507335,'D','s:C'),(507339,'D','s:C'),(507340,'D','s:C'),(507341,'D','s:C'),(507342,'D','s:C'),(507343,'D','s:C'),(507344,'D','s:C'),(507345,'D','s:C'),(507346,'D','s:C'),(507347,'D','s:C'),(507349,'D','s:C'),(507350,'D','s:C'),(507351,'D','s:C'),(507352,'D','s:C'),(507353,'D','s:C'),(507354,'D','s:C'),(507356,'D','s:C'),(507357,'D','s:C'),(507358,'D','s:C'),(507359,'D','s:C'),(507375,'D','s:C'),(507376,'D','s:C'),(507385,'D','s:C'),(507386,'D','s:C'),(507387,'D','s:C'),(507388,'D','s:C'),(507390,'D','s:C'),(507391,'D','s:C'),(507392,'D','s:C'),(507393,'D','s:C'),(507394,'D','s:C'),(507395,'D','s:C'),(507396,'D','s:C'),(507403,'D','s:C'),(507405,'D','s:C'),(507406,'D','s:C'),(507410,'D','s:C'),(507411,'D','s:C'),(507415,'D','s:C'),(507417,'D','s:C'),(507450,'D','s:C'),(507453,'D','s:C'),(507468,'D','s:C'),(507508,'D','s:D'),(507515,'D','s:D'),(507517,'D','s:D'),(507576,'D','s:E'),(507582,'D','s:E'),(507584,'D','s:E'),(507585,'D','s:E'),(507586,'D','s:E'),(507651,'D','s;9'); /*!40000 ALTER TABLE `despatch` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `period` -- DROP TABLE IF EXISTS `period`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `period` ( `PER_ROWID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `PER_END_DATE` char(3) COLLATE latin1_bin NOT NULL, UNIQUE KEY `RowId` (`PER_ROWID`), KEY `END_DATE` (`PER_END_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=2112 DEFAULT CHARSET=latin1 COLLATE=latin1_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `period` -- LOCK TABLES `period` WRITE; /*!40000 ALTER TABLE `period` DISABLE KEYS */; INSERT INTO `period` VALUES (9,'_:L'),(10,'_<2'),(11,'_