| | |
| | | -- Tabellenstruktur für Tabelle `client` |
| | | -- |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 0; |
| | | |
| | | CREATE TABLE `client` ( |
| | | `client_id` bigint(20) NOT NULL auto_increment, |
| | | `sys_userid` int(11) NOT NULL default '0', |
| | |
| | | `dl_ratio` int(11) NOT NULL default '-1', |
| | | `ul_bandwidth` int(11) NOT NULL default '-1', |
| | | `dl_bandwidth` int(11) NOT NULL default '-1', |
| | | PRIMARY KEY (`ftp_user_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | PRIMARY KEY (`ftp_user_id`), |
| | | KEY `active` (`active`), |
| | | KEY `server_id` (`server_id`), |
| | | KEY `username` (`username`), |
| | | KEY `quota_files` (`quota_files`) |
| | | ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `ftp_user` |
| | |
| | | `updated` tinyint(4) NOT NULL default '0', |
| | | `active` tinyint(4) NOT NULL default '1', |
| | | PRIMARY KEY (`server_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `server` |
| | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | |
| | | CREATE TABLE `shell_user` ( |
| | | `shell_user_id` bigint(20) NOT NULL auto_increment, |
| | | `sys_userid` int(11) NOT NULL default '0', |
| | |
| | | `pgroup` varchar(255) default NULL, |
| | | `shell` varchar(255) NOT NULL default '/bin/bash', |
| | | `dir` varchar(255) default NULL, |
| | | `chroot` varchar(255) NOT NULL, |
| | | PRIMARY KEY (`shell_user_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; |
| | | |
| | | |
| | | -- |
| | | -- Daten für Tabelle `shell_user` |
| | |
| | | `times` tinyint(1) NOT NULL default '1', |
| | | `login_time` timestamp NOT NULL default '0000-00-00 00:00:00' |
| | | ); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |