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

[..hidden..]

Revision: 1860
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1860&view=rev
Author:   einhverfr
Date:     2007-11-09 11:31:26 -0800 (Fri, 09 Nov 2007)

Log Message:
-----------
Province (or state) is now distinct from city in terms of db stroage

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-11-09 04:01:15 UTC (rev 1859)
+++ trunk/sql/Pg-database.sql	2007-11-09 19:31:26 UTC (rev 1860)
@@ -134,7 +134,8 @@
   line_one text check (line_one ~ '[[:alnum:]_]') NOT NULL,
   line_two text,
   line_three text,
-  city_province text check (city_province ~ '[[:alnum:]_]') NOT NULL,
+  city text check (city '[[:alnum:]_]') NOT NULL,
+  province text check(province '[[:alnum:]_]' NOT NULL),
   country_id integer not null REFERENCES country(id),
   mail_code text not null check (mail_code ~ '[[:alnum:]_]'),
   created date not null,


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