diff options
| author | Martin Willi <martin@strongswan.org> | 2008-04-15 15:13:53 +0000 |
|---|---|---|
| committer | Martin Willi <martin@strongswan.org> | 2008-04-15 15:13:53 +0000 |
| commit | 02e4180e489d1de8d5a9e437d71c225b5dcbc4c3 (patch) | |
| tree | 72c1fdc23feaf8942c2086998c2732ebb9f6a9ad /src/charon/plugins/sql/mysql.sql | |
| parent | 1822ca740bee3269280db91924e5503dba9a75c4 (diff) | |
| download | strongswan-02e4180e489d1de8d5a9e437d71c225b5dcbc4c3.tar.bz2 strongswan-02e4180e489d1de8d5a9e437d71c225b5dcbc4c3.tar.xz | |
updated sql plugin to respect config changes
Diffstat (limited to 'src/charon/plugins/sql/mysql.sql')
| -rw-r--r-- | src/charon/plugins/sql/mysql.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/charon/plugins/sql/mysql.sql b/src/charon/plugins/sql/mysql.sql index aefab21dc..aca8b83af 100644 --- a/src/charon/plugins/sql/mysql.sql +++ b/src/charon/plugins/sql/mysql.sql @@ -20,6 +20,8 @@ CREATE TABLE `child_configs` ( `updown` varchar(128) collate utf8_unicode_ci default NULL, `hostaccess` tinyint(1) unsigned NOT NULL default '0', `mode` tinyint(4) unsigned NOT NULL default '1', + `dpd_action` tinyint(4) unsigned NOT NULL default '0', + `close_action` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; @@ -54,6 +56,7 @@ CREATE TABLE `peer_configs` ( `local_id` varchar(64) collate utf8_unicode_ci NOT NULL, `remote_id` varchar(64) collate utf8_unicode_ci NOT NULL, `cert_policy` tinyint(3) unsigned NOT NULL default '1', + `uniqueid` tinyint(3) unsigned NOT NULL default '0', `auth_method` tinyint(3) unsigned NOT NULL default '1', `eap_type` tinyint(3) unsigned NOT NULL default '0', `eap_vendor` smallint(5) unsigned NOT NULL default '0', @@ -64,7 +67,8 @@ CREATE TABLE `peer_configs` ( `overtime` mediumint(8) unsigned NOT NULL default '300', `mobike` tinyint(1) NOT NULL default '1', `dpd_delay` mediumint(8) unsigned NOT NULL default '120', - `dpd_action` tinyint(3) unsigned NOT NULL default '1', + `virtual` varchar(40) default NULL, + `pool` varchar(32) default NULL, `mediation` tinyint(1) NOT NULL default '0', `mediated_by` int(10) unsigned NOT NULL default '0', `peer_id` int(10) unsigned NOT NULL default '0', |