migration.sql

-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: master.xml
-- Ran at: 28/02/2022, 16:16
-- Against: postgres@jdbc:postgresql://localhost:5432/postgres
-- Liquibase version: 4.8.0
-- *********************************************************************
-- Changeset current/20211206-add-locale-to-user-profile.xml::add-locale-to-use-profile::msavy marc@blackparrotlabs.io (manual changeset)
ALTER TABLE public.users ADD locale VARCHAR(255);

-- Changeset current/20220228-rework-notification-filtering.xml::1646057700977-6::msavy (generated)
CREATE TABLE public.notification_rules ("NotificationPreferenceEntity_id" BIGINT NOT NULL, enabled BOOLEAN, expression VARCHAR(255), message VARCHAR(255), source VARCHAR(255));

-- Changeset current/20220228-rework-notification-filtering.xml::1646057700977-7::msavy (generated)
ALTER TABLE public.notification_rules ADD CONSTRAINT "FKbxdud6qk8e28eq1mjihqauybo" FOREIGN KEY ("NotificationPreferenceEntity_id") REFERENCES public.notification_preferences (id);

-- Changeset current/20220228-rework-notification-filtering.xml::1646232783603-7::msavy (generated)
ALTER TABLE notification_preferences ADD CONSTRAINT "FKt9qjvmcl36i14utm5uptyqg84" FOREIGN KEY (user_id) REFERENCES users (username);

-- Changeset current/20220228-rework-notification-filtering.xml::1646057700977-8::msavy (generated)
ALTER TABLE public.notification_category_preferences DROP CONSTRAINT "FKaq4x0n83d83xevui0ctqwdgbi";

-- Changeset current/20220228-rework-notification-filtering.xml::1646057700977-10::msavy (generated)
DROP TABLE public.notification_category_preferences;

-- Changeset current/20220228-rework-notification-filtering.xml::1646057700977-11::msavy (generated)
DROP TABLE public.notification_types;