aboutsummaryrefslogtreecommitdiffstats
path: root/bin/update-schema
Commit message (Collapse)AuthorAgeLines
* 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
| * Add `external_url' column to `body' table.Jon Kristensen2014-03-11-0/+1
| |
* | remove action check on admin_logHakim Cassimally2013-12-09-0/+8
| | | | | | | | to allow a wider range of action logging.
* | Do fewer things for a dev installation.Matthew Somerville2013-09-13-3/+4
| | | | | | | | | | | | | | | | | | | | If the development parameter is passed to the install-script, don't install a crontab, don't set up nginx, don't force the repository to a particular version, and don't set up an application server. Also only create a general.yml file if one doesn't already exist, and add some locales that the test suite assumes are present. And run the db schema update script.
* | [Zurich] Add schema migration 0029 to bin/update-schemaChris Mytton2013-09-10-0/+1
|/
* A script to bring a FixMyStreet database up to date.Matthew Somerville2013-02-22-0/+134
It will examine the current database to see at what state it is, and optionally run the newer schema SQL files in order to bring the database up to date. At the 'adding bodies' stage, it will also query MapIt to fill the name column of the new body table.
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 18:20:17 +0000