保留一位小数
保留两位小数
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;