/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wp_fluentform_forms`; */
/* PRE_TABLE_NAME: `1748366729_wp_fluentform_forms`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1748366729_wp_fluentform_forms` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `status` varchar(45) DEFAULT 'Draft', `appearance_settings` text DEFAULT NULL, `form_fields` longtext DEFAULT NULL, `has_payment` tinyint(1) NOT NULL DEFAULT 0, `type` varchar(45) DEFAULT NULL, `conditions` text DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `1748366729_wp_fluentform_forms` (`id`, `title`, `status`, `appearance_settings`, `form_fields`, `has_payment`, `type`, `conditions`, `created_by`, `created_at`, `updated_at`) VALUES (1,'Contact Form Demo','published',NULL,'{\"fields\":[{\"index\":0,\"element\":\"input_name\",\"attributes\":{\"name\":\"names\",\"data-type\":\"name-element\"},\"settings\":{\"container_class\":\"\",\"admin_field_label\":\"Name\",\"conditional_logics\":[],\"label_placement\":\"\"},\"fields\":{\"first_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"first_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"Enter Name\"},\"settings\":{\"container_class\":\"\",\"label\":\"Name\",\"help_message\":\"\",\"visible\":true,\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}},\"middle_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"middle_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"\",\"required\":false},\"settings\":{\"container_class\":\"\",\"label\":\"Middle Name\",\"help_message\":\"\",\"error_message\":\"\",\"visible\":false,\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}},\"last_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"last_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"Enter Last name\",\"required\":false},\"settings\":{\"container_class\":\"\",\"label\":\"Last name\",\"help_message\":\"\",\"error_message\":\"\",\"visible\":true,\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}}},\"editor_options\":{\"title\":\"Name Fields\",\"element\":\"name-fields\",\"icon_class\":\"ff-edit-name\",\"template\":\"nameFields\"},\"uniqElKey\":\"el_1570866006692\"},{\"index\":1,\"element\":\"input_email\",\"attributes\":{\"type\":\"email\",\"name\":\"email\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"Email Address\"},\"settings\":{\"container_class\":\"\",\"label\":\"Email\",\"label_placement\":\"\",\"help_message\":\"\",\"admin_field_label\":\"\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"},\"email\":{\"value\":true,\"message\":\"This field must contain a valid email\",\"global\":false,\"global_message\":\"This field must contain a valid email\"}},\"conditional_logics\":[],\"is_unique\":\"no\",\"unique_validation_message\":\"Email address need to be unique.\",\"prefix_label\":\"\",\"suffix_label\":\"\"},\"editor_options\":{\"title\":\"Email Address\",\"icon_class\":\"ff-edit-email\",\"template\":\"inputText\"},\"uniqElKey\":\"el_1570866012914\"},{\"index\":2,\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"subject\",\"value\":\"\",\"class\":\"\",\"placeholder\":\"Subject\",\"maxlength\":\"\"},\"settings\":{\"container_class\":\"\",\"label\":\"Subject\",\"label_placement\":\"\",\"admin_field_label\":\"Subject\",\"help_message\":\"\",\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":{\"type\":\"any\",\"status\":false,\"conditions\":[{\"field\":\"\",\"value\":\"\",\"operator\":\"\"}]},\"is_unique\":\"no\",\"unique_validation_message\":\"This field value need to be unique.\",\"prefix_label\":\"\",\"suffix_label\":\"\"},\"editor_options\":{\"title\":\"Simple Text\",\"icon_class\":\"ff-edit-text\",\"template\":\"inputText\"},\"uniqElKey\":\"el_1570878958648\"},{\"index\":3,\"element\":\"textarea\",\"attributes\":{\"name\":\"message\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"Enter Your message\",\"rows\":4,\"cols\":2,\"maxlength\":\"\"},\"settings\":{\"container_class\":\"\",\"label\":\"Your message\",\"admin_field_label\":\"\",\"label_placement\":\"\",\"help_message\":\"\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":{\"type\":\"any\",\"status\":false,\"conditions\":[{\"field\":\"\",\"value\":\"\",\"operator\":\"\"}]}},\"editor_options\":{\"title\":\"Text Area\",\"icon_class\":\"ff-edit-textarea\",\"template\":\"inputTextarea\"},\"uniqElKey\":\"el_1570879001207\"}],\"submitButton\":{\"uniqElKey\":\"el_1524065200616\",\"element\":\"button\",\"attributes\":{\"type\":\"submit\",\"class\":\"\"},\"settings\":{\"align\":\"left\",\"button_style\":\"default\",\"container_class\":\"\",\"help_message\":\"\",\"background_color\":\"#1a7efb\",\"button_size\":\"md\",\"color\":\"#ffffff\",\"button_ui\":{\"type\":\"default\",\"text\":\"Submit\",\"img_url\":\"\"},\"normal_styles\":{\"backgroundColor\":\"#1a7efb\",\"borderColor\":\"#1a7efb\",\"color\":\"#ffffff\",\"borderRadius\":\"\",\"minWidth\":\"\"},\"hover_styles\":{\"backgroundColor\":\"#ffffff\",\"borderColor\":\"#1a7efb\",\"color\":\"#1a7efb\",\"borderRadius\":\"\",\"minWidth\":\"\"},\"current_state\":\"normal_styles\"},\"editor_options\":{\"title\":\"Submit Button\"}}}',0,'',NULL,1,'2024-05-16 11:21:50','2024-06-09 16:57:53'),(2,'Subscription Form','published',NULL,'{\"fields\":[{\"index\":1,\"element\":\"container\",\"attributes\":[],\"settings\":{\"container_class\":\"\",\"conditional_logics\":{\"type\":\"any\",\"status\":false,\"conditions\":[{\"field\":\"\",\"value\":\"\",\"operator\":\"\"}]},\"is_width_auto_calc\":true,\"container_width\":\"\"},\"columns\":[{\"width\":100,\"left\":\"\",\"fields\":[{\"index\":1,\"element\":\"input_email\",\"attributes\":{\"type\":\"email\",\"name\":\"email\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"Your e-mail address\"},\"settings\":{\"container_class\":\"\",\"label\":\"\",\"label_placement\":\"\",\"help_message\":\"\",\"admin_field_label\":\"Email\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"This field is required\",\"global\":false,\"global_message\":\"This field is required\"},\"email\":{\"value\":true,\"message\":\"This field must contain a valid email\",\"global\":false,\"global_message\":\"This field must contain a valid email\"}},\"conditional_logics\":[],\"is_unique\":\"no\",\"unique_validation_message\":\"Email address need to be unique.\",\"prefix_label\":\"\",\"suffix_label\":\"\"},\"editor_options\":{\"title\":\"Email Address\",\"icon_class\":\"ff-edit-email\",\"template\":\"inputText\"},\"uniqElKey\":\"el_1715857020883\"},{\"index\":15,\"element\":\"custom_submit_button\",\"attributes\":{\"class\":\"\",\"type\":\"submit\"},\"settings\":{\"button_style\":\"\",\"button_size\":\"md\",\"align\":\"left\",\"container_class\":\"\",\"current_state\":\"normal_styles\",\"background_color\":\"\",\"color\":\"\",\"hover_styles\":{\"backgroundColor\":\"#ffffff\",\"borderColor\":\"#1a7efb\",\"color\":\"#1a7efb\",\"borderRadius\":\"\",\"minWidth\":\"100%\"},\"normal_styles\":{\"backgroundColor\":\"#1a7efb\",\"borderColor\":\"#1a7efb\",\"color\":\"#ffffff\",\"borderRadius\":\"\",\"minWidth\":\"100%\"},\"button_ui\":{\"text\":\"Subscribe\",\"type\":\"default\",\"img_url\":\"\"},\"conditional_logics\":{\"type\":\"any\",\"status\":false,\"conditions\":[{\"field\":\"\",\"value\":\"\",\"operator\":\"\"}]}},\"editor_options\":{\"title\":\"Custom Submit Button\",\"icon_class\":\"dashicons dashicons-arrow-right-alt\",\"template\":\"customButton\"},\"uniqElKey\":\"el_1715857024728\"}]}],\"editor_options\":{\"title\":\"Conteneur à 1 colonne\",\"icon_class\":\"dashicons dashicons-align-center\"},\"uniqElKey\":\"el_171585701712465\"}],\"submitButton\":{\"uniqElKey\":\"el_1524065200616\",\"element\":\"button\",\"attributes\":{\"type\":\"submit\",\"class\":\"\"},\"settings\":{\"align\":\"left\",\"button_style\":\"default\",\"container_class\":\"\",\"help_message\":\"\",\"background_color\":\"#1a7efb\",\"button_size\":\"md\",\"color\":\"#ffffff\",\"button_ui\":{\"type\":\"default\",\"text\":\"Subscribe\",\"img_url\":\"\"}},\"editor_options\":{\"title\":\"Submit Button\"}}}',0,'form',NULL,1,'2024-05-16 11:21:50','2024-06-09 16:53:49'),(3,'Influencer Reward Program','published',NULL,'{\"fields\":[{\"index\":2,\"element\":\"input_name\",\"attributes\":{\"name\":\"names\",\"data-type\":\"name-element\"},\"settings\":{\"container_class\":\"\",\"admin_field_label\":\"\",\"conditional_logics\":[],\"label_placement\":\"\"},\"fields\":{\"first_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"first_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"\"},\"settings\":{\"container_class\":\"\",\"label\":\"First Name\",\"help_message\":\"\",\"visible\":true,\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"First Name field is required\",\"global\":true,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}},\"middle_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"middle_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"\",\"required\":false},\"settings\":{\"container_class\":\"\",\"label\":\"Middle Name\",\"help_message\":\"\",\"error_message\":\"\",\"visible\":false,\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":true,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}},\"last_name\":{\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"last_name\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"\",\"required\":false},\"settings\":{\"container_class\":\"\",\"label\":\"Last Name\",\"help_message\":\"\",\"error_message\":\"\",\"visible\":true,\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":true,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"template\":\"inputText\"}}},\"editor_options\":{\"title\":\"Name Fields\",\"element\":\"name-fields\",\"icon_class\":\"icon-user\",\"template\":\"nameFields\"},\"uniqElKey\":\"el_1516797727681\"},{\"index\":7,\"element\":\"input_email\",\"attributes\":{\"type\":\"email\",\"name\":\"email\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"you@domain.com\"},\"settings\":{\"container_class\":\"\",\"label\":\"Email\",\"label_placement\":\"\",\"help_message\":\"\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"Email field is required\",\"global\":false,\"global_message\":\"This field is required\"},\"email\":{\"value\":true,\"message\":\"This field must contain a valid email\",\"global\":true,\"global_message\":\"This field must contain a valid email\"}},\"conditional_logics\":[],\"is_unique\":\"no\",\"unique_validation_message\":\"Email address need to be unique.\",\"prefix_label\":\"\",\"suffix_label\":\"\"},\"editor_options\":{\"title\":\"Email\",\"icon_class\":\"icon-envelope-o\",\"template\":\"inputText\"},\"uniqElKey\":\"el_1516797731343\"},{\"index\":3,\"element\":\"select\",\"attributes\":{\"name\":\"department\",\"value\":\"\",\"id\":\"\",\"class\":\"\"},\"settings\":{\"label\":\"Influencer Platform\",\"help_message\":\"\",\"container_class\":\"\",\"label_placement\":\"\",\"placeholder\":\"- Select -\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"Department field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":[],\"advanced_options\":[{\"label\":\"YouTube\",\"value\":\"YouTube\",\"calc_value\":\"\",\"image\":\"\",\"id\":0},{\"label\":\"Instagram\",\"value\":\"Instagram\",\"calc_value\":\"\",\"image\":\"\",\"id\":1},{\"label\":\"TickTok\",\"value\":\"TickTok\",\"calc_value\":\"\",\"image\":\"\",\"id\":2},{\"label\":\"Others\",\"value\":\"Others\",\"calc_value\":\"\",\"image\":\"\",\"id\":3}],\"enable_image_input\":false,\"calc_value_status\":false,\"dynamic_default_value\":\"\",\"randomize_options\":\"no\",\"enable_select_2\":\"no\",\"values_visible\":false},\"editor_options\":{\"title\":\"Dropdown\",\"icon_class\":\"icon-caret-square-o-down\",\"element\":\"select\",\"template\":\"select\"},\"uniqElKey\":\"el_1516797735245\"},{\"index\":1,\"element\":\"input_text\",\"attributes\":{\"type\":\"text\",\"name\":\"subject\",\"value\":\"\",\"class\":\"\",\"placeholder\":\"Paste your Video URL\",\"maxlength\":\"\"},\"settings\":{\"container_class\":\"\",\"label\":\"Mention Video URL Where You promoted\",\"label_placement\":\"\",\"admin_field_label\":\"\",\"help_message\":\"\",\"validation_rules\":{\"required\":{\"value\":true,\"message\":\"Subject field is required\",\"global\":false,\"global_message\":\"This field is required\"}},\"conditional_logics\":[],\"is_unique\":\"no\",\"unique_validation_message\":\"This field value need to be unique.\",\"prefix_label\":\"\",\"suffix_label\":\"\"},\"editor_options\":{\"title\":\"Text Input\",\"icon_class\":\"icon-text-width\",\"template\":\"inputText\"},\"uniqElKey\":\"el_1516797770161\"},{\"index\":2,\"element\":\"textarea\",\"attributes\":{\"name\":\"description\",\"value\":\"\",\"id\":\"\",\"class\":\"\",\"placeholder\":\"\",\"rows\":4,\"cols\":2,\"maxlength\":\"\"},\"settings\":{\"container_class\":\"\",\"label\":\"Your Reward Message\",\"label_placement\":\"\",\"help_message\":\"\",\"validation_rules\":{\"required\":{\"value\":false,\"message\":\"This field is required\",\"global\":true,\"global_message\":\"This field is required\"}},\"conditional_logics\":[]},\"editor_options\":{\"title\":\"Textarea\",\"icon_class\":\"icon-paragraph\",\"template\":\"inputTextarea\"},\"uniqElKey\":\"el_1516797774136\"}],\"submitButton\":{\"uniqElKey\":\"el_1524065200616\",\"element\":\"button\",\"attributes\":{\"type\":\"submit\",\"class\":\"\"},\"settings\":{\"align\":\"left\",\"button_style\":\"default\",\"container_class\":\"\",\"help_message\":\"\",\"background_color\":\"#1a7efb\",\"button_size\":\"md\",\"color\":\"#ffffff\",\"button_ui\":{\"type\":\"default\",\"text\":\"Apply For Reward\",\"img_url\":\"\"},\"normal_styles\":{\"backgroundColor\":\"#1a7efb\",\"borderColor\":\"#1a7efb\",\"color\":\"#ffffff\",\"borderRadius\":\"\",\"minWidth\":\"\"},\"hover_styles\":{\"backgroundColor\":\"#ffffff\",\"borderColor\":\"#1a7efb\",\"color\":\"#1a7efb\",\"borderRadius\":\"\",\"minWidth\":\"\"},\"current_state\":\"normal_styles\"},\"editor_options\":{\"title\":\"Submit Button\"}}}',0,'form',NULL,1,'2024-07-07 09:26:46','2025-05-27 14:45:54');
