grants-writer/src/main/resources/db/changelog/migration/_0.1.0_migrate.sql

-- liquibase formatted sql
-- changeset zuhaimi:1677359372272-1
CREATE TABLE `groups` (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    created_time TIMESTAMP(6) WITHOUT TIME ZONE,
    description VARCHAR(500),
    modified_time TIMESTAMP(6) WITHOUT TIME ZONE,
    name VARCHAR(100),
    CONSTRAINT "groupsPK" PRIMARY KEY (id)
);

-- changeset zuhaimi:1677359372272-2
ALTER TABLE
    `groups`
ADD
    CONSTRAINT UC_GROUPSDESCRIPTION_COL UNIQUE (description);

-- changeset zuhaimi:1677359372272-3
ALTER TABLE
    `groups`
ADD
    CONSTRAINT UC_GROUPSNAME_COL UNIQUE (name);