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,
9
UNIQUE KEY (`user`,`alias`),
12
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
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,
20
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;