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

[..hidden..]

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

Log Message:
-----------
Fixing db schema field names to match stored procedures (since those names are clearer anyway)

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-11-09 19:31:26 UTC (rev 1860)
+++ trunk/sql/Pg-database.sql	2007-11-09 19:35:33 UTC (rev 1861)
@@ -135,7 +135,7 @@
   line_two text,
   line_three text,
   city text check (city '[[:alnum:]_]') NOT NULL,
-  province text check(province '[[:alnum:]_]' NOT NULL),
+  state text check(state '[[: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.