SQL

CREATE TABLE "private_room"  (
  "channel_id" text primary key,
  "game_category_id" text not null references "game" ("category_id") on delete cascade,
  "parent_id" text not null,
  "is_whisper" integer not null
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
channel_id TEXT ✓ ✓ Rename | Drop
game_category_id TEXT Rename | Drop
parent_id TEXT Rename | Drop
is_whisper INTEGER Rename | Drop

Foreign Keys

Column Destination
game_category_id game.category_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_private_room_1 channel_id ✓ SQL
-- no sql found --
 Drop