article_list.sql 438 B

12345678910111213141516171819202122
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周六 12月 18 08:55:58 2021
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:article_list
  9. CREATE TABLE article_list
  10. (
  11. id INTEGER PRIMARY KEY AUTOINCREMENT,
  12. collect_id VARCHAR (36),
  13. collect_title TEXT,
  14. article_id VARCHAR (36),
  15. level INTEGER,
  16. title VARCHAR (64),
  17. children INTEGER DEFAULT (0)
  18. );
  19. COMMIT TRANSACTION;
  20. PRAGMA foreign_keys = on;