-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2018 at 04:12 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: `giftsystem`
--

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

--
-- Table structure for table `addons`
--

CREATE TABLE IF NOT EXISTS `addons` (
  `addchoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customization_id` bigint(20) NOT NULL,
  `addons_id` bigint(20) NOT NULL,
  PRIMARY KEY (`addchoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `addons_choice`
--

CREATE TABLE IF NOT EXISTS `addons_choice` (
  `addons_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `addons_pic` blob NOT NULL,
  `addons_price` int(11) NOT NULL,
  PRIMARY KEY (`addons_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `addons_choice`
--

INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(1, [encoded data, 54498 characters], 23);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(2, [encoded data, 23832 characters], 33);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(3, [encoded data, 131072 characters], 33);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(4, [encoded data, 22434 characters], 32);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(5, [encoded data, 38996 characters], 12);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(6, [encoded data, 131072 characters], 50);
INSERT INTO `addons_choice` (`addons_id`, `addons_pic`, `addons_price`) VALUES
(7, [encoded data, 38996 characters], 12);

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

--
-- Table structure for table `basket`
--

CREATE TABLE IF NOT EXISTS `basket` (
  `basket_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `basket_name` text NOT NULL,
  `basket_picture` blob NOT NULL,
  `basket_color` text NOT NULL,
  `basket_price` int(11) NOT NULL,
  PRIMARY KEY (`basket_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `basket`
--

INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(1, 'Basket A', [encoded data, 40414 characters], 'White', 5);
INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(2, 'Basket B', [encoded data, 86756 characters], 'Pink', 5);
INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(3, 'Basket C', [encoded data, 81022 characters], 'Brownish-Brown Wood', 5);
INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(4, 'Basket D', [encoded data, 29312 characters], 'Brownish', 5);
INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(5, 'Basket E', [encoded data, 131072 characters], 'Black and White', 5);
INSERT INTO `basket` (`basket_id`, `basket_name`, `basket_picture`, `basket_color`, `basket_price`) VALUES
(6, 'Basket F', [encoded data, 79066 characters], 'Light Brown', 5);

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `name` text NOT NULL,
  `picture` text NOT NULL,
  `username` text NOT NULL,
  `ic` text NOT NULL,
  `phone` varchar(11) NOT NULL,
  `email` text NOT NULL,
  `add1` text NOT NULL,
  `add2` text NOT NULL,
  `city` text NOT NULL,
  `postcode` int(6) NOT NULL,
  `state` text NOT NULL,
  `password` text NOT NULL,
  `dateregister` date NOT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `status` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`name`, `picture`, `username`, `ic`, `phone`, `email`, `add1`, `add2`, `city`, `postcode`, `state`, `password`, `dateregister`, `id`, `status`) VALUES
('', '', '', '0', '', '', '', '', '', 0, '', '', '0000-00-00', 36, ''),
('', '', '', '0', '', '', '', '', '', 0, '', '', '0000-00-00', 37, ''),
('', '', '', '0', '', '', '', '', '', 0, '', '', '0000-00-00', 38, ''),
('', '', '', '0', '', '', '', '', '', 0, '', '', '0000-00-00', 39, ''),
('admin', 'nophoto.png', 'admin', '1', '1', 'admin@admin', 'admin', 'admin', 'admin', 47000, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2018-12-11', 40, 'ADMIN'),
('', '', '', '', '', '', '', '', '', 0, '', '', '0000-00-00', 41, ''),
('MARLISA SAZIELA BINTI MANSOR', 'nophoto.png', 'MARLISA', '960711035372', '0199516947', 'lisaziela@gmail.com', 'NO 54 RKT KESEDAR SUNGAI ASAP B', '', 'GUA MUSANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 42, 'CUSTOMER'),
('NURUL NAZURAH BINTI WIRA', 'nophoto.png', 'NAZURAH', '960999024565', '0199768678', 'NAZURAHH@GMAIL', 'LOT 123', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 45, 'CUSTOMER'),
('WAN NABEELA BINIT ISHAK', 'nophoto.png', 'WAN', '96071103899', '0199272721', 'WAN@gmail.com', 'NO 16', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '65ded5353c5ee48d0b7d48c591b8f430', '2018-12-12', 46, 'CUSTOMER'),
('SYAFIQAH  ATHIRAH BINIT ZAMRI', 'nophoto.png', 'SYAFIQAH', '970102038976', '0199987756', 'TZ@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 47, 'CUSTOMER'),
('NORMASIDAYU BINTI ABU BAKAR', 'nophoto.png', 'NORMASHI', '970102039999', '0199727728', 'MASHI@GMAIL', 'NO 299', 'TAMAN PINK', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 48, 'CUSTOMER'),
('AMER AIMAN BIN RAZANI', 'nophoto.png', 'AMER', '970102036666', '0199272721', 'WAN@gmail.com', 'NO 16', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 49, 'CUSTOMER'),
('SY MUHAMMAD NAZIF BIN SY AHMAD', 'nophoto.png', 'NAZIF', '967865035374', '0199728882', 'NAZIF@gmail.com', 'Chiku 8', '', 'Gua Musang', 18300, 'Kelantan', '202cb962ac59075b964b07152d234b70', '2018-12-12', 50, 'CUSTOMER'),
('ABDUL SHAHRUL AZIM BIN SUDIN', 'nophoto.png', 'AZIM', '961230035928', '0176767899', 'AZIM@GMAIL', 'NO 27', 'TAMAN KUNING', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 51, 'CUSTOMER'),
('RIZQAN BIN SAARI', 'nophoto.png', 'RIZQAN', '960711038723', '0199787828', 'RIZ@GMAIL', 'LOT 22', 'JALAN KIKI', 'PASIR MAS', 17868, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 52, 'CUSTOMER'),
('SALEHHUDDIN', 'nophoto.png', 'SALEH', '970102036767', '0199987860', 'SALEH@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 53, 'CUSTOMER'),
('LUQMAN BIN RAZALI', 'nophoto.png', 'LUQRA', '970102035556', '0199787828', 'LUQ@GMAIL', 'LOT 22', 'JALAN KIKI', 'PASIR MAS', 17868, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-12', 54, 'CUSTOMER'),
('KHARI KJ', 'nophoto.png', 'KHAIRI', '960689925928', '+14524524', 'KJ@gmail.com', 'NO 12', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 55, 'CUSTOMER'),
('MUHAMMAD FAHMI', 'nophoto.png', 'FAHMI', '960101010103221', '0199728999', 'FAHMI@GMAIL', 'NO 299', 'TAMAN PINK', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 56, 'CUSTOMER'),
('BADRUL AMIN', 'nophoto.png', 'BAD', '960630036783', '0199876665', 'BAD@gmail.com', 'NO 54 RKT KESEDAR SUNGAI ASAP B', 'JALAN JALAN', 'GUA MUSANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 57, 'CUSTOMER'),
('HAKIM DZARAWI', 'nophoto.png', 'HAKIM', '960630088768', '0145432348', 'HAKIM@gmail.com', 'NO 12', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 58, 'CUSTOMER'),
('IQMAL USSAIQ', 'nophoto.png', 'IQMAL', '960630087458', '0176443099', 'IQMAL@GMAIL', 'NO 27', 'TAMAN KUNING', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 59, 'CUSTOMER'),
('MOHAMMAD ALIF FAISAL BIN SHAARI', 'nophoto.png', 'ALIFFAISAL', '960630035923', '0199555656', 'ALIFFAISAL@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 60, 'CUSTOMER'),
('ALIF ZHAFRI', 'nophoto.png', 'ALIFZ', '970102035473', '01998888', 'HOY@GMAIL', 'NO 299', 'TAMAN PINK', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 61, 'CUSTOMER'),
('RAJA MUHAMMAD ASYROFIL AMBIA', 'nophoto.png', 'RAJA ', '970102036762', '0179768766', 'RAJA@GMAIL', 'NO 1', 'TAMAN OREN', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 62, 'CUSTOMER'),
('EQWA IZZIF', 'nophoto.png', 'EQWA', '960630038953', '0179868765', 'EQWAI@GMAIL', 'NO 1', 'TAMAN OREN', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 63, 'CUSTOMER'),
('MUAZ AHMAD DZA', 'nophoto.png', 'MUAZ ', '96010101013', '0199999756', 'MUAZ@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 64, 'CUSTOMER'),
('NAMJOON', 'nophoto.png', 'NAMJOON', '940630035928', '0199727777', 'NAMJOON@GMAIL', 'NO 299', 'TAMAN PINK', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 65, 'CUSTOMER'),
('KIM TAEHYUNG', 'nophoto.png', 'TAEHYUNG', '950630035928', '0199726288', 'KIMTAE@gmail.com', 'NO 12', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 66, 'CUSTOMER'),
('H DONG HOOBIN CHE HUSIN', 'nophoto.png', 'HAHA', '96010101018', '0146789578', 'HAHA@GMAIL', 'NO 22', 'TAMAN HIJAU', 'MACHANG', 18500, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 67, 'CUSTOMER'),
('JUNJUNGKOOK', 'nophoto.png', 'JUNGKOOK', '96010101019', '0199787800', 'JUNGKOOK@GMAIL', 'LOT 22', 'JALAN KIKI', 'PASIR MAS', 17868, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 68, 'CUSTOMER'),
('MARWAN FIKRI', 'nophoto.png', 'MARWAN', '970102038989', '0199777756', 'MARWANL@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 69, 'CUSTOMER'),
('CHAN  YIM UN', 'nophoto.png', 'CHAN', '960633592834', '0199898971', 'CHAN@gmail.com', 'NO 16', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 70, 'CUSTOMER'),
('NORA YUSOF', 'nophoto.png', 'NORA', '970102035382', '0198889756', 'NORA@GMAIL', 'LOT 124', 'JALAN JALAN', 'MACHANG', 15670, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 71, 'CUSTOMER'),
('LUNA MAYA', 'nophoto.png', 'LUNA', '970102032321', '017978763', 'LUNA@GMAIL', 'NO 1', 'TAMAN OREN', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 72, 'CUSTOMER'),
('MARIANI BINTI MOHD NOOR', 'nophoto.png', 'MARIANI', '950120035509', '0196547721', 'ANI@gmail.com', 'NO 16', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 73, 'CUSTOMER'),
('SALMA HIDAYA', 'nophoto.png', 'SALMA', '970102035098', '0179766765', 'SALMA@GMAIL', 'NO 1', 'TAMAN OREN', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 74, 'CUSTOMER'),
('AFIQAH NURFARHANA BINTI ROSLAN', 'nophoto.png', 'AFIQAH', '9606300359284567', '0199929350', 'PIQA@gmail.com', 'NO 54 RKT KESEDAR SUNGAI ASAP B', '', 'GUA MUSANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 75, 'CUSTOMER'),
('MAIZATUL NORATISA', 'nophoto.png', 'TESS', '970109995372', '01678998765', 'TESS@GMAIL', 'NO 1', 'TAMAN OREN', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 76, 'CUSTOMER'),
('SYAHIRA ABD RASHID', 'nophoto.png', 'IRAH', '960634565928', '0199729782', 'IRA@gmail.com', 'Chiku 8', '', 'Gua Musang', 18300, 'Kelantan', '202cb962ac59075b964b07152d234b70', '2018-12-13', 77, 'CUSTOMER'),
('ROYHANAH', 'nophoto.png', 'ROYHANAH', '970103455372', '0199787928', 'ROY@GMAIL', 'LOT 22', 'JALAN KIKI', 'PASIR MAS', 17868, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 78, 'CUSTOMER'),
('MANSOR BIN MANAF', 'nophoto.png', 'MANSOR', '970102999972', '0199712728', 'MAN@GMAIL', 'Chiku 2', 'TAMAN OREN', 'Gua Musang', 18300, 'Kelantan', '202cb962ac59075b964b07152d234b70', '2018-12-13', 79, 'CUSTOMER'),
('MAHIRAH SYAMIMI ', 'nophoto.png', 'MAHIRAH', '970102076372', '0199454531', 'MIMI@gmail.com', 'NO 16', 'TAMAN MERAH', 'MACHANG', 18300, 'KELANTAN', '202cb962ac59075b964b07152d234b70', '2018-12-13', 80, 'CUSTOMER'),
('NUR HIDAYAH BINTI LUDIN', 'nophoto.png', 'MAIZATUL', '960630037865', '0108272728', 'ATUL@GMAIL', 'LOT 11', 'JALAN KEMANA', 'BATU GAJAH', 14560, 'PERAK', '202cb962ac59075b964b07152d234b70', '2018-12-13', 81, 'CUSTOMER'),
('MASMIRA SHAMIZA BINTI MANSOR', 'nophoto.png', 'MASMIRA', '970602035372', '0198696789', 'MAS@GMAIL', 'LOT 11', 'JALAN KEMBARA', 'BATU GAJAH', 14560, 'PERAK', '202cb962ac59075b964b07152d234b70', '2018-12-13', 82, 'CUSTOMER'),
('x', 'nophoto.png', 'x', 'x', 'x', 'x@x', 'x', 'x', 'x', 0, 'x', '9dd4e461268c8034f5c8564e155c67a6', '2018-12-14', 83, 'CUSTOMER');

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

--
-- Table structure for table `customize`
--

CREATE TABLE IF NOT EXISTS `customize` (
  `customization_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customize_specialnotes` text NOT NULL,
  `id` text NOT NULL,
  `payment_ccn` text NOT NULL,
  `payment_total` int(11) NOT NULL,
  `payment_cvv` text NOT NULL,
  `basket_id` bigint(20) NOT NULL,
  `receiver_name` text NOT NULL,
  `receiver_address` text NOT NULL,
  `receiver_hp` text NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`customization_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;

--
-- Dumping data for table `customize`
--

INSERT INTO `customize` (`customization_id`, `customize_specialnotes`, `id`, `payment_ccn`, `payment_total`, `payment_cvv`, `basket_id`, `receiver_name`, `receiver_address`, `receiver_hp`, `user_id`) VALUES
(32, 'HUHU', 'MARLISA', '123', 9, '456', 3, 'TENGKU ALIA EDIRA BINTI TN MD AZAHAN', 'NO 12, TAMAN MERAH', '019951678', 0),
(33, 'hai', 'MARLISA', '234', 9, '678', 1, 'MUHAMMAD BADRUL AMIN BIN CHE HUSIN', 'NO 22, TAMAN HIJAU', '0146789567', 0),
(34, 'APA KABAR', 'SYAFIQAH', '876', 9, '098', 1, 'MUHAMMAD SALEHUDDIN BIN ZAINAL MAZRI', 'LOT 11, JALAN KEMBARA', '0198696767', 0),
(35, 'HEY', 'NORMASHI', '', 9, '', 1, 'TENGKU ALIA EDIRA BINTI TN MD AZAHAN', 'NO 12, TAMAN MERAH', '0127896543', 0),
(36, 'HEY', 'NORMASHI', '999', 9, '456', 1, 'TENGKU ALIA EDIRA BINTI TN MD AZAHAN', 'NO 12, TAMAN MERAH', '0127896543', 0),
(37, 'HAI', 'AMER', '9', 8, '12', 1, 'MOHAMMAD ALIF FAISAL BIN SHAARI', 'LOT 124, JALAN JALAN', '0199987756', 0),
(38, 'HAI', 'NAZIF', '899', 9, '9877', 2, 'NORMASIDAYU BINTI ABU BAKAR', 'NO 299, TAMAN PINK', '0199727728', 0),
(39, 'whatsup', 'AZIM', '9', 9, '99', 1, 'SY MUHAMMAD NAZIF BIN SY AHMAD', 'Chiku 8', '0199728882', 0),
(40, 'HAIIIII', 'RIZQAN', '88', 9, '97', 1, 'NUR HIDAYAH BINTI LUDIN', 'LOT 11, JALAN KEMANA', '0108272728', 0),
(41, 'HIHI', 'SALEH', '2345', 9, '77', 1, 'NURUL NAZURAH BINTI WIRA', 'LOT 123, JALAN JALAN', '0199768678', 0),
(42, 'HAI', 'SALEH', '9', 9, '34', 1, 'AFIQAH NURFARHANA BINTI ROSLAN', 'NO 54 RKT KESEDAR SUNGAI ASAP B', '0199657654', 0),
(43, 'HIII', 'LUQRA', '9', 9, '876', 1, 'IZZAH', 'NO 299, TAMAN PINK', '0199727728', 0),
(44, 'HIII', 'LUQRA', '45', 9, '456', 4, 'HUSNA', 'NO 27, TAMAN KUNING', '0176767899', 0),
(45, 'HIHI', 'KHAIRI', '789', 9, '344', 1, 'SITI SAFIYAH', 'Chiku 8', '0199728882', 0),
(46, 'HEY', 'KHAIRI', '777', 9, '342', 1, 'ALIF DANIAL', 'LOT 124, JALAN JALAN', '0199987756', 0),
(47, 'SAYA NAK MAKAN NASI', 'FAHMI', '234', 9, '789', 1, 'SITI NOR ARIFAH HALIM', 'LOT 156, JALAN KEMANA', '0197727272', 0),
(48, 'APA KHABAR ORANG KAMPUNG', 'FAHMI', '777', 9, '098', 3, 'ZAINAL MAZRI', 'LOT 11, JALAN KEMBARA', '0198696767', 0),
(49, 'SAYA MAHU SESUATU', 'BAD', '234', 9, '654', 5, 'KHAIRI JAMALLUDDIN', 'NO 2, TAMAN BIRU', '0136783726', 0),
(50, 'ASSIGNMENT PHP', 'BAD', '00', 8, '6766', 2, 'AZIMSUDIN', 'NO 27, TAMAN KUNING', '0176767899', 0),
(51, 'HIT YOU WITH THAT DDU DDU', 'BAD', '6666', 9, '5555', 1, 'SARAH SUHAIRI', 'NO 2, TAMAN BIRU', '0136783726', 0),
(52, 'SEWA 230', 'HAKIM', '887', 9, '667', 2, 'PUAN ROYHANAH', 'Chiku 8', '0199728882', 0),
(53, 'HUI', 'HAKIM', '456', 9, '780', 4, 'LUDIN DANIAL', 'LOT 11, JALAN KEMANA', '0108272728', 0),
(54, 'HIU', 'HAKIM', '345', 9, '888', 3, 'NURL IRA', 'LOT 123, JALAN JALAN', '0199768678', 0),
(55, 'HAI I MISS YOU', 'IQMAL', '9909', 9, '9990', 1, 'SALSABILLA', 'LOT 11, JALAN KEMBARA', '0198692347', 0),
(56, 'NOTHING', 'IQMAL', '787', 9, '678', 5, 'CHE HUSIN ISMAIL', 'NO 22, TAMAN HIJAU', '0146789897', 0),
(57, 'HAI ORANG REMBAU', 'ALIFFAISAL', '787', 9, '567', 1, 'FARAH AZWIN', 'Chiku 8', '0199776582', 0),
(58, 'HI', 'ALIFFAISAL', '234', 9, '098', 1, 'NUR HIDAYAH BINTI LUDIN', 'LOT 11, JALAN KEMANA', '0108272728', 0),
(59, 'HAI YAYA', 'ALIFZ', '876', 9, '890', 1, 'HIDAYAH LUDIN', 'NO 27, TAMAN KUNING', '0176767899', 0),
(60, 'BILIK MEETING', 'ALIFZ', '', 9, '', 2, 'ALIA FARHANA BINTI YUSOF', 'NO 1, TAMAN OREN', '0179768765', 0),
(61, 'HUI', 'RAJA ', '123', 9, '456', 1, 'SITI RAIISUDDIN', 'LOT 11, JALAN KEMBARA', '0198696898', 0),
(62, 'HUI', 'RAJA ', '668', 9, '668', 1, 'NURUL NAZURAH BINTI WIRA', 'LOT 123, JALAN JALAN', '0199768678', 0),
(63, 'PHP', 'EQWA', '999', 9, '766', 1, 'MUHAMMAD HUSIN', 'NO 22, TAMAN HIJAU', '0146789897', 0),
(64, 'NOT TODAY', 'EQWA', '000', 9, '000', 3, 'SY MUHAMMAD AHMAD', 'Chiku 8', '0199728882', 0),
(65, 'SPRING DAY', 'EQWA', '098', 9, '98', 1, 'NORMASI', 'NO 299, TAMAN PINK', '0199727728', 0),
(66, 'PART 2', 'MUAZ ', '888', 9, '000', 1, 'SAARI', 'LOT 22, JALAN KIKI', '0199787827', 0),
(67, 'YA HOIII', 'MUAZ ', '899', 9, '566', 1, 'ALIA EDIRA ', 'NO 12, TAMAN MERAH', '0124432345', 0),
(68, 'HUI', 'NAMJOON', '8787', 9, '9888', 2, 'NUR HIDAYAH BINTI LUDIN', 'LOT 11, JALAN KEMANA', '0108272728', 0),
(69, 'BTS', 'TAEHYUNG', '234', 9, '234', 3, 'NURUL NAZURAH BINTI WIRA', 'LOT 123, JALAN JALAN', '0199768678', 0),
(70, 'HAPPY BIRTHDAY', 'TAEHYUNG', '123', 7, '678', 3, 'MONO', 'NO 27, TAMAN KUNING', '0176767899', 0),
(71, 'PHP', 'TAEHYUNG', '7654', 9, '889', 1, 'IRA', 'LOT 11, JALAN KEMBARA', '0198696767', 0),
(72, 'DISANA SINI', 'TAEHYUNG', '999', 9, '878', 4, 'SALINI', 'NO 22, TAMAN HIJAU', '0146789567', 0),
(73, 'K.', 'HAHA', '', 9, '', 1, 'WAN NABEELA BINIT ISHAK', 'NO 16, TAMAN MERAH', '0199272721', 0),
(74, 'TOLONGLAH', 'JUNGKOOK', '99', 9, '88', 1, 'MAS', 'NO 299, TAMAN PINK', '0199727728', 0),
(75, 'PASIR MASS', 'JUNGKOOK', '567', 9, '786', 1, 'FAISAL BIN SHAARI', 'LOT 124, JALAN JALAN', '0199987756', 0),
(76, 'HEYY', 'MARWAN', '233', 9, '788', 5, 'NURSYAHIRA BINTI ABD RASHID', 'LOT 123, JALAN JALAN', '0199768678', 0),
(77, 'HALOO', 'MARWAN', '456', 9, '123', 1, 'NUR KASIH BINTI LUDIN', 'LOT 11, JALAN KEMANA', '0107272728', 0),
(78, 'HEYY BUAT APA TU?', 'MARWAN', '7800', 9, '5678', 1, 'SAZLINA SALLEH', 'NO 27, TAMAN KUNING', '0176767899', 0),
(79, 'MYVI', 'CHAN', '1234', 9, '6789', 1, 'NAZIF BIN SY AHMAD', 'Chiku 8', '0199728803', 0),
(80, '13HB HAPPY BIRTHDAY', 'CHAN', '3456', 9, '6754', 1, 'MUHAMMAD FAHMI', 'NO 299, TAMAN PINK', '0199728999', 0),
(81, 'RUNNINGMAN ', 'CHAN', '5678', 9, '4567', 1, 'H DONG HOOBIN CHE HUSIN', 'NO 22, TAMAN HIJAU', '0146789578', 0),
(82, 'APA KHABAR ORANG KAMPUNG', 'CHAN', '00', 9, '098', 1, 'MUHAMMAD AMER AIMAN BIN MOHD RAZANI', 'LOT 22, JALAN KIKIKOKI', '0128787878', 0),
(83, 'DARI KERANA MATA', 'CHAN', '3467', 9, '3435', 3, 'KHARI KJ', 'NO 12, TAMAN MERAH', '0128787898', 0),
(84, 'MEMPUNYAI KUASA', 'NORA', '1234', 9, '7788', 1, 'ZAHIRAH', 'Chiku 2', '01992727223', 0),
(85, 'APAKAH ADA PADA NAMA', 'LUNA', '9000', 9, '5678', 1, 'NURFARHANA ', 'NO 54 RKT KESEDAR SUNGAI ASAP B', '0199227727', 0),
(86, 'HAII :)', 'MARIANI', '897', 9, '564', 2, 'MANSOR BIN MANAF', 'LOT 11, JALAN KEMBARA', '0198696765', 0),
(87, 'HAI :)))', 'MARIANI', '5546', 9, '987', 1, 'MASMIRA SHAMIZA BINTI MANSOR', 'NO 12, TAMAN MERAH', '01456545345', 0),
(88, 'HEYY', 'MARIANI', '00', 9, '456', 2, 'MAHIRAH SYAMIMI BINTI MANSOR', 'NO 22, TAMAN HIJAU', '0146786549', 0),
(89, 'sadadas', 'x', 'dfsdf', 7, 'sdfsdf', 4, 'Mohamad Rahimi Mohamad Rosman', 'LOT 1722, TAMAN ADABI, KG JIAS', '199891306', 0),
(90, 'x', 'x', 'fsfsdf', 32, 'sdfsdf', 1, 'Mohamad Rahimi Mohamad Rosman', 'LOT 1722, TAMAN ADABI, KG JIAS', '199891306', 0);

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

--
-- Table structure for table `flower`
--

CREATE TABLE IF NOT EXISTS `flower` (
  `flower_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `flower_name` text NOT NULL,
  `flower_img` blob NOT NULL,
  `flower_price` int(11) NOT NULL,
  PRIMARY KEY (`flower_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `flower`
--

INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(1, 'Baby Breath', [encoded data, 121176 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(2, 'Bleeding Heart', [encoded data, 38068 characters], 3);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(3, 'Dafodil', [encoded data, 79388 characters], 2);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(4, 'Dahlia', [encoded data, 131072 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(5, 'Daisy', [encoded data, 105628 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(6, 'Hydrangea', [encoded data, 131072 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(7, 'Sunflowers', [encoded data, 56336 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(8, 'Orkids', [encoded data, 131072 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(9, 'Peony', [encoded data, 68790 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(10, 'Rose', [encoded data, 57640 characters], 5);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(11, 'Sweet Pea', [encoded data, 131072 characters], 6);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(12, 'Tuberose', [encoded data, 108650 characters], 5);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(13, 'Tulips', [encoded data, 131072 characters], 4);
INSERT INTO `flower` (`flower_id`, `flower_name`, `flower_img`, `flower_price`) VALUES
(14, 'Bunga Matahari', [encoded data, 110798 characters], 6);

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

--
-- Table structure for table `flowerchoice`
--

CREATE TABLE IF NOT EXISTS `flowerchoice` (
  `flowerchoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customization_id` int(11) NOT NULL,
  `flower_id` int(11) NOT NULL,
  `shop_id` int(11) NOT NULL,
  PRIMARY KEY (`flowerchoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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