src/libcharon/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