Minilogin_ip Default Error

[takatok]

NOTE: I'm VERY new to SQL.

When setting up my server I got the following error:

Account Attempting to be created: qwertylicious 0
Error in CreateAccount query'INSERT INTO accountSET name='qwertylicious',status=0,lsaccountid=110177;' #1364: Field 'minilogin_ip' doesn't have a default value

After searching the forums for similiar problems I found 10-15 people with the same problem and everyone assuming they were trying to use minilogin (they weren't)

I fixed the problem by doing this in the dbase

mysql>alter table account alter column minilogin_ip set default 0

Anyway, the SVN checkout of PEQ_DB has this problem i think:
In account.sql Line 40

REPLACE
`minilogin_ip` varchar(32) NOT NULL,
WITH
`minilogin_ip` varchar(32) NOT NULL DEFAULT 0,

Hope this helps solve the problem

Tony