SQL

CREATE TABLE properties_config  (
  property_id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  n8n_classifier_webhook_url TEXT,
  n8n_orchestrator_webhook_url TEXT,
  telegram_chat_id TEXT,
  is_active INTEGER DEFAULT 1,
  settings_json TEXT DEFAULT '{}',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  ical_url_airbnb TEXT,
  ical_url_booking TEXT,
  cleaner_telegram_chat_id TEXT,
  cleaning_duration_hours INTEGER DEFAULT 2,
  cleaning_start_offset_hours INTEGER DEFAULT 1
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
property_id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
n8n_classifier_webhook_url TEXT ✓ Rename | Drop
n8n_orchestrator_webhook_url TEXT ✓ Rename | Drop
telegram_chat_id TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
settings_json TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop
ical_url_airbnb TEXT ✓ Rename | Drop
ical_url_booking TEXT ✓ Rename | Drop
cleaner_telegram_chat_id TEXT ✓ Rename | Drop
cleaning_duration_hours INTEGER ✓ Rename | Drop
cleaning_start_offset_hours INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_properties_config_active is_active SQL 
CREATE INDEX idx_properties_config_active
ON properties_config(is_active)
Drop
sqlite_autoindex_properties_config_1 property_id ✓ SQL
-- no sql found --
 Drop