-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 13, 2018 at 05:40 AM
-- Server version: 5.7.14
-- PHP Version: 5.6.25

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 utf8mb4 */;

--
-- Database: `parking`
--

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

--
-- Table structure for table `level`
--

CREATE TABLE `level` (
  `level_id` int(20) NOT NULL,
  `level_name` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `parking`
--

CREATE TABLE `parking` (
  `park_id` bigint(20) NOT NULL,
  `date_in` date NOT NULL,
  `date_out` date NOT NULL,
  `time_in` text NOT NULL,
  `time_out` text NOT NULL,
  `amount` text,
  `ve_id` text NOT NULL,
  `slot_id` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parking`
--

INSERT INTO `parking` (`park_id`, `date_in`, `date_out`, `time_in`, `time_out`, `amount`, `ve_id`, `slot_id`) VALUES
(9, '2018-12-13', '2018-12-13', '8am', '9.30 am', NULL, 'DAS1212', 'Basement(01)'),
(10, '2018-12-12', '2018-12-12', '8am', '10am', NULL, 'AEW1505', 'Basement(02)'),
(11, '2018-12-11', '2018-12-11', '11am', '2pm', NULL, 'DCJ1149', 'Groundfloor(01)'),
(12, '2018-12-12', '2018-12-12', '9pm', '10pm', NULL, 'PKF9748', 'Level1(01)'),
(13, '2018-12-08', '2018-12-08', '1pm', '4pm', NULL, 'DC123', 'level1(02)'),
(14, '2018-12-10', '2018-12-10', '9am', '10am', NULL, 'DCC1294', 'Groundfloor(03)'),
(15, '2018-12-07', '2018-12-07', '9am', '11am', NULL, 'DCA1425', 'level1(03)'),
(16, '2018-12-05', '2018-12-05', '12pm', '6pm', NULL, 'AGV656', 'Groundfloor(04)'),
(17, '2018-12-12', '2018-12-12', '2pm', '3pm', NULL, 'ABZ123', 'Level1(06)'),
(18, '2018-12-11', '2018-12-11', '8am', '5pm', NULL, 'WA1', 'Level2(05)');

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

--
-- Table structure for table `slot`
--

CREATE TABLE `slot` (
  `slot_id` bigint(20) NOT NULL,
  `slot_name` text NOT NULL,
  `level_id` int(20) NOT NULL,
  `type_id` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `type`
--

CREATE TABLE `type` (
  `type_id` bigint(20) NOT NULL,
  `type_price` int(11) NOT NULL,
  `types_status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `user` (
  `us_id` bigint(20) NOT NULL,
  `us_name` text NOT NULL,
  `us_phone_number` varchar(16) NOT NULL,
  `us_address1` varchar(50) NOT NULL,
  `us_address2` varchar(50) NOT NULL,
  `us_postcode` text NOT NULL,
  `us_city` text NOT NULL,
  `us_state` text NOT NULL,
  `us_email` text NOT NULL,
  `us_password` text NOT NULL,
  `status` text NOT NULL,
  `picture` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `user` (`us_id`, `us_name`, `us_phone_number`, `us_address1`, `us_address2`, `us_postcode`, `us_city`, `us_state`, `us_email`, `us_password`, `status`, `picture`) VALUES
(1, 'Salehuddin', '0139587030', 'G 12, Jalan Melor', 'Taman Wangi', '18300', 'Gua Musang', 'Kelantan', 'zm.salehuddin@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'USER', 'salehuddinsalehuddin.jpg'),
(5, 'ADMIN', '11223344', 'Jalan 1', 'Kampung', '12111', 'Pantai Remis ', 'Perak', 'admin@gmail.com', '73acd9a5972130b75066c82595a1fae3', 'ADMIN', 'ADMINadmin_picture.png'),
(6, 'Ali', '01332423', 'Batu 52 1/4 Jalan Segari', 'Sungai Batu', '34900', 'Pantai Remis', 'Perak', 'ali@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', ''),
(7, 'Dollah', '0139780474', 'Pangkal Kala', 'Kampung Bahru', '17000', 'Pasir Mas', 'Kelantan', 'Dollah@gmail.com', '123', 'USER', ''),
(8, 'Abu', '012345678', 'kuartes felda', 'taman wangi', '18300', 'Gua Musang', 'Kelantan', 'zm.alias@gmail.com', '45c48cce2e2d7fbdea1afc51c7c6ad26', 'USER', 'qChrysanthemum.jpg'),
(9, 'Rizqan', '0111234567', 'Jalan Sentosa', 'Taman Aman', '18300', 'Gua Musang', 'Kelantan', 'rizqan@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'RizqanRizqan.jpg'),
(10, 'Azim', '011123245', 'Jalan Bahru', 'Taman Jaya', '34900', 'Pantai Remis', 'Perak', 'azim@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AzimAzim.jpg'),
(11, 'Nazif', '0111293846', 'Kampung Lemau,', 'Pasir Mas', '17000', 'Pasir Mas', 'Kelantan', 'nazif@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'Nazifsalehuddin.jpg'),
(13, 'Agia', '0111728919', 'Taman Damar', 'Kampung Desa', '18300', 'Gua Musang', 'Kelantan', 'zm.salehuddin@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AgiaAgia.png'),
(14, 'Hakim ', '0123414556', 'Taman Indah', 'Kampung Desa', '16390', 'Bachok', 'Kelantan', 'hakim@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'Hakim hakim.png'),
(15, 'Fahmi', '0199283475', 'Kampung Rahmat', 'Taman Indah', '34900', 'Pantai Remis', 'Perak', 'Fahmi@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'FahmiFahmi.png'),
(16, 'Nazurah', '0130924299', 'G 4, Jalan Melor', 'Taman Kesedar', '18300', 'Gua Musang ', 'Kelantan', 'zurah@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'NazurahNazurah.png'),
(17, 'Mashidayu', '0122443453', 'Kampung Damai', 'Jalan Changloon', '06100', 'Kodiang', 'Kedah', 'mashidayu@gmailc.om', '202cb962ac59075b964b07152d234b70', 'USER', 'MashidayuMashidayu.png'),
(18, 'Alif', '0129483753', 'Kampung Indah', 'Jalan Indah', '08400', 'Merbok', 'Kedah', 'alif@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AlifAlif.png'),
(19, 'Zhafri', '0183035934', 'Jalan Telipot', 'Taman Teratai', '01007', 'Kangar', 'Perlis', 'zhafri@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'ZhafriZhafri.png'),
(20, 'Hidayah', '0134230985', 'Jalan Lama', 'Kampung Tepus', '02100', 'Padang Besar', 'Perlis', 'hidayah@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'HidayahHidayah.png'),
(21, 'Arifah', '0192845395', 'Jalan Sama', 'Kampung Indah', '34700', 'Pengkalan Bharu', 'Perak', 'arifah@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'ArifahArifah.png'),
(22, 'Luqman', '0134289343', 'Lot 172 Jalan Segari', 'Taman Dahlia', '16100', 'Pengkalan Chepa', 'Kota Bharu', 'luqman@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'LuqmanLuqman.jpg'),
(23, 'Ikmal', '0172482332', 'Jalan Machang', 'Kampung Belukar', '18500', 'Machang', 'Kelantan', 'ikmal@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'IkmalIkmal.png'),
(24, 'Edira', '0134324234', 'Jalan Bazar', 'Buluh Kubu', '15000', 'Kota Bharu', 'Kelantan', 'edira@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'EdiraEdira.png'),
(25, 'Amer', '0144934232', 'Jalan Lama', 'Taman Kenanga', '1500', 'Kota Bharu', 'Kelantan', 'amer@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AmerSalehuddin.jpg'),
(26, 'Amran', '0194564565', 'Jalan Bayam', 'Taman Merpati', '89050 ', 'Kudat', 'Sabah', 'amran@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AmranAmran.jpg'),
(27, 'Rafiq', '0182445345', 'Rumah Panjang', 'Kampung Hutan', '89150', 'Kota Belud', 'Sabah', 'rafiq@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'RafiqRafiq.jpg'),
(28, 'Khairul', '0144354645', 'Jalan Desaru', 'Kampung Permai', '06600', 'Kuala Kedah', 'Kedah', 'khairul@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'KhairulKhairul.jpg'),
(29, 'Malik', '0194353456', 'Jalan Lama', 'Taman Wangi', '02000', 'Kuala Perlis', 'Perlis', 'malik@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'MalikMalik.JPG'),
(30, 'Muaz', '0194325435', 'Jalan Pasir', 'Kampung Debus', '89800', 'Beaufort', 'Sabah', 'muaz@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'MuazMuaz.jpg'),
(31, 'Hasnah', '0193354354', 'Lot 32 Jalan Lurus', 'Kampung Matang', '91300', 'Semporna', 'Sabah', 'hasnah@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'HasnahHasnah.jpg'),
(32, 'Mira', '0193543543', 'Jalan Segar', 'Taman Rashidah', '34500', 'Pengkalan Bharu', 'Perak', 'mira@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'MiraMira.jpg'),
(33, 'Afiqa', '0194534634', 'Lot 3 Jalan Hampas', 'Kampung Rambutan', '06000', 'Jitra', 'Kedah', 'afiqa@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AfiqaAfiqa.png'),
(34, 'Syahira', '0183435363', 'Lot 34 Jalan Hijau', 'Kampung Baru', '06150', 'Ayer Hitam', 'Kedah', 'syahira@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'SyahiraSyahira.png'),
(35, 'Adam', '0134254355', 'Jalan Parit', 'Kampung Permai', '34900', 'Pantai Remis', 'Perak', 'adam@gmail.com', '202cb962ac59075b964b07152d234b70', 'USER', 'AdamAdam.jpg');

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

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `ve_id` bigint(20) NOT NULL,
  `ve_plate_number` text NOT NULL,
  `ve_model` text NOT NULL,
  `ve_color` text NOT NULL,
  `us_id` text NOT NULL,
  `ve_pic` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` (`ve_id`, `ve_plate_number`, `ve_model`, `ve_color`, `us_id`, `ve_pic`) VALUES
(18, 'DAS1212', 'Honda-Civic Type R', 'Green', 'Rizqan', 'Rizqana6.jpg'),
(16, 'AEW1505', 'Mitsubishi- Evo ', 'Red', 'Salehuddin', 'Salehuddina5.jpg'),
(20, 'DCJ1149', 'Perodua-Myvi-SE', 'Grey', 'Nazif', 'Nazifmyvi_grey.jpg'),
(21, 'Azx123', 'Proton - Iriz', 'Red', 'ADMIN', 'ADMINiriz_red.jpg'),
(22, 'PKF9748', 'Perodua - Alza', 'Grey', 'Agia', 'Agiaalza_grey.JPG'),
(23, 'DC123', 'Toyota - Alphard', 'Black', 'Hakim ', 'Hakim alphad_black.PNG'),
(24, 'DCC1294', 'Proton - Preve', 'Gold', 'Fahmi', 'Fahmipreve_gold.jpg'),
(25, 'DCA1425', 'Perodua - Kancil', 'Green', 'Nazurah', 'Nazurahkancil_green.jpg'),
(26, 'AGV656', 'Proton - Exora', 'Black', 'Alif', 'Alifexora_black.jpg'),
(27, 'ABZ123', 'Toyota - Hilux', 'Black', 'Mashidayu', 'Mashidayuhilux_black.jpg'),
(28, 'WA1', 'Proton - Perdana', 'Black', 'Hidayah', 'Hidayahperdana_black.jpg'),
(29, 'DCB3344', 'Proton - Satria', 'Yellow', 'Zhafri', 'Zhafrisatria_kuning.jpg'),
(30, 'BPE5223', 'Proton - Iriz', 'Red', 'Arifah', 'Arifahiriz_red.jpg'),
(31, 'DCN920', 'Honda - Jazz', 'Blue', 'Luqman', 'Luqmanjazz_blue.PNG'),
(32, 'WA6728', 'Perodua - Axia', 'Red', 'Ikmal', 'Ikmalaxia_red.jpg'),
(33, 'WHM5550', 'Proton - Waja', 'Grey', 'Amer', 'AmerWaja_grey1.jpg'),
(34, 'WW12', 'Proton - Wira', 'Gold', 'Amran', 'AmranWira_gold.jpg'),
(35, 'JGR5466', 'Perodua - Kelisa', 'Red', 'Rafiq', 'RafiqKelisa_Merah.jpg'),
(36, 'BGM6824', 'Perodua - Kenari', 'Blue', 'Khairul', 'Khairulkenari_blue.jpg'),
(37, 'AE432', 'Honda - Ferrio', 'Yellow', 'Malik', 'Malikhondaek_yellow.jpg'),
(38, 'WD1258', 'Honda - Civic', 'White', 'Muaz', 'Muazbhondanew_white.jpg'),
(39, 'WW134', 'Honda - Fd', 'Blue', 'Hasnah', 'Hasnahhonda_blue.jpg'),
(40, 'AKB8318', 'Honda - City', 'White', 'Mira', 'Mirahonda_city.jpg'),
(41, 'AKM131', 'Honda - City', 'Grey', 'Afiqa', 'Afiqahondacity_grey.jpg'),
(43, 'AQ123', 'Proton - Satria', 'Grey', 'Adam', 'AdamSatria_greygti.jpg'),
(46, 'BA123', 'Mitsubishi - Evolution 7', 'Red', 'Azim', 'Azimevo_7red.jpg');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `level`
--
ALTER TABLE `level`
  ADD PRIMARY KEY (`level_id`);

--
-- Indexes for table `parking`
--
ALTER TABLE `parking`
  ADD PRIMARY KEY (`park_id`);

--
-- Indexes for table `slot`
--
ALTER TABLE `slot`
  ADD PRIMARY KEY (`slot_id`);

--
-- Indexes for table `type`
--
ALTER TABLE `type`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`us_id`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`ve_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `level`
--
ALTER TABLE `level`
  MODIFY `level_id` int(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `parking`
--
ALTER TABLE `parking`
  MODIFY `park_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `slot`
--
ALTER TABLE `slot`
  MODIFY `slot_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `type`
--
ALTER TABLE `type`
  MODIFY `type_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `us_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `ve_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
/*!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 */;
