· 9 years ago · Nov 02, 2016, 12:26 PM
1-- phpMyAdmin SQL Dump
2-- version 4.5.3.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 02, 2016 at 12:23 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 `attachments`
23--
24
25DROP TABLE IF EXISTS `attachments`;
26CREATE TABLE `attachments` (
27 `id` int(11) NOT NULL,
28 `claim_id` int(11) NOT NULL,
29 `title` varchar(255) NOT NULL,
30 `file_name` varchar(255) NOT NULL,
31 `file_size` varchar(50) NOT NULL,
32 `created` datetime NOT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- --------------------------------------------------------
36
37--
38-- Table structure for table `claims`
39--
40
41DROP TABLE IF EXISTS `claims`;
42CREATE TABLE `claims` (
43 `id` int(11) NOT NULL,
44 `nric` varchar(12) DEFAULT NULL,
45 `branch` varchar(255) DEFAULT NULL,
46 `bank_account` varchar(255) DEFAULT NULL,
47 `num_account` varchar(255) DEFAULT NULL,
48 `sum` float(10,2) NOT NULL,
49 `document` tinyint(1) NOT NULL DEFAULT '0',
50 `status` int(11) NOT NULL DEFAULT '1001',
51 `created` datetime NOT NULL,
52 `modified` datetime NOT NULL
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55--
56-- Dumping data for table `claims`
57--
58
59INSERT INTO `claims` (`id`, `nric`, `branch`, `bank_account`, `num_account`, `sum`, `document`, `status`, `created`, `modified`) VALUES
60(5, '570102015049', 'Kuala Lumpur', '3014', '1234567890', 1700.00, 0, 1001, '2016-10-28 22:05:09', '2016-10-28 22:05:09'),
61(6, '570102015049', 'Kuala Lumpur', '3008', '1234567890', 400.00, 0, 1001, '2016-10-31 20:37:08', '2016-10-31 20:37:08');
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `funds`
67--
68
69DROP TABLE IF EXISTS `funds`;
70CREATE TABLE `funds` (
71 `id` int(11) NOT NULL,
72 `rank` int(11) NOT NULL DEFAULT '1' COMMENT 'Kedudukan Susunan Jenis Tuntutan',
73 `name` varchar(255) DEFAULT NULL COMMENT 'Jenis tuntutan ',
74 `amount` float(10,2) DEFAULT NULL COMMENT 'jumlah bantuan',
75 `is_active` tinyint(1) DEFAULT NULL,
76 `created` datetime DEFAULT NULL,
77 `modified` datetime DEFAULT NULL
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `funds`
82--
83
84INSERT INTO `funds` (`id`, `rank`, `name`, `amount`, `is_active`, `created`, `modified`) VALUES
85(1, 1, 'Persaraan saya sebanyak', 200.00, 1, '2016-10-14 14:59:02', '2016-10-18 15:19:13'),
86(2, 2, 'Kemasukan di wad melebihi 3 hari', 200.00, 1, '2016-10-14 15:01:03', '2016-10-14 15:01:03'),
87(3, 3, 'Pemberhentian kerja sebab kesihatan', 200.00, 1, '2016-10-14 15:01:49', '2016-10-14 15:01:49'),
88(4, 4, 'Khariat kematian ahli sebanyak', 500.00, 1, '2016-10-14 15:02:09', '2016-10-14 15:02:09'),
89(5, 5, 'Kecemerlangan anak saya : UPSR sekurang-kurangnya 4A', 100.00, 1, '2016-10-14 15:02:42', '2016-10-14 15:02:42'),
90(6, 6, 'Kecemerlangan anak saya : PT 3 sekurang-kurangnya 7A', 150.00, 1, '2016-10-14 15:03:06', '2016-10-14 15:03:06'),
91(7, 7, 'Kecemerlangan anak saya : SPM sekurang-kurangnya 6A', 200.00, 1, '2016-10-14 15:03:25', '2016-10-14 15:03:25'),
92(8, 8, 'Kecemerlangan anak saya : STPM sekurang-kurangnya 4P', 250.00, 1, '2016-10-14 15:05:41', '2016-10-14 15:05:41');
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `items`
98--
99
100DROP TABLE IF EXISTS `items`;
101CREATE TABLE `items` (
102 `id` int(11) NOT NULL,
103 `claim_id` int(11) DEFAULT NULL COMMENT 'ref:Table_claims',
104 `fund_id` int(11) DEFAULT NULL COMMENT 'ref:Table_funds',
105 `qty` int(11) NOT NULL,
106 `amount` float(10,2) DEFAULT NULL
107) ENGINE=InnoDB DEFAULT CHARSET=latin1;
108
109--
110-- Dumping data for table `items`
111--
112
113INSERT INTO `items` (`id`, `claim_id`, `fund_id`, `qty`, `amount`) VALUES
114(14, 5, 1, 1, 200.00),
115(15, 5, 4, 3, 500.00),
116(16, 6, 1, 1, 200.00),
117(17, 6, 3, 1, 200.00);
118
119-- --------------------------------------------------------
120
121--
122-- Table structure for table `members`
123--
124
125DROP TABLE IF EXISTS `members`;
126CREATE TABLE `members` (
127 `id` int(11) NOT NULL,
128 `name` varchar(255) DEFAULT NULL,
129 `email` varchar(255) DEFAULT NULL,
130 `phone` varchar(255) DEFAULT NULL,
131 `telephone` varchar(255) DEFAULT NULL,
132 `nric` varchar(12) DEFAULT NULL,
133 `nation` int(11) DEFAULT NULL,
134 `age` int(11) DEFAULT NULL,
135 `year` year(4) DEFAULT NULL,
136 `dob` date DEFAULT NULL,
137 `dop` date DEFAULT NULL,
138 `address` text,
139 `add_office` text,
140 `states` varchar(255) NOT NULL,
141 `nom_receipt` varchar(255) DEFAULT NULL,
142 `date_receipt` date DEFAULT NULL,
143 `status` int(11) NOT NULL DEFAULT '1001',
144 `is_active` tinyint(1) DEFAULT '1',
145 `date_register` date NOT NULL,
146 `date_received` date DEFAULT NULL,
147 `date_approved` date DEFAULT NULL,
148 `date_notified` date DEFAULT NULL,
149 `comment` text,
150 `created` datetime NOT NULL,
151 `modified` datetime NOT NULL
152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153
154--
155-- Dumping data for table `members`
156--
157
158INSERT 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
159(1, 'A RAHMAN BIN RAHMAT', 'a.rahman@gmail.com', '0126983875', '0126983875', '570102015049', 0, 59, 1957, '1957-02-01', '2016-10-27', 'PEJ. KESIHATAN DAERAH JB', 'PEJ. KESIHATAN DAERAH JB', 'JOHOR', NULL, NULL, 1004, 1, '2016-10-27', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '2016-10-27 21:24:24'),
160(2, 'NORJAHAN BIN KASIHAN', '', '', '', '570203017019', 0, 59, 1957, '1957-03-02', '0000-00-00', '', 'PEJ KES PONTIAN', 'JOHOR', NULL, NULL, 1001, 0, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
161(3, 'BUSRAH BIN BABA', '', '', '', '570213045099', 0, 59, 1957, '1957-02-13', '0000-00-00', '', 'H. PERMAI JB', 'JOHOR', NULL, NULL, 1001, 0, '0000-00-00', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
162(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'),
163(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'),
164(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'),
165(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'),
166(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'),
167(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'),
168(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'),
169(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'),
170(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'),
171(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'),
172(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');
173
174-- --------------------------------------------------------
175
176--
177-- Table structure for table `params`
178--
179
180DROP TABLE IF EXISTS `params`;
181CREATE TABLE `params` (
182 `id` int(11) NOT NULL,
183 `code` int(11) NOT NULL COMMENT '5xxx',
184 `name` varchar(255) NOT NULL,
185 `status` tinyint(1) NOT NULL DEFAULT '1'
186) ENGINE=InnoDB DEFAULT CHARSET=latin1;
187
188--
189-- Dumping data for table `params`
190--
191
192INSERT INTO `params` (`id`, `code`, `name`, `status`) VALUES
193(1, 1000, 'Tiada Maklumat', 1),
194(2, 1001, 'Permohonan Baru', 1),
195(3, 1002, 'Dalam Semakan', 1),
196(4, 1004, 'Permohonan Berjaya', 1),
197(5, 1005, 'Permohonan Gagal', 1),
198(6, 1006, 'Tiada Lampiran', 1),
199(7, 2002, 'Bukan Ahli', 1),
200(8, 3001, 'AFFIN BANK BERHAD / AFFIN ISLAMIC BANK', 1),
201(9, 3002, 'AL-RAJHI BANKING', 1),
202(10, 3003, 'ALLIANCE BANK MALAYSIA BERHAD', 1),
203(11, 3004, 'AMBANK BERHAD', 1),
204(12, 3005, 'BANK ISLAM MALAYSIA', 1),
205(13, 3006, 'BANK KERJASAMA RAKYAT MALAYSIA BERHAD', 1),
206(14, 3007, 'BANK MUAMALAT', 1),
207(15, 3008, 'BANK OF AMERICA', 1),
208(16, 3009, 'BANK OF CHINA (MALAYSIA) BERHAD', 1),
209(17, 3010, 'BANK SIMPANAN NASIONAL BERHAD', 1),
210(18, 3011, 'BANK PERTANIAN MALAYSIA BERHAD (AGROBANK)', 1),
211(19, 3012, 'CIMB BANK BERHAD', 1),
212(20, 3013, 'CITIBANK BERHAD', 1),
213(21, 3014, 'DEUTSCHE BANK (MSIA) BERHAD', 1),
214(22, 3015, 'HONG LEONG BANK', 1),
215(23, 3016, 'HSBC BANK MALAYSIA BERHAD', 1),
216(24, 3017, 'KUWAIT FINANCE HOUSE (MALAYSIA) BHD', 1),
217(25, 3018, 'OCBC BANK(MALAYSIA) BHD', 1),
218(26, 3019, 'PUBLIC BANK', 1),
219(27, 3020, 'RHB BANK', 1),
220(28, 3021, 'STANDARD CHARTERED BANK', 1),
221(29, 4001, 'Melayu', 1),
222(30, 4002, 'Cina', 1),
223(31, 4003, 'India', 1),
224(32, 4004, 'Iban', 1),
225(33, 4005, 'Kadazan', 1),
226(34, 4006, 'Bidayuh', 1),
227(35, 4007, 'Lain-lain', 1);
228
229-- --------------------------------------------------------
230
231--
232-- Table structure for table `states`
233--
234
235DROP TABLE IF EXISTS `states`;
236CREATE TABLE `states` (
237 `id` int(11) NOT NULL,
238 `code` varchar(4) NOT NULL,
239 `name` varchar(200) NOT NULL,
240 `is_active` tinyint(1) NOT NULL
241) ENGINE=InnoDB DEFAULT CHARSET=latin1;
242
243--
244-- Dumping data for table `states`
245--
246
247INSERT INTO `states` (`id`, `code`, `name`, `is_active`) VALUES
248(1, '01', 'Johor', 1),
249(2, '02', 'Kedah', 1),
250(3, '03', 'Kelantan', 1),
251(4, '04', 'Melaka', 1),
252(5, '05', 'Negeri Sembilan', 1),
253(6, '06', 'Pahang', 1),
254(7, '07', 'Pulau Pinang', 1),
255(8, '08', 'Perak', 1),
256(9, '09', 'Perlis', 1),
257(10, '10', 'Selangor', 1),
258(11, '11', 'Terengganu', 1),
259(12, '12', 'Sabah', 1),
260(13, '13', 'Sarawak', 1),
261(14, '14', 'Wilayah Persekutuan Kuala Lumpur', 1),
262(15, '15', 'Wilayah Persekutuan Labuan', 1),
263(16, '16', 'Wilayah Persekutuan Putrajaya', 1),
264(98, '00', 'Tiada Maklumat', 1);
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `users`
270--
271
272DROP TABLE IF EXISTS `users`;
273CREATE TABLE `users` (
274 `id` int(11) NOT NULL,
275 `role` int(11) NOT NULL DEFAULT '200',
276 `username` varchar(150) NOT NULL,
277 `password` varchar(255) NOT NULL,
278 `name` varchar(255) NOT NULL,
279 `email` char(40) NOT NULL,
280 `token_exp` datetime DEFAULT NULL,
281 `token_key` varchar(255) DEFAULT NULL,
282 `token_reset` tinyint(1) DEFAULT '0',
283 `is_active` tinyint(1) NOT NULL DEFAULT '1',
284 `created` datetime DEFAULT NULL,
285 `modified` datetime DEFAULT NULL
286) ENGINE=InnoDB DEFAULT CHARSET=latin1;
287
288--
289-- Dumping data for table `users`
290--
291
292INSERT INTO `users` (`id`, `role`, `username`, `password`, `name`, `email`, `token_exp`, `token_key`, `token_reset`, `is_active`, `created`, `modified`) VALUES
293(1, 100, 'zakimustafa', '$2y$11$WUZYeGN6S2djMnFhaXlNZu7K0uvPpeWVbmw3BkJlDKRunhCJJEJym', 'Mohamad Zaki Mustafa', 'mohdzaki04@gmail.com', NULL, NULL, 0, 1, '2016-10-20 10:17:17', '2016-10-26 13:42:05'),
294(2, 200, 'azmios', '$2y$11$UWpLYWtAQ3BXR0pYVVd6Vup4CFAjN.3Jwm1MsqSL7hNgiwZCsCIdq', 'Mohd Azmi Osman', 'azmios@gmail.com', NULL, NULL, 0, 1, '2016-10-26 14:49:19', '2016-10-26 14:50:40');
295
296--
297-- Indexes for dumped tables
298--
299
300--
301-- Indexes for table `attachments`
302--
303ALTER TABLE `attachments`
304 ADD PRIMARY KEY (`id`);
305
306--
307-- Indexes for table `claims`
308--
309ALTER TABLE `claims`
310 ADD PRIMARY KEY (`id`);
311
312--
313-- Indexes for table `funds`
314--
315ALTER TABLE `funds`
316 ADD PRIMARY KEY (`id`);
317
318--
319-- Indexes for table `items`
320--
321ALTER TABLE `items`
322 ADD PRIMARY KEY (`id`);
323
324--
325-- Indexes for table `members`
326--
327ALTER TABLE `members`
328 ADD PRIMARY KEY (`id`);
329
330--
331-- Indexes for table `params`
332--
333ALTER TABLE `params`
334 ADD PRIMARY KEY (`id`);
335
336--
337-- Indexes for table `states`
338--
339ALTER TABLE `states`
340 ADD PRIMARY KEY (`id`);
341
342--
343-- Indexes for table `users`
344--
345ALTER TABLE `users`
346 ADD PRIMARY KEY (`id`);
347
348--
349-- AUTO_INCREMENT for dumped tables
350--
351
352--
353-- AUTO_INCREMENT for table `attachments`
354--
355ALTER TABLE `attachments`
356 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
357--
358-- AUTO_INCREMENT for table `claims`
359--
360ALTER TABLE `claims`
361 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
362--
363-- AUTO_INCREMENT for table `funds`
364--
365ALTER TABLE `funds`
366 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
367--
368-- AUTO_INCREMENT for table `items`
369--
370ALTER TABLE `items`
371 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
372--
373-- AUTO_INCREMENT for table `members`
374--
375ALTER TABLE `members`
376 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;
377--
378-- AUTO_INCREMENT for table `params`
379--
380ALTER TABLE `params`
381 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
382--
383-- AUTO_INCREMENT for table `states`
384--
385ALTER TABLE `states`
386 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;
387--
388-- AUTO_INCREMENT for table `users`
389--
390ALTER TABLE `users`
391 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;