message.sql 476 B

12345678910111213141516171819202122232425
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周五 7月 31 13:50:23 2020
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:message
  9. CREATE TABLE message (
  10. id INTEGER PRIMARY KEY AUTOINCREMENT,
  11. sender TEXT NOT NULL,
  12. type INTEGER NOT NULL,
  13. book INTEGER,
  14. paragraph INTEGER,
  15. data TEXT,
  16. doc_id TEXT (40),
  17. time INTEGER
  18. );
  19. COMMIT TRANSACTION;
  20. PRAGMA foreign_keys = on;