Changeset 258

Timestamp:

Oct 31, 2006, 5:59:22 PM (14 years ago)

Author:

Dominic Hargreaves

Message:

Add columns to streamline the bad postcodes process

File:

• trunk/npemap.org.uk/schema_postgres.sql (modified) (2 diffs)

trunk/npemap.org.uk/schema_postgres.sql

@@ -31 +31 @@
     source integer NOT NULL,
     deleted boolean NOT NULL default 'f',
+    delete_reason integer
 
         CONSTRAINT pk_postcode PRIMARY KEY (id),
@@ -43 +44 @@
     reporter_email character varying,
     created_at timestamp without time zone NOT NULL default NOW(),
+    actioned boolean NOT NULL default 'f'
 
     CONSTRAINT fk_postcode_id FOREIGN KEY (postcode) REFERENCES postcodes (id)