-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Dec 21, 2024 at 03:46 PM
-- Server version: 5.7.39
-- PHP Version: 8.2.0

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

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

--
-- Table structure for table `auto`
--

CREATE TABLE `auto` (
  `item` int(50) NOT NULL,
  `symbol` varchar(20) DEFAULT NULL,
  `auto` tinyint(1) DEFAULT NULL,
  `hasTrade` tinyint(1) DEFAULT NULL,
  `strategy` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `auto`
--

INSERT INTO `auto` (`item`, `symbol`, `auto`, `hasTrade`, `strategy`) VALUES
(51, 'SUIUSDT', 0, 0, '[]'),
(52, 'PEPEUSDT', 0, 0, '[]'),
(53, 'ETCUSDT', 0, 0, '[]'),
(54, 'ZILUSDT', 0, 0, '[]'),
(55, 'CRVUSDT', 0, 0, '[]'),
(56, 'DOTUSDT', 0, 0, '[]'),
(57, 'DOGEUSDT', 0, 0, '[]'),
(58, 'ZRXUSDT', 0, 1, '[]'),
(59, 'STORJUSDT', 0, 0, '[]'),
(60, 'HEXUSDT', 0, 0, '[]'),
(61, 'UNIUSDT', 0, 0, '[]'),
(62, 'MOCAUSDT', 0, 0, '[]'),
(63, 'YOLOUSDT', 0, 0, '[]');

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

--
-- Table structure for table `completed`
--

CREATE TABLE `completed` (
  `id` int(11) NOT NULL,
  `symbol` varchar(50) DEFAULT NULL,
  `orderId` varchar(100) DEFAULT NULL,
  `orderListId` int(11) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `origQty` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `side` varchar(10) DEFAULT NULL,
  `transactTime` bigint(20) DEFAULT NULL,
  `usdVal` varchar(100) DEFAULT NULL,
  `openTime` bigint(20) DEFAULT NULL,
  `profit` varchar(50) DEFAULT NULL,
  `percent` varchar(20) DEFAULT NULL,
  `setting` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `completed`
--

INSERT INTO `completed` (`id`, `symbol`, `orderId`, `orderListId`, `price`, `origQty`, `type`, `side`, `transactTime`, `usdVal`, `openTime`, `profit`, `percent`, `setting`, `created_at`) VALUES
(2, 'YOLOUSDT', 'C02__499125443102818304079', -1, '0.00000010266', '299547683', 'MARKET', 'SELL', 1734783014804, NULL, 1734782772866, NULL, '2.505', NULL, '2024-12-21 12:10:14');

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

--
-- Table structure for table `db`
--

CREATE TABLE `db` (
  `id` int(11) NOT NULL,
  `symbol` varchar(50) DEFAULT NULL,
  `signal` varchar(50) DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `OHTPC` varchar(100) DEFAULT NULL,
  `accel` double DEFAULT NULL,
  `unix` bigint(20) DEFAULT NULL,
  `SMA20` double DEFAULT NULL,
  `vwma` double DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `db`
--

INSERT INTO `db` (`id`, `symbol`, `signal`, `time`, `OHTPC`, `accel`, `unix`, `SMA20`, `vwma`, `created_at`) VALUES
(1, 'SUIUSDT', 'noow', 1733996842, '60mBUY 4hSELL 1dSELL ', 5.41, NULL, NULL, NULL, '2024-12-13 17:35:04'),
(4, 'PEPEUSDT', 'WAIT 33.836080577001', 1733588825, '60mBUY 4hSELL 1dSELL ', 2.16, 1734781917, 0.000024475, 0.000017075, '2024-12-13 17:35:04'),
(5, 'ETCUSDT', 'EXIT SHORT', 1733585863, '60mBUY 4hBUY 1dSELL ', 0, 1734781922, 36.875, 26.025, '2024-12-13 17:35:04'),
(6, 'ZILUSDT', 'WAIT 26.052897447598', 1733585852, '60mSELL 4hBUY 1dSELL ', 3.19, 1734781920, 0.034885, 0.02064, '2024-12-13 17:35:04'),
(13, 'CRVUSDT', 'WAIT 26.927460063114', 1734191599, NULL, NULL, 1734781910, NULL, 0.8134, '2024-12-14 15:53:19'),
(14, 'DOTUSDT', 'WAIT 22.751116573221', 1734191601, NULL, NULL, 1734781921, NULL, 6.906, '2024-12-14 15:53:21'),
(15, 'DOGEUSDT', 'WAIT 28.823207335167', 1734191602, NULL, NULL, 1734781922, NULL, 0.30608, '2024-12-14 15:53:22'),
(16, 'ZRXUSDT', 'WAIT 25.917116581662', 1734191605, NULL, NULL, 1734781920, NULL, 0.45715, '2024-12-14 15:53:25'),
(17, 'STORJUSDT', 'noow', 1734191607, NULL, NULL, NULL, NULL, NULL, '2024-12-14 15:53:27'),
(18, 'HEXUSDT', 'noow', 1734194254, NULL, NULL, NULL, NULL, NULL, '2024-12-14 16:37:34'),
(20, 'UNIUSDT', 'WAIT 21.651641641987', 1734195533, NULL, NULL, 1734781921, NULL, 13.001, '2024-12-14 16:58:53'),
(24, 'MOCAUSDT', 'noow', 1734772030, NULL, NULL, NULL, NULL, NULL, '2024-12-21 09:07:10'),
(25, 'YOLOUSDT', 'noow', 1734782285, NULL, NULL, NULL, NULL, NULL, '2024-12-21 11:58:05');

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

--
-- Table structure for table `trades`
--

CREATE TABLE `trades` (
  `id` int(11) NOT NULL,
  `symbol` varchar(50) DEFAULT NULL,
  `orderId` varchar(100) DEFAULT NULL,
  `orderListId` int(11) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `origQty` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `side` varchar(10) DEFAULT NULL,
  `transactTime` bigint(20) DEFAULT NULL,
  `setting` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `trades`
--

INSERT INTO `trades` (`id`, `symbol`, `orderId`, `orderListId`, `price`, `amount`, `origQty`, `type`, `side`, `transactTime`, `setting`, `created_at`) VALUES
(267, 'YOLOUSDT', 'C02__499122459967008769079', -1, '0.000000139755', '226745373', '226745373', 'MARKET', 'BUY', 1734782303569, 'MANUAL', '2024-12-21 11:58:23'),
(272, 'MOCAUSDT', 'C02__499135664449679360079', -1, '0.30706', '102.8', '102.8', 'MARKET', 'BUY', 1734785451763, 'MANUAL', '2024-12-21 12:50:51');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auto`
--
ALTER TABLE `auto`
  ADD PRIMARY KEY (`item`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `auto`
--
ALTER TABLE `auto`
  MODIFY `item` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `completed`
--
ALTER TABLE `completed`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `db`
--
ALTER TABLE `db`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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