-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `dauld_class`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `pw` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `priv` int(1) NOT NULL DEFAULT '0',
  `active` varchar(1) NOT NULL DEFAULT 'n',
  `avatar` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `email`, `pw`, `fname`, `sname`, `priv`, `active`, `avatar`) VALUES
(1, 'fredbfhdfhdfh', '663b8d72dc84c87f87dabd1302c57da7035ba27f', 'Fred', 'Bloggs', 3, 'y', ''),
(2, 'dauld', '663b8d72dc84c87f87dabd1302c57da7035ba27f', 'David', 'Auld', 3, 'y', ''),
(3, 'test@test.com', '55c3b5386c486feb662a0785f340938f518d547f', 'Test', 'Tester', 1, 'y', ''),
(4, 'mike', '63982e54a7aeb0d89910475ba6dbd3ca6dd4e5a1', 'mike', 'Smiff', 1, 'y', ''),
(5, 'mm', '4028a0e356acc947fcd2bfbf00cef11e128d484a', 'test', 'test', 2, 'y', ''),
(6, 'a', '6f9b0a55df8ac28564cb9f63a10be8af6ab3f7c2', 'a', 'a', 1, 'y', ''),
(7, 'Gene.Simmons@genes.com', 'ff232d7a7cf4235c667fbcdd5798aa7c56535963', 'Gene', 'Simmons', 1, 'y', ''),
(8, 'Michael.Jordan@nba.com', 'bac55382cdfd2db38eba4332483623121c155dc5', 'Michael', 'Jordan', 1, 'y', ''),
(9, 'Fred.Nerk@fred.com', '8a472bb4018913e0badffe4b0e4594795e4f2764', 'Fred', 'Nerk', 2, 'y', ''),
(10, 'brad', '4028a0e356acc947fcd2bfbf00cef11e128d484a', 'Brad', 'Brown', 2, 'y', ''),
(11, 'test', '56f5950b728849d0b97c1bccf1691c090ab6734c', 'John', 'Doe', 1, 'y', ''),
(12, 'Joe.Bloggs@cdu.au', '6a1910ff509708b4198d8a16632a127213a30e72', 'Joe', 'Bloggs', 1, 'y', ''),
(13, 'megan.louse@test.com', '479578d84f5facb5a875ecf245aae41ea2de38d8', 'Megan', 'Louise', 1, 'y', ''),
(14, 'lol', '721c0d4e5013c9fb054b3288adf6b82ad96fccf9', 'tester', 'tester', 1, 'y', ''),
(15, '2@2.com', 'df2cd7104536553afde9f7d66133d578eccb4606', '2', '2', 1, 'y', ''),
(29, 'dave', '754c8c114cfda31b6d2190cfd363d5bf', 'david', 'auld', 3, 'y', ''),
(17, 'fred', '663b8d72dc84c87f87dabd1302c57da7035ba27f', 'fred1', 'fred1', 2, 'y', ''),
(18, 'fred@fred.com', '663b8d72dc84c87f87dabd1302c57da7035ba27f', 'fred@fred.com', 'Bloggs', 2, 'y', ''),
(19, '1@1.com', 'cb711f6c34b4568a3b356d03aa677ec0fc904e19', 'Jane', 'Bloggs', 1, 'y', ''),
(20, 'brad@hotmail.com', '5b2e050bbec5ed7d6223039f19d86df3b90419b1', 'brad', 'brown', 2, 'y', ''),
(21, 'z@z.com', '1b0b84482bda7a65ec918141f1cc1aa804d6d01d', 'z', 'z', 1, 'y', ''),
(22, 'g', '48e1a46fea43b7d6e21fcd2ac996415053dbb3b2', 'g', 'g', 1, 'y', ''),
(23, 'ddds', '6af77af68f4dfd2bad990772bd3e5e6534feb5fa', 'dssd', 'sddsds', 1, 'y', ''),
(24, 'blah', '05dc54328edc1e335436ea8cc059a52c19d3cf96', 'test', 'blah', 1, 'y', ''),
(25, 'bradb', 'bf9f464311af70de6109a5694d40a678e356a102', 'gangster g bradb', 'bradb', 1, 'y', ''),
(26, 'Louise.drill@tester.com', 'f8e11177a7e34f34595ba2088bf2d0dce3b745fd', 'Louise', 'Mcmill', 1, 'y', ''),
(27, '1@1.com.au', '3cb657eb357e1a0eba46e9d00745c11d090fbd01', 'ew', 'efrf', 2, 'y', ''),
(28, 'peter@peters.com.au', '63982e54a7aeb0d89910475ba6dbd3ca6dd4e5a1', 'Peter', 'Peters', 2, 'y', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
COMMIT;

