aboutsummaryrefslogtreecommitdiffstats
path: root/src/charon/plugins/medsrv/mysql.sql
blob: 0fb60dbc6cf7d26b2d55089c7619ceb20ba2de1b (plain)
1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE IF NOT EXISTS `Peer` (
  `IdPeer` int(10) unsigned NOT NULL auto_increment,
  `IdUser` int(10) unsigned NOT NULL,
  `Alias` varchar(30) collate utf8_unicode_ci NOT NULL,
  `KeyId` varbinary(20) NOT NULL,
  `PublicKey` blob NOT NULL,
  PRIMARY KEY  (`IdPeer`),
  KEY `KeyId` (`KeyId`),
  KEY `IdUser` (`IdUser`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;