CREATE TABLE raid_builder.game_calendar_event(
	game_calendar_event_id uuid PRIMARY KEY,
	game_id uuid REFERENCES raid_builder.game(game_id) NOT NULL,
	event_name text NOT NULL,
	event_description text,
	event_start_date timestamptz NOT NULL,
	event_end_date timestamptz NOT NULL,

	--Auditing
	modified_by uuid,
	modified_date timestamptz,
	created_by uuid NOT NULL,
	created_date timestamptz NOT NULL
);

CREATE INDEX idx_game_calendar_event_game_id ON raid_builder.game_calendar_event(game_id);

GRANT ALL ON TABLE raid_builder.game_calendar_event TO raid_builder;