Changeset 260

Timestamp:

Oct 31, 2006, 6:02:38 PM (15 years ago)

Author:

Dominic Hargreaves

Message:

Deletion reasons

File:

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

trunk/npemap.org.uk/schema_postgres.sql

@@ -58 +58 @@
 );
 
+CREATE sequence s_delete_reasons;
+
+-- Reasons for deletion
+CREATE TABLE delete_reasons (
+    id integer NOT NULL DEFAULT NEXTVAL('s_delete_reasons'),
+    reason character varying
+);
+
 CREATE INDEX postcode_easting ON postcodes (easting);
 CREATE INDEX postcode_northing ON postcodes (northing);