PHP Classes

File: magic_pixel.sql

Recommend this page to a friend!
  Classes of Er. Rochak Chauhan  >  Magic PHP Pixel Tracking  >  magic_pixel.sql  >  Download  
File: magic_pixel.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL file
Class: Magic PHP Pixel Tracking
Track if an email message was viewed or opened
Author: By
Last change:
Date: 4 months ago
Size: 5,959 bytes
 

Contents

Class file image Download
-- Adminer 4.7.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `mp_campaign_email`;
CREATE TABLE `mp_campaign_email` (
  `mp_campaign_email_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mp_campaign_email_uuid` varchar(32) NOT NULL,
  `mp_email_campaign_uuid` varchar(32) NOT NULL,
  `mp_campaign_email_address` varchar(255) NOT NULL,
  `mp_campaign_email_sent_on` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `mp_campaign_email_last_viewed_on` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `mp_campaign_email_last_viewed_metadata` text,
  `mp_campaign_email_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mp_campaign_email_modified_date` datetime DEFAULT NULL,
  `mp_campaign_email_status` enum('PENDING','SENT','VIEWED','CLICKED','SENDING_FAILED','ERROR') NOT NULL DEFAULT 'PENDING',
  `mp_campaign_email_is_deleted` enum('YES','NO') NOT NULL DEFAULT 'NO',
  PRIMARY KEY (`mp_campaign_email_id`),
  UNIQUE KEY `mp_campaign_email_uuid` (`mp_campaign_email_uuid`),
  KEY `mp_email_campaign_uuid` (`mp_email_campaign_uuid`),
  KEY `mp_campaign_email_address` (`mp_campaign_email_address`),
  CONSTRAINT `mp_campaign_email_ibfk_1` FOREIGN KEY (`mp_email_campaign_uuid`) REFERENCES `mp_email_campaign` (`mp_email_campaign_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table to store itemised details of each email sent';

INSERT INTO `mp_campaign_email` (`mp_campaign_email_id`, `mp_campaign_email_uuid`, `mp_email_campaign_uuid`, `mp_campaign_email_address`, `mp_campaign_email_sent_on`, `mp_campaign_email_last_viewed_on`, `mp_campaign_email_last_viewed_metadata`, `mp_campaign_email_created_date`, `mp_campaign_email_modified_date`, `mp_campaign_email_status`, `mp_campaign_email_is_deleted`) VALUES
(3,	'9b6b8f0455b8014e7d60f5ecc7576178',	'13b3c8c9102329bafdffc41ecfff9796',	'rochak@jumbolabs.com',	'2020-01-03 15:54:51',	'2020-01-03 10:24:51',	'{\"USER_AGENT\":\"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:71.0) Gecko/20100101 Firefox/71.0\",\"IP_ADDRESS\":\"127.0.0.1\",\"DOMAIN_NAME\":null,\"REFERER\":null,\"COOKIES\":\"{\"_ga\":\"GA1.1.1780311937.1564663649\",\"driftt_aid\":\"6b134f81-79a0-4a70-9f6a-32fbda981ad2\",\"DFTT_END_USER_PREV_BOOTSTRAPPED\":\"true\",\"_hjid\":\"4b08548d-b268-42c8-a14c-03b7a20d123a\",\"__utma\":\"111872281.1780311937.1564663649.1571132123.1575044469.3\",\"__utmz\":\"111872281.1567766802.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)\",\"__adroll_fpc\":\"03d2fb4dcbc6a815769902015fb0efc8-s2-1568024423357\",\"__ar_v4\":\"U36ONZY67FFAHJLM6Z6EZ7:20190909:14|4US6UBV4BFFKBH5JUVO5QC:20190909:14|WP3ATQIKEZDE7DXADAQPOH:20190909:14\",\"remember_web_59ba36addc2b2f9401580f014c7f58ea4e30989d\":\"eyJpdiI6ImhCYjN2Ymtkam1IUmcraHBxZmxPRXc9PSIsInZhbHVlIjoiMlV2eTRKcEhwbFwvM1RveUdVY1ArMEdFaVhGMzlGcERFK2J4UWJpQkR1M3A0K2pUNkNIYUlrT1ExdTRTNVVOS21SdGdNdnA5YXpYdnlkR0tsdjFsSXA2bDhURHBHeVBGN2x5QUFwd2RZQmtmWnhEV0o5NlFJWHBHOFwvXC9Gb1NabmZ4M1FHcGZQUVJLcG5PVU1GYW9Nbll5SElJM3lRYktFRkU0a1NGa1ZmWkFvPSIsIm1hYyI6IjQ2Yzg5MDcwNDhjZWRmNjExZTkwNmMxYmMxNThhMGExNzVkOTMxNjQ5Y2QyZDM2N2JhZDMxNzlhYWRmYjFkMTAifQ==\",\"language\":\"en_US\",\"csrftoken\":\"VGREtjsD4XKqNzxegyFqpGQnlmTH6ukHRaGUDCb3RInWPk8voD0azt6W9pfS3hGP\",\"__atuvc\":\"2|45\",\"_pk_id_2140_1fff\":\"efc094d298252e68.1573041897.2.1573045319.1573045319.\",\"_pk_id_1_1fff\":\"93c2d536106e2ac2.1573041897.2.1573045319.1573045319.\",\"GDPR_Accepted\":\"1\",\"adminer_schema-sentrifugo\":\"assets:-4.7917x57.7778\",\"username-localhost-8888\":\"\\\"2|1:0|10:1577976456|23:username-localhost-8888|44:ZjQzMGJkYmJlYmY2NDNmNjk2YzU5MmNiMTYzNTMzZmY=|1d662748f584b81f10612be94c3a68c2dd61ae93a09adcbfe4da676e9f7db497\\\"\",\"_xsrf\":\"2|bb0600ba|94bc2e4d147d3d8bd137405d78f4d719|1576565524\",\"adminer_schema-vtc\":\"vtc_district:1.8056x64.7222_vtc_state:-4.375x80.4861_vtc_subdistrict:11.25x48.3333_vtc_data:1.8056x-1.6667_vtc_place:20.2778x32.7084\",\"sessionid\":\"7a9l3w0xwkewvwwyyjtfecn1za8vldbf\",\"adminer_version\":\"4.7.5\",\"adminer_schema-baseapp_db\":\"audit_log:-3.8194x65.2083_error_log:-3.1944x80.8333_master_country:0.6944x19.7222_master_document:16.8056x65.9028_master_state:6.9444x4.8611_master_vtc:20.6944x-0.4861_sso_token:42.7083x51.0417_sso_user_information:34.8611x69.0972\"}\"}',	'2020-01-03 15:54:51',	NULL,	'PENDING',	'NO'),
(4,	'603df1d302bc4c24e2bd43e8a4664103',	'13b3c8c9102329bafdffc41ecfff9796',	'rochakchauhan@gmail.com',	'2019-12-31 12:35:57',	NULL,	NULL,	'2019-12-31 12:35:57',	NULL,	'PENDING',	'NO');

DROP TABLE IF EXISTS `mp_email_campaign`;
CREATE TABLE `mp_email_campaign` (
  `mp_email_campaign_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mp_email_campaign_uuid` varchar(32) NOT NULL,
  `mp_email_campaign_name` varchar(255) NOT NULL,
  `mp_email_campaign_startdate` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `mp_email_campaign_enddate` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `mp_email_campaign_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mp_email_campaign_modified_date` datetime DEFAULT NULL,
  `mp_email_campaign_status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `mp_email_campaign_is_deleted` enum('YES','NO') NOT NULL DEFAULT 'NO',
  PRIMARY KEY (`mp_email_campaign_id`),
  UNIQUE KEY `mp_email_campaign_uuid` (`mp_email_campaign_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table for demo perpose only';

INSERT INTO `mp_email_campaign` (`mp_email_campaign_id`, `mp_email_campaign_uuid`, `mp_email_campaign_name`, `mp_email_campaign_startdate`, `mp_email_campaign_enddate`, `mp_email_campaign_created_date`, `mp_email_campaign_modified_date`, `mp_email_campaign_status`, `mp_email_campaign_is_deleted`) VALUES
(1,	'13b3c8c9102329bafdffc41ecfff9796',	'mp_email_campaign_name_here',	'2001-03-10 17:16:18',	'2001-04-18 17:16:18',	'2019-12-28 14:52:54',	NULL,	'ACTIVE',	'NO');

-- 2020-01-03 10:28:32

For more information send a message to info at phpclasses dot org.