aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Expand)AuthorAgeLines
* Add created and last_active columns to user.Matthew Somerville2018-05-23-0/+2
* add extra column to body tableStruan Donald2018-04-11-1/+2
* add convert_latlong option to body tableStruan Donald2018-03-29-0/+1
* Add ResponseTemplate.external_status_code fieldDave Arter2018-03-29-0/+1
* permit blank updates to be fetched over Open311Struan Donald2018-03-15-0/+1
* fetch new problems over open311Struan Donald2018-03-15-0/+1
* Add 'verified' database columns for email/phone.Matthew Somerville2017-09-30-1/+5
* add is_default column to response_prioritiesStruan Donald2017-09-13-0/+1
* Remove hardcoded states from Problem model.Matthew Somerville2017-08-31-1/+1
* Add state table to database.Matthew Somerville2017-08-29-33/+9
* Add site-wide extra fields for reports, and admin UI to manageDave Arter2017-08-17-0/+8
* Add translation table.Matthew Somerville2017-08-09-0/+10
* Add inactive state to categories.Matthew Somerville2017-07-14-5/+13
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 09:20:42 +0000