| | |
| | | `disablesmtp` enum('n','y') NOT NULL default 'n', |
| | | `disablesieve` enum('n','y') NOT NULL default 'n', |
| | | `disablelda` enum('n','y') NOT NULL default 'n', |
| | | `disabledoveadm` enum('n','y') NOT NULL default 'n', |
| | | PRIMARY KEY (`mailuser_id`), |
| | | KEY `server_id` (`server_id`,`email`), |
| | | KEY `email_access` (`email`,`access`) |
| | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `sys_theme` |
| | | -- |
| | | |
| | | CREATE TABLE IF NOT EXISTS `sys_theme` ( |
| | | `var_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| | | `tpl_name` varchar(32) NOT NULL, |
| | | `username` varchar(64) NOT NULL, |
| | | `logo_url` varchar(255) NOT NULL, |
| | | PRIMARY KEY (`var_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `sys_user` |
| | | -- |
| | |
| | | `ssl_request` mediumtext NULL, |
| | | `ssl_cert` mediumtext NULL, |
| | | `ssl_bundle` mediumtext NULL, |
| | | `ssl_key` mediumtext NULL, |
| | | `ssl_action` varchar(16) NULL, |
| | | `stats_password` varchar(255) default NULL, |
| | | `stats_type` varchar(255) default 'webalizer', |
| | |
| | | -- Dumping data for table `sys_user` |
| | | -- |
| | | |
| | | INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default', 'global', 'themes/default/images/header_logo.png'); |
| | | INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default-v2', 'global', 'themes/default-v2/images/header_logo.png'); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Dumping data for table `sys_user` |
| | | -- |
| | | |
| | | INSERT INTO `sys_user` (`userid`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `username`, `passwort`, `modules`, `startmodule`, `app_theme`, `typ`, `active`, `language`, `groups`, `default_group`, `client_id`) VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'dashboard,admin,client,mail,monitor,sites,dns,vm,tools,help', 'dashboard', 'default', 'admin', 1, 'en', '1,2', 1, 0); |
| | | |
| | | -- -------------------------------------------------------- |