-- MySQL dump 10.19  Distrib 10.3.36-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: leimatfi_joomla
-- ------------------------------------------------------
-- Server version	10.3.36-MariaDB-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `xrx2w_baforms_forms`
--

DROP TABLE IF EXISTS `xrx2w_baforms_forms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xrx2w_baforms_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL,
  `title_settings` text NOT NULL,
  `form_settings` text NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `alow_captcha` varchar(40) NOT NULL,
  `display_title` tinyint(1) NOT NULL DEFAULT 1,
  `sent_massage` text NOT NULL,
  `error_massage` text NOT NULL,
  `redirect_url` varchar(255) NOT NULL,
  `email_recipient` varchar(255) NOT NULL,
  `email_subject` varchar(255) NOT NULL,
  `email_body` text NOT NULL,
  `sender_name` varchar(255) NOT NULL,
  `sender_email` varchar(255) NOT NULL,
  `reply_subject` varchar(255) NOT NULL,
  `reply_body` text NOT NULL,
  `display_popup` tinyint(1) NOT NULL DEFAULT 0,
  `button_lable` varchar(255) NOT NULL,
  `button_position` varchar(40) NOT NULL,
  `button_bg` varchar(40) NOT NULL,
  `button_color` varchar(40) NOT NULL,
  `button_font_size` int(5) NOT NULL DEFAULT 14,
  `button_border` int(5) NOT NULL DEFAULT 3,
  `button_weight` varchar(10) NOT NULL DEFAULT 'normal',
  `display_submit` tinyint(1) NOT NULL DEFAULT 1,
  `submit_embed` text NOT NULL,
  `message_bg_rgba` varchar(255) NOT NULL,
  `message_color_rgba` varchar(255) NOT NULL,
  `dialog_color_rgba` varchar(255) NOT NULL,
  `add_sender_email` varchar(255) NOT NULL DEFAULT '0',
  `copy_submitted_data` tinyint(1) NOT NULL DEFAULT 0,
  `modal_width` varchar(255) NOT NULL DEFAULT '500',
  `display_total` tinyint(1) NOT NULL DEFAULT 0,
  `currency_code` varchar(255) NOT NULL,
  `currency_symbol` varchar(255) NOT NULL,
  `payment_methods` varchar(255) NOT NULL,
  `return_url` varchar(255) NOT NULL,
  `cancel_url` varchar(255) NOT NULL,
  `paypal_email` varchar(255) NOT NULL,
  `payment_environment` varchar(255) NOT NULL,
  `seller_id` varchar(255) NOT NULL,
  `skrill_email` varchar(255) NOT NULL,
  `webmoney_purse` varchar(255) NOT NULL,
  `check_ip` tinyint(1) NOT NULL DEFAULT 0,
  `payu_api_key` varchar(255) NOT NULL,
  `payu_merchant_id` varchar(255) NOT NULL,
  `payu_account_id` varchar(255) NOT NULL,
  `button_type` varchar(255) NOT NULL,
  `email_letter` mediumtext NOT NULL,
  `display_cart` tinyint(1) NOT NULL DEFAULT 0,
  `currency_position` varchar(255) NOT NULL DEFAULT 'before',
  `multiple_payment` tinyint(1) NOT NULL DEFAULT 0,
  `custom_payment` varchar(255) NOT NULL DEFAULT 'Custom Payment',
  `mailchimp_api_key` varchar(255) NOT NULL,
  `mailchimp_list_id` varchar(255) NOT NULL,
  `mailchimp_fields_map` text NOT NULL,
  `stripe_api_key` varchar(255) NOT NULL,
  `stripe_image` varchar(255) NOT NULL,
  `stripe_name` varchar(255) NOT NULL,
  `stripe_description` varchar(255) NOT NULL,
  `theme_color` varchar(255) NOT NULL DEFAULT '#009ddc',
  `email_options` text NOT NULL,
  `mollie_api_key` varchar(255) NOT NULL,
  `telegram_token` varchar(255) NOT NULL,
  `payu_biz_merchant` varchar(255) NOT NULL,
  `payu_biz_salt` varchar(255) NOT NULL,
  `save_continue` tinyint(1) NOT NULL DEFAULT 0,
  `save_continue_label` varchar(255) NOT NULL DEFAULT 'Save and Continue',
  `save_continue_size` varchar(30) NOT NULL DEFAULT '13',
  `save_continue_weight` varchar(10) NOT NULL DEFAULT 'normal',
  `save_continue_align` varchar(20) NOT NULL DEFAULT 'center',
  `save_continue_color` varchar(50) NOT NULL DEFAULT '#009ddc',
  `save_continue_popup_title` varchar(255) NOT NULL,
  `save_continue_popup_message` text NOT NULL,
  `save_continue_subject` varchar(255) NOT NULL,
  `save_continue_email` text NOT NULL,
  `ccavenue_merchant_id` varchar(255) NOT NULL,
  `ccavenue_working_key` varchar(255) NOT NULL,
  `stripe_secret_key` varchar(255) NOT NULL,
  `load_jquery` tinyint(1) NOT NULL DEFAULT 1,
  `acymailing_lists` text NOT NULL,
  `acymailing_fields_map` text NOT NULL,
  `yandex_shopId` varchar(255) NOT NULL,
  `yandex_scid` varchar(255) NOT NULL,
  `google_sheets` text NOT NULL,
  `barion_poskey` varchar(255) NOT NULL,
  `barion_email` varchar(255) NOT NULL,
  `payu_pl_pos_id` varchar(255) NOT NULL,
  `payu_pl_second_key` varchar(255) NOT NULL,
  `save_submissions` tinyint(1) NOT NULL DEFAULT 1,
  `attach_uploaded_files` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xrx2w_baforms_forms`
