/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpjh_wpdatatables_columns`; */
/* PRE_TABLE_NAME: `1689681854_wpjh_wpdatatables_columns`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1689681854_wpjh_wpdatatables_columns` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `table_id` bigint(20) NOT NULL, `orig_header` varchar(255) NOT NULL, `display_header` varchar(255) NOT NULL, `filter_type` enum('none','null_str','text','number','number-range','date-range','datetime-range','time-range','select','checkbox') NOT NULL, `column_type` enum('autodetect','string','int','float','date','link','email','image','formula','datetime','time') NOT NULL, `input_type` enum('none','text','textarea','mce-editor','date','datetime','time','link','email','selectbox','multi-selectbox','attachment') NOT NULL DEFAULT 'text', `input_mandatory` tinyint(1) NOT NULL DEFAULT '0', `id_column` tinyint(1) NOT NULL DEFAULT '0', `group_column` tinyint(1) NOT NULL DEFAULT '0', `sort_column` tinyint(1) NOT NULL DEFAULT '0', `hide_on_phones` tinyint(1) NOT NULL DEFAULT '0', `hide_on_tablets` tinyint(1) NOT NULL DEFAULT '0', `visible` tinyint(1) NOT NULL DEFAULT '1', `sum_column` tinyint(1) NOT NULL DEFAULT '0', `skip_thousands_separator` tinyint(1) NOT NULL DEFAULT '0', `width` varchar(4) NOT NULL DEFAULT '', `possible_values` text NOT NULL, `default_value` varchar(100) NOT NULL DEFAULT '', `css_class` varchar(255) NOT NULL DEFAULT '', `text_before` varchar(255) NOT NULL DEFAULT '', `text_after` varchar(255) NOT NULL DEFAULT '', `formatting_rules` text NOT NULL, `calc_formula` text NOT NULL, `color` varchar(255) NOT NULL DEFAULT '', `advanced_settings` text NOT NULL, `pos` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
INSERT INTO `1689681854_wpjh_wpdatatables_columns` (`id`, `table_id`, `orig_header`, `display_header`, `filter_type`, `column_type`, `input_type`, `input_mandatory`, `id_column`, `group_column`, `sort_column`, `hide_on_phones`, `hide_on_tablets`, `visible`, `sum_column`, `skip_thousands_separator`, `width`, `possible_values`, `default_value`, `css_class`, `text_before`, `text_after`, `formatting_rules`, `calc_formula`, `color`, `advanced_settings`, `pos`) VALUES (6,2,'YEAR','YEAR','none','date','text',0,0,0,0,0,0,1,0,0,'','','','','','','','','','{\"decimalPlaces\":-1,\"sorting\":1,\"dateInputFormat\":\"\",\"linkTargetAttribute\":\"_self\",\"linkButtonAttribute\":0,\"linkButtonLabel\":\"\",\"linkButtonClass\":\"\"}',2),(5,2,'NAME OF PARTNERSHIP','NAME OF PARTNERSHIP','none','string','text',0,0,0,0,0,0,1,0,0,'','','','','','','','','','{\"decimalPlaces\":-1,\"sorting\":1,\"dateInputFormat\":\"\",\"linkTargetAttribute\":\"_self\",\"linkButtonAttribute\":0,\"linkButtonLabel\":\"\",\"linkButtonClass\":\"\"}',1),(4,2,'S/N','S/N','none','int','text',0,0,0,0,0,0,1,0,0,'','','','','','','','','','{\"decimalPlaces\":-1,\"sorting\":1,\"dateInputFormat\":\"\",\"linkTargetAttribute\":\"_self\",\"linkButtonAttribute\":0,\"linkButtonLabel\":\"\",\"linkButtonClass\":\"\"}',0);
