diff options
| author | Andreas Steffen <andreas.steffen@strongswan.org> | 2010-07-12 20:28:24 +0200 |
|---|---|---|
| committer | Andreas Steffen <andreas.steffen@strongswan.org> | 2010-07-12 20:28:34 +0200 |
| commit | ab635e029ec5a88d41aaa3dbf864d1ae6bd9a982 (patch) | |
| tree | c03acdf34c8116cc0d9ca454c7f33f43ad440021 /src/libcharon/plugins/sql/mysql.sql | |
| parent | cb0a9d58a38d2fe163eb61d350f403a47842cdca (diff) | |
| download | strongswan-ab635e029ec5a88d41aaa3dbf864d1ae6bd9a982.tar.bz2 strongswan-ab635e029ec5a88d41aaa3dbf864d1ae6bd9a982.tar.xz | |
updated SQL templates to support attribute pool and identity parameters
Diffstat (limited to 'src/libcharon/plugins/sql/mysql.sql')
| -rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql index f4a62a6f8..5a6dd10e9 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -187,11 +187,23 @@ CREATE TABLE leases ( PRIMARY KEY (`id`) ); +DROP TABLE IF EXISTS attribute_pools; +CREATE TABLE attribute_pools ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(32) NOT NULL, + PRIMARY KEY (`id`) +); + DROP TABLE IF EXISTS attributes; CREATE TABLE attributes ( `id` int(10) unsigned NOT NULL auto_increment, + `identity` int(10) unsigned NOT NULL default '0', + `pool` int(10) unsigned NOT NULL default '0', `type` int(10) unsigned NOT NULL, - `value` varbinary(16) NOT NULL + `value` varbinary(16) NOT NULL, + PRIMARY KEY (`id`), + INDEX (`identity`), + INDEX (`pool`) ); DROP TABLE IF EXISTS ike_sas; |