userProviderMysql

Mysql User Provider

Example GoTuna UserProvider for Mysql

Create mysql table

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_UNIQUE` (`email`)
)

Insert sample records

INSERT INTO `users` (`email`, `name`, `phone`, `password_hash`) VALUES
('john@example.com', 'John', '555-0001', '$2a$10$M8YHTRKueW4DEV2/Wc4SF.DZ98NxP37eF5.XeEY1u3JWu8UWcqUNm');

INSERT INTO `users` (`email`, `name`, `phone`, `password_hash`) VALUES
('bob@example.com', 'Bob', '555-2555', '$2a$10$ibd7hES316n1XhuAWJuzv.7EfqZzcBAgtQ.k4loS6fL4EihEJMKxS');