• Home
• sk.objectify
• notiflow
• 1.1.39
• source code
• V0_0_4__alter_json_2_jsonb.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_4__alter_json_2_jsonb.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 .
 */

ALTER TABLE nc_processing_info
  ALTER COLUMN event_ids
  SET DATA TYPE jsonb
  USING event_ids::jsonb;
 
ALTER TABLE nc_processing_info
  ALTER COLUMN event_json
  SET DATA TYPE jsonb
  USING event_json::jsonb;
  
ALTER TABLE nc_processing_info
  ALTER COLUMN event_json_diff
  SET DATA TYPE jsonb
  USING event_json_diff::jsonb;