SF.net SVN: ledger-smb:[6001] branches/1.3

[..hidden..]

Revision: 6001
          http://sourceforge.net/p/ledger-smb/code/6001
Author:   einhverfr
Date:     2013-09-12 11:04:00 +0000 (Thu, 12 Sep 2013)
Log Message:
-----------
Dropping zip code null requirement.

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/Pg-database.sql
    branches/1.3/sql/modules/Fixes.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2013-09-12 11:01:48 UTC (rev 6000)
+++ branches/1.3/Changelog	2013-09-12 11:04:00 UTC (rev 6001)
@@ -9,6 +9,7 @@
 * Updated Hungarian translation (Pongracz I)
 * Fixed is_zero error on inventory activity report (Chris T)
 * Fixed bug 861, receipts saying "pay from" cash account (Chris T)
+* Dropped not null requirement on zip/mail codes (Chris T, 863)
 
 
 Changelog for 1.3.34

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2013-09-12 11:01:48 UTC (rev 6000)
+++ branches/1.3/sql/Pg-database.sql	2013-09-12 11:04:00 UTC (rev 6001)
@@ -642,7 +642,7 @@
   city text check (city ~ '[[:alnum:]_]') NOT NULL,
   state text check(state ~ '[[:alnum:]_]'),
   country_id integer not null REFERENCES country(id),
-  mail_code text not null check (mail_code ~ '[[:alnum:]_]'),
+  mail_code text check (mail_code ~ '[[:alnum:]_]'),
   created date not null default now(),
   inactive_date timestamp default null,
   active boolean not null default TRUE

Modified: branches/1.3/sql/modules/Fixes.sql
===================================================================
--- branches/1.3/sql/modules/Fixes.sql	2013-09-12 11:01:48 UTC (rev 6000)
+++ branches/1.3/sql/modules/Fixes.sql	2013-09-12 11:04:00 UTC (rev 6001)
@@ -634,3 +634,6 @@
 
 COMMIT;
 
+BEGIN;
+ALTER TABLE location ALTER COLUMN mail_code DROP NOT NULL;
+COMMIT;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits