up.sql 355 B

1234567891011121314
  1. -- 表:progress
  2. CREATE TABLE progresss
  3. (
  4. id SERIAL PRIMARY KEY,
  5. book INTEGER,
  6. para INTEGER,
  7. lang VARCHAR (16),
  8. all_strlen INTEGER,
  9. public_strlen INTEGER,
  10. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  11. );
  12. CREATE INDEX progresss_book_para ON progresss (book,para);
  13. CREATE INDEX progresss_book_para_lang ON progresss (book,para,lang);