up.sql 653 B

12345678910111213141516171819202122232425262728293031323334
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周日 12月 5 21:44:27 2021
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:sentence
  9. CREATE TABLE sentence
  10. (
  11. id CHAR (36) PRIMARY KEY,
  12. parent CHAR (36),
  13. block_id CHAR (36),
  14. channal CHAR (36),
  15. book INTEGER NOT NULL,
  16. paragraph INTEGER NOT NULL,
  17. "begin" INTEGER NOT NULL,
  18. "end" INTEGER NOT NULL,
  19. tag TEXT,
  20. author TEXT,
  21. editor CHAR (36),
  22. text TEXT,
  23. language CHAR (8),
  24. ver INTEGER,
  25. status INTEGER,
  26. strlen INTEGER,
  27. modify_time INTEGER NOT NULL,
  28. receive_time INTEGER,
  29. create_time INTEGER
  30. );
  31. COMMIT TRANSACTION;
  32. PRAGMA foreign_keys = on;