--
-- Database: `kdevuhni_footstatsdb`
--

CREATE DATABASE IF NOT EXISTS `kdevuhni_footstatsdb`;
USE `kdevuhni_footstatsdb`;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `kt_user`(
  `u_id` int(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `u_namesurname` varchar(45) NOT NULL,
  `u_role` varchar(20) NOT NULL,
  `u_location` varchar(30) NOT NULL,
  `u_email` varchar(70) NOT NULL,
  `u_password` varchar(96) NOT NULL,
  `u_activation_code` varchar(250) NOT NULL,
  `u_email_status` enum('0','1') NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `kt_user` (`u_id`,`u_namesurname`, `u_role`, `u_location`, `u_email`, `u_password`, `u_activation_code`, `u_email_status`) VALUES
(1, 'John Smith', 'coach', 'Santarem', 'web-tutorial@programmer.net', '$2y$10$vdMwAmoRJfep8Vl4BI0QDOXArOCTOMbFs6Ja15qq3NEkPUBBtffD2', 'c74c4bf0dad9cbae3d80faa054b7d8ca', '0');

--
-- Indexes for dumped tables
--
