SQL

CREATE TABLE programs  (
  id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  description TEXT,
  image TEXT,
  video_url TEXT,
  trailer_url TEXT,
  category TEXT,
  rating REAL DEFAULT 8.0,
  year INTEGER DEFAULT 2023,
  duration TEXT,
  director TEXT,
  actors TEXT DEFAULT '[]',
  language TEXT DEFAULT '普通话',
  region TEXT DEFAULT '中国大陆',
  awards TEXT DEFAULT '[]',
  tags TEXT DEFAULT '[]',
  is_multi_episode INTEGER DEFAULT 0,
  program_type TEXT DEFAULT 'movie',
  total_episodes INTEGER DEFAULT 1,
  current_episodes INTEGER DEFAULT 1,
  update_pattern TEXT DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
description TEXT ✓ Rename | Drop
image TEXT ✓ Rename | Drop
video_url TEXT ✓ Rename | Drop
trailer_url TEXT ✓ Rename | Drop
category TEXT ✓ Rename | Drop
rating REAL ✓ Rename | Drop
year INTEGER ✓ Rename | Drop
duration TEXT ✓ Rename | Drop
director TEXT ✓ Rename | Drop
actors TEXT ✓ Rename | Drop
language TEXT ✓ Rename | Drop
region TEXT ✓ Rename | Drop
awards TEXT ✓ Rename | Drop
tags TEXT ✓ Rename | Drop
is_multi_episode INTEGER ✓ Rename | Drop
program_type TEXT ✓ Rename | Drop
total_episodes INTEGER ✓ Rename | Drop
current_episodes INTEGER ✓ Rename | Drop
update_pattern TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?