aboutsummaryrefslogtreecommitdiffstats
path: root/bin/update-schema
Commit message (Collapse)AuthorAgeLines
* Add database index for user full text search.M Somerville2020-08-06-0/+1
|
* Add database index for full text search.Matthew Somerville2020-07-31-0/+4
|
* Fix update-schema constraint check on Postgres 12Dave Arter2020-05-27-1/+1
| | | | | pg_constraint.consrc has been removed in Postgres 12, and this is the recommended replacement. See https://www.postgresql.org/docs/12/release-12.html
* Add a new "staff" contact state.Matthew Somerville2020-02-26-0/+1
| | | | | This state will appear when reporting if you are logged in as a staff member of the relevant body, but otherwise not appear on the site.
* Add ManifestTheme model for customising web manifestDave Arter2020-02-14-0/+1
|
* Do not hard code site name in database fixture.Matthew Somerville2019-12-10-0/+1
| | | | This also lets it be cobrand specific.
* Add admin log entry for more objects and things.Matthew Somerville2019-11-08-0/+1
| | | | | Namely templates, roles, bodies, categories, various user edits, and when using the inspect form and changing category.
* DB changes to support OIDC authDave Arter2019-08-16-0/+1
|
* Add user roles tablesDave Arter2019-05-28-0/+1
|
* Allow user to be associated with multiple areas.Matthew Somerville2019-02-14-0/+1
| | | | | | Update database to store an array of IDs rather than only one; consequential changes to the admin and the dashboard to allow selection.
* Associate moderation history with admin log.Matthew Somerville2018-11-27-0/+1
|
* Store all moderation change history in database.Matthew Somerville2018-11-26-0/+7
| | | | | Currently keeping the same front end functionality of only reverting to the original.
* Store more original stuff on moderation.Matthew Somerville2018-11-16-0/+1
|
* Add created and last_active columns to user.Matthew Somerville2018-05-23-0/+1
|
* add extra column to body tableStruan Donald2018-04-11-0/+1
| | | | 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-0/+1
| | | | | These are so we can state whether a user's email address or phone number have been verified by confirmation email/text.
* Include schema migration test.Matthew Somerville2017-09-14-0/+1
| | | | This was missed in 0998aef4.
* Remove hardcoded states from Problem model.Matthew Somerville2017-08-31-1/+18
| | | | | 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-0/+1
|
* Add site-wide extra fields for reports, and admin UI to manageDave Arter2017-08-17-0/+1
| | | | | | | - Also provides an editor for the extra Open311 fields on contacts. - Adds .btn--small class for small buttons Fixes #1743.
* Fix issues with database migration script.Matthew Somerville2017-08-10-3/+2
| | | | | | A reference to ->storage was missed as this script changed in a different branch. The schema files contain transaction commands themselves. A check for migration 52 was missing.
* Allow update-schema to run on empty database.Matthew Somerville2017-08-03-22/+31
|
* Include schema check for 0051 missed in 466c5cac.Matthew Somerville2017-07-17-0/+1
|
* Add customisable defect types.Dave Arter2017-03-23-0/+1
| | | | | | | | | 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 0048 migration check to update-schemaDave Arter2017-01-16-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-0/+1
|
* Refactor problem response priority into its own modelDave Arter2016-09-09-0/+1
| | | | | | | 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/+1
| | | | | | | | | | | 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-0/+1
|
* Add user planned reports.Matthew Somerville2016-08-22-0/+1
| | | | | | 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-0/+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-0/+1
|
* Remove many uses of mySociety::Config.Matthew Somerville2015-12-02-7/+6
|
* Add "time spent" admin logging.Hakim Cassimally2015-10-06-0/+1
| | | | | | | | | | | | | | | | | | | | | 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/+1
| | | | | | | 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-0/+8
|
* Move "missing" handling to separate column.Matthew Somerville2015-08-19-0/+1
|
* Remove ms_current_timestamp() override function.Matthew Somerville2015-08-13-0/+1
| | | | | This override is not used anywhere, it dates from a very old long-gone test script, and causes issues with database query planning.
* Add schema migration check for latest migration.Matthew Somerville2015-08-13-2/+8
|
* Remove need for cron-wrapper with existing scriptsMatthew Somerville2015-01-19-6/+10
| | | | | Call the necessary boilerplate in each script so you can call them directly. Remove boilerplate from files that don't need it.
* Use env in shebang lines, and remove unneeded onesMatthew Somerville2015-01-19-1/+1
|
* Moderation - update-schema fixed and improvedHakim Cassimally2014-08-14-30/+137
| | | | | | bin/update-schema --commit should now work A downgrade is also provided. Run bin/update-schema --help for details
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 08:49:44 +0000