up.sql 389 B

123456789101112131415
  1. -- 表:progress_chapter
  2. CREATE TABLE progress_chapters
  3. (
  4. id SERIAL PRIMARY KEY,
  5. book INTEGER,
  6. para INTEGER,
  7. lang VARCHAR (16),
  8. all_trans REAL,
  9. public REAL,
  10. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  11. );
  12. CREATE INDEX progress_chapters_book_para ON progress_chapters (book,para);
  13. CREATE INDEX progress_chapters_book_para_lang ON progress_chapters (book,para,lang);