article.sql 493 B

12345678910111213141516171819202122232425262728
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周六 12月 18 08:55:22 2021
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:article
  9. CREATE TABLE article
  10. (
  11. id CHAR (36) PRIMARY KEY,
  12. title TEXT (50),
  13. subtitle TEXT,
  14. summary TEXT,
  15. content TEXT,
  16. tag TEXT,
  17. owner CHAR (36),
  18. setting TEXT,
  19. status INTEGER,
  20. create_time INTEGER,
  21. modify_time INTEGER,
  22. receive_time INTEGER,
  23. lang VARCHAR (16)
  24. );
  25. COMMIT TRANSACTION;
  26. PRAGMA foreign_keys = on;