| | |
| | | `limit_hterror` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_ssl` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_web_subdomain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_web_aliasdomain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_ftp_user` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | `ssh_chroot` varchar(255) NOT NULL DEFAULT 'no,jailkit,ssh-chroot', |
| | | `limit_webdav_user` int(11) NOT NULL DEFAULT '0', |
| | | `limit_backup` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'y', |
| | | `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n', |
| | | `limit_aps` int(11) NOT NULL DEFAULT '-1', |
| | | `default_dnsserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `db_servers` blob, |
| | |
| | | `default_dbserver` int(11) NOT NULL DEFAULT '1', |
| | | `dns_servers` blob, |
| | | `limit_database` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_quota` int(11) NOT NULL default '-1', |
| | | `limit_cron` int(11) NOT NULL DEFAULT '0', |
| | | `limit_cron_type` enum('url','chrooted','full') NOT NULL DEFAULT 'url', |
| | |
| | | `limit_hterror` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_ssl` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_web_subdomain` int(11) NOT NULL default '-1', |
| | | `limit_web_aliasdomain` int(11) NOT NULL default '-1', |
| | | `limit_ftp_user` int(11) NOT NULL default '-1', |
| | |
| | | `ssh_chroot` varchar(255) NOT NULL DEFAULT 'no', |
| | | `limit_webdav_user` int(11) NOT NULL default '0', |
| | | `limit_backup` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'y', |
| | | `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n', |
| | | `limit_aps` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_dns_zone` int(11) NOT NULL default '-1', |
| | | `limit_dns_slave_zone` int(11) NOT NULL default '-1', |
| | | `limit_dns_record` int(11) NOT NULL default '-1', |
| | | `limit_database` int(11) NOT NULL default '-1', |
| | | `limit_database_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_quota` int(11) NOT NULL default '-1', |
| | | `limit_cron` int(11) NOT NULL default '0', |
| | | `limit_cron_type` enum('url','chrooted','full') NOT NULL default 'url', |
| | |
| | | `id_rsa` VARCHAR( 2000 ) NOT NULL default '', |
| | | `ssh_rsa` VARCHAR( 600 ) NOT NULL default '', |
| | | `lost_password_function` tinyint(1) NOT NULL default '1', |
| | | `lost_password_hash` VARCHAR(50) NOT NULL default '', |
| | | `lost_password_reqtime` DATETIME NULL default NULL, |
| | | PRIMARY KEY (`userid`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | `database_name` varchar(64) DEFAULT NULL, |
| | | `database_name_prefix` varchar(50) NOT NULL default '', |
| | | `database_quota` int(11) unsigned DEFAULT NULL, |
| | | `quota_exceeded` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `last_quota_notification` date NULL default NULL, |
| | | `database_user_id` int(11) unsigned DEFAULT NULL, |
| | | `database_ro_user_id` int(11) unsigned DEFAULT NULL, |