bdfpkRSZ

1CREATE DATABASE IF NOT EXISTS `thiswebsitedb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2USE `thiswebsitedb`;
3
4-- --------------------------------------------------------
5
6--
7-- Table structure for table `users`
8--
9
10CREATE TABLE `users` (
11  `username` varchar(20) NOT NULL,
12  `password` varchar(20) NOT NULL,
13  `email` varchar(30) NOT NULL
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16--
17-- Dumping data for table `users`
18--
19
20INSERT INTO `users` (`username`, `password`, `email`) VALUES
21('ChristaH', 'password', 'mail@mail.com'),
22('jos223', 'MyPassword123', 'mail228@mail.com'),
23('RobKat', 'password', 'robkat@mail.com'),
24('user1', 'password', 'email@mail.com'),
25('winterH', 'PassWord', 'MAIL@mail.com'),
26('WinterMH', 'passWord', 'maiL@mail.com');
27
28--
29-- Indexes for dumped tables
30--
31
32--
33-- Indexes for table `users`
34--
35ALTER TABLE `users`
36  ADD UNIQUE KEY `username` (`username`);