diff options
Diffstat (limited to 'src/charon/plugins/med_db/mysql.sql')
| -rw-r--r-- | src/charon/plugins/med_db/mysql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/src/charon/plugins/med_db/mysql.sql b/src/charon/plugins/med_db/mysql.sql new file mode 100644 index 000000000..0fb60dbc6 --- /dev/null +++ b/src/charon/plugins/med_db/mysql.sql @@ -0,0 +1,12 @@ + +CREATE TABLE IF NOT EXISTS `Peer` ( + `IdPeer` int(10) unsigned NOT NULL auto_increment, + `IdUser` int(10) unsigned NOT NULL, + `Alias` varchar(30) collate utf8_unicode_ci NOT NULL, + `KeyId` varbinary(20) NOT NULL, + `PublicKey` blob NOT NULL, + PRIMARY KEY (`IdPeer`), + KEY `KeyId` (`KeyId`), + KEY `IdUser` (`IdUser`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + |