-- ----------------------------------------------------------------------
-- MySQL Migration Toolkit
-- SQL Create Script
-- ----------------------------------------------------------------------
SET FOREIGN_KEY_CHECKS = 0;
CREATE DATABASE IF NOT EXISTS `ftp`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ftp`;
-- -------------------------------------
-- Tables
DROP TABLE IF EXISTS `ftp_users`;
CREATE TABLE `ftp_users` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`ftpUserName` VARCHAR(50) NOT NULL,
`ftpPassword` VARCHAR(50) NOT NULL,
`ftpPasswordType` TINYINT(3) NULL,
`changePassword` TINYINT NOT NULL DEFAULT '1',
`sKey` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(200) NULL,
`dirHome` VARCHAR(200) NOT NULL,
`privilege` TINYINT(3) NULL,
`loginMsgFile` VARCHAR(80) NULL,
`disabled` TINYINT NOT NULL DEFAULT '0',
`sessionEncryption` TINYINT NOT NULL DEFAULT '0',
`dirHomeLock` TINYINT NOT NULL DEFAULT '1',
`hideHidden` TINYINT NOT NULL DEFAULT '1',
`alwaysAllowLogin` TINYINT NOT NULL DEFAULT '0',
`maxUsersConcurrent` SMALLINT(5) NOT NULL DEFAULT 10,
`speedLimitUp` INT(10) NULL DEFAULT -1,
`speedLimitDown` INT(10) NULL DEFAULT -1,
`maxUsersLoginPerIP` SMALLINT(5) NOT NULL DEFAULT 5,
`timeOutIdle` INT(10) NULL,
`timeOutSession` INT(10) NULL DEFAULT -1,
`quotaEnable` TINYINT NOT NULL DEFAULT '1',
`quotaCurrent` BIGINT(19) NULL DEFAULT 0,
`quotaMax` BIGINT(19) NULL DEFAULT 52428800,
`ratioType` TINYINT(3) NULL,
`ratioUp` SMALLINT(5) NULL,
`ratioDown` SMALLINT(5) NULL,
`ratioCredit` FLOAT(53) NULL,
`expiration` DATETIME NULL,
`groups` VARCHAR(80) NULL,
`notes` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `ix_ftp_users__ftpUserName` (`ftpUserName`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `ftp_groupAccess`;
CREATE TABLE `ftp_groupAccess` (
`indexNo` SMALLINT(5) NOT NULL DEFAULT 2,
`ftpUserName` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(200) NOT NULL,
INDEX `ix_ftp_groupAccess__ftpUserName` (`ftpUserName`, `indexNo`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `ftp_groupIPs`;
CREATE TABLE `ftp_groupIPs` (
`indexNo` SMALLINT(5) NOT NULL DEFAULT 2,
`ftpUserName` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(80) NOT NULL,
INDEX `ix_ftp_groupIPs__ftpUserName` (`ftpUserName`, `indexNo`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `ftp_groups`;
CREATE TABLE `ftp_groups` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`ftpUserName` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(200) NULL,
`notes` VARCHAR(255) NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `ix_ftp_groups__ftpUserName` (`ftpUserName`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `ftp_userAccess`;
CREATE TABLE `ftp_userAccess` (
`indexNo` SMALLINT(5) NOT NULL DEFAULT 2,
`ftpUserName` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(200) NOT NULL,
INDEX `ix_ftp_userAccess__ftpUserName` (`ftpUserName`, `indexNo`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `ftp_userIPs`;
CREATE TABLE `ftp_userIPs` (
`indexNo` SMALLINT(5) NOT NULL DEFAULT 2,
`ftpUserName` VARCHAR(50) NOT NULL,
`accessRule` VARCHAR(80) NOT NULL,
INDEX `ix_ftp_userIPs__ftpUserName` (`ftpUserName`, `indexNo`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------------------------------------------------
-- EOF
