· 9 years ago · Nov 24, 2016, 09:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 24, 2016 at 10:44 AM
7-- Server version: 5.6.13
8-- PHP Version: 5.4.17
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `dockc`
15--
16CREATE DATABASE IF NOT EXISTS `dockc` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
17USE `dockc`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `user`
23--
24
25CREATE TABLE IF NOT EXISTS `user` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `username` varchar(20) NOT NULL,
28 `password` varchar(160) NOT NULL,
29 `salt` varchar(30) NOT NULL,
30 `role` tinyint(4) NOT NULL,
31 `lastlogin` datetime DEFAULT NULL,
32 `disable` datetime DEFAULT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
35
36--
37-- Dumping data for table `user`
38--
39
40INSERT INTO `user` (`id`, `username`, `password`, `salt`, `role`, `lastlogin`, `disable`) VALUES
41(1, 'admin', 'e274cecc887663264fee56db93fbc82a76128ef3', 'QxLUF1bgIAdeQX', 1, '2016-11-20 12:45:41', NULL),
42(2, 'peter', 'ef4c9e982661148ef9c398ab562f06f7d208e0f7', '$6Rjdafdj8(Ud', 2, '2016-11-22 22:17:13', NULL),
43(3, 'bart', '98e2d806ec19512339cc74f12cd771dc5a4a55fd', 'R%u&R56e$%&pmNU4', 3, '2016-11-22 22:44:55', NULL),
44(4, 'vincent', '0a85346dcb42ecc9b2f28cbd53e4a6ccf58410f7', 'CsZC2kzdSMr4', 2, '2016-11-22 22:45:39', NULL),
45(5, 'marvin', 'b5b01e8770b19c6e0bed8678e0d31771803d9b44', 'TrF5rmXUBH4N', 2, '2016-11-20 15:45:00', NULL),
46(6, 'richard', '76d10ad91945f87e84dbd0c3878978b125b6bd25', 'FwyprUzJd6TM', 3, '2016-11-22 22:16:44', NULL),
47(7, 'jan', 'edde193785af325f4f76111909f93b7ec10c6d64', '48abab7627e', 1, '2016-11-22 22:39:36', NULL);