[phpslash-users] optimizing the DB.

[Ajay S. <ss...@od...>]

I'm not a database/mysql expert but I can get around.  I need some help
in cleaning up the database from the old 0.5x and making sure that NO
MORE CHANGES are going to be done for 0.6.  (There will be additions and
modifications when 0.65 comes out because of the new poll script).

This is all coming about because I looked in the psl_topic table and
noticed that topic_id was a "varchar(32)".  This was left over from the
days that we were going to use MD5 id's.  I went through and changed all
the "id" fields to int(11), but what's the range on an int(11)?
Shouldn't we change all the id fields to unsigned because we should
NEVER have a negative id number.  

later,
ajay

----------------------------------------------------------------
Satyajot (Ajay) Sharma 
ss...@od...
Digital Odyssey System Administrator
WWJMD - What would Jim Morrison do.
----------------------------------------------------------------