Changeset 62


Ignore:
Timestamp:
Oct 16, 2006, 6:03:27 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Bad postcodes table (references #13)

File:
1 edited

Legend:

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

    r36 r62  
    3434);
    3535
     36-- Bad postcode reports
     37CREATE TABLE bad_postcodes (
     38    postcode integer NOT NULL,
     39    ip inet,
     40    reason character varying,
     41    reporter_email character varying,
     42    created_at timestamp without time zone NOT NULL default NOW(),
     43
     44    CONSTRAINT fk_postcode_id FOREIGN KEY (postcode) REFERENCES postcodes (id)
     45);
     46
    3647CREATE INDEX postcode_easting ON postcodes (easting);
    3748CREATE INDEX postcode_northing ON postcodes (northing);
Note: See TracChangeset for help on using the changeset viewer.