float、double字段类型建表

 保留一位小数

保留两位小数

USE `communitydb`;


DROP TABLE IF EXISTS `t_comm_service_farmmaterial_plan`;

CREATE TABLE `t_comm_service_farmmaterial_plan` (
  `dataid` varchar(100) COLLATE utf8_bin NOT NULL,
  `title` varchar(100) COLLATE utf8_bin NOT NULL,
  `descp` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `materialtype` int(11) NOT NULL DEFAULT '0',
  `materialname` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `planstate` int(11) DEFAULT '0',
  `planvolume` double(14,2) DEFAULT '0.00',
  `volumeunit` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `begindate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  `makeorg` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `makeorgid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `makeperson` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `makepersonid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `maketime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `projectid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `remark` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`dataid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;