wordindex.sql 571 B

123456789101112131415161718192021222324252627282930313233343536
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周一 8月 3 08:34:55 2020
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:wordindex
  9. DROP TABLE IF EXISTS wordindex;
  10. CREATE TABLE wordindex (
  11. id INT,
  12. word TEXT PRIMARY KEY ASC
  13. UNIQUE,
  14. word_en TEXT,
  15. count INT,
  16. normal INT,
  17. bold INT,
  18. is_base INT,
  19. len INT,
  20. final INT
  21. );
  22. -- 索引:
  23. DROP INDEX IF EXISTS "";
  24. CREATE INDEX "" ON wordindex (
  25. word_en ASC
  26. );
  27. COMMIT TRANSACTION;
  28. VACUUM;
  29. PRAGMA foreign_keys = on;