复制 -- 数据库: `proftpd` -- -- -------------------------------------------------------- -- -- 表的据库结构 `ftpgroups` -- CREATE TABLE `ftpgroups` ( `groupname` varchar(30) NOT NULL default , `gid` int(11) NOT NULL default 1000, `members` varchar(255) NOT NULL default ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 表的结构 `ftpusers` -- CREATE TABLE `ftpusers` ( `userid` varchar(30) NOT NULL default , `passwd` varchar(80) NOT NULL default , `uid` int(10) unsigned NOT NULL default 1000, `gid` int(10) unsigned NOT NULL default 1000, `homedir` varchar(255) NOT NULL default , `shell` varchar(255) NOT NULL default /sbin/nologin, `count` int(10) unsigned NOT NULL default 0, `host` varchar(30) NOT NULL default , `lastlogin` varchar(30) NOT NULL default , UNIQUE KEY `userid` (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- 导出表中的云服务器数据 `ftpusers` -- INSERT INTO `ftpusers` VALUES (test, test, 1000, 1000, /home/test, /sbin/nologin,0,,); -- -------------------------------------------------------- -- -- 表的结构 `quotalimits` -- CREATE TABLE `quotalimits` ( `name` varchar(30) default NULL, `quota_type` enum(user,group,class,all) NOT NULL default user, `per_session` enum(false,true) NOT NULL default false, `limit_type` enum(soft,hard) NOT NULL default soft, `bytes_in_avail` float NOT NULL default 0, `bytes_out_avail` float NOT NULL default 0, `bytes_xfer_avail` float NOT NULL default 0, `files_in_avail` int(10) unsigned NOT NULL default 0, `files_out_avail` int(10) unsigned NOT NULL default 0, `files_xfer_avail` int(10) unsigned NOT NULL default 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 表的香港云服务器结构 `quotatallies` -- CREATE TABLE `quotatallies` ( `name` varchar(30) NOT NULL default , `quota_type` enum(user,group,class,all) NOT NULL default user, `bytes_in_used` float NOT NULL default 0, `bytes_out_used` float NOT NULL default 0, `bytes_xfer_used` float NOT NULL default 0, `files_in_used` int(10) unsigned NOT NULL default 0, `files_out_used` int(10) unsigned NOT NULL default 0, `files_xfer_used` int(10) unsigned NOT NULL default 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.115.116.117.118.119.120.121. |
喜欢
讨厌