SQL

CREATE TABLE lives  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  live_id TEXT UNIQUE NOT NULL,
  title TEXT,
  content TEXT,
  content_prefix TEXT,
  published_date TEXT,
  link_name TEXT,
  link TEXT,
  grade INTEGER,
  created_at TEXT,
  created_at_unix INTEGER,
  created_at_zh TEXT,
  updated_at TEXT,
  source TEXT,
  category INTEGER,
  reading INTEGER DEFAULT 0,
  flag TEXT,
  attribute TEXT,
  up_counts INTEGER,
  down_counts INTEGER,
  comment_count INTEGER,
  highlight_color TEXT,
  images TEXT,
  extra_type INTEGER,
  extra TEXT,
  is_show_comment INTEGER,
  is_forbid_comment INTEGER,
  show_source_name TEXT,
  vote_id INTEGER,
  vote TEXT,
  zan_status TEXT,
  readings TEXT,
  word_blocks TEXT,
  raw_data TEXT,
  saved_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  UNIQUE(live_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
live_id TEXT Rename | Drop
title TEXT ✓ Rename | Drop
content TEXT ✓ Rename | Drop
content_prefix TEXT ✓ Rename | Drop
published_date TEXT ✓ Rename | Drop
link_name TEXT ✓ Rename | Drop
link TEXT ✓ Rename | Drop
grade INTEGER ✓ Rename | Drop
created_at TEXT ✓ Rename | Drop
created_at_unix INTEGER ✓ Rename | Drop
created_at_zh TEXT ✓ Rename | Drop
updated_at TEXT ✓ Rename | Drop
source TEXT ✓ Rename | Drop
category INTEGER ✓ Rename | Drop
reading INTEGER ✓ Rename | Drop
flag TEXT ✓ Rename | Drop
attribute TEXT ✓ Rename | Drop
up_counts INTEGER ✓ Rename | Drop
down_counts INTEGER ✓ Rename | Drop
comment_count INTEGER ✓ Rename | Drop
highlight_color TEXT ✓ Rename | Drop
images TEXT ✓ Rename | Drop
extra_type INTEGER ✓ Rename | Drop
extra TEXT ✓ Rename | Drop
is_show_comment INTEGER ✓ Rename | Drop
is_forbid_comment INTEGER ✓ Rename | Drop
show_source_name TEXT ✓ Rename | Drop
vote_id INTEGER ✓ Rename | Drop
vote TEXT ✓ Rename | Drop
zan_status TEXT ✓ Rename | Drop
readings TEXT ✓ Rename | Drop
word_blocks TEXT ✓ Rename | Drop
raw_data TEXT ✓ Rename | Drop
saved_at TIMESTAMP ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_created_at created_at SQL 
CREATE INDEX idx_created_at
ON lives(created_at)
Drop
idx_live_id live_id SQL 
CREATE INDEX idx_live_id
ON lives(live_id)
Drop
idx_saved_at saved_at SQL 
CREATE INDEX idx_saved_at
ON lives(saved_at)
Drop
sqlite_autoindex_lives_1 live_id ✓ SQL
-- no sql found --
 Drop