ProFTPD是继Wu-FTP之后最为流行的FTP服务器软件。我们来看看Proftpd 建表的代码。
- CREATE TABLE FTPGRPS(
- groupname text NOT NULL,
- gid smallint(6) NOT NULL default 0,
- members text NOT NULL
- )
- INSERT INTO FTPGRPS VALUES ('FTPGRP', 2001, 'FTPUSR');
- INSERT INTO FTPGRPS VALUES ('ftpusers', 2002, 'ftp');
- CREATE TABLE FTPUSERS (
- userid text NOT NULL,
- passwd text NOT NULL,
- uid int(11) NOT NULL default '0',
- gid int(11) NOT NULL default '0',
- homedir text,
- shell text
- )
- INSERT INTO FTPUSERS VALUES ('lcx1', '123456', 2001, 2001, '/home/www/lcx1', "");
- 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
- )
- CREATE TABLE quotatallies (
- name VARCHAR(30) NOT NULL,
- quota_type ENUM("user", "group", "class", "all") NOT NULL,
- bytes_in_used FLOAT NOT NULL,
- bytes_out_used FLOAT NOT NULL,
- bytes_xfer_used FLOAT NOT NULL,
- files_in_used INT UNSIGNED NOT NULL,
- files_out_used INT UNSIGNED NOT NULL,
- files_xfer_used INT UNSIGNED NOT NULL
- );
通过上面的代码的说明,你们可以进行Proftpd 建表了,希望对你们有用!
【编辑推荐】