
复制 CREATE TABLE ftpgroup ( groupname varchar(16) NOT NULL default ”,装设置
gid smallint(6) NOT NULL default ‘5500′, members varchar(16) NOT NULL default ”, KEY groupname (groupname) TYPE=MyISAMCOMMENT=’ProFTP group table’; CREATE TABLE ftpuser ( id int(10) unsigned NOT NULL auto_increment, userid varchar(32) NOT NULL default ”, passwd varchar(32) NOT NULL default ”, uid smallint(6) NOT NULL default ‘5500′, gid smallint(6) NOT NULL default ‘5500′, homedir varchar(255) NOT NULL default ”, shell varchar(16) NOT NULL default ‘/sbin/nologin’, count int(11) NOT NULL default ‘0′, accessed datetime NOT NULL default ‘0000-00-00 00:00:00′, modified datetime NOT NULL default ‘0000-00-00 00:00:00′, PRIMARY KEY (id), UNIQUE KEY userid (userid) ) TYPE=MyISAMCOMMENT=’ProFTP user table’; 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.