diff options
Diffstat (limited to 'src/libcharon/plugins/medcli/mysql.sql')
-rw-r--r-- | src/libcharon/plugins/medcli/mysql.sql | 32 |
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`) +); |