python source code of 0266_user_folder_perms

Project: notifications-api (GitHub Link)

notifications-api-master
- application.py
- Makefile
- gunicorn_config.py
- Procfile
- requirements_for_test.txt
- deploy-exclude.lst
- LICENSE
- test_csv_files
  - empty.csv
  - multiple_letter.csv
  - email.csv
  - sms.csv
  - multiple_sms.csv
  - multiple_email.csv
- runtime.txt
- .flake8
- .cfignore
- requirements-app.txt
- run_celery.py
- docker
  - Dockerfile
- setup.cfg
- README.md
- migrations
  - env.py
  - versions
    - 0228_notification_postage.py
    - 0266_user_folder_perms_table.py
    - 0019_add_job_row_number.py
    - 0123_add_noti_to_email_reply.py
    - 0213_brand_colour_domain_.py
    - 0187_another_letter_org.py
    - 0042_notification_history.py
    - 0148_add_letters_as_pdf_svc_perm.py
    - 0317_uploads_for_all.py
    - 0107_drop_template_stats.py
    - 0164_add_organisation_to_service.py
    - 0069_add_dvla_job_status.py
    - 0211_email_branding_update_.py
    - 0309_add_uq_key_row_number.py
    - 0028_fix_reg_template_history.py
    - 0229_new_letter_rates.py
    - 0233_updated_first_class_dates.py
    - 0131_user_auth_types.py
    - 0165_another_letter_org.py
    - 0286_add_unique_email_name.py
    - 0218_another_letter_org.py
    - 0016_reply_to_email.py
    - 0025_notify_service_data.py
    - 0303_populate_services_org_id.py
    - 0096_update_job_stats.py
    - 0081_noti_status_as_enum.py
    - 0177_add_virus_scan_statuses.py
    - 0311_add_inbound_sms_history.py
    - 0083_add_perm_types_and_svc_perm.py
    - 0077_add_intl_notification.py
    - 0052_drop_jobs_status.py
    - 0207_set_callback_history_type.py
    - 0116_another_letter_org.py
    - 0051_set_job_status.py
    - 0023_add_research_mode.py
    - 0320_optimise_notifications.py
    - 0129_add_email_auth_permission_.py
    - 0203_fix_old_incomplete_jobs.py
    - 0143_remove_reply_to.py
    - 0082_add_golive_template.py
    - 0183_alter_primary_key.py
    - 0066_add_dvla_provider.py
    - 0122_add_service_letter_contact.py
    - 0040_adjust_mmg_provider_rate.py
    - 0032_notification_created_status.py
    - 0297_template_redacted_fix.py
    - 0234_ft_billing_postage.py
    - 0002_add_content_char_count.py
    - 0192_drop_provider_statistics.py
    - 0285_default_org_branding.py
    - 0206_assign_callback_type.py
    - 0178_add_filename.py
    - 0201_another_letter_org.py
    - 0230_noti_postage_constraint_1.py
    - 0197_service_contact_link.py
    - 0057_change_email_template.py
    - 0017_add_failure_types.py
    - 0278_add_more_stuff_to_orgs.py
    - 0154_nullable_is_blank.py
    - 0292_give_users_folder_perms.py
    - 0151_refactor_letter_rates.py
    - 0287_drop_branding_domains.py
    - 0068_add_created_by_to_provider.py
    - 0118_service_sms_senders.py
    - 0141_remove_unused.py
    - 0039_fix_notifications.py
    - 0262_remove_edit_folders.py
    - 0159_add_historical_redact.py
    - 0264_add_folder_permissions_perm.py
    - 0314_populate_email_access.py
    - 0289_precompiled_for_all.py
    - 0064_update_template_process_type.py
    - 0100_notification_created_by.py
    - 0215_email_brand_type.py
    - 0279_remove_fk_to_users.py
    - 0071_add_job_error_state.py
    - 0258_service_postage_nullable.py
    - 0101_een_logo.py
    - 0313_email_access_validated_at.py
    - 0128_noti_to_sms_sender.py
    - 0244_another_letter_org.py
    - 0158_remove_rate_limit_default.py
    - 0171_add_org_invite_template.py
    - 0027_update_provider_rates.py
    - 0088_add_schedule_serv_perm.py
    - 0132_add_sms_prefix_setting.py
    - 0134_add_email_2fa_template_.py
    - 0157_add_rate_limit_to_service.py
    - 0166_add_org_user_stuff.py
    - 0009_created_by_for_jobs.py
    - 0092_add_inbound_provider.py
    - 0099_tfl_dar.py
    - 0280_invited_user_folder_perms.py
    - 0301_upload_letters_permission.py
    - 0133_set_services_sms_prefix.py
    - 0282_add_count_as_live.py
    - 0204_service_data_retention.py
    - 0124_add_free_sms_fragment_limit.py
    - 0305_add_gp_org_type.py
    - 0021_add_delivered_failed_counts.py
    - 0304_remove_org_to_service.py
    - 0259_remove_service_postage.py
    - 0281_non_null_folder_permissions.py
    - 0102_template_redacted.py
    - 0199_another_letter_org.py
    - 0076_add_intl_flag_to_provider.py
    - 0182_add_upload_document_perm.py
    - 0248_enable_choose_postage.py
    - 0113_job_created_by_nullable.py
    - 0037_service_sms_sender.py
    - 0018_remove_subject_uniqueness.py
    - 0146_add_service_callback_api.py
    - 0084_add_job_stats.py
    - 0093_data_gov_uk.py
    - 0087_scheduled_notifications.py
    - 0265_add_confirm_edit_templates.py
    - 0075_create_rates_table.py
    - 0110_monthly_billing.py
    - 0062_provider_details_history.py
    - 0147_drop_mapping_tables.py
    - 0186_rename_is_active_columns.py
    - 0003_add_service_history.py
    - 0224_returned_letter_status.py
    - 0312_populate_returned_letters.py
    - 0014_add_template_version.py
    - 0200_another_letter_org.py
    - 0321_drop_postage_constraints.py
    - 0194_ft_billing_created_at.py
    - 0250_drop_stats_template_table.py
    - 0169_hidden_templates_nullable.py
    - 0109_rem_old_noti_status.py
    - 0209_add_cancelled_status.py
    - 0020_template_history_fix.py
    - 0008_archive_template.py
    - 0191_ft_billing_pkey.py
    - 0322_broadcast_service_perm.py
    - 0073_add_international_sms_flag.py
    - 0307_delete_dm_datetime.py
    - 0006_api_keys_history.py
    - 0149_add_crown_to_services.py
    - 0094_job_stats_update.py
    - 0050_index_for_stats.py
    - 0257_letter_branding_migration.py
    - 0155_revert_0153.py
    - 0015_fix_template_data.py
    - 0252_letter_branding_table.py
    - 0108_change_logo_not_nullable.py
    - 0181_billing_primary_key.py
    - 0221_nullable_service_branding.py
    - 0253_set_template_postage_.py
    - 0161_email_branding.py
    - 0184_alter_primary_key_1.py
    - 0310_returned_letters_table_.py
    - 0138_sms_sender_nullable.py
    - 0086_add_norm_to_notification.py
    - 0156_set_temp_letter_contact.py
    - 0232_noti_postage_constraint_3.py
    - 0231_noti_postage_constraint_2.py
    - 0208_fix_unique_index.py
    - 0210_remove_monthly_billing.py
    - 0072_add_dvla_orgs.py
    - 0144_template_service_letter.py
    - 0106_null_noti_status.py
    - 0070_fix_notify_user_email.py
    - 0219_default_email_branding.py
    - 0011_ad_provider_details.py
    - 0140_sms_prefix_non_nullable.py
    - 0127_remove_unique_constraint.py
    - 0055_service_whitelist.py
    - 0263_remove_edit_folders_2.py
    - 0167_add_precomp_letter_svc_perm.py
    - 0061_add_client_reference.py
    - 0126_add_annual_billing.py
    - 0031_store_personalisation.py
    - 0111_drop_old_service_flags.py
    - 0242_template_folders.py
    - 0172_deprioritise_examples.py
    - 0079_update_rates.py
    - 0238_add_validation_failed.py
    - 0217_default_email_branding.py
    - 0001_restart_migrations.py
    - 0294_add_verify_reply_to_.py
    - 0173_create_daily_sorted_letter.py
    - 0255_another_letter_org.py
    - 0319_contact_list_archived.py
    - 0085_update_incoming_to_inbound.py
    - 0130_service_email_reply_to_row.py
    - 0139_migrate_sms_allowance_data.py
    - 0091_letter_billing.py
    - 0007_template_history.py
    - 0316_int_letters_permission.py
    - 0198_add_caseworking_permission.py
    - 0251_another_letter_org.py
    - 0196_complaints_table_.py
    - 0045_billable_units.py
    - 0030_service_id_not_null.py
    - 0089_govuk_sms_sender.py
    - 0013_add_loadtest_client.py
    - 0097_notnull_inbound_provider.py
    - 0256_set_postage_tmplt_hstr.py
    - 0153_add_is_letter_contact_blank.py
    - 0115_add_inbound_numbers.py
    - 0074_update_sms_rate.py
    - 0059_set_services_to_active.py
    - 0163_add_new_org_model.py
    - 0056_minor_updates.py
    - 0205_service_callback_type.py
    - 0024_add_research_mode_defaults.py
    - 0315_document_download_count.py
    - 0012_complete_provider_details.py
    - 0170_hidden_non_nullable.py
    - 0029_fix_email_from.py
    - 0022_add_pending_status.py
    - 0048_job_scheduled_time.py
    - 0241_another_letter_org.py
    - 0041_email_template_.py
    - 0295_api_key_constraint.py
    - 0291_remove_unused_index.py
    - 0114_drop_monthly_billing_cols.py
    - 0112_add_start_end_dates.py
    - 0067_service_contact_block.py
    - 0235_add_postage_to_pk.py
    - 0162_remove_org.py
    - 0300_migrate_org_types.py
    - 0026_rename_notify_service.py
    - 0060_add_letter_template_type.py
    - 0160_another_letter_org.py
    - 0298_add_mou_signed_receipt.py
    - 0223_add_domain_constraint.py
    - 0120_add_org_banner_branding.py
    - 0212_remove_caseworking.py
    - 0105_opg_letter_org.py
    - 0137_notification_template_hist.py
    - 0125_add_organisation_type.py
    - 0188_add_ft_notification_status.py
    - 0046_organisations_and_branding.py
    - 0254_folders_for_all.py
    - 0010_events_table.py
    - 0189_ft_billing_data_type.py
    - 0227_postage_constraints.py
    - 0202_new_letter_pricing.py
    - 0090_inbound_sms.py
    - 0095_migrate_existing_svc_perms.py
    - 0078_add_sent_notification_status.py
    - 0225_another_letter_org.py
    - 0226_service_postage.py
    - 0033_api_key_type.py
    - 0058_add_letters_flag.py
    - 0121_nullable_logos.py
    - 0034_pwd_changed_at_not_null.py
    - 0220_email_brand_type_non_null.py
    - 0098_service_inbound_api.py
    - 0318_service_contact_list.py
    - 0180_another_letter_org.py
    - 0080_fix_rate_start_date.py
    - 0260_remove_dvla_organisation.py
    - 0175_drop_job_statistics_table.py
    - 0261_service_volumes.py
    - 0240_dvla_org_non_nullable.py
    - 0168_hidden_templates.py
    - 0246_notifications_index.py
    - 0135_stats_template_usage.py
    - 0145_add_notification_reply_to.py
    - 0047_ukvi_spelling.py
    - 0283_platform_admin_not_live.py
    - 0239_add_edit_folder_permission.py
    - 0053_cancelled_job_status.py
    - 0236_another_letter_org.py
    - 0299_org_types_table.py
    - 0296_agreement_signed_by_person.py
    - 0065_users_current_session_id.py
    - 0103_add_historical_redact.py
    - 0005_add_provider_stats.py
    - 0195_ft_notification_timestamps.py
    - 0308_delete_loadtesting_provider.py
    - 0104_more_letter_orgs.py
    - 0190_another_letter_org.py
    - 0179_billing_primary_const.py
    - 0185_add_is_active_to_reply_tos.py
    - 0302_add_org_id_to_services.py
    - 0288_add_go_live_user.py
    - 0306_letter_rates_price_rise.py
    - 0284_0283_retry.py
    - 0038_test_api_key_type.py
    - 0293_drop_complaint_fk.py
    - 0035_notification_type_.py
    - 0214_another_letter_org.py
    - 0237_add_filename_to_dvla_org.py
    - 0245_archived_flag_jobs.py
    - 0174_add_billing_facts.py
    - 0063_templates_process_type.py
    - 0243_another_letter_org.py
    - 0142_validate_constraints.py
    - 0216_remove_colours.py
    - 0249_another_letter_org.py
    - 0247_another_letter_org.py
    - 0117_international_sms_notify.py
    - 0290_org_go_live_notes.py
    - 0043_notification_indexes.py
    - 0150_another_letter_org.py
    - 0036_notif_key_type_not_null.py
    - 0222_drop_service_branding.py
    - 0054_perform_drop_status_column.py
    - 0176_alter_billing_columns.py
    - 0152_kill_service_free_fragments.py
    - 0044_jobs_to_notification_hist.py
    - 0136_user_mobile_nullable.py
    - 0004_notification_stats_date.py
    - 0119_add_email_reply_to.py
    - 0193_add_ft_billing_timestamps.py
    - 0277_consent_to_research_null.py
  - README.md
  - alembic.ini
  - script.py.mako
