-- MySQL dump 10.13 Distrib 5.6.49, for Linux (x86_64) -- -- Host: localhost Database: 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` varchar(30) NOT NULL, `user_id` int(11) NOT NULL, `user_pay` float(10,2) NOT NULL, `user_url` varchar(100) NOT NULL, `pay_time` int(11) NOT NULL, `pay_status` tinyint(4) DEFAULT '0', `pay_memo` varchar(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` varchar(30) NOT NULL, `admin_time` datetime NOT NULL, `user_name` varchar(33) NOT NULL, `admin_memo` varchar(100) NOT NULL, `admin_number` varchar(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` varchar(11) COLLATE utf8_bin NOT NULL, `app_ico` varchar(100) COLLATE utf8_bin DEFAULT NULL, `app_url` varchar(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` varchar(100) COLLATE utf8_bin DEFAULT NULL, `app_ip` varchar(25) COLLATE utf8_bin DEFAULT NULL, `app_userid` int(11) DEFAULT NULL, `app_username` varchar(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` varchar(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` varchar(30) NOT NULL, `server_price` float(6,2) NOT NULL, `server_desc` varchar(100) NOT NULL, `server_pic` varchar(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` varchar(30) NOT NULL, `app_server_id` int(11) NOT NULL, `app_server_int` tinyint(4) NOT NULL, `app_server_text` varchar(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` varchar(11) COLLATE utf8_bin NOT NULL, `app_ico` varchar(100) COLLATE utf8_bin DEFAULT NULL, `app_url` varchar(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` varchar(100) COLLATE utf8_bin DEFAULT NULL, `app_ip` varchar(25) COLLATE utf8_bin DEFAULT NULL, `app_userid` int(11) DEFAULT NULL, `app_username` varchar(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`;