aboutsummaryrefslogtreecommitdiffstats
path: root/db
Commit message (Collapse)AuthorAgeLines
* 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
| | |
* | | add subcategory field to problem tableStruan Donald2012-12-03-1/+10
| |/ |/|
* | Allow external_body optionally to be a lookup on /reports.Matthew Somerville2012-11-22-0/+1
| |
* | set interest_count default to 0 as null + 1 = null in postgres :(Struan Donald2012-10-09-1/+10
| | | | | | | | tests for the ui for interest_count as well
* | Missing commas due to merge.Matthew Somerville2012-10-04-2/+2
| |
* | Merge branch 'fmb-read-only'Dave Whiteland2012-10-03-1/+42
|\ \ | | | | | | | | | | | | | | | | | | Conflicts: db/schema.sql perllib/FixMyStreet/DB/Result/Contact.pm perllib/FixMyStreet/DB/Result/Problem.pm
| * | correct syntax error in schemaStruan Donald2012-09-26-1/+1
| | |
| * | allow endpoints to be configured at a category levelStruan Donald2012-08-29-1/+21
| | | | | | | | | | | | | | | default cobrand now checks for endpoint configuration and only extra fallbacks are in UK cobrand
| * | initial crude add support option for a problemStruan Donald2012-08-23-1/+10
| | |
| * | make external_source_id text for flexibilityStruan Donald2012-07-12-1/+1
| | |
| * | add in external_source and external_source_id to schemaStruan Donald2012-07-12-1/+5
| | |
| * | changed mm_msg_id to external_source_id, and added external_source colDave Whiteland2012-07-12-6/+8
| | |
| * | added Message Manager ID (mm_msg_id) column and used itDave Whiteland2012-07-11-0/+6
| |/
* | Remove any remaining BCI reference.Matthew Somerville2012-10-03-5/+5
| |
* | utility sql for secret, fixes #321Dave Whiteland2012-09-13-0/+8
| |
* | do no send alerts for non public reportsStruan Donald2012-09-04-9/+37
| |
* | add non-public fields to contacts and problemStruan Donald2012-08-31-2/+17
|/
* Merge branch 'master' into bromleyMatthew Somerville2012-05-16-1/+10
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: bin/send-reports conf/crontab.ugly conf/general.yml-example db/schema.sql perllib/FixMyStreet/App/Controller/Admin.pm perllib/FixMyStreet/App/Controller/Report/New.pm perllib/FixMyStreet/DB/Result/Comment.pm perllib/FixMyStreet/DB/Result/Open311conf.pm perllib/FixMyStreet/DB/Result/Problem.pm perllib/FixMyStreet/DB/Result/User.pm templates/web/default/js/validation_strings.html templates/web/fixmystreet/auth/sign_out.html templates/web/fixmystreet/report/new/councils_text_all.html web/cobrands/fixmystreet/_base.scss
| * added can_display_external_id because external ids are not always useful for ↵Dave Whiteland2012-05-03-1/+10
| | | | | | | | publishing, using send_method_used to determine that on a council-by-council basis
| * added retry cutoff and send_fail data to problem table for webservice ↵Dave Whiteland2012-03-23-1/+16
| | | | | | | | send-reports
| * now using open311config all send-reports webservices, not just open311Dave Whiteland2012-03-23-1/+9
| |
* | add in schema update file for suppress_alertsStruan Donald2012-05-11-0/+6
| |
* | add ability to suppress alerts to report creator onStruan Donald2012-05-11-1/+2
| | | | | | | | comments updated from open311
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 08:41:36 +0000