/* Navicat MySQL Data Transfer Source Server : ipu测试-121.42.183.206 Source Server Version : 50625 Source Host : 121.42.183.206:3307 Source Database : test Target Server Type : MYSQL Target Server Version : 50625 File Encoding : 65001 Date: 2019-03-03 00:08:09 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for ipu_db_demo -- ---------------------------- DROP TABLE IF EXISTS `ipu_db_demo`; CREATE TABLE `ipu_db_demo` ( `pk` int(255) NOT NULL COMMENT '主键', `string_type` varchar(255) NOT NULL COMMENT '字符串字段', `int_type` int(255) NOT NULL COMMENT '整型字段', `decimal_type` decimal(4,2) NOT NULL COMMENT '小数值字段', `date_type` date NOT NULL COMMENT '日期字段', `datetime_type` datetime NOT NULL COMMENT '日期时间字段', PRIMARY KEY (`pk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;