-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2020 年 12 月 27 日 11:31
-- 服务器版本: 5.5.36
-- PHP 版本: 5.3.28
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 utf8 */;
--
-- 数据库: `rider`
--
-- --------------------------------------------------------
--
-- 表的结构 `record`
--
CREATE TABLE IF NOT EXISTS `record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`lat_list` text NOT NULL,
`lon_list` text NOT NULL,
`date` text NOT NULL,
`duration` text NOT NULL,
`distance` text NOT NULL,
`cal` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
--
-- 转存表中的数据 `record`
--
INSERT INTO `record` (`id`, `username`, `lat_list`, `lon_list`, `date`, `duration`, `distance`, `cal`) VALUES
(33, 'aa', '34.19756;34.197666;34.195987;34.19559;34.19665;34.19625;34.19581;34.196491;34.194482;34.19454;34.19373908095777;', '108.86557;108.865034;108.866503;108.8643;108.86456;108.86501;108.86408;108.864151;108.865111;108.86837;108.87541864208818;', '2020-04-26 12:30:46', '0:0:13', '2.065公里', '56.17卡');
-- --------------------------------------------------------
--
-- 表的结构 `topic`
--
CREATE TABLE IF NOT EXISTS `topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` text NOT NULL,
`title` varchar(255) NOT NULL,
`message` text NOT NULL,
`date` text NOT NULL,
`author` text NOT NULL,
`img` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
--
-- 转存表中的数据 `topic`
--
INSERT INTO `topic` (`id`, `content`, `title`, `message`, `date`, `author`, `img`) VALUES
(47, '呜呜呜', '蓝瘦香菇', 'cc#不哭不哭#2020-04-10;cc#哈哈#2020-04-10;cc#回复 cc：有啥想开不开#2020-04-10;cc#不要哭#2020-04-10;cc#不可不不#2020-04-10;', '2020-4-10', 'cc', '5e8fc67985c31.jpg'),
(48, '123', '123', 'aa#123456#2020-06-27;', '123', 'aa', 'uploaded/1587814155686food3.jpg'),
(49, '骑车真不错', '今天天气不错，很适合骑车', '', '2020-4-26', 'bb', 'uploaded\\1587831228365food2.jpg');
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text CHARACTER SET utf8 NOT NULL,
`password` text CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=7 ;
--
-- 转存表中的数据 `user`
--
INSERT INTO `user` (`id`, `name`, `password`) VALUES
(1, '123', '123'),
(2, '123', '123'),
(3, 'aa', '123'),
(4, 'bb', '123'),
(6, 'cc', '123');
/*!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 */;
