1 files changed, 24 insertions, 0 deletions
diff --git a/src/libcharon/plugins/sql/cred.sql b/src/libcharon/plugins/sql/cred.sql
new file mode 100644
index 000000000..4b53e4e4b
--- /dev/null
+++ b/src/libcharon/plugins/sql/cred.sql
@@ -0,0 +1,24 @@
+
+DROP TABLE IF EXISTS shared_secrets;
+CREATE TABLE shared_secrets (
+	id INTEGER PRIMARY KEY AUTOINCREMENT,
+	type INTEGER,
+	local TEXT, 
+	remote TEXT
+);
+
+DROP TABLE IF EXISTS certificates;
+CREATE TABLE certificates (
+	id INTEGER PRIMARY KEY AUTOINCREMENT,
+	type INTEGER,
+	subject TEXT,
+	data BLOB,
+);
+
+DROP TABLE IF EXISTS private_keys;
+CREATE TABLE private_keys (
+	id INTEGER PRIMARY KEY AUTOINCREMENT,
+	type INTEGER,
+	keyid BLOB,
+	data BLOB,
+);