-
Notifications
You must be signed in to change notification settings - Fork 3
/
pureftp.sql
18 lines (17 loc) · 905 Bytes
/
pureftp.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TABLE `ftpd` (
`User` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`Password` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`Uid` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ftpuser',
`Gid` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ftpgroup',
`Dir` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '/ftpdata',
`ULBandwidth` smallint(5) NOT NULL DEFAULT '0',
`DLBandwidth` smallint(5) NOT NULL DEFAULT '0',
`comment` tinytext COLLATE utf8_unicode_ci NOT NULL,
`ipaccess` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
`QuotaSize` int(10) NOT NULL DEFAULT '0',
`QuotaFiles` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `ftpd`
ADD PRIMARY KEY (`User`),
ADD UNIQUE KEY `User` (`User`);