up.sql 413 B

1234567891011121314151617181920212223
  1. -- 表:pali_text
  2. CREATE TABLE pali_text
  3. (
  4. id SERIAL PRIMARY KEY,
  5. book INTEGER,
  6. paragraph INTEGER,
  7. level INTEGER,
  8. class varchar (255),
  9. toc TEXT,
  10. text TEXT,
  11. html TEXT,
  12. lenght INTEGER,
  13. album_index INTEGER,
  14. chapter_len INTEGER,
  15. next_chapter INTEGER,
  16. prev_chapter INTEGER,
  17. parent INTEGER,
  18. chapter_strlen INTEGER
  19. );
  20. -- 索引
  21. CREATE INDEX pali_text_vri ON pali_text (book, paragraph );