Like in subject.
I think CREATE TABLE nuke_users should looks like this or maybe there should be something more.
This one works good.
CREATE TABLE nuke_users (
pn_uid INTEGER NOT NULL IDENTITY,
pn_uname VARCHAR(25) NOT NULL,
pn_user_regdate TIMESTAMP,
pn_user_viewemail BIT,
pn_name VARCHAR(60) DEFAULT '' NOT NULL,
pn_email VARCHAR(60) DEFAULT '' NOT NULL,
pn_femail VARCHAR(60) DEFAULT '' NOT NULL,
pn_url VARCHAR(254) DEFAULT '' NOT NULL,
pn_timezone_offset INTEGER DEFAULT '0' NOT NULL,
pn_user_avatar VARCHAR(30) DEFAULT 'blank.gif' NOT NULL,
pn_user_icq VARCHAR(15) DEFAULT '' NOT NULL,
pn_user_aim VARCHAR(18) DEFAULT '' NOT NULL,
pn_user_yim VARCHAR(25) DEFAULT '' NOT NULL,
pn_user_msnm VARCHAR(25) DEFAULT '' NOT NULL,
pn_user_from VARCHAR(100) DEFAULT '' NOT NULL,
pn_user_lang INTEGER DEFAULT '0' NOT NULL,
pn_user_occ VARCHAR(100) DEFAULT '' NOT NULL,
pn_user_intrest VARCHAR(150) DEFAULT '' NOT NULL,
pn_user_sig VARCHAR(255) DEFAULT '' NOT NULL,
pn_bio VARCHAR DEFAULT '' NOT NULL,
pn_pass VARCHAR(40) DEFAULT '' NOT NULL,
pn_theme VARCHAR(255) DEFAULT '' NOT NULL,
pn_storynum INTEGER DEFAULT '10' NOT NULL,
pn_ublockon BIT,
pn_ublock VARCHAR DEFAULT '' NOT NULL,
pn_umode VARCHAR(10) DEFAULT '' NOT NULL,
pn_uorder INTEGER DEFAULT '0' NOT NULL,
pn_thold INTEGER DEFAULT '0' NOT NULL,
pn_noscore BIT,
pn_prev_last_visit TIMESTAMP ,
pn_last_visit TIMESTAMP ,
pn_commentmax INTEGER DEFAULT '4096' NOT NULL
);
