aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
Commit message (Collapse)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
| | | | Adds and extra column for bodies and the associated Extra role.
* add convert_latlong option to body tableStruan Donald2018-03-29-0/+1
| | | | | For controlling if reports pulled in via Open311 should have the position converted from Easting/Northing to lat/long.
* Add ResponseTemplate.external_status_code fieldDave Arter2018-03-29-0/+1
|
* permit blank updates to be fetched over Open311Struan Donald2018-03-15-0/+1
| | | | | Add a per body configuration option to allow Open311 updates to contain only a status change, rather than emitting a warning when this happens.
* fetch new problems over open311Struan Donald2018-03-15-0/+1
| | | | | | | | | | This enables the display of existing reports from the back end on FMS if the body is configured to do this. Reports will not be created if they are missing an id, a lat or a long, if the lat/long is outside the area covered by the body, if there is already a report with a matching id, or if we can't parse out the request time.
* Add 'verified' database columns for email/phone.Matthew Somerville2017-09-30-1/+5
| | | | | These are so we can state whether a user's email address or phone number have been verified by confirmation email/text.
* add is_default column to response_prioritiesStruan Donald2017-09-13-0/+1
|
* Remove hardcoded states from Problem model.Matthew Somerville2017-08-31-1/+1
| | | | | We keep the internal states hardcoded, plus the core open (confirmed) and closed ones, but the remainder are moved to the database.
* 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
| | | | | | | - Also provides an editor for the extra Open311 fields on contacts. - Adds .btn--small class for small buttons Fixes #1743.
* Add translation table.Matthew Somerville2017-08-09-0/+10
|
* Add inactive state to categories.Matthew Somerville2017-07-14-5/+13
| | | | | A new 'state' column replaces confirmed and deleted, allowing categories to be unconfirmed, confirmed, deleted or inactive.
* Add customisable defect types.Dave Arter2017-03-23-0/+18
| | | | | | | | | Problems can have an associated defect type, that can be assigned during an inspection. Include an admin interface for managing these types, that can also be assigned on a per-category basis, currently available to the Oxfordshire cobrand. (Also include 'TM' in traffic management Exor RDI output.)
* 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
| | | | Used internally to provide more details about when a priority is applicable.
* Add 'extra' field to User modelDave Arter2016-09-23-1/+2
|
* Refactor problem response priority into its own modelDave Arter2016-09-09-1/+17
| | | | | | | This moves the response priority values from a cobrand-specific method to a full DB model, and includes management screens in the admin for administering them. For mysociety/fixmystreetforcouncils#66
* Extend response templates to work across all cobrandsDave Arter2016-09-08-0/+7
| | | | | | | | | | | This builds on the response templates in the Zürich cobrand: - Allow response templates to be assigned to categories - Also adds a auto_response flag, which will be used to automatically create updates when reports are made. - Include response templates select box on update form For mysociety/fixmystreetforcouncils#31
* Allow user to have an area assigned in adminDave Arter2016-08-22-1/+2
|
* Add user planned reports.Matthew Somerville2016-08-22-0/+8
| | | | | | A user with the appropriate permission can add/remove reports from their list of planned reports using a button on a report page. The list can be viewed at /my/planned.
* Remove check constraint on user body permissions.Dave Arter2016-08-09-5/+1
| | | | We'll soon be adding more new permission types.
* Use normal user authentication to control access to /adminMatthew Somerville2016-07-19-0/+1
| | | | | | | | | - Adds is_superuser flag to User - Logged-in user must be a superuser or have from_body set in order to access anything within /admin - has_permission_to on a superuser will always return true - Only superusers can create/grant superusers - New `createsuperuser` command for creating superusers
* Prerequisites (new modules, db, config).Matthew Somerville2016-01-22-1/+3
|
* Add "time spent" admin logging.Hakim Cassimally2015-10-06-1/+2
| | | | | | | | | | | | | | | | | | | | | Mechanism is general, but current implementation only used for Zurich. - Zurich: Record time_spent field mysociety/FixMyStreet-Commercial#676 - template changes (including jQuery spinner) - backend changes to save data are made: - in log_edit, if supplied - and time on category change (and arbitrary actions) - Add update_admin_log to all paths for DM, ensuring that it gets called, while resetting the `time_spent` parameter, to make sure that there is never a duplicate record created. - Also quell warning about using DateTime values in query. - Also add (seemingly unrelated) parens to stop misparsing of OK line in questionnaire test now that DT::Format::Pg is used in Zurich cobrand See mysociety/FixMyStreet-Commercial#676
* [Zurich] Response templates for report admin.Hakim Cassimally2015-10-06-0/+9
| | | | | | | This provides a ResponseTemplate model that an admin/staff user can choose from when responding to problems. For mysociety/FixMyStreet-Commercial#671.
* 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
| | | | | | | Make dashboard work properly in two-tier councils, showing reports sent to both. Create an index on the array of the bodies_str column to speed up performance, and use that throughout the code replacing all LIKE scans. This also enables a simplifying tidy of the restriction code.
* Move "missing" handling to separate column.Matthew Somerville2015-08-19-0/+1
|
* Remove ms_current_timestamp() override function.Matthew Somerville2015-08-13-29/+8
| | | | | This override is not used anywhere, it dates from a very old long-gone test script, and causes issues with database query planning.
* Improve stored procedure performance.Matthew Somerville2015-08-10-17/+11
| | | | | Add an index on the radian values, make the function stable, and switch to a full bounding box rather than a slower angle check.
* Report moderationHakim Cassimally2014-08-13-1/+31
| | | | | | | | | | | - redaction marked with [...] - of report and comments - stores original data - uses a single form, on the report/_main view - requires additional permissions (user_body_permissions) - Hide report functionality - Moderation notification/contact form - Moderation writes to admin_log
* Merge remote branch 'origin/sweden-rebase'Matthew Somerville2014-03-11-0/+1
|\ | | | | | | | | | | | | Conflicts: bin/update-schema locale/sv_SE.UTF-8/LC_MESSAGES/FixMyStreet.po perllib/FixMyStreet/DB/Result/Body.pm
| * Add `external_url' column to `body' table.Jon Kristensen2014-03-11-0/+1
| |
* | remove action check on admin_logHakim Cassimally2013-12-09-4/+1
| | | | | | | | to allow a wider range of action logging.
* | [Zurich] Update schema.sql with body.deleted columnChris Mytton2013-09-10-1/+2
|/
* Merge remote branch 'origin/zurich'Matthew Somerville2013-02-04-73/+51
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: bin/open311-populate-service-list bin/send-comments bin/update-all-reports conf/crontab.ugly db/schema.sql perllib/FixMyStreet/App/Controller/Admin.pm perllib/FixMyStreet/App/Controller/Report/New.pm perllib/FixMyStreet/App/Controller/Reports.pm perllib/FixMyStreet/Cobrand/Default.pm perllib/FixMyStreet/Cobrand/LichfieldDC.pm perllib/FixMyStreet/DB/Result/Open311conf.pm perllib/FixMyStreet/DB/Result/Problem.pm perllib/FixMyStreet/DB/ResultSet/Problem.pm perllib/FixMyStreet/SendReport.pm perllib/FixMyStreet/SendReport/Email.pm perllib/FixMyStreet/SendReport/Open311.pm perllib/Open311/GetServiceRequestUpdates.pm perllib/Open311/PopulateServiceList.pm t/app/controller/report_new.t t/app/controller/rss.t templates/web/bromley/report/display.html templates/web/default/admin/council_contacts.html templates/web/default/common_header_tags.html templates/web/default/dashboard/index.html templates/web/default/front/stats.html templates/web/default/report/_main.html templates/web/default/report/update-form.html templates/web/emptyhomes/index.html templates/web/emptyhomes/report/display.html templates/web/emptyhomes/report/new/councils_text_all.html templates/web/emptyhomes/reports/body.html templates/web/emptyhomes/reports/index.html templates/web/fixmystreet/report/new/fill_in_details_form.html templates/web/fixmystreet/report/update-form.html web/cobrands/fixmystreet/fixmystreet.js web/js/fixmystreet.js
| * 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 ↵Matthew Somerville2012-12-19-1/+6
| | | | | | | | than one body.
| * 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
| | | | | | | | Add foreign key constraint from contacts to body.
| * 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
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: bin/send-comments conf/crontab.ugly db/schema.sql perllib/FixMyStreet/App/Controller/Admin.pm perllib/FixMyStreet/DB/Result/Open311conf.pm perllib/FixMyStreet/DB/ResultSet/Problem.pm perllib/Open311.pm t/app/controller/report_updates.t t/open311.t templates/web/default/report/display.html templates/web/default/report/updates.html templates/web/fixmystreet/report/display.html
| * | order of conditions in constraints need to match exactly to make deployment ↵Struan Donald2012-10-03-2/+2
| | | | | | | | | | | | schema test pass
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 17:59:16 +0000