text: # --- !Ups
  CREATE TABLE favorite_project (
    id                        BIGINT AUTO_INCREMENT NOT NULL,
    user_id                   BIGINT,
    project_id                BIGINT,
    owner                     VARCHAR(255),
    project_name              VARCHAR(255),
    CONSTRAINT pk_favorite_project PRIMARY KEY (id),
    CONSTRAINT uq_favorite_project_user_id_project_id_1 UNIQUE (user_id, project_id),
    CONSTRAINT fk_favorite_project_user FOREIGN KEY (user_id) REFERENCES n4user (id) on DELETE CASCADE,
    CONSTRAINT fk_favorite_project_project FOREIGN KEY (project_id) REFERENCES project (id) on DELETE CASCADE
    )
    row_format=compressed, key_block_size=8
  ;
  
  CREATE index ix_favorite_project_user_1 ON favorite_project (user_id);
  CREATE index ix_favorite_project_project_2 ON favorite_project (project_id);
  
  CREATE TABLE favorite_organization (
    id                        BIGINT AUTO_INCREMENT NOT NULL,
    user_id                   BIGINT,
    organization_id           BIGINT,
    organization_name        VARCHAR(255),
    CONSTRAINT pk_favorite_organization PRIMARY KEY (id),
    CONSTRAINT uq_favorite_organization_user_id_organization_id_1 UNIQUE (user_id, organization_id),
    CONSTRAINT fk_favorite_organization_user FOREIGN KEY (user_id) REFERENCES n4user (id) on DELETE CASCADE,
    CONSTRAINT fk_favorite_organization_organization FOREIGN KEY (organization_id) REFERENCES organization (id) on DELETE CASCADE
    )
    row_format=compressed, key_block_size=8
  ;
  
  CREATE index ix_favorite_organization_user_1 ON favorite_organization (user_id);
  CREATE index ix_favorite_organization_organization_2 ON favorite_organization (organization_id);
  
  # --- !Downs
  DROP TABLE favorite_project;
  DROP TABLE favorite_organization;
  