Skip to content

Instantly share code, notes, and snippets.

@AlanCoding
Created May 16, 2024 14:08
Show Gist options
  • Save AlanCoding/dcd9e67e02423e5524450b8150a4d6d8 to your computer and use it in GitHub Desktop.
Save AlanCoding/dcd9e67e02423e5524450b8150a4d6d8 to your computer and use it in GitHub Desktop.
-- Detecting notnull changes not implemented for this database backend
BEGIN;
-- Application: main
-- Model: Role
ALTER TABLE "main_rbac_roles"
MODIFY "object_id" integer;
-- Model: RoleAncestorEntry
ALTER TABLE "main_rbac_role_ancestors"
MODIFY "content_type_id" integer;
ALTER TABLE "main_rbac_role_ancestors"
MODIFY "object_id" integer;
-- Model: ExecutionEnvironment
ALTER TABLE "main_executionenvironment"
MODIFY "name" varchar(512);
ALTER TABLE "main_executionenvironment"
MODIFY "image" varchar(1024);
ALTER TABLE "main_executionenvironment"
MODIFY "pull" varchar(16);
-- Model: UnifiedJobTemplate
ALTER TABLE "main_unifiedjobtemplate"
MODIFY "name" varchar(512);
ALTER TABLE "main_unifiedjobtemplate"
MODIFY "old_pk" integer;
ALTER TABLE "main_unifiedjobtemplate"
MODIFY "status" varchar(32);
-- Model: UnifiedJobDeprecatedStdout
DROP INDEX "main_unifiedjob_created_by_id_d2a186ab_fk_auth_user_id";
DROP INDEX "main_unifiedjob_emitted_events_check";
DROP INDEX "main_unifiedjob_execution_environmen_b2eaf9c0_fk_main_exec";
DROP INDEX "main_unifiedjob_instance_group_id_f76a06e2_fk_main_inst";
DROP INDEX "main_unifiedjob_modified_by_id_14cbb9bc_fk_auth_user_id";
DROP INDEX "main_unifiedjob_old_pk_check";
DROP INDEX "main_unifiedjob_organization_id_cbfa01d3_fk_main_orga";
DROP INDEX "main_unifiedjob_polymorphic_ctype_id_cb46239b_fk_django_co";
DROP INDEX "main_unifiedjob_schedule_id_766ca767_fk_main_schedule_id";
DROP INDEX "main_unifiedjob_task_impact_check";
DROP INDEX "main_unifiedjob_unified_job_template_a398b197_fk_main_unif";
DROP INDEX "main_unifiedjob_canceled_on_8695ca21";
DROP INDEX "main_unifiedjob_created_94704da7";
DROP INDEX "main_unifiedjob_created_by_id_d2a186ab";
DROP INDEX "main_unifiedjob_execution_environment_id_b2eaf9c0";
DROP INDEX "main_unifiedjob_finished_eccf6159";
DROP INDEX "main_unifiedjob_instance_group_id_f76a06e2";
DROP INDEX "main_unifiedjob_launch_type_f97c0639";
DROP INDEX "main_unifiedjob_launch_type_f97c0639_like";
DROP INDEX "main_unifiedjob_modified_by_id_14cbb9bc";
DROP INDEX "main_unifiedjob_organization_id_cbfa01d3";
DROP INDEX "main_unifiedjob_polymorphic_ctype_id_cb46239b";
DROP INDEX "main_unifiedjob_schedule_id_766ca767";
DROP INDEX "main_unifiedjob_status_ea421be2";
DROP INDEX "main_unifiedjob_status_ea421be2_like";
DROP INDEX "main_unifiedjob_unified_job_template_id_a398b197";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "created";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "modified";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "description";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "name";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "old_pk";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "launch_type";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "cancel_flag";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "status";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "failed";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "started";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "finished";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "elapsed";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "job_args";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "job_cwd";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "job_explanation";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "start_args";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "result_traceback";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "celery_task_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "created_by_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "modified_by_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "polymorphic_ctype_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "schedule_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "unified_job_template_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "execution_node";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "instance_group_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "emitted_events";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "controller_node";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "canceled_on";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "dependencies_processed";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "organization_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "execution_environment_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "installed_collections";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "ansible_version";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "work_unit_id";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "host_status_counts";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "preferred_instance_groups_cache";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "task_impact";
ALTER TABLE "main_unifiedjob"
DROP COLUMN "job_env";
-- Model: UnifiedJob
ALTER TABLE "main_unifiedjob"
DROP COLUMN "result_stdout_text";
ALTER TABLE "main_unifiedjob"
MODIFY "name" varchar(512);
ALTER TABLE "main_unifiedjob"
MODIFY "old_pk" integer;
ALTER TABLE "main_unifiedjob"
MODIFY "emitted_events" integer;
ALTER TABLE "main_unifiedjob"
MODIFY "launch_type" varchar(20);
ALTER TABLE "main_unifiedjob"
MODIFY "status" varchar(20);
ALTER TABLE "main_unifiedjob"
MODIFY "job_cwd" varchar(1024);
ALTER TABLE "main_unifiedjob"
MODIFY "celery_task_id" varchar(100);
ALTER TABLE "main_unifiedjob"
MODIFY "task_impact" integer;
ALTER TABLE "main_unifiedjob"
MODIFY "ansible_version" varchar(255);
ALTER TABLE "main_unifiedjob"
MODIFY "work_unit_id" varchar(255);
-- Model: Organization
ALTER TABLE "main_organization"
MODIFY "name" varchar(512);
ALTER TABLE "main_organization"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_organization"
MODIFY "max_hosts" integer;
-- Model: OrganizationGalaxyCredentialMembership
ALTER TABLE "main_organizationgalaxycredentialmembership"
MODIFY "position" integer;
-- Model: Team
ALTER TABLE "main_team"
MODIFY "name" varchar(512);
-- Model: Profile
ALTER TABLE "main_profile"
MODIFY "ldap_dn" varchar(1024);
-- Model: Credential
ALTER TABLE "main_credential"
MODIFY "name" varchar(512);
-- Model: CredentialType
ALTER TABLE "main_credentialtype"
MODIFY "name" varchar(512);
ALTER TABLE "main_credentialtype"
MODIFY "kind" varchar(32);
ALTER TABLE "main_credentialtype"
MODIFY "namespace" varchar(1024);
-- Model: CredentialInputSource
ALTER TABLE "main_credentialinputsource"
MODIFY "input_field_name" varchar(1024);
-- Model: JobEvent
ALTER TABLE "main_jobevent"
DROP CONSTRAINT "main_jobevent_pkey_new";
ALTER TABLE "main_jobevent"
ADD CONSTRAINT "main_jobevent_id_c1990d33_uniq" UNIQUE ("id");
ALTER TABLE "main_jobevent"
MODIFY "event" varchar(100);
ALTER TABLE "main_jobevent"
MODIFY "uuid" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "playbook" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "play" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "role" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "task" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "counter" integer;
ALTER TABLE "main_jobevent"
MODIFY "verbosity" integer;
ALTER TABLE "main_jobevent"
MODIFY "start_line" integer;
ALTER TABLE "main_jobevent"
MODIFY "end_line" integer;
ALTER TABLE "main_jobevent"
MODIFY "host_name" varchar(1024);
ALTER TABLE "main_jobevent"
MODIFY "parent_uuid" varchar(1024);
-- Model: ProjectUpdateEvent
ALTER TABLE "main_projectupdateevent"
DROP CONSTRAINT "main_projectupdateevent_pkey_new";
ALTER TABLE "main_projectupdateevent"
ADD CONSTRAINT "main_projectupdateevent_id_3a7deea1_uniq" UNIQUE ("id");
ALTER TABLE "main_projectupdateevent"
MODIFY "event" varchar(100);
ALTER TABLE "main_projectupdateevent"
MODIFY "uuid" varchar(1024);
ALTER TABLE "main_projectupdateevent"
MODIFY "playbook" varchar(1024);
ALTER TABLE "main_projectupdateevent"
MODIFY "play" varchar(1024);
ALTER TABLE "main_projectupdateevent"
MODIFY "role" varchar(1024);
ALTER TABLE "main_projectupdateevent"
MODIFY "task" varchar(1024);
ALTER TABLE "main_projectupdateevent"
MODIFY "counter" integer;
ALTER TABLE "main_projectupdateevent"
MODIFY "verbosity" integer;
ALTER TABLE "main_projectupdateevent"
MODIFY "start_line" integer;
ALTER TABLE "main_projectupdateevent"
MODIFY "end_line" integer;
-- Model: AdHocCommandEvent
ALTER TABLE "main_adhoccommandevent"
DROP CONSTRAINT "main_adhoccommandevent_pkey_new";
ALTER TABLE "main_adhoccommandevent"
ADD CONSTRAINT "main_adhoccommandevent_id_6c3a6485_uniq" UNIQUE ("id");
ALTER TABLE "main_adhoccommandevent"
MODIFY "uuid" varchar(1024);
ALTER TABLE "main_adhoccommandevent"
MODIFY "counter" integer;
ALTER TABLE "main_adhoccommandevent"
MODIFY "verbosity" integer;
ALTER TABLE "main_adhoccommandevent"
MODIFY "start_line" integer;
ALTER TABLE "main_adhoccommandevent"
MODIFY "end_line" integer;
ALTER TABLE "main_adhoccommandevent"
MODIFY "event" varchar(100);
ALTER TABLE "main_adhoccommandevent"
MODIFY "host_name" varchar(1024);
-- Model: InventoryUpdateEvent
ALTER TABLE "main_inventoryupdateevent"
DROP CONSTRAINT "main_inventoryupdateevent_pkey_new";
ALTER TABLE "main_inventoryupdateevent"
ADD CONSTRAINT "main_inventoryupdateevent_id_71df1d21_uniq" UNIQUE ("id");
ALTER TABLE "main_inventoryupdateevent"
MODIFY "uuid" varchar(1024);
ALTER TABLE "main_inventoryupdateevent"
MODIFY "counter" integer;
ALTER TABLE "main_inventoryupdateevent"
MODIFY "verbosity" integer;
ALTER TABLE "main_inventoryupdateevent"
MODIFY "start_line" integer;
ALTER TABLE "main_inventoryupdateevent"
MODIFY "end_line" integer;
-- Model: SystemJobEvent
ALTER TABLE "main_systemjobevent"
DROP CONSTRAINT "main_systemjobevent_pkey_new";
ALTER TABLE "main_systemjobevent"
ADD CONSTRAINT "main_systemjobevent_id_0d18ec99_uniq" UNIQUE ("id");
ALTER TABLE "main_systemjobevent"
MODIFY "uuid" varchar(1024);
ALTER TABLE "main_systemjobevent"
MODIFY "counter" integer;
ALTER TABLE "main_systemjobevent"
MODIFY "verbosity" integer;
ALTER TABLE "main_systemjobevent"
MODIFY "start_line" integer;
ALTER TABLE "main_systemjobevent"
MODIFY "end_line" integer;
-- Model: NotificationTemplate
ALTER TABLE "main_notificationtemplate"
MODIFY "name" varchar(512);
ALTER TABLE "main_notificationtemplate"
MODIFY "notification_type" varchar(32);
-- Model: Notification
ALTER TABLE "main_notification"
MODIFY "status" varchar(20);
ALTER TABLE "main_notification"
MODIFY "notification_type" varchar(32);
-- Model: JobTemplate
ALTER TABLE "main_jobtemplate"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_jobtemplate"
MODIFY "webhook_service" varchar(16);
ALTER TABLE "main_jobtemplate"
MODIFY "webhook_key" varchar(64);
ALTER TABLE "main_jobtemplate"
MODIFY "playbook" varchar(1024);
ALTER TABLE "main_jobtemplate"
MODIFY "scm_branch" varchar(1024);
ALTER TABLE "main_jobtemplate"
MODIFY "forks" integer;
ALTER TABLE "main_jobtemplate"
MODIFY "verbosity" integer;
ALTER TABLE "main_jobtemplate"
MODIFY "skip_tags" varchar(1024);
ALTER TABLE "main_jobtemplate"
MODIFY "start_at_task" varchar(1024);
ALTER TABLE "main_jobtemplate"
MODIFY "job_type" varchar(64);
ALTER TABLE "main_jobtemplate"
MODIFY "host_config_key" varchar(1024);
ALTER TABLE "main_jobtemplate"
MODIFY "job_slice_count" integer;
-- Model: Job
ALTER TABLE "main_job"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_job"
MODIFY "webhook_service" varchar(16);
ALTER TABLE "main_job"
MODIFY "webhook_guid" varchar(128);
ALTER TABLE "main_job"
MODIFY "job_type" varchar(64);
ALTER TABLE "main_job"
MODIFY "playbook" varchar(1024);
ALTER TABLE "main_job"
MODIFY "scm_branch" varchar(1024);
ALTER TABLE "main_job"
MODIFY "forks" integer;
ALTER TABLE "main_job"
MODIFY "verbosity" integer;
ALTER TABLE "main_job"
MODIFY "skip_tags" varchar(1024);
ALTER TABLE "main_job"
MODIFY "start_at_task" varchar(1024);
ALTER TABLE "main_job"
MODIFY "scm_revision" varchar(1024);
ALTER TABLE "main_job"
MODIFY "job_slice_number" integer;
ALTER TABLE "main_job"
MODIFY "job_slice_count" integer;
-- Model: JobHostSummary
ALTER TABLE "main_jobhostsummary"
MODIFY "host_name" varchar(1024);
ALTER TABLE "main_jobhostsummary"
MODIFY "changed" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "dark" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "failures" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "ignored" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "ok" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "processed" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "rescued" integer;
ALTER TABLE "main_jobhostsummary"
MODIFY "skipped" integer;
-- Model: SystemJobTemplate
ALTER TABLE "main_systemjobtemplate"
MODIFY "job_type" varchar(32);
-- Model: SystemJob
ALTER TABLE "main_systemjob"
MODIFY "job_type" varchar(32);
-- Model: Project
ALTER TABLE "main_project"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_project"
MODIFY "local_path" varchar(1024);
ALTER TABLE "main_project"
MODIFY "scm_type" varchar(8);
ALTER TABLE "main_project"
MODIFY "scm_url" varchar(1024);
ALTER TABLE "main_project"
MODIFY "scm_branch" varchar(256);
ALTER TABLE "main_project"
MODIFY "scm_refspec" varchar(1024);
ALTER TABLE "main_project"
MODIFY "scm_update_cache_timeout" integer;
ALTER TABLE "main_project"
MODIFY "scm_revision" varchar(1024);
-- Model: ProjectUpdate
ALTER TABLE "main_projectupdate"
MODIFY "local_path" varchar(1024);
ALTER TABLE "main_projectupdate"
MODIFY "scm_type" varchar(8);
ALTER TABLE "main_projectupdate"
MODIFY "scm_url" varchar(1024);
ALTER TABLE "main_projectupdate"
MODIFY "scm_branch" varchar(256);
ALTER TABLE "main_projectupdate"
MODIFY "scm_refspec" varchar(1024);
ALTER TABLE "main_projectupdate"
MODIFY "job_type" varchar(64);
ALTER TABLE "main_projectupdate"
MODIFY "job_tags" varchar(1024);
ALTER TABLE "main_projectupdate"
MODIFY "scm_revision" varchar(1024);
-- Model: ReceptorAddress
ALTER TABLE "main_receptoraddress"
DROP CONSTRAINT "unique_receptor_address";
ALTER TABLE "main_receptoraddress"
MODIFY "address" varchar(255);
ALTER TABLE "main_receptoraddress"
MODIFY "websocket_path" varchar(255);
ALTER TABLE "main_receptoraddress"
MODIFY "protocol" varchar(10);
-- Model: InventoryConstructedInventoryMembership
ALTER TABLE "main_inventoryconstructedinventorymembership"
MODIFY "position" integer;
-- Model: Inventory
ALTER TABLE "main_inventory"
MODIFY "name" varchar(512);
ALTER TABLE "main_inventory"
MODIFY "total_hosts" integer;
ALTER TABLE "main_inventory"
MODIFY "hosts_with_active_failures" integer;
ALTER TABLE "main_inventory"
MODIFY "total_groups" integer;
ALTER TABLE "main_inventory"
MODIFY "total_inventory_sources" integer;
ALTER TABLE "main_inventory"
MODIFY "inventory_sources_with_failures" integer;
ALTER TABLE "main_inventory"
MODIFY "kind" varchar(32);
-- Model: Host
DROP INDEX "host_ansible_facts_default_gin";
ALTER TABLE "main_host"
MODIFY "name" varchar(512);
ALTER TABLE "main_host"
MODIFY "instance_id" varchar(1024);
-- Model: Group
ALTER TABLE "main_group"
MODIFY "name" varchar(512);
-- Model: HostMetric
ALTER TABLE "main_hostmetric"
MODIFY "hostname" varchar(512);
-- Model: InventorySource
ALTER TABLE "main_inventorysource"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_inventorysource"
MODIFY "source" varchar(32);
ALTER TABLE "main_inventorysource"
MODIFY "source_path" varchar(1024);
ALTER TABLE "main_inventorysource"
MODIFY "scm_branch" varchar(1024);
ALTER TABLE "main_inventorysource"
MODIFY "verbosity" integer;
ALTER TABLE "main_inventorysource"
MODIFY "update_cache_timeout" integer;
-- Model: InventoryUpdate
ALTER TABLE "main_inventoryupdate"
MODIFY "custom_virtualenv" varchar(100);
ALTER TABLE "main_inventoryupdate"
MODIFY "source" varchar(32);
ALTER TABLE "main_inventoryupdate"
MODIFY "source_path" varchar(1024);
ALTER TABLE "main_inventoryupdate"
MODIFY "scm_branch" varchar(1024);
ALTER TABLE "main_inventoryupdate"
MODIFY "verbosity" integer;
ALTER TABLE "main_inventoryupdate"
MODIFY "scm_revision" varchar(1024);
-- Model: CustomInventoryScript
ALTER TABLE "main_custominventoryscript"
MODIFY "name" varchar(512);
-- Model: AdHocCommand
ALTER TABLE "main_adhoccommand"
MODIFY "job_type" varchar(64);
ALTER TABLE "main_adhoccommand"
MODIFY "module_name" varchar(1024);
ALTER TABLE "main_adhoccommand"
MODIFY "forks" integer;
ALTER TABLE "main_adhoccommand"
MODIFY "verbosity" integer;
-- Model: Schedule
ALTER TABLE "main_schedule"
MODIFY "name" varchar(512);
-- Model: ActivityStream
ALTER TABLE "main_activitystream"
MODIFY "operation" varchar(13);
ALTER TABLE "main_activitystream"
MODIFY "action_node" varchar(512);
-- Model: InstanceLink
ALTER TABLE "main_instancelink"
MODIFY "link_state" varchar(16);
-- Model: Instance
DROP INDEX "unique_ip_address_not_empty";
ALTER TABLE "main_instance"
ADD CONSTRAINT "main_instance_ip_address_28190262_uniq" UNIQUE ("ip_address");
ALTER TABLE "main_instance"
MODIFY "uuid" varchar(40);
ALTER TABLE "main_instance"
MODIFY "hostname" varchar(250);
ALTER TABLE "main_instance"
MODIFY "ip_address" varchar(50);
ALTER TABLE "main_instance"
MODIFY "version" varchar(120);
ALTER TABLE "main_instance"
MODIFY "capacity" integer;
ALTER TABLE "main_instance"
MODIFY "node_type" varchar(16);
ALTER TABLE "main_instance"
MODIFY "node_state" varchar(16);
-- Model: InstanceGroup
ALTER TABLE "main_instancegroup"
MODIFY "name" varchar(250);
-- Model: UnifiedJobTemplateInstanceGroupMembership
ALTER TABLE "main_unifiedjobtemplateinstancegroupmembership"
MODIFY "position" integer;
-- Model: OrganizationInstanceGroupMembership
ALTER TABLE "main_organizationinstancegroupmembership"
MODIFY "position" integer;
-- Model: InventoryInstanceGroupMembership
ALTER TABLE "main_inventoryinstancegroupmembership"
MODIFY "position" integer;
-- Model: JobLaunchConfigInstanceGroupMembership
ALTER TABLE "main_joblaunchconfiginstancegroupmembership"
MODIFY "position" integer;
-- Model: ScheduleInstanceGroupMembership
ALTER TABLE "main_scheduleinstancegroupmembership"
MODIFY "position" integer;
-- Model: WorkflowJobTemplateNodeBaseInstanceGroupMembership
ALTER TABLE "main_workflowjobtemplatenodebaseinstancegroupmembership"
MODIFY "position" integer;
-- Model: WorkflowJobNodeBaseInstanceGroupMembership
ALTER TABLE "main_workflowjobnodebaseinstancegroupmembership"
MODIFY "position" integer;
-- Model: WorkflowJobInstanceGroupMembership
ALTER TABLE "main_workflowjobinstancegroupmembership"
MODIFY "position" integer;
-- Model: WorkflowJobTemplateNode
ALTER TABLE "main_workflowjobtemplatenode"
MODIFY "identifier" varchar(512);
-- Model: WorkflowJobNode
ALTER TABLE "main_workflowjobnode"
MODIFY "identifier" varchar(512);
-- Model: WorkflowJobTemplate
ALTER TABLE "main_workflowjobtemplate"
MODIFY "webhook_service" varchar(16);
ALTER TABLE "main_workflowjobtemplate"
MODIFY "webhook_key" varchar(64);
-- Model: WorkflowJob
ALTER TABLE "main_workflowjob"
MODIFY "webhook_service" varchar(16);
ALTER TABLE "main_workflowjob"
MODIFY "webhook_guid" varchar(128);
-- Model: Label
ALTER TABLE "main_label"
MODIFY "name" varchar(512);
-- Model: OAuth2Application
ALTER TABLE "main_oauth2application"
MODIFY "client_id" varchar(100);
ALTER TABLE "main_oauth2application"
MODIFY "name" varchar(255);
ALTER TABLE "main_oauth2application"
MODIFY "algorithm" varchar(5);
ALTER TABLE "main_oauth2application"
MODIFY "client_secret" varchar(1024);
ALTER TABLE "main_oauth2application"
MODIFY "client_type" varchar(32);
ALTER TABLE "main_oauth2application"
MODIFY "authorization_grant_type" varchar(32);
-- Model: OAuth2AccessToken
ALTER TABLE "main_oauth2accesstoken"
MODIFY "token" varchar(255);
-- Application: dab_rbac
-- Model: DABPermission
ALTER TABLE "dab_rbac_dabpermission"
MODIFY "name" varchar(255);
ALTER TABLE "dab_rbac_dabpermission"
MODIFY "codename" varchar(100);
-- Model: RoleDefinition_permissions
ALTER TABLE "dab_rbac_roledefinition_permissions"
MODIFY "id" bigint;
-- Model: ObjectRole_provides_teams
ALTER TABLE "dab_rbac_objectrole_provides_teams"
MODIFY "id" bigint;
-- Model: RoleEvaluation
ALTER TABLE "dab_rbac_roleevaluation"
MODIFY "content_type_id" integer;
ALTER TABLE "dab_rbac_roleevaluation"
MODIFY "object_id" integer;
-- Model: RoleEvaluationUUID
ALTER TABLE "dab_rbac_roleevaluationuuid"
MODIFY "content_type_id" integer;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment