aboutsummaryrefslogtreecommitdiffstats
path: root/db
Commit message (Collapse)AuthorAgeLines
* 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
* 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.
* Further improvements to attachment cachingSeb Bacon2011-12-13-0/+9
|
* WIP on caching attachmentsSeb Bacon2011-12-12-0/+35
|
* add db/schema.rb to db/.gitignoreJames McKinney2011-10-11-0/+1
|
* Merge branch 'wdtk' into developRobin Houston2011-09-08-0/+15
|\ | | | | | | | | | | Conflicts: config/general.yml-example spec/models/track_mailer_spec.rb
| * Migration for new User columnsRobin Houston2011-09-07-0/+15
| | | | | | | | | | A migration to add the new columns email_bounced_at and email_bounce_message to the users table.
* | Store user's locale against profile, so we can send them localised track ↵Seb Bacon2011-09-03-0/+11
|/ | | | emails. Also internationalize more strings at the same time. Fixes #163.
* Bring the wdtk branch into line with master (no more differences).Robin Houston2011-08-09-0/+35
|
* Merge branch 'master' into wdtkRobin Houston2011-08-09-0/+22
|\
| * Guess holding pen emails based on having a correct hash and an incorrect id. ↵Seb Bacon2011-08-08-0/+22
| | | | | | | | Closes #117
* | Let’s not do these migrations on WDTK. At least not yet.Robin Houston2011-07-30-35/+0
|/
* To make tests pass with RawEmails on the filesystem, instead of hacky ↵Seb Bacon2011-07-29-1/+1
| | | | dependency on existence of text_binary field in raw_emails model, rewrite tests (and their fixtures) to explicitly load data from FS when raw_emails are used.
* move load-email-fixtures-to-filesystem hack to global config, so that we ↵Seb Bacon2011-07-25-4/+2
| | | | don't need to remember to run it everywhere that the raw_emails fixture is used. At the same time, correct the migration that previously removed the data_binary column, as this is assumed for fixture loading. In a future iteration, we should probably stop abusing fixtures like this...
generated by cgit v1.2.3 (git 2.25.1) at 2025-10-04 03:12:40 +0000