up.sql 662 B

12345678910111213141516171819202122232425262728293031323334353637
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周三 12月 8 07:45:42 2021
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:dict
  9. CREATE TABLE dict
  10. (
  11. id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  12. guid TEXT,
  13. pali TEXT NOT NULL,
  14. type TEXT,
  15. gramma TEXT,
  16. parent TEXT,
  17. parent_id TEXT,
  18. mean TEXT,
  19. note TEXT,
  20. factors TEXT,
  21. factormean TEXT,
  22. part_id TEXT,
  23. status INTEGER,
  24. dict_name TEXT,
  25. language TEXT,
  26. confidence INTEGER DEFAULT (100),
  27. creator INTEGER,
  28. ref_counter INTEGER DEFAULT (1),
  29. time INTEGER,
  30. );
  31. -- 索引:
  32. CREATE INDEX "" ON dict (pali);
  33. COMMIT TRANSACTION;
  34. PRAGMA foreign_keys = on;