|
L
larsonsc author
I have a table in my DB (the DDL is below) and in this table I have 5 decimal fields created with a size of 3 and a precision of 1. However, when I view the table, these fields are still being shown as 4 digits with a precision of 2 and the values are being rounded. I'm pretty sure this is something I have set wrong, but I can't quite seem to figure out what else to adjust. Advice?
CREATE TABLE `_courses` (
`CourseID` int(11) NOT NULL auto_increment,
`CourseName` varchar(50) NOT NULL,
`9Hole` varchar(3) NOT NULL,
`CreatedByPHPRunner` int(11) default NULL,
`BluePar` tinyint(4) default NULL,
`WhitePar` tinyint(4) default NULL,
`GoldPar` tinyint(4) default NULL,
`RedPar` tinyint(4) default NULL,
`BlackPar` tinyint(4) default NULL,
`BlueSlope` tinyint(4) default NULL,
`BlueRating` decimal(3,1) default NULL,
`WhiteSlope` tinyint(4) default NULL,
`WhiteRating` decimal(3,1) default NULL,
`GoldSlope` tinyint(4) default NULL,
`GoldRating` decimal(3,1) default NULL,
`RedSlope` tinyint(4) default NULL,
`RedRating` decimal(3,1) default NULL,
`BlackSlope` tinyint(4) default NULL,
`BlackRating` decimal(3,1) default NULL,
`OwnerID` tinyint(4) default NULL,
`Address` varchar(50) default NULL,
`City` varchar(50) default NULL,
`State` varchar(2) default NULL,
`Phone` varchar(50) default NULL,
`URL` varchar(75) default NULL,
`DateUpdated` date default NULL,
`Fairways` tinyint(4) default NULL,
`CourseNotes` varchar(200) default NULL,
PRIMARY KEY (`CourseID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; |
|