aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Expand)AuthorAgeLines
* Allow bodies to span multiple area IDs, and areas can be covered by more than...Matthew Somerville2012-12-19-1/+6
* Make from_body a foreign key.Matthew Somerville2012-12-15-1/+1
* Rename council column to bodies_str, and all the related code.Matthew Somerville2012-12-15-2/+2
* Convert report sending code to use bodies rather than areas/councils.Matthew Somerville2012-12-15-0/+1
* Rename area_id on Contacts table to body_id.Matthew Somerville2012-12-15-19/+5
* Rename from_council to from_body, and small related changes.Matthew Somerville2012-12-15-19/+1
* Rename 'open311conf' database table to 'body'.Matthew Somerville2012-12-15-3/+3
* Allow external_body optionally to be a lookup on /reports.Matthew Somerville2012-11-22-0/+1
* set interest_count default to 0 as null + 1 = null in postgres :(Struan Donald2012-10-09-1/+1
* Missing commas due to merge.Matthew Somerville2012-10-04-2/+2
* Merge branch 'fmb-read-only'Dave Whiteland2012-10-03-1/+15
|\
| * correct syntax error in schemaStruan Donald2012-09-26-1/+1
| * allow endpoints to be configured at a category levelStruan Donald2012-08-29-1/+8
| * initial crude add support option for a problemStruan Donald2012-08-23-1/+4
| * add in external_source and external_source_id to schemaStruan Donald2012-07-12-1/+5
* | add non-public fields to contacts and problemStruan Donald2012-08-31-2/+8
|/
* Merge branch 'master' into bromleyMatthew Somerville2012-05-16-1/+4
|\
| * added can_display_external_id because external ids are not always useful for ...Dave Whiteland2012-05-03-1/+4
| * added retry cutoff and send_fail data to problem table for webservice send-re...Dave Whiteland2012-03-23-1/+6
| * now using open311config all send-reports webservices, not just open311Dave Whiteland2012-03-23-1/+2
* | add ability to suppress alerts to report creator onStruan Donald2012-05-11-1/+2
* | store title in users table so we can persist it for bromleyStruan Donald2012-05-01-1/+2
* | associated a comment user with a council configStruan Donald2012-03-26-1/+2
* | DB changes for comment sendingStruan Donald2012-03-26-2/+7
* | forgot to add extra column into schema fileStruan Donald2012-03-23-1/+2
* | add in retry count codeStruan Donald2012-03-22-1/+6
* | add in send method codeStruan Donald2012-03-22-1/+2
* | add external id to comments tableStruan Donald2012-03-19-1/+2
|/
* Merge branch 'rss-addresses'Struan Donald2011-11-30-1/+2
|\
| * 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
|\|
| * Merge branch 'master' of ssh://git.mysociety.org/data/git/public/fixmystreet ...Struan Donald2011-08-17-2/+4
| |\
| * | 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
|\ \ \ | | |/ | |/|
| * | 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 03:35:56 +0000