-- MySQL dump 10.13 Distrib 5.6.49, for Linux (x86_64)
--
-- Host: localhost Databa
se: app
-- ------------------------------------------------------
-- Server version 5.6.49-log
;
;
;
;
;
;
;
;
;
;
--
-- Table structure for table `account_list`
--
DROP TABLE IF EXISTS `account_list`;
;
;
CREATE TABLE `account_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varcha
r(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_pay` float(10,2) NOT NULL,
`user_url` varcha
r(100) NOT NULL,
`pay_time` int(11) NOT NULL,
`pay_status` tinyint(4) DEFAULT '0',
`pay_memo` varcha
r(100) NOT NULL,
`user_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
;
--
-- Dumping data for table `account_list`
--
LOCK TABLES `account_list` WRITE;
;
;
UNLOCK TABLES;
--
-- Table structure for table `admin_money_list`
--
DROP TABLE IF EXISTS `admin_money_list`;
;
;
CREATE TABLE `admin_money_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`user_money` float(10,2) NOT NULL,
`user_money2` float(10,2) NOT NULL,
`admin_name` varcha
r(30) NOT NULL,
`admin_time` datetime NOT NULL,
`user_name` varcha
r(33) NOT NULL,
`admin_memo` varcha
r(100) NOT NULL,
`admin_number` varcha
r(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
;

--
-- Dumping data for table `admin_money_list`
--
LOCK TABLES `admin_money_list` WRITE;
;
;
UNLOCK TABLES;
--
-- Table structure for table `apk_list`
--
DROP TABLE IF EXISTS `apk_list`;
;
;
CREATE TABLE `apk_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_name` varcha
r(11) COLLATE utf8_bin NOT NULL,
`app_ico` varcha
r(100) COLLATE utf8_bin DEFAULT NULL,
`app_url` varcha
r(200) COLLATE utf8_bin NOT NULL,
`app_date` datetime NOT NULL,
`app_status` smallint(6) NOT NULL DEFAULT '0',
`app_visits` int(11) DEFAULT '0',
`app_perview_visits` int(11) NOT NULL DEFAULT '0',
`app_scan_visits` int(11) NOT NULL DEFAULT '0',
`app_install` int(11) NOT NULL DEFAULT '0',
`app_memo` varcha
r(100) COLLATE utf8_bin DEFAULT NULL,
`app_ip` varcha
r(25) COLLATE utf8_bin DEFAULT NULL,
`app_userid` int(11) DEFAULT NULL,
`app_username` varcha
r(33) COLLATE utf8_bin NOT NULL,
`app_delstatus` tinyint(4) NOT NULL DEFAULT '0',
`app_enddate` datetime DEFAULT NULL,
`app_api` tinyint(4) NOT NULL DEFAULT '0',
`is_small` int(11) NOT NULL DEFAULT '0',
`package` varcha
r(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
;
--
-- Dumping data for table `apk_list`
--
LOCK TABLES `apk_list` WRITE;
;
;
UNLOCK TABLES;
--
-- Table structure for table `apk_server`
--
DROP TABLE IF EXISTS `apk_server`;
;
;
CREATE TABLE `apk_server` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`server_name` varcha
r(30) NOT NULL,
`server_price` float(6,2) NOT NULL,
`server_desc` varcha
r(100) NOT NULL,
`server_pic` varcha
r(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
;
--
-- Dumping data for table `apk_server`
--
LOCK TABLES `apk_server` WRITE;
;
INSERT INTO `apk_server` VALUES (1,'正式版',48.00,'测试版将于1天后自动失效。','https://www-26ge.oss-cn-hangzhou.aliyuncs.com/server/s1.png'),(8,'开通统计',48.00,'根据设备号统计,一个设备号只记录一次数据。可精准统计,[预览量]、[下载量]、[安装量]。','https://www-26ge.oss-cn-hangzhou.aliyuncs.com/server/s8.png'),(9,'制定启动页',30.00,'app启动页面,可设定启动后停留时间。 (如需我们设计启动页请加客服说明)','https://www-26ge.oss-cn-hangzhou.aliyuncs.com/server/s9.png'),(10,'制定下载页',100.00,'看具体需求。能细化到根据地区自动显示不同的广告语。','https://www-26ge.oss-cn-hangzhou.aliyuncs.com/server/s10.png');
;
UNLOCK TABLES;
--
-- Table structure for table `apk_server_list`
--
DROP TABLE IF EXISTS `apk_server_list`;
;
;
CREATE TABLE `apk_server_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_id` int(11) NOT NULL,
`app_userid` int(11) NOT NULL,
`app_server` varcha
r(30) NOT NULL,
`app_server_id` int(11) NOT NULL,
`app_server_int` tinyint(4) NOT NULL,
`app_server_text` varcha
r(500) NOT NULL,
`app_server_price` float(10,2) NOT NULL,
`app_server_time` datetime NOT NULL,
`app_server_page` tinyint(4) DEFAULT '0',
`app_server_status` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
;
--
-- Dumping data for table `apk_server_list`
--
LOCK TABLES `apk_server_list` WRITE;
;
;
UNLOCK TABLES;
--
-- Table structure for table `app_list`
--
DROP TABLE IF EXISTS `app_list`;
;
;
CREATE TABLE `app_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_name` varcha
r(11) COLLATE utf8_bin NOT NULL,
`app_ico` varcha
r(100) COLLATE utf8_bin DEFAULT NULL,
`app_url` varcha
r(200) COLLATE utf8_bin NOT NULL,
`app_date` datetime NOT NULL,
`app_status` smallint(6) NOT NULL DEFAULT '0',
`app_visits` int(11) DEFAULT '0',
`app_perview_visits` int(11) NOT NULL DEFAULT '0',
`app_scan_visits` int(11) NOT NULL DEFAULT '0',
`app_install` int(11) NOT NULL DEFAULT '0',
`app_memo` varcha
r(100) COLLATE utf8_bin DEFAULT NULL,
`app_ip` varcha
r(25) COLLATE utf8_bin DEFAULT NULL,
`app_userid` int(11) DEFAULT NULL,
`app_username` varcha
r(33) COLLATE utf8_bin NOT NULL,
`app_delstatus` tinyint(4) NOT NULL DEFAULT '0',
`app_type` tinyint(4) NOT NULL DEFAULT '0',
`app_api` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
;
--
-- Dumping data for table `app_list`
--
LOCK TABLES `app_list` WRITE;
;
;
UNLOCK TABLES;
--
-- Table structure for table `app_server`
--
DROP TABLE IF EXISTS `app_server`;