- manifest.yml.j2
- tests
  - test_all_queues_used.py
  - __init__.py
  - app
    - template_statistics
      - __init__.py
      - test_rest.py
    - template_folder
      - test_template_folder_rest.py
    - db.py
    - dao
      - test_returned_letters_dao.py
      - test_annual_billing_dao.py
      - test_complaint_dao.py
      - test_service_permissions_dao.py
      - notification_dao
        test_notification_dao_template_usage.py
        test_notification_dao.py
        __init__.py
        test_notification_dao_delete_notifications.py
        test_notification_dao_performance_platform.py
      - test_service_data_retention_dao.py
      - test_uploads_dao.py
      - test_daily_sorted_letter_dao.py
      - test_service_callback_api_dao.py
      - test_service_whitelist_dao.py
      - test_users_dao.py
      - test_provider_rates_dao.py
      - test_service_email_reply_to_dao.py
      - test_service_inbound_api_dao.py
      - test_date_utils.py
      - test_provider_details_dao.py
      - test_service_contact_list_dao.py
      - test_letter_branding_dao.py
      - test_service_letter_contact_dao.py
      - test_organisation_dao.py
      - test_email_branding_dao.py
      - test_api_key_dao.py
      - test_template_folder_dao.py
      - test_ft_billing_dao.py
      - test_inbound_sms_dao.py
      - test_service_sms_sender_dao.py
      - test_invited_user_dao.py
      - __init__.py
      - test_inbound_numbers_dao.py
      - test_services_dao.py
      - test_templates_dao.py
      - test_fact_notification_status_dao.py
      - test_permissions_dao.py
      - test_events_dao.py
      - test_jobs_dao.py
    - test_utils.py
    - complaint
      - __init__.py
      - test_complaint_rest.py
    - public_contracts
      - test_GET_notification.py
      - test_POST_notification.py
      - __init__.py
      - schemas
        v0
        email_notification.json
        definitions.json
        POST_notification_return_email.json
        GET_notifications_return.json
        sms_notification.json
        GET_notification_return_sms.json
        POST_notification_return_sms.json
        GET_notification_return_email.json
    - delivery
      - __init__.py
      - test_send_to_providers.py
    - email_branding
      - __init__.py
      - test_rest.py
    - organisation
      - test_invite_rest.py
      - test_rest.py
    - notifications
      - test_process_client_response.py
      - test_validators.py
      - test_process_letter_notifications.py
      - test_process_notification.py
      - __init__.py
      - rest
        test_callbacks.py
        test_send_notification.py
        __init__.py
      - test_receive_notification.py
      - test_notifications_ses_callback.py
      - test_rest.py
    - inbound_sms
      - __init__.py
      - test_rest.py
    - invite
      - test_invite_rest.py
      - __init__.py
    - user
      - __init__.py
      - test_rest_verify.py
      - test_rest.py
    - authentication
      - __init__.py
      - test_authentication.py
    - inbound_number
      - __init__.py
      - test_rest.py
    - provider_details
      - __init__.py
      - test_rest.py
    - billing
      - test_billing.py
    - v2
      - test_errors.py
      - notifications
        test_notification_schemas.py
        test_post_letter_notifications.py
        __init__.py
        test_get_notifications.py
        test_post_notifications.py
      - inbound_sms
        test_get_inbound_sms.py
        test_inbound_sms_schemas.py
        __init__.py
      - templates
        test_templates_schemas.py
        test_get_templates.py
      - template
        test_post_template.py
        test_get_template.py
        __init__.py
        test_template_schemas.py
      - __init__.py
    - test_route_authentication.py
    - commands
      - __init__.py
      - test_performance_platform_commands.py
    - celery
      - test_reporting_tasks.py
      - test_service_callback_tasks.py
      - test_process_ses_receipts_tasks.py
      - test_scheduled_tasks.py
      - test_ftp_update_tasks.py
      - test_tasks.py
      - test_letters_pdf_tasks.py
      - test_research_mode_tasks.py
      - test_provider_tasks.py
      - test_nightly_tasks.py
    - job
      - __init__.py
      - test_rest.py
    - test_cronitor.py
    - service
      - test_send_one_off_notification.py
      - test_utils.py
      - test_statistics_rest.py
      - test_suspend_resume_service.py
      - test_service_whitelist.py
      - test_send_pdf_letter_notification.py
      - test_schema.py
      - test_archived_service.py
      - test_url_for.py
      - test_api_key_endpoints.py
      - __init__.py
      - test_statistics.py
      - test_service_data_retention_rest.py
      - test_callback_rest.py
      - test_sender.py
      - test_service_contact_list_rest.py
      - test_rest.py
    - platform_stats
      - __init__.py
      - test_rest.py
    - clients
      - test_firetext.py
      - test_mmg.py
      - test_aws_ses.py
      - test_document_download.py
      - __init__.py
      - test_performance_platform.py
    - test_model.py
    - test_config.py
    - letter_branding
      - test_letter_branding_rest.py
      - __init__.py
    - accept_invite
      - test_accept_invite_rest.py
      - __init__.py
    - template
      - test_rest_history.py
      - __init__.py
      - test_rest.py
    - letters
      - test_letter_utils.py
      - test_returned_letters.py
      - __init__.py
    - __init__.py
    - performance_platform
      - test_processing_time.py
      - test_total_sent_notifications.py
    - test_cloudfoundry_config.py
    - aws
      - test_s3.py
    - conftest.py
    - events
      - __init__.py
      - test_rest.py
    - test_schemas.py
    - status
      - test_status.py
    - upload
      - __init__.py
      - test_rest.py
  - conftest.py
