id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
sid VARCHAR(32) NOT NULL DEFAULT '',
ip VARCHAR(15) NOT NULL DEFAULT '',
-userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
-refid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+refid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
module VARCHAR(255) NOT NULL DEFAULT '',
action VARCHAR(255) NOT NULL DEFAULT '',
what VARCHAR(255) NOT NULL DEFAULT '',
is_admin ENUM('Y','N') NOT NULL DEFAULT 'N',
is_member ENUM('Y','N') NOT NULL DEFAULT 'N',
-timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+timestamp VARCHAR(10) NOT NULL DEFAULT 0,
PRIMARY KEY(id),
KEY(userid),
KEY(refid)