re-aranged migrations so that big_flags for orgs happen before foreign keys

re-aranged migraitons so that bit_flags for roles happens before foreign keys

added role scrubbing to foreign keys migration

final tweks to ensure all migrations happen together

replaced plan roles with bitflags

removed organisation_types and replaced with bitflags

updated removing_intermediary_tables to remove some other unused tables

added migration to make a many to one relationship guidances > guidance_groups, additionally, removed the project groups and projects tables

added migration to add foreign keys. Also needed to remove the temporary models, and update existing models to reflect the new relationships

updated migration to remove all new_table_name structures

init commit of migration to remove old tables and rename intermediary ones

additionally stores old project_id for new_plans

changed the way answers are selected in migration

updated prefetching, relocated index definition, and removed debug for migration

wrapped migration in transaction for performance

updated code to write user-generated content (answers/notes)

removed early cutting for template project and relpaced with better selection

updated to allow template versioning to function correctly

total schema data migration: now with customized templates

preliminary migration of db schema - migration subject to change

renamed roles to perms

removed the unused user_id field from the dmptemplates table

removed domain and stylesheet_id from organisation. Both were unused on the front and back ends of the tool

removed role_in_plans, resource_id, and resource_type from the roles table. All were unused

removed parent_id field from questions table

removed option_warnings table and unused code surrounding the structure

removed user_statuses, user_types, and user_role_types tables and associations which referenced them

Corrected spelling of text_desription field in token_permission_types

fixed db migration so that it does not update user records in TEST mode. Added sqlite3 to gemfile for tests. Added languages fixture

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