Changeset 260


Ignore:
Timestamp:
Oct 31, 2006, 6:02:38 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Deletion reasons

File:
1 edited

Legend:

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

    r258 r260  
    5858);
    5959
     60CREATE sequence s_delete_reasons;
     61
     62-- Reasons for deletion
     63CREATE TABLE delete_reasons (
     64    id integer NOT NULL DEFAULT NEXTVAL('s_delete_reasons'),
     65    reason character varying
     66);
     67
    6068CREATE INDEX postcode_easting ON postcodes (easting);
    6169CREATE INDEX postcode_northing ON postcodes (northing);
Note: See TracChangeset for help on using the changeset viewer.