| | |
| | | `language` char(2) NOT NULL DEFAULT 'en', |
| | | `usertheme` varchar(32) NOT NULL DEFAULT 'default', |
| | | `template_master` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `template_additional` text NOT NULL DEFAULT '', |
| | | `template_additional` text NOT NULL, |
| | | `created_at` bigint(20) DEFAULT NULL, |
| | | `locked` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `canceled` enum('n','y') NOT NULL DEFAULT 'n', |
| | |
| | | `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
| | | `serial` int(10) unsigned default NULL, |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`) |
| | | KEY `rr` (`zone`,`type`,`name`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `domain` varchar(255) NOT NULL default '', |
| | | `dkim` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `dkim_private` mediumtext NOT NULL default '', |
| | | `dkim_public` mediumtext NOT NULL default '', |
| | | `dkim_private` mediumtext NOT NULL, |
| | | `dkim_public` mediumtext NOT NULL, |
| | | `active` enum('n','y') NOT NULL, |
| | | PRIMARY KEY (`domain_id`), |
| | | KEY `server_id` (`server_id`,`domain`), |
| | |
| | | `typ` varchar(16) NOT NULL default 'user', |
| | | `active` tinyint(1) NOT NULL default '1', |
| | | `language` varchar(2) NOT NULL default 'en', |
| | | `groups` TEXT NOT NULL default '', |
| | | `groups` TEXT NOT NULL, |
| | | `default_group` int(11) unsigned NOT NULL default '0', |
| | | `client_id` int(11) unsigned NOT NULL default '0', |
| | | `id_rsa` VARCHAR( 2000 ) NOT NULL default '', |
| | |
| | | `rewrite_rules` mediumtext, |
| | | `added_date` date NOT NULL DEFAULT '0000-00-00', |
| | | `added_by` varchar(255) DEFAULT NULL, |
| | | PRIMARY KEY (`domain_id`) |
| | | PRIMARY KEY (`domain_id`), |
| | | UNIQUE KEY `serverdomain` ( `server_id` , `domain` ) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |