mint/api-v8/public/db/postgresql/go/20210814142535-create-groups/up.sql

-- Your SQL goes here

CREATE TABLE groups (
    id           SERIAL PRIMARY KEY,
    uid          VARCHAR (36) ,

    name         VARCHAR (255) NOT NULL,

    description      TEXT,
    description_type TContentType NOT NULL DEFAULT('markdown'), 
    
    setting      JSON NOT NULL DEFAULT('{}'), 

    status       TStatus  NOT NULL DEFAULT('private'), 
    owner_id     INTEGER NOT NULL, 

	version     INTEGER NOT NULL DEFAULT (1),
    deleted_at  TIMESTAMP,

    created_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX groups_name ON groups (name);
CREATE INDEX groups_status ON groups (status);

CREATE UNIQUE INDEX groups_uid ON groups (uid);