vxi55jYh

1-- phpMyAdmin SQL Dump
2-- version 4.5.3.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 26, 2016 at 01:06 PM
7-- Server version: 5.6.28
8-- PHP Version: 5.6.27
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `nuamo`
15--
16CREATE DATABASE IF NOT EXISTS `nuamo` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
17USE `nuamo`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `claims`
23--
24
25DROP TABLE IF EXISTS `claims`;
26CREATE TABLE `claims` (
27  `id` int(11) NOT NULL,
28  `nric` int(12) DEFAULT NULL,
29  `branch` varchar(255) DEFAULT NULL,
30  `bank_account` varchar(255) DEFAULT NULL,
31  `num_account` varchar(255) DEFAULT NULL,
32  `created` datetime NOT NULL,
33  `modified` datetime NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36-- --------------------------------------------------------
37
38--
39-- Table structure for table `funds`
40--
41
42DROP TABLE IF EXISTS `funds`;
43CREATE TABLE `funds` (
44  `id` int(11) NOT NULL,
45  `rank` int(11) NOT NULL DEFAULT '1' COMMENT 'Kedudukan Susunan Jenis Tuntutan',
46  `name` varchar(255) DEFAULT NULL COMMENT 'Jenis tuntutan ',
47  `amount` float(10,2) DEFAULT NULL COMMENT 'jumlah bantuan',
48  `is_active` tinyint(1) DEFAULT NULL,
49  `created` datetime DEFAULT NULL,
50  `modified` datetime DEFAULT NULL
51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52
53--
54-- Dumping data for table `funds`
55--
56
57INSERT INTO `funds` (`id`, `rank`, `name`, `amount`, `is_active`, `created`, `modified`) VALUES
58(1, 1, 'Persaraan saya sebanyak', 200.00, 1, '2016-10-14 14:59:02', '2016-10-18 15:19:13'),
59(2, 2, 'Kemasukan di wad melebihi 3 hari', 200.00, 1, '2016-10-14 15:01:03', '2016-10-14 15:01:03'),
60(3, 3, 'Pemberhentian kerja sebab kesihatan', 200.00, 1, '2016-10-14 15:01:49', '2016-10-14 15:01:49');
61
62-- --------------------------------------------------------
63
64--
65-- Table structure for table `items`
66--
67
68DROP TABLE IF EXISTS `items`;
69CREATE TABLE `items` (
70  `id` int(11) NOT NULL,
71  `claim_id` int(11) DEFAULT NULL COMMENT 'ref:Table_claims',
72  `fund_id` int(11) DEFAULT NULL COMMENT 'ref:Table_funds',
73  `amount` float(10,2) DEFAULT NULL,
74  `created` datetime DEFAULT NULL,
75  `modified` datetime DEFAULT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `members`
82--
83
84DROP TABLE IF EXISTS `members`;
85CREATE TABLE `members` (
86  `id` int(11) NOT NULL,
87  `name` varchar(255) DEFAULT NULL,
88  `email` varchar(255) DEFAULT NULL,
89  `phone` varchar(255) DEFAULT NULL,
90  `telephone` varchar(255) DEFAULT NULL,
91  `nric` varchar(12) DEFAULT NULL,
92  `nation` int(11) DEFAULT NULL,
93  `age` int(11) DEFAULT NULL,
94  `year` year(4) DEFAULT NULL,
95  `dob` date DEFAULT NULL,
96  `dop` date DEFAULT NULL,
97  `address` text,
98  `add_office` text,
99  `states` varchar(255) NOT NULL,
100  `nom_receipt` varchar(255) DEFAULT NULL,
101  `date_receipt` date DEFAULT NULL,
102  `status` int(11) NOT NULL DEFAULT '1001',
103  `is_active` tinyint(1) DEFAULT '1',
104  `date_register` date NOT NULL,
105  `date_received` date DEFAULT NULL,
106  `date_approved` date DEFAULT NULL,
107  `date_notified` date DEFAULT NULL,
108  `comment` text,
109  `created` datetime NOT NULL,
110  `modified` datetime NOT NULL
111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112
113--
114-- Dumping data for table `members`
115--
116
117INSERT INTO `members` (`id`, `name`, `email`, `phone`, `telephone`, `nric`, `nation`, `age`, `year`, `dob`, `dop`, `address`, `add_office`, `states`, `nom_receipt`, `date_receipt`, `status`, `is_active`, `date_register`, `date_received`, `date_approved`, `date_notified`, `comment`, `created`, `modified`) VALUES
118(1, 'A RAHMAN BIN RAHMAT', '', '', '', '570102015049', 0, 59, 1957, '1957-02-01', '0000-00-00', '', 'PEJ. KESIHATAN DAERAH JB', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
119(2, 'NORJAHAN BIN KASIHAN', '', '', '', '570203017019', 0, 59, 1957, '1957-03-02', '0000-00-00', '', 'PEJ KES PONTIAN', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
120(3, 'BUSRAH BIN BABA', '', '', '', '570213045099', 0, 59, 1957, '1957-02-13', '0000-00-00', '', 'H. PERMAI JB', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
121(4, 'ABD GHANI BIN MIAN', '', '', '', '570428016463', 0, 59, 1957, '1957-04-28', '0000-00-00', '', 'H. PERMAI JB', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
122(5, 'SHAMSUDIN BIN MOHAMED', '', '', '', '570502016913', 0, 59, 1957, '1957-02-05', '0000-00-00', '', 'H. TEMENGGUNG SRI MAHARAJA TUN IBRAHIM', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
123(6, 'BUANG BIN A KADIR', '', '', '', '570504016773', 0, 59, 1957, '1957-04-05', '0000-00-00', '', 'H. MERSING', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
124(7, 'MOHD KASIAN BIN BUANG', '', '', '', '570607017103', 0, 59, 1957, '1957-07-06', '0000-00-00', '', 'PEJ. KESIHATAN DAERAH K.TINGGI', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
125(8, 'MOHD ISHADI BIN SARBINI', '', '', '', '570612016631', 0, 59, 1957, '1957-12-06', '0000-00-00', '', 'H. MERSING', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
126(9, 'SAHNIN BIN JURIMI', '', '', '', '570903016455', 0, 59, 1957, '1957-03-09', '0000-00-00', '', 'PEJ. KESIHATAN DAERAH B.PAHAT', 'JOHOR', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
127(10, 'JAAFAR BIN HAMDAN', '', '0124455806', '', '731025025917', 0, 43, 1973, '1973-10-25', '0000-00-00', '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
128(11, 'MOHD FAIZAL BIN ABDULLAH', '', '', '047407920', '750327095025', 0, 41, 1975, '1975-03-27', '0000-00-00', '', 'JAB ORL HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
129(12, 'MOHD FIRDAUS IZHAM BIN MOKHTAR', '', '', '044457333', '840511075883', 0, 32, 1984, '1984-11-05', '0000-00-00', '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
130(13, 'MUHAMMAD NADHAR BIN NAZARI', '', '0125513865', '', '840815065641', 0, 32, 1984, '1984-08-15', '0000-00-00', '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
131(14, 'MUHAMAD HAIRIL SYUKRI BIN IBRAHIM', '', '0133053731', '', '881125115219', 0, 28, 1988, '1988-11-25', '0000-00-00', '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
132(15, 'MOHD IKHWAN SYAFIQ BIN MARZUKI', '', '0133702794', '', '891204025317', 0, 27, 1989, '1989-04-12', '0000-00-00', '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
133(16, 'AIMI NURHAFIZA BINTI MOHAMAD', '', '0195212445', '', '921007115000', 0, 24, 1992, '1992-07-10', '0000-00-00', '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', 'KEDAH/PERLIS', NULL, NULL, 1004, 1, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `params`
139--
140
141DROP TABLE IF EXISTS `params`;
142CREATE TABLE `params` (
143  `id` int(11) NOT NULL,
144  `code` int(11) NOT NULL COMMENT '5xxx',
145  `name` varchar(255) NOT NULL,
146  `status` tinyint(1) NOT NULL DEFAULT '1'
147) ENGINE=InnoDB DEFAULT CHARSET=latin1;
148
149--
150-- Dumping data for table `params`
151--
152
153INSERT INTO `params` (`id`, `code`, `name`, `status`) VALUES
154(1, 1000, 'Tiada Maklumat', 1),
155(2, 1001, 'Permohonan Baru', 1),
156(3, 1002, 'Dalam Semakan', 1),
157(4, 1004, 'Permohonan Berjaya', 1),
158(5, 1005, 'Permohonan Gagal', 1),
159(6, 2001, 'Ahli', 1),
160(7, 2002, 'Bukan Ahli', 1),
161(8, 3001, 'AFFIN BANK BERHAD / AFFIN ISLAMIC BANK', 1),
162(9, 3002, 'AL-RAJHI BANKING', 1),
163(10, 3003, 'ALLIANCE BANK MALAYSIA BERHAD', 1),
164(11, 3004, 'AMBANK BERHAD', 1),
165(12, 3005, 'BANK ISLAM MALAYSIA', 1),
166(13, 3006, 'BANK KERJASAMA RAKYAT MALAYSIA BERHAD', 1),
167(14, 3007, 'BANK MUAMALAT', 1),
168(15, 3008, 'BANK OF AMERICA', 1),
169(16, 3009, 'BANK OF CHINA (MALAYSIA) BERHAD', 1),
170(17, 3010, 'BANK SIMPANAN NASIONAL BERHAD', 1),
171(18, 3011, 'BANK PERTANIAN MALAYSIA BERHAD (AGROBANK)', 1),
172(19, 3012, 'CIMB BANK BERHAD', 1),
173(20, 3013, 'CITIBANK BERHAD', 1),
174(21, 3014, 'DEUTSCHE BANK (MSIA) BERHAD', 1),
175(22, 3015, 'HONG LEONG BANK', 1),
176(23, 3016, 'HSBC BANK MALAYSIA BERHAD', 1),
177(24, 3017, 'KUWAIT FINANCE HOUSE (MALAYSIA) BHD', 1),
178(25, 3018, 'OCBC BANK(MALAYSIA) BHD', 1),
179(26, 3019, 'PUBLIC BANK', 1),
180(27, 3020, 'RHB BANK', 1),
181(28, 3021, 'STANDARD CHARTERED BANK', 1),
182(29, 4001, 'Melayu', 1),
183(30, 4002, 'Cina', 1),
184(31, 4003, 'India', 1),
185(32, 4004, 'Iban', 1),
186(33, 4005, 'Kadazan', 1),
187(34, 4006, 'Bidayuh', 1),
188(35, 4007, 'Lain-lain', 1);
189
190-- --------------------------------------------------------
191
192--
193-- Table structure for table `users`
194--
195
196DROP TABLE IF EXISTS `users`;
197CREATE TABLE `users` (
198  `id` int(11) NOT NULL,
199  `role` int(11) NOT NULL DEFAULT '200',
200  `username` varchar(150) NOT NULL,
201  `password` varchar(255) NOT NULL,
202  `name` varchar(255) NOT NULL,
203  `email` char(40) NOT NULL,
204  `token_exp` datetime DEFAULT NULL,
205  `token_key` varchar(255) DEFAULT NULL,
206  `token_reset` tinyint(1) DEFAULT '0',
207  `is_active` tinyint(1) NOT NULL DEFAULT '1',
208  `created` datetime DEFAULT NULL,
209  `modified` datetime DEFAULT NULL
210) ENGINE=InnoDB DEFAULT CHARSET=latin1;
211
212--
213-- Dumping data for table `users`
214--
215
216INSERT INTO `users` (`id`, `role`, `username`, `password`, `name`, `email`, `token_exp`, `token_key`, `token_reset`, `is_active`, `created`, `modified`) VALUES
217(1, 100, 'zakimustafa', '$2y$11$WUZYeGN6S2djMnFhaXlNZu7K0uvPpeWVbmw3BkJlDKRunhCJJEJym', 'Mohamad Zaki Mustafa', 'zaki@gmail.com', NULL, NULL, 0, 1, '2016-10-20 10:17:17', '2016-10-26 13:42:05');
218
219--
220-- Indexes for dumped tables
221--
222
223--
224-- Indexes for table `claims`
225--
226ALTER TABLE `claims`
227  ADD PRIMARY KEY (`id`);
228
229--
230-- Indexes for table `funds`
231--
232ALTER TABLE `funds`
233  ADD PRIMARY KEY (`id`);
234
235--
236-- Indexes for table `items`
237--
238ALTER TABLE `items`
239  ADD PRIMARY KEY (`id`);
240
241--
242-- Indexes for table `members`
243--
244ALTER TABLE `members`
245  ADD PRIMARY KEY (`id`);
246
247--
248-- Indexes for table `params`
249--
250ALTER TABLE `params`
251  ADD PRIMARY KEY (`id`);
252
253--
254-- Indexes for table `users`
255--
256ALTER TABLE `users`
257  ADD PRIMARY KEY (`id`);
258
259--
260-- AUTO_INCREMENT for dumped tables
261--
262
263--
264-- AUTO_INCREMENT for table `claims`
265--
266ALTER TABLE `claims`
267  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
268--
269-- AUTO_INCREMENT for table `funds`
270--
271ALTER TABLE `funds`
272  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
273--
274-- AUTO_INCREMENT for table `items`
275--
276ALTER TABLE `items`
277  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
278--
279-- AUTO_INCREMENT for table `members`
280--
281ALTER TABLE `members`
282  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;
283--
284-- AUTO_INCREMENT for table `params`
285--
286ALTER TABLE `params`
287  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
288--
289-- AUTO_INCREMENT for table `users`
290--
291ALTER TABLE `users`
292  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;