-- https://www.phpmyadmin.net/
--
-- Palvelimen versio: 10.1.35-MariaDB

START TRANSACTION;



--
-- Database: `users`
--

-- --------------------------------------------------------

--
-- Rakenne taululle `users`
--

CREATE TABLE `users` (
  `userid` int(11) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Vedos taulusta `users`
--

INSERT INTO `users` (`userid`, `firstname`, `lastname`, `username`, `password`) VALUES
(1, 'Testi', 'Testaaja', 'testaaja', '$2y$10$BIBxLRPAVfPbu0nfn45.p.83Wx7VEqEtxyPR5dM97WBAtiqXRqTxe'),
(4, 'Mikki', 'Hiiri', 'mikki', '$2y$10$RWsITVVxbRd8DOppU7vKEO93kPTva3D1xt1ZI4Dr47qXeNLF9BmRi'),
(5, 'Minni', 'Hiiri', 'minni', '$2y$10$81Jhb6UA7imIvz34AC0ts.wA.fBItDtJvJUM//LyNY0kk14Nfut8W');

--
-- Indexes for dumped tables
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`userid`),
  ADD UNIQUE KEY `idx_username` (`username`),
  ADD UNIQUE KEY `username` (`username`) USING BTREE;

--
-- AUTO_INCREMENT for dumped table
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;


