History for dmpopidor / db
2016-12-08
@xsrust
updated schema
xsrust committed on 8 Dec 2016
@xsrust
added migration to make a many to one relationship guidances > guidance_groups, additionally, removed the project groups and projects tables
xsrust committed on 8 Dec 2016
@xsrust
added migration to add foreign keys. Also needed to remove the temporary models, and update existing models to reflect the new relationships
xsrust committed on 8 Dec 2016
@xsrust
updated migration to remove all new_table_name structures
xsrust committed on 8 Dec 2016
@xsrust
init commit of migration to remove old tables and rename intermediary ones
xsrust committed on 8 Dec 2016
@xsrust
additionally stores old project_id for new_plans
xsrust committed on 8 Dec 2016
2016-12-06
@xsrust
changed the way answers are selected in migration
xsrust committed on 6 Dec 2016
2016-12-05
@xsrust
updated prefetching, relocated index definition, and removed debug for migration
xsrust committed on 5 Dec 2016
@xsrust
wrapped migration in transaction for performance
xsrust committed on 5 Dec 2016
2016-11-30
@xsrust
updated code to write user-generated content (answers/notes)
xsrust committed on 30 Nov 2016
@xsrust
removed early cutting for template project and relpaced with better selection
xsrust committed on 30 Nov 2016
@xsrust
updated to allow template versioning to function correctly
xsrust committed on 30 Nov 2016
2016-11-29
@xsrust
total schema data migration: now with customized templates
xsrust committed on 29 Nov 2016
@xsrust
preliminary migration of db schema - migration subject to change
xsrust committed on 29 Nov 2016
@xsrust
renamed roles to perms
xsrust committed on 29 Nov 2016
2016-11-15
@xsrust
removed the unused user_id field from the dmptemplates table
xsrust committed on 15 Nov 2016
@xsrust
removed domain and stylesheet_id from organisation. Both were unused on the front and back ends of the tool
xsrust committed on 15 Nov 2016
@xsrust
removed role_in_plans, resource_id, and resource_type from the roles table. All were unused
xsrust committed on 15 Nov 2016
@xsrust
removed parent_id field from questions table
xsrust committed on 15 Nov 2016
@xsrust
removed option_warnings table and unused code surrounding the structure
xsrust committed on 15 Nov 2016
@xsrust
removed user_statuses, user_types, and user_role_types tables and associations which referenced them
xsrust committed on 15 Nov 2016
2016-11-14
@Ray Carrick
add spanish translations
Ray Carrick committed on 14 Nov 2016
2016-11-02
@briley
Corrected spelling of text_desription field in token_permission_types
briley committed on 2 Nov 2016
@briley
fixed db migration so that it does not update user records in TEST mode. Added sqlite3 to gemfile for tests. Added languages fixture
briley committed on 2 Nov 2016
2016-10-26
@briley
ran db migrations
briley committed on 26 Oct 2016
2016-10-25
@xsrust
modifying relationship between users and organisations \n -users now belong_to organisation \n -organisations now have_many users \n -removed the depricated user_org_roles structure with migration \n -moved data out of that structure into the existing organisation_id field of users to complete relationship \n -re-evaluated functions to do with organisation_id field, as it was used as a placeholder before
xsrust committed on 25 Oct 2016
2016-10-18
@Jimmy Angelakos
Merge branch 'master' of https://github.com/DMPRoadmap/roadmap into postgresql
Jimmy Angelakos committed on 18 Oct 2016
2016-10-06
@xsrust
changed schema to be correct for point of migration of data
xsrust committed on 6 Oct 2016
2016-10-04
@briley
Fixed typos: changed all change_org_detials to change_org_details
briley committed on 4 Oct 2016
@xsrust
removed all instances of comparing booleans to 1 or 0 for postgres compatability
xsrust committed on 4 Oct 2016