-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 24, 2020 at 04:08 AM
-- Server version: 5.6.41-84.1-log
-- PHP Version: 7.2.7

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: `acmaig3n_acmalive`
--

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

--
-- Table structure for table `doc_manager`
--

CREATE TABLE `doc_manager` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `doc` text NOT NULL,
  `uploaddate` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `docyear` int(11) NOT NULL,
  `sort` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `doc_manager`
--

INSERT INTO `doc_manager` (`id`, `title`, `doc`, `uploaddate`, `subject`, `docyear`, `sort`) VALUES
(16, 'Automotive Deals FY 2018', 'Automotive_Deals_FY2018.pdf', '23-05-2019', 4, 2018, 1),
(98, 'ACMA Pre Budget Memorandum for Union Budget 2019_20', 'ACMA Pre Budget Memorandum for Union Budget2019_20_20th_May_2019.pdf', '08-07-2019', 6, 2019, 1),
(70, 'Vision 2020_2010', 'Vision 2020_2010.pdf', '10-06-2019', 12, 2010, 1),
(115, 'Budget Speech 2019', 'Budget Speech_2019.pdf', '08-07-2019', 6, 2019, 5),
(116, 'Memorandum Provisions Finance Bill 2019', 'Memorandum_Provisions_Finance_Bill_2019.pdf', '08-07-2019', 6, 2019, 6),
(190, 'Commodity_Price_Trends_July_2019', 'Commodity_Price_Trends_July_2019.pdf', '09-11-2019', 20, 2019, 16),
(189, 'Commodity_Price_Trends_July_2018', 'Commodity_Price_Trends_July_2018.pdf', '09-11-2019', 20, 2018, 1),
(180, 'Charging Infra guidelines_oct 19', 'Charging_Infrastructure_for_Electric_Vehicles _Revised_Guidelines_Standards_Ministry of Power.pdf', '31-10-2019', 19, 2019, 6),
(181, 'Tax Alert October 2019', '', '06-11-2019', 13, 2019, 19),
(182, 'Commodity_Price_September_2019', 'Commodity_Price_September_2019.pdf', '08-11-2019', 20, 2019, 18),
(183, 'Commodity_Price_Trends_April_2018', 'Commodity_Price_Trends_April_2018.pdf', '8-11-2019', 20, 2018, 1),
(184, 'Commodity_Price_Trends_August_2018', 'Commodity_Price_Trends_August_2018.pdf', '09-11-2019', 20, 2018, 1),
(185, 'Commodity_Price_Trends_August_2019', 'Commodity_Price_Trends_August_2019.pdf', '09-11-2019', 20, 2019, 17),
(186, 'Commodity_Price_Trends_December_2018', 'Commodity_Price_Trends_December_2018.pdf', '09-11-2019', 20, 2018, 1),
(187, 'Commodity_Price_Trends_February_2019', 'Commodity_Price_Trends_February_2019.pdf', '09-11-2019', 20, 2019, 6),
(188, 'Commodity_Price_Trends_January_2019', 'Commodity_Price_Trends_January_2019.pdf', '09-11-2019', 20, 2019, 7),
(113, 'Press Release on pre budget recommendations 2019', 'Press_Release_on_pre budget_recommendations_2019.pdf', '08-07-2019', 6, 2019, 3),
(99, 'ACMA Presentation to Ministry of Finance', 'ACMA Presentation to Ministry of Finance.pdf', '08-07-2019', 6, 2019, 2),
(128, 'Financial Analysis FY17', 'ACMA_Financial analysis_FY17.pdf', '09-07-2019', 10, 2017, 1),
(129, 'Financial analysis Q1 FY18', 'ACMA_Financial analysis_Q1 FY18.pdf', '09-07-2019', 10, 2018, 2),
(130, 'Financial analysis Q3 FY18', 'ACMA_Financial analysis_Q3 FY18.pdf', '09-07-2019', 10, 2018, 3),
(133, 'Financial analysis Q2 FY19', 'ACMA_Financial analysis_Q2 FY19.pdf', '09-07-2019', 10, 2018, 6),
(117, 'Automotive - Budget Update by EY', 'Automotive - Budget Update.pdf', '08-07-2019', 6, 2019, 7),
(84, 'OEM Financial_Analysis and Utilisation FY 17', 'Financial_Analysis_and_Utilisation_FY_17.pdf', '19-06-2019', 11, 2017, 0),
(132, 'Financial analysis Q1 FY19', 'ACMA_Financial analysis_Q1 FY19.pdf', '09-07-2019', 10, 2018, 5),
(85, 'OEM Financial Analysis and Utilisation FY 18', 'Financial_Analysis_and_Utilisation_View_FY18.pdf', '19-06-2019', 11, 2018, 0),
(46, 'Annual Vehicle Performance FY19', 'Annual_Vehicle_Performance_FY19.pdf', '23-05-2019', 18, 2019, 0),
(88, 'Quarterly Vehicle Performance Q1 FY 19', 'Quarterly_Vehicle_Performance_Q1_FY19.pdf', '19-06-2019', 16, 2018, 0),
(89, 'Quarterly Vehicle Performance Q2 FY 19', 'Quarterly_Vehicle_Performance_Q2_FY19.pdf', '19-06-2019', 16, 2018, 0),
(96, 'Tax and Regulatory Alert May 2019', 'ACMA Tax and Regulatory Alert_May_2019.pdf', '28-06-2019', 13, 2019, 14),
(50, 'Tax and Regulatory Alert April 2018', 'Tax_and_Regulatory_Alert_April_2018.pdf', '23-05-2019', 13, 2018, 1),
(51, 'Tax and Regulatory Alert May 2018', 'Tax_and_Regulatory_Alert_May_2018.pdf', '23-05-2019', 13, 2018, 2),
(54, 'Tax and Regulatory Alert July 2018', 'Tax_and_Regulatory_Alert_July_2018.pdf', '23-05-2019', 13, 2018, 3),
(53, 'Tax and Regulatory Alert June2018', 'Tax_and_Regulatory_Alert_June_2018.pdf', '23-05-2019', 13, 2018, 4),
(55, 'Tax and Regulatory Alert Aug 2018', 'Tax_and_Regulatory_Alert_August_2018.pdf', '23-05-2019', 13, 2018, 5),
(56, 'Tax and Regulatory Alert Sept 2018', 'Tax_and_Regulatory_Alert_September_2018.pdf', '23-05-2019', 13, 2018, 6),
(57, 'Tax and Regulatory Alert Oct 2018', 'Tax_and_Regulatory_Alert_October_2018.pdf', '23-05-2019', 13, 2018, 7),
(58, 'Tax and Regulatory Alert Nov 2018', 'Tax_and_Regulatory_Alert_November_2018.pdf', '23-05-2019', 13, 2018, 8),
(59, 'Tax and Regulatory Alert Dec 2018', 'Tax_and_Regulatory_Alert_December_2018.pdf', '23-05-2019', 13, 2018, 9),
(60, 'Tax and Regulatory Alert Jan 2019', 'Tax_and_Regulatory_Alert_January_2019.pdf', '23-05-2019', 13, 2019, 10),
(61, 'Tax and Regulatory Alert Feb 2019', 'Tax_and_Regulatory_Alert_February_2019.pdf', '23-05-2019', 13, 2019, 11),
(62, 'Tax and Regulatory Alert March 2019', 'Tax_and_Regulatory_Alert_March_2019.pdf', '23-05-2019', 13, 2019, 12),
(63, 'Tax and Regulatory Alert April 2019', 'Tax_and_Regulatory_Alert_April_2019.pdf', '23-05-2019', 13, 2019, 13),
(154, 'CMVR Technical Standing Committee Minutes', 'MOM_ 56_CMVR-TSC.PDF', '09-10-2019', 17, 2019, 1),
(173, 'GazetteNotification19_Vehicle eligibility for Electric Bus and 4ws', 'GazetteNotification19_Vehicle eligibility for Electric Bus and 4ws.pdf', '23-10-2019', 19, 2019, 3),
(174, 'Inst on Govt Purchases through Tender FAME_II_till 30 sept 19', 'Inst on Govt Purchases through Tender FAME_II_till 30 sept 19.pdf', '23-10-2019', 19, 2019, 4),
(71, 'Growing Beyond Manfuacturing_E&Y_2012', 'Growing Beyond Manfuacturing_E&Y_2012.pdf', '10-06-2019', 12, 2012, 2),
(72, 'High Performance in Turbulent Times_2013', 'High Performance in Turbulent Times_2013.pdf', '10-06-2019', 12, 2013, 3),
(73, 'China_Study_November_2015', 'China_Study_November_2015.pdf', '10-06-2019', 12, 2015, 4),
(74, 'Automotive_Electronics_Study_August_2016', 'Automotive_Electronics_Study_August_2016.pdf', '10-06-2019', 12, 2016, 5),
(75, 'FTA study_August 2017', 'FTA study_August 2017.pdf', '10-06-2019', 12, 2017, 6),
(76, 'Globalization Study - September 2018', 'Globalization Study - September 2018.pdf', '10-06-2019', 12, 2018, 7),
(77, 'EV Study_2018', 'EV Study_2018.pdf', '10-06-2019', 12, 2018, 8),
(78, 'Final_Digital Transformation Road Map for India\'s Automotive Industry_2019', 'Final_Digital Transformation Road Map for India\'s Automotive Industry_2019', '10-06-2019', 12, 2019, 9),
(175, 'Revised- Expression of Interest_28Aug', 'Revised- Expression of Interest_28Aug.pdf', '23-10-2019', 19, 2019, 5),
(137, 'Export-Import Analysis April-September FY 19', 'ACMA_April_September_FY19.pdf', '15-07-2019', 8, 2018, 3),
(131, 'Financial analysis FY18', 'ACMA_financial analysis_FY18.pdf', '09-07-2019', 10, 2018, 4),
(114, 'Press Statement Post Budget 2019', 'Press_Statement_Post_Budget_2019.pdf', '08-07-2019', 6, 2019, 4),
(170, 'ACMA / DHI EV Report ', 'ACMA_DHI_EV Study on Electric Mobility.pdf', '18-10-2019', 7, 2019, 19),
(97, 'Tax and Regulatory Alert June 2019', 'ACMA Tax and Regulatory Alert_June_2019.pdf', '28-06-2019', 13, 2019, 15),
(171, 'FAME II Notifications & Guidelines', 'FAME II Notifications and guidelines.pdf', '23-10-2019', 19, 2019, 1),
(118, 'Budget Highlights EY', 'Budget_Highlights_EY.PDF', '08-07-2019', 6, 2019, 8),
(119, 'Budget Analysis EY', '', '08-07-2019', 6, 2019, 9),
(124, 'Budget Analysis Crisil', 'Budget_Analysis_Crisil.pdf', '08-07-2019', 6, 2019, 10),
(125, 'Key Indirect Tax changes-Automotive Sector', 'The key Indirect Tax changes pertaining to the Automobile sector (1).pdf', '08-07-2019', 6, 2019, 11),
(126, 'Key Highlights of Economic Survey 2018-19', 'Key Highlights of Economic Survey 2018-19.pdf', '08-07-2019', 6, 2019, 12),
(134, 'Financial analysis Q3 FY19', 'ACMA_Financial analysis_Q3 FY19.pdf', '09-07-2019', 10, 2019, 7),
(135, 'Export-Import Analysis FY 18', 'EXIM_FY18.pdf', '15-07-2019', 8, 2018, 1),
(136, 'Export-Import Analysis April-June FY 19', 'EXIM_April_June_FY19.pdf', '15-07-2019', 8, 2018, 2),
(138, 'Export-Import Analysis April-December FY 19', 'EXIM_April_December_FY19.pdf', '15-07-2019', 8, 2019, 4),
(139, 'Automotive Deals Q1 FY19', 'Automotive_Deals_Q1_FY19.pdf', '15-08-2019', 4, 2019, 2),
(140, 'Automotive Deals Q2FY19', 'Automotive_Deals_Q2FY19.pdf', '15-08-2019', 4, 2019, 3),
(141, 'Automotive Deals Q3FY19', 'Automotive_Deals_Q3FY19.pdf', '15-08-2019', 4, 2019, 4),
(142, 'Vehicle_Performace Report Q1 FY2020', 'Vehicle_Performace_Report_Q1_FY2020.pdf', '15-08-2019', 16, 2019, 1),
(143, 'Tax Alert July 2019', 'Tax_Alert_July_2019.pdf', '15-08-2019', 13, 2019, 16),
(155, 'Exim Report FY19', 'Exim_Report_FY19.pdf', '10-10-2019', 8, 2019, 5),
(149, 'Quarterly Forecasting February 2019', 'Quarterly_Forecasting_February_2019.pdf', '15-08-2019', 15, 2019, 1),
(156, 'Automotive Deals Fy 2019', 'Automotive_Deals_Fy2019.pdf', '10-10-2019', 4, 2019, 5),
(150, 'Quarterly Forecasting April 2019', 'Quarterly_Forecasting_April_2019.pdf', '15-08-2019', 15, 2019, 2),
(151, 'Quarterly Forecasting July 2019', 'Quarterly_Forecasting_July_2019.pdf', '15-08-2019', 15, 2019, 3),
(160, 'Tax Alert August 2019', 'Tax_Alert_August_2019.pdf', '10-10-2019', 13, 2019, 17),
(161, 'Tax Alert September 2019', 'Tax_Alert_September_2019.pdf', '10-10-2019', 13, 2019, 18),
(164, 'EV Study_2019', 'EV_Report_Fy19.pdf', '16-10-2019', 7, 2019, 18),
(172, 'FAME II- Sanction of electric buses_Press release', 'FAME II- Sanction of electric buses_Press release.pdf', '23-10-2019', 19, 2019, 2),
(191, 'Commodity_Price_Trends_June_2018', 'Commodity_Price_Trends_June_2018.pdf', '09-11-2019', 20, 2018, 1),
(192, 'Commodity_Price_Trends_June_2018', 'Commodity_Price_Trends_June_2018.pdf', '09-11-2019', 20, 2018, 1),
(193, 'Commodity_Price_Trends_June_2019', 'Commodity_Price_Trends_June_2019.pdf', '09-11-2019', 20, 2019, 14),
(194, 'Commodity_Price_Trends_March_2019', 'Commodity_Price_Trends_March_2019.pdf', '09-11-2019', 20, 2019, 13),
(195, 'Commodity_Price_Trends_May_2018', 'Commodity_Price_Trends_May_2018.pdf', '09-11-2019', 20, 2018, 1),
(196, 'Commodity_Price_Trends_November_2018', 'Commodity_Price_Trends_November_2018.pdf', '09-11-2019', 20, 2018, 1),
(197, 'Commodity_Price_Trends_October_2018', 'Commodity_Price_Trends_October_2018.pdf', '09-11-2019', 20, 2018, 1),
(198, 'Commodity_Price_Trends_September_2018', 'Commodity_Price_Trends_September_2018.pdf', '09-11-2019', 20, 2018, 1),
(199, 'Commodity_Prices_May_2019', 'Commodity_Prices_May_2019.pdf', '09-11-2019', 20, 2019, 18),
(200, 'Quarterly Vehicle Forecast October  2019', 'Analysis of Automotive Industry - Oct 2019.pdf', '12-11-2019', 15, 2019, 4),
(201, 'Quarterly Vehicle Forecast October  2019', '', '12-11-2019', 15, 2019, 5),
(202, 'Quarterly Vehicle Forecast October  2019', '', '12-11-2019', 15, 2019, 6),
(203, 'Quarterly Vehicle Forecast October  2019', '', '12-11-2019', 15, 2019, 7),
(204, 'Quarterly Vehicle Forecast October  2019', '', '12-11-2019', 15, 2019, 8),
(205, 'Commodity Price Trends October 2019', 'ACMA_Commodity_Prices_October_2019.pdf', '04-12-2019', 20, 2019, 19),
(208, 'ACMA Deals Newsletter Q1 FY20', 'ACMA_Deals_Newsletter_Q1_FY20.pdf', '06-12-2019', 4, 2019, 6),
(207, 'Tax and Regulatory November 2019', 'Tax and Regulatory November 2019.pdf', '06-12-2019', 13, 2019, 20),
(209, 'Quarterly vehicle sales report Q2 FY20', 'Quarterly_vehicle_sales_report_ Q2_FY20.pdf', '06-12-2019', 16, 2019, 2),
(214, 'Commodity Price Trends November 2019', 'ACMA_Commodity Prices_November 2019.pdf', '09-01-2020', 20, 2019, 20),
(215, 'Financial analysis Q1 FY20', 'ACMA_Financial analysis_Q1 FY20_Final.pdf', '09-01-2020', 10, 2019, 8),
(216, 'Tax Alert December 2019', 'ACMA Tax and Regulatory December 2019.pdf', '09-01-2020', 13, 2019, 21),
(217, 'ACMA_Commodity_Prices_December_2019', 'ACMA_Commodity_Prices_December_2019.pdf', '08-02-2020', 20, 2020, 21),
(218, 'ACMA_Commodity Price December 2019', 'ACMA_Commodity_Prices_December_2019.pdf', '08-02-2020', 20, 2020, 22),
(219, 'Quarterly vehicle sales report Q3 FY20', 'ACMA_Quarterly_Vehicle_Sales_Report_Q3_FY20.pdf', '08-02-2020', 16, 2020, 3),
(220, 'Quarterly vehicle sales report Q3 FY20', 'ACMA_Quarterly_Vehicle_Sales_Report_Q3_FY20.pdf', '08-02-2020', 16, 2020, 4),
(221, 'ACMA Commodity Price December 2019', 'ACMA_Commodity_Prices_December_2019.pdf', '08-02-2020', 20, 2020, 23),
(222, 'Quarterly vehicle sales report Q3 FY20', 'ACMA_Quarterly_Vehicle_Sales_Report_Q3_FY20.pdf', '08-02-2020', 15, 2020, 9),
(223, 'ACMA Commodity Price December 2019', 'ACMA_Commodity_Prices_December_2019.pdf', '08-02-2020', 20, 2020, 24),
(224, 'Tax Alert January 2020', 'Tax_and_Regulatory_January_2020_Final.pdf', '08-02-2020', 13, 2020, 22),
(225, 'LightWeighting ', 'WhitePaper-LightWeighting_prepared by IHS.pdf', '18-02-2020', 12, 2019, 10),
(226, 'Vehicle Forecast_January_2020', 'Vehicle Forecast_January_2020.pdf', '02-03-2020', 15, 2020, 10),
(227, 'January 2020_Commodity Price', 'January 2020_Commodity Price.pdf', '02-03-2020', 20, 2020, 25),
(228, 'February_2020_Tax_and_Regulatory Alert', 'February_2020_Tax_and_Regulatory Alert.pdf', '02-03-2020', 13, 2020, 23),
(229, '9M_FY20_EXIM_Report', '9M_FY20_EXIM_Report.pdf', '02-03-2020', 8, 2020, 6),
(230, 'Circular 1_PBM_Seeking Inputs from Members_24th August_2019', 'Circular 1_PBM_Seeking Inputs from Members_24th August_2019.pdf', '10-03-2020', 6, 2019, 13),
(231, 'Circular_2_PBM_Seeking Inputs from Members_24th September 2019', 'Circular_2_PBM_Seeking Inputs from Members_24th September 2019.pdf', '10-03-2020', 6, 2019, 14),
(232, 'ACMA_PBM_2020_2021_21st November 2019', 'ACMA_PBM_2020_2021_21st November 2019.pdf', '10-03-2020', 6, 2019, 15),
(233, 'ACMA PBM Presentation to MOF_2nd December 2019', 'ACMA PBM Presentation to MOF_2nd December 2019.pdf', '10-03-2020', 6, 2019, 16),
(234, 'ACMA PBM Presentation to DHI_17th December 2019', 'ACMA PBM Presentation to DHI_17th December 2019.pdf', '10-03-2020', 6, 2019, 17),
(235, 'ACMA PBM Presentation_2019_20_BJP headquarters_2nd January 2020', 'ACMA PBM Presentation_2019_20_BJP headquarters_2nd January 2020.pdf', '10-03-2020', 6, 2020, 18),
(236, 'Circular_3_ACMA_EY_Webcast _Analysis of Union Budget 2020_2021_3rd_February_2020_4.00 pm', 'Circular_3_ACMA_EY_Webcast _Analysis of Union Budget 2020_2021_3rd_February_2020_4.00 pm.pdf', '10-03-2020', 6, 2020, 19),
(237, 'Circular_4_Budget Annoucment_5th February_2020', 'Circular_4_Budget Annoucment_5th February_2020.pdf', '10-03-2020', 6, 2020, 20),
(238, 'ACMA Press Statement Budget 2020', 'ACMA Press Statement Budget 2020.pdf', '10-03-2020', 6, 2020, 21),
(239, 'Budget_Speech', 'Budget_Speech.pdf', '10-03-2020', 6, 2020, 22),
(240, 'budget-connect-2020-tax-alert-key-amendments-impacting-auto-sector', 'budget-connect-2020-tax-alert-key-amendments-impacting-auto-sector.pdf', '10-03-2020', 6, 2020, 23),
(241, 'ey-budget-connect-2020-consolidated-tax-and-policy-alerts', 'ey-budget-connect-2020-consolidated-tax-and-policy-alerts.pdf', '10-03-2020', 6, 2020, 24),
(242, 'Key Highlights of Economic Survey 2019-20', 'Key Highlights of Economic Survey 2019-20.pdf', '10-03-2020', 6, 2020, 25);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `doc_manager`
--
ALTER TABLE `doc_manager`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `doc_manager`
--
ALTER TABLE `doc_manager`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243;
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 */;
