PHP+Android实现的环保APP

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2021 年 02 月 23 日 18:29 -- 服务器版本: 5.5.53 -- PHP 版本: 5.4.45 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 */; -- -- 数据库: `environment_data` -- CREATE DATABASE `environment_data` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `environment_data`; -- -------------------------------------------------------- -- -- 表的结构 `think_article` -- CREATE TABLE IF NOT EXISTS `think_article` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` text, `title` text, `content` text, `time` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ; -- -- 转存表中的数据 `think_article` -- INSERT INTO `think_article` (`id`, `name`, `title`, `content`, `time`) VALUES (16, 'ddd', '绝对不行九点半ddd', '博大精深步行街下边补习班还是大包小包还不下班电话手表相互百度好的吧我不喜欢相互', '2021-02-15'), (15, 'ccc', '喝会茶ccc', '不说话不行不行好好上班吧喜欢的话并行不悖喜欢的话百度好像好好的哈很喜欢八点半', '2021-02-15'), (14, 'bbb', '单边好像不是bbb', '年底那你想不想不喜欢吧都不喜欢还是不行大包小包好的不对不对', '2021-02-15'), (11, 'aaa', '课代表超能少年aaa', '巴顿将军上补习班先进技术你睡吧下边', '2021-02-14'), (23, 'JDK123', 'asdqwe', 'sadasdasfafsaszxczxczxc', '2021-02-23'), (24, 'root', 'aaaqwewe', 'asdasddasdasdas', '2021-02-23'); -- -------------------------------------------------------- -- -- 表的结构 `think_daily_user` -- CREATE TABLE IF NOT EXISTS `think_daily_user` ( `id` int(11) NOT NULL, `name` text NOT NULL, `level` text NOT NULL, `time` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `id_3` (`id`), KEY `id_2` (`id`), KEY `id_4` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `think_daily_user` -- INSERT INTO `think_daily_user` (`id`, `name`, `level`, `time`) VALUES (14, 'bbb', '2', '2021-02-23 18:22'), (11, 'aaa', '2', '2021-02-23 18:25'), (15, 'ccc', '1', '2021-02-23 18:26'), (13, 'root', '2', '2021-02-23 18:18'), (16, 'ddd', '6', '2021-02-15 01:08'), (21, 'JDK123', '7', '2021-02-23 04:33'), (22, 'aaa123', '4', '2021-02-23 04:47'); -- -------------------------------------------------------- -- -- 表的结构 `think_impact_mapsport` -- CREATE TABLE IF NOT EXISTS `think_impact_mapsport` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ; -- -- 转存表中的数据 `think_impact_mapsport` -- INSERT INTO `think_impact_mapsport` (`id`, `name`, `latitude`, `longitude`) VALUES (9, 'Name:root@AAA', 37.42249904147249, -122.08527490496635), (11, 'Name:aaa@QWEDAS', 37.42170582409102, -122.08545930683611), (17, 'Name:root@ASDFGHJ', 37.421603043379015, -122.08411853760482), (19, 'Name:aaa@AAAA', 37.42151410865942, -122.08368435502051); -- -------------------------------------------------------- -- -- 表的结构 `think_user` -- CREATE TABLE IF NOT EXISTS `think_user` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` text, `password` text, `telephone` int(11) DEFAULT NULL, `level` text, `role` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; -- -- 转存表中的数据 `think_user` -- INSERT INTO `think_user` (`id`, `name`, `password`, `telephone`, `level`, `role`) VALUES (15, 'ccc', '12345678', 649846797, '8', 'User'), (14, 'bbb', '12345678', 2147483647, '4', 'User'), (13, 'root', '55555555', 646578757, '69', 'SuperUser'), (12, 'hhh', '12345678', 646578757, '0', 'User'), (11, 'aaa', '77777777', 2147483647, '32', 'Organizer'), (16, 'ddd', '12345678', 2147483647, '6', 'User'), (17, 'eee', '12345678', 545678437, '0', 'User'), (18, 'ggg', '12345678', 2147483647, '0', 'User'), (19, 'fff', '12345678', 248676497, '0', 'User'), (20, 'admin', '88888888', 248676497, '0', 'SuperUser'), (21, 'JDK123', '11111111', 16546546, '7', 'User'), (22, 'aaa123', '123123123', 1254875215, '4', 'Organizer'); -- -------------------------------------------------------- -- -- 表的结构 `think_user_friend` -- CREATE TABLE IF NOT EXISTS `think_user_friend` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `friend` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `id_2` (`id`), UNIQUE KEY `id_3` (`id`), UNIQUE KEY `id_4` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ; -- -- 转存表中的数据 `think_user_friend` -- INSERT INTO `think_user_friend` (`id`, `name`, `friend`) VALUES (13, 'root', '14@19@21@11@15@16'), (11, 'aaa', '19@16@15@14@23@24'), (15, 'ccc', '11@14'), (16, 'ddd', '14@11'), (21, 'JDK123', '11@14'), (22, 'aaa123', '16@11'), (14, 'bbb', '23'); /*!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 */;