aboutsummaryrefslogtreecommitdiffstats
path: root/src/libcharon/plugins/medcli/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/libcharon/plugins/medcli/mysql.sql')
-rw-r--r--src/libcharon/plugins/medcli/mysql.sql32
1 files changed, 32 insertions, 0 deletions
diff --git a/src/libcharon/plugins/medcli/mysql.sql b/src/libcharon/plugins/medcli/mysql.sql
new file mode 100644
index 000000000..0107ad35a
--- /dev/null
+++ b/src/libcharon/plugins/medcli/mysql.sql
@@ -0,0 +1,32 @@
+
+CREATE TABLE `ClientConfig` (
+ `IdClientConfig` int(11) NOT NULL,
+ `KeyId` varbinary(20) NOT NULL,
+ `PublicKey` blob NOT NULL,
+ `PrivateKey` blob NOT NULL,
+ PRIMARY KEY (`IdClientConfig`)
+);
+
+
+CREATE TABLE `MediationServerConfig` (
+ `IdMediationServerConfig` int(11) NOT NULL,
+ `Address` varchar(200) NOT NULL,
+ `KeyId` varbinary(20) NOT NULL,
+ `PublicKey` blob NOT NULL,
+ PRIMARY KEY (`IdMediationServerConfig`)
+);
+
+
+CREATE TABLE `Connection` (
+ `IdConnection` int(11) NOT NULL auto_increment,
+ `Active` tinyint(1) NOT NULL,
+ `Alias` varchar(50) NOT NULL,
+ `KeyId` varbinary(20) NOT NULL,
+ `PublicKey` blob NOT NULL,
+ `LocalSubnet` varchar(20),
+ `RemoteSubnet` varchar(20),
+ `Status` int(11) NOT NULL,
+ PRIMARY KEY (`IdConnection`),
+ UNIQUE (`Alias`),
+ UNIQUE (`KeyId`)
+);