数据库问题

Question

老师，我下载了项目之后发现并没有数据的sql文件，能不能发一份呢？

Answer 1

skyding 2018-08-07 09:09:26

CREATE DATABASE /*!32312 IF NOT EXISTS*/`manager` /*!40100 DEFAULT CHARACTER SET latin1 */;   

USE `manager`;    

CREATE TABLE `product` (    

`id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '产品编号',    

`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '产品名称',    

`threshold_amount` decimal(15,3) NOT NULL COMMENT '起投金额',    

`step_amount` decimal(15,3) NOT NULL COMMENT '投资步长',    

`lock_term` smallint(6) NOT NULL COMMENT '锁定期',    

`reward_rate` decimal(5,3) NOT NULL COMMENT '收益率,0-100 百分比值',    

`status` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '状态,AUDINTING:审核中,IN_SELL:销售中,LOCKED:暂停销售,FINISHED:已结束',    

`memo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',    

`create_at` datetime DEFAULT NULL COMMENT '创建时间',    

`create_user` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建者',    

`update_at` datetime DEFAULT NULL COMMENT '更新时间',    

`update_user` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '更新者',    

PRIMARY KEY (`id`)    

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;    

CREATE TABLE `order_t` (    

`order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单编号',    

`chan_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道编号',    

`product_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '产品编号',    

`chan_user_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道用户编号',    

`order_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '类型,APPLY:申购,REDEEM:赎回',    

`order_status` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '状态,INIT:初始化,PROCESS:处理中,SUCESS:成功,FAIL:失败',    

`outer_order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '外部订单编号',    

`amount` decimal(15,3) NOT NULL COMMENT '金额',    

`memo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',    

`create_at` datetime DEFAULT NULL COMMENT '创建时间',    

`update_at` datetime DEFAULT NULL COMMENT '更新时间',    

PRIMARY KEY (`order_id`)    

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;    

CREATE DATABASE /*!32312 IF NOT EXISTS*/`seller-backup` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;    

USE `seller-backup`;    

/*Table structure for table `order_t` */    

DROP TABLE IF EXISTS `order_t`;    

CREATE TABLE `order_t` (    

`order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单编号',    

`chan_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道编号',    

`product_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '产品编号',    

`chan_user_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道用户编号',    

`order_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '类型,APPLY:申购,REDEEM:赎回',    

`order_status` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '状态,INIT:初始化,PROCESS:处理中,SUCESS:成功,FAIL:失败',    

`outer_order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '外部订单编号',    

`amount` decimal(15,3) NOT NULL COMMENT '金额',    

`memo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',    

`create_at` datetime DEFAULT NULL COMMENT '创建时间',    

`update_at` datetime DEFAULT NULL COMMENT '更新时间',    

PRIMARY KEY (`order_id`)    

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;    

/*Table structure for table `verification_order` */    

DROP TABLE IF EXISTS `verification_order`;    

CREATE TABLE `verification_order` (    

`order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单编号',    

`chan_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道编号',    

`product_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '产品编号',    

`chan_user_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '渠道用户编号',    

`order_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '类型,APPLY:申购,REDEEM:赎回',    

`outer_order_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '外部订单编号',    

`amount` decimal(15,3) NOT NULL COMMENT '金额',    

`create_at` datetime DEFAULT NULL COMMENT '创建时间',    

PRIMARY KEY (`order_id`)    

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;    

• 提问者 tidhy #1

  非常感谢！