-- 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 `publications`
--

CREATE TABLE `publications` (
  `publications_id` int(11) NOT NULL,
  `language_id` smallint(6) NOT NULL DEFAULT '1',
  `date` date DEFAULT NULL,
  `heading` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `added_on_date` datetime DEFAULT NULL,
  `status` smallint(6) DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publications`
--

INSERT INTO `publications` (`publications_id`, `language_id`, `date`, `heading`, `added_on_date`, `status`) VALUES
(2, 1, '2015-06-25', 'Awards Publication 2015', '2017-08-11 11:37:25', 1),
(3, 1, '2014-09-19', 'Awards Publication 2014', '2017-08-11 11:37:37', 1),
(4, 1, '2013-08-21', 'Awards Publication 2013', '2017-08-11 11:38:00', 1),
(5, 1, '2016-05-26', 'Awards Publication 2016', '2017-08-11 11:45:23', 1),
(8, 1, '2017-01-01', 'Energy Elders -  Outlook 2020', '2017-08-11 20:25:51', 1),
(9, 1, '2016-12-31', 'Energy Elders - Special Report 2020', '2017-08-11 20:26:41', 1),
(10, 2, '2015-06-25', 'Awards Publication 2015', '2017-08-11 11:37:25', 1),
(11, 2, '2014-09-19', 'Awards Publication 2014', '2017-08-11 11:37:37', 1),
(12, 2, '2013-08-21', 'Awards Publication 2013', '2017-08-11 11:38:00', 1),
(13, 2, '2016-05-26', 'Awards Publication 2016', '2017-08-11 11:45:23', 1),
(14, 2, '2017-01-01', 'Energy Elders -  Outlook 2020', '2017-08-11 20:25:51', 1),
(15, 2, '2016-12-31', 'Energy Elders - Special Report 2020', '2017-08-11 20:26:41', 1),
(21, 1, '2018-05-30', 'Sustainable Development Goals and Energy Nexus', '2018-06-06 11:23:01', 1),
(20, 1, '2018-06-01', 'Awards Publication - 2018', '2018-06-06 10:44:44', 1),
(22, 1, '2018-02-27', 'CEO Roundtable Series - February - Energy Efficiency: Best Strategies to Leverage Oil and Gas Production in the Gulf?', '2018-06-12 10:43:32', 1),
(23, 1, '2018-12-28', 'Annual Report - 2018', '2019-04-22 14:08:27', 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 */;
