aboutsummaryrefslogtreecommitdiffstats
path: root/db
Commit message (Collapse)AuthorAgeLines
* Removing db/development_structure.sql from version control. Because ↵Louise Crow2013-08-08-2095/+0
| | | | different versions of postgres are producing minor variations every time this is generated, it's proving more of a hindrance than a help to development. Happy to reinstate it if anyone has suggestions about how to keep it stable across minor postgres version differences.
* Update reference to Configuration to reflect name change to ↵Louise Crow2013-04-30-1/+1
| | | | AlaveteliConfiguration
* bundle update debugger rmagickMatthew Landauer2013-03-18-24/+24
|
* Merge remote-tracking branch 'mysociety/develop' into rails-3-developHenare Degan2013-03-14-1/+2095
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: Gemfile Gemfile.lock app/controllers/admin_request_controller.rb app/controllers/admin_track_controller.rb app/controllers/request_controller.rb app/controllers/services_controller.rb app/helpers/link_to_helper.rb app/mailers/request_mailer.rb app/models/application_mailer.rb app/models/info_request.rb app/views/admin_censor_rule/edit.html.erb app/views/admin_censor_rule/new.html.erb app/views/admin_public_body/_form.html.erb app/views/admin_public_body/_locale_selector.html.erb app/views/admin_public_body/_one_list.html.erb app/views/admin_public_body/edit.html.erb app/views/admin_public_body/list.html.erb app/views/admin_public_body/new.html.erb app/views/admin_request/_incoming_message_actions.html.erb app/views/admin_request/edit.html.erb app/views/admin_request/edit_comment.html.erb app/views/admin_request/edit_outgoing.html.erb app/views/admin_request/list.html.erb app/views/admin_request/list_old_unclassified.html.erb app/views/admin_request/show.html.erb app/views/admin_track/_some_tracks.html.erb app/views/admin_track/list.html.erb app/views/admin_user/edit.html.erb app/views/admin_user/list.html.erb app/views/admin_user/show.html.erb app/views/general/_footer.html.erb app/views/general/exception_caught.html.erb app/views/help/contact.html.erb app/views/layouts/default.html.erb app/views/public_body/_alphabet.html.erb app/views/request/_request_listing_single.html.erb app/views/request/_sidebar.html.erb app/views/request/new.html.erb app/views/request/show.html.erb app/views/request_mailer/external_response.rhtml app/views/request_mailer/fake_response.rhtml config/environment.rb config/environments/production.rb config/routes.rb spec/controllers/admin_censor_rule_controller_spec.rb spec/controllers/request_controller_spec.rb spec/controllers/track_controller_spec.rb spec/helpers/link_to_helper_spec.rb spec/mailers/request_mailer_spec.rb spec/models/info_request_spec.rb spec/spec_helper.rb spec/views/public_body/show.html.erb_spec.rb spec/views/request/show.html.erb_spec.rb vendor/plugins/rails_xss/lib/rails_xss/erubis.rb
| * Reignore schema.rbLouise Crow2013-03-08-0/+1
| |
| * Checkin current snapshot of sql as per standard Rails good practise.Matthew Landauer2013-02-26-2/+2095
| | | | | | | | | | | | Also has the advantage that it makes it easier to switch between branches with different schemas as the test db schema will be generated from the checked in file.
* | Update syntax while I'm hereHenare Degan2013-03-05-1/+1
| |
* | Remove debugging output that was causing migration to failHenare Degan2013-03-05-2/+0
| |
* | Merge branch 'develop' into rails-3-spikeHenare Degan2013-02-15-4/+2
|\| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: Gemfile Gemfile.lock app/controllers/general_controller.rb app/controllers/track_controller.rb app/models/outgoing_message.rb app/models/public_body.rb app/models/user.rb app/views/general/frontpage.rhtml config/environment.rb config/initializers/inflections.rb config/initializers/mime_types.rb db/migrate/094_remove_old_tags_foreign_key.rb lib/timezone_fixes.rb spec/models/request_mailer_spec.rb spec/views/request/list.rhtml_spec.rb
| * Drop the obsolete indexes explicitly by name - the 'remove_index' calls ↵Louise Crow2013-01-17-4/+2
| | | | | | | | don't work as the table has been renamed, and they automatically generate the index name from the table name. Apply custom index name from a5e90e2b7ea6adedbf80c05bbb84425a02c63da0.
| * Fix up some DB migration issues with Rails 3Henare Degan2013-01-18-3/+4
| | | | | | | | | | * The public_body_tags table had already been removed * The index has_tag_string_tags generated a name longer than the Postgres maximum of 63 characters. It was ignored in earlier Rails versions, see: https://rails.lighthouseapp.com/projects/8994/tickets/6187-postgresql-and-rails-303-migrations-fail-with-index-name-length-64-chars
* | We expect timestamps in a later migration but they're no longer added by the ↵Henare Degan2013-01-22-0/+2
| | | | | | | | newer version of acts_as_versioned we're using since 2ba57e8
* | Fix up some DB migration issues with Rails 3Henare Degan2012-12-11-3/+4
| | | | | | | | | | * The public_body_tags table had already been removed * The index has_tag_string_tags generated a name longer than the Postgres maximum of 63 characters. It was ignored in earlier Rails versions, see: https://rails.lighthouseapp.com/projects/8994/tickets/6187-postgresql-and-rails-303-migrations-fail-with-index-name-length-64-chars
* | Run the Rails 3 generatorHenare Degan2012-12-11-0/+7
|/
* Remove old code.Louise Crow2012-11-20-10/+2
|
* The used sql syntax is not supported by sqlite. Now db:migrate works with ↵Stefan Langenmaier2012-11-19-4/+11
| | | | sqlite.
* Add migration to add disclosure_log fieldMatthew Landauer2012-10-22-0/+13
|
* Rename models and tables exim -> mail_serverMatthew Landauer2012-10-11-0/+13
|
* Merge remote-tracking branch 'openaustralia_github/configuration_refactor' ↵Louise Crow2012-10-01-1/+1
|\ | | | | | | | | | | | | into develop Conflicts: config/general.yml-example
| * Extract configuration with defaults into one moduleMatthew Landauer2012-09-25-1/+1
| |
* | Re-enable migration - it looks like the underlying bug is something to do ↵Louise Crow2012-09-27-56/+56
| | | | | | | | with interlock/memcached.
* | Test commit to try to figure out what's wrong with the travis build - it ↵Louise Crow2012-09-27-56/+56
|/ | | | always fails on this migration.
* Merge remote-tracking branch 'origin/release/0.6.6' into developLouise Crow2012-09-20-4/+3
|\
| * Faster way to update counter cache.release/0.6.6Louise Crow2012-09-20-4/+3
| |
* | Migration accidentally omitted from 550f143Robin Houston2012-09-19-0/+9
|/
* Add index on updated_at to public body versions as this is how they are ↵Louise Crow2012-09-13-0/+9
| | | | retrieved in the admin timeline view.
* Add some indexes to help IncomingMessage.fully_destroy find records more ↵Louise Crow2012-09-13-0/+18
| | | | efficiently by info_request_event_id
* Add an index on incoming message id to the outgoing messages table - suspect ↵Louise Crow2012-09-13-0/+9
| | | | this will improve the performance of AdminRequestController#destroy_incoming, which looks for outgoing messages by incoming message.
* Add a counter cache for the number of info_requests associated with public ↵Louise Crow2012-09-12-0/+17
| | | | bodies.
* Add some indexes based on queries appearing in the SQL slow queries log.Louise Crow2012-09-12-0/+69
|
* Add a new model for request classifications so that we can access them more ↵Louise Crow2012-09-11-0/+14
| | | | efficiently when creating league tables for the request classification game.
* Merge branch 'release/0.6.3' into developLouise Crow2012-08-22-0/+32
|\ | | | | | | | | | | | | | | Conflicts: app/controllers/admin_public_body_controller.rb app/views/admin_public_body/import_csv.rhtml spec/controllers/admin_public_body_controller_spec.rb spec/models/info_request_spec.rb
| * Rollback change to activerecord session store - whilst activerecord store ↵Louise Crow2012-08-15-0/+16
| | | | | | | | has some advantages (notably avoiding permanent versus transient session hijack possibilities), I think it needs some more work/testing (we'd need to have good code for cleaning out stale activerecord sessions periodically - with activerecord store this is now our responsibility). We'd also need to reset the session key to kill all in progress sessions to prevent errors as rails tries to store long cookie keys in the limited key field of the activerecord store. For this release, it'll be more straightforward to fix the csv_upload file issue #526 in a more localized way.
| * Use ActiveRecord to store sessions, rather than Cookies. Fixes #526.Seb Bacon2012-07-19-0/+16
| |
* | Correct constraint on external requestsRobin Houston2012-08-22-0/+16
|/
* Support regular expressions in CensorRules; also support 'global' ↵Seb Bacon2012-07-13-0/+9
| | | | CensorRules that aren't attached to a User or Request or Public Body (but don't expose this in the admin UI). Fixes #33
* Set the API key in a much more efficient wayRobin Houston2012-07-02-3/+44
| | | | | | | | | If we are using PostgreSQL, populate the api_key column in a more efficient fashion. Conflicts: db/migrate/112_add_api_key_to_public_bodies.rb
* Renumber clashing migrationRobin Houston2012-06-07-0/+0
|
* External requestsRobin Houston2012-06-06-0/+22
| | | | | Add data model support for “external” requests, i.e. requests added via the API rather than made using the site.
* Correct syntax for making column NOT NULLRobin Houston2012-06-06-1/+1
|
* Generate an API key for each public bodyRobin Houston2012-06-06-0/+18
|
* Support "following" functionality:Seb Bacon2012-05-30-0/+11
| | | | | | * Change "email me about stuff" wording to "follow" throughout * Introduce a new flag that the user can set, which controls if they get email alerts * Add a new link to a "wall" for logged in users where they can see a feed of all the things they're following
* First stab at new feature. Adds new box in sidebar for reporting an issue, a ↵Seb Bacon2012-05-24-0/+13
| | | | | | new "needs admin attention"-type state to InfoRequests, a flag indicating that a request has ever been marked as needing admin attention, and a controller method and route for setting this state & flag. Also adds the reason something needs admin attention to the subject of the email that gets sent to administrators. Neeeds tests.
* More WIPSeb Bacon2012-04-03-22/+0
|
* WIPSeb Bacon2012-04-03-0/+14
|
* first stab at sending PURGE requests to upstream varnish for request pages. ↵Seb Bacon2012-03-13-0/+22
| | | | Next step: making it asynchronous, e.g. with a queue of things to purge via a cron job.
* Rate limitingRobin Houston2012-01-29-0/+13
| | | | | | Add the capability to specify a limit to the number of requests a user can make per day, which can be turned off for specific users in the admin interface.
* Use correct column type for sent_at date (was only preserving time and not ↵Seb Bacon2012-01-10-0/+12
| | | | date, resulting in incoming_messages all apparently being sent on January 1, 2000)
* Ensure we always censor safe_mail_from; and mention new only-parse-once ↵Seb Bacon2011-12-21-0/+11
| | | | feature in CHANGES.md
* Ensure we only parse emails when needed by referring to a new last_parsed ↵Seb Bacon2011-12-21-0/+9
| | | | field on incoming_messages. Currently mails are always parsed just-in-time, but could be parsed as a queue in the future.
generated by cgit v1.2.3 (git 2.25.1) at 2025-09-20 21:28:07 +0000