 
 /*Data for the table `p2p_project_apply` */
 
+/*Table structure for table `p2p_project_collect` */
+
+DROP TABLE IF EXISTS `p2p_project_collect`;
+
+CREATE TABLE `p2p_project_collect` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `porder` tinyint(4) NOT NULL COMMENT '待收期数',
+  `status` tinyint(4) NOT NULL COMMENT '0未收1已还款2待还',
+  `projectId` bigint(18) NOT NULL COMMENT '项目id',
+  `orderId` int(10) NOT NULL COMMENT '投标id',
+  `repaytime` int(11) DEFAULT NULL COMMENT '应收日期',
+  `repayyestime` int(11) DEFAULT NULL COMMENT '实收日期',
+  `repayaccount` int(11) DEFAULT NULL COMMENT '应收金额',
+  `repayyesaccount` int(11) NOT NULL COMMENT '实收金额',
+  `interest` int(11) NOT NULL COMMENT '应收利息',
+  `capital` int(11) NOT NULL COMMENT '应收本金',
+  `latedays` smallint(11) DEFAULT '0' COMMENT '逾期天数',
+  `lateinterest` int(11) NOT NULL COMMENT '逾期罚息',
+  `addtime` int(11) NOT NULL COMMENT '添加时间',
+  `addip` varchar(15) NOT NULL COMMENT '添加IP',
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='代收表';
+
+/*Data for the table `p2p_project_collect` */
+
 /*Table structure for table `p2p_project_order` */
 
 DROP TABLE IF EXISTS `p2p_project_order`;
 
 CREATE TABLE `p2p_project_order` (
-  `oid` bigint(18) NOT NULL,
-  `userId` bigint(18) DEFAULT NULL,
+  `oid` int(18) unsigned NOT NULL AUTO_INCREMENT,
+  `userId` int(18) DEFAULT NULL,
   `status` int(11) NOT NULL COMMENT '1全部通过 2部分通过',
   `projectId` bigint(18) NOT NULL COMMENT '标id',
   `money` int(11) NOT NULL DEFAULT '0' COMMENT '投标金额',

  `invitenum` int(11) DEFAULT '0' COMMENT '邀请人数',
  PRIMARY KEY (`userId`),
  KEY `i_username` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `p2p_user` */

/*Table structure for table `p2p_userinfo` */


) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章目录表';

/*Data for the table `p2p_articlecat` */

/*Table structure for table `p2p_code` */

DROP TABLE IF EXISTS `p2p_code`;

CREATE TABLE `p2p_code` (
  `codeId` int(10) unsigned NOT NULL COMMENT '验证码编号',
  `senceId` tinyint(10) unsigned DEFAULT NULL COMMENT '使用场景',
  `target` varchar(32) NOT NULL COMMENT '用户手机',
  `code` varchar(6) NOT NULL COMMENT '验证码',
  `status` tinyint(1) unsigned NOT NULL COMMENT '状态（0，未使用；1，已使用）',
  `addtime` int(10) unsigned NOT NULL COMMENT '验证码加入时间',
  `exctime` int(10) unsigned DEFAULT NULL COMMENT '过期时间',
  `error_num` tinyint(1) unsigned DEFAULT NULL COMMENT '失败次数',
  `addip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`codeId`),
  KEY `userphone` (`target`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='验证码表，便于接收不到查询';

/*Data for the table `p2p_code` */

/*Table structure for table `p2p_project` */

