SQL

CREATE TABLE users  (
  guild_id INTEGER NOT NULL,
  user_id INTEGER NOT NULL,
  joined_at TEXT NOT NULL,
  bank REAL NOT NULL,
  rank TEXT NOT NULL,
  PRIMARY KEY (guild_id, user_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
guild_id INTEGER ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
joined_at TEXT Rename | Drop
bank REAL Rename | Drop
rank TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_users_1
  • guild_id
  • user_id
 ✓ SQL
-- no sql found --
 Drop