|
/*
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;
|