Changeset 331

Timestamp:

Nov 5, 2006, 3:42:59 PM (15 years ago)

Author:

Dominic Hargreaves

Message:

Add districts table with script to populate it.

Location:

trunk/npemap.org.uk

Files:

• schema_postgres.sql (modified) (1 diff)
• scripts/postuk/import-postuk (added)

trunk/npemap.org.uk/schema_postgres.sql

@@ -67 +67 @@
 );
 
+-- Districts
+CREATE TABLE districts (
+    outward character varying(4) NOT NULL,
+    district character varying,
+    county character varying,
+
+    CONSTRAINT pk_district PRIMARY KEY (outward)
+);
+
 CREATE INDEX postcode_easting ON postcodes (easting);
 CREATE INDEX postcode_northing ON postcodes (northing);