src/charon/plugins/medsrv/mysql.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21


CREATE TABLE IF NOT EXISTS `peer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(10) unsigned NOT NULL,
  `alias` varchar(30) NOT NULL,
  `keyid` varbinary(20) NOT NULL,
  `public_key` blob,
  PRIMARY KEY  (`id`),
  UNIQUE KEY (`user`,`alias`),
  UNIQUE KEY (`keyid`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(30) NOT NULL,
  `password` varbinary(20) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;