diff options
| author | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 19:31:56 +0000 |
|---|---|---|
| committer | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 19:31:56 +0000 |
| commit | c932c5daa39f40f59b31957aa672d0e5e41d510f (patch) | |
| tree | bedbd281b98c552cef4437a7d58b320e0706b63e /db/schema.sql | |
| parent | 3562fcd4dcd37db197f3fc448b7d2be408d1072b (diff) | |
Migrate alerts table
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql index ba5ce4121..fbff047fb 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -293,8 +293,8 @@ create table alert_type ( create table alert ( id serial not null primary key, alert_type text not null references alert_type(ref), - parameter text, -- e.g. Problem ID for new updates, Easting for local problem alerts - parameter2 text, -- e.g. Northing for local problem alerts + parameter text, -- e.g. Problem ID for new updates, Longitude for local problem alerts + parameter2 text, -- e.g. Latitude for local problem alerts email text not null, confirmed integer not null default 0, lang text not null default 'en-gb', |