-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 14, 2025 at 05:38 AM
-- Server version: 5.7.44
-- PHP Version: 8.1.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `abhaf_bilingual`
--

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `newsletter_id` int(11) NOT NULL,
  `news_categ_id` int(11) DEFAULT NULL COMMENT 'newsletter category id',
  `language_id` smallint(6) NOT NULL DEFAULT '1',
  `month` int(11) DEFAULT NULL,
  `year` bigint(20) DEFAULT NULL,
  `type` smallint(6) DEFAULT '0' COMMENT '0 - memebers, 1 - public',
  `added_on_date` datetime DEFAULT NULL COMMENT 'inserted datetime',
  `status` smallint(6) DEFAULT '1' COMMENT '0 - inactive, 1- active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter`
--

INSERT INTO `newsletter` (`newsletter_id`, `news_categ_id`, `language_id`, `month`, `year`, `type`, `added_on_date`, `status`) VALUES
(2, 1, 1, 3, 2017, 1, '2017-07-07 14:52:22', 0),
(6, 1, 1, 3, 2017, 0, '2017-07-07 15:08:18', 0),
(8, 1, 1, 5, 2017, 0, '2017-07-07 15:09:58', 0),
(10, 1, 1, 6, 2017, 0, '2017-07-10 15:40:05', 0),
(13, 1, 1, 6, 2017, 1, '2017-07-30 14:13:06', 0),
(17, 1, 1, 2, 2017, 1, '2017-07-31 17:28:07', 0),
(18, 1, 1, 7, 2017, 1, '2017-07-31 18:09:30', 0),
(20, 1, 1, 5, 2017, 1, '2017-08-01 10:47:02', 0),
(21, 1, 1, 4, 2017, 1, '2017-08-01 10:49:47', 0),
(22, 1, 1, 2, 2017, 0, '2017-08-01 11:19:18', 0),
(23, 1, 1, 4, 2017, 0, '2017-08-01 11:19:41', 0),
(24, 1, 1, 7, 2017, 0, '2017-08-01 11:44:21', 0),
(28, 1, 1, 8, 2017, 0, '2017-08-30 17:15:02', 0),
(38, 2, 1, 7, 2017, 1, '2017-09-05 12:37:09', 1),
(39, 2, 1, 8, 2017, 1, '2017-09-05 12:37:30', 1),
(40, 2, 1, 7, 2017, 0, '2017-09-07 18:49:50', 1),
(41, 1, 1, 9, 2017, 1, '2017-09-27 17:18:17', 0),
(42, 1, 1, 9, 2017, 0, '2017-09-27 17:23:33', 0),
(45, 2, 1, 8, 2017, 0, '2017-10-09 09:42:48', 1),
(46, 2, 1, 6, 2017, 0, '2017-10-09 09:43:41', 1),
(47, 2, 1, 5, 2017, 0, '2017-10-09 09:44:24', 1),
(48, 2, 1, 10, 2017, 0, '2017-10-09 09:50:14', 1),
(49, 2, 1, 9, 2017, 0, '2017-10-09 09:52:59', 1),
(50, 2, 1, 9, 2017, 1, '2017-10-09 09:55:54', 1),
(51, 2, 1, 6, 2017, 1, '2017-10-09 09:57:32', 1),
(52, 2, 1, 5, 2017, 1, '2017-10-09 09:58:02', 1),
(53, 2, 1, 10, 2017, 1, '2017-10-09 10:01:29', 1),
(54, 1, 1, 10, 2017, 0, '2017-10-31 11:41:15', 0),
(56, 1, 1, 10, 2017, 1, '2017-10-31 12:54:51', 0),
(57, 1, 1, 11, 2017, 0, '2017-11-29 12:47:27', 0),
(58, 1, 1, 11, 2017, 1, '2017-11-29 12:48:12', 0),
(59, 3, 2, 3, 2017, 1, '2017-07-07 14:52:22', 1),
(60, 3, 2, 3, 2017, 0, '2017-07-07 15:08:18', 1),
(61, 3, 2, 5, 2017, 0, '2017-07-07 15:09:58', 1),
(62, 3, 2, 6, 2017, 0, '2017-07-10 15:40:05', 1),
(63, 3, 2, 6, 2017, 1, '2017-07-30 14:13:06', 1),
(64, 3, 2, 2, 2017, 1, '2017-07-31 17:28:07', 1),
(65, 3, 2, 7, 2017, 1, '2017-07-31 18:09:30', 1),
(66, 3, 2, 5, 2017, 1, '2017-08-01 10:47:02', 1),
(67, 3, 2, 4, 2017, 1, '2017-08-01 10:49:47', 1),
(68, 3, 2, 2, 2017, 0, '2017-08-01 11:19:18', 1),
(69, 3, 2, 4, 2017, 0, '2017-08-01 11:19:41', 1),
(70, 3, 2, 7, 2017, 0, '2017-08-01 11:44:21', 1),
(71, 3, 2, 8, 2017, 0, '2017-08-30 17:15:02', 1),
(72, 4, 2, 7, 2017, 1, '2017-09-05 12:37:09', 1),
(73, 4, 2, 8, 2017, 1, '2017-09-05 12:37:30', 1),
(74, 4, 2, 7, 2017, 0, '2017-09-07 18:49:50', 1),
(75, 3, 2, 9, 2017, 1, '2017-09-27 17:18:17', 1),
(76, 3, 2, 9, 2017, 0, '2017-09-27 17:23:33', 1),
(77, 4, 2, 8, 2017, 0, '2017-10-09 09:42:48', 1),
(78, 4, 2, 6, 2017, 0, '2017-10-09 09:43:41', 1),
(80, 4, 2, 5, 2017, 0, '2017-10-09 09:44:24', 1),
(81, 4, 2, 10, 2017, 0, '2017-10-09 09:50:14', 1),
(82, 4, 2, 9, 2017, 0, '2017-10-09 09:52:59', 1),
(83, 4, 2, 9, 2017, 1, '2017-10-09 09:55:54', 1),
(84, 4, 2, 6, 2017, 1, '2017-10-09 09:57:32', 1),
(85, 4, 2, 5, 2017, 1, '2017-10-09 09:58:02', 1),
(86, 4, 2, 10, 2017, 1, '2017-10-09 10:01:29', 1),
(87, 3, 2, 10, 2017, 0, '2017-10-31 11:41:15', 1),
(88, 3, 2, 10, 2017, 1, '2017-10-31 12:54:51', 1),
(89, 3, 2, 11, 2017, 0, '2017-11-29 12:47:27', 1),
(90, 3, 2, 11, 2017, 1, '2017-11-29 12:48:12', 1),
(91, 3, 2, 12, 2017, 0, '2017-12-20 14:50:54', 1),
(92, 3, 2, 12, 2017, 1, '2017-12-20 14:51:15', 1),
(93, 1, 1, 12, 2017, 1, '2018-01-25 18:20:05', 0),
(94, 1, 1, 12, 2017, 0, '2018-01-27 11:58:22', 0),
(95, 1, 1, 1, 2018, 0, '2018-02-20 15:43:35', 0),
(96, 1, 1, 2, 2018, 0, '2018-03-01 11:18:01', 1),
(97, 1, 1, 3, 2018, 0, '2018-03-27 12:27:10', 1),
(98, 1, 1, 4, 2018, 0, '2018-04-24 11:51:35', 1),
(99, 1, 1, 5, 2018, 0, '2018-06-26 15:09:03', 1),
(100, 1, 1, 6, 2018, 0, '2018-07-04 12:28:43', 1),
(101, 1, 1, 7, 2018, 0, '2018-10-02 12:52:41', 1),
(102, 1, 1, 9, 2018, 0, '2018-12-26 12:27:46', 1),
(103, 1, 1, 10, 2018, 0, '2018-12-26 12:31:28', 1),
(104, 1, 1, 11, 2018, 0, '2018-12-26 12:33:15', 1),
(105, 1, 1, 12, 2018, 0, '2019-01-01 15:31:01', 1),
(106, 1, 1, 1, 2019, 0, '2019-02-03 13:50:16', 1),
(107, 1, 1, 2, 2019, 0, '2019-04-01 12:08:14', 1),
(108, 1, 1, 4, 2019, 0, '2019-05-23 13:13:22', 1),
(109, 1, 1, 5, 2019, 0, '2019-07-02 12:37:15', 1);
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 */;
