aboutsummaryrefslogtreecommitdiffstats
path: root/db
Commit message (Collapse)AuthorAgeLines
* Add customisable defect types.Dave Arter2017-03-23-0/+39
| | | | | | | | | 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/+7
|
* Add ‘state’ field to ResponseTemplate modelDave Arter2017-01-10-0/+7
|
* Add ‘description’ field to ResponsePriority modelDave Arter2016-10-19-0/+13
| | | | Used internally to provide more details about when a priority is applicable.
* Add 'extra' field to User modelDave Arter2016-09-23-1/+14
|
* Refactor problem response priority into its own modelDave Arter2016-09-09-1/+44
| | | | | | | 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/+26
| | | | | | | | | | | 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/+9
|
* Add user planned reports.Matthew Somerville2016-08-22-0/+20
| | | | | | 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/+14
| | | | We'll soon be adding more new permission types.
* Use normal user authentication to control access to /adminMatthew Somerville2016-07-19-0/+7
| | | | | | | | | - 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/+11
|
* Reduce use of FixMyStreet::App.Matthew Somerville2015-12-02-1/+1
| | | | Command line scripts don't need a full blown app, just database.
* Add "time spent" admin logging.Hakim Cassimally2015-10-06-1/+6
| | | | | | | | | | | | | | | | | | | | | 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/+18
| | | | | | | 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/+27
|
* Simplify/consolidate body restriction db code.Matthew Somerville2015-08-19-127/+25
| | | | | | | 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/+11
|
* Remove ms_current_timestamp() override function.Matthew Somerville2015-08-13-30/+24
| | | | | 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/+58
| | | | | Add an index on the radian values, make the function stable, and switch to a full bounding box rather than a slower angle check.
* Moderation - update-schema fixed and improvedHakim Cassimally2014-08-14-0/+7
| | | | | | bin/update-schema --commit should now work A downgrade is also provided. Run bin/update-schema --help for details
* Report moderationHakim Cassimally2014-08-13-1/+67
| | | | | | | | | | | - 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/+10
|\ | | | | | | | | | | | | 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/+10
| |
* | remove action check on admin_logHakim Cassimally2013-12-09-4/+7
| | | | | | | | to allow a wider range of action logging.
* | [Zurich] Update schema.sql with body.deleted columnChris Mytton2013-09-10-1/+2
| |
* | [Zurich] Add deleted column to body tableChris Mytton2013-09-10-0/+6
|/ | | | | | This is so Zurich can mark certain external bodies (which may already have problems assigned to them) as deleted, without *actually* deleting them.
* Tweak interest_count schema creation.Matthew Somerville2013-02-21-10/+1
|
* Consolidate all body SQL changes into one file.Matthew Somerville2013-02-21-105/+87
|
* New schema to bring alert_type up to date with what it says it is.Matthew Somerville2013-02-05-0/+19
|
* Update schema migration to work after previous merged in one.Matthew Somerville2013-02-04-7/+7
|
* Get alert_types.sql up to date with merged in schema changes.Matthew Somerville2013-02-04-9/+46
|
* Merge remote branch 'origin/zurich'Matthew Somerville2013-02-04-81/+145
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
| * Get schema to make sure the body table has the right things in it for the move.Matthew Somerville2013-02-01-0/+6
| |
| * Allow bodies to have parent bodies.Matthew Somerville2012-12-19-0/+6
| |
| * 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/+21
| | | | | | | | than one body.
| * Make from_body a foreign key.Matthew Somerville2012-12-15-1/+7
| |
| * Rename council column to bodies_str, and all the related code.Matthew Somerville2012-12-15-10/+15
| |
| * Convert report sending code to use bodies rather than areas/councils.Matthew Somerville2012-12-15-0/+8
| |
| * Rename area_id on Contacts table to body_id.Matthew Somerville2012-12-15-19/+30
| | | | | | | | Add foreign key constraint from contacts to body.
| * Rename from_council to from_body, and small related changes.Matthew Somerville2012-12-15-19/+6
| |
| * Rename 'open311conf' database table to 'body'.Matthew Somerville2012-12-15-3/+15
| |
* | add internal review status to problemsStruan Donald2013-01-17-6/+16
| |
* | Merge branch 'bromley-new-statuses'Struan Donald2013-01-16-1/+91
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
| * | correct name of comment state constraintStruan Donald2012-10-03-2/+2
| | |
| * | add send_extended_statuses conf option and use in send-commentsStruan Donald2012-10-03-1/+8
| | |
| * | tidy up status names in DB, improve tests a littleStruan Donald2012-10-01-2/+77
| | |
| * | initial work to handle changed problem statesStruan Donald2012-08-31-0/+8
| | |
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 08:30:04 +0000