[关闭]
@Tyhj 2017-10-25T09:56:36.000000Z 字数 1017 阅读 1020

WallPaper数据库设计

Android


App:versionCode apkUrl imageUrls info version

CallBack: status note imeia

Home:image type

Left:isRead left IMEI

UserInfo:appVersion name model androidVersion OS PhoneIMEI

WallPaper:WallPaperId WallPaperName wallPreview
WallPaperImage WallPaperData

  1. mysql> create table App(
  2. -> versionCode text,
  3. -> apkUrl text,
  4. -> imageUrl text,
  5. -> info text,
  6. -> version integer)
  7. -> ;
  8. mysql> create table home(
  9. -> imageUrl text,
  10. -> type integer)
  11. -> ;
  12. mysql> create table wallpaper(
  13. -> id integer,
  14. -> name text,
  15. -> preview text,
  16. -> image text,
  17. -> mv text,
  18. -> download integer);
  19. mysql> create table callBack(
  20. -> time text,
  21. -> status integer,
  22. -> note text,
  23. -> imei text);
  24. mysql> create table leftNote(
  25. -> time text,
  26. -> status integer,
  27. -> note text,
  28. -> imei text);
  29. mysql> create table userInfo(
  30. -> appVersion text,
  31. -> name text,
  32. -> model text,
  33. -> androidVersion text,
  34. -> os text,
  35. -> imei text,
  36. -> time text);
  1. {"code":200,"wallpapers":
  2. [{"preview":"http://ac-9tedv93w.clouddn.com/ff19866435605f22e5cb.png",
  3. "image":"http://ac-9tedv93w.clouddn.com/0e39b4313516e86e501e.jpg",
  4. "name":"变色龙",
  5. "mv":"http://ac-9tedv93w.clouddn.com/b76f488325d7620ec147.mp4",
  6. "id":1}
  7. ]}
添加新批注
在作者公开此批注前,只有你和作者可见。
回复批注