SF.net SVN: ledger-smb:[6000] trunk

[..hidden..]

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

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

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2013-09-12 10:50:35 UTC (rev 5999)
+++ trunk/Changelog	2013-09-12 11:01:48 UTC (rev 6000)
@@ -94,6 +94,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: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2013-09-12 10:50:35 UTC (rev 5999)
+++ trunk/sql/Pg-database.sql	2013-09-12 11:01:48 UTC (rev 6000)
@@ -671,7 +671,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: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2013-09-12 10:50:35 UTC (rev 5999)
+++ trunk/sql/modules/Fixes.sql	2013-09-12 11:01:48 UTC (rev 6000)
@@ -193,3 +193,7 @@
 
 -- Required for parameter rename
 DROP FUNCTION pricelist__delete(int,int);
+
+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