-- 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: `mcf2.0`
--

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

--
-- Table structure for table `tbl_donation`
--

CREATE TABLE IF NOT EXISTS `tbl_donation` (
  `donation_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT NULL,
  `project_id` text NOT NULL,
  `amount_donation` text NOT NULL,
  `mosque_id` text NOT NULL,
  PRIMARY KEY (`donation_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_donation`
--

INSERT INTO `tbl_donation` (`donation_id`, `user_id`, `project_id`, `amount_donation`, `mosque_id`) VALUES
(1, 'amer', 'tandas', '300', ''),
(2, 'amer', 'tandas', '300', ''),
(3, 'amer', 'innovation', '300', ''),
(4, 'agia', 'tandas', '567890', ''),
(5, 'kj', 'innovation', '45678', ''),
(6, 'saleh', 'Membaikpulih', '33000', ''),
(7, 'amer', 'innovation', '4567', ''),
(8, 'x', 'Membaikpulih', '900', '');

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

--
-- Table structure for table `tbl_mosque`
--

CREATE TABLE IF NOT EXISTS `tbl_mosque` (
  `mosque_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mosque_name` text NOT NULL,
  `mosque_street1` text,
  `mosque_street2` text,
  `mosque_postcode` text,
  `mosque_city` text,
  `mosque_state` text,
  `mosque_pic` blob,
  `mosque_pic_type` text,
  `mosque_desc` text,
  `username` text,
  `password` text,
  `email` text,
  `phone` text,
  `rn` text,
  PRIMARY KEY (`mosque_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_mosque`
--

INSERT INTO `tbl_mosque` (`mosque_id`, `mosque_name`, `mosque_street1`, `mosque_street2`, `mosque_postcode`, `mosque_city`, `mosque_state`, `mosque_pic`, `mosque_pic_type`, `mosque_desc`, `username`, `password`, `email`, `phone`, `rn`) VALUES
(1, 'a', 'a', 'a', 'a', 'a', 'a', NULL, NULL, 'a', 'amer', 'a', 'a@A', 'a', 'a'),
(2, 'masjid machang', 'Jalan Pasir Puteh, 18500 Machang, Kelantan, Malaysia', 'Jalan Pasir Puteh, 18500 Machang, Kelantan, Malaysia', 'Machang', '18500', 'Kelantan', NULL, NULL, 'Masjid besar Machang', 'iqmal', 'iqmal', 'iqmalussaiq@gmail.com', '0148446387', 'MY-03-MCG-00004'),
(3, 'masjid pasir puteh', 'Jalan Tok Bali, 18502 Pasir Puteh, Kelantan, Malaysia', 'Jalan Tok Bali, 18502 Pasir Puteh, Kelantan, Malaysia', 'Pasir Puteh', '18502', 'Kelantan', NULL, NULL, 'Masjid besar Pasir Puteh', 'alif', 'alif', 'alif@1.com', '0123456879', 'MY-03-MCG-00003');

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

--
-- Table structure for table `tbl_project`
--

CREATE TABLE IF NOT EXISTS `tbl_project` (
  `project_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `project_name` text NOT NULL,
  `project_purpose` text NOT NULL,
  `target` text NOT NULL,
  `mosque_id` text NOT NULL,
  PRIMARY KEY (`project_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_project`
--

INSERT INTO `tbl_project` (`project_id`, `project_name`, `project_purpose`, `target`, `mosque_id`) VALUES
(1, 'innovation', 'give fund to renovate their facilities', 'rm3000', 'amer'),
(2, 'tandas', 'memudahkan jemaah', 'rm40000', 'amer'),
(3, 'Membaikpulih', 'Kebahagian jemaah', 'rm5000', 'alif');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_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=33 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `username`, `name`, `pwd`, `ic`, `add1`, `add2`, `postcode`, `state`, `city`, `email`, `phone`, `picture`, `status`) VALUES
(1, 'amer', 'amer hamzah', 'f5f45107403c20b3b3f33bc9631012b7', '950101035505', 'lot 123 jalan apa haa', 'lot 123 jalan apa haa', '18500', 'kelatan', 'machang', 'Amer@gmail.com', '0148443444', 'amermohd-ibrisam-b-jalaluddin-690104036667.jpg', 'USER'),
(2, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', '991010980076', 'lot 123 jalan apa', 'lot 123 jalan apa', '23444', 'aa', 'a', 'a@gmail.com', 'a', '', ''),
(3, 'hakim', 'hakim', '5e8e3302732abbc67998f8ccd0362dad', '959191359955', 'lot 555 jalan kokdan', 'lot 555 jalan kokdan', '1077799', 'kelantan', 'pasir mas', 'hakim@gmail.com', '0144455678', '', ''),
(4, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'adminamer.png', 'ADMIN'),
(5, 'iqmal', 'fahmi azmi', 'f11d50d63d3891a44c332e46d6d7d561', '950101035505', 'Jalan Pasir Puteh, 18500 Macha', 'Jalan Pasir Puteh, 18500 Macha', '18500', 'Kelantan', 'Machang', 'iqmalussaiq@gmail.com', '0148446387', '', ''),
(6, 'iqmal', 'fahmi azmi', 'f11d50d63d3891a44c332e46d6d7d561', '950101035505', 'Jalan Pasir Puteh, 18500 Macha', 'Jalan Pasir Puteh, 18500 Macha', '18500', 'Kelantan', 'Machang', 'iqmalussaiq@gmail.com', '0148446387', '', ''),
(7, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', 'USER'),
(8, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', ''),
(9, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', ''),
(10, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', ''),
(11, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', ''),
(12, 'a', 'a', '0cc175b9c0f1b6a831c399e269772661', 'a', 'a', 'a', 'a', 'a', 'a', 'a@A', 'a', '', ''),
(13, 'agia', 'agia', '8e1142119bb4405fd279bee4bbaa68b6', '960102034455', 'LOT 501 JALAN KO KIANG', 'LOT 501 JALAN KO KIANG', '18509', 'Terengganu', 'Kerteh', 'agia@1.com', '0123456788', 'agiaagia.PNG', 'USER'),
(14, 'saleh', 'saleh', '8690bca557c4a22fc13928aa31644a08', '960203034451', 'LOT 501 JALAN KO KE', 'LOT 501 JALAN KO KE', '18566', 'Kelantan', 'Tumpat', 'saleh@1.com', '0123223232', 'salehsaleh.png', 'USER'),
(15, 'rizqan', 'rizqan', '064d173e60cc8151160cf0370956ace3', '950203035590', 'LOT 501 JALAN KO EK', 'LOT 501 JALAN KO EK', '12500', 'Kelantan', 'Kuala Krai', 'rizqan@1.com', '0123344556', '', 'USER'),
(16, 'fahmi', 'fahmi', 'f11d50d63d3891a44c332e46d6d7d561', '940201034498', 'LOT 501 JALAN KO LI', 'LOT 501 JALAN KO LI', '23800', 'Kelantan', 'Machang', 'fahmi@1.com', '0132133213', '', 'USER'),
(17, 'zurah', 'zurah', 'dc8d9d3b364efcc99ecaa64a20f3795a', '950101034417', 'LOT 501 JALAN KO LAA', 'LOT 501 JALAN KO LAA', '95600', 'Sarawak', 'Danau', 'zurah@1.com', '0148900012', '', 'USER'),
(18, 'alia', 'alia', '86c8c6c90abd00c209e39736da1ec1fd', '970707034455', 'LOT 501 JALAN KO WENG', 'LOT 501 JALAN KO WENG', '76900', 'Sabah', 'Padang', 'alia@1.com', '0112342121', '', 'USER'),
(19, 'alif', 'alif', '099a147c0c6bcd34009896b2cc88633c', '950101035555', 'LOT 501 JALAN KO TIE', 'LOT 501 JALAN KO TIE', '99099', 'Melaka', 'Komtar', 'alif@1.com', '0133213213', 'alifalif.png', 'USER'),
(20, 'amerul', 'amerul', 'dfe259aac72fae9c3233574b54f93dc3', '951411034401', 'LOT 501 JALAN KO WEK', 'LOT 501 JALAN KO WEK', '18500', 'Kelantan', 'Machang', 'amerul@1.com', '0133456788', '', 'USER'),
(21, 'badd', 'badd', '0c9c92602241d5728b497fd5604598de', '990202034450', 'LOT 501 JALAN KO TAK', 'LOT 501 JALAN KO TAK', '12500', 'Sarawak', 'Danau', 'badd@1.com', '0124455667', '', 'USER'),
(22, 'edira', 'edira', 'f0bd534f134ebb46a57f3e3015b2eec5', '99203033303', 'LOT 501 JALAN KO LU', 'LOT 501 JALAN KO LU', '32909', 'Johor', 'Langau', 'edira@1.com', '0189909903', '', 'USER'),
(23, 'eppa', 'eppa', 'f46ead6eb452485880580caf573cfc46', '930303035503', 'LOT 501 JALAN KO WATPE', 'LOT 501 JALAN KO WATPE', '11200', 'Johor', 'Mersing', 'eppa@1.com', '0198765543', '', 'USER'),
(24, 'ira', 'ira', '3c67080a1a09b022fb9d94e57a75ddad', '951203034450', 'LOT 501 JALAN APA', 'LOT 501 JALAN APA', '23200', 'Johor', 'Kulai', 'ira@1.com', '012334451', '', 'USER'),
(25, 'kj', 'kj', '771f01104d905386a134a676167edccc', '950606023303', 'LOT 501 JALAN APO', 'LOT 501 JALAN APO', '90900', 'Sabah', 'Sandakan', 'kj@1.com', '0162344455', 'kjkj.png', 'USER'),
(26, 'mashi', 'mashi', 'e1e2f4baed93346ce3071d9f5d1eb867', '950120035509', 'LOT 501 JALAN APALA', 'LOT 501 JALAN APALA', '34900', 'Kedah', 'Kokdang', 'mashi@1.com', '0123432210', '', 'USER'),
(27, 'mell', 'mell', '92d74ff04daaaf9643d28a02fac90a74', '94030293449', 'LOT 501 JALAN APAKAH', 'LOT 501 JALAN APAKAH', '29909', 'Sabah', 'Mundie', 'mell@1.com', '0112344450', 'mellmell.png', 'USER'),
(28, 'nazif', 'nazif', 'b21d5a7970915d15ad054a14c182cd05', '950101020093', 'LOT 501 JALAN APATU', 'LOT 501 JALAN APATU', '98990', 'Melaka', 'Kweng', 'nazif@1.com', '0134405050', '', 'USER'),
(29, 'pikah', 'pikah', '944b3d45bddfe23c9760774ac6b6c88d', '940304020403', 'LOT 501 JALAN APAWEH', 'LOT 501 JALAN APAWEH', '850499', 'Perlis', 'Muinin', 'pikah@1.com', '0134343049', '', 'USER'),
(30, 'tessa', 'tessa', '81f2190577663a61c0a327e2753e6307', '900203045509', 'LOT 501 JALAN APALAH', 'LOT 501 JALAN APALAH', '28909', 'Sabah', 'Juwalu', 'tessa@1.com', '012300918', '', 'USER'),
(31, 'pikah', 'pikah', '944b3d45bddfe23c9760774ac6b6c88d', '93921919029', 'LOT 501 JALAN APA', 'LOT 501 JALAN APA', '8987875', 'kelantan', 'machang', 'pikah@1.com', '0123047575', '', ''),
(32, '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 */;
