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

[..hidden..]

Revision: 1237
          http://svn.sourceforge.net/ledger-smb/?rev=1237&view=rev
Author:   linuxpoet
Date:     2007-05-23 12:44:05 -0700 (Wed, 23 May 2007)

Log Message:
-----------
added mailcode to location

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-22 19:07:28 UTC (rev 1236)
+++ trunk/sql/Pg-database.sql	2007-05-23 19:44:05 UTC (rev 1237)
@@ -63,7 +63,8 @@
   line_two text,
   line_three text,
   city_province text check (city_province ~ '[[:alnum:]_]') NOT NULL,
-  country_id integer not null REFERENCES country(id));
+  country_id integer not null REFERENCES country(id)
+  mail_code text not null check (mail_code ~ '[[:alnum:]_]'));
 
 CREATE TABLE company (
   id serial UNIQUE,


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