/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpjh_wpdatatables`; */
/* PRE_TABLE_NAME: `1689681854_wpjh_wpdatatables`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1689681854_wpjh_wpdatatables` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `show_title` tinyint(1) NOT NULL DEFAULT '1', `table_type` varchar(55) NOT NULL, `content` text NOT NULL, `filtering` tinyint(1) NOT NULL DEFAULT '1', `filtering_form` tinyint(1) NOT NULL DEFAULT '0', `sorting` tinyint(1) NOT NULL DEFAULT '1', `tools` tinyint(1) NOT NULL DEFAULT '1', `server_side` tinyint(1) NOT NULL DEFAULT '0', `editable` tinyint(1) NOT NULL DEFAULT '0', `inline_editing` tinyint(1) NOT NULL DEFAULT '0', `popover_tools` tinyint(1) NOT NULL DEFAULT '0', `editor_roles` varchar(255) NOT NULL DEFAULT '', `mysql_table_name` varchar(255) NOT NULL DEFAULT '', `edit_only_own_rows` tinyint(1) NOT NULL DEFAULT '0', `userid_column_id` int(11) NOT NULL DEFAULT '0', `display_length` int(3) NOT NULL DEFAULT '10', `auto_refresh` int(3) NOT NULL DEFAULT '0', `fixed_columns` tinyint(1) NOT NULL DEFAULT '-1', `fixed_layout` tinyint(1) NOT NULL DEFAULT '0', `responsive` tinyint(1) NOT NULL DEFAULT '0', `scrollable` tinyint(1) NOT NULL DEFAULT '0', `word_wrap` tinyint(1) NOT NULL DEFAULT '0', `hide_before_load` tinyint(1) NOT NULL DEFAULT '0', `var1` varchar(255) NOT NULL DEFAULT '', `var2` varchar(255) NOT NULL DEFAULT '', `var3` varchar(255) NOT NULL DEFAULT '', `tabletools_config` varchar(255) NOT NULL DEFAULT '', `advanced_settings` text NOT NULL, `cache_source_data` tinyint(1) NOT NULL DEFAULT '0', `auto_update_cache` tinyint(1) NOT NULL DEFAULT '0', `file_location` varchar(15) NOT NULL DEFAULT '', UNIQUE KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `1689681854_wpjh_wpdatatables` (`id`, `title`, `show_title`, `table_type`, `content`, `filtering`, `filtering_form`, `sorting`, `tools`, `server_side`, `editable`, `inline_editing`, `popover_tools`, `editor_roles`, `mysql_table_name`, `edit_only_own_rows`, `userid_column_id`, `display_length`, `auto_refresh`, `fixed_columns`, `fixed_layout`, `responsive`, `scrollable`, `word_wrap`, `hide_before_load`, `var1`, `var2`, `var3`, `tabletools_config`, `advanced_settings`, `cache_source_data`, `auto_update_cache`, `file_location`) VALUES (2,'LIST OF SOME FEDERAL AND STATE MINISTRIES, DEPARTMENT AND AGENCIES WE HAVE WORKED WITH IN THE PAST YEARS',1,'csv','/home/emmanu14/public_html/auctioneers/wp-content/uploads/2020/07/great-port-2.xlsx',1,0,1,1,0,0,0,0,'','',0,0,25,0,-1,0,0,0,0,1,'','','','a:5:{s:5:\"print\";i:1;s:4:\"copy\";i:1;s:5:\"excel\";i:1;s:3:\"csv\";i:1;s:3:\"pdf\";i:0;}','{\"info_block\":0,\"global_search\":1,\"showRowsPerPage\":1,\"clearFilters\":0}',0,0,'');
