Changeset 258


Ignore:
Timestamp:
Oct 31, 2006, 5:59:22 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Add columns to streamline the bad postcodes process

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/schema_postgres.sql

    r168 r258  
    3131    source integer NOT NULL,
    3232    deleted boolean NOT NULL default 'f',
     33    delete_reason integer
    3334
    3435        CONSTRAINT pk_postcode PRIMARY KEY (id),
     
    4344    reporter_email character varying,
    4445    created_at timestamp without time zone NOT NULL default NOW(),
     46    actioned boolean NOT NULL default 'f'
    4547
    4648    CONSTRAINT fk_postcode_id FOREIGN KEY (postcode) REFERENCES postcodes (id)
Note: See TracChangeset for help on using the changeset viewer.