Changeset 331 for trunk/npemap.org.uk/schema_postgres.sql

Timestamp:

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

Author:

Dominic Hargreaves

Message:

Add districts table with script to populate it.

File:

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

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);