thuductpc.sql

BEGIN;
-- Model missing for table: pg_stat_statements
-- Model missing for table: crm_crmfield
-- Model missing for table: qna_qnaquestion
-- Model missing for table: trello_sync_card
-- Model missing for table: trello_sync_trelloprofile
-- Model missing for table: crm_activity
-- Model missing for table: crm_affiliateuser
-- Model missing for table: crm_autopipelinetask
-- Model missing for table: crm_autotask
-- Model missing for table: crm_crmfeature
-- Model missing for table: crm_exporteddataloger
-- Model missing for table: crm_follower
-- Model missing for table: crm_formintegration
-- Model missing for table: crm_importeddatalogger
-- Model missing for table: crm_person
-- Model missing for table: crm_productvariation
-- Model missing for table: crm_product
-- Model missing for table: crm_soldproduct
-- Model missing for table: crm_company
-- Model missing for table: crm_deal
-- Model missing for table: crm_stage
-- Model missing for table: crm_stagedeal
-- Model missing for table: crm_pipeline
-- Model missing for table: crm_team_pipelines
-- Model missing for table: crm_team
-- Model missing for table: deepmind_selfchatlog
-- Model missing for table: tracking_pageview
-- Model missing for table: tracking_visitor
-- Application: performance
-- Model: KPIBackup
ALTER TABLE "performance_kpibackup"
        ALTER "data" TYPE jsonb USING data::jsonb;
-- Model: KVStore
ALTER TABLE "performance_kvstore"
        ALTER "data" TYPE jsonb USING data::jsonb;
-- Model: KPI
ALTER TABLE "performance_kpi"
        ADD COLUMN "children_data" jsonb;
ALTER TABLE "performance_kpi"
        ALTER "year_data" TYPE jsonb USING year_data::jsonb;
-- Model: KpiComment
ALTER TABLE "performance_kpicomment"
        ALTER COLUMN "kpi_unique_key" SET NOT NULL;
-- Application: company
-- Model: Organization
ALTER TABLE "company_organization"
        DROP COLUMN "can_delete_deal";
ALTER TABLE "company_organization"
        DROP COLUMN "can_see_company_statistic";
ALTER TABLE "company_organization"
        DROP COLUMN "can_see_contact";
ALTER TABLE "company_organization"
        DROP COLUMN "can_see_deal_other";
ALTER TABLE "company_organization"
        DROP COLUMN "can_see_user_statistic";
ALTER TABLE "company_organization"
        DROP COLUMN "enable_bsc";
ALTER TABLE "company_organization"
        DROP COLUMN "enable_drag_review";
ALTER TABLE "company_organization"
        DROP COLUMN "saleup_auto_expiration_email";
ALTER TABLE "company_organization"
        DROP COLUMN "saleup_free";
ALTER TABLE "company_organization"
        DROP COLUMN "saleup_package";
ALTER TABLE "company_organization"
        DROP COLUMN "saleup_trial";
ALTER TABLE "company_organization"
        DROP COLUMN "show_timeline";
ALTER TABLE "company_organization"
        ADD COLUMN "relation_definition" jsonb;
ALTER TABLE "company_organization"
        ADD COLUMN "default_auto_score_parent" boolean NOT NULL DEFAULT TRUE;
-- Application: notifications
-- Model: Notification
DROP INDEX "notifications_notification_deleted_b32b69e6_uniq";
DROP INDEX "notifications_notification_unread_cce4be30_uniq";

ALTER TABLE "notifications_notification"
        ALTER "data" TYPE jsonb USING data::jsonb;
-- Application: tip
-- Model: Tip
-- Table missing: tip_tip
-- Application: easy_select2
-- Model: Related
-- Table missing: easy_select2_related
-- Model: TestFieldsModel_m2m_field
-- Table missing: easy_select2_testfieldsmodel_m2m_field
-- Model: TestFieldsModel
-- Table missing: easy_select2_testfieldsmodel
-- Model: EmptyModel
-- Table missing: easy_select2_emptymodel
-- Application: corsheaders
-- Model: CorsModel
-- Table missing: corsheaders_corsmodel
-- Application: actstream
-- Model: Action
ALTER TABLE "actstream_action"
        ALTER "data" TYPE jsonb USING data::jsonb;
-- Application: extrascore
-- Model: ExScore
ALTER TABLE "extrascore_exscore"
        ALTER "group" TYPE varchar(4000);
COMMIT;