-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 25, 2022 at 06:57 PM
-- Server version: 8.0.31-0ubuntu0.20.04.1
-- PHP Version: 7.4.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `echautores_dev`
--

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `node` int NOT NULL COMMENT 'node_id',
  `role` bigint NOT NULL,
  `text` varchar(40) NOT NULL COMMENT 'node_name',
  `parent_id` int NOT NULL,
  `leaf` varchar(5) NOT NULL COMMENT 'true/false',
  `action` varchar(40) DEFAULT NULL,
  `iconCls` varchar(25) NOT NULL COMMENT 'iconClass',
  `sort` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`node`, `role`, `text`, `parent_id`, `leaf`, `action`, `iconCls`, `sort`) VALUES
(1, 262144, 'Autoresponders', 0, 'false', 'autoresponders', 'icon-autoresps', 1),
(2, 262144, 'Subscribers', 0, 'false', 'subscribers', 'icon-subscribers', 2),
(3, 262144, 'Tracking Tags', 0, 'false', 'trackinggrid', 'icon-tracktags', 3),
(4, 262144, 'Link Tracking', 0, 'false', 'linktrackinggrid', 'icon-linktracking', 4),
(5, 262144, 'User Profile', 0, 'false', '', 'icon-profile', 5),
(6, 262144, 'System', 0, 'false', '', 'icon-system', 6),
(7, 262144, 'Help', 0, 'false', 'help', 'icon-help', 7),
(8, 262144, 'Logout', 0, 'true', 'logout', 'icon-logout', 8),
(9, 262144, 'Show List', 1, 'true', 'autolist', 'icon-autolist', 1),
(10, 262144, 'Create New', 1, 'true', 'autoresp_create', 'icon-autoresp-create', 2),
(11, 262144, 'Copy Existing', 1, 'true', 'autoresp_copy', 'icon-autoresp-copy', 3),
(12, 262144, 'Show List', 2, 'true', 'subscriberlist', 'icon-autolist', 1),
(13, 262144, 'Add Subscriber', 2, 'true', 'subscriber_add', 'icon-subscriber-add', 2),
(14, 262144, 'Quick Find', 2, 'true', 'subscriber_qfind', 'icon-subscriber-add', 3),
(15, 262144, 'Filter', 2, 'false', '', 'icon-subscriber-add', 4),
(16, 262144, 'Set Filter', 15, 'true', 'subscriber_setfilter', 'icon-subscriber-add', 1),
(17, 262144, 'Clear Filter', 15, 'true', 'subscriber_clearfilter', 'icon-subscriber-add', 2),
(18, 262144, 'Group Tasks', 2, 'false', '', 'icon-subscriber-add', 5),
(19, 262144, 'Global Tasks', 2, 'false', '', 'icon-subscriber-add', 6),
(20, 262144, 'Import From File', 2, 'true', '', 'icon-subscriber-add', 7),
(21, 262144, 'Broadcast', 18, 'false', '', 'icon-subscriber-add', 1),
(22, 262144, 'Export', 18, 'false', '', 'icon-subscriber-add', 2),
(23, 262144, 'Edit', 18, 'false', '', 'icon-subscriber-add', 3),
(24, 262144, 'Delete', 18, 'false', '', 'icon-subscriber-add', 4),
(25, 262144, 'Create New', 21, 'false', 'broadcast_new', 'icon-subscriber-add', 1),
(26, 262144, 'Clear Send Log', 18, 'false', '', 'icon-subscriber-add', 5),
(27, 262144, 'Queue Manager', 21, 'false', 'broadcast_queue', 'icon-subscriber-add', 2),
(28, 262144, 'Quick Remove', 19, 'true', 'quick_remove', 'icon-subscriber-add', 1),
(29, 262144, 'Delete Unsubscribers', 19, 'true', 'delete_unsubscribers', 'icon-subscriber-add', 2),
(30, 262144, 'Delete Failures', 19, 'true', 'delete_failures', 'icon-subscriber-add', 3),
(31, 262144, 'Deduplicate', 19, 'true', 'deduplicate', 'icon-subscriber-add', 4),
(32, 262144, 'Show List', 3, 'true', '', 'icon-subscriber-add', 1),
(33, 262144, 'Create New', 3, 'true', '', 'icon-subscriber-add', 2),
(34, 262144, 'Show List', 4, 'true', '', 'icon-subscriber-add', 1),
(35, 262144, 'Create New', 4, 'true', '', 'icon-subscriber-add', 2),
(36, 262144, 'Basic Profile', 5, 'true', '', 'icon-subscriber-add', 1),
(37, 262144, 'Detailed Record', 5, 'true', '', 'icon-subscriber-add', 2),
(38, 262144, 'Settings', 6, 'true', '', 'icon-subscriber-add', 1),
(39, 262144, 'Backup and Restore', 6, 'false', '', 'icon-subscriber-add', 2),
(40, 262144, 'Custom Tags', 6, 'true', '', 'icon-subscriber-add', 3),
(41, 262144, 'Tests', 6, 'false', '', 'icon-subscriber-add', 4),
(42, 262144, 'Backup Data', 39, 'true', '', 'icon-subscriber-add', 1),
(43, 262144, 'Restore Data', 39, 'true', '', 'icon-subscriber-add', 2),
(44, 262144, 'Email Send Test', 41, 'true', '', 'icon-subscriber-add', 1),
(45, 262144, 'Email Capture Test', 41, 'true', '', 'icon-subscriber-add', 2),
(46, 262144, 'Blast Timer Test', 41, 'true', '', 'icon-subscriber-add', 3),
(47, 262144, 'Version Check', 7, 'true', '', 'icon-subscriber-add', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`node`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `node` int NOT NULL AUTO_INCREMENT COMMENT 'node_id', AUTO_INCREMENT=48;
COMMIT;

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