up.sql 461 B

12345678910111213141516171819
  1. -- Your SQL goes here
  2. CREATE TABLE wbw_templates
  3. (
  4. id SERIAL PRIMARY KEY,
  5. book INTEGER NOT NULL,
  6. paragraph INTEGER NOT NULL,
  7. wid INTEGER NOT NULL,
  8. word VARCHAR (1024),
  9. real VARCHAR (1024),
  10. type VARCHAR (64),
  11. gramma VARCHAR (64),
  12. part VARCHAR (1024),
  13. style VARCHAR (64)
  14. );
  15. -- 索引:search
  16. CREATE INDEX wbw_templates_book ON wbw_templates ("book", "paragraph", "wid");
  17. CREATE INDEX wbw_templates_book1 ON wbw_templates ("book", "paragraph");