diff options
| author | Tobias Brunner <tobias@strongswan.org> | 2010-03-12 16:45:46 +0100 |
|---|---|---|
| committer | Tobias Brunner <tobias@strongswan.org> | 2010-03-19 13:34:52 +0100 |
| commit | 08c5572602404675f5cba93d8bbaa8a6925c1b95 (patch) | |
| tree | 0819425652f758e072e6f432a2d655d995879383 /src/libcharon/plugins/medsrv/mysql.sql | |
| parent | 7c11d10eb8f16dd4ffa31dd7e61141cc80c56596 (diff) | |
| download | strongswan-08c5572602404675f5cba93d8bbaa8a6925c1b95.tar.bz2 strongswan-08c5572602404675f5cba93d8bbaa8a6925c1b95.tar.xz | |
Moving charon to libcharon.
Diffstat (limited to 'src/libcharon/plugins/medsrv/mysql.sql')
| -rw-r--r-- | src/libcharon/plugins/medsrv/mysql.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/src/libcharon/plugins/medsrv/mysql.sql b/src/libcharon/plugins/medsrv/mysql.sql new file mode 100644 index 000000000..eb9f57772 --- /dev/null +++ b/src/libcharon/plugins/medsrv/mysql.sql @@ -0,0 +1,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`) +) 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; + |