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

Timestamp:

Oct 18, 2006, 10:59:39 PM (14 years ago)

Author:

Dominic Hargreaves

Message:

Initial bit of #18

File:

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

trunk/npemap.org.uk/schema_postgres.sql

@@ -46 +46 @@
 );
 
+-- Interest in future plans
+CREATE TABLE interest (
+    email character varying,
+    scotland boolean DEFAULT false,
+    northernireland boolean DEFAULT false
+)
+
 CREATE INDEX postcode_easting ON postcodes (easting);
 CREATE INDEX postcode_northing ON postcodes (northing);