目录
阿里云官方文档：https://help.aliyun.com/
阿里云开放实验室：https://edu.aliyun.com/lab/
（本人听过官方 ACA/ACP 认证辅导课，推荐参考视频课：https://edu.aliyun.com/course/1132/lesson/list）
我的阿里云控制台
阿里云整体架构
弹性计算服务ECS
ECS之初体验
1. 背景知识：
云服务器（Elastic Compute Service, 简称ECS），是一种简单高效，处理能力可以弹性伸缩的计算服务。ECS的相关术语说明如下：
－－实例（Instance）：是一个虚拟的计算环境，由CPU、内存、系统盘和运行的操作系统组成；ECS实例作为云服务器最为核心的概念，其他资源，比如磁盘、IP、镜像、快照等，只有与ECS结合后才具有使用意义。
－－地域（Region）：指ECS实例所在的物理位置。地域内的ECS实例内网是互通的，不同的地域之间ECS实例内网不互通。
－－可用区（Zone）：指在同一地域内，电力和网络互相独立的物理区域。
－－磁盘（Disk）：是为ECS实例提供数据块级别的数据存储。可以分为4类： 普通云盘、SSD云盘、高效云盘和本地SSD磁盘
－－快照（Snapshot）：是某一个时间点上某个磁盘的数据拷贝。
－－镜像（Image）：是ECS实例运行环境的模板，一般包括操作系统和预装的软件。
－－安全组（Security Group）：是一种虚拟防火墙，具备状态检测包过滤功能。每个实例至少属于一个安全组。同一个安全组内的实例之间网络互通，不同安全组的实例之间默认内网不通，但是可以授权两个安全组之间互访。
2. 操作
资源信息：
（1）远程登录ECS服务器
在本地计算机上访问远程ECS服务器，其操作系统为Linux。使用 ECS 服务器的 弹性IP，用户名 和 密码：
[root@iZuf68exorylfe8cw5q0osZ ~]# vim /alidata/www/default/index.html
访问弹性IP，即可看到我修改的内容：
（2）使用阿里云控制台管理ECS实例
访问控制台url：
下一步输入密码登陆成功，即可进入阿里云控制台主页：
选择产品与服务中的云服务器ECS：
点击对应实例ID的“管理”：
（3）查看ECS实例磁盘:
实例ID为 u-i2jjtsje 的实例包含两个磁盘：20G的数据盘和40G的系统盘：
（4）重置ECS实例登录密码：
点击“配置安全组规则”右侧的三竖点，即可看到重置实例密码：
(5) 重启ECS实例
验证密码修改成功:
接下来就可以进行其他的应用部署和操作。
3. 选购实例
实例页面中点击”创建实例“，即可选购实例：
（1）ECS付费模式分为包年包月，按量付费和抢占式实例。
包年包月：采用预付费的方式，最小选购时间为1个月。若购买中国内地地域的 ECS 用于网站 Web 访问，及时备案。若 ECS 用于 SLB，前往 SLB 选购页面购买带宽，ECS 仅需保留少量带宽以便管理。
- 优点：实例平均每小时价格低，支持固定带宽和按实际流量两种计费方式，支持固定带宽随时升级，最少升级1天，支持实例随时升级。
- 缺点：实例不可随时释放退款，实例升级需要升级到购买结束的周期。
- 适用场景：固定的7*24小时服务，如Web服务等。
按量付费：采用后付费的方式，按照每小时计费一次。按量付费 ECS 不支持备案服务。
- 优点：实例可以随时释放，支持固定带宽和按实际流量两种计费方式。
- 缺点：实例每小时价格较高，不支持固定带宽升级，不支持实例规格升级，建议新建实例解决。
- 适用场景：爆发业务的临时扩展、临时测试、科学计算等。
抢占式实例：相对于按量付费实例价格有一定的折扣，价格随供求波动，按实际使用时长进行收费，后付费模式。
您愿意支付每小时的实例最高价。当您的出价高于当前市场成交价时，您的实例就会运行。
阿里云会根据供需资源或市场成交价的变化释放您的抢占式实例。
抢占式实例不支持备案服务。
（2）地域及可用区
地域：选择不同的地域，价格不一样。一般情况下，选择最靠近的节点，因为距离更近可以减少延迟时间和提供更快的下载速度。目前支持的地域有华北1、华北2、华南1等等。
可用区：在同一地域中可以选择多个可用区。在同一地域下可用区与可用区之间内网互通，同一可用区内的ECS实例网络延时更小。如果应用需要更高的高可用性，可以将ECS实例创建在不同的可用区内。
（3）配置网络
可选择网络类型：专有网络或经典网络。
是ECS产品功能上的区分，与运营商公网接入网络质量无关。
经典网络：IP地址由阿里云统一分配，配置简便，使用方便，适合对操作易用性要求比较高、需要快速使用ECS的用户。
专有网络：逻辑隔离的私有网络，用户可以自定义网络拓扑和IP地址，支持通过专线连接。适合对网络管理熟悉了解的用户。
选择区分：
- 经典网络：通过 选择安全组，可以直接选择现有的安全组；也可以通过自行创建来选择
- 专有网络：可以选择 默认专有网络和交换机，也可以自己创建。默认类型的专有网络和交换机确定了在专有网络类型的云产品创建时在相应地域和可用区下唯一的默认网络位置，与非默认的专有网络和交换机之间的区别主要在于：默认类型的资源只能由阿里云创建。
- 弹性公网IP：是可以独立申请的公网IP地址，只能绑定在同一地域内专有网络类型的ECS实例上，支持动态绑定和解绑。目前，1个弹性公网IP只能绑定到1个ECS实例上，而1个ECS实例只能绑定1个公网IP。
可选择是否IPv6
（4）选择实例规格：
不同的需求可以选择不同的实例规格，包括vCPU，内存，带宽等。比如：访问流量较少的个人网站，搭配最低的标准即可实现。若是需要大量计算，数据处理等功能，需要选择较高配置的标准。
（5）配置镜像
镜像分成 公共镜像、自定义镜像、共享镜像 和 镜像市场。
公共镜像：是由阿里云官方提供公共基础镜像，仅包括初始系统环境。请根据您的实际情况自助配置应用环境或相关软件配置。
自定义镜像：基于用户系统快照生成，包括初始系统环境、 应用环境和相关软件配置 。选择自定义镜像创建云服务器，节省您的重复配置时间。
共享镜像：是其他账号的自定义镜像主动共享给您使用的镜像。阿里云不保证其他账号共享给您的镜像的完整性和安全性，使用共享镜像需要自行承担风险。
镜像市场：提供经严格审核的百款优质第三方镜像，预装操作系统、应用环境和各类软件，无需配置，可一键部署云服务器。满足建站/应用开发/可视化管理等个性化需求。
（6）选择实例存储规格
（7）选择快照服务
云数据库RDS
阿里云关系型数据库（Relational Database Service，简称 RDS）是一种稳定可靠、可弹性伸缩的在线数据库服务。基于阿里云分布式文件系统和高性能存储，RDS 支持 MySQL、SQL Server、PostgreSQL 和 PPAS（Postgre Plus Advanced Server，一种高度兼容 Oracle 的数据库）引擎，并且提供了容灾、备份、恢复、监控、迁移等方面的全套解决方案，彻底解决数据库运维的烦恼。
云数据库管理初体验
RDS实例链接方式：当RDS实例创建成功后，默认提供内网链接地址，用户可以通过数据传输服务或相同地域的ECS实例连接到RDS实例。若要通过本地服务器或不同地域的ECS实例连接到RDS实例，用户需申请外网地址。
RDS 数据库账号
在使用 RDS 数据库之前，需要在 RDS 实例中创建账号。同一实例下的数据库共享该实例下的所有资源，其中：
- MySQL 版实例和 SQL Server 版实例最多可以创建 500 个账号
- PostgreSQL 版实例和 PPAS 版实例没有账号个数限制
- RDS for SQL Server 2012 只能创建初始账号
注意事项：
（1）分配数据库账号权限时，按最小权限原则和业务角色创建账号，并合理分配只读和读写权限。必要时可以把数据库账号和数据库拆分成更小粒度，使每个数据库账号只能访问其业务之内的数据。如果不需要数据库写入操作，分配只读权限。
（2）设置数据库账号的密码为强密码，并定期更换。
创建数据库账号
（1）数据库账号：由 2~16 个字符的小写字母，数字或下划线组成、开头需为字母，结尾需为字母或数字，如 lab_user 。
（2）授权数据库：该账号授权的数据库，选取左边的 未授权数据库 ，单击授权，添加数据库到已授权数据库中。如果尚未创建数据库，该值可以为空。您可以通过已授权数据库右上角的权限设置按钮将该账号下的数据库权限批量设置为全部设读写或者全部设只读。
（3）密码：该账号对应的密码，由 6~32 个字符的字母、数字、中划线或下划线组成，如 password4example。
确认密码：输入与密码一致的字段，如 password4example，以确保密码正确输入。
（4）备注说明：可以备注该账号的相关信息，便于后续账号管理，最多支持 256 个字符（1 个汉字等于 3 个字符）。
RDS 数据库
用户可以通过 RDS 管理控制台 创建数据库。数据库名称实例内唯一，实例间互不影响。同一实例下的数据库共享该实例下的所有资源，其中：
-
MySQL 版实例最多可以创建 500 个数据库
-
SQL Server 2008 R2 版实例最多可以创建 50 个数据库
-
PostgreSQL 版实例和 PPAS 版实例没有数据库个数限制
创建数据库
（1）数据库(DB)名称：由 2~64 个字符的小写字母、数字、下划线或中划线组成，开头需为字母，结尾需为字母或数字。
（2）支持字符集：设置数据库的字符集：utf8、gbk、latin1 和 utf8mb4。
（3）授权账号：选择该数据库授权的账号。如果尚未创建账号，该值可以为空。
（4）账号类型：选择 授权账号 后可见，设置该数据库授权给 授权账号 的权限，可以设置为 读写 或者 只读 。
（5）备注说明：可以备注该数据库的相关信息，便于后续数据库管理，最多支持 256 个字符（1 个汉字等于 3 个字符）。
访问阿里云RDS管理控制台
实例:
管理:
在RDS实例上创建数据库
点击“创建”后：
登陆实例：
工作台：
数据导入：
lab.sql内容如下：
-- MySQL dump 10.13 Distrib 5.7.14, for linux-glibc2.5 (x86_64)
--
-- Host: localhost Database: yunku
-- ------------------------------------------------------
-- Server version 5.7.14
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admin_app_version`
--
DROP TABLE IF EXISTS `admin_app_version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_app_version` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`branch` varchar(20) NOT NULL DEFAULT '' COMMENT '分支',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '代号',
`v` tinyint(4) NOT NULL COMMENT '大版本',
`version` varchar(20) NOT NULL DEFAULT '' COMMENT '版本号',
`memo` text COMMENT '描述',
`filename` varchar(50) NOT NULL DEFAULT '' COMMENT '文件名',
`filehash` char(40) NOT NULL DEFAULT '' COMMENT '文件hash',
`filesize` int(20) unsigned NOT NULL COMMENT '文件大小',
`user_id` int(10) unsigned NOT NULL,
`addtime` datetime NOT NULL COMMENT '上传时间',
PRIMARY KEY (`id`),
KEY `name` (`name`,`version`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='客户端程序静默更新';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_app_version`
--
LOCK TABLES `admin_app_version` WRITE;
/*!40000 ALTER TABLE `admin_app_version` DISABLE KEYS */;
INSERT INTO `admin_app_version` VALUES (1,'','app_win',0,'20.0.14.0','','setup_20.0.14.0.exe','b2372943e0922b230989945af91bf9364a137e48',40657112,1,'2016-07-06 18:31:17'),(2,'','app_mac',0,'20.0.12','','gokuai_20.0.12.dmg','f2fae0ecf46b6deec982d5c47d45c2fea4efd931',11004666,1,'2016-07-06 18:32:10'),(3,'','app_android',0,'2.1.2.1','','yunku_philips_2.1.2.1.apk','97bccece874f3c2a595195773051e8e8146c605e',8354456,1,'2016-07-07 15:47:03'),(4,'','app_mac',0,'20.0.12','','ali_20.0.12.dmg','f2fae0ecf46b6deec982d5c47d45c2fea4efd931',11004666,1,'2016-07-08 13:28:57'),(5,'','app_iphone',0,'1.0.1','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE plist PUBLIC \"-//Apple//DTD PLIST 1.0//EN\" \"http://www.apple.com/DTDs/PropertyList-1.0.dtd\">\r\n<plist version=\"1.0\">\r\n<dict>\r\n <key>items</key>\r\n <array>\r\n <dict>\r\n <key>assets</key>\r\n <array>\r\n <dict>\r\n <key>kind</key>\r\n <string>software-package</string>\r\n <key>url</key>\r\n <string>https://philips-clientsoftware.oss-cn-shanghai.aliyuncs.com/app_iphone/app_1.0.1.ipa</string>\r\n </dict>\r\n <dict>\r\n <key>kind</key>\r\n <string>full-size-image</string>\r\n <key>needs-shine</key>\r\n <false/>\r\n <key>url</key>\r\n <string>https://dn-yksw.gokuai.com/iphone_installer.png</string>\r\n </dict>\r\n <dict>\r\n <key>kind</key>\r\n <string>display-image</string>\r\n <key>needs-shine</key>\r\n <false/>\r\n <key>url</key>\r\n <string>https://dn-yksw.gokuai.com/iphone_installer.png</string>\r\n </dict>\r\n </array>\r\n <key>metadata</key>\r\n <dict>\r\n <key>bundle-identifier</key>\r\n <string>com.gokuai.yunku.philips</string>\r\n <key>bundle-version</key>\r\n <string>1.0.1</string>\r\n <key>kind</key>\r\n <string>software</string>\r\n <key>title</key>\r\n <string>飞利浦云盘</string>\r\n <key>update_content</key>\r\n <array></array>\r\n </dict>\r\n </dict>\r\n </array>\r\n</dict>\r\n</plist>','app_1.0.1.ipa','8cdf95cade2187ea305a177defff2c43b377c5a3',11785604,1,'2016-07-10 05:05:54');
/*!40000 ALTER TABLE `admin_app_version` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_client_gui`
--
DROP TABLE IF EXISTS `admin_client_gui`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_client_gui` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`branch` varchar(20) NOT NULL DEFAULT '',
`hash` char(32) NOT NULL DEFAULT '',
`v` tinyint(4) NOT NULL COMMENT '大版本',
`type` tinyint(3) unsigned NOT NULL DEFAULT '1',
`source` varchar(20) NOT NULL DEFAULT '',
`platform` varchar(20) NOT NULL DEFAULT '',
`filesize` int(10) unsigned NOT NULL DEFAULT '0',
`property` text,
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `hash` (`branch`,`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_client_gui`
--
LOCK TABLES `admin_client_gui` WRITE;
/*!40000 ALTER TABLE `admin_client_gui` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_client_gui` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_notify_email`
--
DROP TABLE IF EXISTS `admin_notify_email`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_notify_email` (
`email` varchar(50) NOT NULL COMMENT '收件邮箱',
`type` varchar(20) NOT NULL COMMENT '通知类型:feedback,receipt',
`name` varchar(20) NOT NULL COMMENT '收件人名称',
`domain` varchar(20) DEFAULT NULL COMMENT '作用域',
`state` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`email`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用于运营的通知邮件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_notify_email`
--
LOCK TABLES `admin_notify_email` WRITE;
/*!40000 ALTER TABLE `admin_notify_email` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_notify_email` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user`
--
DROP TABLE IF EXISTS `admin_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`password` char(60) DEFAULT NULL,
`remember_token` text,
`state` tinyint(4) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`add_dateline` int(10) unsigned DEFAULT NULL,
`last_dateline` int(10) unsigned DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user`
--
LOCK TABLES `admin_user` WRITE;
/*!40000 ALTER TABLE `admin_user` DISABLE KEYS */;
INSERT INTO `admin_user` VALUES (1,'admin','$2y$10$8zkcvaFJUeYV1scTYRk3jekMrt34.jbXOyqRKZweil8lEKDTCe5yK',NULL,1,NULL,0,0,'127.0.01',1);
/*!40000 ALTER TABLE `admin_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_check_delete`
--
DROP TABLE IF EXISTS `file_check_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_check_delete` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`filehash` char(40) CHARACTER SET ascii NOT NULL COMMENT '文件hash',
`dateline` int(10) NOT NULL COMMENT '时间戳',
PRIMARY KEY (`id`),
KEY `filehash` (`filehash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_check_delete`
--
LOCK TABLES `file_check_delete` WRITE;
/*!40000 ALTER TABLE `file_check_delete` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_check_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_check_delete_storage`
--
DROP TABLE IF EXISTS `file_check_delete_storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_check_delete_storage` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`filehash` char(40) CHARACTER SET ascii NOT NULL COMMENT '文件hash',
`dateline` int(10) NOT NULL COMMENT '时间戳',
PRIMARY KEY (`id`),
UNIQUE KEY `storage_point_hash` (`storage_point`,`filehash`),
KEY `storage_point_id` (`storage_point`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_check_delete_storage`
--
LOCK TABLES `file_check_delete_storage` WRITE;
/*!40000 ALTER TABLE `file_check_delete_storage` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_check_delete_storage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_00`
--
DROP TABLE IF EXISTS `file_refer_00`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_00` (
`filehash` char(40) NOT NULL COMMENT '文件hash',
`hash` char(40) NOT NULL COMMENT 'hash',
`version` int(10) NOT NULL COMMENT '版本号',
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL COMMENT '时间戳',
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_00`
--
LOCK TABLES `file_refer_00` WRITE;
/*!40000 ALTER TABLE `file_refer_00` DISABLE KEYS */;
INSERT INTO `file_refer_00` VALUES ('007c0bfee1d7be6663e99f267f352d0f41a7aaac','0577fe119197e1bd867f9447f6263814e2ef099a',958,29,'95c22905ba598e4886c0',1468465378),('005860033a88f7602dd659b0078f18abc11b6a02','0592317805d7f3c3854273a9c71d78928a49db44',194,29,'95c22905ba598e4886c0',1468465232),('0056b5f5861228feaed8fb8896b816ec7a2a00b2','06aae033b5bdd8b57da2ec2d9375bb5e7629bddc',403,37,'95c22905ba598e4886c0',1468830366),('00ea223cb97ef1bb96f375bd9c3e040b580bc09a','09c5e8de2d021adf2ce8ae1dcb1daa6d2427dd08',309,29,'95c22905ba598e4886c0',1468465254),('006f06724b21f8bb95ab7017508bee7b86d734be','1c833c6db02b23f7698f259fa688f2113a02903a',724,29,'95c22905ba598e4886c0',1468465336),('00dade0b7b45ce773095ce002e23ba9331ddaea5','201a62e8051ef78904e30a2bf534031027b93035',1231,29,'95c22905ba598e4886c0',1468465430),('005754c24193a7181d9843a4804dbac8ed2a672d','3372473a0d9229acdc33bc2f15f5373a2aa92103',510,29,'95c22905ba598e4886c0',1468465293),('006a51d0d5589ca61cca2f0fb412379519b46a97','38362a5c59d08e89af70e24b1fe9de4161ebc8f5',103,6,'95c22905ba598e4886c0',1468558873),('002143a0c1598d584be83cca3e20244098e0b575','38e0a5d11ce80f48d9fe34c0e578d9b46d07d266',722,6,'95c22905ba598e4886c0',1469601519),('002482500f96a3cc7fe006fdeeee030454f124a0','4e0c501d6e939dedac43a506ebbe302878e54407',224,22,'95c22905ba598e4886c0',1468303162),('002482500f96a3cc7fe006fdeeee030454f124a0','4e0c501d6e939dedac43a506ebbe302878e54407',643,22,'95c22905ba598e4886c0',1468463856),('003b2b9a38c8e39f064432eb668b24509a5c0ef3','587519699ac1d4d018d73072751825bd0d27c978',790,31,'95c22905ba598e4886c0',1469203716),('00c9ccef5bc179d29bf2c3bd384f83f0c9ec3bdb','6d62ec11d7f61968ebbe1e5deb3c5254bba54133',148,31,'95c22905ba598e4886c0',1469188662),('0034903024d6636ae61596afa904930a541069f3','716ddd85c67a7ad05cc68e14e6c313717dd58d4c',744,29,'95c22905ba598e4886c0',1468465339),('005bb8653244e42632bbbebd05ed23238dfd8d6c','718d00926d19844c7f1f1c36695858152d7a4ba2',1155,29,'95c22905ba598e4886c0',1468465415),('0083cce9fe69b33195493cbe18c3c1224a6f9c3b','7f123fe92d34ddec5aceb0dc8df6319882cf1604',1647,29,'95c22905ba598e4886c0',1468476434),('005a578a4afc48499e9269e663a7dacd230570c3','8b26c8be2335c635cf33d3159c0b5f52759ba0ff',154,29,'95c22905ba598e4886c0',1468465216),('00632712c97a5381a1803da5c61557fcdb67791c','8b98fcba8de21c71577c366d14da2fb7bbca82bf',1097,31,'95c22905ba598e4886c0',1469258843),('00632712c97a5381a1803da5c61557fcdb67791c','8f4e06abf37dd4f5bd2e77826e9343639b8febcb',17,31,'95c22905ba598e4886c0',1468583799),('005dd7ef5ae20e17d60937f5b9494da21eb3aae6','9844c821f0e94dfa8407537e74f0359993c2e061',272,22,'95c22905ba598e4886c0',1468303173),('005dd7ef5ae20e17d60937f5b9494da21eb3aae6','9844c821f0e94dfa8407537e74f0359993c2e061',699,22,'95c22905ba598e4886c0',1468463925),('0080b1b0c7a41e80ca729dbb36cd4d31cf302ee6','d6662080febedc6f79e4b04512aa1bc66eb849fe',595,31,'95c22905ba598e4886c0',1469203614),('000502f82186763397d6065635f95ea366350449','d84e8c9c20e8b6a3ec67b536e3eba5837f07e7fe',341,20,'95c22905ba598e4886c0',1468305557),('006a51d0d5589ca61cca2f0fb412379519b46a97','e2c54f1b0311fe479fa1e6a8501af16012a67920',558,6,'95c22905ba598e4886c0',1468559047),('006a51d0d5589ca61cca2f0fb412379519b46a97','e4083e86f7c9fb8d57e452349ea9211ceacd17a3',789,6,'95c22905ba598e4886c0',1469601534),('002a84cbe1ce7c903df206a3ccb95658862d6427','e439ee50ec061f710d659e0788628d5ed4c942f4',1814,29,'95c22905ba598e4886c0',1468886167),('00e30ab8c6adefb61743caf028cdff4a6aac9fe5','ebe8d8509feb64f87bfa178c176f50f8db568fa3',1420,29,'95c22905ba598e4886c0',1468466275),('0089670efa0c48fc9283cf12ff8dc64b822a9ee9','f7d365fc0fdc6b477ea8f1b9e1632d0f303bbd3c',50,31,'95c22905ba598e4886c0',1468974394),('008ea8ac5b56a77605000cde08a575c1fb664a80','fb0db6f70bad18f5e5635732e68b75d32686b47c',45,20,'95c22905ba598e4886c0',1468305280);
/*!40000 ALTER TABLE `file_refer_00` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_01`
--
DROP TABLE IF EXISTS `file_refer_01`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_01` (
`filehash` char(40) NOT NULL,
`hash` char(40) NOT NULL,
`version` int(10) NOT NULL,
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_01`
--
LOCK TABLES `file_refer_01` WRITE;
/*!40000 ALTER TABLE `file_refer_01` DISABLE KEYS */;
INSERT INTO `file_refer_01` VALUES ('01c0250f0206c752a53e2a908e6d3789ca553a97','05afb6d7063a7177f3f8ebd10ef68f7a728330c0',1045,29,'95c22905ba598e4886c0',1468465395),('0117a9fd0be2c502b5d1072a824c66ea850511eb','1703295d0841f937d5e3dde59bd996cfec1f9a61',730,31,'95c22905ba598e4886c0',1469203700),('017114fa86d98d06990f42ec41cc15402acee4d6','1eaa896ef6827527484a87e59b455ab2e025c52c',954,22,'95c22905ba598e4886c0',1468837242),('011b10ed2d58dcacfeb5d279d2142d388da49aab','23842bd4131e15a744d50992d1cbe13abefd5ccb',790,6,'95c22905ba598e4886c0',1469601534),('0146183d64eab20c01fb2a0d653de6bb5095869c','29f161622bc73b55f0144672c21eff31ef06fea5',276,22,'95c22905ba598e4886c0',1468303173),('0146183d64eab20c01fb2a0d653de6bb5095869c','29f161622bc73b55f0144672c21eff31ef06fea5',703,22,'95c22905ba598e4886c0',1468463926),('01e863954762539ef5f2073396c0e4ba0d7c91cd','30c942db4cc9c853c8dae6eaf7415af3cbb084b6',645,20,'95c22905ba598e4886c0',1468305794),('0145a94f71141a63c34cb3b81829361f39cf2c99','3a0ff0a02edc92e30c466a5969caea7839d75ad7',455,29,'95c22905ba598e4886c0',1468465283),('011b10ed2d58dcacfeb5d279d2142d388da49aab','47595477d97b85d7fc5cddc0ff49ba6d4abfc435',108,6,'95c22905ba598e4886c0',1468558882),('01d1b5c3baf2ad9be1d68512112cbbd2e88e8303','479f7ec783e42fdb5b6b8a50d4ab54f7d7e21296',298,37,'95c22905ba598e4886c0',1468830341),('017426ad9e0e1e44904ef3befb3199c2a1136e8c','5aac19cc21479f98d8717d5dec0fd4ddf47a3a97',957,20,'95c22905ba598e4886c0',1468306044),('015a7c57b039c53d885fb9d1198bc5cbc8c1e424','5c525970f82c74a1f723b34ad95c38e3e6ee7131',631,31,'95c22905ba598e4886c0',1469203635),('012337bd196d208f519f5aa4f0a4c6fa91c97cdc','5f41b45e19e61f2591e3279bf73b86e1101fa2e8',751,29,'95c22905ba598e4886c0',1468465340),('01bc8384be1b116578047a27546af6fd5be7b3fa','6b4d3f35066ed4f30ab33c1ed0c4f6d451735d18',12,27,'95c22905ba598e4886c0',1468387885),('011b10ed2d58dcacfeb5d279d2142d388da49aab','780c395f0c5649813818b8cc3f8dd1d9988569b2',560,6,'95c22905ba598e4886c0',1468559048),('01434452f5baf92944afbe9391d051c993d101dd','7851ceb8d189d62093f6e6a8c8d8dbf4c0360d27',51,37,'95c22905ba598e4886c0',1468830282),('01d6287174e527954d00da19b260e9dfb2b93e57','83e3d9924e7c80e5be2a7899a8aa64c3edf4d0c3',408,37,'95c22905ba598e4886c0',1468830367),('0141059bbc1aaf099e0fd1ce608d7aca51f47402','948a2295816027d264cc9ada23a27a8865c78e01',120,22,'95c22905ba598e4886c0',1468303135),('0141059bbc1aaf099e0fd1ce608d7aca51f47402','948a2295816027d264cc9ada23a27a8865c78e01',525,22,'95c22905ba598e4886c0',1468463717),('017426ad9e0e1e44904ef3befb3199c2a1136e8c','99493f82850c159697d057ce194c87883abf9742',121,20,'95c22905ba598e4886c0',1468305349),('01af5457a99c1e76ea140c021343bcfd65fd83b7','a084d0d8df5e70d1213b5e882418b8001672b333',101,29,'95c22905ba598e4886c0',1468465190),('012e7c93a3ba8e75e84812432825728e0d58d0c8','ae25bb49d879a3071551a420cf992a45c1b7f47b',1762,29,'95c22905ba598e4886c0',1468809007),('018b5237002bde831301801335f14abb2d3a4a29','b10fcaffa751dec49c6ba97ef8947f2ac5150e5a',513,29,'95c22905ba598e4886c0',1468465293),('01632ba3c853be8856ff63e68507db14e005ea9c','c362c430a94c26c3d449e71d5096a60776732c08',273,22,'95c22905ba598e4886c0',1468303173),('01632ba3c853be8856ff63e68507db14e005ea9c','c362c430a94c26c3d449e71d5096a60776732c08',700,22,'95c22905ba598e4886c0',1468463926),('01a78cd558a90662304eaaf7e88860a66fd052ea','c7840373eeccc637edc7ee1737c049ac729d9f95',1587,29,'95c22905ba598e4886c0',1468476181),('014b4c7506086bfb8fc5f2e623b28bcbc1a32f7d','f144ceb46839be1bf0b3e97fecc604b8a5d921c0',1298,20,'95c22905ba598e4886c0',1468306273),('019c0ab22bf4e2e0caf8bee432ed027d5ad0da19','f71a0513b661344998c0bd0d7ba545c13848372f',88,29,'95c22905ba598e4886c0',1468465180);
/*!40000 ALTER TABLE `file_refer_01` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_02`
--
DROP TABLE IF EXISTS `file_refer_02`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_02` (
`filehash` char(40) NOT NULL,
`hash` char(40) NOT NULL,
`version` int(10) NOT NULL,
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_02`
--
LOCK TABLES `file_refer_02` WRITE;
/*!40000 ALTER TABLE `file_refer_02` DISABLE KEYS */;
INSERT INTO `file_refer_02` VALUES ('02ba412f8baf9f611aa5c4206422810b2ca41813','08f1ebdf4bf3defed8f6f86687d659f7297e9206',975,29,'95c22905ba598e4886c0',1468465381),('02227e72e66891f6ead313d7861f885244d53b3f','0f225517bdb1640d8f8b62ebe0657abb5e325736',360,29,'95c22905ba598e4886c0',1468465263),('023a2f8b5103ddeac10ef46e272073ffa8071a7e','1684e7fb610ee6c1eef2cc5addd78d0338a99c15',834,20,'95c22905ba598e4886c0',1468305907),('02f9d66d8911f0998d18203c02c3151133a39935','34f45b4997ea3d02bb7b683e7f30f4fa08ca207f',169,37,'95c22905ba598e4886c0',1468830311),('023ec64d48b647b35b7cceefe8ceda702d226961','41f23dabff0f649d5ce687e93fa335a39e790a1c',993,29,'95c22905ba598e4886c0',1468465384),('026fe686f034463dbb6720ae6d82083b40c33a6b','45a82399495773adfe9c40a4498704ea7a46433a',295,6,'95c22905ba598e4886c0',1468558939),('02225a401324495556bced5f7390d5a17a0b562e','589df942040b0527fa9bcd487bac9b8706fe8539',662,6,'95c22905ba598e4886c0',1468559070),('02225a401324495556bced5f7390d5a17a0b562e','58b86040cf38dc58d9dbb4b203cfb7a59c231be0',217,6,'95c22905ba598e4886c0',1468558921),('02b0eca2112004f696d7958d71da00d5fdca181a','630ab688067b328352ab98776dda1862de4e5988',721,6,'95c22905ba598e4886c0',1469601515),('02529a141671e3df614ff98b3898647bd2a486a2','63e4fe66f437775615305122e3af2893dcd60033',632,29,'95c22905ba598e4886c0',1468465318),('02a055e79700067542ac8b6812a57957639341cf','7325fd9caa54df0fb768d635751c24150db6de27',438,20,'95c22905ba598e4886c0',1468305633),('02b5daec1356b1372048af600d4bbef936d98d31','83bdf74fbe04538f9b1fa71f97d2825a3524bd4c',290,22,'95c22905ba598e4886c0',1468303177),('02b5daec1356b1372048af600d4bbef936d98d31','83bdf74fbe04538f9b1fa71f97d2825a3524bd4c',717,22,'95c22905ba598e4886c0',1468463929),('0258b520868519b0d6513f977bbf5e589f27c2f5','8ad83cbad1c2b49d7ce9f54307f72aba1de1d774',476,29,'95c22905ba598e4886c0',1468465286),('028336394e78d9eb15c22a7e2541ac9e12c2ecb2','8e3eead54891132fbe433fadb7dcf3ce7a277d3c',954,31,'95c22905ba598e4886c0',1469203771),('0294d8e0438de988c4144dabcd5f4a9515d14ffb','a94bba1f9eb86bdbd5a0a6a72a94165888357972',739,20,'95c22905ba598e4886c0',1468305846),('02225a401324495556bced5f7390d5a17a0b562e','bda41c41ceee7d8bbf8a7f98339ef54cf1a79448',886,6,'95c22905ba598e4886c0',1469601555),('029952c0530e67442bf30a71cc5a25c08d4522dc','e3c219bc2910fca059282e438b7b8dfc233b7e19',730,6,'95c22905ba598e4886c0',1469601517),('02b695fee2c930d0de808856181a522bf1ce1f3f','e54211e78ecf8a21ec867a06caa29a765e29e8f7',248,29,'95c22905ba598e4886c0',1468465242),('02207ff3b47f404ae945c206e6713334a95cd633','e62d16b19a97911401bd800f3e1ef99fb265626b',1344,20,'95c22905ba598e4886c0',1468306297),('02143d065471673119651a3486f4a2c8c4e1bd80','f5d065c91a967fc9d957fe906cabcc15fb611883',1085,20,'95c22905ba598e4886c0',1468306133),('029300c7e6c41b5e10212edd8147e35dc55ebf60','fa2a93b209c52ac75457d585d33dd511e1a2d7e2',35,37,'95c22905ba598e4886c0',1468830278),('0202aa961c9ccc2afa262f032069f83adf4a7c98','fa60adfce7d6a0c9c2884f07137ade279fb52aca',74,37,'95c22905ba598e4886c0',1468830288),('02550e4352dc66b89c72ae0ae4395841a8482961','fd4dc246c44ff9b72bfd21d281c2ad1846e4580a',411,29,'95c22905ba598e4886c0',1468465273),('028b40d8d32496f15029db75129ee6817af3bdd9','fd87e4a72c5367e8eedc8453d934812c774b5f17',385,22,'95c22905ba598e4886c0',1468303372);
/*!40000 ALTER TABLE `file_refer_02` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_03`
--
DROP TABLE IF EXISTS `file_refer_03`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_03` (
`filehash` char(40) NOT NULL,
`hash` char(40) NOT NULL,
`version` int(10) NOT NULL,
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_03`
--
LOCK TABLES `file_refer_03` WRITE;
/*!40000 ALTER TABLE `file_refer_03` DISABLE KEYS */;
INSERT INTO `file_refer_03` VALUES ('03036321178b693ba4d9ef18402a9663e15da9ba','032983fd9909a95ebf67cacfb6fe1875d1333c26',575,31,'95c22905ba598e4886c0',1469203605),('0346a803882ee507c9b0834473669293f33a1ed6','064c8a150ac2ed1f8b7a1314ed389104733ac268',273,31,'95c22905ba598e4886c0',1469203464),('0373de956b1d2f3ab39d12fd6f7a299a26b2db25','0ab3e344c87f7460a41eb340aaf65824098b966f',283,6,'95c22905ba598e4886c0',1468558936),('03324168a05312acbfaba2342227ba70873e80ca','213b2e10f9e1b97bb43329733227b43f08912e59',453,22,'95c22905ba598e4886c0',1468303418),('035849d5a34cf3c32e25c74ab93ed18374f53ea6','23db167c095587f1eaee0f4c7fc58a575eb3db36',453,20,'95c22905ba598e4886c0',1468305639),('0357ab0fbc1df69c4bf67faf8b796020aff2fff3','288dc7458ab3c3d06da1ac28125e79bcf16ebbdd',393,6,'95c22905ba598e4886c0',1468558959),('0334d11333498ebbc416641fc16e4c667d5e3fac','325b9dd5dd3c6405fbee6df8c0a307a18e6dd724',1201,20,'95c22905ba598e4886c0',1468306192),('037e48f1fbf0383f1d43c8bc83d6d3f91464af5b','3c17c19b1be2d86a043f58ea2eb369fadc661de5',255,20,'95c22905ba598e4886c0',1468305461),('03af5bd634b452f6f7755fcb6961936eab2adf5c','3d35ceb288f855242878918fe4b3d9478ec6e739',189,31,'95c22905ba598e4886c0',1469188675),('03bc67a4642ec682d0f5fd0b763e2593502f8cce','4ed0834d0e51221d5736963d941c32da97a73274',600,29,'95c22905ba598e4886c0',1468465311),('03b4c77ca7fcc2fa1285bf1b0b1e95f1fddf5be7','5986c294b6e809ce13e56479bb3e1e37fef79e5c',885,31,'95c22905ba598e4886c0',1469203749),('033574cab00185209415eeb7e19bdabd485b2483','611c80104236fe994a19dc62a9aed456e05e735f',437,22,'95c22905ba598e4886c0',1468303390),('0374e0f02bd0a5ed2e2ee72572692965f7af67f1','6229e78f7d61749e3c3451a772306ce011dd2413',110,37,'95c22905ba598e4886c0',1468830297),('03c70bf6377c5b2edfb0ac09b0ded13ee2c7a0e4','6f229a53388483512c5959c79f99ea998919c2e5',681,22,'95c22905ba598e4886c0',1468463889),('03c70bf6377c5b2edfb0ac09b0ded13ee2c7a0e4','6f229a53388483512c5959c79f99ea998919c2e5',805,22,'95c22905ba598e4886c0',1468478576),('03031623415fa7490bae84c627a2794144efb655','728ba02aba65d4e605556c6435fa9d5470afb7e7',852,20,'95c22905ba598e4886c0',1468305914),('03e25e8d8f2d58f66bac687068c85496fe7a4532','7f2a5e824c8276e8207092c96711f74b5ff84ea5',701,20,'95c22905ba598e4886c0',1468305825),('03401b7c03513dde599fc29d97baa4dc11e59cc1','93e778c2503b4c50db236522e2bc6d752095dbdb',299,20,'95c22905ba598e4886c0',1468305537),('033cfb8ccb0df528d3836e018778c6f34b46129e','ac7e24d7f84935e1a55978c70e4d230b171564db',316,37,'95c22905ba598e4886c0',1468830346),('03d5d0addb9ba9b82cfb7cfb88caeb65681befa0','b50b550ea1a61abe41ee4cc0e257915f68587047',1636,29,'95c22905ba598e4886c0',1468476377),('038892325808fbed0479ee355c9bf982e3ebe4e2','b5273ac92d62812a4b92410179f300ec34475227',430,29,'95c22905ba598e4886c0',1468465278),('036168601f9b406af894b3c2675667e32731c4cd','b847b4ebf8da33dcf0e34b90612760962332dca1',734,29,'95c22905ba598e4886c0',1468465337),('03cb7c925efa3a0d2cd7cd80a64d23f0ad295d5d','bd551215edbe7852db5d7417c43fb6bdb9e06f60',950,6,'95c22905ba598e4886c0',1470204091),('03b8d44561771be3bdcab30c85951f77aefa2ffb','bdf38d05888f596a64ebc8f732ef1d0a9dcd3617',705,31,'95c22905ba598e4886c0',1469203698),('03b4792181ccee84058faef2dd59c4f94a49dca3','cf8eb95a3a1720d5deeffd799ee4133c0a0401b0',1829,29,'95c22905ba598e4886c0',1469025383),('035ea32404cae4d831a5b8eeca7ae813e04659ff','d20c8573aab54b7b03f253eb06ed570fdabd2e70',1400,29,'95c22905ba598e4886c0',1468466049),('03b6b0d4e23efdcd8864d3dcc22cd0c6e755dd55','d22d91f7038877ff06a96163d474da791e95ed5b',356,37,'95c22905ba598e4886c0',1468830355),('033d033de7078be18ea0ef4a9aacfb6acc211c1c','ea479e6b451d387b99c73c978ab468f00baf4df7',436,29,'95c22905ba598e4886c0',1468465279),('039b37bf0e8fa3d288ff332445abfc793ffcdd15','f1938fb6466315f3c6d7bb37c2cd8c70d0659d8d',471,29,'95c22905ba598e4886c0',1468465286);
/*!40000 ALTER TABLE `file_refer_03` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_04`
--
DROP TABLE IF EXISTS `file_refer_04`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_04` (
`filehash` char(40) NOT NULL,
`hash` char(40) NOT NULL,
`version` int(10) NOT NULL,
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_04`
--
LOCK TABLES `file_refer_04` WRITE;
/*!40000 ALTER TABLE `file_refer_04` DISABLE KEYS */;
INSERT INTO `file_refer_04` VALUES ('04f5c36c4c74a0a9f9e91d794edea7d6e82c88cb','109477e463392a41475af8859f952aa87d48ee0e',167,37,'95c22905ba598e4886c0',1468830312),('0438be992a6b438fdd1f582064f42ef34ea90b10','15f1742be2b47ea753ed20546aeef6f251a3de8f',73,31,'95c22905ba598e4886c0',1469188624),('04d8b860c8a5906e98f665e05e6b586c5ce729ef','2051d1cc1ad4cad7b638b916bb6473b9b3c0536b',624,6,'95c22905ba598e4886c0',1468559062),('044d7d9a7b76ef43bc7910377dce3ce7c14bfb1f','2f032458da0640e24c282c32467912bf5b367da1',1075,29,'95c22905ba598e4886c0',1468465400),('0405eb13b1ed3573a42aa0a97f08d0e2e5cf4ca9','35929f051c8e20996e674e70ef05e2d07d53821b',254,37,'95c22905ba598e4886c0',1468830331),('0438be992a6b438fdd1f582064f42ef34ea90b10','3a7eab679fd112ace4887508b894439dce6438d1',44,31,'95c22905ba598e4886c0',1468974303),('0431ed0d3046d7ed9a7ce8f3f4bd1db2d499cdd2','3cbd7669ecb833f07d5e67c22ea8628b8dda0973',1661,29,'95c22905ba598e4886c0',1468476556),('04fbe215ea69ed581ecb32befeb5962cff589eca','612f956ee521ea3f1bdd035c3add9d6f6db32efc',874,29,'95c22905ba598e4886c0',1468465363),('0454d5d4f0409eabec5230b51d393a9bffeefd42','645d9ee131cfa116ce6a6d371ff0ad54196cd3b5',572,20,'95c22905ba598e4886c0',1468305715),('0438be992a6b438fdd1f582064f42ef34ea90b10','6aedd416c35521d104cefc08f57a76a27c3161fd',1123,31,'95c22905ba598e4886c0',1469258847),('042651f3bc9f4861920ab1faf30a3ccf6a2f9cec','6fb296452507bc9e285c487f28b1ae09833e1543',349,31,'95c22905ba598e4886c0',1469203487),('047ad8c3717f7df51418372207d2cd3b819ec633','76a445c1bd90b8b11ec87fdbb4a7de79f234358b',143,31,'95c22905ba598e4886c0',1469188660),('04f42603b0308e4aa18d6d0467a2874469c12f76','7b8df15d549a7541d68fb9a829392f06a590da1b',408,22,'95c22905ba598e4886c0',1468303378),('0420373eb2022d941b4c1d4cca672c6b4a1cee84','86b61e1f288afbf2f9b8c8642be9763843ac91dd',531,29,'95c22905ba598e4886c0',1468465297),('04ebbc11a8a290f0181bc2722e5f2e7ee171f2af','970f032e9d705f2883f97c27ee66ff73235a6118',180,29,'95c22905ba598e4886c0',1468465229),('040f1b6f224e197646196d2916b430cd1cb0d02e','9a3a87b3e3ba7ccba9f9870632aac27dc66e3ba4',803,20,'95c22905ba598e4886c0',1468305896),('04d8b860c8a5906e98f665e05e6b586c5ce729ef','9c6e3a73c8f3acb7a5b1b0ea191f0000ec1f6a2f',865,6,'95c22905ba598e4886c0',1469601549),('04cd0ee4123f97d057e8e1a36c0696e88ed990f4','a54d7022e96c94bc753c0f703aae11e794bd8d24',648,29,'95c22905ba598e4886c0',1468465321),('04fd767f838474814e04be6551bfdb492bf80532','d70071ea34fef364f85a1904907491a97d63e945',36,20,'95c22905ba598e4886c0',1468305276),('04d8b860c8a5906e98f665e05e6b586c5ce729ef','dba4c8047f16b2f3b38f8a2c6555cf49d41a145b',181,6,'95c22905ba598e4886c0',1468558905),('04cbacb9a8bd24c180fa04ad28b829c1995b41c2','e137f8ff0fd6b5a9481b35d365e45cd17d8dd058',1268,29,'95c22905ba598e4886c0',1468465439),('049eec8642ffce9859f96535846122fc6808f28e','e622abbaa18db20fe0d1a6742e578c1776f5adb8',1055,31,'95c22905ba598e4886c0',1469203843),('04cf5117912c1044f5f2e000015e65f455d52e70','e9284d9245fc131770e319971ec40e53c5346891',119,29,'95c22905ba598e4886c0',1468465205),('0446bc6e32400006bf095283c150d624a6462da9','eda3eff99e94530f7e921dfe444206dd721a02a8',984,31,'95c22905ba598e4886c0',1469203792),('04eb84ad317e5ed3d85ba78ddf03f841e6af9bfe','f0b8187d2253816256874d16457a0316000999ff',793,29,'95c22905ba598e4886c0',1468465347),('048af537bdb688d3d12bdb98960bd2020946a6bd','fe6cd4975a11a0696d168b63527cb121ce0fad02',292,6,'95c22905ba598e4886c0',1468558938);
/*!40000 ALTER TABLE `file_refer_04` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `file_refer_05`
--
DROP TABLE IF EXISTS `file_refer_05`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_refer_05` (
`filehash` char(40) NOT NULL,
`hash` char(40) NOT NULL,
`version` int(10) NOT NULL,
`mount_id` int(10) unsigned NOT NULL COMMENT 'mount_id',
`storage_point` varchar(20) NOT NULL COMMENT '存储点',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`hash`,`version`,`storage_point`),
KEY `dateline` (`dateline`),
KEY `file_hash` (`filehash`,`hash`),
KEY `file_storage` (`filehash`,`storage_point`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `file_refer_05`
--
LOCK TABLES `file_refer_05` WRITE;
/*!40000 ALTER TABLE `file_refer_05` DISABLE KEYS */;
INSERT INTO `file_refer_05` VALUES ('05507e47ef348c65073171f1aa1c516adf6d76bf','16db14d2f0cbf5f0df1b5809db332dcc2226c059',1189,22,'95c22905ba598e4886c0',1469038108),('0519712f5a2c66346cd1670e8961ce268cba5170','17cd6cb32674031dfad495b82380621be0d7c4f3',242,22,'95c22905ba598e4886c0',1468303166),('0519712f5a2c66346cd1670e8961ce268cba5170','17cd6cb32674031dfad495b82380621be0d7c4f3',661,22,'95c22905ba598e4886c0',1468463859),('05e7e22e9f5aaf1e3e50c1eaeffa7401fed057cb','2029faf4dd19712c2620557d99f13840b66692a4',910,31,'95c22905ba598e4886c0',1469203747),('05c04b33a8e73a692cf2e79f0c622d546acf3502','2e6e2f445544573448583605e8e428ac1a47fa21',1199,29,'95c22905ba598e4886c0',1468465423),('05cd9ba5638b032761667656f630cbeb3d2b73b7','3d15cb675b9ad5be40258d709540a9a59840e73e',308,29,'95c22905ba598e4886c0',1468465254),('05fc0baa7ffc55a73c5c66a5585ca450ba885eb7','4cd2aed876117ea7535d0bd4eb40fce057d3f535',187,20,'95c22905ba598e4886c0',1468305382),('0562cd94c797d98a79bbf72dd1b10a6ac0ff281e','5c80a1d5203867a7c5617695e9fa20fd5812b0ca',1253,29,'95c22905ba598e4886c0',1468465436),('055b8044d879dd9b3e6ab580a0dbfca14df0f04e','83851a0b219a93274260e70ac293b1b4eedf1825',1117,20,'95c22905ba598e4886c0',1468306141),('05dbcfcdbce17f18be3c08a944342e504be69ddb','8daf1b61824b2b08b1826a7a66e21e370620059a',520,31,'95c22905ba598e4886c0',1469203578),('05e15df7a08d428114b3f10797542fccf2930c03','90751579b794cb8f2c4d5a54db3a8586f9200d13',564,31,'95c22905ba598e4886c0',1469203598),('0506e11d1071ed744bd5dc733b0631ee03f73a28','99b64caf2714d89d4ac1e455dfe22852785eb3e1',1229,20,'95c22905ba598e4886c0',1468306227),('05a29cc1a61addd8940ea7bdd018b60e38476396','a824c5a5dc94db3b82679e2ede14eb5f9d3988cd',607,29,'95c22905ba598e4886c0',1468465313),('05b7b2ddb615703690dc140804fe734436ee4738','bc6da42fa7875165afc43130d39f1c71dc03637f',892,29,'95c22905ba598e4886c0',1468465366),('05b4dbef9f01fc35152b0294baecf3e58f14781e','d2cf14709dc64e96393998ce82f22b697a3217a7',767,29,'95c22905ba598e4886c0',1468465344),('05f07f819454a04422afbb6ce519f13451848d2e','e0c611db579bec6bff0dd7644988859f465ee092',1088,29,'95c22905ba598e4886c0',1468465402),('0579cee4abeafb9d0fe72aea8d137ee3fe972c22','e3656edd7318b6b40a0fac3b60c501ca601f8a12',1330,29,'95c22905ba598e4886c0',1468465452),('053b249e1586f9f69c02951d441160dc04d9f233','e72b04be002f2aed70d5d0ea4cf1c0846d00a3be',1768,29,'95c22905ba598e4886c0',1468809017),('05c6bcfaca6c34bea7878f7f1a7cf85a6efdd2d1','f7492b5a1d1a3f46c1b4c7a741d9b4983b1a0bf1',459,6,'95c22905ba598e4886c0',1468558973),('050ab4f96f8c7ceb915fccd42d679ff73e11cb96','fce0005a9befeb0b1446ade5a66c0affab16daf7',767,20,'95c22905ba598e4886c0',1468305883);
/*!40000 ALTER TABLE `file_refer_05` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_account`
--
DROP TABLE IF EXISTS `pay_account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_account` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`product_id` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '产品名称',
`total_charge` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总充值',
`total_gift` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总赠送',
`balance` float(9,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
`freeze` float(9,2) NOT NULL DEFAULT '0.00' COMMENT '冻结金额',
`receipt` float(9,2) NOT NULL DEFAULT '0.00' COMMENT '可索取发票额度',
`arrear_day` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '欠费天数',
`cost_reminded` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '扣费提醒',
`arrear_reminded` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '欠费提醒',
`end_dateline` int(11) NOT NULL DEFAULT '-1' COMMENT '到期日期',
`info` text COMMENT '扩展信息',
`state` tinyint(4) DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='账户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_account`
--
LOCK TABLES `pay_account` WRITE;
/*!40000 ALTER TABLE `pay_account` DISABLE KEYS */;
INSERT INTO `pay_account` VALUES (1,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(2,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(3,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(4,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(5,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(6,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(7,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(8,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(9,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(10,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(11,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(12,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(13,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(14,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(15,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(16,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(17,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(18,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(19,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(20,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(21,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(22,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(23,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(24,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(25,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(26,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(27,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(28,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(29,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(30,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(31,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1),(32,100,0,0,0.00,0.00,0.00,0,0,0,-1,NULL,1);
/*!40000 ALTER TABLE `pay_account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_account_rel`
--
DROP TABLE IF EXISTS `pay_account_rel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_account_rel` (
`account_id` int(11) unsigned NOT NULL,
`rel_id` int(11) unsigned NOT NULL,
`type` varchar(20) NOT NULL,
PRIMARY KEY (`account_id`,`rel_id`,`type`),
KEY `rel_id` (`rel_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_account_rel`
--
LOCK TABLES `pay_account_rel` WRITE;
/*!40000 ALTER TABLE `pay_account_rel` DISABLE KEYS */;
INSERT INTO `pay_account_rel` VALUES (1,1,'p'),(2,2,'p'),(3,3,'p'),(4,4,'p'),(5,5,'p'),(6,6,'p'),(7,7,'p'),(8,8,'p'),(9,9,'p'),(10,10,'p'),(11,11,'p'),(12,12,'p'),(13,13,'p'),(14,14,'p'),(15,15,'p'),(16,16,'p'),(17,17,'p'),(18,18,'p'),(19,19,'p'),(20,20,'p'),(21,21,'p'),(22,22,'p'),(23,23,'p'),(24,24,'p'),(25,25,'p'),(26,26,'p'),(27,27,'p'),(28,28,'p'),(29,29,'p'),(30,30,'p'),(31,31,'p'),(32,32,'p');
/*!40000 ALTER TABLE `pay_account_rel` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_card`
--
DROP TABLE IF EXISTS `pay_card`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_card` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`batch_id` int(10) unsigned DEFAULT '0',
`cardno` varchar(100) NOT NULL DEFAULT '',
`state` tinyint(1) NOT NULL DEFAULT '1',
`member_id` int(10) unsigned DEFAULT '0',
`ent_id` int(10) unsigned DEFAULT '0',
`last_dateline` int(10) unsigned DEFAULT '0',
`assign` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cardno` (`cardno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_card`
--
LOCK TABLES `pay_card` WRITE;
/*!40000 ALTER TABLE `pay_card` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_card` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_card_batch`
--
DROP TABLE IF EXISTS `pay_card_batch`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_card_batch` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`batchno` char(4) DEFAULT NULL COMMENT '批次号',
`type` tinyint(3) unsigned DEFAULT '1' COMMENT '类型',
`name` varchar(20) NOT NULL COMMENT '批次名称',
`num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '卡数量',
`memo` varchar(200) DEFAULT '' COMMENT '备注',
`product_id` smallint(5) unsigned DEFAULT '0' COMMENT '产品id',
`period` smallint(6) DEFAULT '3' COMMENT '时长',
`money` smallint(5) unsigned DEFAULT '0' COMMENT '金额',
`state` tinyint(4) DEFAULT '1' COMMENT '状态',
`cardno_length` tinyint(3) unsigned DEFAULT '12' COMMENT '卡号长度',
`expire_dateline` int(10) unsigned DEFAULT '0' COMMENT '失效时间',
`addtime` datetime DEFAULT NULL COMMENT '开卡时间',
PRIMARY KEY (`id`),
UNIQUE KEY `batchno` (`batchno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_card_batch`
--
LOCK TABLES `pay_card_batch` WRITE;
/*!40000 ALTER TABLE `pay_card_batch` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_card_batch` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_member_profile`
--
DROP TABLE IF EXISTS `pay_member_profile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_member_profile` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`member_id` int(10) NOT NULL COMMENT '用户ID',
`member_name` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名称',
`member_phone` varchar(50) NOT NULL COMMENT '电话',
`company` varchar(100) NOT NULL COMMENT '公司',
`dateline` int(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户个人资料表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_member_profile`
--
LOCK TABLES `pay_member_profile` WRITE;
/*!40000 ALTER TABLE `pay_member_profile` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_member_profile` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_member_trade`
--
DROP TABLE IF EXISTS `pay_member_trade`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_member_trade` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`org_id` int(11) unsigned NOT NULL DEFAULT '0',
`member_id` int(11) unsigned NOT NULL,
`product_id` smallint(5) unsigned NOT NULL,
`pay_product_id` smallint(5) unsigned DEFAULT NULL,
`space` int(10) unsigned NOT NULL,
`space_count` smallint(5) unsigned NOT NULL DEFAULT '1',
`fee` float(9,2) NOT NULL,
`amount` smallint(5) unsigned NOT NULL DEFAULT '1',
`begindate` int(10) unsigned NOT NULL,
`enddate` int(10) unsigned NOT NULL DEFAULT '0',
`state` tinyint(4) NOT NULL,
`out_trade_no` char(22) NOT NULL,
`trade_no` varchar(50) DEFAULT NULL,
`buyer_info` varchar(200) DEFAULT NULL,
`extra` text,
`receipt_state` tinyint(4) NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL,
`finishtime` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `list` (`org_id`,`member_id`,`state`),
KEY `available` (`org_id`,`member_id`,`product_id`,`space_count`,`enddate`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_member_trade`
--
LOCK TABLES `pay_member_trade` WRITE;
/*!40000 ALTER TABLE `pay_member_trade` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_member_trade` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_payment`
--
DROP TABLE IF EXISTS `pay_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_payment` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`ename` varchar(50) NOT NULL DEFAULT '',
`img` varchar(256) NOT NULL DEFAULT '',
`remark` varchar(200) NOT NULL DEFAULT '',
`state` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `ename` (`ename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_payment`
--
LOCK TABLES `pay_payment` WRITE;
/*!40000 ALTER TABLE `pay_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_payment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_product`
--
DROP TABLE IF EXISTS `pay_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_product` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`product_id` smallint(5) unsigned NOT NULL COMMENT '产品id',
`name` varchar(100) NOT NULL DEFAULT '',
`title` varchar(200) NOT NULL DEFAULT '',
`memo` varchar(200) NOT NULL DEFAULT '',
`type` varchar(10) NOT NULL DEFAULT 'p' COMMENT '类型,p个人,org团队',
`level` tinyint(3) unsigned NOT NULL DEFAULT '1',
`number` int(10) NOT NULL DEFAULT '0' COMMENT '单位G',
`price` float(9,2) NOT NULL DEFAULT '0.00',
`years` smallint(5) unsigned NOT NULL COMMENT '套餐年数',
`months` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '折合成月数',
`days` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '折合成天数',
`state` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `product_year` (`product_id`,`years`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_product`
--
LOCK TABLES `pay_product` WRITE;
/*!40000 ALTER TABLE `pay_product` DISABLE KEYS */;
INSERT INTO `pay_product` VALUES (23,23,'Gokuai Enterprise Ultimate','旗舰版','','ent',7,-1,3000.00,0,1,30,0),(100,100,'Gokuai Personal','个人版','','p',1,5,0.00,0,1,30,1),(101,101,'Gokuai Team','团队版','','p',2,10,99.00,0,1,30,1);
/*!40000 ALTER TABLE `pay_product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_trade`
--
DROP TABLE IF EXISTS `pay_trade`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_trade` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '订单类型',
`account_id` int(10) unsigned NOT NULL COMMENT '账户id',
`ent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '团队id',
`member_id` int(10) unsigned NOT NULL COMMENT '用户id',
`product_id` smallint(5) unsigned NOT NULL COMMENT '产品id',
`pay_product_id` smallint(5) unsigned NOT NULL COMMENT '付费产品id',
`number` smallint(5) unsigned NOT NULL COMMENT '购买个数',
`fee` float(9,2) NOT NULL,
`period` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '时长',
`begin_dateline` int(10) unsigned NOT NULL COMMENT '服务开始',
`end_dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务结束',
`state` tinyint(4) NOT NULL COMMENT '订单状态',
`out_trade_no` char(22) NOT NULL DEFAULT '' COMMENT '订单号',
`trade_no` varchar(50) DEFAULT NULL COMMENT '支付号',
`buyer_info` varchar(200) DEFAULT NULL COMMENT '支付人信息',
`extra` text COMMENT '附加信息',
`receipt_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '开票状态',
`add_dateline` int(10) unsigned NOT NULL,
`finish_dateline` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `available` (`ent_id`,`member_id`,`product_id`,`end_dateline`,`state`),
KEY `list` (`ent_id`,`member_id`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_trade`
--
LOCK TABLES `pay_trade` WRITE;
/*!40000 ALTER TABLE `pay_trade` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_trade` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay_trade_detail`
--
DROP TABLE IF EXISTS `pay_trade_detail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_trade_detail` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(11) unsigned NOT NULL,
`type` tinyint(4) NOT NULL COMMENT '类型',
`sub_type` tinyint(4) DEFAULT NULL COMMENT '子类型',
`fee` float(9,2) NOT NULL COMMENT '金额',
`state` tinyint(4) unsigned NOT NULL COMMENT '状态',
`member_id` int(10) unsigned DEFAULT NULL,
`out_trade_no` char(22) NOT NULL COMMENT '订单号',
`trade_no` varchar(50) DEFAULT NULL COMMENT '交易号',
`buyer_info` varchar(200) DEFAULT NULL COMMENT '付款人信息',
`extra` text COMMENT '额外信息',
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
`finishtime` int(10) unsigned NOT NULL COMMENT '完成时间',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`,`type`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay_trade_detail`
--
LOCK TABLES `pay_trade_detail` WRITE;
/*!40000 ALTER TABLE `pay_trade_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_trade_detail` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
导入SQL文件后，执行变更：
右键可有多种操作：
执行SQL：
点击一键诊断：
一键诊断主页如下：
完整图如下：
诊断报告可根据时间段发起诊断：
诊断完成，查看报告：
诊断报告信息：
- 实例规格
- 健康状况
- SQL优化
- 空间诊断
- 会话列表
- 慢SQL汇总
- 性能趋势图
实例诊断报告详情如下：
性能洞察：
自治中心：
在数据库自治服务中的“监控大盘”，可选择实例和指标，自定义监控大盘：
确定选择后即可看到自动生成的图表：
对象存储OSS
阿里云对象存储（Object Storage Service，简称OSS），是阿里云对外提供的海量、安全、低成本、高可靠的云存储服务。使用 OSS，您可以通过网络随时存储和调用包括文本、图片、音频和视频等在内的各种结构化或非结构化数据文件。以下的术语为OSS相关的基本概念：
- Bucket，是一个用户用来管理所存储Object的存储空间。 每个用户可以拥有多个Bucket。Bucket的名称在OSS的范围内必须是全局唯一的，一旦创建之后无法修改名称。Bucket内部的Object数目是没有限制的。
- Object，是OSS存储数据的基本单元，称为OSS的对象，也被称为OSS的文件。根据不同的上传方式，Object的大小限制是不一样的。Object由元信息（Object Meta），用户数据（Data）和文件名（Key）组成。Object由一个在Bucket内部唯一的Key来标示。Object操作在OSS上具有原子性，操作要么成功要么失败，不会存在有中间状态的Object。OSS保证用户一旦上传完成之后读到的Object是完整的，OSS不会返回给用户一个只上传成功了部分的Object。分片上传最大支持48.8TB的Object，其他的上传方式最大支持5GB。
- Region，表示OSS的数据中心所在的区域，物理位置。 一旦指定之后就不允许更改，该Bucket下所有的Object都存储在对应的数据中心。
- Endpoint，表示OSS对外服务的访问域名。OSS以HTTP REST API的形式对外提供服务，当访问不同的Region的时候，需要不同的域名。
用户可以通过调用API，在任何应用、任何时间、任何地点上传和下载数据，也可以通过阿里云Web控制台对数据进行简单的管理。目前阿里云OSS支持如下几种语言版本的SDK调用API：Python SDK，Java SDK，Android SDK，iOS SDK，JavaScript SDK，.NET SDK，PHP SDK，Ruby SDK，C SDK，Go SDK，Media-C SDK。本实验中主要介绍如何使用Python SDK调用OSS API实现文件的简单上传，下载和删除等操作。
OSS作为对象存储提供商，常用的使用场景如下：
- 适用于图片、音视频、日志等海量文件的存储，支持各种终端设备，Web网站程序和移动应用直接向OSS写入或读取数据，支持 流式写入 和 文件写入 两种方式。
- 开发者不仅可以直接使用OSS，利用BGP带宽，实现超低延时的数据直接下载；OSS也可以配合阿里云CDN加速服务，为图片、音视频、移动应用更新分发，提供最佳体验等场景。
- 上传文件到OSS后，可以配合媒体转码服务(MTS)，图片处理服务（IMG）进行云端的数据处理。
OSS对象存储主页：
创建Bucket：
数据导入包括：
使用云存储OSS的API上传和下载文件
使用ECS（OSS Python环境），OSS（文件存储服务器）资源，通过OSS的Python SDK，实现文件的上传和下载以及删除OSS Bucket。
- 查看OSS环境
对应Bucket的概览：
OSS 上传方式分为两类：简单上传和分块上传；其中，简单上传由于不支持断点续传，适合用于上传小文件；而分块上传支持断点续传，适合上传比较大的文件，一般超过100MB 的文件都推荐使用分块上传。下面将本地的小文件上传到本次上图Object路径中。
首先，ssh远程登录到OSS Python环境的ECS服务器，使用外网地址（弹性IP），用户名和密码。
使用OSS API进行文件上传和下载之前，用户需配置阿里云账号的AccessKeyID，AccessKeySecret和Endpoint信息，以便于通过 OSS 的权限验证。在 ECS 命令行中，使用命令 cd aliyun-lab 进入 aliyun-lab 目录。 然后，使用命令 vim configure.json ，configure.json 文件用于提供调用 OSS API 时所需的公共参数。
OSS 地域与外网 Endpoint 的对应关系如下表：
| 地域 | 外网Endpoint |
| 华东 1 (杭州) | oss-cn-hangzhou.aliyuncs.com |
| 华东 2 (上海) | oss-cn-shanghai.aliyuncs.com |
| 华北 1 (青岛) | oss-cn-qingdao.aliyuncs.com |
| 华北 2 (北京) | oss-cn-beijing.aliyuncs.com |
| 华南 1 (深圳) | oss-cn-shenzhen.aliyuncs.com |
- 调用OSS API上传小文件
vim object_upload.py
# -*- encoding:utf8 -*-
#Date: Fri. Feb 25th 2016
#Author: Tansy B.
import oss2
import json
import sys
__access_key = ''
__access_secret = ''
__oss_endpoint = ''
__bucket_name = '' #目标bucket名
__file_name = '' #本地文件,如果是在脚本相同的路径中，则只需填写文件名。否则，
提供完整的文件路径。
__object_name = '' #上传的object名称
if __name__ == '__main__':
#判断输入的Access Key Id, Access key secret以及endpoint是否为空。
json_data = open('configure.json','r')
cfg = json.load(json_data)
if cfg['id'] =='' or cfg['secret'] == '':
print ('Please set up your access_key, access_secret')
sys.exit(1)
if cfg['endpoint'] == '':
print('Please enter your oss endpoint')
sys.exit(1)
#从configure.json中读取如下参数值：
__access_id = cfg['id']
__access_secret = cfg['secret']
__oss_endpoint = cfg['endpoint']
json_data.close()
#获取用户输入的bucket名称，并在bucket后增加AK的ID信息，避免出现bucket重复的情况
if len(sys.argv) < 4 :
print "Missing bucket, local file or object name!\n"
print "Usage: python object_upload.py <Bucket Name> <Local File Name> <Upload Object Name>\n"
print "For example: python object_upload.py lab lab.txt lab_object.txt"
sys.exit(1)
else:
__bucket_name = sys.argv[1]
__file_name = sys.argv[2]
__object_name = sys.argv[3]
#用于鉴权并连接OSS的Service和Bucket
auth = oss2.Auth(__access_id, __access_secret)
service = oss2.Service(auth,__oss_endpoint)
bucket = oss2.Bucket(auth, __oss_endpoint, __bucket_name)
#本地文件上传到oss bucket中，并重命名
print 'Start Upload ...'
#调用OSS API的put_object()上传文件
with open(__file_name,'rb') as fileobj:
bucket.put_object(__object_name, fileobj)
print 'You have successfully upload the file:'
print '--Bucket Name:', __bucket_name, '\n--Upload File Name:', __file_name, '\n--Object Name:', __object_name
控制台中可看到已经上传成功：
- 调用OSS API下载小文件
# -*- encoding:utf8 -*-
#Date: Fri. Feb 26th 2016
#Author: Tansy B.
import oss2
import json
import sys
__access_key = ''
__access_secret = ''
__service_endpoint = ''
__bucket_name = '' #目标Bucket名
__object_name = '' #Bucket中目标object名
__local_name = '' #下载到本地的文件名
if __name__ == '__main__':
#判断输入的Access Key Id, Access key secret以及endpoint是否为空。
json_data = open('configure.json','r')
cfg = json.load(json_data)
if cfg['id'] =='' or cfg['secret'] == '':
print ('Please set up your access_key, access_secret')
sys.exit(1)
if cfg['endpoint'] == '':
print('Please enter your oss endpoint')
sys.exit(1)
#从configure.json中读取如下参数值：
__access_id = cfg['id']
__access_secret = cfg['secret']
__oss_endpoint = cfg['endpoint']
json_data.close()
#获取用户输入的bucket名称，并在bucket后增加AK的ID信息，避免出现bucket重复的情况
if len(sys.argv) < 4 :
print "Missing bucket, local file or object name!\n"
print "Usage: python object_download.py <Bucket Name> <Object Name> <File Name>\n"
print "For example: python object_download.py lab lab_object.txt lab_local.txt"
sys.exit(1)
else:
__bucket_name = sys.argv[1]
__object_name = sys.argv[2]
__local_name = sys.argv[3]
#用于鉴权并连接OSS的Service和Bucket
auth = oss2.Auth(__access_id, __access_secret)
service = oss2.Service(auth,__oss_endpoint)
bucket = oss2.Bucket(auth, __oss_endpoint, __bucket_name)
#OSS bucket中的object下载到本地，并重命名
print 'Start download the object', __object_name, 'from bucket', __bucket_name
#调用OSS API的get_object_to_file()下载object
bucket.get_object_to_file(__object_name, __local_name)
print 'You have successfully download the object from the oss.'将 OSS 存储的文件 lab_object.txt 下载到本地,并重命名为 lab_local.txt 。下载成功后，执行命令 ls ，列出当前目录下所有的文件，可以看到文件lab_local.txt 已经保存在当前目录下。
- 调用OSS API删除Object
# -*- encoding:utf8 -*-
#Date: Fri. Feb 26th 2016
#Author: Tansy B.
import oss2
import json
import sys
__access_key = ''
__access_secret = ''
__service_endpoint = ''
__bucket_name = '' #目标bucket名
__object_name = '' #删除object名
if __name__ == '__main__':
#判断输入的Access Key Id, Access key secret以及endpoint是否为空。
json_data = open('configure.json','r')
cfg = json.load(json_data)
if cfg['id'] =='' or cfg['secret'] == '':
print ('Please set up your access_key, access_secret')
sys.exit(1)
if cfg['endpoint'] == '':
print('Please enter your oss endpoint')
sys.exit(1)
#从configure.json中读取如下参数值：
__access_id = cfg['id']
__access_secret = cfg['secret']
__oss_endpoint = cfg['endpoint']
json_data.close()
#获取用户输入的bucket名称，并在bucket后增加AK的ID信息，避免出现bucket重复的情况
if len(sys.argv) < 3 :
print "Missing bucket, local file or object name!\n"
print "Usage: python object_delete.py <Bucket Name> <Object Name>\n"
print "For example: python object_delete.py lab lab_object.txt"
sys.exit(1)
else:
__bucket_name = sys.argv[1]
__object_name = sys.argv[2]
#用于鉴权并连接OSS的Service和Bucket
auth = oss2.Auth(__access_id, __access_secret)
service = oss2.Service(auth,__oss_endpoint)
bucket = oss2.Bucket(auth, __oss_endpoint, __bucket_name)
#删除OSS bucket中的object
print 'Start deleting objects in the bucket'
#调用OSS API batch_delete_objects()，批量删除objects
result = bucket.batch_delete_objects([__object_name])
print 'You successfully delete objects:'
print('\n'.join(result.deleted_keys))
控制台中可看到已删除成功：
- 创建OSS Bucket
在真实的生产工作环境中，用户在上传或者管理 OSS 中的存储文件之前，首先需要在 OSS 中创建一个 Bucket，也就是 OSS 的存储空间。
# -*- encoding:utf8 -*-
#Date: Fri. Feb 24th 2016
#Author: Tansy B.
import oss2
import json
import sys
__access_id = ''
__access_secret = ''
__oss_endpoint = ''
__bucket_name =''# 新建的bucket名
if __name__ == '__main__':
#判断输入的Access Key Id, Access key secret以及endpoint是否为空。
json_data = open('configure.json','r')
cfg = json.load(json_data)
if cfg['id'] =='' or cfg['secret'] == '':
print ('Please set up your access_key, access_secret')
sys.exit(1)
if cfg['endpoint'] == '':
print('Please enter your oss endpoint')
sys.exit(1)
#从configure.json中读取如下参数值：
__access_id = cfg['id']
__access_secret = cfg['secret']
__oss_endpoint = cfg['endpoint']
json_data.close()
#获取用户输入的bucket名称，并在bucket后增加AK的ID信息，避免出现bucket重复的情况
if len(sys.argv) == 1:
print 'Missing bucket name!\n'
print 'Usage: python bucket_create.py <Bucket Name>\n'
print 'For example: python bucket_create.py lab\nlab is a new oss bucket name'
sys.exit(1)
else:
__bucket_name = sys.argv[1] + '-' + __access_id.lower()
#用于鉴权并连接OSS的Service和Bucket
auth = oss2.Auth(__access_id, __access_secret)
service = oss2.Service(auth,__oss_endpoint)
bucket = oss2.Bucket(auth, __oss_endpoint, __bucket_name)
#创建一个新的bucket
print 'Start Creating a bucket'
#调用OSS API的create_bucket()创建bucket
result = bucket.create_bucket()
print 'Your bucket Create Successfully'
print 'Your new bucket is: ', __bucket_name可通过以上API的形式，也可以通过以下控制台管理界面的形式，创建Bucket，上传文件，下载文件，复制Object URL，查看Object文件，删除Object文件，删除OSS Bucket等。
使用OSS管理控制台上传文件
还可设置权限管理等：
阿里云云盾（云安全）
DDoS防护包
- Web应用防火墙
- 安骑士
- 安全管家
- 云安全中心
- 云监控
RAM访问控制
SDK开发
| IDE + Cloud Toolkit + Docker | https://help.aliyun.com/document_detail/98762.html https://tianchi.aliyun.com/competition/entrance/231759/tab/174 |
| 阿里云容器镜像服务（仓库、命名空间） | |
| Docker Command
| docker login --username=beth registry.cn-shanghai.aliyuncs.com
docker pull registry.cn-shanghai.aliyuncs.com/bethchen/test_for_tianchi:1.0
docker run --rm -it --net host -e "SERVER_PORT=8000" --name "clientprocess1" -d registry.cn-shanghai.aliyuncs.com/bethchen/test_for_tianchi:1.0 docker run --rm -it --net host -e "SERVER_PORT=8001" --name "clientprocess2" -d registry.cn-shanghai.aliyuncs.com/bethchen/test_for_tianchi:1.0 docker run --rm -it --net host -e "SERVER_PORT=8002" --name "backendprocess" -d registry.cn-shanghai.aliyuncs.com/bethchen/test_for_tianchi:1.0
docker pull registry.cn-hangzhou.aliyuncs.com/cloud_native_match/scoring:0.1 docker run --rm --net host -e "SERVER_PORT=8081" --name scoring -d registry.cn-hangzhou.aliyuncs.com/cloud_native_match/scoring:0.1
docker ps
docker log --follow <container-id> |
IDE + Cloud Toolkit
推荐使用 Alibaba Cloud Toolkit 进行操作。Cloud Toolkit 与主流 IDE 及阿里云容器镜像服务无缝集成，可以简化操作。 这里以在 IntelliJ IDEA 中使用 Alibaba Cloud Toolkit 为例。只需配置一次，之后都可一键推送～
- 在本地 IDE 中安装 Alibaba Cloud Toolkit 并进行阿里云账户配置。参见：
在 IntelliJ IDEA 中安装和配置 Cloud Toolkit - 设置用于打包本地镜像的 Docker 环境。
- 在 IntelliJ IDEA 工具栏单击 Tools > Alibaba Cloud > Preferences… 。
- 在 Settings 对话框的左侧导航栏中单击 Docker。
- 在 Docker 界面中设置 Cloud Toolkit 需要连接的 Docker 环境。
- 本地为 Mac 或 Linux 操作系统，勾选 Unix Socket，然后单击 Browse，输入unix:///var/run/docker.sock。
- 本地为 Windows 操作系统，勾选 TCP Connection，然后在 URI 右侧文档框输入本地 Docker 的 URI，如 http://127.0.0.1:2375。
- 远程 Docker 环境：勾选 Tcp Connection，在 URI 右侧的文本框里输入远端的 Docker 环境的 URI（包括 IP 地址和端口），如 http://x.x.x.x:2375，并确保远程主机的 HTTP 服务开启。
- 单击 Test Connection 进行连接测试。
注意：如果出现连接测试报错，可进入 Docker 的 Settings 界面，单击左侧导航栏中的 General，然后选择 Expose daemon on tcp://localhost:2375 without TLS。
构建并上传应用
- 在 IntelliJ IDEA 的菜单栏中选择 File > Open… ，选择参赛的工程文件。
- 在 IntelliJ IDEA 界面左侧的 Project 中右键单击您的 Docker 应用工程名，在弹出的下拉菜单中选择 Alibaba Cloud > Deploy to Registry
- 在 Deploy to Registry对话框中进行以下配置。
- 在 Image 页签中选择 Context Directory 和 Dockerfile。
- Context Directory：参赛的工程文件所在的目录，例如上文中的 tianchi 。
- Dockerfile：选择上文中创建的 Dockerfile。
- Version：对上传的工程文件做版本标记。例如 1.0
- 在 Image Repositories 区域选择上文中创建的容器镜像服务的地域、命名空间和镜像仓库。
- 单击RUN
IDE + Cloud Toolkit的截图：
容器镜像服务：
Push镜像成功：
E-MapReduce
扫一扫
6156
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
