Query

app.db — evolution_instances

SQL

CREATE TABLE evolution_instances (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  instance_name TEXT NOT NULL UNIQUE,
  api_url TEXT NOT NULL,
  api_key TEXT NOT NULL,
  chatbot_id INTEGER,
  status TEXT NOT NULL DEFAULT 'pending',
  qr_code_url TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
instance_name TEXT Rename | Drop
api_url TEXT Rename | Drop
api_key TEXT Rename | Drop
chatbot_id INTEGER ✓ Rename | Drop
status TEXT Rename | Drop
qr_code_url TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_evolution_instances_instance_name instance_name SQL 
CREATE INDEX idx_evolution_instances_instance_name
ON evolution_instances(instance_name)
Drop
idx_evolution_instances_status status SQL 
CREATE INDEX idx_evolution_instances_status
ON evolution_instances(status)
Drop
sqlite_autoindex_evolution_instances_1 instance_name ✓ SQL
-- no sql found --
 Drop