The current repo belongs to Closed status, and some functions are restricted. For details, please refer to the description of repo status
2 Star 2 Fork 1

闪电侠的右手/php网站实现文件上传管理
Closed

Create your Gitee Account
Explore and code with more than 13.5 million developers,Free private repositories !:)
Sign up
文件
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
internetjc.sql 6.18 KB
Copy Edit Raw Blame History
fansOfTech authored 7 years ago . first commit
-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 2017-07-26 03:18:36
-- 服务器版本: 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: `useradmin`
--
-- --------------------------------------------------------
--
-- 表的结构 `company`
--
CREATE TABLE `company` (
`id` int(11) UNSIGNED NOT NULL,
`company` varchar(255) DEFAULT NULL,
`comFirstCharter` varchar(10) DEFAULT NULL,
`Charter_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `company`
--
INSERT INTO `company` (`id`, `company`, `comFirstCharter`, `Charter_id`) VALUES
(4, '索尼', 'S', 19),
(3, '松下', 'S', 19),
(5, '百度', 'B', 2),
(6, '谷歌', 'G', 7),
(7, '微软', 'W', 23),
(8, '网易', 'W', 23),
(9, '腾讯', 'T', 20),
(10, '阿里巴巴', 'A', 1),
(11, '淘宝', 'T', 20),
(12, '51rgb', '5', 27);
-- --------------------------------------------------------
--
-- 表的结构 `com_charter`
--
CREATE TABLE `com_charter` (
`Charter_id` int(10) UNSIGNED NOT NULL,
`charter` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `com_charter`
--
INSERT INTO `com_charter` (`Charter_id`, `charter`) VALUES
(1, 'A'),
(2, 'B'),
(3, 'C'),
(4, 'D'),
(5, 'E'),
(6, 'F'),
(7, 'G'),
(8, 'H'),
(9, 'I'),
(10, 'J'),
(11, 'K'),
(12, 'L'),
(13, 'M'),
(14, 'N'),
(15, 'O'),
(16, 'P'),
(17, 'Q'),
(18, 'R'),
(19, 'S'),
(20, 'T'),
(21, 'U'),
(22, 'V'),
(23, 'W'),
(24, 'X'),
(25, 'Y'),
(26, 'Z'),
(27, '123');
-- --------------------------------------------------------
--
-- 表的结构 `msg`
--
CREATE TABLE `msg` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(30) DEFAULT NULL,
`company` varchar(100) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`message` longtext,
`situation` varchar(5) DEFAULT '0',
`reply` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `msg`
--
INSERT INTO `msg` (`id`, `username`, `company`, `phone`, `message`, `situation`, `reply`) VALUES
(1, 'admin', '阿里巴巴', '12345678901', '你好', '0', '你好3'),
(3, 'test', '索尼', '', '你好1', '0', '你好11');
-- --------------------------------------------------------
--
-- 表的结构 `upload`
--
CREATE TABLE `upload` (
`id` int(10) UNSIGNED NOT NULL,
`fname` varchar(255) DEFAULT NULL,
`fpath` varchar(255) DEFAULT NULL,
`fsize` varchar(20) DEFAULT NULL,
`company` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `upload`
--
INSERT INTO `upload` (`id`, `fname`, `fpath`, `fsize`, `company`) VALUES
(1, 'readme.txt', 'files/阿里巴巴/readme.txt', '1.42KB', '阿里巴巴'),
(3, 'stylers.model.xml', 'files/阿里巴巴/stylers.model.xml', '114.89KB', '阿里巴巴'),
(4, 'langs.model.xml', 'files/百度/langs.model.xml', '275.28KB', '百度'),
(5, 'functionList.xml', 'files/阿里巴巴/functionList.xml', '56.53KB', '阿里巴巴'),
(6, 'contextMenu.xml', 'files/阿里巴巴/contextMenu.xml', '3.51KB', '阿里巴巴'),
(7, 'stylers.model.xml', 'files/百度/stylers.model.xml', '114.89KB', '百度'),
(9, 'SciLexer.dll', 'files/阿里巴巴/SciLexer.dll', '1028.17KB', '阿里巴巴'),
(10, 'mimeTools.dll', 'files/百度/mimeTools.dll', '96.67KB', '百度'),
(11, 'NppExport.dll', 'files/百度/NppExport.dll', '21.17KB', '百度'),
(12, 'PluginManager.dll', 'files/松下/PluginManager.dll', '398.17KB', '松下'),
(14, 'gpup.exe', 'files/阿里巴巴/gpup.exe', '279.17KB', '阿里巴巴');
-- --------------------------------------------------------
--
-- 表的结构 `useradmin`
--
CREATE TABLE `useradmin` (
`id` int(11) UNSIGNED NOT NULL,
`username` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
`seed1` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`seed2` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`class` varchar(10) CHARACTER SET utf8 DEFAULT '0',
`company` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 转存表中的数据 `useradmin`
--
INSERT INTO `useradmin` (`id`, `username`, `seed1`, `password`, `seed2`, `class`, `company`) VALUES
(5, 'admin', ']d_zFmT2R&C{', '3a9215b9384fb0987b9d9ba8e4fb9ee6fa27e8b94e63378262258050a25a53b5', 'q6oK?(JI69%7&_O1', '1', '阿里巴巴'),
(4, 'test', 'wfO', '056888fd15333561af3f5b13f8479bd23da77f0f3b82bce7ea32d1ea8f2b7f37', 'd;-', '0', '索尼'),
(6, '', 'm9jxf[;4UGx7_vm', 'd9da0ffb1a360c57c05cfc6f701dcd5b6c82593eafbc85b190e3f1b876d784f8', 'yv%a*z|sr]j', '0', '');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `company`
--
ALTER TABLE `company`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `com_charter`
--
ALTER TABLE `com_charter`
ADD PRIMARY KEY (`Charter_id`);
--
-- Indexes for table `msg`
--
ALTER TABLE `msg`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `upload`
--
ALTER TABLE `upload`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `useradmin`
--
ALTER TABLE `useradmin`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `company`
--
ALTER TABLE `company`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- 使用表AUTO_INCREMENT `com_charter`
--
ALTER TABLE `com_charter`
MODIFY `Charter_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- 使用表AUTO_INCREMENT `msg`
--
ALTER TABLE `msg`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 使用表AUTO_INCREMENT `upload`
--
ALTER TABLE `upload`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- 使用表AUTO_INCREMENT `useradmin`
--
ALTER TABLE `useradmin`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
/*!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 */;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/shaoeric/php_web_site_implementation_of_file_upload_management.git
git@gitee.com:shaoeric/php_web_site_implementation_of_file_upload_management.git
shaoeric
php_web_site_implementation_of_file_upload_management
php网站实现文件上传管理
master

Search