media.sql 503 B

123456789101112131415161718192021222324252627
  1. --
  2. -- 由SQLiteStudio v3.1.1 产生的文件 周五 7月 31 13:49:22 2020
  3. --
  4. -- 文本编码:UTF-8
  5. --
  6. PRAGMA foreign_keys = off;
  7. BEGIN TRANSACTION;
  8. -- 表:media
  9. CREATE TABLE media (
  10. id CHAR (36) PRIMARY KEY,
  11. type INTEGER,
  12. link TEXT,
  13. title TEXT,
  14. summary TEXT,
  15. anchor TEXT,
  16. creator CHAR (36),
  17. create_time INTEGER,
  18. modify_time INTEGER,
  19. receive_time INTEGER
  20. );
  21. COMMIT TRANSACTION;
  22. PRAGMA foreign_keys = on;