-- --------------------------------------------------------
-- Host:                         realbeto.ro
-- Server version:               11.6.2-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

-- Dumping structure for table carpsilviuionut.tds_trackings_templates
CREATE TABLE IF NOT EXISTS `tds_trackings_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `page_html` varchar(2000) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- Dumping data for table carpsilviuionut.tds_trackings_templates: ~0 rows (approximately)
DELETE FROM `tds_trackings_templates`;
INSERT INTO `tds_trackings_templates` (`id`, `name`, `page_html`, `created_at`) VALUES
	(1, 'Default Template', '<script async src="https://www.googletagmanager.com/gtag/js?id=UA-xxxxxxxx"></script> //Your Google Analytics ID\r\n<script>\r\n    window.dataLayer = window.dataLayer || [];\r\n    function gtag(){ dataLayer.push(arguments); }\r\n    gtag( \'js\', new Date() );\r\n    gtag( \'config\', \'UA-xxxxxxxx-x\' ); //Your Google Analytics ID\r\n    gtag(\r\n        \'event\', // Sends your conversion as an Event with the "ecommerce" "category" in your GA events reports\r\n        \'purchase\', // Specifies the "action" of the event\r\n        {\r\n            \'event_label\': \'NAMEIT\', // This is the "label" of the event. You can rename. (e.g. Plan2)\r\n            \'transaction_id\': \'INVOICE NUMBER\', // This is the ID of conversion. (e.g. 634)\r\n            \'value\': XXX.00, // Specifies the total revenue or grand total associated with the transaction (e.g. 11.99)\r\n            \'currency\': "XXX", // Local currency code. (e.g USD)\r\n            \'tax\': 0.0, // Specifies the total shipping cost of the transaction. (e.g. 5)\r\n            \'shipping\': 0, // Specifies the total tax of the transaction. (e.g. 1.29)\r\n            "items": [\r\n                {\r\n                    "id": "Your Plan ID", // Transaction ID. For this specific case it\'s SKU. Required.\r\n                    "name": "NameIt", // Product name. Required.\r\n                    "quantity": XX, // Quantity. Required.\r\n                    "price": "XX.0" // Price per Unit. Required.\r\n                },\r\n                {\r\n                    "id": "Your Plan ID2",\r\n                    "name": "NameIt2",\r\n                    "quantity": XX,\r\n                    "price": "XX.0"\r\n                },\r\n                {\r\n                    "id": "Your Plan ID3",\r\n                    "name": "NameIt3",\r\n                    "quantity": XX,\r\n                    "price": "XX.0"\r\n                }\r\n            ],\r\n            \'event_callback\': function() {\r\n                redirect(1000);\r\n            }\r\n        }\r\n    );\r\n</script>', '2024-02-07 08:09:01');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
