From 97fd829089335248cd5b2b82af1363460a3c42eb Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 31 Aug 2010 08:16:12 -0400
Subject: [PATCH] Added document_root_www field to the web_domain table. This field contains the symlink path to the website.

---
 install/sql/incremental/upd_0001.sql |    1 +
 install/sql/ispconfig3.sql           |    1 +
 2 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/install/sql/incremental/upd_0001.sql b/install/sql/incremental/upd_0001.sql
new file mode 100644
index 0000000..8759395
--- /dev/null
+++ b/install/sql/incremental/upd_0001.sql
@@ -0,0 +1 @@
+ALTER TABLE `web_domain` ADD `document_root_www` VARCHAR( 255 ) NULL AFTER `document_root`;
\ No newline at end of file
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index d39bb06..69c73d8 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -1084,6 +1084,7 @@
   `parent_domain_id` int(11) unsigned NOT NULL default '0',
   `vhost_type` varchar(32) default NULL,
   `document_root` varchar(255) default NULL,
+  `document_root_www` varchar(255) default NULL,
   `system_user` varchar(255) default NULL,
   `system_group` varchar(255) default NULL,
   `hd_quota` bigint(20) NOT NULL default '0',

--
Gitblit v1.9.1