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

Timestamp:

Oct 19, 2006, 8:22:01 AM (15 years ago)

Author:

Dominic Hargreaves

Message:

Add created_at to interest table

File:

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

trunk/npemap.org.uk/schema_postgres.sql

@@ -51 +51 @@
     scotland boolean default false,
     northernireland boolean default false,
-    ip inet
+    ip inet,
+    created_at timestamp without time zone NOT NULL default NOW()
 );