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;
+