-id bigint(20) NOT NULL auto_increment,
-sid varchar(32) NOT NULL default '',
-ip varchar(15) NOT NULL default '',
-userid bigint(20) NOT NULL default '0',
-refid bigint(20) 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',
+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,
+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,