adding "within_city_limits" bool column
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 17 Feb 2006 04:08:52 +0000 (04:08 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 17 Feb 2006 04:08:52 +0000 (04:08 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@3101 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/actor.pm
Open-ILS/src/sql/Pg/005.schema.actors.sql

index d45267c..910d6d6 100644 (file)
@@ -132,7 +132,8 @@ use base qw/actor/;
 __PACKAGE__->table( 'actor_usr_address' );
 __PACKAGE__->columns( Primary => qw/id/ );
 __PACKAGE__->columns( Essential => qw/valid address_type usr street1 street2
-                                     city county state country post_code/ );
+                                     city county state country post_code
+                                     within_city_limits/ );
 
 #-------------------------------------------------------------------------------
 package actor::org_address;
index 9746f08..4ef4c08 100644 (file)
@@ -421,17 +421,18 @@ CREATE INDEX actor_org_unit_setting_usr_idx ON actor.org_unit_setting (org_unit)
 
 
 CREATE TABLE actor.usr_address (
-       id              SERIAL  PRIMARY KEY,
-       valid           BOOL    NOT NULL DEFAULT TRUE,
-       address_type    TEXT    NOT NULL DEFAULT 'MAILING',
-       usr             INT     NOT NULL REFERENCES actor.usr (id),
-       street1         TEXT    NOT NULL,
-       street2         TEXT,
-       city            TEXT    NOT NULL,
-       county          TEXT,
-       state           TEXT    NOT NULL,
-       country         TEXT    NOT NULL,
-       post_code       TEXT    NOT NULL
+       id                      SERIAL  PRIMARY KEY,
+       valid                   BOOL    NOT NULL DEFAULT TRUE,
+       within_city_limits      BOOL    NOT NULL DEFAULT TRUE,
+       address_type            TEXT    NOT NULL DEFAULT 'MAILING',
+       usr                     INT     NOT NULL REFERENCES actor.usr (id),
+       street1                 TEXT    NOT NULL,
+       street2                 TEXT,
+       city                    TEXT    NOT NULL,
+       county                  TEXT,
+       state                   TEXT    NOT NULL,
+       country                 TEXT    NOT NULL,
+       post_code               TEXT    NOT NULL
 );
 
 CREATE INDEX actor_usr_addr_usr_idx ON actor.usr_address (usr);