SQL

CREATE TABLE course_topics  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  title       TEXT NOT NULL,
  category    TEXT NOT NULL,
  description TEXT DEFAULT '',
  age_range   TEXT DEFAULT '6-12',
  difficulty  TEXT DEFAULT 'beginner' CHECK(difficulty IN ('beginner','intermediate','advanced')),
  tags        TEXT DEFAULT '[]',
  content     TEXT DEFAULT '',
  status      TEXT DEFAULT 'active' CHECK(status IN ('active','draft','archived')),
  created_at  DATETIME DEFAULT (datetime('now')),
  updated_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
category TEXT Rename | Drop
description TEXT ✓ Rename | Drop
age_range TEXT ✓ Rename | Drop
difficulty TEXT ✓ Rename | Drop
tags TEXT ✓ Rename | Drop
content TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?