(6421,'BC','TRAIL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6422,'SK','TRAMPING LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6423,'MB','TRAVERSE BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6424,'NL','TRAYTOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6425,'QC','TRECESSON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6426,'MB','TREHERNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6427,'NB','TREMBLAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6428,'ON','TRENT RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6429,'NS','TRENTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6430,'ON','TRENTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6431,'NL','TREPASSEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6432,'QC','TRES-SAINT-REDEMPTEUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6433,'SK','TRIBUNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6434,'QC','TRING-JONCTION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6435,'NL','TRINITY BB','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6436,'NL','TRINITY TB','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6437,'NL','TRITON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6438,'AB','TROCHU','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6439,'QC','TROIS-PISTOLES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6440,'QC','TROIS-RIVES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6441,'QC','TROIS-RIVIERES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6442,'NB','TROIS-RUISSEAUX','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6443,'SK','TROSSACHS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6444,'NB','TROUT BROOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6445,'ON','TROUT CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6446,'AB','TROUT LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6447,'NT','TROUT LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6448,'NL','TROUT RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6449,'NS','TROY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6450,'ON','TROY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6451,'SK','TRUAX','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6452,'NB','TRUDEL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6453,'NS','TRURO HEIGHTS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6454,'NS','TRURO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6455,'BC','TSAWWASSEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6456,'BC','TSAY KEH DENE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6457,'NT','TSIIGEHTCHIC','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6458,'AB','TSUU T\'INA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6459,'SK','TUFFNELL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6460,'SK','TUGASKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6461,'NT','TUKTOYAKTUK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6462,'BC','TULAMEEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6463,'NT','TULITA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6464,'AB','TULLIBY LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6465,'BC','TUMBLER RIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6466,'ON','TUNIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6467,'ON','TUPPERVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6468,'AB','TURIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6469,'ON','TURKEY POINT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6470,'NL','TURKS COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6471,'AB','TURNER VALLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6472,'SK','TURNOR LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6473,'NB','TURTLE CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6474,'SK','TURTLEFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6475,'NS','TUSKET','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6476,'SK','TUXFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6477,'SK','TWAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6478,'ON','TWEED','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6479,'NL','TWILLINGATE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6480,'AB','TWIN BUTTE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6481,'NB','TWO BROOKS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6482,'AB','TWO HILLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6483,'MB','TYNDALL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6484,'PE','TYNE VALLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6485,'NB','TYNEMOUTH CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6486,'SK','TYNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6487,'SK','TYVAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6488,'BC','UCLUELET','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6489,'ON','UDORA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6490,'NT','ULUKHAKTOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6491,'QC','ULVERTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6492,'QC','UMIUJAQ','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6493,'BC','UNION BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6494,'NB','UNION CORNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6495,'ON','UNION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6496,'ON','UNIONVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6497,'SK','UNITY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6498,'NB','UPHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6499,'NB','UPPER BLACKVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6500,'NS','UPPER BRANCH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6501,'NB','UPPER BRIGHTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6502,'NS','UPPER BROOKSIDE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6503,'ON','UPPER CANADA VILLAGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6504,'NB','UPPER CAPE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6505,'NB','UPPER CAVERHILL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6506,'NS','UPPER CHELSEA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6507,'NB','UPPER COVERDALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6508,'NB','UPPER DERBY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6509,'NB','UPPER DORCHESTER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6510,'BC','UPPER FRASER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6511,'NB','UPPER GAGETOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6512,'NB','UPPER GOLDEN GROVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6513,'NS','UPPER GRAND MIRA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6514,'NB','UPPER HAINESVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6515,'NS','UPPER HAMMONDS PLAINS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6516,'NB','UPPER HAMPSTEAD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6517,'NL','UPPER ISLAND COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6518,'NS','UPPER KENNETCOOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6519,'NB','UPPER KENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6520,'NB','UPPER KESWICK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6521,'NB','UPPER KINGSCLEAR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6522,'NB','UPPER KINTORE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6523,'NB','UPPER KNOXFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6524,'NS','UPPER LAHAVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6525,'NS','UPPER LEITCHES CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6526,'NB','UPPER LETANG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6527,'NB','UPPER LOCH LOMOND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6528,'NB','UPPER MILLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6529,'NS','UPPER MUSQUODOBOIT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6530,'NS','UPPER NINE MILE RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6531,'NS','UPPER NORTH RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6532,'NS','UPPER NORTH SYDNEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6533,'NS','UPPER NORTHFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6534,'NS','UPPER ONSLOW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6535,'NS','UPPER PORT LA TOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6536,'NB','UPPER QUEENSBURY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6537,'NS','UPPER RAWDON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6538,'NB','UPPER REXTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6539,'NB','UPPER ROCKPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6540,'NB','UPPER SACKVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6541,'NS','UPPER SACKVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6542,'NB','UPPER SALMON CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6543,'NS','UPPER STEWIACKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6544,'NS','UPPER TANTALLON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6545,'NB','UPPER TRACY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6546,'NS','UPPER WASHABUCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6547,'NB','UPPER WOODSTOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6548,'NB','UPPERTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6549,'ON','UPSALA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6550,'NB','UPSALQUITCH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6551,'QC','UPTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6552,'SK','URANIUM CITY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6553,'NS','URBANIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6554,'NB','UTOPIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6555,'ON','UTOPIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6556,'ON','UTTERSON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6557,'ON','UXBRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6558,'ON','VAL CARON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6559,'NB','VAL COMEAU','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6560,'ON','VAL COTE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6561,'ON','VAL GAGNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6562,'SK','VAL MARIE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6563,'ON','VAL RITA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6564,'ON','VAL THERESE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6565,'QC','VAL-ALAIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6566,'QC','VAL-BRILLANT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6567,'NB','VAL-D\'AMOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6568,'QC','VAL-D\'ESPOIR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6569,'QC','VAL-D\'OR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6570,'QC','VAL-DAVID','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6571,'QC','VAL-DES-BOIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6572,'QC','VAL-DES-LACS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6573,'QC','VAL-DES-MONTS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6574,'NB','VAL-DOUCET','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6575,'QC','VAL-JOLI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6576,'QC','VAL-MORIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6577,'QC','VAL-PARADIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6578,'QC','VAL-RACINE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6579,'QC','VAL-SAINT-GILLES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6580,'QC','VALCOURT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6581,'BC','VALEMOUNT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6582,'AB','VALHALLA CENTRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6583,'QC','VALLEE-JONCTION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6584,'NL','VALLEY POND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6585,'MB','VALLEY RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6586,'NB','VALLEY ROAD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6587,'NS','VALLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6588,'AB','VALLEYVIEW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6589,'BC','VAN ANDA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6590,'BC','VANCOUVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6591,'BC','VANDERHOOF','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6592,'ON','VANESSA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6593,'SK','VANGUARD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6594,'ON','VANIER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6595,'ON','VANKLEEK HILL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6596,'SK','VANSCOY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6597,'QC','VARENNES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6598,'ON','VARNA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6599,'ON','VARS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6600,'MB','VASSAR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6601,'QC','VAUDREUIL-DORION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6602,'QC','VAUDREUIL-SUR-LE-LAC','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6603,'ON','VAUGHAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6604,'AB','VAUXHALL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6605,'BC','VAVENBY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6606,'SK','VAWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6607,'AB','VEGA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6608,'AB','VEGREVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6609,'QC','VENISE-EN-QUEBEC','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6610,'QC','VENOSTA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6611,'QC','VERCHERES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6612,'QC','VERDUN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6613,'SK','VEREGIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6614,'MB','VERMETTE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6615,'ON','VERMILION BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6616,'AB','VERMILION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6617,'ON','VERNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6618,'PE','VERNON BRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6619,'BC','VERNON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6620,'ON','VERNON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6621,'ON','VERONA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6622,'NB','VERRET','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6623,'SK','VERWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6624,'NB','VESPRA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6625,'AB','VETERAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6626,'SK','VIBANK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6627,'SK','VICEROY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6628,'SK','VICTOIRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6629,'MB','VICTORIA BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6630,'NL','VICTORIA CB','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6631,'NB','VICTORIA CORNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6632,'NL','VICTORIA COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6633,'ON','VICTORIA HARBOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6634,'NS','VICTORIA MINES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6635,'BC','VICTORIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6636,'PE','VICTORIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6637,'QC','VICTORIAVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6638,'SK','VIDORA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6639,'ON','VIENNA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6640,'AB','VIKING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6641,'NB','VILLAGE BLANCHARD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6642,'QC','VILLAGE SAINT-PIERRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6643,'NB','VILLAGE-DES-POIRIER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6644,'NB','VILLAGE-SAINT-LAURENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6645,'QC','VILLE-MARIE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6646,'QC','VILLEBOIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6647,'QC','VILLEROY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6648,'AB','VILNA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6649,'QC','VIMONT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6650,'AB','VIMY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6651,'NB','VINEGAR HILL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6652,'ON','VINELAND STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6653,'ON','VINELAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6654,'MB','VIRDEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6655,'ON','VIRGIL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6656,'ON','VIRGINIATOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6657,'SK','VISCOUNT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6658,'MB','VISTA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6659,'MB','VITA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6660,'ON','VITTORIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6661,'MB','VOGAR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6662,'SK','VONDA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6663,'AB','VULCAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6664,'NB','WAASIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6665,'AB','WABAMUN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6666,'AB','WABASCA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6667,'ON','WABIGOON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6668,'MB','WABOWDEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6669,'NL','WABUSH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6670,'SK','WADENA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6671,'NS','WAGMATCOOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6672,'ON','WAHNAPITAE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6673,'ON','WAINFLEET','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6674,'AB','WAINWRIGHT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6675,'SK','WAKAW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6676,'NB','WAKEFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6677,'QC','WAKEFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6678,'SK','WALDECK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6679,'MB','WALDERSEE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6680,'SK','WALDHEIM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6681,'ON','WALDHOF','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6682,'SK','WALDRON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6683,'ON','WALFORD STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6684,'BC','WALHACHIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6685,'NB','WALKER SETTLEMENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6686,'ON','WALKERTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6687,'NS','WALLACE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6688,'ON','WALLACEBURG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6689,'ON','WALLACETOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6690,'ON','WALLENSTEIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6691,'AB','WALSH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6692,'ON','WALSINGHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6693,'ON','WALTERS FALLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6694,'QC','WALTHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6695,'NS','WALTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6696,'ON','WALTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6697,'AB','WANDERING RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6698,'AB','WANHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6699,'MB','WANIPIGOW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6700,'MB','WANLESS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6701,'SK','WAPELLA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6702,'NB','WAPSKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6703,'AB','WARBURG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6704,'NB','WARD SETTLEMENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6705,'QC','WARDEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6706,'AB','WARDLOW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6707,'BC','WARDNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6708,'NB','WARDS CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6709,'ON','WARDSVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6710,'BC','WARE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6711,'NL','WAREHAM-CENTREVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6712,'ON','WARKWORTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6713,'SK','WARMAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6714,'ON','WARMINSTER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6715,'AB','WARNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6716,'MB','WARREN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6717,'ON','WARREN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6718,'ON','WARSAW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6719,'AB','WARSPITE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6720,'NB','WARWICK SETTLEMENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6721,'QC','WARWICK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6722,'BC','WASA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6723,'ON','WASAGA BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6724,'MB','WASAGAMACK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6725,'MB','WASAGAMING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6726,'SK','WASECA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6727,'NS','WASHABUCK CENTRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6728,'ON','WASHAGO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6729,'MB','WASKADA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6730,'QC','WASKAGANISH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6731,'AB','WASKATENAU','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6732,'SK','WASKESIU LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6733,'QC','WASWANIPI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6734,'AB','WATER VALLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6735,'NB','WATERBOROUGH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6736,'ON','WATERDOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6737,'NB','WATERFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6738,'ON','WATERFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6739,'SK','WATERHEN LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6740,'MB','WATERHEN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6741,'NS','WATERLOO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6742,'ON','WATERLOO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6743,'QC','WATERLOO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6744,'NB','WATERSIDE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6745,'AB','WATERTON PARK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6746,'NB','WATERVILLE CARLETON CO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6747,'NS','WATERVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6748,'QC','WATERVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6749,'NB','WATERVILLE-SUNBURY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6750,'ON','WATFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6751,'AB','WATINO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6752,'SK','WATROUS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6753,'YT','WATSON LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6754,'SK','WATSON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6755,'ON','WAUBAUSHENE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6756,'SK','WAUCHOPE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6757,'NS','WAVERLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6758,'ON','WAWA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6759,'MB','WAWANESA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6760,'NB','WAWEIG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6761,'SK','WAWOTA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6762,'NB','WAYERTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6763,'MB','WAYWAYSEECAPPO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6764,'ON','WEAGAMOW LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6765,'NB','WEAVER SIDING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6766,'NB','WEAVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6767,'SK','WEBB','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6768,'ON','WEBBWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6769,'ON','WEBEQUIE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6770,'NS','WEDGEPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6771,'QC','WEEDON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6772,'SK','WEEKES','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6773,'SK','WEIRDALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6774,'NT','WEKWETI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6775,'NB','WELDON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6776,'SK','WELDON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6777,'ON','WELLAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6778,'ON','WELLANDPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6779,'ON','WELLESLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6780,'AB','WELLING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6781,'PE','WELLINGTON STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6782,'NS','WELLINGTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6783,'ON','WELLINGTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6784,'BC','WELLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6785,'MB','WELLWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6786,'NB','WELSFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6787,'NB','WELSHPOOL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6788,'SK','WELWYN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6789,'AB','WEMBLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6790,'QC','WEMINDJI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6791,'QC','WEMOTACI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6792,'QC','WENDAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6793,'ON','WENDOVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6794,'NS','WENTWORTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6795,'QC','WENTWORTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6796,'QC','WENTWORTH-NORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6797,'NS','WENTZELLS LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6798,'NL','WESLEYVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6799,'NS','WEST ARICHAT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6800,'AB','WEST BAPTISTE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6801,'NL','WEST BAY CENTRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6802,'NS','WEST BAY ROAD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6803,'NS','WEST BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6804,'SK','WEST BEND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6805,'NB','WEST BRANCH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6806,'QC','WEST BROME','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6807,'NS','WEST CLIFFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6808,'NS','WEST DOVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6809,'NB','WEST FLORENCEVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6810,'ON','WEST GUILFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6811,'NS','WEST INDIAN ROAD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6812,'BC','WEST KELOWNA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6813,'ON','WEST LORNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6814,'ON','WEST MONTROSE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6815,'NS','WEST NORTHFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6816,'NS','WEST PENNANT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6817,'NS','WEST PORTERS LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6818,'NS','WEST PUBNICO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6819,'NB','WEST QUACO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6820,'NS','WEST RIVER STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6821,'NB','WEST RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6822,'NS','WEST ST ANDREWS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6823,'NL','WEST ST MODESTE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6824,'MB','WEST ST PAUL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6825,'BC','WEST VANCOUVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6826,'BC','WESTBANK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6827,'MB','WESTBOURNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6828,'BC','WESTBRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6829,'ON','WESTBROOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6830,'QC','WESTBURY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6831,'NS','WESTCHESTER STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6832,'NB','WESTCOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6833,'NL','WESTERN BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6834,'NS','WESTERN SHORE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6835,'AB','WESTEROSE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6836,'BC','WESTHOLME','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6837,'AB','WESTLOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6838,'ON','WESTMEATH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6839,'NS','WESTMOUNT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6840,'QC','WESTMOUNT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6841,'NB','WESTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6842,'NS','WESTPHAL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6843,'NL','WESTPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6844,'NS','WESTPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6845,'ON','WESTPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6846,'NS','WESTVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6847,'BC','WESTWOLD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6848,'ON','WESTWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6849,'AB','WETASKIWIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6850,'SK','WEYAKWIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6851,'SK','WEYBURN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6852,'NS','WEYMOUTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6853,'NU','WHALE COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6854,'BC','WHALETOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6855,'NT','WHATI','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6856,'ON','WHEATLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6857,'NB','WHEATON SETTLEMENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6858,'SK','WHELAN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6859,'AB','WHISPERING HILLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6860,'BC','WHISTLER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6861,'NL','WHITBOURNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6862,'ON','WHITBY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6863,'SK','WHITE BEAR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6864,'SK','WHITE CITY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6865,'SK','WHITE FOX','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6866,'AB','WHITE GULL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6867,'NB','WHITE HEAD ISLAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6868,'NB','WHITE HEAD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6869,'ON','WHITE LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6870,'NB','WHITE RAPIDS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6871,'ON','WHITE RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6872,'BC','WHITE ROCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6873,'SK','WHITECAP','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6874,'AB','WHITECOURT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6875,'ON','WHITEDOG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6876,'ON','WHITEFISH FALLS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6877,'ON','WHITEFISH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6878,'YT','WHITEHORSE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6879,'AB','WHITELAW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6880,'MB','WHITEMOUTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6881,'NB','WHITES BROOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6882,'NB','WHITES COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6883,'NS','WHITES LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6884,'NB','WHITES MOUNTAIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6885,'MB','WHITESHELL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6886,'ON','WHITEVALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6887,'NL','WHITEWAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6888,'SK','WHITEWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6889,'NB','WHITNEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6890,'ON','WHITNEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6891,'NS','WHYCOCOMAGH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6892,'NS','WHYNOTTS SETTLEMENT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6893,'ON','WIARTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6894,'NB','WICKHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6895,'QC','WICKHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6896,'NB','WICKLOW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6897,'AB','WIDEWATER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6898,'NB','WIGGINS MILL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6899,'ON','WIKWEMIKONG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6900,'ON','WILBERFORCE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6901,'SK','WILCOX','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6902,'NL','WILD COVE WB','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6903,'AB','WILDWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6904,'NS','WILEVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6905,'ON','WILKESPORT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6906,'SK','WILKIE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6907,'NL','WILLIAMS HARBOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6908,'BC','WILLIAMS LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6909,'NB','WILLIAMSBURG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6910,'ON','WILLIAMSBURG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6911,'ON','WILLIAMSFORD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6912,'NB','WILLIAMSTOWN CARLETON CO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6913,'NB','WILLIAMSTOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6914,'ON','WILLIAMSTOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6915,'NS','WILLIAMSWOOD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6916,'AB','WILLINGDON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6917,'ON','WILLOW BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6918,'SK','WILLOW BUNCH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6919,'NB','WILLOW GROVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6920,'BC','WILLOW RIVER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6921,'SK','WILLOWBROOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6922,'NS','WILMOT STATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6923,'NB','WILMOT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6924,'ON','WILMOT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6925,'ON','WILNO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6926,'NB','WILSONS BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6927,'ON','WILSONVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6928,'NL','WILTONDALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6929,'AB','WIMBORNE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6930,'ON','WINCHESTER SPRINGS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6931,'ON','WINCHESTER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6932,'BC','WINDERMERE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6933,'ON','WINDERMERE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6934,'ON','WINDHAM CENTRE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6935,'NS','WINDSOR JUNCTION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6936,'NB','WINDSOR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6937,'NS','WINDSOR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6938,'ON','WINDSOR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6939,'QC','WINDSOR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6940,'SK','WINDTHORST','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6941,'AB','WINFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6942,'BC','WINFIELD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6943,'ON','WINGHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6944,'NL','WINGS POINT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6945,'MB','WINKLER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6946,'BC','WINLAW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6947,'MB','WINNIPEG BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6948,'MB','WINNIPEG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6949,'MB','WINNIPEGOSIS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6950,'PE','WINSLOE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6951,'BC','WINTER HARBOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6952,'NL','WINTERLAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6953,'NL','WINTERTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6954,'NB','WIRRAL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6955,'SK','WISETON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6956,'SK','WISHART','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6957,'NL','WITLESS BAY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6958,'NS','WITTENBURG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6959,'QC','WOBURN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6960,'AB','WOKING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6961,'ON','WOLFE ISLAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6962,'NS','WOLFVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6963,'QC','WOLINAK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6964,'SK','WOLLASTON LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6965,'SK','WOLSELEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6966,'BC','WONOWON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6967,'SK','WOOD MOUNTAIN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6968,'NB','WOOD POINT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6969,'ON','WOODBRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6970,'NL','WOODFORDS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6971,'ON','WOODHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6972,'MB','WOODLANDS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6973,'NB','WOODLANDS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6974,'ON','WOODLAWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6975,'NB','WOODMANS POINT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6976,'MB','WOODMORE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6977,'MB','WOODRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6978,'SK','WOODROW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6979,'MB','WOODSIDE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6980,'NB','WOODSIDE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6981,'NB','WOODSTOCK FIRST NATION','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6982,'NB','WOODSTOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6983,'NL','WOODSTOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6984,'ON','WOODSTOCK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6985,'ON','WOODVIEW','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6986,'ON','WOODVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6987,'ON','WOOLER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6988,'AB','WORSLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6989,'ON','WORTHINGTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6990,'BC','WOSS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6991,'AB','WOSTOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6992,'QC','WOTTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6993,'AB','WRENTHAM','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6994,'NT','WRIGLEY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6995,'ON','WROXETER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6996,'SK','WROXTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6997,'NB','WUHRS BEACH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6998,'ON','WUNNUMIN LAKE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(6999,'ON','WYEBRIDGE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7000,'NB','WYERS BROOK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7001,'ON','WYEVALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7002,'SK','WYMARK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7003,'BC','WYNNDEL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7004,'SK','WYNYARD','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7005,'ON','WYOMING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7006,'NS','WYSES CORNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7007,'BC','YAHK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7008,'BC','YALE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7009,'QC','YAMACHICHE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7010,'QC','YAMASKA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7011,'QC','YAMASKA-EST','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7012,'SK','YARBO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7013,'ON','YARKER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7014,'NS','YARMOUTH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7015,'SK','YELLOW CREEK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7016,'SK','YELLOW GRASS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7017,'SK','YELLOW QUILL','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7018,'NT','YELLOWKNIFE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7019,'BC','YMIR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7020,'NB','YOHO','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7021,'NL','YORK HARBOUR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7022,'MB','YORK LANDING','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7023,'ON','YORK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7024,'PE','YORK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7025,'ON','YORK.','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7026,'SK','YORKTON','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7027,'BC','YOUBOU','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7028,'SK','YOUNG','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7029,'NB','YOUNGS COVE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7030,'ON','YOUNGS POINT','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7031,'AB','YOUNGSTOWN','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7032,'AB','ZAMA CITY','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7033,'NB','ZEALAND','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7034,'SK','ZEALANDIA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7035,'BC','ZEBALLOS','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7036,'SK','ZEHNER','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7037,'SK','ZENON PARK','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7038,'ON','ZEPHYR','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7039,'MB','ZHODA','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7040,'NB','ZIONVILLE','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN'),(7041,'ON','ZURICH','2023-07-10 21:44:36','2023-07-10 21:44:36','CAN');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `countries_name_unique` (`name`),
  UNIQUE KEY `countries_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (3,'Others','OTHER',NULL,NULL),(4,'Canada','CAN',NULL,NULL);

--
-- Table structure for table `device_logs`
--

CREATE TABLE `device_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_id` int NOT NULL,
  `type` tinyint NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modified_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `device_logs`
--

INSERT INTO `device_logs` VALUES (1,'F07011',1,1,'Hoist frame cracked','Ha Doan Ngoc','Ha Doan Ngoc','2023-06-22 02:21:47','2023-06-22 02:21:47'),(2,'F07012',1,1,'Hoist will not freewheel','Ha Doan Ngoc','Ha Doan Ngoc','2023-06-22 02:21:47','2023-06-22 02:21:47'),(3,'',1,1,'Hoist hooks opened.','Ha Doan Ngoc','Ha Doan Ngoc','2023-06-22 02:21:47','2023-06-22 02:21:47'),(4,'',4,2,'Hoist overheats','Ha Doan Ngoc','Ha Doan Ngoc','2023-06-22 02:21:47','2023-06-22 02:21:47');

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` blob,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mfg` timestamp NULL DEFAULT NULL,
  `load` int NOT NULL,
  `lifting_height` double(8,2) DEFAULT NULL,
  `duty_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `control` int NOT NULL,
  `frequency` int NOT NULL,
  `main_voltage` int NOT NULL,
  `control_voltage` int NOT NULL,
  `braking` int NOT NULL,
  `hoisting_cycle` int NOT NULL,
  `start` int NOT NULL,
  `running_time` int NOT NULL,
  `temperature` double(8,2) NOT NULL,
  `site_id` int NOT NULL,
  `admin_id` json DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `modified_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `devices`
--

INSERT INTO `devices` VALUES (1,'CM Lodestar VS',NULL,'','BDHKSM463','electric-chain',NULL,2,NULL,'h2',520000,0,0,0,1000000,0,320000,3200,55.00,1,NULL,0,'Doan Ngoc Ha','Doan Ngoc Ha','2023-06-19 04:19:43','2023-06-22 02:00:10'),(2,'Shaw Box SK',NULL,'','BDHJ43XS','wire-rope-hoists',NULL,2,NULL,'h3',720000,0,0,0,1000000,0,560000,3200,56.00,2,NULL,1,'Doan Ngoc Ha','Doan Ngoc Ha','2023-06-19 04:20:18','2023-06-22 02:00:25'),(3,'Yale YK Y80. Cable King',NULL,'FGDJS444','BDHKSMK4D','wire-rope-hoists',NULL,1,10000.00,'h3',640000,60,220,110,1000000,64000,480000,32000,60.00,1,'{\"staff\": \"3\", \"Duong Nguyen\": \"2\", \"Site manager\": \"4\"}',1,'Doan Ngoc Ha','Doan Ngoc Ha','2023-06-19 04:31:01','2023-07-12 21:16:25'),(4,'Lodeking LT',_binary '[BLOB]','gfdg','HNDKD45','wire-rope-hoists',NULL,3,444.00,'h2',64000,4,44,40,1000000,0,480000,3200,404.00,3,'{\"Duong Nguyen\": \"2\"}',1,'Doan Ngoc Ha','Doan Ngoc Ha','2023-06-19 04:31:50','2023-07-16 21:12:52'),(7,'Device Site 7',NULL,'vcx345','432','manual-power',NULL,54,54.00,'h1',545,45,5,545,545,4,543,34,54.00,7,'{\"staff\": \"3\"}',1,'Site manager','Site manager','2023-07-17 00:50:20','2023-07-17 00:50:20');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `maintenances`
--

CREATE TABLE `maintenances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `device_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `inspection_date` timestamp NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `related_event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maintenances`
--

INSERT INTO `maintenances` VALUES (1,1,1,'Reason','Note','2023-07-05 17:00:00','','',0,'2023-07-04 21:20:16','2023-07-04 21:26:13'),(2,4,2,'reason','note','2023-07-05 17:00:00','init_inspection','F07011',1,'2023-07-04 21:23:10','2023-07-13 01:38:28');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2014_10_12_200000_add_two_factor_columns_to_users_table',1),(4,'2015_04_12_000000_create_orchid_users_table',1),(5,'2015_10_19_214424_create_orchid_roles_table',1),(6,'2015_10_19_214425_create_orchid_role_users_table',1),(7,'2016_08_07_125128_create_orchid_attachmentstable_table',1),(8,'2017_09_17_125801_create_notifications_table',1),(9,'2019_08_19_000000_create_failed_jobs_table',1),(10,'2019_12_14_000001_create_personal_access_tokens_table',1),(11,'2023_02_23_071333_create_sessions_table',1),(12,'2023_02_23_103528_create_posts_table',1),(13,'2023_03_07_135009_create_tasks_table',1),(14,'2023_03_08_074300_update_task_database',1),(15,'2023_04_25_164300_create_site_table',1),(16,'2023_05_09_031252_update_site_table',1),(17,'2023_05_10_074032_update_enum_sitetable',2),(18,'2023_05_11_065137_add_site_status',3),(19,'2023_05_16_073433_new_user_profile_info',4),(20,'2023_05_16_093747_add_user_status',5),(21,'2023_06_22_042902_alter_devices_table_3',6),(22,'2023_06_22_044755_alter_devices_table_4',7),(23,'2023_06_26_102013_alter_devices_table_5',8),(24,'2023_06_26_102611_alter_devices_table_5',9),(25,'2023_06_27_043838_alter_sites_table_3',10),(26,'2023_06_29_030540_create_device_logs_table',11),(27,'2023_06_16_122020_create_devices_table',12),(28,'2023_06_19_090437_alter_devices_table',12),(29,'2023_06_19_104345_alter_devices_table_2',12),(30,'2023_06_29_102649_create_activity_log_table',12),(31,'2023_06_29_102650_add_event_column_to_activity_log_table',12),(32,'2023_06_29_102651_add_batch_uuid_column_to_activity_log_table',12),(33,'2023_07_04_093437_create_maintenance_table',13),(34,'2023_07_05_093437_create_maintenance_table',14),(35,'2023_07_07_085126_alter_user_table_add_device_column',15),(36,'2023_07_10_101750_remove_device_id_in_users_table',16),(37,'2023_07_10_105311_add_site_to_users_table',17),(38,'2023_07_11_032428_add_admin_to_sites_table',18),(39,'2023_07_11_033747_alter_sites_table',19),(40,'2023_07_11_041523_add_province_code_to_cities_table',20),(41,'2023_07_11_042610_remove_province_id_to_cities_table',21),(42,'2023_07_11_042809_remove_country_id_to_provinces_table',22),(43,'2023_07_12_023912_create_user_site_table',23),(44,'2023_07_13_015951_alter_devices_tables',24),(45,'2023_07_13_071037_alter_device_logs_table',25),(46,'2023_07_13_083437_alter_maintenances_table',26),(48,'2023_07_17_092948_create_site_users_table',27);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--


--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `provinces_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` VALUES (1,'Alberta','AB','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(2,'British Columbia','BC','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(3,'Manitoba','MB','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(4,'New Brunswick','NB','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(5,'Newfoundland and Labrador','NL','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(6,'Nova Scotia','NS','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(7,'Ontario','ON','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(8,'Prince Edward Island','PE','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(9,'Quebec','QC','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN'),(10,'Saskatchewan','SK','2023-07-10 21:31:46','2023-07-10 21:31:46','CAN');

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` bigint unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_users_role_id_foreign` (`role_id`),
  CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--

INSERT INTO `role_users` VALUES (1,1),(13,2),(14,3);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super-admin','Super Admin','{\"platform.index\": \"1\", \"platform.dashboard.sm\": \"0\", \"platform.systems.roles\": \"1\", \"platform.systems.users\": \"1\", \"platform.dashboard.admin\": \"1\", \"platform.dashboard.staff\": \"0\", \"platform.modules.devices\": \"1\", \"platform.systems.activity\": \"1\", \"platform.modules.sites.view\": \"1\", \"platform.systems.attachment\": \"1\", \"platform.modules.devices.view\": \"1\", \"platform.modules.sites.create\": \"1\", \"platform.modules.devices.create\": \"1\"}','2023-05-09 17:23:46','2023-07-10 20:02:40'),(2,'site-manager','Site Manager','{\"platform.index\": \"1\", \"platform.dashboard.sm\": \"1\", \"platform.modules.sites\": \"1\", \"platform.systems.roles\": \"0\", \"platform.systems.users\": \"1\", \"platform.dashboard.admin\": \"0\", \"platform.dashboard.staff\": \"0\", \"platform.modules.devices\": \"1\", \"platform.systems.activity\": \"1\", \"platform.modules.sites.view\": \"1\", \"platform.systems.attachment\": \"1\", \"platform.modules.sites.create\": \"0\"}','2023-05-09 17:24:41','2023-07-10 20:00:04'),(3,'staff','Staff','{\"platform.index\": \"1\", \"platform.dashboard.sm\": \"0\", \"platform.modules.sites\": \"0\", \"platform.systems.roles\": \"0\", \"platform.systems.users\": \"0\", \"platform.dashboard.admin\": \"0\", \"platform.dashboard.staff\": \"1\", \"platform.modules.devices\": \"1\", \"platform.systems.activity\": \"0\", \"platform.systems.attachment\": \"0\"}','2023-06-28 03:27:21','2023-07-10 03:21:16');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `site_users`
--

CREATE TABLE `site_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_id` int NOT NULL,
  `user_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_users`
--

INSERT INTO `site_users` VALUES (1,3,12,'2023-07-17 04:07:56','2023-07-17 04:07:56'),(2,3,13,'2023-07-17 04:10:56','2023-07-17 04:10:56'),(3,3,14,'2023-07-18 01:05:13','2023-07-18 01:05:13'),(4,1,1,'2023-07-18 20:33:28','2023-07-18 20:33:28');

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `site_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `admin_id` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` blob,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `working_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sites_site_code_unique` (`site_code`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` VALUES (1,'S001','Canada Construction Limited','Công ty cổ phần công nghệ Coming',0,0,'So 7 ngach Khuong Trung','Đoàn Ngọc Hà','090512341234',_binary '[BLOB]','2023-05-09 01:27:22','2023-06-26 04:16:05','',NULL,NULL,NULL),(2,'S002','CANA Group of Companies','adsf asdf asdf asd fasd fasdf asdf ads fasdf',0,1,'So 7 ngach 211/249 Khuong Trung, Thanh Xuan, Ha Noi','DOAN NGOC HA','0901234231',_binary '[BLOB]','2023-05-09 08:15:01','2023-06-29 04:04:46','Construction',NULL,NULL,NULL),(3,'S003','Tacc Construction Ltd a','asdf asdf á fasd fasd fasd fasd fasd fasdf á',13,0,'Toronto ABC','Doan Ngoc Ha','0901234231',_binary '[BLOB]','2023-05-12 01:12:45','2023-07-18 03:32:29','Construction','CAN',NULL,NULL),(4,'SSS4C_SITE_4','Site 4',NULL,4,1,'ac',NULL,NULL,NULL,'2023-07-10 20:42:13','2023-07-10 20:42:13','Construction',NULL,NULL,NULL),(5,'SSS4C_SITE_5','Site 5',NULL,2,1,'sdfsaf',NULL,NULL,NULL,'2023-07-11 00:49:39','2023-07-11 00:49:39','Transport and Warehousing','CAN',NULL,NULL),(6,'SSS4C_SITE_6','Site 6',NULL,3,1,'fd',NULL,NULL,NULL,'2023-07-11 00:51:17','2023-07-11 00:51:17','Transport and Warehousing','CAN',NULL,NULL),(7,'SSS4C_SITE_7','Site 7',NULL,4,1,'anc',NULL,NULL,NULL,'2023-07-11 00:54:51','2023-07-16 21:25:09','Construction','CAN',NULL,NULL),(9,'SSS4C_SITE_8','site 8',NULL,2,1,'abc',NULL,NULL,NULL,'2023-07-16 21:24:58','2023-07-16 21:24:58','Construction','CAN',NULL,NULL);

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tasks`
--



