SF.net SVN: ledger-smb:[6002] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 6002
          http://sourceforge.net/p/ledger-smb/code/6002
Author:   einhverfr
Date:     2013-09-12 11:05:23 +0000 (Thu, 12 Sep 2013)
Log Message:
-----------
Fixing regexp for checking mailcode per 863, only on trunk

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2013-09-12 11:04:00 UTC (rev 6001)
+++ trunk/sql/Pg-database.sql	2013-09-12 11:05:23 UTC (rev 6002)
@@ -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 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

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