Removed strayed code fragment
[strongswan.git] / src / charon / plugins / medsrv / mysql.sql
1
2 CREATE TABLE IF NOT EXISTS `peer` (
3 `id` int(10) unsigned NOT NULL auto_increment,
4 `user` int(10) unsigned NOT NULL,
5 `alias` varchar(30) NOT NULL,
6 `keyid` varbinary(20) NOT NULL,
7 `public_key` blob,
8 PRIMARY KEY (`id`),
9 UNIQUE KEY (`user`,`alias`),
10 UNIQUE KEY (`keyid`),
11 KEY (`user`)
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
13
14 CREATE TABLE IF NOT EXISTS `user` (
15 `id` int(10) unsigned NOT NULL auto_increment,
16 `login` varchar(30) NOT NULL,
17 `password` varbinary(20) NOT NULL,
18 PRIMARY KEY (`id`),
19 UNIQUE KEY (`login`)
20 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
21