From ae344ea5a2b4346d911d5af7cbc3ba4c54f08270 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 23 Dec 2004 08:32:03 +0000
Subject: [PATCH] allow NULL zip in some countries

---
 FS/bin/freeside-setup          | 4 ++--
 README.1.5.0pre7               | 3 +++
 httemplate/docs/upgrade10.html | 3 +++
 3 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index 1c5c3d204..c867a721f 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -463,7 +463,7 @@ sub tables_hash_hack {
         'city',     'varchar', '',     $char_d,
         'county',   'varchar', 'NULL', $char_d,
         'state',    'varchar', 'NULL', $char_d,
-        'zip',      'varchar', '',     10,
+        'zip',      'varchar', 'NULL', 10,
         'country',  'char', '',     2,
         'daytime',  'varchar', 'NULL', 20,
         'night',    'varchar', 'NULL', 20,
@@ -597,7 +597,7 @@ sub tables_hash_hack {
         'address2', 'varchar', 'NULL', $char_d,
         'city',     'varchar', '',     $char_d,
         'state',    'varchar', 'NULL', $char_d,
-        'zip',      'varchar', '',     10,
+        'zip',      'varchar', 'NULL', 10,
         'country',  'char', '',     2,
 #        'trancode', 'int', '', '',
         'cardnum',  'varchar', '',     16,
diff --git a/README.1.5.0pre7 b/README.1.5.0pre7
index b521d5d5e..dda49a76b 100644
--- a/README.1.5.0pre7
+++ b/README.1.5.0pre7
@@ -36,6 +36,9 @@ ALTER TABLE h_part_pkg ADD promo_code varchar(80) NULL;
 CREATE INDEX part_pkg2 ON part_pkg ( promo_code );
 CREATE INDEX h_part_pkg2 ON h_part_pkg ( promo_code );
 
+ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL;
+ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL;
+
 Installs w/integrated RT:
   CREATE SEQUENCE attributes_id_seq;
 
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
index 9e6418bf6..d8186858f 100644
--- a/httemplate/docs/upgrade10.html
+++ b/httemplate/docs/upgrade10.html
@@ -261,9 +261,12 @@ ALTER TABLE svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
 ALTER TABLE h_svc_forward ALTER COLUMN srcsvc DROP NOT NULL;
 ALTER TABLE svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
 ALTER TABLE h_svc_forward ALTER COLUMN dstsvc DROP NOT NULL;
+ALTER TABLE cust_main ALTER COLUMN zip DROP NOT NULL;
+ALTER TABLE h_cust_main ALTER COLUMN zip DROP NOT NULL;
 
 Or on Pg versions that don't support DROP NOT NULL (tested on 7.1 and 7.2 so far):
 UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'srcsvc' OR attname = 'dstsvc' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'svc_forward' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_svc_forward' ) );
+UPDATE pg_attribute SET attnotnull = FALSE WHERE ( attname = 'zip' ) AND ( attrelid = ( SELECT oid FROM pg_class WHERE relname = 'cust_main' ) OR attrelid = ( SELECT oid FROM pg_class WHERE relname = 'h_cust_main' ) );
 
 If you created your database with a version before 1.4.2, dump database, edit:
 - cust_main and h_cust_main: increase otaker from 8 to 32
-- 
2.11.0