17 lines
765 B
SQL
17 lines
765 B
SQL
CREATE TYPE raid_builder.tutorial_status AS ENUM ( 'COMPLETED', 'NOT_COMPLETED' );
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS raid_builder.account_tutorial_status (
|
|
account_tutorial_status_id uuid PRIMARY KEY,
|
|
account_id uuid REFERENCES raid_builder.account(account_id),
|
|
games_tutorial_status raid_builder.tutorial_status NOT NULL,
|
|
game_tutorial_status raid_builder.tutorial_status NOT NULL,
|
|
raid_groups_tutorial_status raid_builder.tutorial_status NOT NULL,
|
|
raid_group_tutorial_status raid_builder.tutorial_status NOT NULL,
|
|
instance_tutorial_status raid_builder.tutorial_status NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_account_tutorial_status_account_id ON raid_builder.account_tutorial_status (account_id);
|
|
|
|
GRANT ALL ON TABLE raid_builder.account_tutorial_status TO raid_builder;
|