Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you how to write the code for building tables in Proftpd. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

ProFTPD is the most popular FTP server software after Wu-FTP. Let's take a look at the code for Proftpd to build the table.

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)

Through the description of the above code, you can build the Proftpd table, I hope it will be useful to you!

The above is the editor for you to share the Proftpd table of how to write the code, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.