Removed strayed code fragment
[strongswan.git] / src / charon / plugins / medcli / mysql.sql
1
2 CREATE TABLE `ClientConfig` (
3 `IdClientConfig` int(11) NOT NULL,
4 `KeyId` varbinary(20) NOT NULL,
5 `PublicKey` blob NOT NULL,
6 `PrivateKey` blob NOT NULL,
7 PRIMARY KEY (`IdClientConfig`)
8 );
9
10
11 CREATE TABLE `MediationServerConfig` (
12 `IdMediationServerConfig` int(11) NOT NULL,
13 `Address` varchar(200) NOT NULL,
14 `KeyId` varbinary(20) NOT NULL,
15 `PublicKey` blob NOT NULL,
16 PRIMARY KEY (`IdMediationServerConfig`)
17 );
18
19
20 CREATE TABLE `Connection` (
21 `IdConnection` int(11) NOT NULL auto_increment,
22 `Active` tinyint(1) NOT NULL,
23 `Alias` varchar(50) NOT NULL,
24 `KeyId` varbinary(20) NOT NULL,
25 `PublicKey` blob NOT NULL,
26 `LocalSubnet` varchar(20),
27 `RemoteSubnet` varchar(20),
28 `Status` int(11) NOT NULL,
29 PRIMARY KEY (`IdConnection`),
30 UNIQUE (`Alias`),
31 UNIQUE (`KeyId`)
32 );