1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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`)
);
|
