topfreegames/khan

-- khan
-- https://github.com/topfreegames/khan
--
-- Licensed under the MIT license:
-- http://www.opensource.org/licenses/mit-license
-- Copyright © 2016 Top Free Games <backend@tfgco.com>

-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
CREATE TABLE memberships (
    id serial PRIMARY KEY,
    game_id varchar(36) NOT NULL REFERENCES games (public_id),
    clan_id integer NOT NULL REFERENCES clans (id),
    player_id integer NOT NULL REFERENCES players (id),
    membership_level varchar(36) NOT NULL,
    approved boolean NOT NULL DEFAULT false,
    denied boolean NOT NULL DEFAULT false,
    banned boolean NOT NULL DEFAULT false,
    requestor_id integer NOT NULL REFERENCES players (id),
    created_at bigint NOT NULL,
    updated_at bigint NULL,
    deleted_by integer NULL,
    deleted_at bigint NULL,

    CONSTRAINT playerid_clanid UNIQUE(player_id, clan_id)
);

-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back
DROP TABLE memberships;