up.sql 291 B

12345678910111213
  1. -- Your SQL goes here
  2. CREATE TABLE book_words
  3. (
  4. id SERIAL PRIMARY KEY,
  5. book INTEGER NOT NULL,
  6. wordindex INTEGER NOT NULL,
  7. count INTEGER NOT NULL,
  8. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  9. );
  10. -- 索引:
  11. CREATE INDEX bookword_wordindex ON book_words (wordindex);