-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2018 at 04:11 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `diet`
--

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

--
-- Table structure for table `center`
--

CREATE TABLE IF NOT EXISTS `center` (
  `center_id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `street_1` varchar(25) NOT NULL,
  `street_2` varchar(15) NOT NULL,
  `postcode` text NOT NULL,
  `city` varchar(11) NOT NULL,
  `state` text NOT NULL,
  `picture` text NOT NULL,
  `description` text NOT NULL,
  `username` text NOT NULL,
  `pwd` text NOT NULL,
  `email` varchar(25) NOT NULL,
  `registration_number` text NOT NULL,
  `phone_number` text NOT NULL,
  PRIMARY KEY (`center_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `center`
--

INSERT INTO `center` (`center_id`, `name`, `street_1`, `street_2`, `postcode`, `city`, `state`, `picture`, `description`, `username`, `pwd`, `email`, `registration_number`, `phone_number`) VALUES
(38, 'hccc', 'ccc', 'cc', 'rg', 'dfg', 'dft', 'hidayahIMG_0391.JPG', 'rff', 'hidayah', '1234', 'drfgg', 'fghh', 'ddfg'),
(39, '', '', '', '', '', '', '', '', '', '', '', '', ''),
(40, 'gchnvb', 'hgf', 'yrh', 'hrstgf', 'rtsdf', 'rsthdfg', 'hgfxIMG_0391.JPG', 'gfhx', 'hgfx', 'rhstgdf', 'thrwsgfd', 'thwrsg', 'htwrsg'),
(41, 'rget', '', '', '', '', '', '', '', '', '', '', '', ''),
(42, 'yh', 'y', 'y56', 'y56', '6y', 'y65', '6yIMG_0391.JPG', '5y', '6y', '6yt', 'y65t', 'y65t4', '645t'),
(43, 'm5y', 'h', 'h', 'h', 'h', 'h', 'hIMG_0388.JPG', 'h', 'h', '', 'h', 'h', 'h'),
(44, 'Dd', 'D', 'D', 'D', 'D', 'D', 'DIMG_0380.JPG', '', 'D', 'D', 'DD', 'DD', 'D');

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

--
-- Table structure for table `health_info`
--

CREATE TABLE IF NOT EXISTS `health_info` (
  `health_info_id` bigint(10) NOT NULL AUTO_INCREMENT,
  `uh` varchar(25) NOT NULL,
  `uw` varchar(25) NOT NULL,
  `user_id` text NOT NULL,
  `tarikh` date NOT NULL,
  PRIMARY KEY (`health_info_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `health_info`
--

INSERT INTO `health_info` (`health_info_id`, `uh`, `uw`, `user_id`, `tarikh`) VALUES
(1, '155', '68', 'x', '2018-12-14'),
(2, '155', '63', 'x', '2018-12-14'),
(3, '155', '70', 'x', '2018-12-14'),
(4, '155', '62', 'x', '2018-12-14');

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

--
-- Table structure for table `register`
--

CREATE TABLE IF NOT EXISTS `register` (
  `register_id` bigint(10) NOT NULL AUTO_INCREMENT,
  `date_register` varchar(15) NOT NULL,
  `user_id` bigint(10) NOT NULL,
  `center_id` bigint(10) NOT NULL,
  PRIMARY KEY (`register_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `trainer`
--

CREATE TABLE IF NOT EXISTS `trainer` (
  `trainer` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `contact_number` varchar(15) NOT NULL,
  `gender` text NOT NULL,
  `address` varchar(25) NOT NULL,
  `center_id` varchar(10) NOT NULL,
  `picture` text NOT NULL,
  `ic` text NOT NULL,
  PRIMARY KEY (`trainer`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `trainer`
--

INSERT INTO `trainer` (`trainer`, `name`, `contact_number`, `gender`, `address`, `center_id`, `picture`, `ic`) VALUES
(1, 'G', 'g', 'male', 'Gg', 'hidayah', 'hidayahIMG_0204.JPG', 'g');

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

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

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` bigint(15) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `name` text NOT NULL,
  `pwd` text NOT NULL,
  `ic` varchar(30) NOT NULL,
  `add1` varchar(30) NOT NULL,
  `add2` varchar(30) NOT NULL,
  `postcode` text NOT NULL,
  `state` varchar(25) NOT NULL,
  `city` varchar(25) NOT NULL,
  `email` varchar(25) NOT NULL,
  `phone` text NOT NULL,
  `picture` text NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

INSERT INTO `user` (`user_id`, `username`, `name`, `pwd`, `ic`, `add1`, `add2`, `postcode`, `state`, `city`, `email`, `phone`, `picture`, `status`) VALUES
(8, 'nor', 'nor hidayah bt ludin', '202cb962ac59075b964b07152d234b70', '961002035438', 'kg limbat bunut susu 17000', 'pasir mas, Kelantan', '17000', 'kelantan', 'pasir mas', 'norhidayah@yahoo.com', '01112954572', '', 'USER'),
(10, 'admin', 'admin', '0cc175b9c0f1b6a831c399e269772661', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'ADMIN'),
(11, 'hakim', 'ahmad hakim', '0cc175b9c0f1b6a831c399e269772661', '234567885434567', 'kg limbat', 'bunut susu,17000 pasir mas', '17000', 'kelantan', 'pasir mas', 'ahmad@gmail', '0145267543', '', 'USER'),
(12, 'x', 'x', '9dd4e461268c8034f5c8564e155c67a6', 'x', 'x', 'x', 'x', 'x', 'x', 'x@x', 'x', '', 'USER');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
