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`)
+);