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

mysql> create table App(
    -> versionCode text,
    -> apkUrl text,
    -> imageUrl text,
    -> info text,
    -> version integer)
    -> ;
mysql> create table home(
    -> imageUrl text,
    -> type integer)
    -> ;
mysql> create table wallpaper(
    -> id integer,
    -> name text,
    -> preview text,
    -> image text,
    -> mv text,
    -> download integer);
mysql> create table callBack(
    -> time text,
    -> status integer,
    -> note text,
    -> imei text);
mysql> create table leftNote(
    -> time text,
    -> status integer,
    -> note text,
    -> imei text);
mysql> create table userInfo(
    -> appVersion text,
    -> name text,
    -> model text,
    -> androidVersion text,
    -> os text,
    -> imei text,
    -> time text);

 {"code":200,"wallpapers":
    [{"preview":"http://ac-9tedv93w.clouddn.com/ff19866435605f22e5cb.png",
    "image":"http://ac-9tedv93w.clouddn.com/0e39b4313516e86e501e.jpg",
    "name":"变色龙",
    "mv":"http://ac-9tedv93w.clouddn.com/b76f488325d7620ec147.mp4",
    "id":1}
 ]}