<NME> apy_account.sql
<BEF> 
/*Table structure for table `apy_account` */

DROP TABLE IF EXISTS `pay_account`;

CREATE TABLE `pay_account` (
  `pay_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '支付账号id',
  `partner` VARCHAR(32) DEFAULT NULL COMMENT '支付合作id,商户id，差不多是支付平台的账号或id',
  `app_Id` VARCHAR(32) DEFAULT NULL COMMENT '应用id',
  `public_key` VARCHAR(1204) DEFAULT NULL COMMENT '支付平台公钥(签名校验使用)，sign_type只有单一key时public_key与private_key相等，比如sign_type=MD5(友店支付除外)的情况',
  `private_key` VARCHAR(2048) DEFAULT NULL COMMENT '应用私钥(生成签名)',
  `notify_url` VARCHAR(1024) DEFAULT NULL COMMENT '异步回调地址',
  `return_url` VARCHAR(1024) DEFAULT NULL COMMENT '同步回调地址',
  `seller` VARCHAR(256) DEFAULT NULL COMMENT '收款账号, 针对支付宝',
  `sign_type` VARCHAR(16) DEFAULT NULL COMMENT '签名类型',
  `input_charset` VARCHAR(16) DEFAULT NULL COMMENT '枚举值，字符编码 utf-8,gbk等等',
  `pay_type` CHAR(16) DEFAULT NULL COMMENT '支付类型,aliPay：支付宝，wxPay：微信, youdianPay: 友店微信,此处开发者自定义对应com.egzosn.pay.demo.entity.PayType枚举值',
  `msg_type` CHAR(8) DEFAULT NULL COMMENT '消息类型，text,xml,json',
  `keystore_path` VARCHAR(256) DEFAULT NULL COMMENT '请求证书地址，请使用绝对路径',
  `store_password` VARCHAR(256) DEFAULT NULL COMMENT '证书对应的密码',
  `is_test` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否为测试环境',
  PRIMARY KEY (`pay_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

/*Data for the table `apy_account` */

insert  into `apy_account`(`pay_id`,`partner`,`appid`,`public_key`,`private_key`,`notify_url`,`return_url`,`seller`,`sign_type`,`input_charset`,`pay_type`,`msg_type`,`create_by`,`create_time`) values
(1,'12******01','wxa**********ba9e9','48gf0iwuhr***********r9weh9eiut9','48gf0iwuhr***********r9weh9eiut9','http://pay.egzosn.com/payBack2.json','同步回调地址','','MD5','utf-8','wxPay','xml','egan','2017-01-20 17:07:48'),
(2,'20889119449*****','','MIGfMA0GCSqGSIb3DQEB*********gmLCUYuLkxpLQIDAQAB','IqZg51Vx8BvyypnIfKgw=*********MIICdwIBADANBgkqhkiG9w0BAQE','http://pay.egzosn.com/payBack3.json','同步回调地址','egzosn@gmail.com','RSA','utf-8','aliPay','text','egan','2017-01-20 17:11:46'),



) ENGINE=INNODB DEFAULT CHARSET=utf8;


<MSG> 移除sql 插入案例

<DFF> @@ -22,11 +22,3 @@ CREATE TABLE `pay_account` (
   PRIMARY KEY (`pay_id`)
 ) ENGINE=INNODB DEFAULT CHARSET=utf8;
 
-/*Data for the table `apy_account` */
-
-insert  into `apy_account`(`pay_id`,`partner`,`appid`,`public_key`,`private_key`,`notify_url`,`return_url`,`seller`,`sign_type`,`input_charset`,`pay_type`,`msg_type`,`create_by`,`create_time`) values
-(1,'12******01','wxa**********ba9e9','48gf0iwuhr***********r9weh9eiut9','48gf0iwuhr***********r9weh9eiut9','http://pay.egzosn.com/payBack2.json','同步回调地址','','MD5','utf-8','wxPay','xml','egan','2017-01-20 17:07:48'),
-(2,'20889119449*****','','MIGfMA0GCSqGSIb3DQEB*********gmLCUYuLkxpLQIDAQAB','IqZg51Vx8BvyypnIfKgw=*********MIICdwIBADANBgkqhkiG9w0BAQE','http://pay.egzosn.com/payBack3.json','同步回调地址','egzosn@gmail.com','RSA','utf-8','aliPay','text','egan','2017-01-20 17:11:46'),
-
-
-

移除sql 插入案例