[Slashcode-general] Problem with install slash site

[Leoncini X. <xa...@ny...>]

Hello,
I have the following problem when trying to install a new slash system with
cvs T_2_5_0_95 same with 96
I use mysql 5
The script fails at the following command saying my vuser lacks drop and
create privileges


CREATE TABLE moderatorlog (     id int UNSIGNED NOT NULL auto_increment,
ipid char(32) DEFAULT '' NOT NULL,      subnetid char(32) DEFAULT '' NOT
NULL,        uid mediumint UNSIGNED NOT NULL,        val tinyint DEFAULT '0'
NOT NULL,       sid mediumint UNSIGNED DEFAULT '' NOT NULL,   ts datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,     cid mediumint UNSIGNED NOT NULL,
cuid mediumint UNSIGNED NOT NULL,       reason tinyint UNSIGNED DEFAULT '0',
active tinyint DEFAULT '1' NOT NULL,    spent tinyint DEFAULT '1' NOT NULL,
m2count mediumint UNSIGNED DEFAULT '0' NOT NULL,      m2needed mediumint
UNSIGNED DEFAULT '0' NOT NULL,       m2status tinyint DEFAULT '0' NOT NULL,
points_orig tinyint DEFAULT NULL,    PRIMARY KEY (id),        KEY sid
(sid,cid),      KEY sid_2 (sid,uid,cid),        KEY cid (cid),  KEY ipid
(ipid),        KEY subnetid (subnetid),     KEY uid (uid),   KEY cuid (cuid),
KEY m2stat_act (m2status,active),       KEY ts_uid_sid (ts,uid,sid))
TYPE=InnoDB

When typed directly in the mysql prompt the error is:

ERROR 1067 (42000): Invalid default value for 'sid'

If I put '0' instead of '' then the command passes. I however do not know
which default value is best to put.
Thanks in advance
Xavier