Add Column

Cancel

Current Schema

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)
)