在线封装打包制作PHP源码,实现H5手机网站转APP,免签封装绿标支持安卓苹果平台
2024-12-26 14:18
-- 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`;