#25 MySql 3.23 still a common version

[Anonymous]

For example, if you are using RHEL3 or CentOS 3. I
know, I know, I should be moving to 4, but plenty of
people still use 3 and it still is being supported
(3.5, 3.6 and 3.7 are recent updates).

I still have to test sub-selects and unions to see how
I change them, but perhaps the following should be
fixed anyway. It doesn't hurt to make the PKs more
explicit. Using mysql-3.23.58-16.RHEL3.1.i386 and the
03/27/06 version of socialclub.

Dropping tables...
Creating tables...
ERROR 1171 at line 86: All parts of a PRIMARY KEY must
be NOT NULL; If you need NULL in a key, use UNIQUE
instead (table _action)

Dropping tables...
Creating tables...
ERROR 1171 at line 1016: All parts of a PRIMARY KEY
must be NOT NULL; If you need NULL in a key, use
UNIQUE instead (table _table)

Dropping tables...
Creating tables...
Inserting initial data...
Inserting privileges...
ERROR 1171 at line 3: All parts of a PRIMARY KEY must
be NOT NULL; If you need NULL in a key, use UNIQUE
instead (table _privileges)

After adding all the necessary NOT NULLs, setup works.