aboutsummaryrefslogtreecommitdiffstats
path: root/src/libcharon/plugins/sql/cred.sql
blob: 4b53e4e4b93f0045e30d48d2baa5cfc73c918900 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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,
);