diff options
Diffstat (limited to 'src/charon/plugins/sql')
-rw-r--r-- | src/charon/plugins/sql/mysql.sql | 6 | ||||
-rw-r--r-- | src/charon/plugins/sql/sqlite.sql | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/src/charon/plugins/sql/mysql.sql b/src/charon/plugins/sql/mysql.sql index 412abc715..1a01394b6 100644 --- a/src/charon/plugins/sql/mysql.sql +++ b/src/charon/plugins/sql/mysql.sql @@ -187,6 +187,12 @@ CREATE TABLE leases ( PRIMARY KEY (`id`) ); +DROP TABLE IF EXISTS attributes; +CREATE TABLE attributes ( + `id` int(10) unsigned NOT NULL auto_increment, + `type` int(10) unsigned NOT NULL, + `value` varbinary(16) NOT NULL +); DROP TABLE IF EXISTS ike_sas; CREATE TABLE ike_sas ( diff --git a/src/charon/plugins/sql/sqlite.sql b/src/charon/plugins/sql/sqlite.sql index f8bac1fcf..53d64dc34 100644 --- a/src/charon/plugins/sql/sqlite.sql +++ b/src/charon/plugins/sql/sqlite.sql @@ -192,6 +192,12 @@ CREATE TABLE leases ( released INTEGER NOT NULL ); +DROP TABLE IF EXISTS attributes; +CREATE TABLE attributes ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + type INTEGER NOT NULL, + value BLOB NOT NULL +); DROP TABLE IF EXISTS ike_sas; CREATE TABLE ike_sas ( |