2023-11-19 18:40:54 [CORE] Plugin activation: updating DB
2023-11-19 18:40:54 [DB] Called updateDB()
2023-11-19 18:40:54 [DB] checkDBTable() for "docs"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_docs` (
`id` int(11) NOT NULL auto_increment,
`index_id` int(11) NOT NULL default '0',
`token` varchar(255) NOT NULL,
`n` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `token` (`token`(190)),
KEY `index_id` (`index_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "index"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`tid` bigint(10) unsigned NOT NULL,
`tsrc` varchar(255) NOT NULL,
`tdt` datetime NOT NULL default '1970-01-01 00:00:00',
`build_time` int(11) NOT NULL default '0',
`update_dt` datetime NOT NULL default '1970-01-01 00:00:00',
`force_rebuild` tinyint(4) NOT NULL default '0',
`locked_dt` datetime NOT NULL default '1970-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `tid_tsrc_unique` (`tid`,`tsrc`(100)),
KEY `tid` (`tid`),
KEY `build_time` (`build_time`),
KEY `force_rebuild` (`force_rebuild`),
KEY `locked_dt` (`locked_dt`),
KEY `tsrc` (`tsrc`(100))
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "stops"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_stops` (
`id` int(10) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `word` (`word`(190))
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "vectors"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_vectors` (
`wid` int(11) NOT NULL,
`did` int(11) NOT NULL,
`wn` int(11) NOT NULL default '0',
UNIQUE KEY `did_wn` (`did`,`wn`),
KEY `wid` (`wid`),
KEY `did` (`did`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "words"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_words` (
`id` int(11) NOT NULL auto_increment,
`word` varchar(255) NOT NULL,
`act` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`),
UNIQUE KEY `word` (`word`(190)),
KEY `act` (`act`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "tw"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_tw` (
`id` int(11) NOT NULL auto_increment,
`w` varchar(255) NOT NULL,
`did` int(11) NOT NULL default '0',
`wn` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `w` (`w`(190))
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "vc"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_vc` (
`id` int(11) NOT NULL auto_increment,
`wid` int(11) NOT NULL default '0',
`upd_dt` datetime NOT NULL default '1970-01-01 00:00:00',
`vc` longblob NULL,
PRIMARY KEY (`id`),
KEY `wid` (`wid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "tp"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_tp` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`q_id` int(11) NOT NULL default '0',
`did` int(11) NOT NULL default '0',
`pow` int(11) NOT NULL default '0',
`res` float(10,6) NOT NULL default '0',
`ts` timestamp NOT NULL default '1970-01-02 00:00:00',
PRIMARY KEY (`id`),
KEY `did` (`did`),
KEY `q_id` (`q_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "qlog"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_qlog` (
`id` int(11) NOT NULL auto_increment,
`query` longtext NULL,
`query_type` varchar(255) NOT NULL default '',
`preset` varchar(255) NOT NULL default '',
`widget_name` varchar(255) NOT NULL default '',
`n_results` int(11) NOT NULL default '0',
`q_time` float(10,6) NOT NULL default '0',
`max_ram` bigint(20) NOT NULL default '0',
`user_id` bigint(20) NOT NULL default '0',
`req_ip` varchar(40) NOT NULL default '',
`ref_url` text NULL,
`insert_dt` datetime NOT NULL default '1970-01-01 00:00:00',
`wpq_params` longtext NULL,
`ext` longtext NULL,
PRIMARY KEY (`id`),
KEY `query_type` (`query_type`),
KEY `preset` (`preset`),
KEY `widget_name` (`widget_name`),
KEY `req_ip` (`req_ip`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "map"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_map` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`post_id` bigint(20) unsigned NOT NULL default '0',
`obj_id` bigint(20) unsigned NOT NULL default '0',
`obj_type` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `post_id` (`post_id`),
UNIQUE KEY `obj_id` (`obj_id`,`obj_type`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "queue"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_queue` (
`id` bigint(20) unsigned NOT NULL,
`post_id` bigint(20) unsigned NOT NULL default '0',
`remark` varchar(255) NOT NULL default '',
`insert_dt` datetime NOT NULL default '1970-01-01 00:00:00',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "rawcache"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_rawcache` (
`id` int(10) unsigned NOT NULL auto_increment,
`object_id` bigint(20) NOT NULL default '0',
`object_type` varchar(150) NULL,
`cached_dt` datetime NULL,
`insert_dt` datetime NULL,
`method_id` varchar(150) NULL default '',
`data` longtext NULL,
`error` text NULL,
`filename` text NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `object_id_and_type` (`object_id`,`object_type`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] checkDBTable() for "ilog"
2023-11-19 18:40:54 [DB] The table does not exist, create new: CREATE TABLE `wpftsi_ilog` (
`id` int(10) unsigned NOT NULL auto_increment,
`index_id` int(10) unsigned NOT NULL default '0',
`start_ts` double(18,6) NOT NULL default '0.000000',
`getpost_ts` double(18,6) NOT NULL default '0.000000',
`clusters_ts` double(18,6) NOT NULL default '0.000000',
`cluster_stats` longtext NULL,
`reindex_ts` double(18,6) NOT NULL default '0.000000',
`status` int(11) NOT NULL default '0',
`error` longtext NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_id` (`index_id`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
2023-11-19 18:40:54 [DB] Last error: 
2023-11-19 18:40:54 [DB] updateDB() result: OK
2023-11-19 18:40:54 [CORE] Version updates: Array
(
    [is_new] => 1
    [is_rebuild] => 1
    [text] => Array
        (
            [0] => <b style="color: red;">Congratulations!</b> <b>WP Fast Total Search plugin</b> has just been installed and successfully activated!<br><br>To complete the installation, we need to create the Search Index of your existing WP posts data. To start this process, simply go to the <a href="admin.php?page=wpfts-options">WPFTS Settings Page</a>
        )

)

2023-11-19 18:40:54 [CORE] Plugin activation completed
2023-11-19 18:44:07 [CORE] Plugin deactivation