--

LOCK TABLES `xrx2w_baforms_forms` WRITE;
/*!40000 ALTER TABLE `xrx2w_baforms_forms` DISABLE KEYS */;
INSERT INTO `xrx2w_baforms_forms` VALUES (1,'Contact Form (en)','font-size:26px; font-weight:normal; text-align:left;color:rgba(17, 17, 17, 1);','/17px/rgba(255, 255, 255, 1)/50px/15px/rgba(255, 255, 255, 1)/rgba(110, 110, 110, 0)/border: 1px solid rgba(255, 255, 255, 1)/5px/width: 100%;background-color: rgba(110, 110, 110, 0);border: 1px solid rgba(0, 0, 0, 0);border-radius: 5px/normal/24/rgba(255, 0, 0, 1)/Total/left/',0,1,'customrecaptcha',0,'<h3>Thanks!</h3><p>Your message was sent successfully!</p>','<h3>Send Message Error!</h3><p>Your message could not be sent!</p>','','info@leimat.fi','New Leimat.fi website message','','John Doe','','Thank you for your submission!','<p>Thank you for filling form! Your information has been successfully submitted. We will process its contents and get back to you as soon as possible.</p>\r\n',0,'','default','rgba(2, 173, 234, 1)','rgba(250, 250, 250, 1)',14,3,'normal',1,'','rgba(255, 255, 255, 1)','rgba(51, 51, 51, 1)','rgba(0, 0, 0, 0.15)','1',0,'500',0,'USD','$','','','','','production','','','',0,'','','','','<table class=\"parent-table\" style=\"width: 100%; background-color: rgb(255, 255, 255);\"><tbody><tr><td><table style=\"width: 100%; background-color: transparent; margin: 0px auto; border-spacing: 0px;\" class=\"second-table\"><tbody class=\"ui-sortable\"><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=3]\" style=\"color: rgb(17, 17, 17); font-size: 14px; font-weight: normal; line-height: 200%; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial;\">[Field=NAME]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=4]\" style=\"color: rgb(17, 17, 17); font-size: 14px; font-weight: normal; line-height: 200%; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial;\">[Field=EMAIL *]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=5]\" style=\"color: rgb(17, 17, 17); font-size: 14px; font-weight: normal; line-height: 200%; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial;\">[Field=MESSAGE]</div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>',0,'before',0,'Custom Payment','','','{}','','','','','rgba(0, 157, 220, 1)','{\"color\":\"rgba(17, 17, 17, 1)\",\"size\":\"14\",\"weight\":\"normal\",\"bg\":\"rgba(255, 255, 255, 1)\",\"width\":\"100\"}','','','','',0,'Save and Continue','13','normal','center','#009ddc','Save and Continue Later','<p>The data you filled in the form has been saved. Please use the following link to return to form. The link will expire after 30 days!</p><p>[ba-form-token-link]</p><p>Enter your email address and link will be emailed to you!</p>','Don\'t forget to complete the form you started!','Your progress has been saved. When you are ready to complete form, please follow this link: [ba-form-token-link]','','','',1,'{}','{}','','','{}','','','','',1,0),(2,'Contact Form (fi)','font-size:26px; font-weight:normal; text-align:left;color:rgba(17, 17, 17, 1);','/17px/rgba(255, 255, 255, 1)/50px/15px/rgba(255, 255, 255, 1)/rgba(110, 110, 110, 0)/border: 1px solid rgba(255, 255, 255, 1)/5px/width: 100%;background-color: rgba(110, 110, 110, 0);border: 1px solid rgba(0, 0, 0, 0);border-radius: 5px/normal/24/rgba(255, 0, 0, 1)/Total/left/',0,1,'customrecaptcha',0,'<h3>Kiitos!</h3><p>Viestisi lähetettiin onnistuneesti!</p>','<h3>Lähetä Viesti Virhe!</h3><p>Viesti ei voitu lähettää!</p>','','info@leimat.fi','Uusi Leimat.fi verkkosivuilla viesti','','John Doe','','Thank you for your submission!','<p>Thank you for filling form! Your information has been successfully submitted. We will process its contents and get back to you as soon as possible.</p>\r\n',0,'','default','rgba(2, 173, 234, 1)','rgba(250, 250, 250, 1)',14,3,'normal',1,'','rgba(255, 255, 255, 1)','rgba(51, 51, 51, 1)','rgba(0, 0, 0, 0.15)','1',0,'500',0,'USD','$','','','','','production','','','',0,'','','','','<table style=\"width: 100%; background-color: #ffffff; border: 1px solid #f3f3f3; margin: 0 auto;\" class=\"second-table\"><tbody class=\"ui-sortable\"><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=7]\">[Field=NIMI]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=8]\">[Field=SÄHKÖPOSTI *]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=9]\">[Field=VIESTI]</div></td></tr></tbody></table></td></tr></tbody></table>',0,'before',0,'Custom Payment','','','{}','','','','','rgba(0, 157, 220, 1)','{}','','','','',0,'Save and Continue','13','normal','center','#009ddc','Save and Continue Later','<p>The data you filled in the form has been saved. Please use the following link to return to form. The link will expire after 30 days!</p><p>[ba-form-token-link]</p><p>Enter your email address and link will be emailed to you!</p>','Don\'t forget to complete the form you started!','Your progress has been saved. When you are ready to complete form, please follow this link: [ba-form-token-link]','','','',1,'{}','{}','','','{}','','','','',1,0),(3,'Contact Form (sv)','font-size:26px; font-weight:normal; text-align:left;color:rgba(17, 17, 17, 1);','/17px/rgba(255, 255, 255, 1)/50px/15px/rgba(255, 255, 255, 1)/rgba(110, 110, 110, 0)/border: 1px solid rgba(255, 255, 255, 1)/5px/width: 100%;background-color: rgba(110, 110, 110, 0);border: 1px solid rgba(0, 0, 0, 0);border-radius: 5px/normal/24/rgba(255, 0, 0, 1)/Total/left/',0,1,'customrecaptcha',0,'<h3>Tack!</h3><p>Ditt meddelande har skickats!</p>','<h3>Skicka Meddelande Fel!</h3><p>Ditt meddelande kunde inte skickas!</p>','','info@leimat.fi','Nya Leimat.fi webbplats meddelande','','John Doe','','Thank you for your submission!','<p>Thank you for filling form! Your information has been successfully submitted. We will process its contents and get back to you as soon as possible.</p>\r\n',0,'','default','rgba(2, 173, 234, 1)','rgba(250, 250, 250, 1)',14,3,'normal',1,'','rgba(255, 255, 255, 1)','rgba(51, 51, 51, 1)','rgba(0, 0, 0, 0.15)','1',0,'500',0,'USD','$','','','','','production','','','',0,'','','','','<table style=\"width: 100%; background-color: #ffffff; border: 1px solid #f3f3f3; margin: 0 auto;\" class=\"second-table\"><tbody class=\"ui-sortable\"><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=11]\">[Field=NAMN]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=12]\">[Field=E-POST *]</div></td></tr></tbody></table></td></tr><tr class=\"ba-section\"><td style=\"width: 100%; padding: 0 20px;\"><table style=\"width: 100%; background-color: rgba(0,0,0,0); color: #333333; margin-top:10px; margin-bottom : 10px; border-top: 1px solid #f3f3f3; border-left: 1px solid #f3f3f3; border-right: 1px solid #f3f3f3; border-bottom: 1px solid #f3f3f3;\"><tbody><tr><td class=\"droppad_area ui-sortable ui-droppable\" style=\"width:100%; padding: 20px\"><div class=\"droppad_item system-item ui-sortable-handle\" data-item=\"[item=13]\">[Field=MEDDELANDE]</div></td></tr></tbody></table></td></tr></tbody></table>',0,'before',0,'Custom Payment','','','{}','','','','','rgba(0, 157, 220, 1)','{}','','','','',0,'Save and Continue','13','normal','center','#009ddc','Save and Continue Later','<p>The data you filled in the form has been saved. Please use the following link to return to form. The link will expire after 30 days!</p><p>[ba-form-token-link]</p><p>Enter your email address and link will be emailed to you!</p>','Don\'t forget to complete the form you started!','Your progress has been saved. When you are ready to complete form, please follow this link: [ba-form-token-link]','','','',1,'{}','{}','','','{}','','','','',1,0);
/*!40000 ALTER TABLE `xrx2w_baforms_forms` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-09-24 11:24:02
