Query

app.db — smile_preview_settings

SQL

CREATE TABLE smile_preview_settings  (
  chatbot_id INTEGER PRIMARY KEY,
  is_enabled INTEGER NOT NULL DEFAULT 0,
  default_credits_per_generation INTEGER NOT NULL DEFAULT 1,
  disclaimer_text TEXT NOT NULL,
  allowed_treatments_json TEXT NOT NULL,
  public_token TEXT NOT NULL UNIQUE,
  require_api_key INTEGER NOT NULL DEFAULT 0,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL,
  client_logo_media_id INTEGER,
  privacy_policy_url TEXT,
  embed_webhook_url TEXT,
  credit_balance INTEGER NOT NULL DEFAULT 0,
  plan_id INTEGER,
  generation_gemini_model TEXT NOT NULL DEFAULT 'gemini-2.5-flash-image',
  regeneration_gemini_model TEXT NOT NULL DEFAULT 'gemini-3.1-flash-image',
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
chatbot_id INTEGER ✓ ✓ Rename | Drop
is_enabled INTEGER Rename | Drop
default_credits_per_generation INTEGER Rename | Drop
disclaimer_text TEXT Rename | Drop
allowed_treatments_json TEXT Rename | Drop
public_token TEXT Rename | Drop
require_api_key INTEGER Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
client_logo_media_id INTEGER ✓ Rename | Drop
privacy_policy_url TEXT ✓ Rename | Drop
embed_webhook_url TEXT ✓ Rename | Drop
credit_balance INTEGER Rename | Drop
plan_id INTEGER ✓ Rename | Drop
generation_gemini_model TEXT Rename | Drop
regeneration_gemini_model TEXT Rename | Drop

Foreign Keys

Column Destination
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_smile_preview_settings_plan plan_id SQL 
CREATE INDEX idx_smile_preview_settings_plan
ON smile_preview_settings(plan_id)
Drop
sqlite_autoindex_smile_preview_settings_1 public_token ✓ SQL
-- no sql found --
 Drop