aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Collapse)AuthorAgeLines
...
* | add external id to comments tableStruan Donald2012-03-19-1/+2
|/
* Merge branch 'rss-addresses'Struan Donald2011-11-30-1/+2
|\ | | | | | | | | | | Conflicts: db/schema.sql perllib/FixMyStreet/DB/Result/Problem.pm
| * geocode column to bytea typeStruan Donald2011-09-19-1/+2
| |
* | Merge branch 'master' of ssh://git.mysociety.org/data/git/public/fixmystreet ↵Struan Donald2011-08-22-1/+19
|\| | | | | | | | | | | | | | | | | into open311-consumer Conflicts: t/app/model/problem.t templates/web/default/report/new/fill_in_details.html web/css/core.css
| * Merge branch 'master' of ssh://git.mysociety.org/data/git/public/fixmystreet ↵Struan Donald2011-08-17-2/+4
| |\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into new_statuses Conflicts: db/schema.sql perllib/FixMyStreet/App/Controller/Admin.pm perllib/FixMyStreet/DB/Result/User.pm t/app/controller/admin.t templates/web/default/admin/update_edit.html web/css/core.css
| * | another syntax errorStruan Donald2011-06-30-1/+1
| | |
| * | syntax errorStruan Donald2011-06-30-1/+1
| | |
| * | allow user changes to be loggedStruan Donald2011-06-27-0/+1
| | |
| * | update users table to user from_councilStruan Donald2011-06-27-1/+1
| | |
| * | add problem state_column to commentStruan Donald2011-06-23-0/+10
| | |
| * | add from_authority flag to users table for council employees etcStruan Donald2011-06-22-0/+1
| | |
| * | rename will not fix to closedStruan Donald2011-06-16-1/+1
| | |
| * | update constraint on problem statesStruan Donald2011-06-15-0/+6
| | |
* | | fix syntax errorsStruan Donald2011-08-16-1/+1
| | |
* | | Merge branch 'master' of ssh://git.mysociety.org/data/git/public/fixmystreet ↵Struan Donald2011-08-16-1/+3
|\ \ \ | | |/ | |/| | | | | | | | | | | | | | | | into open311-consumer Conflicts: db/schema.sql perllib/FixMyStreet/DB/Result/Problem.pm
| * | sql syntax errorStruan Donald2011-08-09-1/+1
| | |
| * | add flagged flags to problems and usersStruan Donald2011-08-09-2/+4
| |/
* | fix syntax errorsStruan Donald2011-08-16-2/+2
| |
* | add in extra field to contacts for storing open311 meta dataStruan Donald2011-08-01-0/+3
| |
* | open311conf id to type serialStruan Donald2011-07-29-1/+1
| |
* | add in table to store configuration of councils using open311Struan Donald2011-07-29-0/+9
| |
* | add extra column to problem for storing addition open311 meta informationStruan Donald2011-07-29-0/+1
|/
* 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
| | | | | | | | council.
* | 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
| | | | rename old occurences to help when changing code later.
* 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 ↵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
|