Why Is Pk Defined As 'int(11) Not Null Auto_Increment Primary Key'?

Yii 1.1 General Discussion
1

Why is pk defined as ‘int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY’?

Shouldn’t it be an unsigned int?

Like

‘INT UNSIGNED AUTO_INCREMENT PRIMARY KEY’

yii/framework/db/schema/mysql/CMysqlSchema.php line 25

2

Hi

Int(11) takes 4 bytes, exactly the size of integers that 32bit PHP can manipulates

3

Thanks for the info.