diff options
| author | Tobias Brunner <tobias@strongswan.org> | 2011-08-08 16:15:28 +0200 |
|---|---|---|
| committer | Tobias Brunner <tobias@strongswan.org> | 2011-08-08 16:15:28 +0200 |
| commit | 1d5aae4b53c875f8cbbd3d7405e484726a0ff555 (patch) | |
| tree | 51b1d36379264b287395e2f8ac58b376e98238de /src/libcharon/plugins/sql | |
| parent | 18c4d010f4f634d5c5a7fa90c7c92075dcce87e4 (diff) | |
| download | strongswan-1d5aae4b53c875f8cbbd3d7405e484726a0ff555.tar.bz2 strongswan-1d5aae4b53c875f8cbbd3d7405e484726a0ff555.tar.xz | |
Fixed syntax in MySQL script.
Diffstat (limited to 'src/libcharon/plugins/sql')
| -rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql index 721e5a2a8..e5d878689 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -20,7 +20,7 @@ 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 '2', - `start_action` tinyint(4) unsigned NOT NULL default '0' + `start_action` tinyint(4) unsigned NOT NULL default '0', `dpd_action` tinyint(4) unsigned NOT NULL default '0', `close_action` tinyint(4) unsigned NOT NULL default '0', `ipcomp` tinyint(4) unsigned NOT NULL default '0', @@ -42,7 +42,8 @@ CREATE TABLE `child_config_traffic_selector` ( DROP TABLE IF EXISTS `proposals`; CREATE TABLE `proposals` ( `id` int(10) unsigned NOT NULL auto_increment, - `proposal` varchar(128) NOT NULL + `proposal` varchar(128) NOT NULL, + PRIMARY KEY (`id`) ); |