• Home
• sk.objectify
• notiflow
• 1.1.44
• source code
• V0_0_23__constrans_and_indexes.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V0_0_23__constrans_and_indexes.sql Maven / Gradle / Ivy

/*
 *   Copyright (C) 2021 the original author or authors.
 *
 *   This file is part of Notiflow
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Lesser General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Lesser General Public License for more details.
 *
 *   You should have received a copy of the GNU Lesser General Public License
 *   along with this program.  If not, see .
 */

CREATE INDEX nc_delivery_info_event_id_idx ON nc_delivery_info (event_id);
CREATE INDEX nc_delivery_info_message_id_idx ON nc_delivery_info (message_id);
CREATE INDEX nc_delivery_info_endpoint_id_idx ON nc_delivery_info (endpoint_id);
ALTER INDEX nc_event_2_endpoint_delivery_pk RENAME TO nc_delivery_info_pk;

ALTER INDEX nc_endpoint_endpoint_id_unique_key RENAME TO nc_endpoint_name_unique_key;

CREATE INDEX nc_intent_event_ids_idx ON nc_intent USING GIN (event_ids);

CREATE INDEX nc_message_event_ids_idx ON nc_message USING GIN (event_ids);
CREATE INDEX nc_message_endpoint_ids_idx ON nc_message USING GIN (endpoint_ids);