// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_online";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_online (
-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) 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',
PRIMARY KEY(id),
KEY(userid),
KEY(refid)