Changeset 331


Ignore:
Timestamp:
Nov 5, 2006, 3:42:59 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Add districts table with script to populate it.

Location:
trunk/npemap.org.uk
Files:
1 added
1 edited

Legend:

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

    r317 r331  
    6767);
    6868
     69-- Districts
     70CREATE TABLE districts (
     71    outward character varying(4) NOT NULL,
     72    district character varying,
     73    county character varying,
     74
     75    CONSTRAINT pk_district PRIMARY KEY (outward)
     76);
     77
    6978CREATE INDEX postcode_easting ON postcodes (easting);
    7079CREATE INDEX postcode_northing ON postcodes (northing);
Note: See TracChangeset for help on using the changeset viewer.