1
2
3
4
5
6
7
8
9

CREATE TABLE `fileSharingUsers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `login` varchar(255) CHARACTER SET utf8 NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `userId` (`userId`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `fileSharingUsers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userId` int(11) NOT NULL, `login` varchar(255) CHARACTER SET utf8 NOT NULL, `password` varchar(255) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `userId` (`userId`), UNIQUE KEY `login` (`login`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1