Changeset 62
- Timestamp:
- Oct 16, 2006, 6:03:27 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/schema_postgres.sql
r36 r62 34 34 ); 35 35 36 -- Bad postcode reports 37 CREATE TABLE bad_postcodes ( 38 postcode integer NOT NULL, 39 ip inet, 40 reason character varying, 41 reporter_email character varying, 42 created_at timestamp without time zone NOT NULL default NOW(), 43 44 CONSTRAINT fk_postcode_id FOREIGN KEY (postcode) REFERENCES postcodes (id) 45 ); 46 36 47 CREATE INDEX postcode_easting ON postcodes (easting); 37 48 CREATE INDEX postcode_northing ON postcodes (northing);
Note: See TracChangeset
for help on using the changeset viewer.