create database ftpse character set 'utf8';
use ftpse;

CREATE TABLE ftplist (
	id int(11) NOT NULL auto_increment ,
	ftpname varchar(255) NOT NULL ,
	ftpserver varchar(255) NOT NULL ,
	ftpport int not null default 21 ,
	ftpuser varchar(50) NULL ,
	ftppass varchar(80) NULL ,
	ftpacct varchar(50) NULL ,
	ftptype int not NULL default 0 ,
	proxyid int not NULL default 0 ,	
	ftplevel int not NULL default 0 ,	
	ftpweb varchar(255) null,
	flag int not NULL default 0 ,	
	updateweekday int not null default 0,
	updatedaytime int not null default 0,
	lastupdate	DATETIME null,
	filecount int not null default 0,
	sumsize bigint not null default 0,
	PRIMARY KEY  (id)
) CHARACTER SET utf8;

CREATE TABLE proxylist (
	id int(11) NOT NULL auto_increment ,
	proxyname varchar(255) NOT NULL ,
	proxyserver varchar(255) NOT NULL ,
	proxyport int not null default 21 ,
	proxyuser varchar(50) NOT NULL ,
	proxypass varchar(80) NOT NULL ,
	ftpacct varchar(50) NOT NULL ,
	proxytype int not NULL default 0 ,	
	flag int not NULL default 0 ,	
	PRIMARY KEY  (id)
)CHARACTER SET utf8;

CREATE TABLE filelist (
	id int(11) NOT NULL auto_increment ,
	ftpid int not NULL ,
	filename varchar(255) NOT NULL ,
	filedir varchar(255) NOT NULL ,
	filesize int not null default 0 ,
	filetime varchar(50) NOT NULL ,
	filetype int not NULL default 0 ,
	flag int not NULL default 0 ,	
	PRIMARY KEY  (id)
) CHARACTER SET utf8 ;


--Web FTPSE RC4 ݿ 2GļС
--RC3ǰֻҪִ
alter table filelist modify filesize bigint default 0;
alter table ftplist modify sumsize bigint default 0;