aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Collapse)AuthorAgeLines
...
* Add cobrand field to alertslouise2009-09-02-1/+2
|
* Add cobrand field to store which version of the site problems and updates ↵louise2009-08-27-1/+3
| | | | came from
* Store site lang for reports, updates, alerts, so that future emails on themmatthew2009-07-10-1/+4
| | | | are in that language.
* Add new index.matthew2009-03-10-1/+2
|
* New index.root2008-11-10-1/+3
|
* Store service per problem, so can display it if we want.matthew2008-10-24-1/+2
|
* Switch flickr state to partial, tidy up code, so soon other things can use ↵matthew2008-10-09-5/+9
| | | | | | it too. Few text tweaks also, and other bits and bobs.
* TMS initial signup stuff.matthew2008-09-10-1/+7
|
* IDs too big for integer.matthew2008-05-06-2/+2
|
* Allow photo upload on updates.matthew2008-03-28-1/+2
|
* Store all voting areas of problems.matthew2007-08-24-2/+3
|
* Abuse.matthew2007-07-11-1/+7
|
* Stick problem_id in flickr_imported table too.matthew2007-06-18-2/+3
|
* New state for Flickr.matthew2007-06-17-1/+2
|
* Flickr FixMyStreet integration HackDay code. Quality variable.matthew2007-06-17-1/+13
|
* Change name from Neighbourhood Fix-It to FixMyStreet. Use Gaze formatthew2007-06-15-2/+2
| | | | | | | population density distance (same value as PB initially, might want changing). Changes to front page, text changes elsewhere, remove canonicalise_council as not needed any more, tidy code of confirmation page.
* If someone leaves an update on a problem, count that as "refreshing" thematthew2007-05-15-3/+3
| | | | | problem. Rename db field to lastupdate to make this all clearer. Tidy up some code.
* Record old/new state of problem in questionnaire table, to have informationmatthew2007-05-09-2/+5
| | | | to hand. Should have done this in the first place, sigh.
* Show basic info on questionnaires on admin pagefrancis2007-05-09-1/+3
|
* Add laststatechange field.matthew2007-05-09-1/+2
|
* NFI questionnaire code. Deals with sending out questionnaires, taking inmatthew2007-05-04-2/+11
| | | | | responses,updating problems, etc. What's left is front-end display issues such as timing out old problems, moving them to different lists, etc.
* Record confirmation time. Add explicit rollback()s to preventmatthew2007-05-03-1/+2
| | | | current_timestamp getting stuck after a begin.
* Allow people to not enter their name for updatesfrancis2007-04-30-2/+2
|
* Remove spurious part of comment accidentally left over from PLedgeBank ↵francis2007-04-23-4/+2
| | | | schema file.
* Start of multiple contacts in database, and admin interface.matthew2007-03-21-10/+8
|
* Have confirm flag in contacts table.matthew2007-02-08-2/+4
|
* Allow anonymous reports.matthew2007-02-08-1/+2
|
* Obviously can be null, for non-covered councils.matthew2007-02-02-2/+2
|
* Submitting to multiple councils, so might not be an integer any more.matthew2007-02-02-2/+2
|
* Record whether map is used, to change report sent to council.matthew2007-02-02-1/+2
|
* Referenced tables must be added before parents.matthew2007-02-02-34/+35
|
* RSS/email alerts for updates, local problems.matthew2007-01-26-3/+38
|
* Fix problem reporting without the map; other changes.matthew2007-01-24-2/+4
|
* First draft of council submission script.matthew2007-01-20-2/+3
|
* Deal with multiple councils, more error checking, tidy some code.matthew2007-01-19-1/+8
|
* Allow fixing of problems via updates, and reopening too.matthew2006-10-10-2/+4
|
* Add photo upload, few other fixes.matthew2006-10-10-1/+2
|
* Add optional phone box.matthew2006-10-09-1/+2
|
* Problems on map; problems within 10km; crappy crappy crappy IE.matthew2006-09-26-25/+9
|
* Email confirmation of problems and comments; bugfix in AuthToken.matthew2006-09-25-1/+10
|
* Tabs; insert stuff into the database.matthew2006-09-22-10/+8
|
* Let's use a database, and why not.matthew2006-09-22-18/+27
|
* E/N, not lat/long. Displaying of individual problems, with comments,matthew2006-09-21-3/+3
| | | | form for adding problems, marking problem on map.
* Remove message and alert tables, as we don't definitely need them, andfrancis2006-09-20-66/+1
| | | | I want to feel tidy before we forget what we do and don't use :)
* SQL trigger to preserve history of changes to the contacts tablefrancis2006-09-20-2/+42
|
* Fix syntax errors in schema.francis2006-09-20-19/+57
| | | | Put back warpable dates (bound to be needed in the end)
* Schema start.matthew2006-09-19-0/+202
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 21:24:45 +0000