search

robmaceachern / cpsc304

Our sweet 304 project
1 stars 1 forks source link

Remove the (9) in int(9) #6

Closed robmaceachern closed 12 years ago

robmaceachern commented 12 years ago

The int(9) stuff doesn't seem to be necessary. Unless there is a reason for keeping it, let's get rid of it.

source: http://matthom.com/archive/2006/11/28/mysql-integer-columns-and-display-width and http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

rc9 commented 12 years ago

makes sense. I don't understand why they even put the count then...I guess just to know for fill zero.

rc9 commented 12 years ago

So I've removed all the () for ints. I also put in a constraint that book.year be between 1000-9999.