应用商店初始化配置文档

1.# LNMP一键安装包 content7一键安装
wget http://soft.vpser.net/lnmp/lnmp1.8beta.tar.gz -cO lnmp1.8.tar.gz && tar zxf lnmp1.8.tar.gz && cd lnmp1.8 && ./install.sh {lnmp|lnmpa|lamp}

2.node安装

3.创建mysql的三张表

CREATE TABLE IF NOT EXISTS `usertable`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `name` VARCHAR(100) ,
   `usercode` VARCHAR(100) ,
   `mail` VARCHAR(100) ,
   `password` VARCHAR(100) ,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

CREATE TABLE IF NOT EXISTS `appinfotable`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `username` VARCHAR(100) ,
   `usercode` VARCHAR(100) ,
   `password` VARCHAR(100) ,
   `bundleid` VARCHAR(100) ,
   `version` VARCHAR(100) ,
   `CFBundleDisplayName` TEXT ,
   `createTime` VARCHAR(100) ,
   `appid` VARCHAR(100)  ,
   `filename` TEXT ,
   `appsize` VARCHAR(100)  ,
   `mail` VARCHAR(40)  ,
   `submission_date` DATE,
   `appname` TEXT,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

CREATE TABLE IF NOT EXISTS `projectTable`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `projectname` TEXT,
   `expireDate` VARCHAR(100) ,
   `mail` VARCHAR(100) ,
   `time` TEXT ,
   `appid` TEXT ,
   `ipaurl` TEXT ,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;

image.png