From 0a466dfd65c07d4bf8c61c0e98c536c0f0b65ec1 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 23 Oct 2007 11:07:59 -0400
Subject: [PATCH] Added SSL website support.

---
 install/sql/ispconfig3.sql |   19 +++++++++++++++----
 1 files changed, 15 insertions(+), 4 deletions(-)

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 3b0acb9..7badb54 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -840,15 +840,26 @@
   `system_group` varchar(255) default NULL,
   `hd_quota` int(11) NOT NULL default '0',
   `traffic_quota` int(11) NOT NULL default '0',
-  `cgi` varchar(255) NOT NULL default 'y',
-  `ssi` varchar(255) NOT NULL default 'y',
-  `suexec` varchar(255) NOT NULL default 'y',
+  `cgi` char(1) NOT NULL default 'y',
+  `ssi` char(1) NOT NULL default 'y',
+  `suexec` char(1) NOT NULL default 'y',
   `php` varchar(255) NOT NULL default 'y',
   `redirect_type` varchar(255) default NULL,
   `redirect_path` varchar(255) default NULL,
+  `ssl` enum('n','y') NOT NULL default 'n',
+  `ssl_state` varchar(255) NOT NULL,
+  `ssl_locality` varchar(255) NOT NULL,
+  `ssl_organisation` varchar(255) NOT NULL,
+  `ssl_organisation_unit` varchar(255) NOT NULL,
+  `ssl_country` varchar(255) NOT NULL,
+  `ssl_request` mediumtext NOT NULL,
+  `ssl_cert` mediumtext NOT NULL,
+  `ssl_bundle` mediumtext NOT NULL,
+  `ssl_action` varchar(10) NOT NULL,
   `active` varchar(255) NOT NULL default 'y',
   PRIMARY KEY  (`domain_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
 
 -- 
 -- Daten f�r Tabelle `web_domain`

--
Gitblit v1.9.1