aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Expand)AuthorAgeLines
* Add customisable defect types.Dave Arter2017-03-23-0/+18
* Add external_id field to ResponsePriority for use with ExorDave Arter2017-02-15-0/+1
* Add ‘state’ field to ResponseTemplate modelDave Arter2017-01-10-0/+1
* Add ‘description’ field to ResponsePriority modelDave Arter2016-10-19-0/+1
* Add 'extra' field to User modelDave Arter2016-09-23-1/+2
* Refactor problem response priority into its own modelDave Arter2016-09-09-1/+17
* Extend response templates to work across all cobrandsDave Arter2016-09-08-0/+7
* Allow user to have an area assigned in adminDave Arter2016-08-22-1/+2
* Add user planned reports.Matthew Somerville2016-08-22-0/+8
* Remove check constraint on user body permissions.Dave Arter2016-08-09-5/+1
* Use normal user authentication to control access to /adminMatthew Somerville2016-07-19-0/+1
* Prerequisites (new modules, db, config).Matthew Somerville2016-01-22-1/+3
* Add "time spent" admin logging.Hakim Cassimally2015-10-06-1/+2
* [Zurich] Response templates for report admin.Hakim Cassimally2015-10-06-0/+9
* Allow underscore in cobrand name/data in database.Matthew Somerville2015-09-29-6/+6
* Simplify/consolidate body restriction db code.Matthew Somerville2015-08-19-0/+1
* Move "missing" handling to separate column.Matthew Somerville2015-08-19-0/+1
* Remove ms_current_timestamp() override function.Matthew Somerville2015-08-13-29/+8
* Improve stored procedure performance.Matthew Somerville2015-08-10-17/+11
* Report moderationHakim Cassimally2014-08-13-1/+31
* Merge remote branch 'origin/sweden-rebase'Matthew Somerville2014-03-11-0/+1
|\
| * Add `external_url' column to `body' table.Jon Kristensen2014-03-11-0/+1
* | remove action check on admin_logHakim Cassimally2013-12-09-4/+1
* | [Zurich] Update schema.sql with body.deleted columnChris Mytton2013-09-10-1/+2
|/
* Merge remote branch 'origin/zurich'Matthew Somerville2013-02-04-73/+51
|\
| * Allow bodies to have parent bodies.Matthew Somerville2012-12-19-0/+1
| * Rejig schema.sql to prevent circular references.Matthew Somerville2012-12-19-40/+43
| * 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
* | add internal review status to problemsStruan Donald2013-01-17-0/+2
* | Merge branch 'bromley-new-statuses'Struan Donald2013-01-16-1/+10
|\ \
| * | order of conditions in constraints need to match exactly to make deployment s...Struan Donald2012-10-03-2/+2
| * | add send_extended_statuses conf option and use in send-commentsStruan Donald2012-10-03-1/+2
| * | tidy up status names in DB, improve tests a littleStruan Donald2012-10-01-2/+2
| * | initial work to handle changed problem statesStruan Donald2012-08-31-0/+8
* | | add subcategory field to problem tableStruan Donald2012-12-03-1/+4
| |/ |/|
* | 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
|/
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 10:38:02 +0000