diff options
| author | Martin Willi <martin@strongswan.org> | 2008-03-14 15:06:42 +0000 |
|---|---|---|
| committer | Martin Willi <martin@strongswan.org> | 2008-03-14 15:06:42 +0000 |
| commit | 39ea88f694a782d82f1e2c803fee4a44a2aeff51 (patch) | |
| tree | 22e7a79bc32c3e97f793c663af6c4d8e3eb57af2 /src/charon/plugins/sql/sqlite.sql | |
| parent | 9c410a88064a4bdc76bff6f48906eadde8bb5cdf (diff) | |
| download | strongswan-39ea88f694a782d82f1e2c803fee4a44a2aeff51.tar.bz2 strongswan-39ea88f694a782d82f1e2c803fee4a44a2aeff51.tar.xz | |
credential lookup in mysql/sqlite database
Diffstat (limited to 'src/charon/plugins/sql/sqlite.sql')
| -rw-r--r-- | src/charon/plugins/sql/sqlite.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/src/charon/plugins/sql/sqlite.sql b/src/charon/plugins/sql/sqlite.sql index eeb1bb201..f004534be 100644 --- a/src/charon/plugins/sql/sqlite.sql +++ b/src/charon/plugins/sql/sqlite.sql @@ -73,3 +73,29 @@ CREATE TABLE traffic_selectors ( end_port INTEGER NOT NULL default '65535' ); +DROP TABLE IF EXISTS shared_secrets; +CREATE TABLE shared_secrets ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + type INTEGER NOT NULL, + local TEXT default NULL, + remote TEXT default NULL, + data BLOB NOT NULL +); + +DROP TABLE IF EXISTS certificates; +CREATE TABLE certificates ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + type INTEGER NOT NULL, + keytype INTEGER NOT NULL, + keyid BLOB NOT NULL, + subject TEXT default NULL, + data BLOB NOT NULL +); + +DROP TABLE IF EXISTS private_keys; +CREATE TABLE private_keys ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + type INTEGER NOT NULL, + keyid BLOB NOT NULL, + data BLOB NOT NULL +); |