From 1de8dc459305436bb29a46804cc21763bd99e36d Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Thu, 4 Jan 2018 00:07:29 +0000
Subject: [PATCH] share/sql/zipcode.sql

---
 share/db/timezone         | 1 -
 share/{db => sql}/zipcode | 8 ++++++++
 2 files changed, 8 insertions(+), 1 deletion(-)
 rename share/{db => sql}/zipcode (75%)

diff --git a/share/db/timezone b/share/db/timezone
index 7c1f5155..07238622 100755
--- a/share/db/timezone
+++ b/share/db/timezone
@@ -8,7 +8,6 @@ while (<>) {
 	next unless $i++;
 	chomp($_);
 	@_ = (split("\t",$_))[1,2,3,4];
-	#push @_,0 if (@_<4);
 	#$_[1] = join("\t",reverse split('/',$_[1]));
 	print join ("\t",@_)."\n";
 }
diff --git a/share/db/zipcode b/share/sql/zipcode
similarity index 75%
rename from share/db/zipcode
rename to share/sql/zipcode
index c9ce2559..c91bcc47 100755
--- a/share/db/zipcode
+++ b/share/sql/zipcode
@@ -7,6 +7,14 @@ use warnings;
 
 while (<>) {
 	chomp($_);
+	s,\\\t,\t,g; # fix error
 	@_ = split("\t",$_);
+	push @_,0 if (@_<12);
+
+	$_ = $_[0];
+	$_[0] = $_[1];
+	$_[1] = $_;
+	 
+
 	print join ("\t",@_)."\n";
 }
-- 
2.47.3