"Fossies" - the Fresh Open Source Software Archive

Member "ispconfig3_install/install/sql/ispconfig3.sql" (8 Jun 2021, 114006 Bytes) of package /linux/privat/ISPConfig-3.2.5.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. See also the latest Fossies "Diffs" side-by-side code changes report for "ispconfig3.sql": 3.2.4_vs_3.2.5.

    1 /*
    2 Copyright (c) 2007-2012, Till Brehm, projektfarm Gmbh
    3 All rights reserved.
    4 
    5 Redistribution and use in source and binary forms, with or without modification,
    6 are permitted provided that the following conditions are met:
    7 
    8     * Redistributions of source code must retain the above copyright notice,
    9       this list of conditions and the following disclaimer.
   10     * Redistributions in binary form must reproduce the above copyright notice,
   11       this list of conditions and the following disclaimer in the documentation
   12       and/or other materials provided with the distribution.
   13     * Neither the name of ISPConfig nor the names of its contributors
   14       may be used to endorse or promote products derived from this software without
   15       specific prior written permission.
   16 
   17 THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
   18 ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
   19 WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
   20 IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
   21 INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
   22 BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
   23 DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
   24 OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
   25 NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
   26 EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
   27 */
   28 
   29 -- Includes
   30 --
   31 -- iso_country_list.sql
   32 --
   33 -- This will create and then populate a MySQL table with a list of the names and
   34 -- ISO 3166 codes for countries in existence as of the date below.
   35 --
   36 -- For updates to this file, see http://27.org/isocountrylist/
   37 -- For more about ISO 3166, see http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html
   38 --
   39 -- Created by getisocountrylist.pl on Sun Nov  2 14:59:20 2003.
   40 -- Wm. Rhodes <iso_country_list@27.org>
   41 --
   42 
   43 --
   44 -- ISPConfig 3
   45 -- DB-Version: 3.0.0.9
   46 --
   47 
   48 SET FOREIGN_KEY_CHECKS = 0;
   49 
   50 -- --------------------------------------------------------
   51 -- --------------------------------------------------------
   52 -- DB-STRUCTURE
   53 -- --------------------------------------------------------
   54 -- --------------------------------------------------------
   55 
   56 --
   57 -- Table structure for table `aps_instances`
   58 --
   59 
   60 CREATE TABLE IF NOT EXISTS `aps_instances` (
   61   `id` int(4) NOT NULL AUTO_INCREMENT,
   62   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
   63   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
   64   `sys_perm_user` varchar(5) DEFAULT NULL,
   65   `sys_perm_group` varchar(5) DEFAULT NULL,
   66   `sys_perm_other` varchar(5) DEFAULT NULL,
   67   `server_id` int(11) NOT NULL DEFAULT '0',
   68   `customer_id` int(4) NOT NULL DEFAULT '0',
   69   `package_id` int(4) NOT NULL DEFAULT '0',
   70   `instance_status` int(4) NOT NULL DEFAULT '0',
   71   PRIMARY KEY (`id`)
   72 ) DEFAULT CHARSET=utf8 ;
   73 
   74 -- --------------------------------------------------------
   75 
   76 --
   77 -- Table structure for table `aps_instances_settings`
   78 --
   79 
   80 CREATE TABLE IF NOT EXISTS `aps_instances_settings` (
   81   `id` int(4) NOT NULL AUTO_INCREMENT,
   82   `server_id` int(11) NOT NULL DEFAULT '0',
   83   `instance_id` int(4) NOT NULL DEFAULT '0',
   84   `name` varchar(255) NOT NULL DEFAULT '',
   85   `value` text,
   86   PRIMARY KEY (`id`)
   87 ) DEFAULT CHARSET=utf8 ;
   88 
   89 -- --------------------------------------------------------
   90 
   91 --
   92 -- Table structure for table `aps_packages`
   93 --
   94 
   95 CREATE TABLE IF NOT EXISTS `aps_packages` (
   96   `id` int(4) NOT NULL AUTO_INCREMENT,
   97   `path` varchar(255) NOT NULL DEFAULT '',
   98   `name` varchar(255) NOT NULL DEFAULT '',
   99   `category` varchar(255) NOT NULL DEFAULT '',
  100   `version` varchar(20) NOT NULL DEFAULT '',
  101   `release` int(4) NOT NULL DEFAULT '0',
  102   `package_url` TEXT,
  103   `package_status` int(1) NOT NULL DEFAULT '2',
  104   PRIMARY KEY (`id`)
  105 ) DEFAULT CHARSET=utf8 ;
  106 
  107 -- --------------------------------------------------------
  108 
  109 --
  110 -- Tabellenstruktur für Tabelle `aps_settings`
  111 --
  112 
  113 CREATE TABLE IF NOT EXISTS `aps_settings` (
  114   `id` int(4) NOT NULL AUTO_INCREMENT,
  115   `name` varchar(255) NOT NULL DEFAULT '',
  116   `value` text,
  117   PRIMARY KEY (`id`),
  118   UNIQUE KEY `name` (`name`)
  119 ) DEFAULT CHARSET=utf8 ;
  120 
  121 -- --------------------------------------------------------
  122 
  123 --
  124 -- Table structure for table `attempts_login`
  125 --
  126 
  127 CREATE TABLE `attempts_login` (
  128   `ip` varchar(39) NOT NULL DEFAULT '',
  129   `times` int(11) DEFAULT NULL,
  130   `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  131 ) DEFAULT CHARSET=utf8 ;
  132 
  133 -- --------------------------------------------------------
  134 
  135 --
  136 -- Table structure for table `client`
  137 --
  138 
  139 CREATE TABLE `client` (
  140   `client_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  141   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  142   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  143   `sys_perm_user` varchar(5) DEFAULT NULL,
  144   `sys_perm_group` varchar(5) DEFAULT NULL,
  145   `sys_perm_other` varchar(5) DEFAULT NULL,
  146   `company_name` varchar(64) DEFAULT NULL,
  147   `company_id` varchar(255) DEFAULT NULL,
  148   `gender` enum('','m','f') NOT NULL DEFAULT '',
  149   `contact_firstname` varchar( 64 ) NOT NULL DEFAULT '',
  150   `contact_name` varchar(64) DEFAULT NULL,
  151   `customer_no` varchar(64) DEFAULT NULL,
  152   `vat_id` varchar(64) DEFAULT NULL,
  153   `street` varchar(255) DEFAULT NULL,
  154   `zip` varchar(32) DEFAULT NULL,
  155   `city` varchar(64) DEFAULT NULL,
  156   `state` varchar(32) DEFAULT NULL,
  157   `country` char(2) DEFAULT NULL,
  158   `telephone` varchar(32) DEFAULT NULL,
  159   `mobile` varchar(32) DEFAULT NULL,
  160   `fax` varchar(32) DEFAULT NULL,
  161   `email` varchar(255) DEFAULT NULL,
  162   `internet` varchar(255) NOT NULL DEFAULT '',
  163   `icq` varchar(16) DEFAULT NULL,
  164   `notes` text,
  165   `bank_account_owner` varchar(255) DEFAULT NULL,
  166   `bank_account_number` varchar(255) DEFAULT NULL,
  167   `bank_code` varchar(255) DEFAULT NULL,
  168   `bank_name` varchar(255) DEFAULT NULL,
  169   `bank_account_iban` varchar(255) DEFAULT NULL,
  170   `bank_account_swift` varchar(255) DEFAULT NULL,
  171   `paypal_email` varchar(255) DEFAULT NULL,
  172   `default_mailserver` int(11) unsigned NOT NULL DEFAULT '1',
  173   `mail_servers` text,
  174   `limit_maildomain` int(11) NOT NULL DEFAULT '-1',
  175   `limit_mailbox` int(11) NOT NULL DEFAULT '-1',
  176   `limit_mailalias` int(11) NOT NULL DEFAULT '-1',
  177   `limit_mailaliasdomain` int(11) NOT NULL DEFAULT '-1',
  178   `limit_mailforward` int(11) NOT NULL DEFAULT '-1',
  179   `limit_mailcatchall` int(11) NOT NULL DEFAULT '-1',
  180   `limit_mailrouting` int(11) NOT NULL DEFAULT '0',
  181   `limit_mail_wblist` int(11) NOT NULL DEFAULT '0',
  182   `limit_mailfilter` int(11) NOT NULL DEFAULT '-1',
  183   `limit_fetchmail` int(11) NOT NULL DEFAULT '-1',
  184   `limit_mailquota` int(11) NOT NULL DEFAULT '-1',
  185   `limit_spamfilter_wblist` int(11) NOT NULL DEFAULT '0',
  186   `limit_spamfilter_user` int(11) NOT NULL DEFAULT '0',
  187   `limit_spamfilter_policy` int(11) NOT NULL DEFAULT '0',
  188   `limit_relayhost` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n',
  189   `default_xmppserver` int(11) unsigned NOT NULL DEFAULT '1',
  190   `xmpp_servers` text,
  191   `limit_xmpp_domain` int(11) NOT NULL DEFAULT '-1',
  192   `limit_xmpp_user` int(11) NOT NULL DEFAULT '-1',
  193   `limit_xmpp_muc` ENUM( 'n', 'y' ) NOT NULL default 'n',
  194   `limit_xmpp_anon` ENUM( 'n', 'y' ) NOT NULL default 'n',
  195   `limit_xmpp_auth_options` varchar(255) NOT NULL DEFAULT 'plain,hashed,isp',
  196   `limit_xmpp_vjud` ENUM( 'n', 'y' ) NOT NULL default 'n',
  197   `limit_xmpp_proxy` ENUM( 'n', 'y' ) NOT NULL default 'n',
  198   `limit_xmpp_status` ENUM( 'n', 'y' ) NOT NULL default 'n',
  199   `limit_xmpp_pastebin` ENUM( 'n', 'y' ) NOT NULL default 'n',
  200   `limit_xmpp_httparchive` ENUM( 'n', 'y' ) NOT NULL default 'n',
  201   `default_webserver` int(11) unsigned NOT NULL DEFAULT '1',
  202   `web_servers` text,
  203   `limit_web_ip` text,
  204   `limit_web_domain` int(11) NOT NULL DEFAULT '-1',
  205   `limit_web_quota` int(11) NOT NULL DEFAULT '-1',
  206   `web_php_options` varchar(255) NOT NULL DEFAULT 'no,fast-cgi,cgi,mod,suphp,php-fpm,hhvm',
  207   `limit_cgi` enum('n','y') NOT NULL DEFAULT 'n',
  208   `limit_ssi` enum('n','y') NOT NULL DEFAULT 'n',
  209   `limit_perl` enum('n','y') NOT NULL DEFAULT 'n',
  210   `limit_ruby` enum('n','y') NOT NULL DEFAULT 'n',
  211   `limit_python` enum('n','y') NOT NULL DEFAULT 'n',
  212   `force_suexec` enum('n','y') NOT NULL DEFAULT 'y',
  213   `limit_hterror` enum('n','y') NOT NULL DEFAULT 'n',
  214   `limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n',
  215   `limit_ssl` enum('n','y') NOT NULL DEFAULT 'n',
  216   `limit_ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n',
  217   `limit_web_subdomain` int(11) NOT NULL DEFAULT '-1',
  218   `limit_web_aliasdomain` int(11) NOT NULL DEFAULT '-1',
  219   `limit_ftp_user` int(11) NOT NULL DEFAULT '-1',
  220   `limit_shell_user` int(11) NOT NULL DEFAULT '0',
  221   `ssh_chroot` varchar(255) NOT NULL DEFAULT 'no,jailkit,ssh-chroot',
  222   `limit_webdav_user` int(11) NOT NULL DEFAULT '0',
  223   `limit_backup` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'y',
  224   `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n',
  225   `limit_aps` int(11) NOT NULL DEFAULT '-1',
  226   `default_dnsserver` int(11) unsigned NOT NULL DEFAULT '1',
  227   `db_servers` text,
  228   `limit_dns_zone` int(11) NOT NULL DEFAULT '-1',
  229   `default_slave_dnsserver` int(11) unsigned NOT NULL DEFAULT '1',
  230   `limit_dns_slave_zone` int(11) NOT NULL DEFAULT '-1',
  231   `limit_dns_record` int(11) NOT NULL DEFAULT '-1',
  232   `default_dbserver` int(11) NOT NULL DEFAULT '1',
  233   `dns_servers` text,
  234   `limit_database` int(11) NOT NULL DEFAULT '-1',
  235   `limit_database_user` int(11) NOT NULL DEFAULT '-1',
  236   `limit_database_quota` int(11) NOT NULL default '-1',
  237   `limit_cron` int(11) NOT NULL DEFAULT '0',
  238   `limit_cron_type` enum('url','chrooted','full') NOT NULL DEFAULT 'url',
  239   `limit_cron_frequency` int(11) NOT NULL DEFAULT '5',
  240   `limit_traffic_quota` int(11) NOT NULL DEFAULT '-1',
  241   `limit_client` int(11) NOT NULL DEFAULT '0',
  242   `limit_domainmodule` int(11) NOT NULL DEFAULT '0',
  243   `limit_mailmailinglist` int(11) NOT NULL DEFAULT '-1',
  244   `limit_openvz_vm` int(11) NOT NULL DEFAULT '0',
  245   `limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0',
  246   `parent_client_id` int(11) unsigned NOT NULL DEFAULT '0',
  247   `username` varchar(64) DEFAULT NULL,
  248   `password` varchar(200) DEFAULT NULL,
  249   `language` char(2) NOT NULL DEFAULT 'en',
  250   `usertheme` varchar(32) NOT NULL DEFAULT 'default',
  251   `template_master` int(11) unsigned NOT NULL DEFAULT '0',
  252   `template_additional` text,
  253   `created_at` bigint(20) DEFAULT NULL,
  254   `locked` enum('n','y') NOT NULL DEFAULT 'n',
  255   `canceled` enum('n','y') NOT NULL DEFAULT 'n',
  256   `can_use_api` enum('n','y') NOT NULL DEFAULT 'n',
  257   `tmp_data` mediumblob,
  258   `id_rsa` text,
  259   `ssh_rsa` varchar(600) NOT NULL DEFAULT '',
  260   `customer_no_template` varchar(255) DEFAULT 'R[CLIENTID]C[CUSTOMER_NO]',
  261   `customer_no_start` int(11) NOT NULL DEFAULT '1',
  262   `customer_no_counter` int(11) NOT NULL DEFAULT '0',
  263   `added_date` date NULL DEFAULT NULL,
  264   `added_by` varchar(255) DEFAULT NULL,
  265   `validation_status` enum('accept','review','reject') NOT NULL DEFAULT 'accept',
  266   `risk_score` int(10) unsigned NOT NULL DEFAULT '0',
  267   `activation_code` varchar(10) NOT NULL DEFAULT '',
  268   PRIMARY KEY (`client_id`)
  269 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  270 
  271 -- --------------------------------------------------------
  272 
  273 --
  274 -- Table structure for table `client_circle`
  275 --
  276 
  277 CREATE TABLE `client_circle` (
  278   `circle_id` int(11) NOT NULL AUTO_INCREMENT,
  279   `sys_userid` int(11) NOT NULL DEFAULT '0',
  280   `sys_groupid` int(11) NOT NULL DEFAULT '0',
  281   `sys_perm_user` varchar(5) DEFAULT NULL,
  282   `sys_perm_group` varchar(5) DEFAULT NULL,
  283   `sys_perm_other` varchar(5) DEFAULT NULL,
  284   `circle_name` varchar(64) DEFAULT NULL,
  285   `client_ids` text,
  286   `description` text,
  287   `active` enum('n','y') NOT NULL default 'y',
  288   PRIMARY KEY (`circle_id`)
  289 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  290 
  291 -- --------------------------------------------------------
  292 
  293 --
  294 -- Table structure for table  `client_template`
  295 --
  296 
  297 CREATE TABLE `client_template` (
  298   `template_id` int(11) unsigned NOT NULL auto_increment,
  299   `sys_userid` int(11) unsigned NOT NULL default '0',
  300   `sys_groupid` int(11) unsigned NOT NULL default '0',
  301   `sys_perm_user` varchar(5) default NULL,
  302   `sys_perm_group` varchar(5) default NULL,
  303   `sys_perm_other` varchar(5) default NULL,
  304   `template_name` varchar(64) NOT NULL DEFAULT '',
  305   `template_type` varchar(1) NOT NULL default 'm',
  306   `mail_servers` text,
  307   `limit_maildomain` int(11) NOT NULL default '-1',
  308   `limit_mailbox` int(11) NOT NULL default '-1',
  309   `limit_mailalias` int(11) NOT NULL default '-1',
  310   `limit_mailaliasdomain` int(11) NOT NULL default '-1',
  311   `limit_mailforward` int(11) NOT NULL default '-1',
  312   `limit_mailcatchall` int(11) NOT NULL default '-1',
  313   `limit_mailrouting` int(11) NOT NULL default '0',
  314   `limit_mail_wblist` int(11) NOT NULL default '0',
  315   `limit_mailfilter` int(11) NOT NULL default '-1',
  316   `limit_fetchmail` int(11) NOT NULL default '-1',
  317   `limit_mailquota` int(11) NOT NULL default '-1',
  318   `limit_spamfilter_wblist` int(11) NOT NULL default '0',
  319   `limit_spamfilter_user` int(11) NOT NULL default '0',
  320   `limit_spamfilter_policy` int(11) NOT NULL default '0',
  321   `limit_relayhost` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n',
  322   `default_xmppserver` int(11) unsigned NOT NULL DEFAULT '1',
  323   `xmpp_servers` text,
  324   `limit_xmpp_domain` int(11) NOT NULL DEFAULT '-1',
  325   `limit_xmpp_user` int(11) NOT NULL DEFAULT '-1',
  326   `limit_xmpp_muc` ENUM( 'n', 'y' ) NOT NULL default 'n',
  327   `limit_xmpp_anon` ENUM( 'n', 'y' ) NOT NULL default 'n',
  328   `limit_xmpp_vjud` ENUM( 'n', 'y' ) NOT NULL default 'n',
  329   `limit_xmpp_proxy` ENUM( 'n', 'y' ) NOT NULL default 'n',
  330   `limit_xmpp_status` ENUM( 'n', 'y' ) NOT NULL default 'n',
  331   `limit_xmpp_pastebin` ENUM( 'n', 'y' ) NOT NULL default 'n',
  332   `limit_xmpp_httparchive` ENUM( 'n', 'y' ) NOT NULL default 'n',
  333   `web_servers` text,
  334   `limit_web_ip` text,
  335   `limit_web_domain` int(11) NOT NULL default '-1',
  336   `limit_web_quota` int(11) NOT NULL default '-1',
  337   `web_php_options` varchar(255) NOT NULL DEFAULT '',
  338   `limit_cgi` enum('n','y') NOT NULL DEFAULT 'n',
  339   `limit_ssi` enum('n','y') NOT NULL DEFAULT 'n',
  340   `limit_perl` enum('n','y') NOT NULL DEFAULT 'n',
  341   `limit_ruby` enum('n','y') NOT NULL DEFAULT 'n',
  342   `limit_python` enum('n','y') NOT NULL DEFAULT 'n',
  343   `force_suexec` enum('n','y') NOT NULL DEFAULT 'y',
  344   `limit_hterror` enum('n','y') NOT NULL DEFAULT 'n',
  345   `limit_wildcard` enum('n','y') NOT NULL DEFAULT 'n',
  346   `limit_ssl` enum('n','y') NOT NULL DEFAULT 'n',
  347   `limit_ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n',
  348   `limit_web_subdomain` int(11) NOT NULL default '-1',
  349   `limit_web_aliasdomain` int(11) NOT NULL default '-1',
  350   `limit_ftp_user` int(11) NOT NULL default '-1',
  351   `limit_shell_user` int(11) NOT NULL default '0',
  352   `ssh_chroot` varchar(255) NOT NULL DEFAULT '',
  353   `limit_webdav_user` int(11) NOT NULL default '0',
  354   `limit_backup` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'y',
  355   `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n',
  356   `limit_aps` int(11) NOT NULL DEFAULT '-1',
  357   `dns_servers` text,
  358   `limit_dns_zone` int(11) NOT NULL default '-1',
  359   `default_slave_dnsserver` int(11) NOT NULL DEFAULT '0',
  360   `limit_dns_slave_zone` int(11) NOT NULL default '-1',
  361   `limit_dns_record` int(11) NOT NULL default '-1',
  362   `db_servers` text,
  363   `limit_database` int(11) NOT NULL default '-1',
  364   `limit_database_user` int(11) NOT NULL DEFAULT '-1',
  365   `limit_database_quota` int(11) NOT NULL default '-1',
  366   `limit_cron` int(11) NOT NULL default '0',
  367   `limit_cron_type` enum('url','chrooted','full') NOT NULL default 'url',
  368   `limit_cron_frequency` int(11) NOT NULL default '5',
  369   `limit_traffic_quota` int(11) NOT NULL default '-1',
  370   `limit_client` int(11) NOT NULL default '0',
  371   `limit_domainmodule` int(11) NOT NULL DEFAULT '0',
  372   `limit_mailmailinglist` int(11) NOT NULL default '-1',
  373   `limit_openvz_vm` int(11) NOT NULL DEFAULT '0',
  374   `limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0',
  375   PRIMARY KEY  (`template_id`)
  376 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  377 
  378 -- --------------------------------------------------------
  379 
  380 --
  381 -- Table structure for table  `client_template_assigned`
  382 --
  383 
  384 CREATE TABLE `client_template_assigned` (
  385   `assigned_template_id` bigint(20) NOT NULL auto_increment,
  386   `client_id` bigint(11) NOT NULL DEFAULT '0',
  387   `client_template_id` int(11) NOT NULL DEFAULT '0',
  388   PRIMARY KEY (`assigned_template_id`),
  389   KEY `client_id` (`client_id`)
  390 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  391 -- --------------------------------------------------------
  392 
  393 --
  394 -- Table structure for table `invoice_message_template`
  395 --
  396 
  397 CREATE TABLE `client_message_template` (
  398   `client_message_template_id` bigint(20) NOT NULL AUTO_INCREMENT,
  399   `sys_userid` int(11) NOT NULL DEFAULT '0',
  400   `sys_groupid` int(11) NOT NULL DEFAULT '0',
  401   `sys_perm_user` varchar(5) DEFAULT NULL,
  402   `sys_perm_group` varchar(5) DEFAULT NULL,
  403   `sys_perm_other` varchar(5) DEFAULT NULL,
  404   `template_type` varchar(255) DEFAULT NULL,
  405   `template_name` varchar(255) DEFAULT NULL,
  406   `subject` varchar(255) DEFAULT NULL,
  407   `message` text,
  408   PRIMARY KEY (`client_message_template_id`)
  409 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  410 
  411 --
  412 -- Dumping data for table `invoice_message_template`
  413 --
  414 
  415 -- --------------------------------------------------------
  416 
  417 --
  418 -- Table structure for table `country`
  419 --
  420 
  421 CREATE TABLE `country` (
  422   `iso` char(2) NOT NULL DEFAULT '',
  423   `name` varchar(64) NOT NULL DEFAULT '',
  424   `printable_name` varchar(64) NOT NULL DEFAULT '',
  425   `iso3` char(3) DEFAULT NULL,
  426   `numcode` smallint(6) DEFAULT NULL,
  427   `eu` enum('n','y') NOT NULL DEFAULT 'n',
  428   PRIMARY KEY (`iso`)
  429 ) DEFAULT CHARSET=utf8 ;
  430 
  431 -- --------------------------------------------------------
  432 
  433 --
  434 -- Table structure for table  `cron`
  435 --
  436 CREATE TABLE `cron` (
  437   `id` int(11) unsigned NOT NULL auto_increment,
  438   `sys_userid` int(11) unsigned NOT NULL default '0',
  439   `sys_groupid` int(11) unsigned NOT NULL default '0',
  440   `sys_perm_user` varchar(5) NULL default NULL,
  441   `sys_perm_group` varchar(5) NULL default NULL,
  442   `sys_perm_other` varchar(5) NULL default NULL,
  443   `server_id` int(11) unsigned NOT NULL default '0',
  444   `parent_domain_id` int(11) unsigned NOT NULL default '0',
  445   `type` enum('url','chrooted','full') NOT NULL default 'url',
  446   `command` TEXT,
  447   `run_min` varchar(100) NULL,
  448   `run_hour` varchar(100) NULL,
  449   `run_mday` varchar(100) NULL,
  450   `run_month` varchar(100) NULL,
  451   `run_wday` varchar(100) NULL,
  452   `log` enum('n','y') NOT NULL default 'n',
  453   `active` enum('n','y') NOT NULL default 'y',
  454   PRIMARY KEY  (`id`)
  455 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  456 
  457 -- --------------------------------------------------------
  458 
  459 --
  460 -- Table structure for table  `directive_snippets`
  461 --
  462 
  463 CREATE TABLE IF NOT EXISTS `directive_snippets` (
  464   `directive_snippets_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  465   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  466   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  467   `sys_perm_user` varchar(5) DEFAULT NULL,
  468   `sys_perm_group` varchar(5) DEFAULT NULL,
  469   `sys_perm_other` varchar(5) DEFAULT NULL,
  470   `name` varchar(255) DEFAULT NULL,
  471   `type` varchar(255) DEFAULT NULL,
  472   `snippet` mediumtext,
  473   `customer_viewable` ENUM('n','y') NOT NULL DEFAULT 'n',
  474   `required_php_snippets` varchar(255) NOT NULL DEFAULT '',
  475   `active` enum('n','y') NOT NULL DEFAULT 'y',
  476   `master_directive_snippets_id` int(11) unsigned NOT NULL DEFAULT '0',
  477   `update_sites` ENUM('y','n') NOT NULL DEFAULT 'n',
  478   PRIMARY KEY (`directive_snippets_id`)
  479 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  480 
  481 -- --------------------------------------------------------
  482 
  483 --
  484 -- Table structure for table  `dns_rr`
  485 --
  486 CREATE TABLE `dns_rr` (
  487   `id` int(11) unsigned NOT NULL auto_increment,
  488   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  489   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  490   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
  491   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
  492   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
  493   `server_id` int(11) NOT NULL default '1',
  494   `zone` int(11) unsigned NOT NULL DEFAULT '0',
  495   `name` varchar(255) NOT NULL DEFAULT '',
  496   `type` enum('A','AAAA','ALIAS','CNAME','DNAME','CAA','DS','HINFO','LOC','MX','NAPTR','NS','PTR','RP','SRV','SSHFP','TXT','TLSA','DNSKEY') default NULL,
  497   `data` TEXT NOT NULL,
  498   `aux` int(11) unsigned NOT NULL default '0',
  499   `ttl` int(11) unsigned NOT NULL default '3600',
  500   `active` enum('N','Y') NOT NULL default 'Y',
  501   `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  502   `serial` int(10) unsigned default NULL,
  503   PRIMARY KEY  (`id`),
  504   KEY `rr` (`zone`,`type`,`name`)
  505 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  506 
  507 -- --------------------------------------------------------
  508 
  509 --
  510 -- Table structure for table  `dns_slave`
  511 --
  512 
  513 CREATE TABLE `dns_slave` (
  514   `id` int(10) unsigned NOT NULL auto_increment,
  515   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  516   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  517   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
  518   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
  519   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
  520   `server_id` int(11) NOT NULL default '1',
  521   `origin` varchar(255) NOT NULL DEFAULT '',
  522   `ns` varchar(255) NOT NULL DEFAULT '',
  523   `active` enum('N','Y') NOT NULL DEFAULT 'N',
  524   `xfer` TEXT NULL,
  525   PRIMARY KEY  (`id`),
  526   UNIQUE KEY `slave` (`origin`,`server_id`),
  527   KEY `active` (`active`)
  528 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  529 
  530 -- --------------------------------------------------------
  531 
  532 --
  533 -- Table structure for table  `dns_ssl_ca`
  534 --
  535 
  536 CREATE TABLE IF NOT EXISTS `dns_ssl_ca` (
  537   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  538   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  539   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  540   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
  541   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
  542   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
  543   `active` enum('N','Y') NOT NULL DEFAULT 'N',
  544   `ca_name` varchar(255) NOT NULL DEFAULT '',
  545   `ca_issue` varchar(255) NOT NULL DEFAULT '',
  546   `ca_wildcard` enum('Y','N') NOT NULL DEFAULT 'N',
  547   `ca_iodef` text NOT NULL,
  548   `ca_critical` tinyint(1) NOT NULL DEFAULT '0',
  549   PRIMARY KEY (`id`),
  550   UNIQUE KEY (`ca_issue`)
  551 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  552 
  553 ALTER TABLE `dns_ssl_ca` ADD UNIQUE(`ca_issue`);
  554 
  555 INSERT INTO `dns_ssl_ca` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `active`, `ca_name`, `ca_issue`, `ca_wildcard`, `ca_iodef`, `ca_critical`) VALUES
  556 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'AC Camerfirma', 'camerfirma.com', 'Y', '', 0),
  557 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'ACCV', 'accv.es', 'Y', '', 0),
  558 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Actalis', 'actalis.it', 'Y', '', 0),
  559 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Amazon', 'amazon.com', 'Y', '', 0),
  560 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Asseco', 'certum.pl', 'Y', '', 0),
  561 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Buypass', 'buypass.com', 'Y', '', 0),
  562 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'CA Disig', 'disig.sk', 'Y', '', 0),
  563 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'CATCert', 'aoc.cat', 'Y', '', 0),
  564 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Certinomis', 'www.certinomis.com', 'Y', '', 0),
  565 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Certizen', 'hongkongpost.gov.hk', 'Y', '', 0),
  566 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'certSIGN', 'certsign.ro', 'Y', '', 0),
  567 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'CFCA', 'cfca.com.cn', 'Y', '', 0),
  568 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Chunghwa Telecom', 'cht.com.tw', 'Y', '', 0),
  569 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Sectigo / Comodo CA', 'comodoca.com', 'Y', '', 0),
  570 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'D-TRUST', 'd-trust.net', 'Y', '', 0),
  571 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'DigiCert', 'digicert.com', 'Y', '', 0),
  572 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'DocuSign', 'docusign.fr', 'Y', '', 0),
  573 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'e-tugra', 'e-tugra.com', 'Y', '', 0),
  574 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'EDICOM', 'edicomgroup.com', 'Y', '', 0),
  575 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Entrust', 'entrust.net', 'Y', '', 0),
  576 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Firmaprofesional', 'firmaprofesional.com', 'Y', '', 0),
  577 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'FNMT', 'fnmt.es', 'Y', '', 0),
  578 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'GlobalSign', 'globalsign.com', 'Y', '', 0),
  579 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'GoDaddy', 'godaddy.com', 'Y', '', 0),
  580 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Google Trust Services', 'pki.goog', 'Y', '', 0),
  581 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'GRCA', 'gca.nat.gov.tw', 'Y', '', 0),
  582 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'HARICA', 'harica.gr', 'Y', '', 0),
  583 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'IdenTrust', 'identrust.com', 'Y', '', 0),
  584 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Izenpe', 'izenpe.com', 'Y', '', 0),
  585 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Kamu SM', 'kamusm.gov.tr', 'Y', '', 0),
  586 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Let''s Encrypt', 'letsencrypt.org', 'Y', '', 0),
  587 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Microsec e-Szigno', 'e-szigno.hu', 'Y', '', 0),
  588 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'NetLock', 'netlock.hu', 'Y', '', 0),
  589 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'PKIoverheid', 'www.pkioverheid.nl', 'Y', '', 0),
  590 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'PROCERT', 'procert.net.ve', 'Y', '', 0),
  591 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'QuoVadis', 'quovadisglobal.com', 'Y', '', 0),
  592 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'SECOM', 'secomtrust.net', 'Y', '', 0),
  593 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Sertifitseerimiskeskuse', 'sk.ee', 'Y', '', 0),
  594 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'StartCom', 'startcomca.com', 'Y', '', 0),
  595 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'SwissSign', 'swisssign.com', 'Y', '', 0),
  596 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Symantec / Thawte / GeoTrust', 'symantec.com', 'Y', '', 0),
  597 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'T-Systems', 'telesec.de', 'Y', '', 0),
  598 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Telia', 'telia.com', 'Y', '', 0),
  599 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Trustwave', 'trustwave.com', 'Y', '', 0),
  600 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Web.com', 'web.com', 'Y', '', 0),
  601 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'WISeKey', 'wisekey.com', 'Y', '', 0),
  602 (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'WoSign', 'wosign.com', 'Y', '', 0);
  603 
  604 -- --------------------------------------------------------
  605 
  606 --
  607 -- Table structure for table  `dns_soa`
  608 --
  609 
  610 CREATE TABLE `dns_soa` (
  611   `id` int(10) unsigned NOT NULL auto_increment,
  612   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
  613   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
  614   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
  615   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
  616   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
  617   `server_id` int(11) NOT NULL default '1',
  618   `origin` varchar(255) NOT NULL DEFAULT '',
  619   `ns` varchar(255) NOT NULL DEFAULT '',
  620   `mbox` varchar(255) NOT NULL DEFAULT '',
  621   `serial` int(11) unsigned NOT NULL default '1',
  622   `refresh` int(11) unsigned NOT NULL default '28800',
  623   `retry` int(11) unsigned NOT NULL default '7200',
  624   `expire` int(11) unsigned NOT NULL default '604800',
  625   `minimum` int(11) unsigned NOT NULL default '3600',
  626   `ttl` int(11) unsigned NOT NULL default '3600',
  627   `active` enum('N','Y') NOT NULL DEFAULT 'N',
  628   `xfer` TEXT NULL,
  629   `also_notify` TEXT NULL,
  630   `update_acl` varchar(255) default NULL,
  631   `dnssec_initialized` ENUM('Y','N') NOT NULL DEFAULT 'N',
  632   `dnssec_wanted` ENUM('Y','N') NOT NULL DEFAULT 'N',
  633   `dnssec_algo` SET('NSEC3RSASHA1','ECDSAP256SHA256') NOT NULL DEFAULT 'ECDSAP256SHA256',
  634   `dnssec_last_signed` BIGINT NOT NULL DEFAULT '0',
  635   `dnssec_info` TEXT NULL,
  636   PRIMARY KEY  (`id`),
  637   UNIQUE KEY `origin` (`origin`),
  638   KEY `active` (`active`)
  639 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  640 
  641 -- --------------------------------------------------------
  642 
  643 --
  644 -- Table structure for table  `dns_template`
  645 --
  646 
  647 CREATE TABLE `dns_template` (
  648   `template_id` int(11) unsigned NOT NULL auto_increment,
  649   `sys_userid` int(11) unsigned NOT NULL default '0',
  650   `sys_groupid` int(11) unsigned NOT NULL default '0',
  651   `sys_perm_user` varchar(5) default NULL,
  652   `sys_perm_group` varchar(5) default NULL,
  653   `sys_perm_other` varchar(5) default NULL,
  654   `name` varchar(64) default NULL,
  655   `fields` varchar(255) default NULL,
  656   `template` text,
  657   `visible` enum('N','Y') NOT NULL default 'Y',
  658   PRIMARY KEY  (`template_id`)
  659 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  660 
  661 --
  662 -- Table structure for table  `domain`
  663 --
  664 
  665 CREATE TABLE `domain` (
  666   `domain_id` int(11) unsigned NOT NULL auto_increment,
  667   `sys_userid` int(11) unsigned NOT NULL default '0',
  668   `sys_groupid` int(11) unsigned NOT NULL default '0',
  669   `sys_perm_user` varchar(5) NOT NULL default '',
  670   `sys_perm_group` varchar(5) NOT NULL default '',
  671   `sys_perm_other` varchar(5) NOT NULL default '',
  672   `domain` varchar(255) NOT NULL default '',
  673   PRIMARY KEY  (`domain_id`),
  674   UNIQUE KEY `domain` (`domain`)
  675 ) DEFAULT CHARSET=utf8 ;
  676 
  677 -- --------------------------------------------------------
  678 
  679 --
  680 -- Table structure for table  `firewall`
  681 --
  682 
  683 CREATE TABLE `firewall` (
  684   `firewall_id` int(11) unsigned NOT NULL auto_increment,
  685   `sys_userid` int(11) unsigned NOT NULL default '0',
  686   `sys_groupid` int(11) unsigned NOT NULL default '0',
  687   `sys_perm_user` varchar(5) default NULL,
  688   `sys_perm_group` varchar(5) default NULL,
  689   `sys_perm_other` varchar(5) default NULL,
  690   `server_id` int(11) unsigned NOT NULL default '0',
  691   `tcp_port` text,
  692   `udp_port` text,
  693   `active` enum('n','y') NOT NULL default 'y',
  694   PRIMARY KEY  (`firewall_id`)
  695 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  696 
  697 -- --------------------------------------------------------
  698 
  699 --
  700 -- Table structure for table  `ftp_user`
  701 --
  702 
  703 CREATE TABLE `ftp_user` (
  704   `ftp_user_id` int(11) unsigned NOT NULL auto_increment,
  705   `sys_userid` int(11) unsigned NOT NULL default '0',
  706   `sys_groupid` int(11) unsigned NOT NULL default '0',
  707   `sys_perm_user` varchar(5) default NULL,
  708   `sys_perm_group` varchar(5) default NULL,
  709   `sys_perm_other` varchar(5) default NULL,
  710   `server_id` int(11) unsigned NOT NULL default '0',
  711   `parent_domain_id` int(11) unsigned NOT NULL default '0',
  712   `username` varchar(64) default NULL,
  713   `username_prefix` varchar(50) NOT NULL default '',
  714   `password` varchar(200) default NULL,
  715   `quota_size` bigint(20) NOT NULL default '-1',
  716   `active` enum('n','y') NOT NULL default 'y',
  717   `uid` varchar(64) default NULL,
  718   `gid` varchar(64) default NULL,
  719   `dir` varchar(255) default NULL,
  720   `quota_files` bigint(20) NOT NULL default '-1',
  721   `ul_ratio` int(11) NOT NULL default '-1',
  722   `dl_ratio` int(11) NOT NULL default '-1',
  723   `ul_bandwidth` int(11) NOT NULL default '-1',
  724   `dl_bandwidth` int(11) NOT NULL default '-1',
  725   `expires` datetime NULL DEFAULT NULL,
  726   `user_type` set('user','system') NOT NULL DEFAULT 'user',
  727   `user_config` text,
  728   PRIMARY KEY  (`ftp_user_id`),
  729   KEY `active` (`active`),
  730   KEY `server_id` (`server_id`),
  731   KEY `username` (`username`),
  732   KEY `quota_files` (`quota_files`)
  733 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  734 
  735 -- --------------------------------------------------------
  736 
  737 --
  738 -- Table structure for table  `ftp_traffic`
  739 --
  740 
  741 CREATE TABLE `ftp_traffic` (
  742   `hostname` varchar(255) NOT NULL,
  743   `traffic_date` date NOT NULL,
  744   `in_bytes` bigint(32) unsigned NOT NULL,
  745   `out_bytes` bigint(32) unsigned NOT NULL,
  746   UNIQUE KEY (`hostname`,`traffic_date`)
  747 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  748 
  749 -- --------------------------------------------------------
  750 
  751 --
  752 -- Table structure for table `help_faq`
  753 --
  754 
  755 CREATE TABLE `help_faq` (
  756   `hf_id` int(11) NOT NULL AUTO_INCREMENT,
  757   `hf_section` int(11) DEFAULT NULL,
  758   `hf_order` int(11) DEFAULT '0',
  759   `hf_question` text,
  760   `hf_answer` text,
  761   `sys_userid` int(11) DEFAULT NULL,
  762   `sys_groupid` int(11) DEFAULT NULL,
  763   `sys_perm_user` varchar(5) DEFAULT NULL,
  764   `sys_perm_group` varchar(5) DEFAULT NULL,
  765   `sys_perm_other` varchar(5) DEFAULT NULL,
  766   PRIMARY KEY (`hf_id`)
  767 )  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  768 
  769 -- --------------------------------------------------------
  770 
  771 --
  772 -- Table structure for table `help_faq_sections`
  773 --
  774 
  775 CREATE TABLE `help_faq_sections` (
  776   `hfs_id` int(11) NOT NULL AUTO_INCREMENT,
  777   `hfs_name` varchar(255) DEFAULT NULL,
  778   `hfs_order` int(11) DEFAULT '0',
  779   `sys_userid` int(11) DEFAULT NULL,
  780   `sys_groupid` int(11) DEFAULT NULL,
  781   `sys_perm_user` varchar(5) DEFAULT NULL,
  782   `sys_perm_group` varchar(5) DEFAULT NULL,
  783   `sys_perm_other` varchar(5) DEFAULT NULL,
  784   PRIMARY KEY (`hfs_id`)
  785 )  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  786 
  787 -- --------------------------------------------------------
  788 
  789 -- Table structure for table `iptables`
  790 --
  791 
  792 DROP TABLE IF EXISTS `iptables`;
  793 CREATE TABLE `iptables` (
  794   `iptables_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  795   `server_id` int(10) unsigned NOT NULL DEFAULT '0',
  796   `table` varchar(10) DEFAULT NULL COMMENT 'INPUT OUTPUT FORWARD',
  797   `source_ip` varchar(16) DEFAULT NULL,
  798   `destination_ip` varchar(16) DEFAULT NULL,
  799   `protocol` varchar(10) DEFAULT 'TCP' COMMENT 'TCP UDP GRE',
  800   `singleport` varchar(10) DEFAULT NULL,
  801   `multiport` varchar(40) DEFAULT NULL,
  802   `state` varchar(20) DEFAULT NULL COMMENT 'NEW ESTABLISHED RECNET etc',
  803   `target` varchar(10) DEFAULT NULL COMMENT 'ACCEPT DROP REJECT LOG',
  804   `active` enum('n','y') NOT NULL DEFAULT 'y',
  805   PRIMARY KEY (`iptables_id`)
  806 ) AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  807 
  808 -- --------------------------------------------------------
  809 
  810 --
  811 -- Table structure for table  `mail_access`
  812 --
  813 
  814 CREATE TABLE `mail_access` (
  815   `access_id` int(11) unsigned NOT NULL auto_increment,
  816   `sys_userid` int(11) unsigned NOT NULL default '0',
  817   `sys_groupid` int(11) unsigned NOT NULL default '0',
  818   `sys_perm_user` varchar(5) NOT NULL default '',
  819   `sys_perm_group` varchar(5) NOT NULL default '',
  820   `sys_perm_other` varchar(5) NOT NULL default '',
  821   `server_id` int(11) NOT NULL default '0',
  822   `source` varchar(255) NOT NULL DEFAULT '',
  823   `access` varchar(255) NOT NULL DEFAULT '',
  824   `type` set('recipient','sender','client') NOT NULL DEFAULT 'recipient',
  825   `active` enum('n','y') NOT NULL default 'y',
  826   PRIMARY KEY  (`access_id`),
  827   UNIQUE KEY `unique_source` (`server_id`,`source`,`type`)
  828 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  829 
  830 -- --------------------------------------------------------
  831 
  832 --
  833 -- Table structure for table  `mail_backup`
  834 --
  835 
  836 CREATE TABLE `mail_backup` (
  837   `backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  838   `server_id` int(10) unsigned NOT NULL DEFAULT '0',
  839   `parent_domain_id` int(10) unsigned NOT NULL DEFAULT '0',
  840   `mailuser_id` int(10) unsigned NOT NULL DEFAULT '0',
  841   `backup_mode` varchar(64) NOT NULL DEFAULT  '',
  842   `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
  843   `filename` varchar(255) NOT NULL DEFAULT '',
  844   `filesize` VARCHAR(20) NOT NULL DEFAULT '',
  845   PRIMARY KEY (`backup_id`)
  846 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  847 
  848 -- --------------------------------------------------------
  849 
  850 --
  851 -- Table structure for table  `mail_content_filter`
  852 --
  853 
  854 CREATE TABLE `mail_content_filter` (
  855   `content_filter_id` int(11) unsigned NOT NULL auto_increment,
  856   `sys_userid` int(11) unsigned NOT NULL default '0',
  857   `sys_groupid` int(11) unsigned NOT NULL default '0',
  858   `sys_perm_user` varchar(5) default NULL,
  859   `sys_perm_group` varchar(5) default NULL,
  860   `sys_perm_other` varchar(5) default NULL,
  861   `server_id` int(11) NOT NULL default '0',
  862   `type` varchar(255) default NULL,
  863   `pattern` varchar(255) default NULL,
  864   `data` varchar(255) default NULL,
  865   `action` varchar(255) default NULL,
  866   `active` varchar(255) NOT NULL default 'y',
  867   PRIMARY KEY  (`content_filter_id`)
  868 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  869 
  870 -- --------------------------------------------------------
  871 
  872 --
  873 -- Table structure for table  `mail_domain`
  874 --
  875 
  876 CREATE TABLE `mail_domain` (
  877   `domain_id` int(11) unsigned NOT NULL auto_increment,
  878   `sys_userid` int(11) unsigned NOT NULL default '0',
  879   `sys_groupid` int(11) unsigned NOT NULL default '0',
  880   `sys_perm_user` varchar(5) NOT NULL default '',
  881   `sys_perm_group` varchar(5) NOT NULL default '',
  882   `sys_perm_other` varchar(5) NOT NULL default '',
  883   `server_id` int(11) unsigned NOT NULL default '0',
  884   `domain` varchar(255) NOT NULL default '',
  885   `dkim` ENUM( 'n', 'y' ) NOT NULL default 'n',
  886   `dkim_selector` varchar(63) NOT NULL DEFAULT 'default',
  887   `dkim_private` mediumtext NULL,
  888   `dkim_public` mediumtext NULL,
  889   `relay_host` varchar(255) NOT NULL DEFAULT '',
  890   `relay_user` varchar(255) NOT NULL DEFAULT '',
  891   `relay_pass` varchar(255) NOT NULL DEFAULT '',
  892   `active` enum('n','y') NOT NULL DEFAULT 'n',
  893   PRIMARY KEY  (`domain_id`),
  894   KEY `server_id` (`server_id`,`domain`),
  895   KEY `domain_active` (`domain`,`active`)
  896 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  897 
  898 -- --------------------------------------------------------
  899 
  900 --
  901 -- Table structure for table  `mail_forwarding`
  902 --
  903 
  904 CREATE TABLE `mail_forwarding` (
  905   `forwarding_id` int(11) unsigned NOT NULL auto_increment,
  906   `sys_userid` int(11) unsigned NOT NULL default '0',
  907   `sys_groupid` int(11) unsigned NOT NULL default '0',
  908   `sys_perm_user` varchar(5) NOT NULL default '',
  909   `sys_perm_group` varchar(5) NOT NULL default '',
  910   `sys_perm_other` varchar(5) NOT NULL default '',
  911   `server_id` int(11) unsigned NOT NULL default '0',
  912   `source` varchar(255) NOT NULL DEFAULT '',
  913   `destination` text,
  914   `type` enum('alias','aliasdomain','forward','catchall') NOT NULL default 'alias',
  915   `active` enum('n','y') NOT NULL DEFAULT 'n',
  916   `allow_send_as` ENUM('n','y') NOT NULL DEFAULT 'n',
  917   `greylisting` enum('n','y' ) NOT NULL DEFAULT 'n',
  918   PRIMARY KEY  (`forwarding_id`),
  919   KEY `server_id` (`server_id`,`source`),
  920   KEY `type` (`type`)
  921 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  922 
  923 -- --------------------------------------------------------
  924 
  925 --
  926 -- Table structure for table  `mail_get`
  927 --
  928 
  929 CREATE TABLE `mail_get` (
  930   `mailget_id` int(11) unsigned NOT NULL auto_increment,
  931   `sys_userid` int(11) unsigned NOT NULL default '0',
  932   `sys_groupid` int(11) unsigned NOT NULL default '0',
  933   `sys_perm_user` varchar(5) default NULL,
  934   `sys_perm_group` varchar(5) default NULL,
  935   `sys_perm_other` varchar(5) default NULL,
  936   `server_id` int(11) unsigned NOT NULL default '0',
  937   `type` varchar(255) default NULL,
  938   `source_server` varchar(255) default NULL,
  939   `source_username` varchar(255) default NULL,
  940   `source_password` varchar(64) default NULL,
  941   `source_delete` varchar(255) NOT NULL default 'y',
  942   `source_read_all` varchar(255) NOT NULL default 'y',
  943   `destination` varchar(255) default NULL,
  944   `active` varchar(255) NOT NULL default 'y',
  945   PRIMARY KEY  (`mailget_id`)
  946 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  947 
  948 -- --------------------------------------------------------
  949 
  950 --
  951 -- Tabellenstruktur für Tabelle `mail_mailinglist`
  952 --
  953 
  954 CREATE TABLE `mail_mailinglist` (
  955   `mailinglist_id` int(11) unsigned NOT NULL auto_increment,
  956   `sys_userid` int(11) unsigned NOT NULL default '0',
  957   `sys_groupid` int(11) unsigned NOT NULL default '0',
  958   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
  959   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
  960   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
  961   `server_id` int(11) unsigned NOT NULL default '0',
  962   `domain` varchar(255) NOT NULL DEFAULT '',
  963   `listname` varchar(255) NOT NULL DEFAULT '',
  964   `email` varchar(255) NOT NULL DEFAULT '',
  965   `password` varchar(255) NOT NULL DEFAULT '',
  966   PRIMARY KEY  (`mailinglist_id`)
  967 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  968 
  969 -- --------------------------------------------------------
  970 
  971 --
  972 -- Table structure for Table `mail_relay_recipient`
  973 --
  974 
  975 CREATE TABLE IF NOT EXISTS `mail_relay_recipient` (
  976   `relay_recipient_id` bigint(20) NOT NULL AUTO_INCREMENT,
  977   `sys_userid` int(11) NOT NULL DEFAULT '0',
  978   `sys_groupid` int(11) NOT NULL DEFAULT '0',
  979   `sys_perm_user` varchar(5) DEFAULT NULL,
  980   `sys_perm_group` varchar(5) DEFAULT NULL,
  981   `sys_perm_other` varchar(5) DEFAULT NULL,
  982   `server_id` int(11) NOT NULL DEFAULT '0',
  983   `source` varchar(255) DEFAULT NULL,
  984   `access` varchar(255) NOT NULL DEFAULT 'OK',
  985   `active` varchar(255) NOT NULL DEFAULT 'y',
  986   PRIMARY KEY (`relay_recipient_id`)
  987 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  988 
  989 -- --------------------------------------------------------
  990 
  991 --
  992 -- Table structure for table  `mail_traffic`
  993 --
  994 
  995 CREATE TABLE `mail_traffic` (
  996   `traffic_id` int(11) unsigned NOT NULL auto_increment,
  997   `mailuser_id` int(11) unsigned NOT NULL DEFAULT '0',
  998   `month` char(7) NOT NULL DEFAULT '',
  999   `traffic` bigint(20) unsigned NOT NULL DEFAULT '0',
 1000   PRIMARY KEY  (`traffic_id`),
 1001   KEY `mailuser_id` (`mailuser_id`,`month`)
 1002 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1003 
 1004 -- --------------------------------------------------------
 1005 
 1006 --
 1007 -- Table structure for table  `mail_transport`
 1008 --
 1009 
 1010 CREATE TABLE `mail_transport` (
 1011   `transport_id` int(11) unsigned NOT NULL auto_increment,
 1012   `sys_userid` int(11) unsigned NOT NULL default '0',
 1013   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1014   `sys_perm_user` varchar(5) NOT NULL default '',
 1015   `sys_perm_group` varchar(5) NOT NULL default '',
 1016   `sys_perm_other` varchar(5) NOT NULL default '',
 1017   `server_id` int(11) unsigned NOT NULL default '0',
 1018   `domain` varchar(255) NOT NULL default '',
 1019   `transport` varchar(255) NOT NULL DEFAULT '',
 1020   `sort_order` int(11) unsigned NOT NULL default '5',
 1021   `active` enum('n','y') NOT NULL DEFAULT 'n',
 1022   PRIMARY KEY  (`transport_id`),
 1023   KEY `server_id` (`server_id`,`transport`),
 1024   KEY `server_id_2` (`server_id`,`domain`)
 1025 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1026 
 1027 -- --------------------------------------------------------
 1028 
 1029 --
 1030 -- Table structure for table  `mail_user`
 1031 --
 1032 
 1033 CREATE TABLE `mail_user` (
 1034   `mailuser_id` int(11) unsigned NOT NULL auto_increment,
 1035   `sys_userid` int(11) unsigned NOT NULL default '0',
 1036   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1037   `sys_perm_user` varchar(5) NOT NULL default '',
 1038   `sys_perm_group` varchar(5) NOT NULL default '',
 1039   `sys_perm_other` varchar(5) NOT NULL default '',
 1040   `server_id` int(11) unsigned NOT NULL default '0',
 1041   `email` varchar(255) NOT NULL default '',
 1042   `login` varchar(255) NOT NULL default '',
 1043   `password` varchar(255) NOT NULL default '',
 1044   `name` varchar(255) NOT NULL default '',
 1045   `uid` int(11) NOT NULL default '5000',
 1046   `gid` int(11) NOT NULL default '5000',
 1047   `maildir` varchar(255) NOT NULL default '',
 1048   `maildir_format` varchar(255) NOT NULL default 'maildir',
 1049   `quota` bigint(20) NOT NULL default '-1',
 1050   `cc` text,
 1051   `forward_in_lda` enum('n','y') NOT NULL default 'n',
 1052   `sender_cc` varchar(255) NOT NULL default '',
 1053   `homedir` varchar(255) NOT NULL default '',
 1054   `autoresponder` enum('n','y') NOT NULL default 'n',
 1055   `autoresponder_start_date` datetime NULL default NULL,
 1056   `autoresponder_end_date` datetime NULL default NULL,
 1057   `autoresponder_subject` varchar(255) NOT NULL default 'Out of office reply',
 1058   `autoresponder_text` mediumtext NULL,
 1059   `move_junk` enum('y','a','n') NOT NULL default 'y',
 1060   `purge_trash_days` INT NOT NULL DEFAULT '0',
 1061   `purge_junk_days` INT NOT NULL DEFAULT '0',
 1062   `custom_mailfilter` mediumtext,
 1063   `postfix` enum('n','y') NOT NULL default 'y',
 1064   `greylisting` enum('n','y' ) NOT NULL DEFAULT 'n',
 1065   `access` enum('n','y') NOT NULL default 'y',
 1066   `disableimap` enum('n','y') NOT NULL default 'n',
 1067   `disablepop3` enum('n','y') NOT NULL default 'n',
 1068   `disabledeliver` enum('n','y') NOT NULL default 'n',
 1069   `disablesmtp` enum('n','y') NOT NULL default 'n',
 1070   `disablesieve` enum('n','y') NOT NULL default 'n',
 1071   `disablesieve-filter` enum('n','y') NOT NULL default 'n',
 1072   `disablelda` enum('n','y') NOT NULL default 'n',
 1073   `disablelmtp` enum('n','y') NOT NULL default 'n',
 1074   `disabledoveadm` enum('n','y') NOT NULL default 'n',
 1075   `disablequota-status` enum('n','y') NOT NULL default 'n',
 1076   `disableindexer-worker` enum('n','y') NOT NULL default 'n',
 1077   `last_quota_notification` date NULL default NULL,
 1078   `backup_interval` VARCHAR( 255 ) NOT NULL default 'none',
 1079   `backup_copies` INT NOT NULL DEFAULT '1',
 1080   PRIMARY KEY  (`mailuser_id`),
 1081   KEY `server_id` (`server_id`,`email`),
 1082   KEY `email_access` (`email`,`access`)
 1083 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1084 
 1085 -- --------------------------------------------------------
 1086 
 1087 --
 1088 -- Table structure for table  `mail_user_filter`
 1089 --
 1090 
 1091 CREATE TABLE `mail_user_filter` (
 1092   `filter_id` int(11) unsigned NOT NULL auto_increment,
 1093   `sys_userid` int(11) unsigned NOT NULL default '0',
 1094   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1095   `sys_perm_user` varchar(5) default NULL,
 1096   `sys_perm_group` varchar(5) default NULL,
 1097   `sys_perm_other` varchar(5) default NULL,
 1098   `mailuser_id` int(11) unsigned NOT NULL default '0',
 1099   `rulename` varchar(64) default NULL,
 1100   `source` varchar(255) default NULL,
 1101   `searchterm` varchar(255) default NULL,
 1102   `op` varchar(255) default NULL,
 1103   `action` varchar(255) default NULL,
 1104   `target` varchar(255) default NULL,
 1105   `active` enum('n','y') NOT NULL default 'y',
 1106   PRIMARY KEY  (`filter_id`)
 1107 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1108 
 1109 -- --------------------------------------------------------
 1110 
 1111 --
 1112 -- Table structure for table `monitor_data`
 1113 --
 1114 
 1115 CREATE TABLE `monitor_data` (
 1116   `server_id` int(11) unsigned NOT NULL default '0',
 1117   `type` varchar(255) NOT NULL default '',
 1118   `created` int(11) unsigned NOT NULL default '0',
 1119   `data` mediumtext,
 1120   `state` enum('no_state','unknown','ok','info','warning','critical','error') NOT NULL DEFAULT 'unknown',
 1121   PRIMARY KEY (`server_id`,`type`,`created`)
 1122 ) DEFAULT CHARSET=utf8 ;
 1123 
 1124 -- --------------------------------------------------------
 1125 
 1126 --
 1127 -- Table structure for table `openvz_ip`
 1128 --
 1129 
 1130 CREATE TABLE IF NOT EXISTS `openvz_ip` (
 1131   `ip_address_id` bigint(20) NOT NULL AUTO_INCREMENT,
 1132   `sys_userid` int(11) NOT NULL DEFAULT '0',
 1133   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 1134   `sys_perm_user` varchar(5) DEFAULT NULL,
 1135   `sys_perm_group` varchar(5) DEFAULT NULL,
 1136   `sys_perm_other` varchar(5) DEFAULT NULL,
 1137   `server_id` int(11) NOT NULL DEFAULT '0',
 1138   `ip_address` varchar(39) DEFAULT NULL,
 1139   `vm_id` int(11) NOT NULL DEFAULT '0',
 1140   `reserved` varchar(255) NOT NULL DEFAULT 'n',
 1141   `additional` varchar(255) NOT NULL DEFAULT 'n',
 1142   PRIMARY KEY (`ip_address_id`)
 1143 )  DEFAULT CHARSET=utf8 ;
 1144 
 1145 --
 1146 -- Dumping data for table `openvz_ip`
 1147 --
 1148 
 1149 -- --------------------------------------------------------
 1150 
 1151 --
 1152 -- Table structure for table `openvz_ostemplate`
 1153 --
 1154 
 1155 CREATE TABLE IF NOT EXISTS `openvz_ostemplate` (
 1156   `ostemplate_id` bigint(20) NOT NULL AUTO_INCREMENT,
 1157   `sys_userid` int(11) NOT NULL DEFAULT '0',
 1158   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 1159   `sys_perm_user` varchar(5) DEFAULT NULL,
 1160   `sys_perm_group` varchar(5) DEFAULT NULL,
 1161   `sys_perm_other` varchar(5) DEFAULT NULL,
 1162   `template_name` varchar(255) DEFAULT NULL,
 1163   `template_file` varchar(255) NOT NULL DEFAULT '',
 1164   `server_id` int(11) NOT NULL DEFAULT '0',
 1165   `allservers` varchar(255) NOT NULL DEFAULT 'y',
 1166   `active` varchar(255) NOT NULL DEFAULT 'y',
 1167   `description` text,
 1168   PRIMARY KEY (`ostemplate_id`)
 1169 )  DEFAULT CHARSET=utf8 ;
 1170 
 1171 --
 1172 -- Dumping data for table `openvz_ostemplate`
 1173 --
 1174 
 1175 INSERT INTO `openvz_ostemplate` (`ostemplate_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `template_file`, `server_id`, `allservers`, `active`, `description`) VALUES(1, 1, 1, 'riud', 'riud', '', 'Debian minimal', 'debian-minimal-x86', 1, 'y', 'y', 'Debian minimal image.');
 1176 
 1177 -- --------------------------------------------------------
 1178 
 1179 --
 1180 -- Table structure for table `openvz_template`
 1181 --
 1182 
 1183 CREATE TABLE IF NOT EXISTS `openvz_template` (
 1184   `template_id` bigint(20) NOT NULL AUTO_INCREMENT,
 1185   `sys_userid` int(11) NOT NULL DEFAULT '0',
 1186   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 1187   `sys_perm_user` varchar(5) DEFAULT NULL,
 1188   `sys_perm_group` varchar(5) DEFAULT NULL,
 1189   `sys_perm_other` varchar(5) DEFAULT NULL,
 1190   `template_name` varchar(255) DEFAULT NULL,
 1191   `diskspace` int(11) NOT NULL DEFAULT '0',
 1192   `traffic` int(11) NOT NULL DEFAULT '-1',
 1193   `bandwidth` int(11) NOT NULL DEFAULT '-1',
 1194   `ram` int(11) NOT NULL DEFAULT '0',
 1195   `ram_burst` int(11) NOT NULL DEFAULT '0',
 1196   `cpu_units` int(11) NOT NULL DEFAULT '1000',
 1197   `cpu_num` int(11) NOT NULL DEFAULT '4',
 1198   `cpu_limit` int(11) NOT NULL DEFAULT '400',
 1199   `io_priority` int(11) NOT NULL DEFAULT '4',
 1200   `active` varchar(255) NOT NULL DEFAULT 'y',
 1201   `description` text,
 1202   `numproc` varchar(255) DEFAULT NULL,
 1203   `numtcpsock` varchar(255) DEFAULT NULL,
 1204   `numothersock` varchar(255) DEFAULT NULL,
 1205   `vmguarpages` varchar(255) DEFAULT NULL,
 1206   `kmemsize` varchar(255) DEFAULT NULL,
 1207   `tcpsndbuf` varchar(255) DEFAULT NULL,
 1208   `tcprcvbuf` varchar(255) DEFAULT NULL,
 1209   `othersockbuf` varchar(255) DEFAULT NULL,
 1210   `dgramrcvbuf` varchar(255) DEFAULT NULL,
 1211   `oomguarpages` varchar(255) DEFAULT NULL,
 1212   `privvmpages` varchar(255) DEFAULT NULL,
 1213   `lockedpages` varchar(255) DEFAULT NULL,
 1214   `shmpages` varchar(255) DEFAULT NULL,
 1215   `physpages` varchar(255) DEFAULT NULL,
 1216   `numfile` varchar(255) DEFAULT NULL,
 1217   `avnumproc` varchar(255) DEFAULT NULL,
 1218   `numflock` varchar(255) DEFAULT NULL,
 1219   `numpty` varchar(255) DEFAULT NULL,
 1220   `numsiginfo` varchar(255) DEFAULT NULL,
 1221   `dcachesize` varchar(255) DEFAULT NULL,
 1222   `numiptent` varchar(255) DEFAULT NULL,
 1223   `swappages` varchar(255) DEFAULT NULL,
 1224   `hostname` varchar(255) DEFAULT NULL,
 1225   `nameserver` varchar(255) DEFAULT NULL,
 1226   `create_dns` varchar(1) NOT NULL DEFAULT 'n',
 1227   `capability` varchar(255) DEFAULT NULL,
 1228   `features` varchar(255) DEFAULT NULL,
 1229   `iptables` varchar(255) DEFAULT NULL,
 1230   `custom` text,
 1231   PRIMARY KEY (`template_id`)
 1232 )  DEFAULT CHARSET=utf8 ;
 1233 
 1234 --
 1235 -- Dumping data for table `openvz_template`
 1236 --
 1237 
 1238 INSERT INTO `openvz_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `diskspace`, `traffic`, `bandwidth`, `ram`, `ram_burst`, `cpu_units`, `cpu_num`, `cpu_limit`, `io_priority`, `active`, `description`, `numproc`, `numtcpsock`, `numothersock`, `vmguarpages`, `kmemsize`, `tcpsndbuf`, `tcprcvbuf`, `othersockbuf`, `dgramrcvbuf`, `oomguarpages`, `privvmpages`, `lockedpages`, `shmpages`, `physpages`, `numfile`, `avnumproc`, `numflock`, `numpty`, `numsiginfo`, `dcachesize`, `numiptent`, `swappages`, `hostname`, `nameserver`, `create_dns`, `capability`, `features`, `iptables`, `custom`) VALUES(1, 1, 1, 'riud', 'riud', '', 'small', 10, -1, -1, 256, 512, 1000, 4, 400, 4, 'y', '', '999999:999999', '7999992:7999992', '7999992:7999992', '65536:unlimited', '2147483646:2147483646', '214748160:396774400', '214748160:396774400', '214748160:396774400', '214748160:396774400', '65536:65536', '131072:139264', '999999:999999', '65536:65536', '0:2147483647', '23999976:23999976', '180:180', '999999:999999', '500000:500000', '999999:999999', '2147483646:2147483646', '999999:999999', '256000:256000', 'v{VEID}.test.tld', '8.8.8.8 8.8.4.4', 'n', '', '', '', '');
 1239 
 1240 -- --------------------------------------------------------
 1241 
 1242 --
 1243 -- Table structure for table `openvz_traffic`
 1244 --
 1245 
 1246 CREATE TABLE IF NOT EXISTS `openvz_traffic` (
 1247   `veid` int(11) NOT NULL DEFAULT '0',
 1248   `traffic_date` date NULL DEFAULT NULL,
 1249   `traffic_bytes` bigint(32) unsigned NOT NULL DEFAULT '0',
 1250   UNIQUE KEY (`veid`,`traffic_date`)
 1251 ) DEFAULT CHARSET=utf8;
 1252 
 1253 --
 1254 -- Dumping data for table `openvz_traffic`
 1255 --
 1256 
 1257 
 1258 -- --------------------------------------------------------
 1259 
 1260 --
 1261 -- Table structure for table `openvz_vm`
 1262 --
 1263 
 1264 CREATE TABLE IF NOT EXISTS `openvz_vm` (
 1265   `vm_id` bigint(20) NOT NULL AUTO_INCREMENT,
 1266   `sys_userid` int(11) NOT NULL DEFAULT '0',
 1267   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 1268   `sys_perm_user` varchar(5) DEFAULT NULL,
 1269   `sys_perm_group` varchar(5) DEFAULT NULL,
 1270   `sys_perm_other` varchar(5) DEFAULT NULL,
 1271   `server_id` int(11) NOT NULL DEFAULT '0',
 1272   `veid` int(10) unsigned NOT NULL DEFAULT '0',
 1273   `ostemplate_id` int(11) NOT NULL DEFAULT '0',
 1274   `template_id` int(11) NOT NULL DEFAULT '0',
 1275   `ip_address` varchar(255) NOT NULL DEFAULT '',
 1276   `hostname` varchar(255) DEFAULT NULL,
 1277   `vm_password` varchar(255) DEFAULT NULL,
 1278   `start_boot` varchar(255) NOT NULL DEFAULT 'y',
 1279   `bootorder` int(11) NOT NULL DEFAULT '1',
 1280   `active` varchar(255) NOT NULL DEFAULT 'y',
 1281   `active_until_date` date NULL DEFAULT NULL,
 1282   `description` text,
 1283   `diskspace` int(11) NOT NULL DEFAULT '0',
 1284   `traffic` int(11) NOT NULL DEFAULT '-1',
 1285   `bandwidth` int(11) NOT NULL DEFAULT '-1',
 1286   `ram` int(11) NOT NULL DEFAULT '0',
 1287   `ram_burst` int(11) NOT NULL DEFAULT '0',
 1288   `cpu_units` int(11) NOT NULL DEFAULT '1000',
 1289   `cpu_num` int(11) NOT NULL DEFAULT '4',
 1290   `cpu_limit` int(11) NOT NULL DEFAULT '400',
 1291   `io_priority` int(11) NOT NULL DEFAULT '4',
 1292   `nameserver` varchar(255) NOT NULL DEFAULT '8.8.8.8 8.8.4.4',
 1293   `create_dns` varchar(1) NOT NULL DEFAULT 'n',
 1294   `capability` text,
 1295   `features` text,
 1296   `iptabless` text,
 1297   `config` mediumtext,
 1298   `custom` text,
 1299   PRIMARY KEY (`vm_id`)
 1300 )  DEFAULT CHARSET=utf8 ;
 1301 
 1302 --
 1303 -- Dumping data for table `openvz_vm`
 1304 --
 1305 
 1306 -- --------------------------------------------------------
 1307 
 1308 --
 1309 -- Table structure for table  `remote_session`
 1310 --
 1311 
 1312 CREATE TABLE `remote_session` (
 1313   `remote_session` varchar(64) NOT NULL DEFAULT '',
 1314   `remote_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1315   `remote_functions` text,
 1316   `client_login` tinyint(1) unsigned NOT NULL default '0',
 1317   `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
 1318   PRIMARY KEY  (`remote_session`)
 1319 ) DEFAULT CHARSET=utf8 ;
 1320 
 1321 -- --------------------------------------------------------
 1322 
 1323 --
 1324 -- Table structure for table  `remote_user`
 1325 --
 1326 
 1327 CREATE TABLE `remote_user` (
 1328   `remote_userid` int(11) unsigned NOT NULL auto_increment,
 1329   `sys_userid` int(11) unsigned NOT NULL default '0',
 1330   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1331   `sys_perm_user` varchar(5) default NULL,
 1332   `sys_perm_group` varchar(5) default NULL,
 1333   `sys_perm_other` varchar(5) default NULL,
 1334   `remote_username` varchar(64) NOT NULL DEFAULT '',
 1335   `remote_password` varchar(200) NOT NULL DEFAULT '',
 1336   `remote_access` enum('y','n') NOT NULL DEFAULT 'y',
 1337   `remote_ips` TEXT,
 1338   `remote_functions` text,
 1339   PRIMARY KEY  (`remote_userid`)
 1340 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1341 
 1342 -- --------------------------------------------------------
 1343 
 1344 --
 1345 -- Table structure for table  `server`
 1346 --
 1347 
 1348 CREATE TABLE `server` (
 1349   `server_id` int(11) unsigned NOT NULL auto_increment,
 1350   `sys_userid` int(11) unsigned NOT NULL default '0',
 1351   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1352   `sys_perm_user` varchar(5) NOT NULL default '',
 1353   `sys_perm_group` varchar(5) NOT NULL default '',
 1354   `sys_perm_other` varchar(5) NOT NULL default '',
 1355   `server_name` varchar(255) NOT NULL default '',
 1356   `mail_server` tinyint(1) NOT NULL default '0',
 1357   `web_server` tinyint(1) NOT NULL default '0',
 1358   `dns_server` tinyint(1) NOT NULL default '0',
 1359   `file_server` tinyint(1) NOT NULL default '0',
 1360   `db_server` tinyint(1) NOT NULL default '0',
 1361   `vserver_server` tinyint(1) NOT NULL default '0',
 1362   `proxy_server` tinyint(1) NOT NULL default '0',
 1363   `firewall_server` tinyint(1) NOT NULL default '0',
 1364   `xmpp_server` tinyint(1) NOT NULL default '0',
 1365   `config` text,
 1366   `updated` bigint(20) unsigned NOT NULL default '0',
 1367   `mirror_server_id` int(11) unsigned NOT NULL default '0',
 1368   `dbversion` int(11) unsigned NOT NULL default '1',
 1369   `active` tinyint(1) NOT NULL default '1',
 1370   PRIMARY KEY  (`server_id`)
 1371 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1372 
 1373 -- --------------------------------------------------------
 1374 
 1375 --
 1376 -- Table structure for table  `server_ip`
 1377 --
 1378 
 1379 CREATE TABLE `server_ip` (
 1380   `server_ip_id` int(11) unsigned NOT NULL auto_increment,
 1381   `sys_userid` int(11) unsigned NOT NULL default '0',
 1382   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1383   `sys_perm_user` varchar(5) default NULL,
 1384   `sys_perm_group` varchar(5) default NULL,
 1385   `sys_perm_other` varchar(5) default NULL,
 1386   `server_id` int(11) unsigned NOT NULL default '0',
 1387   `client_id` int(11) unsigned NOT NULL default '0',
 1388   `ip_type` enum(  'IPv4',  'IPv6' ) NOT NULL DEFAULT  'IPv4',
 1389   `ip_address` varchar(39) default NULL,
 1390   `virtualhost` enum('n','y') NOT NULL default 'y',
 1391   `virtualhost_port` varchar(255) default '80,443',
 1392   PRIMARY KEY  (`server_ip_id`)
 1393 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1394 
 1395 -- --------------------------------------------------------
 1396 
 1397 --
 1398 -- Table structure for table  `server_ip_map`
 1399 --
 1400 
 1401 CREATE TABLE `server_ip_map` (
 1402   `server_ip_map_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1403   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1404   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1405   `sys_perm_user` varchar(5) DEFAULT NULL,
 1406   `sys_perm_group` varchar(5) DEFAULT NULL,
 1407   `sys_perm_other` varchar(5) DEFAULT NULL,
 1408   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1409   `source_ip` varchar(15) DEFAULT NULL,
 1410   `destination_ip` varchar(35) DEFAULT '',
 1411   `active` enum('n','y') NOT NULL DEFAULT 'y',
 1412   PRIMARY KEY (`server_ip_map_id`)
 1413 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1414 
 1415 -- --------------------------------------------------------
 1416 
 1417 --
 1418 -- Table structure for table  `server_php`
 1419 --
 1420 
 1421 CREATE TABLE `server_php` (
 1422   `server_php_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1423   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1424   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1425   `sys_perm_user` varchar(5) DEFAULT NULL,
 1426   `sys_perm_group` varchar(5) DEFAULT NULL,
 1427   `sys_perm_other` varchar(5) DEFAULT NULL,
 1428   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1429   `client_id` int(11) unsigned NOT NULL DEFAULT '0',
 1430   `name` varchar(255) DEFAULT NULL,
 1431   `php_fastcgi_binary` varchar(255) DEFAULT NULL,
 1432   `php_fastcgi_ini_dir` varchar(255) DEFAULT NULL,
 1433   `php_fpm_init_script` varchar(255) DEFAULT NULL,
 1434   `php_fpm_ini_dir` varchar(255) DEFAULT NULL,
 1435   `php_fpm_pool_dir` varchar(255) DEFAULT NULL,
 1436   `php_fpm_socket_dir` varchar(255) DEFAULT NULL,
 1437   `active` enum('n','y') NOT NULL DEFAULT 'y',
 1438   PRIMARY KEY (`server_php_id`)
 1439 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1440 
 1441 -- --------------------------------------------------------
 1442 
 1443 --
 1444 -- Table structure for table `shell_user`
 1445 --
 1446 
 1447 CREATE TABLE `shell_user` (
 1448   `shell_user_id` int(11) unsigned NOT NULL auto_increment,
 1449   `sys_userid` int(11) unsigned NOT NULL default '0',
 1450   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1451   `sys_perm_user` varchar(5) default NULL,
 1452   `sys_perm_group` varchar(5) default NULL,
 1453   `sys_perm_other` varchar(5) default NULL,
 1454   `server_id` int(11) unsigned NOT NULL default '0',
 1455   `parent_domain_id` int(11) unsigned NOT NULL default '0',
 1456   `username` varchar(64) default NULL,
 1457   `username_prefix` varchar(50) NOT NULL default '',
 1458   `password` varchar(200) default NULL,
 1459   `quota_size` bigint(20) NOT NULL default '-1',
 1460   `active` enum('n','y') NOT NULL default 'y',
 1461   `puser` varchar(255) default NULL,
 1462   `pgroup` varchar(255) default NULL,
 1463   `shell` varchar(255) NOT NULL default '/bin/bash',
 1464   `dir` varchar(255) default NULL,
 1465   `chroot` varchar(255) NOT NULL DEFAULT '',
 1466   `ssh_rsa` text,
 1467   PRIMARY KEY  (`shell_user_id`)
 1468 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1469 
 1470 -- --------------------------------------------------------
 1471 
 1472 --
 1473 -- Table structure for table  `spamfilter_policy`
 1474 --
 1475 
 1476 CREATE TABLE `spamfilter_policy` (
 1477   `id` int(11) unsigned NOT NULL auto_increment,
 1478   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1479   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1480   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
 1481   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
 1482   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
 1483   `policy_name` varchar(64) default NULL,
 1484   `virus_lover` enum('N','Y') default 'N',
 1485   `spam_lover` enum('N','Y') default 'N',
 1486   `banned_files_lover` enum('N','Y') default 'N',
 1487   `bad_header_lover` enum('N','Y') default 'N',
 1488   `bypass_virus_checks` enum('N','Y') default 'N',
 1489   `bypass_spam_checks` enum('N','Y') default 'N',
 1490   `bypass_banned_checks` enum('N','Y') default 'N',
 1491   `bypass_header_checks` enum('N','Y') default 'N',
 1492   `spam_modifies_subj` enum('N','Y') default 'N',
 1493   `virus_quarantine_to` varchar(255) default NULL,
 1494   `spam_quarantine_to` varchar(255) default NULL,
 1495   `banned_quarantine_to` varchar(255) default NULL,
 1496   `bad_header_quarantine_to` varchar(255) default NULL,
 1497   `clean_quarantine_to` varchar(255) default NULL,
 1498   `other_quarantine_to` varchar(255) default NULL,
 1499   `spam_tag_level` DECIMAL(5,2) default NULL,
 1500   `spam_tag2_level` DECIMAL(5,2) default NULL,
 1501   `spam_kill_level` DECIMAL(5,2) default NULL,
 1502   `spam_dsn_cutoff_level` DECIMAL(5,2) default NULL,
 1503   `spam_quarantine_cutoff_level` DECIMAL(5,2) default NULL,
 1504   `addr_extension_virus` varchar(64) default NULL,
 1505   `addr_extension_spam` varchar(64) default NULL,
 1506   `addr_extension_banned` varchar(64) default NULL,
 1507   `addr_extension_bad_header` varchar(64) default NULL,
 1508   `warnvirusrecip` enum('N','Y') default 'N',
 1509   `warnbannedrecip` enum('N','Y') default 'N',
 1510   `warnbadhrecip` enum('N','Y') default 'N',
 1511   `newvirus_admin` varchar(64) default NULL,
 1512   `virus_admin` varchar(64) default NULL,
 1513   `banned_admin` varchar(64) default NULL,
 1514   `bad_header_admin` varchar(64) default NULL,
 1515   `spam_admin` varchar(64) default NULL,
 1516   `spam_subject_tag` varchar(64) default NULL,
 1517   `spam_subject_tag2` varchar(64) default NULL,
 1518   `message_size_limit` int(11) unsigned default NULL,
 1519   `banned_rulenames` varchar(64) default NULL,
 1520   `policyd_quota_in` int(11) NOT NULL DEFAULT  '-1',
 1521   `policyd_quota_in_period` int(11) NOT NULL DEFAULT  '24',
 1522   `policyd_quota_out` int(11) NOT NULL DEFAULT  '-1',
 1523   `policyd_quota_out_period` int(11) NOT NULL DEFAULT  '24',
 1524   `policyd_greylist` ENUM(  'Y',  'N' ) NOT NULL DEFAULT  'N',
 1525   `rspamd_greylisting` enum('n','y') NOT NULL DEFAULT 'n',
 1526   `rspamd_spam_greylisting_level` decimal(5,2) DEFAULT NULL,
 1527   `rspamd_spam_tag_level` decimal(5,2) DEFAULT NULL,
 1528   `rspamd_spam_tag_method` enum('add_header','rewrite_subject') NOT NULL DEFAULT 'rewrite_subject',
 1529   `rspamd_spam_kill_level` decimal(5,2) DEFAULT NULL,
 1530   PRIMARY KEY  (`id`)
 1531 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1532 
 1533 -- --------------------------------------------------------
 1534 
 1535 --
 1536 -- Table structure for table  `spamfilter_users`
 1537 --
 1538 
 1539 CREATE TABLE `spamfilter_users` (
 1540   `id` int(11) unsigned NOT NULL auto_increment,
 1541   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1542   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1543   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
 1544   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
 1545   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
 1546   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1547   `priority` tinyint(3) unsigned NOT NULL default '7',
 1548   `policy_id` int(11) unsigned NOT NULL default '1',
 1549   `email` varchar(255) NOT NULL DEFAULT '',
 1550   `fullname` varchar(64) default NULL,
 1551   `local` varchar(1) default NULL,
 1552   PRIMARY KEY  (`id`),
 1553   UNIQUE KEY `email` (`email`)
 1554 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1555 
 1556 -- --------------------------------------------------------
 1557 
 1558 --
 1559 -- Table structure for table  `spamfilter_wblist`
 1560 --
 1561 
 1562 CREATE TABLE `spamfilter_wblist` (
 1563   `wblist_id` int(11) unsigned NOT NULL auto_increment,
 1564   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1565   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1566   `sys_perm_user` varchar(5) NOT NULL DEFAULT '',
 1567   `sys_perm_group` varchar(5) NOT NULL DEFAULT '',
 1568   `sys_perm_other` varchar(5) NOT NULL DEFAULT '',
 1569   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1570   `wb` enum('W','B') NOT NULL default 'W',
 1571   `rid` int(11) unsigned NOT NULL DEFAULT '0',
 1572   `email` varchar(255) NOT NULL DEFAULT '',
 1573   `priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
 1574   `active` enum('y','n') NOT NULL default 'y',
 1575   PRIMARY KEY  (`wblist_id`)
 1576 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1577 
 1578 -- --------------------------------------------------------
 1579 
 1580 --
 1581 -- Table structure for table  `support_message`
 1582 --
 1583 
 1584 CREATE TABLE `support_message` (
 1585   `support_message_id` int(11) unsigned NOT NULL auto_increment,
 1586   `sys_userid` int(11) unsigned NOT NULL default '0',
 1587   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1588   `sys_perm_user` varchar(5) default NULL,
 1589   `sys_perm_group` varchar(5) default NULL,
 1590   `sys_perm_other` varchar(5) default NULL,
 1591   `recipient_id` int(11) unsigned NOT NULL default '0',
 1592   `sender_id` int(11) unsigned NOT NULL default '0',
 1593   `subject` varchar(255) default NULL,
 1594   `message` text default NULL,
 1595   `tstamp` int(11) NOT NULL default '0',
 1596   PRIMARY KEY  (`support_message_id`)
 1597 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1598 
 1599 -- --------------------------------------------------------
 1600 
 1601 --
 1602 -- Table structure for table `sys_config`
 1603 --
 1604 
 1605 CREATE TABLE `sys_config` (
 1606   `group` varchar(64) NOT NULL DEFAULT '',
 1607   `name` varchar(64) NOT NULL DEFAULT '',
 1608   `value` varchar(255) NOT NULL DEFAULT '',
 1609   PRIMARY KEY (`group`, `name`)
 1610 ) DEFAULT CHARSET=utf8;
 1611 
 1612 
 1613 -- --------------------------------------------------------
 1614 
 1615 --
 1616 -- Table structure for table `sys_cron`
 1617 --
 1618 
 1619 CREATE TABLE IF NOT EXISTS `sys_cron` (
 1620   `name` varchar(50) NOT NULL DEFAULT '',
 1621   `last_run` datetime NULL DEFAULT NULL,
 1622   `next_run` datetime NULL DEFAULT NULL,
 1623   `running` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
 1624   PRIMARY KEY (`name`)
 1625 ) DEFAULT CHARSET=utf8;
 1626 
 1627 
 1628 -- --------------------------------------------------------
 1629 
 1630 --
 1631 -- Table structure for table  `sys_datalog`
 1632 --
 1633 
 1634 CREATE TABLE `sys_datalog` (
 1635   `datalog_id` int(11) unsigned NOT NULL auto_increment,
 1636   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1637   `dbtable` varchar(255) NOT NULL default '',
 1638   `dbidx` varchar(255) NOT NULL default '',
 1639   `action` char(1) NOT NULL default '',
 1640   `tstamp` int(11) NOT NULL default '0',
 1641   `user` varchar(255) NOT NULL default '',
 1642   `data` longtext,
 1643   `status` set('pending','ok','warning','error') NOT NULL default 'ok',
 1644   `error` mediumtext,
 1645   `session_id` varchar(64) NOT NULL DEFAULT '',
 1646   PRIMARY KEY  (`datalog_id`),
 1647   KEY `server_id` (`server_id`,`status`)
 1648 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1649 
 1650 -- --------------------------------------------------------
 1651 
 1652 --
 1653 -- Table structure for table  `sys_dbsync`
 1654 --
 1655 
 1656 CREATE TABLE `sys_dbsync` (
 1657   `id` int(11) unsigned NOT NULL auto_increment,
 1658   `jobname` varchar(64) NOT NULL default '',
 1659   `sync_interval_minutes` int(11) unsigned NOT NULL default '0',
 1660   `db_type` varchar(16) NOT NULL default '',
 1661   `db_host` varchar(255) NOT NULL default '',
 1662   `db_name` varchar(64) NOT NULL default '',
 1663   `db_username` varchar(64) NOT NULL default '',
 1664   `db_password` varchar(64) NOT NULL default '',
 1665   `db_tables` varchar(255) NOT NULL default 'admin,forms',
 1666   `empty_datalog` int(11) unsigned NOT NULL default '0',
 1667   `sync_datalog_external` int(11) unsigned NOT NULL default '0',
 1668   `active` tinyint(1) NOT NULL default '1',
 1669   `last_datalog_id` int(11) unsigned NOT NULL default '0',
 1670   PRIMARY KEY  (`id`),
 1671   KEY `last_datalog_id` (`last_datalog_id`)
 1672 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1673 
 1674 -- --------------------------------------------------------
 1675 
 1676 --
 1677 -- Table structure for table  `sys_filesync`
 1678 --
 1679 
 1680 CREATE TABLE `sys_filesync` (
 1681   `id` int(11) unsigned NOT NULL auto_increment,
 1682   `jobname` varchar(64) NOT NULL default '',
 1683   `sync_interval_minutes` int(11) unsigned NOT NULL default '0',
 1684   `ftp_host` varchar(255) NOT NULL default '',
 1685   `ftp_path` varchar(255) NOT NULL default '',
 1686   `ftp_username` varchar(64) NOT NULL default '',
 1687   `ftp_password` varchar(64) NOT NULL default '',
 1688   `local_path` varchar(255) NOT NULL default '',
 1689   `wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
 1690   `active` tinyint(1) NOT NULL default '1',
 1691   PRIMARY KEY  (`id`)
 1692 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1693 
 1694 -- --------------------------------------------------------
 1695 
 1696 --
 1697 -- Table structure for table  `sys_group`
 1698 --
 1699 
 1700 CREATE TABLE `sys_group` (
 1701   `groupid` int(11) unsigned NOT NULL auto_increment,
 1702   `name` varchar(64) NOT NULL default '',
 1703   `description` text,
 1704   `client_id` int(11) unsigned NOT NULL default '0',
 1705   PRIMARY KEY  (`groupid`)
 1706 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1707 
 1708 -- --------------------------------------------------------
 1709 
 1710 --
 1711 -- Table structure for table  `sys_ini`
 1712 --
 1713 
 1714 CREATE TABLE `sys_ini` (
 1715   `sysini_id` int(11) unsigned NOT NULL auto_increment,
 1716   `config` longtext,
 1717   `default_logo` text NOT NULL,
 1718   `custom_logo` text NOT NULL,
 1719   PRIMARY KEY  (`sysini_id`)
 1720 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1721 
 1722 -- --------------------------------------------------------
 1723 
 1724 --
 1725 -- Table structure for table  `sys_log`
 1726 --
 1727 
 1728 CREATE TABLE `sys_log` (
 1729   `syslog_id` int(11) unsigned NOT NULL auto_increment,
 1730   `server_id` int(11) unsigned NOT NULL default '0',
 1731   `datalog_id` int(11) unsigned NOT NULL default '0',
 1732   `loglevel` tinyint(4) NOT NULL default '0',
 1733   `tstamp` int(11) unsigned NOT NULL DEFAULT '0',
 1734   `message` text,
 1735   PRIMARY KEY  (`syslog_id`)
 1736 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1737 
 1738 -- --------------------------------------------------------
 1739 
 1740 --
 1741 -- Table structure for table `sys_remoteaction`
 1742 --
 1743 
 1744 CREATE TABLE `sys_remoteaction` (
 1745   `action_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1746   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1747   `tstamp` int(11) NOT NULL DEFAULT '0',
 1748   `action_type` varchar(20) NOT NULL DEFAULT '',
 1749   `action_param` mediumtext,
 1750   `action_state` enum('pending','ok','warning','error') NOT NULL DEFAULT 'pending',
 1751   `response` mediumtext,
 1752   PRIMARY KEY (`action_id`),
 1753   KEY `server_id` (`server_id`)
 1754 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1755 
 1756 -- --------------------------------------------------------
 1757 
 1758 --
 1759 -- Table structure for table `sys_session`
 1760 --
 1761 
 1762 CREATE TABLE `sys_session` (
 1763   `session_id` varchar(64) NOT NULL DEFAULT '',
 1764   `date_created` datetime NULL DEFAULT NULL,
 1765   `last_updated` datetime NULL DEFAULT NULL,
 1766   `permanent` enum('n','y') NOT NULL DEFAULT 'n',
 1767   `session_data` longtext,
 1768   PRIMARY KEY (`session_id`),
 1769   KEY `last_updated` (`last_updated`)
 1770 ) DEFAULT CHARSET=utf8 ;
 1771 
 1772 -- --------------------------------------------------------
 1773 
 1774 --
 1775 -- Table structure for table `sys_theme`
 1776 --
 1777 
 1778 CREATE TABLE IF NOT EXISTS `sys_theme` (
 1779   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1780   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1781   `sys_perm_user` varchar(5) DEFAULT NULL,
 1782   `sys_perm_group` varchar(5) DEFAULT NULL,
 1783   `sys_perm_other` varchar(5) DEFAULT NULL,
 1784   `var_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1785   `tpl_name` varchar(32) NOT NULL DEFAULT '',
 1786   `username` varchar(64) NOT NULL DEFAULT '',
 1787   `logo_url` varchar(255) NOT NULL DEFAULT '',
 1788   PRIMARY KEY (`var_id`)
 1789 ) DEFAULT CHARSET=utf8 ;
 1790 
 1791 -- --------------------------------------------------------
 1792 
 1793 --
 1794 -- Table structure for table  `sys_user`
 1795 --
 1796 
 1797 CREATE TABLE `sys_user` (
 1798   `userid` int(11) unsigned NOT NULL auto_increment,
 1799   `sys_userid` int(11) unsigned NOT NULL default '1' COMMENT 'Created by userid',
 1800   `sys_groupid` int(11) unsigned NOT NULL default '1' COMMENT 'Created by groupid',
 1801   `sys_perm_user` varchar(5) NOT NULL default 'riud',
 1802   `sys_perm_group` varchar(5) NOT NULL default 'riud',
 1803   `sys_perm_other` varchar(5) NOT NULL default '',
 1804   `username` varchar(64) NOT NULL default '',
 1805   `passwort` varchar(200) NOT NULL default '',
 1806   `modules` varchar(255) NOT NULL default '',
 1807   `startmodule` varchar(255) NOT NULL default '',
 1808   `app_theme` varchar(32) NOT NULL default 'default',
 1809   `typ` varchar(16) NOT NULL default 'user',
 1810   `active` tinyint(1) NOT NULL default '1',
 1811   `language` varchar(2) NOT NULL default 'en',
 1812   `groups` TEXT,
 1813   `default_group` int(11) unsigned NOT NULL default '0',
 1814   `client_id` int(11) unsigned NOT NULL default '0',
 1815   `id_rsa` VARCHAR( 2000 ) NOT NULL default '',
 1816   `ssh_rsa` VARCHAR( 600 ) NOT NULL default '',
 1817   `lost_password_function` tinyint(1) NOT NULL default '1',
 1818   `lost_password_hash` VARCHAR(50) NOT NULL default '',
 1819   `lost_password_reqtime` DATETIME NULL default NULL,
 1820   PRIMARY KEY  (`userid`)
 1821 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1822 
 1823 -- --------------------------------------------------------
 1824 
 1825 --
 1826 -- Table structure for table `webdav_user`
 1827 --
 1828 
 1829 CREATE TABLE `webdav_user` (
 1830   `webdav_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1831   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1832   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1833   `sys_perm_user` varchar(5) DEFAULT NULL,
 1834   `sys_perm_group` varchar(5) DEFAULT NULL,
 1835   `sys_perm_other` varchar(5) DEFAULT NULL,
 1836   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1837   `parent_domain_id` int(11) unsigned NOT NULL DEFAULT '0',
 1838   `username` varchar(64) DEFAULT NULL,
 1839   `username_prefix` varchar(50) NOT NULL default '',
 1840   `password` varchar(200) DEFAULT NULL,
 1841   `active` enum('n','y') NOT NULL DEFAULT 'y',
 1842   `dir` varchar(255) DEFAULT NULL,
 1843   PRIMARY KEY (`webdav_user_id`)
 1844 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1845 
 1846 -- --------------------------------------------------------
 1847 
 1848 --
 1849 -- Table structure for table `web_backup`
 1850 --
 1851 
 1852 CREATE TABLE `web_backup` (
 1853   `backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 1854   `server_id` int(10) unsigned NOT NULL DEFAULT '0',
 1855   `parent_domain_id` int(10) unsigned NOT NULL DEFAULT '0',
 1856   `backup_type` enum('web','mysql','mongodb') NOT NULL DEFAULT 'web',
 1857   `backup_mode` varchar(64) NOT NULL DEFAULT  '',
 1858   `backup_format` varchar(64) NOT NULL DEFAULT '',
 1859   `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
 1860   `filename` varchar(255) NOT NULL DEFAULT '',
 1861   `filesize` VARCHAR(20) NOT NULL DEFAULT '',
 1862   `backup_password` VARCHAR(255) NOT NULL DEFAULT '',
 1863   PRIMARY KEY (`backup_id`)
 1864 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1865 
 1866 -- --------------------------------------------------------
 1867 
 1868 --
 1869 -- Table structure for table `web_database`
 1870 --
 1871 
 1872 CREATE TABLE `web_database` (
 1873   `database_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1874   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1875   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1876   `sys_perm_user` varchar(5) DEFAULT NULL,
 1877   `sys_perm_group` varchar(5) DEFAULT NULL,
 1878   `sys_perm_other` varchar(5) DEFAULT NULL,
 1879   `server_id` int(11) unsigned NOT NULL DEFAULT '0',
 1880   `parent_domain_id` int(11) unsigned NOT NULL DEFAULT  '0',
 1881   `type` varchar(16) NOT NULL DEFAULT 'y',
 1882   `database_name` varchar(64) DEFAULT NULL,
 1883   `database_name_prefix` varchar(50) NOT NULL default '',
 1884   `database_quota` int(11) DEFAULT NULL,
 1885   `quota_exceeded` enum('n','y') NOT NULL DEFAULT 'n',
 1886   `last_quota_notification` date NULL default NULL,
 1887   `database_user_id` int(11) unsigned DEFAULT NULL,
 1888   `database_ro_user_id` int(11) unsigned DEFAULT NULL,
 1889   `database_charset` varchar(64) DEFAULT NULL,
 1890   `remote_access` enum('n','y') NOT NULL DEFAULT 'y',
 1891   `remote_ips` text,
 1892   `backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none',
 1893   `backup_copies` INT NOT NULL DEFAULT '1',
 1894   `active` enum('n','y') NOT NULL DEFAULT 'y',
 1895   PRIMARY KEY (`database_id`),
 1896   KEY `database_user_id` (`database_user_id`),
 1897   KEY `database_ro_user_id` (`database_ro_user_id`)
 1898 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1899 
 1900 -- --------------------------------------------------------
 1901 
 1902 --
 1903 -- Tabellenstruktur für Tabelle `web_database_user`
 1904 --
 1905 
 1906 CREATE TABLE IF NOT EXISTS `web_database_user` (
 1907   `database_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 1908   `sys_userid` int(11) unsigned NOT NULL DEFAULT '0',
 1909   `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0',
 1910   `sys_perm_user` varchar(5) DEFAULT NULL,
 1911   `sys_perm_group` varchar(5) DEFAULT NULL,
 1912   `sys_perm_other` varchar(5) DEFAULT NULL,
 1913   `server_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
 1914   `database_user` varchar(64) DEFAULT NULL,
 1915   `database_user_prefix` varchar(50) NOT NULL default '',
 1916   `database_password` varchar(64) DEFAULT NULL,
 1917   `database_password_mongo` varchar(32) DEFAULT NULL,
 1918   PRIMARY KEY (`database_user_id`)
 1919 )  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 1920 
 1921 -- --------------------------------------------------------
 1922 
 1923 --
 1924 -- Table structure for table  `web_domain`
 1925 --
 1926 
 1927 CREATE TABLE `web_domain` (
 1928   `domain_id` int(11) unsigned NOT NULL auto_increment,
 1929   `sys_userid` int(11) unsigned NOT NULL default '0',
 1930   `sys_groupid` int(11) unsigned NOT NULL default '0',
 1931   `sys_perm_user` varchar(5) default NULL,
 1932   `sys_perm_group` varchar(5) default NULL,
 1933   `sys_perm_other` varchar(5) default NULL,
 1934   `server_id` int(11) unsigned NOT NULL default '0',
 1935   `ip_address` varchar(39) default NULL,
 1936   `ipv6_address` VARCHAR( 255 ) default NULL,
 1937   `domain` varchar(255) default NULL,
 1938   `type` varchar(32) default NULL,
 1939   `parent_domain_id` int(11) unsigned NOT NULL default '0',
 1940   `vhost_type` varchar(32) default NULL,
 1941   `document_root` varchar(255) default NULL,
 1942   `web_folder` varchar(100) default NULL,
 1943   `system_user` varchar(255) default NULL,
 1944   `system_group` varchar(255) default NULL,
 1945   `hd_quota` bigint(20) NOT NULL default '0',
 1946   `traffic_quota` bigint(20) NOT NULL default '-1',
 1947   `cgi` enum('n','y') NOT NULL default 'y',
 1948   `ssi` enum('n','y') NOT NULL default 'y',
 1949   `suexec` enum('n','y') NOT NULL default 'y',
 1950   `errordocs` tinyint(1) NOT NULL default '1',
 1951   `is_subdomainwww` tinyint(1) NOT NULL default '1',
 1952   `subdomain` enum('none','www','*') NOT NULL default 'none',
 1953   `php` varchar(32) NOT NULL default 'y',
 1954   `ruby` enum('n','y') NOT NULL default 'n',
 1955   `python` enum('n','y') NOT NULL default 'n',
 1956   `perl` enum('n','y') NOT NULL default 'n',
 1957   `redirect_type` varchar(255) default NULL,
 1958   `redirect_path` varchar(255) default NULL,
 1959   `seo_redirect` varchar(255) default NULL,
 1960   `rewrite_to_https` ENUM('y','n') NOT NULL DEFAULT 'n',
 1961   `ssl` enum('n','y') NOT NULL default 'n',
 1962   `ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n',
 1963   `ssl_letsencrypt_exclude` enum('n','y') NOT NULL DEFAULT 'n',
 1964   `ssl_state` varchar(255) NULL,
 1965   `ssl_locality` varchar(255) NULL,
 1966   `ssl_organisation` varchar(255) NULL,
 1967   `ssl_organisation_unit` varchar(255) NULL,
 1968   `ssl_country` varchar(255) NULL,
 1969   `ssl_domain` varchar(255) NULL,
 1970   `ssl_request` mediumtext NULL,
 1971   `ssl_cert` mediumtext NULL,
 1972   `ssl_bundle` mediumtext NULL,
 1973   `ssl_key` mediumtext NULL,
 1974   `ssl_action` varchar(16) NULL,
 1975   `stats_password` varchar(255) default NULL,
 1976   `stats_type` varchar(255) default 'awstats',
 1977   `allow_override` varchar(255) NOT NULL default 'All',
 1978   `apache_directives` mediumtext NULL DEFAULT NULL,
 1979   `nginx_directives` mediumtext NULL DEFAULT NULL,
 1980   `php_fpm_use_socket` ENUM('n','y') NOT NULL DEFAULT 'y',
 1981   `php_fpm_chroot` enum('n','y') NOT NULL DEFAULT 'n',
 1982   `pm` enum('static','dynamic','ondemand') NOT NULL DEFAULT 'ondemand',
 1983   `pm_max_children` int(11) NOT NULL DEFAULT '10',
 1984   `pm_start_servers` int(11) NOT NULL DEFAULT '2',
 1985   `pm_min_spare_servers` int(11) NOT NULL DEFAULT '1',
 1986   `pm_max_spare_servers` int(11) NOT NULL DEFAULT '5',
 1987   `pm_process_idle_timeout` int(11) NOT NULL DEFAULT '10',
 1988   `pm_max_requests` int(11) NOT NULL DEFAULT '0',
 1989   `php_open_basedir` mediumtext,
 1990   `custom_php_ini` mediumtext,
 1991   `backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none',
 1992   `backup_copies` INT NOT NULL DEFAULT '1',
 1993   `backup_format_web` VARCHAR( 255 ) NOT NULL default 'default',
 1994   `backup_format_db` VARCHAR( 255 ) NOT NULL default 'gzip',
 1995   `backup_encrypt` enum('n','y') NOT NULL DEFAULT 'n',
 1996   `backup_password` VARCHAR( 255 ) NOT NULL DEFAULT '',
 1997   `backup_excludes` mediumtext,
 1998   `active` enum('n','y') NOT NULL default 'y',
 1999   `traffic_quota_lock` enum('n','y') NOT NULL default 'n',
 2000   `proxy_directives` mediumtext,
 2001   `last_quota_notification` date NULL default NULL,
 2002   `rewrite_rules` mediumtext,
 2003   `added_date` date NULL DEFAULT NULL,
 2004   `added_by` varchar(255) DEFAULT NULL,
 2005   `directive_snippets_id` int(11) unsigned NOT NULL default '0',
 2006   `enable_pagespeed` ENUM('y','n') NOT NULL DEFAULT 'n',
 2007   `http_port` int(11) unsigned NOT NULL DEFAULT '80',
 2008   `https_port` int(11) unsigned NOT NULL DEFAULT '443',
 2009   `folder_directive_snippets` text,
 2010   `log_retention` int(11) NOT NULL DEFAULT '10',
 2011   `proxy_protocol` enum('n','y') NOT NULL default 'n',
 2012   `server_php_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
 2013   `jailkit_chroot_app_sections` mediumtext NULL DEFAULT NULL,
 2014   `jailkit_chroot_app_programs` mediumtext NULL DEFAULT NULL,
 2015   `delete_unused_jailkit` enum('n','y') NOT NULL default 'n',
 2016   `last_jailkit_update` date NULL DEFAULT NULL,
 2017   `last_jailkit_hash` varchar(255) DEFAULT NULL,
 2018   PRIMARY KEY  (`domain_id`),
 2019   UNIQUE KEY `serverdomain` (  `server_id` , `ip_address`,  `domain` )
 2020 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 2021 
 2022 -- --------------------------------------------------------
 2023 
 2024 --
 2025 -- Table structure for table `web_folder`
 2026 --
 2027 
 2028 CREATE TABLE IF NOT EXISTS `web_folder` (
 2029   `web_folder_id` bigint(20) NOT NULL AUTO_INCREMENT,
 2030   `sys_userid` int(11) NOT NULL DEFAULT '0',
 2031   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 2032   `sys_perm_user` varchar(5) DEFAULT NULL,
 2033   `sys_perm_group` varchar(5) DEFAULT NULL,
 2034   `sys_perm_other` varchar(5) DEFAULT NULL,
 2035   `server_id` int(11) NOT NULL DEFAULT '0',
 2036   `parent_domain_id` int(11) NOT NULL DEFAULT '0',
 2037   `path` varchar(255) DEFAULT NULL,
 2038   `active` varchar(255) NOT NULL DEFAULT 'y',
 2039   PRIMARY KEY (`web_folder_id`)
 2040 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 2041 
 2042 --
 2043 -- Dumping data for table `web_folder`
 2044 --
 2045 
 2046 
 2047 -- --------------------------------------------------------
 2048 
 2049 --
 2050 -- Table structure for table `web_folder_user`
 2051 --
 2052 
 2053 CREATE TABLE IF NOT EXISTS `web_folder_user` (
 2054   `web_folder_user_id` bigint(20) NOT NULL AUTO_INCREMENT,
 2055   `sys_userid` int(11) NOT NULL DEFAULT '0',
 2056   `sys_groupid` int(11) NOT NULL DEFAULT '0',
 2057   `sys_perm_user` varchar(5) DEFAULT NULL,
 2058   `sys_perm_group` varchar(5) DEFAULT NULL,
 2059   `sys_perm_other` varchar(5) DEFAULT NULL,
 2060   `server_id` int(11) NOT NULL DEFAULT '0',
 2061   `web_folder_id` int(11) NOT NULL DEFAULT '0',
 2062   `username` varchar(255) DEFAULT NULL,
 2063   `password` varchar(255) DEFAULT NULL,
 2064   `active` varchar(255) NOT NULL DEFAULT 'y',
 2065   PRIMARY KEY (`web_folder_user_id`)
 2066 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 2067 
 2068 --
 2069 -- Dumping data for table `web_folder_user`
 2070 --
 2071 
 2072 -- --------------------------------------------------------
 2073 
 2074 --
 2075 -- Table structure for table  `web_traffic`
 2076 --
 2077 
 2078 CREATE TABLE `web_traffic` (
 2079   `hostname` varchar(255) NOT NULL DEFAULT '',
 2080   `traffic_date` date NULL DEFAULT NULL,
 2081   `traffic_bytes` bigint(32) unsigned NOT NULL default '0',
 2082   UNIQUE KEY  (`hostname`,`traffic_date`)
 2083 ) DEFAULT CHARSET=utf8 ;
 2084 
 2085 -- --------------------------------------------------------
 2086 
 2087 --
 2088 -- Table structure for table `xmpp_domain`
 2089 --
 2090 
 2091 CREATE TABLE `xmpp_domain` (
 2092   `domain_id` int(11) unsigned NOT NULL auto_increment,
 2093   `sys_userid` int(11) unsigned NOT NULL default '0',
 2094   `sys_groupid` int(11) unsigned NOT NULL default '0',
 2095   `sys_perm_user` varchar(5) NOT NULL default '',
 2096   `sys_perm_group` varchar(5) NOT NULL default '',
 2097   `sys_perm_other` varchar(5) NOT NULL default '',
 2098   `server_id` int(11) unsigned NOT NULL default '0',
 2099   `domain` varchar(255) NOT NULL default '',
 2100 
 2101   `management_method` ENUM( 'normal', 'maildomain' ) NOT NULL default 'normal',
 2102   `public_registration` ENUM( 'n', 'y' ) NOT NULL default 'n',
 2103   `registration_url` varchar(255) NOT NULL DEFAULT '',
 2104   `registration_message` varchar(255) NOT NULL DEFAULT '',
 2105   `domain_admins` text,
 2106 
 2107   `use_pubsub` enum('n','y') NOT NULL DEFAULT 'n',
 2108   `use_proxy` enum('n','y') NOT NULL DEFAULT 'n',
 2109   `use_anon_host` enum('n','y') NOT NULL DEFAULT 'n',
 2110 
 2111   `use_vjud` enum('n','y') NOT NULL DEFAULT 'n',
 2112   `vjud_opt_mode` enum('in', 'out') NOT NULL DEFAULT 'in',
 2113 
 2114   `use_muc_host` enum('n','y') NOT NULL DEFAULT 'n',
 2115   `muc_name` varchar(30) NOT NULL DEFAULT '',
 2116   `muc_restrict_room_creation` enum('n', 'y', 'm') NOT NULL DEFAULT 'm',
 2117   `muc_admins` text,
 2118   `use_pastebin` enum('n','y') NOT NULL DEFAULT 'n',
 2119   `pastebin_expire_after` int(3) NOT NULL DEFAULT 48,
 2120   `pastebin_trigger` varchar(10) NOT NULL DEFAULT '!paste',
 2121   `use_http_archive` enum('n','y') NOT NULL DEFAULT 'n',
 2122   `http_archive_show_join` enum('n', 'y') NOT NULL DEFAULT 'n',
 2123   `http_archive_show_status` enum('n', 'y') NOT NULL DEFAULT 'n',
 2124   `use_status_host` enum('n','y') NOT NULL DEFAULT 'n',
 2125 
 2126   `ssl_state` varchar(255) NULL,
 2127   `ssl_locality` varchar(255) NULL,
 2128   `ssl_organisation` varchar(255) NULL,
 2129   `ssl_organisation_unit` varchar(255) NULL,
 2130   `ssl_country` varchar(255) NULL,
 2131   `ssl_email` varchar(255) NULL,
 2132   `ssl_request` mediumtext NULL,
 2133   `ssl_cert` mediumtext NULL,
 2134   `ssl_bundle` mediumtext NULL,
 2135   `ssl_key` mediumtext NULL,
 2136   `ssl_action` varchar(16) NULL,
 2137 
 2138   `active` enum('n','y') NOT NULL DEFAULT 'n',
 2139   PRIMARY KEY  (`domain_id`),
 2140   KEY `server_id` (`server_id`,`domain`),
 2141   KEY `domain_active` (`domain`,`active`)
 2142 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 2143 
 2144 -- --------------------------------------------------------
 2145 
 2146 --
 2147 -- Table structure for table  `xmpp_user`
 2148 --
 2149 
 2150 CREATE TABLE `xmpp_user` (
 2151   `xmppuser_id` int(11) unsigned NOT NULL auto_increment,
 2152   `sys_userid` int(11) unsigned NOT NULL default '0',
 2153   `sys_groupid` int(11) unsigned NOT NULL default '0',
 2154   `sys_perm_user` varchar(5) NOT NULL default '',
 2155   `sys_perm_group` varchar(5) NOT NULL default '',
 2156   `sys_perm_other` varchar(5) NOT NULL default '',
 2157   `server_id` int(11) unsigned NOT NULL default '0',
 2158   `jid` varchar(255) NOT NULL default '',
 2159   `password` varchar(255) NOT NULL default '',
 2160   `active` enum('n','y') NOT NULL DEFAULT 'n',
 2161   PRIMARY KEY  (`xmppuser_id`),
 2162   KEY `server_id` (`server_id`,`jid`),
 2163   KEY `jid_active` (`jid`,`active`)
 2164 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 2165 
 2166 -- --------------------------------------------------------
 2167 
 2168 -- --------------------------------------------------------
 2169 -- --------------------------------------------------------
 2170 -- DB-DATA
 2171 -- --------------------------------------------------------
 2172 -- --------------------------------------------------------
 2173 
 2174 --
 2175 -- Dumping data for table `aps_settings`
 2176 --
 2177 
 2178 INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(1, 'ignore-php-extension', '');
 2179 INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(2, 'ignore-php-configuration', '');
 2180 INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(3, 'ignore-webserver-module', '');
 2181 
 2182 -- --------------------------------------------------------
 2183 
 2184 --
 2185 -- Dumping data for table `country`
 2186 --
 2187 
 2188 INSERT INTO `country` (`iso`, `name`, `printable_name`, `iso3`, `numcode`, `eu`) VALUES
 2189 ('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 'n'),
 2190 ('AL', 'ALBANIA', 'Albania', 'ALB', 8, 'n'),
 2191 ('DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 'n'),
 2192 ('AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 'n'),
 2193 ('AD', 'ANDORRA', 'Andorra', 'AND', 20, 'n'),
 2194 ('AO', 'ANGOLA', 'Angola', 'AGO', 24, 'n'),
 2195 ('AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 'n'),
 2196 ('AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 'n'),
 2197 ('AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 'n'),
 2198 ('AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 'n'),
 2199 ('AM', 'ARMENIA', 'Armenia', 'ARM', 51, 'n'),
 2200 ('AW', 'ARUBA', 'Aruba', 'ABW', 533, 'n'),
 2201 ('AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 'n'),
 2202 ('AT', 'AUSTRIA', 'Austria', 'AUT', 40, 'y'),
 2203 ('AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 'n'),
 2204 ('BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 'n'),
 2205 ('BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 'n'),
 2206 ('BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 'n'),
 2207 ('BB', 'BARBADOS', 'Barbados', 'BRB', 52, 'n'),
 2208 ('BY', 'BELARUS', 'Belarus', 'BLR', 112, 'n'),
 2209 ('BE', 'BELGIUM', 'Belgium', 'BEL', 56, 'y'),
 2210 ('BZ', 'BELIZE', 'Belize', 'BLZ', 84, 'n'),
 2211 ('BJ', 'BENIN', 'Benin', 'BEN', 204, 'n'),
 2212 ('BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 'n'),
 2213 ('BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 'n'),
 2214 ('BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 'n'),
 2215 ('BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 'n'),
 2216 ('BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 'n'),
 2217 ('BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 'n'),
 2218 ('BR', 'BRAZIL', 'Brazil', 'BRA', 76, 'n'),
 2219 ('IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 'n'),
 2220 ('BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 'n'),
 2221 ('BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 'y'),
 2222 ('BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 'n'),
 2223 ('BI', 'BURUNDI', 'Burundi', 'BDI', 108, 'n'),
 2224 ('KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 'n'),
 2225 ('CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 'n'),
 2226 ('CA', 'CANADA', 'Canada', 'CAN', 124, 'n'),
 2227 ('CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 'n'),
 2228 ('KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 'n'),
 2229 ('CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 'n'),
 2230 ('TD', 'CHAD', 'Chad', 'TCD', 148, 'n'),
 2231 ('CL', 'CHILE', 'Chile', 'CHL', 152, 'n'),
 2232 ('CN', 'CHINA', 'China', 'CHN', 156, 'n'),
 2233 ('CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 'n'),
 2234 ('CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 'n'),
 2235 ('CO', 'COLOMBIA', 'Colombia', 'COL', 170, 'n'),
 2236 ('KM', 'COMOROS', 'Comoros', 'COM', 174, 'n'),
 2237 ('CG', 'CONGO', 'Congo', 'COG', 178, 'n'),
 2238 ('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 'n'),
 2239 ('CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 'n'),
 2240 ('CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 'n'),
 2241 ('CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384, 'n'),
 2242 ('HR', 'CROATIA', 'Croatia', 'HRV', 191, 'y'),
 2243 ('CU', 'CUBA', 'Cuba', 'CUB', 192, 'n'),
 2244 ('CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 'y'),
 2245 ('CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 'y'),
 2246 ('DK', 'DENMARK', 'Denmark', 'DNK', 208, 'y'),
 2247 ('DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 'n'),
 2248 ('DM', 'DOMINICA', 'Dominica', 'DMA', 212, 'n'),
 2249 ('DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 'n'),
 2250 ('EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 'n'),
 2251 ('EG', 'EGYPT', 'Egypt', 'EGY', 818, 'n'),
 2252 ('SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 'n'),
 2253 ('GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 'n'),
 2254 ('ER', 'ERITREA', 'Eritrea', 'ERI', 232, 'n'),
 2255 ('EE', 'ESTONIA', 'Estonia', 'EST', 233, 'y'),
 2256 ('ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 'n'),
 2257 ('FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 'n'),
 2258 ('FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 'n'),
 2259 ('FJ', 'FIJI', 'Fiji', 'FJI', 242, 'n'),
 2260 ('FI', 'FINLAND', 'Finland', 'FIN', 246, 'y'),
 2261 ('FR', 'FRANCE', 'France', 'FRA', 250, 'y'),
 2262 ('GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 'n'),
 2263 ('PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 'n'),
 2264 ('TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 'n'),
 2265 ('GA', 'GABON', 'Gabon', 'GAB', 266, 'n'),
 2266 ('GM', 'GAMBIA', 'Gambia', 'GMB', 270, 'n'),
 2267 ('GE', 'GEORGIA', 'Georgia', 'GEO', 268, 'n'),
 2268 ('DE', 'GERMANY', 'Germany', 'DEU', 276, 'y'),
 2269 ('GH', 'GHANA', 'Ghana', 'GHA', 288, 'n'),
 2270 ('GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 'n'),
 2271 ('GR', 'GREECE', 'Greece', 'GRC', 300, 'y'),
 2272 ('GL', 'GREENLAND', 'Greenland', 'GRL', 304, 'n'),
 2273 ('GD', 'GRENADA', 'Grenada', 'GRD', 308, 'n'),
 2274 ('GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 'n'),
 2275 ('GU', 'GUAM', 'Guam', 'GUM', 316, 'n'),
 2276 ('GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 'n'),
 2277 ('GN', 'GUINEA', 'Guinea', 'GIN', 324, 'n'),
 2278 ('GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 'n'),
 2279 ('GY', 'GUYANA', 'Guyana', 'GUY', 328, 'n'),
 2280 ('HT', 'HAITI', 'Haiti', 'HTI', 332, 'n'),
 2281 ('HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 'n'),
 2282 ('VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 'n'),
 2283 ('HN', 'HONDURAS', 'Honduras', 'HND', 340, 'n'),
 2284 ('HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 'n'),
 2285 ('HU', 'HUNGARY', 'Hungary', 'HUN', 348, 'y'),
 2286 ('IS', 'ICELAND', 'Iceland', 'ISL', 352, 'n'),
 2287 ('IN', 'INDIA', 'India', 'IND', 356, 'n'),
 2288 ('ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 'n'),
 2289 ('IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 'n'),
 2290 ('IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 'n'),
 2291 ('IE', 'IRELAND', 'Ireland', 'IRL', 372, 'y'),
 2292 ('IL', 'ISRAEL', 'Israel', 'ISR', 376, 'n'),
 2293 ('IT', 'ITALY', 'Italy', 'ITA', 380, 'y'),
 2294 ('JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 'n'),
 2295 ('JP', 'JAPAN', 'Japan', 'JPN', 392, 'n'),
 2296 ('JO', 'JORDAN', 'Jordan', 'JOR', 400, 'n'),
 2297 ('KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 'n'),
 2298 ('KE', 'KENYA', 'Kenya', 'KEN', 404, 'n'),
 2299 ('KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 'n'),
 2300 ('KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea, Democratic People''s Republic of', 'PRK', 408, 'n'),
 2301 ('KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 'n'),
 2302 ('KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 'n'),
 2303 ('KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 'n'),
 2304 ('LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418, 'n'),
 2305 ('LV', 'LATVIA', 'Latvia', 'LVA', 428, 'y'),
 2306 ('LB', 'LEBANON', 'Lebanon', 'LBN', 422, 'n'),
 2307 ('LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 'n'),
 2308 ('LR', 'LIBERIA', 'Liberia', 'LBR', 430, 'n'),
 2309 ('LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 'n'),
 2310 ('LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 'n'),
 2311 ('LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 'y'),
 2312 ('LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 'y'),
 2313 ('MO', 'MACAO', 'Macao', 'MAC', 446, 'n'),
 2314 ('MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 'n'),
 2315 ('MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 'n'),
 2316 ('MW', 'MALAWI', 'Malawi', 'MWI', 454, 'n'),
 2317 ('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 'n'),
 2318 ('MV', 'MALDIVES', 'Maldives', 'MDV', 462, 'n'),
 2319 ('ML', 'MALI', 'Mali', 'MLI', 466, 'n'),
 2320 ('MT', 'MALTA', 'Malta', 'MLT', 470, 'y'),
 2321 ('MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 'n'),
 2322 ('MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 'n'),
 2323 ('MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 'n'),
 2324 ('MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 'n'),
 2325 ('YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 'n'),
 2326 ('MX', 'MEXICO', 'Mexico', 'MEX', 484, 'n'),
 2327 ('FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 'n'),
 2328 ('MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 'n'),
 2329 ('MC', 'MONACO', 'Monaco', 'MCO', 492, 'n'),
 2330 ('MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 'n'),
 2331 ('MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 'n'),
 2332 ('MA', 'MOROCCO', 'Morocco', 'MAR', 504, 'n'),
 2333 ('MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 'n'),
 2334 ('MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 'n'),
 2335 ('NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 'n'),
 2336 ('NR', 'NAURU', 'Nauru', 'NRU', 520, 'n'),
 2337 ('NP', 'NEPAL', 'Nepal', 'NPL', 524, 'n'),
 2338 ('NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 'y'),
 2339 ('AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 'n'),
 2340 ('NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 'n'),
 2341 ('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 'n'),
 2342 ('NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 'n'),
 2343 ('NE', 'NIGER', 'Niger', 'NER', 562, 'n'),
 2344 ('NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 'n'),
 2345 ('NU', 'NIUE', 'Niue', 'NIU', 570, 'n'),
 2346 ('NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 'n'),
 2347 ('MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 'n'),
 2348 ('NO', 'NORWAY', 'Norway', 'NOR', 578, 'n'),
 2349 ('OM', 'OMAN', 'Oman', 'OMN', 512, 'n'),
 2350 ('PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 'n'),
 2351 ('PW', 'PALAU', 'Palau', 'PLW', 585, 'n'),
 2352 ('PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 'n'),
 2353 ('PA', 'PANAMA', 'Panama', 'PAN', 591, 'n'),
 2354 ('PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 'n'),
 2355 ('PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 'n'),
 2356 ('PE', 'PERU', 'Peru', 'PER', 604, 'n'),
 2357 ('PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 'n'),
 2358 ('PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 'n'),
 2359 ('PL', 'POLAND', 'Poland', 'POL', 616, 'y'),
 2360 ('PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 'y'),
 2361 ('PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 'n'),
 2362 ('QA', 'QATAR', 'Qatar', 'QAT', 634, 'n'),
 2363 ('RE', 'REUNION', 'Reunion', 'REU', 638, 'n'),
 2364 ('RO', 'ROMANIA', 'Romania', 'ROM', 642, 'y'),
 2365 ('RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 'n'),
 2366 ('RW', 'RWANDA', 'Rwanda', 'RWA', 646, 'n'),
 2367 ('SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 'n'),
 2368 ('KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 'n'),
 2369 ('LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 'n'),
 2370 ('PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 'n'),
 2371 ('VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 'n'),
 2372 ('WS', 'SAMOA', 'Samoa', 'WSM', 882, 'n'),
 2373 ('SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 'n'),
 2374 ('ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 'n'),
 2375 ('SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 'n'),
 2376 ('SN', 'SENEGAL', 'Senegal', 'SEN', 686, 'n'),
 2377 ('RS', 'SERBIA', 'Serbia', 'SRB', 381, 'n'),
 2378 ('SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 'n'),
 2379 ('SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 'n'),
 2380 ('SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 'n'),
 2381 ('SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 'y'),
 2382 ('SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 'y'),
 2383 ('SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 'n'),
 2384 ('SO', 'SOMALIA', 'Somalia', 'SOM', 706, 'n'),
 2385 ('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 'n'),
 2386 ('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 'n'),
 2387 ('ES', 'SPAIN', 'Spain', 'ESP', 724, 'y'),
 2388 ('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 'n'),
 2389 ('SD', 'SUDAN', 'Sudan', 'SDN', 736, 'n'),
 2390 ('SR', 'SURINAME', 'Suriname', 'SUR', 740, 'n'),
 2391 ('SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 'n'),
 2392 ('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 'n'),
 2393 ('SE', 'SWEDEN', 'Sweden', 'SWE', 752, 'y'),
 2394 ('CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 'n'),
 2395 ('SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 'n'),
 2396 ('TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 'n'),
 2397 ('TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 'n'),
 2398 ('TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 'n'),
 2399 ('TH', 'THAILAND', 'Thailand', 'THA', 764, 'n'),
 2400 ('TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 'n'),
 2401 ('TG', 'TOGO', 'Togo', 'TGO', 768, 'n'),
 2402 ('TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 'n'),
 2403 ('TO', 'TONGA', 'Tonga', 'TON', 776, 'n'),
 2404 ('TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 'n'),
 2405 ('TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 'n'),
 2406 ('TR', 'TURKEY', 'Turkey', 'TUR', 792, 'n'),
 2407 ('TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 'n'),
 2408 ('TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 'n'),
 2409 ('TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 'n'),
 2410 ('UG', 'UGANDA', 'Uganda', 'UGA', 800, 'n'),
 2411 ('UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 'n'),
 2412 ('AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 'n'),
 2413 ('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 'n'),
 2414 ('US', 'UNITED STATES', 'United States', 'USA', 840, 'n'),
 2415 ('UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 'n'),
 2416 ('UY', 'URUGUAY', 'Uruguay', 'URY', 858, 'n'),
 2417 ('UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 'n'),
 2418 ('VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 'n'),
 2419 ('VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 'n'),
 2420 ('VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 'n'),
 2421 ('VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 'n'),
 2422 ('VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 'n'),
 2423 ('WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 'n'),
 2424 ('EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 'n'),
 2425 ('YE', 'YEMEN', 'Yemen', 'YEM', 887, 'n'),
 2426 ('ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 'n'),
 2427 ('ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 'n'),
 2428 ('ME', 'MONTENEGRO', 'Montenegro', 'MNE', 382, 'n');
 2429 
 2430 -- --------------------------------------------------------
 2431 
 2432 --
 2433 -- Dumping data for table `dns_template`
 2434 --
 2435 
 2436 INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Default', 'DOMAIN,IP,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=3600\nttl=3600\nxfer=\nalso_notify=\ndnssec_wanted=N\ndnssec_algo=ECDSAP256SHA256\n\n[DNS_RECORDS]\nA|{DOMAIN}.|{IP}|0|3600\nA|www|{IP}|0|3600\nA|mail|{IP}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|mail.{DOMAIN}.|10|3600\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600', 'y');
 2437 
 2438 
 2439 -- --------------------------------------------------------
 2440 
 2441 --
 2442 -- Dumping data for table `help_faq`
 2443 --
 2444 
 2445 INSERT INTO `help_faq` VALUES (1,1,0,'I would like to know ...','Yes, of course.',1,1,'riud','riud','r');
 2446 
 2447 -- --------------------------------------------------------
 2448 
 2449 --
 2450 -- Dumping data for table `help_faq_sections`
 2451 --
 2452 
 2453 INSERT INTO `help_faq_sections` VALUES (1,'General',0,NULL,NULL,NULL,NULL,NULL);
 2454 
 2455 -- --------------------------------------------------------
 2456 
 2457 --
 2458 -- Dumping data for table `spamfilter_policy`
 2459 --
 2460 
 2461 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(1, 1, 0, 'riud', 'riud', 'r', 'Non-paying', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'Y', '', '', '', '', '', '', 3, 7, 10, 0, 0, '', '', '', '', 'N', 'N', 'N', '', '', '', '', '', '', '', 0, '', 'n', 6.00, 8.00, 'rewrite_subject', 12.00);
 2462 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(2, 1, 0, 'riud', 'riud', 'r', 'Uncensored', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n', 999.00, 999.00, 'rewrite_subject', 999.00);
 2463 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(3, 1, 0, 'riud', 'riud', 'r', 'Wants all spam', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n', 999.00, 999.00, 'rewrite_subject', 999.00);
 2464 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(4, 1, 0, 'riud', 'riud', 'r', 'Wants viruses', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 6.9, 6.9, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'y', 4.00, 6.00, 'rewrite_subject', 10.00);
 2465 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(5, 1, 0, 'riud', 'riud', 'r', 'Normal', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', '', '', '', '', '', '', 1, 4.5, 50, 0, 0, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, '', '***SPAM***', NULL, NULL, 'y', 4.00, 6.00, 'rewrite_subject', 10.00);
 2466 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(6, 1, 0, 'riud', 'riud', 'r', 'Trigger happy', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 5, 5, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'y', 2.00, 4.00, 'rewrite_subject', 8.00);
 2467 INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`, `rspamd_greylisting`, `rspamd_spam_greylisting_level`, `rspamd_spam_tag_level`, `rspamd_spam_tag_method`, `rspamd_spam_kill_level`) VALUES(7, 1, 0, 'riud', 'riud', 'r', 'Permissive', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 10, 20, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n', 7.00, 10.00, 'rewrite_subject', 20.00);
 2468 
 2469 -- --------------------------------------------------------
 2470 
 2471 --
 2472 -- Dumping data for table `sys_group`
 2473 --
 2474 
 2475 INSERT INTO `sys_group` (`groupid`, `name`, `description`, `client_id`) VALUES (1, 'admin', 'Administrators group', 0);
 2476 
 2477 -- --------------------------------------------------------
 2478 
 2479 --
 2480 -- Dumping data for table `sys_ini`
 2481 --
 2482 
 2483 INSERT INTO `sys_ini` (`sysini_id`, `config`, `default_logo`, `custom_logo`) VALUES (1, '', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAABBCAYAAACU5+uOAAAItUlEQVR42u1dCWwVVRStUJZCK6HsFNAgWpaCJkKICZKApKUFhURQpEnZF4EEUJZYEEpBIamgkQpUQBZRW7YCBqQsggsQEAgKLbIGCYsSCNqyQ8D76h18Hd/MvJk/n/bXc5KT+TNz79vPzNv+/2FhAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOAe++s0akTsRZxMnE6cGkKcxkwhPofaBPwWRzxxB/EO8UGI8xhxEGoV8EscY8qBKFRcgdoFAhXHC+VUHAbHo5aBQASyrZwL5DoxEjUNeBXI9XIuEMEE1DTgVSA3FA3qIDEtBLnTQiBDUNOAV4EUKhpURojmZQQEAjwKgSwK0bykWQgEU74ABAKBABAIBOIJffoNrkRsS0whDiMO5uNw4gBiSxvfGOJrbDtMOgr2JNa18HmZmETsopnGp4h9xdF0TcQRb8NEPkawTzv2qaWIoybnZYRUBoJD+difGAuBlCy0qsRM4mfERcTFfGygsBUF/xFxE/EQ8RixwIbi/j7il8R3iE8qwuxAXMJxuuFiTvNMYleb/E0gXiI+cOBaISTJrzLxcw2/+8Q5pjjfNNkM0RDILLadpbimw+bsc4DPkxRpuqkZ1orisoBAiguuhkUhPSvZRBA3u6gsK94g9jDFP9aHcAV3EKNNYX8i3RcNJ4M4nTiROJCYykIzbGZKvouk68vYbyS/cUbz+RrJZpzkO5Sv3eajaJhRDvUwg21nKK4VcF5WKPgFH6PZZw/7dJXC6S6lczunfbIQLpeDkZ+lJcoCAikuvChioaLBtfD4JHPiXSFKKexBPoa9Wwr3ael6skMZDGO7K3z+uOSb5OA7mu2KiOGmPH3ADVh8/sohnDS2S1NcG+uiO/kd+8RL146YRWzj359tb0Eg+gIpsHkjFNrQqiF3DZJABDtyuCP5/FuNRlHN8Ofz9nx+XLNR3jR1c4w8TSFGSmnr4FEgU7wKhI51jAeTpv+/ZQGBOAuEu1d/Ku6LV35t9rdigkUjHuMgkHPEecQsxdjjUx4zHbMI+10OdzqfZ2o0iiqSfzgPfMXnzZqN6iTbJ5jytMTU0E97FEhaAAJ5kc/PuJjQOCoIgegJpKbUl5b5vGaBT+A+vOgn5/JYIdFBIOs1wo1kIZl93+P70/h8oUZYFXkmKInPU9h3m2YeT8lvRilPyyWbi3xt4iMWSDc+P4lp3uAIRDxdryjui6dmuujXcr91IDcMmaJv31WISfTrLeJXCUT3yb1a4Ztmalyu61MaZG/XtD9tapRGnpZKNp2lNNZ3KZARAQgk3untBYEEPgbJ92FsIAax34v1AQ2B5Go2BlW60n0QyCC/BWISdJ5LgewWU8k86DdTzMyNh0BKVyAzfB5I93YQyBGeTlW9lQbwIle2Rdgzy7BAxJT6Hb6X6EIgTrznRSCiHli02cwcPor1pbkQiL5AKvOA+ZZPAtkfxFms3j4IZHAwBGJaRPxdjH00BSImJRqKOlEwjtjUo0Dm2pWla4HMzsyqQIxSMKI8C8RkL9YXuhDf5gqcw4NweaZJiGkh8UeLwi+Utkb4KZCrYszkVSDiQRDMN4hkf5DvZ2gKZJyLPJgFkmAjEDEF3EYSWzPeklO8Q8CLQGKJhQquK+eDdLFNZBJxFLEf8XUXFTbcYv2kRhAEIq+vGNO88zTTKVaRzxPrSSvPW11O8yZqCiROSnMsX0sP0ixWops1Hfbx/AaJIz5QcFc5n+ZVNcbxmoWtEsBNB4EU8Tgk32Gv1wneEybeWG1N8RoNbplmOo2neiyxE3/eoun7G9t31hGIqXuzl8/HB0kgxhvhD03/KoEIpIWFQPLK+UJhkWpgKLZP8IKhajNhJg8A7yt8/5K6QoFM8z5mc68Ph3VWM6wTbN+a+AR/vqThV13KYyMXAgmXps9FnK8GSSA17KaXFf7R3gUyd8H/TiBss9fngfQehzfMpkDLgxcS73J4k1y85WrxtTtOjZPuVZA2O55RhLfUId5XpI2UHwZDIHxtp7HtRrVL25SfhWy7z7VAMuYvipszd0FJcfxzHspdrMctGnGcZNPTZ4F0VszqyPSlPHm8JG9f2SDtgF3Nq/rnJZssyXeUdP0CN64c9l/FDfGyZNNNkaeVGmnMM+Vdtd19los8/2e7Ow/E70lxiG7pRmkn8AaeULlcoo4sBDLfKvL0nLUxablfX0hfmfuQ01avI65fUQYEkupRIJHcAMwbDWNNdmLgupV4zeMO3stcIZ1M4aYo4vZt0oO7Locd0ndGTEQofN+QxiZ22+y7W+RpgUb66vOU7232SZXupZqvaYT3Dfu8ZLrejtc47mvkJ9FoVEWKBmW7dyc7ZXD1Nb2TH3JVn5Tqa3r1repzY6/gwWeqhUCGO/XjWSTmjYYVLOzFoP0Z/qJTks033brxrtjmxCbGtK4ivEqKuH2fNuc0tDatIYgna4yGbz2eeTL8WhJbic2aDnmqqpm2KlLeK5vWn0pc0wirGvtUtBkzNdPKDzWe24oGdZX4CzGfWCD4U93GBQdqNSw4Uiny8K9h4buOhlU2scq+Q1G1i233k63hFwBPEfcS04l1FGJoynbH+fgz8ZKFQJLDAMDjk/psCPzw20XxE6mmdLd24d8KNQ14FciUEPl1xHvEhlK6W2j65aOWgUAEUpV4NEREstyDQNqjloFARVKL/xukrAvkGjGC09zGwfYKsQdqF/BTKMnEJcTtxC3EPAU3iic5cRkfjc/ZFvZuuZm4gXjOouG35LQ2Yfutkq/4pfpN/E9TDVCjQGkJqQExho+CjYlRPseRiQE3EIriaMZTw4K3mOJv23J8jme23RsEAMqqQJrb9PnnEbPEVpUAuJD4Mf/PoCqeONQCUJYFElGKf7ojpnqjUQtAWRdJaf1t2w8ofSAUBNKulATSEaUPhIpIRj9icbyFUgdCTSRTeR0i2HwfpQ0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBnG392D9QU+JXhxAAAAAElFTkSuQmCC', '');
 2484 
 2485 -- --------------------------------------------------------
 2486 
 2487 --
 2488 -- Dumping data for table `sys_user`
 2489 --
 2490 
 2491 INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default', 'global', 'themes/default/images/header_logo.png');
 2492 INSERT INTO `sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default-v2', 'global', 'themes/default-v2/images/header_logo.png');
 2493 
 2494 -- --------------------------------------------------------
 2495 
 2496 --
 2497 -- Dumping data for table `sys_user`
 2498 --
 2499 
 2500 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', 'xxx', 'dashboard,admin,client,mail,monitor,sites,dns,vm,tools,help', 'dashboard', 'default', 'admin', 1, 'en', '1,2', 1, 0);
 2501 
 2502 -- --------------------------------------------------------
 2503 
 2504 --
 2505 -- Dumping data for table `sys_config`
 2506 --
 2507 
 2508 INSERT INTO sys_config VALUES ('db','db_version','3.2.5');
 2509 INSERT INTO sys_config VALUES ('interface','session_timeout','0');
 2510 
 2511 SET FOREIGN_KEY_CHECKS = 1;