- pytest.ini
- scripts
  - paas_app_wrapper.sh
  - run_tests.sh
  - run_app_paas.sh
  - delete_sqs_queues.py
  - bootstrap.sh
  - check_if_new_migration.py
  - run_single_test.sh
  - run_multi_worker_app_paas.sh
  - run_celery_beat.sh
  - run_app.sh
  - run_celery.sh
  - common_functions.sh
  - fix_migrations.py
- statsd_mapping.yml
- requirements.txt
- paas-failwhale
  - manifest.yml
  - nginx.conf
  - README.md
- app
  - template_statistics
    - rest.py
    - __init__.py
  - template_folder
    - rest.py
    - __init__.py
    - template_folder_schema.py
  - dao
    - fact_billing_dao.py
    - provider_details_dao.py
    - service_whitelist_dao.py
    - service_contact_list_dao.py
    - dao_utils.py
    - date_util.py
    - annual_billing_dao.py
    - daily_sorted_letter_dao.py
    - permissions_dao.py
    - email_branding_dao.py
    - service_permissions_dao.py
    - service_data_retention_dao.py
    - service_letter_contact_dao.py
    - services_dao.py
    - letter_branding_dao.py
    - jobs_dao.py
    - notifications_dao.py
    - returned_letters_dao.py
    - service_callback_api_dao.py
    - service_inbound_api_dao.py
    - complaint_dao.py
    - inbound_numbers_dao.py
    - provider_rates_dao.py
    - service_user_dao.py
    - service_sms_sender_dao.py
    - api_key_dao.py
    - fact_notification_status_dao.py
    - __init__.py
    - uploads_dao.py
    - templates_dao.py
    - invited_user_dao.py
    - events_dao.py
    - organisation_dao.py
    - template_folder_dao.py
    - inbound_sms_dao.py
    - users_dao.py
    - service_email_reply_to_dao.py
    - invited_org_user_dao.py
  - complaint
    - complaint_schema.py
    - __init__.py
    - complaint_rest.py
  - delivery
    - __init__.py
    - send_to_providers.py
  - email_branding
    - email_branding_schema.py
    - rest.py
    - __init__.py
  - cloudfoundry_config.py
  - history_meta.py
  - organisation
    - organisation_schema.py
    - invite_rest.py
    - rest.py
    - __init__.py
  - exceptions.py
  - cronitor.py
  - notifications
    - notifications_sms_callback.py
    - process_letter_notifications.py
    - notifications_ses_callback.py
    - notifications_letter_callback.py
    - process_notifications.py
    - rest.py
    - __init__.py
    - receive_notifications.py
    - utils.py
    - validators.py
  - inbound_sms
    - rest.py
    - __init__.py
    - inbound_sms_schemas.py
  - invite
    - rest.py
    - __init__.py
  - config.py
  - variables.py
  - user
    - rest.py
    - __init__.py
    - users_schema.py
  - authentication
    - __init__.py
    - auth.py
  - inbound_number
    - rest.py
    - __init__.py
  - provider_details
    - rest.py
    - __init__.py
  - billing
    - rest.py
    - __init__.py
    - billing_schemas.py
  - v2
    - notifications
      - get_notifications.py
      - __init__.py
      - post_notifications.py
      - notification_schemas.py
      - create_response.py
    - inbound_sms
      - __init__.py
      - get_inbound_sms.py
      - inbound_sms_schemas.py
    - templates
      - get_templates.py
      - __init__.py
      - templates_schemas.py
    - template
      - post_template.py
      - get_template.py
      - template_schemas.py
      - __init__.py
    - __init__.py
    - utils.py
    - errors.py
  - celery
    - provider_tasks.py
    - scheduled_tasks.py
    - research_mode_tasks.py
    - reporting_tasks.py
    - tasks.py
    - service_callback_tasks.py
    - letters_pdf_tasks.py
    - __init__.py
    - nightly_tasks.py
    - celery.py
    - process_sms_client_response_tasks.py
    - process_ses_receipts_tasks.py
  - job
    - rest.py
    - __init__.py
  - models.py
  - service
    - statistics.py
    - service_senders_schema.py
    - callback_rest.py
    - service_data_retention_schema.py
    - sender.py
    - send_notification.py
    - rest.py
    - __init__.py
    - service_callback_api_schema.py
    - utils.py
    - service_contact_list_schema.py
    - send_pdf_letter_schema.py
  - platform_stats
    - platform_stats_schema.py
    - rest.py
    - __init__.py
  - version.py.dist
  - serialised_models.py
  - clients
    - email
      - aws_ses.py
      - __init__.py
      - aws_ses_stub.py
    - document_download.py
    - __init__.py
    - performance_platform
      - __init__.py
      - performance_platform_client.py
    - sms
      - firetext.py
      - __init__.py
      - mmg.py
  - schemas.py
  - commands.py
  - schema_validation
    - definitions.py
    - __init__.py
  - letter_branding
    - letter_branding_schema.py
    - letter_branding_rest.py
    - __init__.py
  - accept_invite
    - rest.py
    - __init__.py
  - template
    - rest.py
    - template_schemas.py
    - __init__.py
  - letters
    - letter_schemas.py
    - rest.py
    - __init__.py
    - utils.py
  - __init__.py
  - performance_platform
    - total_sent_notifications.py
    - processing_time.py
    - __init__.py
  - utils.py
  - errors.py
  - .gitignore
  - hashing.py
  - aws
    - s3.py
    - __init__.py
  - events
    - rest.py
    - __init__.py
  - status
    - healthcheck.py
    - __init__.py
  - upload
    - rest.py
    - __init__.py
- .gitignore
- .pyup.yml

"""

Revision ID: 0266_user_folder_perms_table
Revises: 0265_add_confirm_edit_templates
Create Date: 2019-02-26 17:00:13.247321

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

revision = '0266_user_folder_perms_table'
down_revision = '0265_add_confirm_edit_templates'


def upgrade():
    op.create_unique_constraint('ix_id_service_id', 'template_folder', ['id', 'service_id'])
    op.create_table('user_folder_permissions',
        sa.Column('user_id', postgresql.UUID(as_uuid=True), nullable=False),
        sa.Column('template_folder_id', postgresql.UUID(as_uuid=True), nullable=False),
        sa.Column('service_id', postgresql.UUID(as_uuid=True), nullable=False),
        sa.ForeignKeyConstraint(['template_folder_id', 'service_id'], ['template_folder.id', 'template_folder.service_id'], ),
        sa.ForeignKeyConstraint(['user_id', 'service_id'], ['user_to_service.user_id', 'user_to_service.service_id'], ),
        sa.ForeignKeyConstraint(['template_folder_id'], ['template_folder.id'], ),
        sa.PrimaryKeyConstraint('user_id', 'template_folder_id', 'service_id'),
    )



def downgrade():
    op.drop_table('user_folder_permissions')
    op.drop_constraint('ix_id_service_id', 'template_folder', type_='unique')