SQL

CREATE TABLE "game"  (
  "category_id" text primary key,
  "title" text not null,
  "town_square_channel_id" text,
  "nominations_channel_id" text,
  "guild_id" text not null,
  "storyteller_id" text not null,
  "is_active" integer not null,
  "is_teensy" integer not null,
  "private_room_limit" integer not null,
  "group_room_limit" integer not null,
  "neighbor_whisper_limit" integer not null,
  "day_length" real not null,
  "night_length" real not null,
  "auto_start" integer not null,
  "allow_conditional_voting" integer not null,
  "current_cycle_start_time" text,
  "current_day" integer not null,
  "current_night" integer not null,
  "voting_window" real not null,
  "groups_should_decrement_room_count" integer not null,
  "private_voting" integer not null,
  "allow_room_history_command" integer not null
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
category_id TEXT ✓ ✓ Rename | Drop
title TEXT Rename | Drop
town_square_channel_id TEXT ✓ Rename | Drop
nominations_channel_id TEXT ✓ Rename | Drop
guild_id TEXT Rename | Drop
storyteller_id TEXT Rename | Drop
is_active INTEGER Rename | Drop
is_teensy INTEGER Rename | Drop
private_room_limit INTEGER Rename | Drop
group_room_limit INTEGER Rename | Drop
neighbor_whisper_limit INTEGER Rename | Drop
day_length REAL Rename | Drop
night_length REAL Rename | Drop
auto_start INTEGER Rename | Drop
allow_conditional_voting INTEGER Rename | Drop
current_cycle_start_time TEXT ✓ Rename | Drop
current_day INTEGER Rename | Drop
current_night INTEGER Rename | Drop
voting_window REAL Rename | Drop
groups_should_decrement_room_count INTEGER Rename | Drop
private_voting INTEGER Rename | Drop
allow_room_history_command INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_game_1 category_id ✓ SQL
-- no sql found --
 Drop
storyteller_active_game_index storyteller_id ✓ SQL 
CREATE UNIQUE INDEX "storyteller_active_game_index"
ON "game" ("storyteller_id") where "is_active" = true
Drop