SQL

CREATE TABLE tasks  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  description TEXT,
  status TEXT NOT NULL DEFAULT 'pending' CHECK(status IN ('pending','in_progress','completed','cancelled')),
  priority TEXT NOT NULL DEFAULT 'medium' CHECK(priority IN ('low','medium','high','urgent')),
  due_date TEXT,
  client_id INTEGER REFERENCES clients(id) ON DELETE SET NULL,
  assigned_to INTEGER REFERENCES users(id) ON DELETE SET NULL,
  created_by INTEGER REFERENCES users(id),
  created_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
  patrocinio_id INTEGER REFERENCES patrocinios(id) ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
description TEXT ✓ Rename | Drop
status TEXT Rename | Drop
priority TEXT Rename | Drop
due_date TEXT ✓ Rename | Drop
client_id INTEGER ✓ Rename | Drop
assigned_to INTEGER ✓ Rename | Drop
created_by INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
patrocinio_id INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
patrocinio_id patrocinios.id
created_by users.id
assigned_to users.id
client_id clients.id

+ Add index

Indexes

Name Columns Unique SQL Drop?