-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ingorex_azarniyan`
--

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

--
-- Table structure for table `adduser`
--

CREATE TABLE `adduser` (
  `id` int(11) NOT NULL,
  `chatid` varchar(64) NOT NULL,
  `mainchatid` varchar(64) NOT NULL,
  `head` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `one_month` varchar(32) DEFAULT NULL,
  `two_months` varchar(32) DEFAULT NULL,
  `user` varchar(64) NOT NULL,
  `pass` varchar(64) NOT NULL,
  `text` text DEFAULT NULL,
  `text2` text DEFAULT NULL,
  `text3` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `one_month`, `two_months`, `user`, `pass`, `text`, `text2`, `text3`) VALUES
(1, '1000', '1000', 'admin', '5bfd1e04db7adafc4908107e1cb08c0d', 'سلام به ربات خوش آمدید \r\n\r\nدکمه ی دریافت هدیه رو بزنید', '♦️ لطفا بر روی اشتراک گذاری شماره کلیک کنید ', 'تشکر بابت به اشتراکی گذاری شماره با شما تماس خواهیم گرفت');

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

--
-- Table structure for table `hash`
--

CREATE TABLE `hash` (
  `id` int(11) NOT NULL,
  `chatid` varchar(64) NOT NULL,
  `hash` varchar(256) NOT NULL,
  `time` varchar(64) NOT NULL,
  `telname` varchar(64) NOT NULL,
  `username` varchar(64) DEFAULT NULL,
  `amount` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `hash`
--

INSERT INTO `hash` (`id`, `chatid`, `hash`, `time`, `telname`, `username`, `amount`) VALUES
(1, '5803067539', 'sdf', '1714288987', 'Matin', 'matinshirani01', '20'),
(2, '5803067539', '654', '1714292639', 'Matin', 'matinshirani01', '20'),
(3, '5803067539', 'asdfa', '1714475493', 'Matin', 'matinshirani01', '20'),
(4, '5803067539', 'asdfa', '1714475495', 'Matin', 'matinshirani01', '20'),
(5, '5803067539', 'asdfa', '1714475500', 'Matin', 'matinshirani01', '20'),
(6, '5803067539', 'asdfa', '1714475508', 'Matin', 'matinshirani01', '20'),
(7, '5803067539', 'asdfa', '1714475524', 'Matin', 'matinshirani01', '20'),
(8, '5803067539', 'asdfa', '1714475556', 'Matin', 'matinshirani01', '20'),
(9, '5803067539', 'asdfa', '1714475618', 'Matin', 'matinshirani01', '20'),
(10, '5803067539', 'asdfa', '1714475688', 'Matin', 'matinshirani01', '20'),
(11, '5803067539', 'asdfa', '1714475803', 'Matin', 'matinshirani01', '20'),
(12, '5803067539', 'fsf', '1714476497', 'Matin', 'matinshirani01', '20'),
(13, '5803067539', 'fsf', '1714476499', 'Matin', 'matinshirani01', '20'),
(14, '5803067539', 'fsf', '1714476504', 'Matin', 'matinshirani01', '20'),
(15, '5803067539', 'ZXC', '1714476605', 'Matin', 'matinshirani01', '20'),
(16, '5803067539', '4654', '1714476668', 'Matin', 'matinshirani01', '20'),
(17, '5803067539', 'شسیبشسیب', '1714901307', 'Matin', 'matinshirani01', '20'),
(18, '7073438733', 'ae994743d6dcd157049ed3e8a371d45d4f5be03ad667317511cd62d5e193ea38', '1715013478', 'پشتیبان fast verify', 'poshtibaniverify', '20'),
(19, '5803067539', 'fasd', '1715065599', 'Matin', 'matinshirani01', '79');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `telfamily` varchar(128) DEFAULT NULL,
  `telname` varchar(128) DEFAULT NULL,
  `username` varchar(128) DEFAULT NULL,
  `chatid` varchar(64) NOT NULL,
  `req1` varchar(128) DEFAULT NULL,
  `req2` varchar(128) DEFAULT NULL,
  `req3` varchar(128) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `phone` varchar(32) DEFAULT 'Empty',
  `name` varchar(128) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `temp_description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `telfamily`, `telname`, `username`, `chatid`, `req1`, `req2`, `req3`, `email`, `phone`, `name`, `description`, `temp_description`) VALUES
(1, 'Pakdel', 'Amir hosein', 'ahpbot_sale', '6849497001', '', '', NULL, NULL, '+989362969718', 'امیر پاکدل', NULL, NULL),
(2, '', 'ཧᜰ꙰ꦿ➢AMIR༒', 'Terool_tm', '2131089108', '', '', NULL, NULL, '989940838827', 'امیرحسین آذرنیان', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adduser`
--
ALTER TABLE `adduser`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

