Changeset 62

Timestamp:

Oct 16, 2006, 6:03:27 PM (15 years ago)

Author:

Dominic Hargreaves

Message:

Bad postcodes table (references #13)

File:

• trunk/npemap.org.uk/schema_postgres.sql (modified) (1 diff)

trunk/npemap.org.uk/schema_postgres.sql

@@ -34 +34 @@
 );
 
+-- Bad postcode reports
+CREATE TABLE bad_postcodes (
+    postcode integer NOT NULL,
+    ip inet,
+    reason character varying,
+    reporter_email character varying,
+    created_at timestamp without time zone NOT NULL default NOW(),
+
+    CONSTRAINT fk_postcode_id FOREIGN KEY (postcode) REFERENCES postcodes (id)
+);
+
 CREATE INDEX postcode_easting ON postcodes (easting);
 CREATE INDEX postcode_northing ON postcodes (northing);