up.sql 548 B

1234567891011121314151617181920
  1. -- 表:pali_sent
  2. CREATE TABLE pali_sent (
  3. id SERIAL PRIMARY KEY,
  4. book INTEGER,
  5. paragraph INTEGER,
  6. word_begin INTEGER,
  7. word_end INTEGER,
  8. length INTEGER,
  9. count INTEGER,
  10. text TEXT,
  11. html TEXT,
  12. sim_sents TEXT,
  13. sim_sents_count INTEGER NOT NULL DEFAULT (0),
  14. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  15. updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  16. );
  17. -- 索引:sentId
  18. CREATE INDEX palisentId ON pali_sent (book, paragraph, word_begin, word_end);