| | |
| | | `limit_cron_frequency` int(11) NOT NULL default '5', |
| | | `limit_traffic_quota` int(11) NOT NULL default '-1', |
| | | `limit_client` int(11) NOT NULL default '0', |
| | | `limit_mailmailinglist` int(11) NOT NULL default '-1', |
| | | `parent_client_id` int(11) unsigned NOT NULL default '0', |
| | | `username` varchar(64) default NULL, |
| | | `password` varchar(64) default NULL, |
| | |
| | | `template_master` int(11) unsigned NOT NULL default '0', |
| | | `template_additional` varchar(255) NOT NULL default '', |
| | | `created_at` bigint(20) DEFAULT NULL, |
| | | `id_rsa` VARCHAR( 2000 ) NOT NULL default '', |
| | | `ssh_rsa` VARCHAR( 600 ) NOT NULL default '', |
| | | PRIMARY KEY (`client_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | |
| | | `limit_cron_frequency` int(11) NOT NULL default '5', |
| | | `limit_traffic_quota` int(11) NOT NULL default '-1', |
| | | `limit_client` int(11) NOT NULL default '0', |
| | | `limit_mailmailinglist` int(11) NOT NULL default '-1', |
| | | PRIMARY KEY (`template_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `mail_mailman_domain` |
| | | -- |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `mail_mailinglist` |
| | | -- |
| | | |
| | | CREATE TABLE `mail_mailman_domain` ( |
| | | `mailman_id` int(11) unsigned NOT NULL auto_increment, |
| | | CREATE TABLE `mail_mailinglist` ( |
| | | `mailinglist_id` int(11) unsigned NOT NULL auto_increment, |
| | | `sys_userid` int(11) unsigned NOT NULL default '0', |
| | | `sys_groupid` int(11) unsigned NOT NULL default '0', |
| | | `sys_perm_user` varchar(5) NOT NULL, |
| | | `sys_perm_group` varchar(5) NOT NULL, |
| | | `sys_perm_other` varchar(5) NOT NULL, |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `domain` varchar(255) NOT NULL default '', |
| | | `mm_home` varchar(255) NOT NULL default '', |
| | | `mm_wrap` varchar(255) NOT NULL default '', |
| | | `mm_user` varchar(50) NOT NULL default '', |
| | | `mm_group` varchar(50) NOT NULL default '', |
| | | PRIMARY KEY (`mailman_id`,`server_id`,`domain`) |
| | | `domain` varchar(255) NOT NULL, |
| | | `listname` varchar(255) NOT NULL, |
| | | `email` varchar(255) NOT NULL, |
| | | `password` varchar(255) NOT NULL, |
| | | PRIMARY KEY (`mailinglist_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | `shell` varchar(255) NOT NULL default '/bin/bash', |
| | | `dir` varchar(255) default NULL, |
| | | `chroot` varchar(255) NOT NULL, |
| | | `ssh_rsa` VARCHAR( 600 ) NOT NULL default '', |
| | | PRIMARY KEY (`shell_user_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | |
| | | `action` char(1) NOT NULL default '', |
| | | `tstamp` int(11) NOT NULL default '0', |
| | | `user` varchar(255) NOT NULL default '', |
| | | `data` text NOT NULL, |
| | | `status` set('pending','ok','warning','error') NOT NULL default 'pending', |
| | | `data` longtext NOT NULL, |
| | | `status` set('pending','ok','warning','error') NOT NULL default 'ok', |
| | | PRIMARY KEY (`datalog_id`), |
| | | KEY `server_id` (`server_id`,`status`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | |
| | | `groups` varchar(255) NOT NULL default '', |
| | | `default_group` int(11) unsigned NOT NULL default '0', |
| | | `client_id` int(11) unsigned NOT NULL default '0', |
| | | |
| | | PRIMARY KEY (`userid`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.3.1'); |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.3.3'); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |