-- phpMyAdmin SQL Dump
-- version 4.4.15.10
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2021-03-04 23:36:48
-- 服务器版本： 5.6.48-log
-- PHP Version: 7.2.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `mms`
--

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

--
-- 表的结构 `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL,
  `user` varchar(18) COLLATE utf8_bin DEFAULT NULL,
  `pass` varchar(32) COLLATE utf8_bin DEFAULT NULL,
  `dy_info` text COLLATE utf8_bin COMMENT '抖音info',
  `temp` varchar(1024) COLLATE utf8_bin DEFAULT NULL,
  `smsu` varchar(50) COLLATE utf8_bin NOT NULL,
  `smsp` varchar(50) COLLATE utf8_bin NOT NULL,
  `t` int(11) NOT NULL,
  `code` varchar(200) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- 转存表中的数据 `admin`
--

INSERT INTO `admin` (`id`, `user`, `pass`, `dy_info`, `temp`, `smsu`, `smsp`, `t`, `code`) VALUES
(1, 'admin', 'lexiong6', '123', '【小辉社区】您的验证码为{code}', 'xiaobo6', 'a123456', 10, '');

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

--
-- 表的结构 `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL,
  `out_order_no` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '支付宝订单号',
  `total_amount` int(10) DEFAULT NULL COMMENT '金额',
  `pay_url` text COLLATE utf8_bin COMMENT 'url',
  `state` int(1) DEFAULT '0' COMMENT '状态',
  `time` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `code` varchar(200) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=787 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- 表的结构 `phone`
--

CREATE TABLE IF NOT EXISTS `phone` (
  `pid` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `time` varchar(12) COLLATE utf8_bin DEFAULT NULL,
  `code` varchar(20) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=440 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- 转存表中的数据 `phone`
--

INSERT INTO `phone` (`pid`, `name`, `phone`, `time`, `code`) VALUES
(438, '联系人 16671050324', '16671050324', '2121-03-04', '192325');

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

--
-- 表的结构 `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL,
  `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL,
  `date` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `code` varchar(200) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- 转存表中的数据 `user`
--

INSERT INTO `user` (`id`, `phone`, `date`, `code`) VALUES
(196, '15381245911', '21210130', ''),
(197, '15381214916', '21210130', ''),
(198, '15281214916', '21210130', ''),
(199, '15381214916', '21210130', ''),
(200, '13046091317', '21210204', ''),
(201, '13046091317', '21210204', ''),
(202, '13380488037', '21210204', ''),
(203, '13350488037', '21210204', ''),
(204, '13350488037', '21210204', ''),
(205, '13350488037', '21210204', ''),
(206, '13476510679', '21210204', ''),
(207, '13476510679', '21210204', ''),
(208, '13800138000', '21210206', ''),
(209, '13800138000', '21210206', ''),
(210, '13800138000', '21210206', ''),
(211, '13800138000', '21210206', ''),
(212, '13588541233', '21210206', ''),
(213, '13588541233', '21210206', ''),
(214, '18535213340', '21210206', ''),
(215, '18569858350', '21210208', ''),
(216, '15888888888', '21210224', ''),
(217, '15888888888', '21210224', ''),
(218, '13459786666', '21210302', ''),
(219, '13476510679', '21210304', '123'),
(220, '13476510679', '21210304', '123'),
(221, '13476510679', '21210304', '123'),
(222, '13476510679', '21210304', '123'),
(223, '13476510679', '21210304', '123'),
(224, '13476510679', '21210304', '123'),
(225, '13476510679', '21210304', '123'),
(226, '13476510679', '21210304', '123'),
(227, '13476510679', '21210304', '123'),
(228, '13046091317', '21210304', '123'),
(229, '15087797533', '21210304', '123');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `phone`
--
ALTER TABLE `phone`
  ADD PRIMARY KEY (`pid`),
  ADD UNIQUE KEY `phone` (`phone`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `phone` (`phone`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=787;
--
-- AUTO_INCREMENT for table `phone`
--
ALTER TABLE `phone`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=440;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=230;
/*!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 */;
