aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Expand)AuthorAgeLines
* Add DB::Questionnaire (and update schema.sql with schema changes).Matthew Somerville2011-05-20-4/+6
* Add PK to 'abuse' tableEdmund von der Burg2011-04-15-2/+1
* Update contacts trigger, fix typo.Matthew Somerville2011-04-11-1/+1
* Merge branch 'master' into migrate_to_catalystEdmund von der Burg2011-04-08-0/+5
|\
| * Should be null as might not get set.Matthew Somerville2011-04-08-3/+3
| * Add external columns for problems, and show body if present in preference to ...Matthew Somerville2011-04-02-0/+5
* | Add back contacts changesEdmund von der Burg2011-04-05-0/+2
* | Moved schema changes back into the main schema file for deployEdmund von der Burg2011-04-04-2/+19
|/
* Migrate alerts tableEdmund von der Burg2011-02-07-2/+2
* Change the problem_find_nearby function.Edmund von der Burg2011-02-07-8/+24
* Migrate db - problems tableEdmund von der Burg2011-02-07-5/+5
* Add confirmed column to update table.Matthew Somerville2010-05-12-0/+1
* Some indices on the alert table.Matthew Somerville2010-05-12-1/+5
* Not unique index, could have multiple entries.Matthew Somerville2010-03-05-1/+1
* Adding simple logging of problem and update edits made in the admin interface.Louise Crow2010-02-08-0/+17
* Adding text and number constraints to cobrand fieldslouise2009-11-10-7/+7
* Adding field for extra data used by cobrandslouise2009-09-17-1/+4
* Add cobrand field to alertslouise2009-09-02-1/+2
* Add cobrand field to store which version of the site problems and updates cam...louise2009-08-27-1/+3
* Store site lang for reports, updates, alerts, so that future emails on themmatthew2009-07-10-1/+4
* 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 it...matthew2008-10-09-5/+9
* 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
* If someone leaves an update on a problem, count that as "refreshing" thematthew2007-05-15-3/+3
* Record old/new state of problem in questionnaire table, to have informationmatthew2007-05-09-2/+5
* 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
* Record confirmation time. Add explicit rollback()s to preventmatthew2007-05-03-1/+2
* Allow people to not enter their name for updatesfrancis2007-04-30-2/+2
* Remove spurious part of comment accidentally left over from PLedgeBank schema...francis2007-04-23-4/+2
* 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