SNAP for WordPress Tables

SNAP adds two tables to the WordPress Database. It should create those tables automatically during the activation. In case your site has overprotective security and WordPress does not allow to create tables, please use this SQL code to create them manually:

CREATE TABLE wp_nxs_log (
id mediumint(9) NOT NULL AUTO_INCREMENT,
date datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
act VARCHAR(255) DEFAULT '' NOT NULL,
nt VARCHAR(255) DEFAULT '' NOT NULL,
type VARCHAR(255) DEFAULT '' NOT NULL,
msg text NOT NULL,
extInfo text NOT NULL,
UNIQUE KEY id (id)
);

CREATE TABLE wp_nxs_query(
id mediumint(9) NOT NULL AUTO_INCREMENT,
datecreated datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
type VARCHAR(55) DEFAULT '' NOT NULL,
postid mediumint(9) NULL,
nttype VARCHAR(55) NULL,
timetorun datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
refid mediumint(9) NULL,
descr VARCHAR(255) NULL,
extInfo text NULL,
UNIQUE KEY id (id)
);

Please note that if are using some other prefix than default “wp_”, please adjust tables names wp_nxs_query and wp_nxs_log accordingly.