-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 2018-05-21 07:27:57
-- 服务器版本： 5.7.14
-- PHP Version: 5.6.25

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

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

--
-- 表的结构 `comm_deal`
--

CREATE TABLE `comm_deal` (
  `id` int(11) NOT NULL,
  `username` varchar(32) NOT NULL COMMENT '下达订单用户姓名',
  `equip_id` varchar(255) DEFAULT NULL COMMENT '车位id',
  `licence_plate` varchar(255) DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  `start_time` varchar(32) DEFAULT NULL COMMENT '订单开始时间',
  `end_time` varchar(32) DEFAULT NULL COMMENT '订单结束时间，预约中为null',
  `pressure` int(11) DEFAULT NULL,
  `user_controller` int(11) DEFAULT NULL,
  `completed` int(11) DEFAULT NULL COMMENT '0未预约，1为预约中'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `comm_equipments`
--

CREATE TABLE `comm_equipments` (
  `id` int(32) NOT NULL COMMENT '车位序号',
  `equip_id` varchar(32) NOT NULL COMMENT '车位号',
  `user_id` varchar(32) DEFAULT NULL COMMENT '车位拥有者',
  `location_nl` varchar(32) DEFAULT NULL COMMENT '车位北纬坐标',
  `location_el` varchar(32) DEFAULT NULL COMMENT '车位东经坐标',
  `description` varchar(32) DEFAULT NULL COMMENT '车位位置信息描述',
  `state` int(12) DEFAULT NULL COMMENT '0空闲中，1预约中,2不可预约'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `comm_equipments` (`id`, `equip_id`, `user_id`, `location_nl`, `location_el`, `description`, `state`) VALUES
(1, 'szzjgcxzl_001', '10', '31.893539', '120.564432', '苏州市张家港市长兴中路8号车位001', 0),
(2, 'szzjgcxzl_002', '10', '31.890110', '120.56398', '苏州市张家港市长兴中路8号车位002', 0),
(3, 'szzjgcxzl_003', '11', '31.893539', '120.54731', '苏州市张家港市长兴中路8号车位003', 2);

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

--
-- 表的结构 `comm_user`
--

CREATE TABLE `comm_user` (
  `id` int(12) NOT NULL COMMENT '表编号',
  `user_id` varchar(32) NOT NULL COMMENT '用户id',
  `username` varchar(32) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '用户密码',
  `phone` varchar(32) DEFAULT NULL COMMENT '联系电话',
  `money` varchar(12) DEFAULT NULL COMMENT '账户余额'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `comm_user` (`id`, `user_id`, `username`, `password`, `phone`, `money`) VALUES
(1, '10', 'superadmin', '123456', '15298816162', '100'),
(2, '11', 'user_02', '123456', '15298816163', '80'),
(6, 'user_user_04', 'user_04', '123456', NULL, NULL),
(5, 'user_user_03', 'user_03', '123456', NULL, NULL),
(7, 'user_user_05', 'user_05', '123456', NULL, NULL);

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

--
-- 表的结构 `comm_user_car`
--

CREATE TABLE `comm_user_car` (
  `user_id` varchar(12) DEFAULT NULL,
  `licence_plate` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '0不在车位上，1在车位上'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `comm_user_car` (`user_id`, `licence_plate`, `status`) VALUES
('10', '京AF0236', 0),
('10', '苏A23542', 0),
('10', '苏E12345', 0),
('10', '苏E12346', 0),
('10', '苏E12347', 0);

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

--
-- 表的结构 `user_t`
--

CREATE TABLE `user_t` (
  `id` int(11) NOT NULL,
  `user_name` varchar(40) NOT NULL,
  `password` varchar(255) NOT NULL,
  `age` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `user_t` (`id`, `user_name`, `password`, `age`) VALUES
(1, '测试', '345', 24),
(2, 'javen', '123', 10);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `comm_equipments`
--
ALTER TABLE `comm_equipments`
  ADD PRIMARY KEY (`id`,`equip_id`);

--
-- Indexes for table `comm_user`
--
ALTER TABLE `comm_user`
  ADD PRIMARY KEY (`id`,`user_id`);

--
-- Indexes for table `comm_user_car`
--
ALTER TABLE `comm_user_car`
  ADD PRIMARY KEY (`licence_plate`);

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

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `comm_deal`
--
ALTER TABLE `comm_deal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `comm_equipments`
--
ALTER TABLE `comm_equipments`
  MODIFY `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '车位序号', AUTO_INCREMENT=4;
--
-- 使用表AUTO_INCREMENT `comm_user`
--
ALTER TABLE `comm_user`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '表编号', AUTO_INCREMENT=8;
--
-- 使用表AUTO_INCREMENT `user_t`
--
ALTER TABLE `user_t`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
/*!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 */;