Query

app.db — whatsapp_meta_oauth_states

SQL

CREATE TABLE whatsapp_meta_oauth_states  (
  state TEXT PRIMARY KEY,
  user_id INTEGER NOT NULL,
  chatbot_id INTEGER NOT NULL,
  connection_id INTEGER,
  redirect_path TEXT,
  redirect_uri TEXT,
  created_at TEXT NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
state TEXT ✓ ✓ Rename | Drop
user_id INTEGER Rename | Drop
chatbot_id INTEGER Rename | Drop
connection_id INTEGER ✓ Rename | Drop
redirect_path TEXT ✓ Rename | Drop
redirect_uri TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_whatsapp_meta_oauth_states_1 state ✓ SQL
-- no sql found --
 Drop