- 论坛徽章:
- 0
|
这个乱码就不要管它了...是中文来的。
还有phpmyadmin的导出信息也不要管,看有效内容就行了
(create table 和 insert info)
改了后是这样子的:
-------------------------------------------------------------------------------
-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2008 骞?06 鏈?23 鏃?22:41
-- 鏈嶅姟鍣ㄧ増鏈? 5.1.25
-- PHP 鐗堟湰: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- 鏁版嵁搴? `ftpusers`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`Username` varchar(35) NOT NULL DEFAULT '',
`Password` char(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
PRIMARY KEY (`Username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`admin`
--
INSERT INTO `admin` (`Username`, `Password`) VALUES
('admin', 'f9b48d49a111e1d9d7751591f1e2ea59');
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`User` varchar(16) NOT NULL,
`Password` varbinary(32) NOT NULL,
`Uid` int(11) NOT NULL DEFAULT '14',
`Gid` int(11) NOT NULL DEFAULT '5',
`Dir` varchar(12 NOT NULL,
`QuotaFiles` int(10) NOT NULL DEFAULT '500',
`QuotaSize` int(10) NOT NULL DEFAULT '30',
`ULBandwidth` int(10) NOT NULL DEFAULT '80',
`DLBandwidth` int(10) NOT NULL DEFAULT '80',
`Ipaddress` varchar(15) NOT NULL DEFAULT '*',
`Comment` tinytext NOT NULL,
`Status` enum('0','1') NOT NULL DEFAULT '1',
`ULRatio` smallint(5) NOT NULL DEFAULT '1',
`DLRatio` smallint(5) NOT NULL DEFAULT '1',
PRIMARY KEY (`User`),
FULLTEXT KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`users`
--
INSERT INTO `users` (`User`, `Password`, `Uid`, `Gid`, `Dir`, `QuotaFiles`, `QuotaSize`, `ULBandwidth`, `DLBandwidth`, `Ipaddress`, `Comment`, `Status`, `ULRatio`, `DLRatio`) VALUES
('ftpuser_1', 'f9b48d49a111e1d9d7751591f1e2ea59', 65534, 31, '/usr', 100, 50, 75, 75, '*', 'Ftp user', '1', 0, 0);
[ 本帖最后由 combye 于 2008-6-24 14:26 编辑 ] |
|