-
Notifications
You must be signed in to change notification settings - Fork 1
/
stockdatabase.sql
77 lines (66 loc) · 21 KB
/
stockdatabase.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
CREATE DATABASE IF NOT EXISTS `stockbot_data` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `stockbot_data`;
-- MySQL dump 10.13 Distrib 8.0.28, for Win64 (x86_64)
--
-- Host: localhost Database: stockbot_data
-- ------------------------------------------------------
-- Server version 8.0.28
/*!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 */;
/*!50503 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 `companies`
--
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies` (
`company_name` varchar(45) NOT NULL,
`ticker` varchar(45) NOT NULL,
PRIMARY KEY (`ticker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `companies`
--
LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES ('3M India Ltd.','3MINDIA'),('Aarti Drugs Ltd.','AARTIDRUGS'),('Aavas Financiers Ltd.','AAVAS'),('ABB India Ltd.','ABB'),('Abbott India Ltd.','ABBOTINDIA'),('Aditya Birla Capital Ltd.','ABCAPITAL'),('Aditya Birla Fashion and Retail Ltd.','ABFRL'),('Aditya Birla Sun Life AMC Ltd.','ABSLAMC'),('ACC Ltd.','ACC'),('Adani Enterprises Ltd.','ADANIENT'),('Adani Green Energy Ltd.','ADANIGREEN'),('Adani Ports and Special Economic Zone Ltd.','ADANIPORTS'),('Adani Transmission Ltd.','ADANITRANS'),('Advanced Enzyme Tech Ltd.','ADVENZYMES'),('Aegis Logistics Ltd.','AEGISCHEM'),('Affle (India) Ltd.','AFFLE'),('AIA Engineering Ltd.','AIAENG'),('Ajanta Pharmaceuticals Ltd.','AJANTPHARM'),('Alkem Laboratories Ltd.','ALKEM'),('Alkyl Amines Chemicals Ltd.','ALKYLAMINE'),('Allcargo Logistics Ltd.','ALLCARGO'),('Alok Industries Ltd.','ALOKINDS'),('Amara Raja Batteries Ltd.','AMARAJABAT'),('Amber Enterprises India Ltd.','AMBER'),('Ambuja Cements Ltd.','AMBUJACEM'),('Angel One Ltd.','ANGELONE'),('Anupam Rasayan India Ltd.','ANURAS'),('APL Apollo Tubes Ltd.','APLAPOLLO'),('Alembic Pharmaceuticals Ltd.','APLLTD'),('Apollo Hospitals Enterprise Ltd.','APOLLOHOSP'),('Apollo Tyres Ltd.','APOLLOTYRE'),('Aptus Value Housing Finance India Ltd.','APTUS'),('Asahi India Glass Ltd.','ASAHIINDIA'),('Ashok Leyland Ltd.','ASHOKLEY'),('Asian Paints Ltd.','ASIANPAINT'),('Aster DM Healthcare Ltd.','ASTERDM'),('Astral Ltd.','ASTRAL'),('AstraZenca Pharma India Ltd.','ASTRAZEN'),('Adani Total Gas Ltd.','ATGL'),('Atul Ltd.','ATUL'),('AU Small Finance Bank Ltd.','AUBANK'),('Aurobindo Pharma Ltd.','AUROPHARMA'),('Avanti Feeds Ltd.','AVANTIFEED'),('Axis Bank Ltd.','AXISBANK'),('Bajaj Auto Ltd.','BAJAJ-AUTO'),('Bajaj Electricals Ltd','BAJAJELEC'),('Bajaj Finserv Ltd.','BAJAJFINSV'),('Bajaj Holdings & Investment Ltd.','BAJAJHLDNG'),('Bajaj Finance Ltd.','BAJFINANCE'),('Balaji Amines Ltd.','BALAMINES'),('Balkrishna Industries Ltd.','BALKRISIND'),('Balrampur Chini Mills Ltd.','BALRAMCHIN'),('Bandhan Bank Ltd.','BANDHANBNK'),('Bank of Baroda','BANKBARODA'),('Bank of India','BANKINDIA'),('BASF India Ltd.','BASF'),('Bata India Ltd.','BATAINDIA'),('Bayer Cropscience Ltd.','BAYERCROP'),('Bombay Burmah Trading Corporation Ltd.','BBTC'),('Brightcom Group Ltd.','BCG'),('Bharat Dynamics Ltd.','BDL'),('Bharat Electronics Ltd.','BEL'),('Berger Paints India Ltd.','BERGEPAINT'),('Bharat Forge Ltd.','BHARATFORG'),('Bharti Airtel Ltd.','BHARTIARTL'),('Bharat Heavy Electricals Ltd.','BHEL'),('Biocon Ltd.','BIOCON'),('Birla Corporation Ltd.','BIRLACORPN'),('Blue Dart Express Ltd.','BLUEDART'),('Blue Star Ltd.','BLUESTARCO'),('Borosil Renewables Ltd.','BORORENEW'),('Bosch Ltd.','BOSCHLTD'),('Bharat Petroleum Corporation Ltd.','BPCL'),('Brigade Enterprises Ltd.','BRIGADE'),('Britannia Industries Ltd.','BRITANNIA'),('BSE Ltd.','BSE'),('Birlasoft Ltd.','BSOFT'),('Computer Age Management Services Ltd.','CAMS'),('Canara Bank','CANBK'),('Can Fin Homes Ltd.','CANFINHOME'),('Caplin Point Laboratories Ltd.','CAPLIPOINT'),('Carborundum Universal Ltd.','CARBORUNIV'),('Castrol India Ltd.','CASTROLIND'),('CCL Products (I) Ltd.','CCL'),('Central Depository Services (India) Ltd.','CDSL'),('Ceat Ltd.','CEATLTD'),('Central Bank of India','CENTRALBK'),('Century Plyboards (India) Ltd.','CENTURYPLY'),('Century Textile & Industries Ltd.','CENTURYTEX'),('Cera Sanitaryware Ltd','CERA'),('CESC Ltd.','CESC'),('Capri Global Capital Ltd.','CGCL'),('CG Power and Industrial Solutions Ltd.','CGPOWER'),('Chalet Hotels Ltd.','CHALET'),('Chambal Fertilizers & Chemicals Ltd.','CHAMBLFERT'),('Chemplast Sanmar Ltd.','CHEMPLASTS'),('Cholamandalam Financial Holdings Ltd.','CHOLAHLDNG'),('Cipla Ltd.','CIPLA'),('Clean Science and Technology Ltd.','CLEAN'),('Coal India Ltd.','COALINDIA'),('Cochin Shipyard Ltd.','COCHINSHIP'),('Coforge Ltd.','COFORGE'),('Colgate Palmolive (India) Ltd.','COLPAL'),('Container Corporation of India Ltd.','CONCOR'),('Coromandel International Ltd.','COROMANDEL'),('CreditAccess Grameen Ltd.','CREDITACC'),('CRISIL Ltd.','CRISIL'),('Crompton Greaves Consumer Electricals Ltd.','CROMPTON'),('CSB Bank Ltd.','CSBBANK'),('City Union Bank Ltd.','CUB'),('Cummins India Ltd.','CUMMINSIND'),('Cyient Ltd.','CYIENT'),('Dabur India Ltd.','DABUR'),('Dalmia Bharat Ltd.','DALBHARAT'),('Dilip Buildcon Ltd.','DBL'),('DCM Shriram Ltd.','DCMSHRIRAM'),('Deepak Nitrite Ltd.','DEEPAKNTR'),('Delta Corp Ltd.','DELTACORP'),('Devyani International Ltd.','DEVYANI'),('Dhani Services Ltd.','DHANI'),('Divi\'s Laboratories Ltd.','DIVISLAB'),('Dixon Technologies (India) Ltd.','DIXON'),('DLF Ltd.','DLF'),('Avenue Supermarts Ltd.','DMART'),('Dr. Reddy\'s Laboratories Ltd.','DRREDDY'),('Easy Trip Planners Ltd.','EASEMYTRIP'),('eClerx Services Ltd.','ECLERX'),('Edelweiss Financial Services Ltd.','EDELWEISS'),('Eicher Motors Ltd.','EICHERMOT'),('E.I.D. Parry (India) Ltd.','EIDPARRY'),('EIH Ltd.','EIHOTEL'),('Elgi Equipments Ltd.','ELGIEQUIP'),('Emami Ltd.','EMAMILTD'),('Endurance Technologies Ltd.','ENDURANCE'),('Engineers India Ltd.','ENGINERSIN'),('EPL Ltd.','EPL'),('Equitas Holdings Ltd.','EQUITAS'),('Equitas Small Finance Bank Ltd.','EQUITASBNK'),('Eris Lifesciences Ltd.','ERIS'),('Escorts Kubota Ltd.','ESCORTS'),('Exide Industries Ltd.','EXIDEIND'),('Fertilisers and Chemicals Travancore Ltd.','FACT'),('FDC Ltd.','FDC'),('Federal Bank Ltd.','FEDERALBNK'),('Finolex Cables Ltd.','FINCABLES'),('Fine Organic Industries Ltd.','FINEORG'),('Finolex Industries Ltd.','FINPIPE'),('Gujarat Fluorochemicals Ltd.','FLUOROCHEM'),('Fortis Healthcare Ltd.','FORTIS'),('Firstsource Solutions Ltd.','FSL'),('Gujarat Ambuja Exports Ltd.','GAEL'),('GAIL (India) Ltd.','GAIL'),('Galaxy Surfactants Ltd.','GALAXYSURF'),('Garware Technical Fibres Ltd.','GARFIBRES'),('Great Eastern Shipping Co. Ltd.','GESHIP'),('General Insurance Corporation of India','GICRE'),('Gland Pharma Ltd.','GLAND'),('Glaxosmithkline Pharmaceuticals Ltd.','GLAXO'),('Glenmark Pharmaceuticals Ltd.','GLENMARK'),('Glenmark Life Sciences Ltd.','GLS'),('GMM Pfaudler Ltd.','GMMPFAUDLR'),('GMR Infrastructure Ltd.','GMRINFRA'),('Go Fashion (India) Ltd.','GOCOLORS'),('Godfrey Phillips India Ltd.','GODFRYPHLP'),('Godrej Agrovet Ltd.','GODREJAGRO'),('Godrej Consumer Products Ltd.','GODREJCP'),('Godrej Industries Ltd.','GODREJIND'),('Godrej Properties Ltd.','GODREJPROP'),('Gujarat Pipavav Port Ltd.','GPPL'),('Granules India Ltd.','GRANULES'),('Graphite India Ltd.','GRAPHITE'),('Grasim Industries Ltd.','GRASIM'),('Grindwell Norton Ltd.','GRINDWELL'),('G R Infraprojects Ltd.','GRINFRA'),('Gujarat State Fertilizers & Chemicals Ltd.','GSFC'),('Gujarat State Petronet Ltd.','GSPL'),('Gujarat Alkalies & Chemicals Ltd.','GUJALKALI'),('Gujarat Gas Ltd.','GUJGASLTD'),('Hindustan Aeronautics Ltd.','HAL'),('Happiest Minds Technologies Ltd.','HAPPSTMNDS'),('Hathway Cable & Datacom Ltd.','HATHWAY'),('Hatsun Agro Product Ltd.','HATSUN'),('Havells India Ltd.','HAVELLS'),('HCL Technologies Ltd.','HCLTECH'),('Housing Development Finance Corporation Ltd.','HDFC'),('HDFC Asset Management Company Ltd.','HDFCAMC'),('HDFC Bank Ltd.','HDFCBANK'),('HDFC Life Insurance Company Ltd.','HDFCLIFE'),('H.E.G. Ltd.','HEG'),('Hemisphere Properties India Ltd.','HEMIPROP'),('Hero MotoCorp Ltd.','HEROMOTOCO'),('HFCL Ltd.','HFCL'),('Hinduja Global Solutions Ltd.','HGS'),('Hikal Ltd.','HIKAL'),('Hindalco Industries Ltd.','HINDALCO'),('Hindustan Copper Ltd.','HINDCOPPER'),('Hindustan Petroleum Corporation Ltd.','HINDPETRO'),('Hindustan Unilever Ltd.','HINDUNILVR'),('Hindustan Zinc Ltd.','HINDZINC'),('HLE Glascoat Ltd.','HLEGLAS'),('Home First Finance Company India Ltd.','HOMEFIRST'),('Honeywell Automation India Ltd.','HONAUT'),('Housing & Urban Development Corporation Ltd.','HUDCO'),('Indiabulls Real Estate Ltd.','IBREALEST'),('Indiabulls Housing Finance Ltd.','IBULHSGFIN'),('ICICI Bank Ltd.','ICICIBANK'),('ICICI Lombard General Insurance Company Ltd.','ICICIGI'),('ICICI Prudential Life Insurance Company Ltd.','ICICIPRULI'),('Indo Count Industries Ltd.','ICIL'),('IDBI Bank Ltd.','IDBI'),('Vodafone Idea Ltd.','IDEA'),('IDFC Ltd.','IDFC'),('IDFC First Bank Ltd.','IDFCFIRSTB'),('Indian Energy Exchange Ltd.','IEX'),('IFB Industries Ltd.','IFBIND'),('Indraprastha Gas Ltd.','IGL'),('IIFL Finance Ltd.','IIFL'),('IIFL Wealth Management Ltd.','IIFLWAM'),('Indian Hotels Co. Ltd.','INDHOTEL'),('India Cements Ltd.','INDIACEM'),('Indiamart Intermesh Ltd.','INDIAMART'),('Indian Bank','INDIANB'),('InterGlobe Aviation Ltd.','INDIGO'),('Indigo Paints Ltd.','INDIGOPNTS'),('Indoco Remedies Ltd.','INDOCO'),('IndusInd Bank Ltd.','INDUSINDBK'),('Indus Towers Ltd.','INDUSTOWER'),('Infibeam Avenues Ltd.','INFIBEAM'),('Infosys Ltd.','INFY'),('Inox Leisure Ltd.','INOXLEISUR'),('Intellect Design Arena Ltd.','INTELLECT'),('Indian Overseas Bank','IOB'),('Indian Oil Corporation Ltd.','IOC'),('Ipca Laboratories Ltd.','IPCALAB'),('IRB Infrastructure Developers Ltd.','IRB'),('IRCON International Ltd.','IRCON'),('Indian Railway Finance Corporation Ltd.','IRFC'),('ICICI Securities Ltd.','ISEC'),('ITC Ltd.','ITC'),('ITI Ltd.','ITI'),('Jamna Auto Industries Ltd.','JAMNAAUTO'),('J.B. Chemicals & Pharmaceuticals Ltd.','JBCHEPHARM'),('Jindal Steel & Power Ltd.','JINDALSTEL'),('J.K. Cement Ltd.','JKCEMENT'),('JK Lakshmi Cement Ltd.','JKLAKSHMI'),('JK Paper Ltd.','JKPAPER'),('JM Financial Ltd.','JMFINANCIL'),('Jindal Stainless Ltd.','JSL'),('JSW Energy Ltd.','JSWENERGY'),('JSW Steel Ltd.','JSWSTEEL'),('Jubilant Foodworks Ltd.','JUBLFOOD'),('Jubilant Ingrevia Ltd.','JUBLINGREA'),('Jubilant Pharmova Ltd.','JUBLPHARMA'),('Justdial Ltd.','JUSTDIAL'),('Jyothy Labs Ltd.','JYOTHYLAB'),('Kajaria Ceramics Ltd.','KAJARIACER'),('Kalpataru Power Transmission Ltd.','KALPATPOWR'),('Kalyan Jewellers India Ltd.','KALYANKJIL'),('Kansai Nerolac Paints Ltd.','KANSAINER'),('Karur Vysya Bank Ltd.','KARURVYSYA'),('Kec International Ltd.','KEC'),('KEI Industries Ltd.','KEI'),('Krishna Institute of Medical Sciences Ltd.','KIMS'),('KNR Constructions Ltd.','KNRCON'),('Kotak Mahindra Bank Ltd.','KOTAKBANK'),('KPIT Technologies Ltd.','KPITTECH'),('K.P.R. Mill Ltd.','KPRMILL'),('KRBL Ltd.','KRBL'),('L&T Finance Holdings Ltd.','L&TFH'),('Dr. Lal Path Labs Ltd.','LALPATHLAB'),('Latent View Analytics Ltd.','LATENTVIEW'),('Laurus Labs Ltd.','LAURUSLABS'),('Lakshmi Machine Works Ltd.','LAXMIMACH'),('LIC Housing Finance Ltd.','LICHSGFIN'),('Linde India Ltd.','LINDEINDIA'),('Macrotech Developers Ltd.','LODHA'),('Larsen & Toubro Ltd.','LT'),('Larsen & Toubro Infotech Ltd.','LTI'),('L&T Technology Services Ltd.','LTTS'),('Lupin Ltd.','LUPIN'),('Lux Industries Ltd.','LUXIND'),('Laxmi Organic Industries Ltd.','LXCHEM'),('Mahindra & Mahindra Ltd.','M&M'),('Mahindra & Mahindra Financial Services Ltd.','M&MFIN'),('Bank of Maharashtra','MAHABANK'),('Mahindra CIE Automotive Ltd.','MAHINDCIE'),('Mahindra Logistics Ltd.','MAHLOG'),('Manappuram Finance Ltd.','MANAPPURAM'),('C.E. Info Systems Ltd.','MAPMYINDIA'),('Marico Ltd.','MARICO'),('Maruti Suzuki India Ltd.','MARUTI'),('Mastek Ltd.','MASTEK'),('Max Healthcare Institute Ltd.','MAXHEALTH'),('Mazagoan Dock Shipbuilders Ltd.','MAZDOCK'),('United Spirits Ltd.','MCDOWELL-N'),('Multi Commodity Exchange of India Ltd.','MCX'),('Medplus Health Services Ltd.','MEDPLUS'),('Metro Brands Ltd.','METROBRAND'),('Metropolis Healthcare Ltd.','METROPOLIS'),('Max Financial Services Ltd.','MFSL'),('Mahanagar Gas Ltd.','MGL'),('Mahindra Holidays & Resorts India Ltd.','MHRIL'),('Minda Industries Ltd.','MINDAIND'),('MindTree Ltd.','MINDTREE'),('MMTC Ltd.','MMTC'),('MOIL Ltd.','MOIL'),('Motilal Oswal Financial Services Ltd.','MOTILALOFS'),('MphasiS Ltd.','MPHASIS'),('MRF Ltd.','MRF'),('Mangalore Refinery & Petrochemicals Ltd.','MRPL'),('MTAR Technologies Ltd.','MTARTECH'),('Muthoot Finance Ltd.','MUTHOOTFIN'),('Nippon Life India Asset Management Ltd.','NAM-INDIA'),('NATCO Pharma Ltd.','NATCOPHARM'),('National Aluminium Co. Ltd.','NATIONALUM'),('Info Edge (India) Ltd.','NAUKRI'),('Navin Fluorine International Ltd.','NAVINFLUOR'),('Nazara Technologies Ltd.','NAZARA'),('NBCC (India) Ltd.','NBCC'),('NCC Ltd.','NCC'),('NESCO Ltd.','NESCO'),('Nestle India Ltd.','NESTLEIND'),('Network18 Media & Investments Ltd.','NETWORK18'),('Narayana Hrudayalaya Ltd.','NH'),('NHPC Ltd.','NHPC'),('The New India Assurance Company Ltd.','NIACL'),('NLC India Ltd.','NLCINDIA'),('NMDC Ltd.','NMDC'),('NOCIL Ltd.','NOCIL'),('NTPC Ltd.','NTPC'),('Nuvoco Vistas Corporation Ltd.','NUVOCO'),('FSN E-Commerce Ventures Ltd.','NYKAA'),('Oberoi Realty Ltd.','OBEROIRLTY'),('Oracle Financial Services Software Ltd.','OFSS'),('Oil India Ltd.','OIL'),('Oil & Natural Gas Corporation Ltd.','ONGC'),('Orient Electric Ltd.','ORIENTELEC'),('Page Industries Ltd.','PAGEIND'),('One 97 Communications Ltd.','PAYTM'),('PCBL Ltd.','PCBL'),('Piramal Enterprises Ltd.','PEL'),('Persistent Systems Ltd.','PERSISTENT'),('Petronet LNG Ltd.','PETRONET'),('Power Finance Corporation Ltd.','PFC'),('Pfizer Ltd.','PFIZER'),('Procter & Gamble Hygiene & Health Care Ltd.','PGHH'),('Procter & Gamble Health Ltd.','PGHL'),('Phoenix Mills Ltd.','PHOENIXLTD'),('Pidilite Industries Ltd.','PIDILITIND'),('PI Industries Ltd.','PIIND'),('Punjab National Bank','PNB'),('PNB Housing Finance Ltd.','PNBHOUSING'),('PNC Infratech Ltd.','PNCINFRA'),('PB Fintech Ltd.','POLICYBZR'),('Polycab India Ltd.','POLYCAB'),('Poly Medicure Ltd.','POLYMED'),('Polyplex Corporation Ltd.','POLYPLEX'),('Poonawalla Fincorp Ltd.','POONAWALLA'),('Power Grid Corporation of India Ltd.','POWERGRID'),('Hitachi Energy India Ltd.','POWERINDIA'),('Praj Industries Ltd.','PRAJIND'),('Prestige Estates Projects Ltd.','PRESTIGE'),('Prince Pipes and Fittings Ltd.','PRINCEPIPE'),('Privi Speciality Chemicals Ltd.','PRIVISCL'),('Prism Johnson Ltd.','PRSMJOHNSN'),('PVR Ltd.','PVR'),('Quess Corp Ltd.','QUESS'),('Radico Khaitan Ltd','RADICO'),('Railtel Corporation Of India Ltd.','RAILTEL'),('Rain Industries Ltd','RAIN'),('Rajesh Exports Ltd.','RAJESHEXPO'),('Rallis India Ltd.','RALLIS'),('The Ramco Cements Ltd.','RAMCOCEM'),('Ratnamani Metals & Tubes Ltd.','RATNAMANI'),('Restaurant Brands Asia Ltd.','RBA'),('RBL Bank Ltd.','RBLBANK'),('Rashtriya Chemicals & Fertilizers Ltd.','RCF'),('REC Ltd.','RECLTD'),('Redington (India) Ltd.','REDINGTON'),('Relaxo Footwears Ltd.','RELAXO'),('Reliance Industries Ltd.','RELIANCE'),('Shree Renuka Sugars Ltd.','RENUKA'),('RHI MAGNESITA INDIA LTD.','RHIM'),('RITES Ltd.','RITES'),('Rossari Biotech Ltd.','ROSSARI'),('Route Mobile Ltd.','ROUTE'),('RattanIndia Enterprises Ltd.','RTNINDIA'),('Rail Vikas Nigam Ltd.','RVNL'),('Steel Authority of India Ltd.','SAIL'),('Sanofi India Ltd.','SANOFI'),('Sapphire Foods India Ltd.','SAPPHIRE'),('Saregama India Ltd','SAREGAMA'),('SBI Cards and Payment Services Ltd.','SBICARD'),('SBI Life Insurance Company Ltd.','SBILIFE'),('State Bank of India','SBIN'),('Schaeffler India Ltd.','SCHAEFFLER'),('Shipping Corporation of India Ltd.','SCI'),('Sequent Scientific Ltd.','SEQUENT'),('Sheela Foam Ltd.','SFL'),('Shilpa Medicare Ltd.','SHILPAMED'),('Shree Cement Ltd.','SHREECEM'),('Shriram City Union Finance Ltd.','SHRIRAMCIT'),('Shyam Metalics and Energy Ltd.','SHYAMMETL'),('Siemens Ltd.','SIEMENS'),('SIS Ltd.','SIS'),('SJVN Ltd.','SJVN'),('SKF India Ltd.','SKFINDIA'),('Sobha Ltd.','SOBHA'),('Solara Active Pharma Sciences Ltd.','SOLARA'),('Solar Industries India Ltd.','SOLARINDS'),('Sona BLW Precision Forgings Ltd.','SONACOMS'),('Sonata Software Ltd.','SONATSOFTW'),('Sun Pharma Advanced Research Company Ltd.','SPARC'),('Spicejet Ltd.','SPICEJET'),('SRF Ltd.','SRF'),('Shriram Transport Finance Co. Ltd.','SRTRANSFIN'),('Strides Pharma Science Ltd.','STAR'),('Star Health and Allied Insurance Company Ltd.','STARHEALTH'),('Sterlite Technologies Ltd.','STLTECH'),('Sudarshan Chemical Industries Ltd.','SUDARSCHEM'),('Sumitomo Chemical India Ltd.','SUMICHEM'),('Sundaram Finance Ltd.','SUNDARMFIN'),('Sundram Fasteners Ltd.','SUNDRMFAST'),('Sun Pharmaceutical Industries Ltd.','SUNPHARMA'),('Sunteck Realty Ltd.','SUNTECK'),('Sun TV Network Ltd.','SUNTV'),('Suprajit Engineering Ltd.','SUPRAJIT'),('Supreme Industries Ltd.','SUPREMEIND'),('Suven Pharmaceuticals Ltd.','SUVENPHAR'),('Suzlon Energy Ltd.','SUZLON'),('Sterling and Wilson Renewable Energy Ltd.','SWSOLAR'),('Symphony Ltd.','SYMPHONY'),('Syngene International Ltd.','SYNGENE'),('Tanla Platforms Ltd.','TANLA'),('Tata Chemicals Ltd.','TATACHEM'),('Tata Coffee Ltd.','TATACOFFEE'),('Tata Communications Ltd.','TATACOMM'),('Tata Consumer Products Ltd.','TATACONSUM'),('Tata Elxsi Ltd.','TATAELXSI'),('Tata Investment Corporation Ltd.','TATAINVEST'),('Tata Motors Ltd.','TATAMOTORS'),('Tata Motors Ltd DVR','TATAMTRDVR'),('Tata Power Co. Ltd.','TATAPOWER'),('Tata Steel Ltd.','TATASTEEL'),('Tata Steel Long Products Ltd.','TATASTLLP'),('TCI Express Ltd.','TCIEXP'),('TCNS Clothing Co. Ltd.','TCNSBRANDS'),('Tata Consultancy Services Ltd.','TCS'),('Teamlease Services Ltd.','TEAMLEASE'),('Tech Mahindra Ltd.','TECHM'),('Thermax Ltd.','THERMAX'),('Thyrocare Technologies Ltd.','THYROCARE'),('Tube Investments of India Ltd.','TIINDIA'),('Timken India Ltd.','TIMKEN'),('Titan Company Ltd.','TITAN'),('Torrent Pharmaceuticals Ltd.','TORNTPHARM'),('Torrent Power Ltd.','TORNTPOWER'),('Trent Ltd.','TRENT'),('Trident Ltd.','TRIDENT'),('Triveni Turbine Ltd.','TRITURBINE'),('Triveni Engineering & Industries Ltd.','TRIVENI'),('TTK Prestige Ltd.','TTKPRESTIG'),('Tata Teleservices (Maharashtra) Ltd.','TTML'),('TV18 Broadcast Ltd.','TV18BRDCST'),('TVS Motor Company Ltd.','TVSMOTOR'),('United Breweries Ltd.','UBL'),('UCO Bank','UCOBANK'),('UFLEX Ltd.','UFLEX'),('UltraTech Cement Ltd.','ULTRACEMCO'),('Union Bank of India','UNIONBANK'),('UPL Ltd.','UPL'),('UTI Asset Management Company Ltd.','UTIAMC'),('Vaibhav Global Ltd.','VAIBHAVGBL'),('Vakrangee Ltd.','VAKRANGEE'),('Varroc Engineering Ltd.','VARROC'),('Varun Beverages Ltd.','VBL'),('Vedanta Ltd.','VEDL'),('Venky\'s (India) Ltd.','VENKEYS'),('V-Guard Industries Ltd.','VGUARD'),('Vijaya Diagnostic Centre Ltd.','VIJAYA'),('Vinati Organics Ltd.','VINATIORGA'),('V.I.P. Industries Ltd.','VIPIND'),('V-Mart Retail Ltd.','VMART'),('Voltas Ltd.','VOLTAS'),('Vardhman Textiles Ltd.','VTL'),('Welspun Corp Ltd.','WELCORP'),('Welspun India Ltd.','WELSPUNIND'),('Westlife Development Ltd.','WESTLIFE'),('Whirlpool of India Ltd.','WHIRLPOOL'),('Wipro Ltd.','WIPRO'),('Wockhardt Ltd.','WOCKPHARMA'),('Yes Bank Ltd.','YESBANK'),('Zee Entertainment Enterprises Ltd.','ZEEL'),('Zensar Technolgies Ltd.','ZENSARTECH'),('Zomato Ltd.','ZOMATO'),('Zydus Lifesciences Ltd.','ZYDUSLIFE'),('Zydus Wellness Ltd.','ZYDUSWELL');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `selection`
--
DROP TABLE IF EXISTS `selection`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `selection` (
`username` varchar(45) NOT NULL,
`tickerselect` varchar(45) NOT NULL,
`userid` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `selection`
--
LOCK TABLES `selection` WRITE;
/*!40000 ALTER TABLE `selection` DISABLE KEYS */;
INSERT INTO `selection` VALUES ('Titan_Slicer#6096','ITC','534491042494283776'),('Titan_Slicer#6096','RELIANCE','534491042494283776'),('Titan_Slicer#6096','UBL','534491042494283776');
/*!40000 ALTER TABLE `selection` 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 2022-07-09 1:34:26