-- MySQL dump 10.16  Distrib 10.1.46-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: steelmin_sktc
-- ------------------------------------------------------
-- Server version	10.1.46-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbl_global_dom_master`
--

DROP TABLE IF EXISTS `tbl_global_dom_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_global_dom_master` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `category` varchar(50) NOT NULL,
  `sub_category` varchar(50) NOT NULL,
  `item` varchar(50) NOT NULL,
  `commodity` varchar(50) NOT NULL,
  `first_col` varchar(150) NOT NULL,
  `f_heading` varchar(255) NOT NULL,
  `region` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `supplier` varchar(50) NOT NULL,
  `f_grade` varchar(50) NOT NULL,
  `f_size` varchar(50) NOT NULL,
  `chemical_composition` varchar(100) NOT NULL,
  `delivery_terms` varchar(150) NOT NULL,
  `payment` varchar(50) NOT NULL,
  `quantity` varchar(15) NOT NULL DEFAULT 'USD',
  `delivery_period` varchar(100) NOT NULL,
  `taxes` varchar(150) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `assessment` varchar(20) NOT NULL,
  `flag` varchar(50) NOT NULL,
  `remarks` varchar(60) NOT NULL,
  `equivalent_GCV` varchar(255) NOT NULL,
  `first_row` varchar(255) NOT NULL,
  `second_row` varchar(255) NOT NULL,
  `day_update` varchar(20) NOT NULL,
  `excel_dnld_for_comp` varchar(5) NOT NULL,
  `sticky_header_value` varchar(100) NOT NULL,
  `f_keywords` varchar(100) NOT NULL,
  `taxes_b4_1_7_2017` varchar(255) NOT NULL,
  `f_url` varchar(100) NOT NULL,
  `f_short_url` varchar(100) NOT NULL,
  `show_in_app_mapview` int(1) NOT NULL,
  `region_of_country` varchar(200) NOT NULL,
  `category_new` varchar(100) NOT NULL,
  `sub_category_new` varchar(100) NOT NULL,
  `item_new` varchar(100) NOT NULL,
  `commodity_new` varchar(100) NOT NULL,
  `lat_long_for_map_in_app` varchar(30) NOT NULL,
  `parentID` int(7) NOT NULL,
  `source` varchar(255) NOT NULL DEFAULT ' listing,home,MapView,commoditywise,regionwise ',
  `platform` varchar(7) NOT NULL DEFAULT 'web',
  `commodityID` int(5) NOT NULL,
  `subCommodityID` int(5) NOT NULL,
  `cityID` int(5) NOT NULL,
  `regionID` int(5) NOT NULL,
  `title` varchar(150) NOT NULL,
  `subSubCommodityID` int(11) NOT NULL,
  `f_methodology` text NOT NULL,
  `publication_day_time` varchar(100) NOT NULL,
  `showOnlyInSteelmint` tinyint(1) NOT NULL DEFAULT '1',
  `view_more_text` varchar(50) NOT NULL,
  `continue_or_discontinue` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1->show in FE; 0=>don''t show in FE',
  `discontinue_but_update_prices` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=>don''t show in web/app + can''t update prices in BE; 1=> don''t show in web/app BUT can update prices in BE',
  `assessmentText` varchar(10) NOT NULL,
  `download_header1` varchar(255) NOT NULL,
  `download_header2` varchar(255) NOT NULL,
  `commodty_name` varchar(20) NOT NULL,
  `sub_commodty_name` varchar(20) NOT NULL,
  `sub_sub_commodty_name` varchar(20) NOT NULL,
  `sticky_header_value_bkup` varchar(50) NOT NULL,
  `rationale` text NOT NULL,
  `rational_publish_date` datetime NOT NULL,
  `rationale_title` varchar(200) NOT NULL,
  `tabname` varchar(50) NOT NULL,
  `countryID` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `sub_category` (`sub_category`,`item`),
  KEY `id_2` (`id`,`source`,`platform`),
  KEY `showOnlyInSteelmint` (`showOnlyInSteelmint`),
  KEY `continue_or_discontinue` (`continue_or_discontinue`)
) ENGINE=MyISAM AUTO_INCREMENT=3017 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_global_dom_master`
--

LOCK TABLES `tbl_global_dom_master` WRITE;
/*!40000 ALTER TABLE `tbl_global_dom_master` DISABLE KEYS */;
INSERT INTO `tbl_global_dom_master` VALUES (3001,'Scrap','Melting Scrap','H2','Melting Scrap','Japan Export','Melting Scrap, FOB Tokyo Bay, Japan','','','Tokyo','','','H2, 3-6mm thick','','FoB Japan','Against L/C','5,000 MT bulk','Within 3-4 week','','YEN','D','','','','','','','','Melting Scrap','','','','',0,'Japan','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,2941,297,'',0,'','',1,'',1,1,'Weekly','Tokyo','FoB Japan','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',122),(3002,'Scrap','Melting Scrap','H2','Melting Scrap','Tokyo Steel H2 scrap purchase price at Utsunomiya','Melting Scrap, Tokyo Steel DAP Utsunomiya, Japan','','','Tokyo','','','H2, 3-6mm thick','','DAP Utsunomiya (Japan)','Regular','As per company ','Immediate','','YEN','D','','','','','','','','Melting Scrap','','','','',0,'Japan','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,2941,297,'',0,'','',1,'View plant wise prices',1,1,'Daily','Tokyo','DAP Utsunomiya (Japan)','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',122),(3003,'Scrap','Melting Scrap','SB','Melting Scrap','Tokyo Steel Shindachi Bara scrap purchase price at Utsunomiya','Shindachi Scrap, Tokyo Steel DAP Utsunomiya, Japan','','','Tokyo','','Shidanchi Bara','','','DAP Utsunomiya (Japan)','Regular','As per company ','Immediate','','YEN','D','','','','','','','','Melting Scrap','','','','',0,'Japan','','Scrap','','','',3002,'commoditywise,regionwise,listing','web,app',410,439,2941,297,'',0,'','',1,'',1,1,'Daily','Tokyo','Shidanchi Bara,DAP Utsunomiya (Japan)','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',122),(3004,'Scrap','Melting Scrap','H2','Melting Scrap','Tokyo Steel H2 scrap purchase price at Tahara','Melting Scrap, Tokyo Steel DAP Tahara, Japan','','','Tokyo','','','H2, 3-6mm thick','','DAP Tahara (Japan)','Regular','As per company ','Immediate','','YEN','D','','','','','','','','Melting Scrap','','','','',0,'Japan','','Scrap','','','',3002,'commoditywise,regionwise,listing','web,app',410,439,2941,297,'',0,'','',1,'',1,1,'Daily','Tokyo','DAP Tahara (Japan)','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',122),(3005,'Scrap','Melting Scrap','H2','Melting Scrap','Kanto Tetsugen tender, Japan Export','Melting Scrap, Kanto Tetsugen Tender, FAS Japan','','','Tokyo','','','H2, 3-6mm thick','','FAS Japan','Against L/C','5,000 MT bulk','Within 3-5 week','','YEN','M','','','','','','','','Melting Scrap','','','','',0,'Japan','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,2941,297,'',0,'','',1,'',1,1,'Monthly','Tokyo','FAS Japan','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',122),(3006,'Scrap','Melting Scrap','HMS','Melting Scrap','Feng Hsin HMS scrap purchase price at Taichung','Melting Scrap, Feng Hsin DAP Taichung, Taiwan','','','Taichung','','','HMS 1&2 (80:20)','','DAP Taichung (Taiwan)','Against L/C','','Within 2-4 week','','TWD','D','','','','','','','','Melting Scrap','','','','',0,'Taiwan','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,13900,297,'',0,'','',1,'',1,1,'Daily','Taichung','DAP Taichung (Taiwan)','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',236),(3007,'Scrap','Melting Scrap','HMS','Melting Scrap','Shagang Steel scrap purchase','Melting Scrap, Shagang Steel DAP Jiangsu, China','','','Jiangsu','','HMS 6-10 mm','','','DAP Jiangsu (China)','Against L/C','5,000 MT bulk','Within 3-5 week','','RMB','D','','','','','','','','Melting Scrap','','','','',0,'China','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,15504,49,'',0,'','',1,'',1,1,'Daily','Jiangsu','HMS 6-10 mm,DAP Jiangsu (China)','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',49),(3008,'Semi Finished','Billet','Billet','Billet','Dhaka,100*100,ASTM A 615/ G 400','','Bangladesh','','Dhaka','','ASTM A 615/ G 400','100*100','C:0.15-0.25, Mn:0.40-0.50','Ex- Works, Chittagong','Against L/C','1,00 MT','Immediate','Including local taxes @ 15%','BDT','W','Bangladesh','Induction Grade','','','100*100','tuesday','','Billet/Bloom/Ingot','','','','',0,'Bangladesh','Semi Finished','Billet','','','',0,'commoditywise,regionwise,listing','web,app',413,448,772,296,'',471,'','',1,'',0,0,'Weekly','Dhaka','ASTM A 615/ G 400,100*100','Steel','Semi Finished','Billet/Bloom/Ingot','Billet','','0000-00-00 00:00:00','','',20),(3009,'Semi Finished','Billet','Billet','Billet','Karachi,100*100,ASTM A 615M Grade 60','','Pakistan','','Karachi','','ASTM A 615M Grade 60','100*100','C:0.15-0.25, Mn:0.40-0.50','Ex- Works, Karachi','Against L/C','1,00 MT','Immediate','Including Taxes','PKR','W','Pakistan','Induction Grade','','','100*100','tuesday','','Billet/Bloom/Ingot','','','','',0,'Pakistan','Semi Finished','Billet','','','',0,'commoditywise,regionwise,listing','web,app',413,448,15355,296,'',471,'','',1,'',0,0,'Weekly','Karachi','ASTM A 615M Grade 60,100*100','Steel','Semi Finished','Billet/Bloom/Ingot','Billet','','0000-00-00 00:00:00','','',187),(3010,'Semi Finished','Billet','Billet','Billet','Tangshan,150*150mm,Q235','Billet, EXW Tangshan, China','China','','Tangshan','','Q235','150*150mm','','EXW-Tangshan','Prompt','500-2000MT','','','RMB','D','','','','','','','','Billet/Bloom/Ingot','','','','',0,'China','Semi Finished','Billet','','','',0,'commoditywise,regionwise,listing','web,app',413,448,1287,49,'',471,'','',1,'',1,0,'','Tangshan','Q235,150*150mm','Steel','Semi Finished','Billet/Bloom/Ingot','Billet','','0000-00-00 00:00:00','','',49),(3011,'Scrap & Metallics','Melting Scrap','Shredded','Shredded','Shredded,','Melting Scrap,Exw Punjab, Pakistan','','','Lahore','','Shredded','','','EXW Punjab','Shredded','','','','PKR','M','Pakistan','','','','','','','Melting Scrap','','','','',0,'Pakistan','','','','','',0,'commoditywise,regionwise,listing','web,app',410,439,3653,187,'',0,'','',1,'',1,0,'Weekly','Lahore','Shredded,','Scrap & Metallics','Melting Scrap','','','','0000-00-00 00:00:00','','',187),(3012,'Semi Finished','Billet','Billet','Billet','60 CC','Billet, Exw Punjab, Pakistan','','','Lahore','','60 CC','','','EXW Punjab','','','','','PKR','M','Pakistan','','','','','','','Billet/Bloom/Ingot','','','','',0,'Pakistan','Semi Finished','Billet','','','',0,'commoditywise,regionwise,listing','web,app',413,448,3653,187,'',471,'','',1,'',1,0,'Weekly','Lahore','60 CC,','Steel','Semi Finished','Billet/Bloom/Ingot','Billet','','0000-00-00 00:00:00','','',187),(3013,'Finish Long','Rebar','Rebar','Rebar','Deformed Bar (G-60),','Rebar, Exy Punjab, Pakistan','','','Lahore','','Deformed Bar (G-60)','','','EXW Punjab','','','','','PKR','M','Pakistan','','','','','','','Rebar','','','','',0,'Pakistan','','','','','',0,'commoditywise,regionwise,listing','web,app',413,447,3653,187,'',466,'','',1,'',1,0,'Weekly','Lahore','Deformed Bar (G-60),','Steel','Finish long','Rebar','','','0000-00-00 00:00:00','','',187),(3015,'Raw material','Graphite Electrode','Graphite Electrode','Graphite Electrode','HP,450mm','Graphite Electrode, Ex-Shanxi, China','','','Shanxi','','HP','450mm','','Ex-Shanxi','Credit up to 90 days','','','','RMB','M','China','','','','','','','Graphite Electrode','','','','',0,'China','','','','','',0,'commoditywise,regionwise,listing','web,app',407,431,15545,49,'',0,'','',1,'',1,0,'Weekly','Shanxi','HP,450mm','Graphite Electrode','Graphite Electrode','','','','0000-00-00 00:00:00','','',49),(3016,'Raw material','Graphite Electrode','Graphite Electrode','Graphite Electrode','UHP,600mm','Graphite Electrode, Ex-Shanxi, China','','','Shanxi','','UHP','600mm','','Ex-Shanxi','Credit up to 90 days','','','','RMB','M','China','','','','','','','Graphite Electrode','','','','',0,'China','','','','','',0,'commoditywise,regionwise,listing','web,app',407,431,15545,49,'',0,'','',1,'',1,0,'Weekly','Shanxi','UHP,600mm','Graphite Electrode','Graphite Electrode','','','','0000-00-00 00:00:00','','',49),(3014,'Scrap','Melting Scrap','Shipyard scrap','Shipyard scrap','Shipyard melting scrap,Exy Chittagong','Ship Breaking, Exy Chittagong, Bangladesh','','','Chittagong','','Ship breaking','','','EXW Chittagong','','','','','BDT','M','Bangladesh','','','','','','','Melting Scrap','','','','',0,'Bangladesh','','Scrap','','','',0,'commoditywise,regionwise,listing','web,app',410,439,14610,20,'',0,'','',1,'',1,1,'Weekly','Chittagong','Shipyard melting scrap,Ex Yard','Scrap & Metallics','Melting Scrap','','Melting Scrap','','0000-00-00 00:00:00','','',20);
/*!40000 ALTER TABLE `tbl_global_dom_master` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-09-25 15:20:39