-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 24, 2025 at 07:03 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

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

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

--
-- Table structure for table `mtm_users`
--

CREATE TABLE `mtm_users` (
  `user_id` varchar(50) NOT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `alias` varchar(100) DEFAULT NULL,
  `margin` decimal(12,2) DEFAULT 0.00,
  `available_margin` decimal(17,2) DEFAULT NULL,
  `employed_margin` decimal(12,2) DEFAULT NULL,
  `group_margin` decimal(17,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- RELATIONSHIPS FOR TABLE `mtm_users`:
--

--
-- Dumping data for table `mtm_users`
--

INSERT INTO `mtm_users` (`user_id`, `ip`, `alias`, `margin`, `available_margin`, `employed_margin`, `group_margin`) VALUES
('BACKENZO', '103.108.220.45:8553', 'BACKENZO', 10000000.00, 30047850.00, 2000000.00, 0.00),
('BBUYING', '103.108.220.47:8553', 'BBUYING', 10000000.00, 99987523.75, 100000.00, 0.00),
('DLL1064', '103.108.220.45:8553', 'AJITH_10_CR', 100000000.00, 974241527.90, 98200000.00, 900000000.00),
('DLL9420', '103.108.220.47:8553', 'ROHIT_3_CR', 30000000.00, 9999982707645.75, 30000000.00, 9999970000000.00),
('EQX032', '103.108.220.45:8553', 'ANS_3_CR', 30000000.00, 12697323.15, 30000000.00, 0.00),
('KEVAL', '103.108.220.47:8553', 'KEVAL_10_CR', 100000000.00, 41020668.72, 98200000.00, 0.00),
('MC0444', '103.108.220.47:8553', 'MARWADI444_10_CR', 100000000.00, 41019869.80, 98200000.00, 0.00),
('MC0489', '103.108.220.45:8553', 'MARWADI489_40_CR', 400000000.00, 167762459.20, 398200000.00, 0.00),
('NFSTVWAP', '103.108.220.46:8553', 'NFSTVWAP_SIM_1X', 0.00, 99993846.25, 2000000.00, 0.00),
('TY03', '103.108.220.47:8553', 'TY03_12_CR', 120000000.00, 50719883.23, 120000000.00, 0.00),
('X06', '103.108.220.45:8553', 'X06_10_CR', 100000000.00, 41045772.12, 98200000.00, 0.00),
('X12', '103.108.220.45:8553', 'X12_12_CR', 120000000.00, 50726556.97, 120000000.00, 0.00),
('ZZJ13048', '103.108.220.45:8553', 'MARU_5_CR', 50000000.00, 983298042.00, 51700000.00, 950000000.00),
('ZZJ14978', '103.108.220.47:8553', 'ROHIT1_3_CR', 30000000.00, 99982706719.00, 30000000.00, 99970000000.00);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mtm_users`
--
ALTER TABLE `mtm_users`
  ADD PRIMARY KEY (`user_id`);


--
-- Metadata
--
USE `phpmyadmin`;

--
-- Metadata for table mtm_users
--
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 */;
