From 83b0d0f038461786c6e62b381c6e0c05997d7ff6 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Wed, 09 Nov 2005 17:22:49 -0500
Subject: [PATCH] Added mail domains
---
interface/sql/ispconfig3db.sql | 14 +++++++++++---
1 files changed, 11 insertions(+), 3 deletions(-)
diff --git a/interface/sql/ispconfig3db.sql b/interface/sql/ispconfig3db.sql
index 887ce2e..c37bd43 100644
--- a/interface/sql/ispconfig3db.sql
+++ b/interface/sql/ispconfig3db.sql
@@ -3,7 +3,7 @@
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
-# Erstellungszeit: 01. November 2005 um 23:57
+# Erstellungszeit: 09. November 2005 um 23:22
# Server Version: 4.0.23
# PHP-Version: 5.0.3
# Datenbank: `ispconfig3`
@@ -35,10 +35,17 @@
DROP TABLE IF EXISTS mail_domain;
CREATE TABLE mail_domain (
domain_id int(11) NOT NULL auto_increment,
+ sys_userid int(11) NOT NULL default '0',
+ sys_groupid int(11) NOT NULL default '0',
+ sys_perm_user varchar(5) NOT NULL default '',
+ sys_perm_group varchar(5) NOT NULL default '',
+ sys_perm_other varchar(5) NOT NULL default '',
server_id int(11) NOT NULL default '0',
domain varchar(255) NOT NULL default '',
- type enum('local','relay','manual_relay') NOT NULL default 'local',
+ type enum('local','relay','manual_relay','alias') NOT NULL default 'local',
relay_host varchar(255) NOT NULL default '',
+ destination varchar(255) NOT NULL default '',
+ active tinyint(4) NOT NULL default '1',
PRIMARY KEY (domain_id),
KEY server_id (server_id,domain,type)
) TYPE=MyISAM;
@@ -47,6 +54,7 @@
# Daten f�r Tabelle `mail_domain`
#
+INSERT INTO mail_domain VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'test.de', 'local', '', '', 1);
# --------------------------------------------------------
#
@@ -399,5 +407,5 @@
# Daten f�r Tabelle `sys_user`
#
-INSERT INTO sys_user VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,clients,designer,resellers,sites', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);
+INSERT INTO sys_user VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,designer,sites', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0);
--
Gitblit v1.9.1