Query

billing.db — admin_notifications

SQL

CREATE TABLE admin_notifications  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  type TEXT,
  title TEXT,
  message TEXT,
  agent_id INTEGER,
  status TEXT DEFAULT 'unread',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
type TEXT ✓ Rename | Drop
title TEXT ✓ Rename | Drop
message TEXT ✓ Rename | Drop
agent_id INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?