API tools faq
paste
mzm-dev

Untitled

mzm-dev
Nov 2nd, 2016
12,012
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.92 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.3.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Nov 24, 2016 at 12:58 AM
  7. -- Server version: 5.6.28
  8. -- PHP Version: 5.6.27
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `nuamo`
  15. --
  16. CREATE DATABASE IF NOT EXISTS `nuamo` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  17. USE `nuamo`;
  18.  
  19. -- --------------------------------------------------------
  20.  
  21. --
  22. -- Table structure for table `attachments`
  23. --
  24.  
  25. DROP TABLE IF EXISTS `attachments`;
  26. CREATE 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. -- Dumping data for table `attachments`
  37. --
  38.  
  39. INSERT INTO `attachments` (`id`, `claim_id`, `title`, `file_name`, `file_size`, `created`) VALUES
  40. (1, 6, 'Tuntutan Peperiksaan', '1478091361_6541_5.jpg', '12345', '0000-00-00 00:00:00'),
  41. (2, 6, 'Fail Dummy 1', '1478091361_6541_5.jpg', '1234', '0000-00-00 00:00:00'),
  42. (3, 6, 'Fail Dummy 2', '1478091361_6541_5.jpg', '123', '0000-00-00 00:00:00'),
  43. (4, 5, 'Fail Dummy 1', '1478091361_6541_5.jpg', '1234', '0000-00-00 00:00:00'),
  44. (5, 5, 'Fail Dummy 2', '1478091361_6541_5.jpg', '123', '0000-00-00 00:00:00');
  45.  
  46. -- --------------------------------------------------------
  47.  
  48. --
  49. -- Table structure for table `claims`
  50. --
  51.  
  52. DROP TABLE IF EXISTS `claims`;
  53. CREATE TABLE `claims` (
  54. `id` int(11) NOT NULL,
  55. `nric` varchar(12) DEFAULT NULL,
  56. `branch` varchar(255) DEFAULT NULL,
  57. `bank_account` varchar(255) DEFAULT NULL,
  58. `num_account` varchar(255) DEFAULT NULL,
  59. `sum` float(10,2) NOT NULL,
  60. `document` tinyint(1) NOT NULL DEFAULT '0',
  61. `catatan` text,
  62. `status` int(11) NOT NULL DEFAULT '1001',
  63. `created` datetime NOT NULL,
  64. `modified` datetime NOT NULL
  65. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  66.  
  67. --
  68. -- Dumping data for table `claims`
  69. --
  70.  
  71. INSERT INTO `claims` (`id`, `nric`, `branch`, `bank_account`, `num_account`, `sum`, `document`, `catatan`, `status`, `created`, `modified`) VALUES
  72. (5, '570102015049', 'Kuala Lumpur', '3014', '1234567890', 400.00, 0, NULL, 1004, '2016-10-28 22:05:09', '2016-10-28 22:05:09'),
  73. (6, '570102015049', 'Kuala Lumpur', '3008', '1234567890', 650.00, 0, 'Catatatatataan', 1001, '2016-10-31 20:37:08', '2016-10-31 20:37:08');
  74.  
  75. -- --------------------------------------------------------
  76.  
  77. --
  78. -- Table structure for table `funds`
  79. --
  80.  
  81. DROP TABLE IF EXISTS `funds`;
  82. CREATE TABLE `funds` (
  83. `id` int(11) NOT NULL,
  84. `rank` int(11) NOT NULL DEFAULT '1' COMMENT 'Kedudukan Susunan Jenis Tuntutan',
  85. `name` varchar(255) DEFAULT NULL COMMENT 'Jenis tuntutan ',
  86. `amount` float(10,2) DEFAULT NULL COMMENT 'jumlah bantuan',
  87. `is_active` tinyint(1) DEFAULT NULL,
  88. `created` datetime DEFAULT NULL,
  89. `modified` datetime DEFAULT NULL
  90. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  91.  
  92. --
  93. -- Dumping data for table `funds`
  94. --
  95.  
  96. INSERT INTO `funds` (`id`, `rank`, `name`, `amount`, `is_active`, `created`, `modified`) VALUES
  97. (1, 1, 'Persaraan saya sebanyak', 200.00, 1, '2016-10-14 14:59:02', '2016-10-18 15:19:13'),
  98. (2, 2, 'Kemasukan di wad melebihi 3 hari', 200.00, 1, '2016-10-14 15:01:03', '2016-10-14 15:01:03'),
  99. (3, 3, 'Pemberhentian kerja sebab kesihatan', 200.00, 1, '2016-10-14 15:01:49', '2016-10-14 15:01:49'),
  100. (4, 4, 'Khariat kematian ahli sebanyak', 500.00, 1, '2016-10-14 15:02:09', '2016-10-14 15:02:09'),
  101. (5, 5, 'Kecemerlangan anak saya : UPSR sekurang-kurangnya 4A', 100.00, 1, '2016-10-14 15:02:42', '2016-10-14 15:02:42'),
  102. (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'),
  103. (7, 7, 'Kecemerlangan anak saya : SPM sekurang-kurangnya 6A', 200.00, 1, '2016-10-14 15:03:25', '2016-10-14 15:03:25'),
  104. (8, 8, 'Kecemerlangan anak saya : STPM sekurang-kurangnya 4P', 250.00, 1, '2016-10-14 15:05:41', '2016-10-14 15:05:41');
  105.  
  106. -- --------------------------------------------------------
  107.  
  108. --
  109. -- Table structure for table `items`
  110. --
  111.  
  112. DROP TABLE IF EXISTS `items`;
  113. CREATE TABLE `items` (
  114. `id` int(11) NOT NULL,
  115. `claim_id` int(11) DEFAULT '0' COMMENT 'ref:Table_claims',
  116. `fund_id` int(11) DEFAULT '0' COMMENT 'ref:Table_funds',
  117. `qty` int(11) NOT NULL DEFAULT '0',
  118. `amount` float(10,2) DEFAULT '0.00'
  119. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  120.  
  121. --
  122. -- Dumping data for table `items`
  123. --
  124.  
  125. INSERT INTO `items` (`id`, `claim_id`, `fund_id`, `qty`, `amount`) VALUES
  126. (19, 7, 1, 1, 200.00),
  127. (52, 5, 1, 1, 200.00),
  128. (53, 5, 3, 1, 200.00),
  129. (66, 6, 1, 1, 200.00),
  130. (67, 6, 2, 1, 200.00),
  131. (68, 6, 8, 1, 250.00);
  132.  
  133. -- --------------------------------------------------------
  134.  
  135. --
  136. -- Table structure for table `members`
  137. --
  138.  
  139. DROP TABLE IF EXISTS `members`;
  140. CREATE TABLE `members` (
  141. `id` int(11) NOT NULL,
  142. `name` varchar(255) DEFAULT NULL,
  143. `email` varchar(255) DEFAULT NULL,
  144. `phone` varchar(255) DEFAULT NULL,
  145. `telephone` varchar(255) DEFAULT NULL,
  146. `nric` varchar(12) DEFAULT NULL,
  147. `nation` int(11) DEFAULT NULL,
  148. `age` int(11) DEFAULT NULL,
  149. `year` year(4) DEFAULT NULL,
  150. `dob` date DEFAULT NULL,
  151. `dop` date DEFAULT NULL,
  152. `address` text,
  153. `add_office` text,
  154. `state_id` varchar(11) DEFAULT '00',
  155. `nom_receipt` varchar(255) DEFAULT NULL,
  156. `date_receipt` date DEFAULT NULL,
  157. `status` int(11) DEFAULT '1001',
  158. `is_active` tinyint(1) DEFAULT '0',
  159. `date_register` date DEFAULT NULL,
  160. `date_received` date DEFAULT NULL,
  161. `date_approved` date DEFAULT NULL,
  162. `date_notified` date DEFAULT NULL,
  163. `comment` text,
  164. `created` datetime DEFAULT NULL,
  165. `modified` datetime DEFAULT NULL
  166. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  167.  
  168. --
  169. -- Dumping data for table `members`
  170. --
  171.  
  172. INSERT INTO `members` (`id`, `name`, `email`, `phone`, `telephone`, `nric`, `nation`, `age`, `year`, `dob`, `dop`, `address`, `add_office`, `state_id`, `nom_receipt`, `date_receipt`, `status`, `is_active`, `date_register`, `date_received`, `date_approved`, `date_notified`, `comment`, `created`, `modified`) VALUES
  173. (1, 'A RAHMAN BIN RAHMAT', '[email protected]', '0126983875', '0126983875', '570102015049', 0, 59, 1957, '1957-02-01', '2016-10-27', 'PEJ. KESIHATAN DAERAH JB', 'PEJ. KESIHATAN DAERAH JB', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '2016-10-27 21:24:24'),
  174. (2, 'NORJAHAN BIN KASIHAN', '', '', '', '570203017019', 0, 59, 1957, '1957-03-02', NULL, '', 'PEJ KES PONTIAN', '00', NULL, NULL, 1001, 0, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  175. (3, 'BUSRAH BIN BABA', '', '', '', '570213045099', 0, 59, 1957, '1957-02-13', NULL, '', 'H. PERMAI JB', '00', NULL, NULL, 1001, 0, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  176. (4, 'ABD GHANI BIN MIAN', '', '', '', '570428016463', 0, 59, 1957, '1957-04-28', NULL, '', 'H. PERMAI JB', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  177. (5, 'SHAMSUDIN BIN MOHAMED', '', '', '', '570502016913', 0, 59, 1957, '1957-02-05', NULL, '', 'H. TEMENGGUNG SRI MAHARAJA TUN IBRAHIM', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  178. (6, 'BUANG BIN A KADIR', '', '', '', '570504016773', 0, 59, 1957, '1957-04-05', NULL, '', 'H. MERSING', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  179. (7, 'MOHD KASIAN BIN BUANG', '', '', '', '570607017103', 0, 59, 1957, '1957-07-06', NULL, '', 'PEJ. KESIHATAN DAERAH K.TINGGI', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  180. (8, 'MOHD ISHADI BIN SARBINI', '', '', '', '570612016631', 0, 59, 1957, '1957-12-06', NULL, '', 'H. MERSING', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  181. (9, 'SAHNIN BIN JURIMI', '', '', '', '570903016455', 0, 59, 1957, '1957-03-09', NULL, '', 'PEJ. KESIHATAN DAERAH B.PAHAT', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  182. (10, 'JAAFAR BIN HAMDAN', '', '0124455806', '', '731025025917', 0, 43, 1973, '1973-10-25', NULL, '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  183. (11, 'MOHD FAIZAL BIN ABDULLAH', '', '', '047407920', '750327095025', 0, 41, 1975, '1975-03-27', NULL, '', 'JAB ORL HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  184. (12, 'MOHD FIRDAUS IZHAM BIN MOKHTAR', '', '', '044457333', '840511075883', 0, 32, 1984, '1984-11-05', NULL, '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  185. (13, 'MUHAMMAD NADHAR BIN NAZARI', '', '0125513865', '', '840815065641', 0, 32, 1984, '1984-08-15', NULL, '', 'HOSPITAL SULTAN ABDUL HALIM LENCONGAN TIMUR BANDAR AMANJAYA 08000NSUNGAI PETANI', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  186. (14, 'MUHAMAD HAIRIL SYUKRI BIN IBRAHIM', '', '0133053731', '', '881125115219', 0, 28, 1988, '1988-11-25', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  187. (15, 'MOHD IKHWAN SYAFIQ BIN MARZUKI', '', '0133702794', '', '891204025317', 0, 27, 1989, '1989-04-12', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  188. (16, 'AIMI NURHAFIZA BINTI MOHAMAD', '', '0195212445', '', '921007115000', 0, 24, 1992, '1992-07-10', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  189. (17, 'ZAINUR FARTINIE BINTI ZAINOL', '', '0137553193', '', '930401025550', 0, 23, 1993, '1993-01-04', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  190. (18, 'MOHAMAD HAZIQ BIN AZMI', '', '0195672331', '', '930407026255', 0, 23, 1993, '1993-07-04', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  191. (19, 'NIK FAZROL AKMAL BIN NIK MUHAMMAD NASRAN', '', '0196400619', '', '930417025109', 0, 23, 1993, '1993-04-17', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00'),
  192. (20, 'MUHAMAD IZHAM BIN ABDUL AZIZ', '', '0143017494', '', '930508055119', 0, 23, 1993, '1993-08-05', NULL, '', 'HOSPITAL SULTANAH BAHIYAH KM6 JALAN LANGGAR 05460 ALOR SETAR', '00', NULL, NULL, 1004, 1, NULL, NULL, NULL, NULL, NULL, '2016-10-27 21:24:24', '0000-00-00 00:00:00');
  193.  
  194. -- --------------------------------------------------------
  195.  
  196. --
  197. -- Table structure for table `params`
  198. --
  199.  
  200. DROP TABLE IF EXISTS `params`;
  201. CREATE TABLE `params` (
  202. `id` int(11) NOT NULL,
  203. `code` int(11) NOT NULL COMMENT '5xxx',
  204. `name` varchar(255) NOT NULL,
  205. `status` tinyint(1) NOT NULL DEFAULT '1'
  206. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  207.  
  208. --
  209. -- Dumping data for table `params`
  210. --
  211.  
  212. INSERT INTO `params` (`id`, `code`, `name`, `status`) VALUES
  213. (1, 1000, 'Tiada Maklumat', 1),
  214. (2, 1001, 'Permohonan Baru', 1),
  215. (3, 1002, 'Dalam Semakan', 1),
  216. (4, 1004, 'Permohonan Berjaya', 1),
  217. (5, 1005, 'Permohonan Gagal', 1),
  218. (6, 1006, 'Tiada Lampiran', 1),
  219. (7, 2001, 'Ahli', 1),
  220. (8, 2002, 'Bukan Ahli', 1),
  221. (9, 3001, 'AFFIN BANK BERHAD / AFFIN ISLAMIC BANK', 1),
  222. (10, 3002, 'AL-RAJHI BANKING', 1),
  223. (11, 3003, 'ALLIANCE BANK MALAYSIA BERHAD', 1),
  224. (12, 3004, 'AMBANK BERHAD', 1),
  225. (13, 3005, 'BANK ISLAM MALAYSIA', 1),
  226. (14, 3006, 'BANK KERJASAMA RAKYAT MALAYSIA BERHAD', 1),
  227. (15, 3007, 'BANK MUAMALAT', 1),
  228. (16, 3008, 'BANK OF AMERICA', 1),
  229. (17, 3009, 'BANK OF CHINA (MALAYSIA) BERHAD', 1),
  230. (18, 3010, 'BANK SIMPANAN NASIONAL BERHAD', 1),
  231. (19, 3011, 'BANK PERTANIAN MALAYSIA BERHAD (AGROBANK)', 1),
  232. (20, 3012, 'CIMB BANK BERHAD', 1),
  233. (21, 3013, 'CITIBANK BERHAD', 1),
  234. (22, 3014, 'DEUTSCHE BANK (MSIA) BERHAD', 1),
  235. (23, 3015, 'HONG LEONG BANK', 1),
  236. (24, 3016, 'HSBC BANK MALAYSIA BERHAD', 1),
  237. (25, 3017, 'KUWAIT FINANCE HOUSE (MALAYSIA) BHD', 1),
  238. (26, 3018, 'OCBC BANK(MALAYSIA) BHD', 1),
  239. (27, 3019, 'PUBLIC BANK', 1),
  240. (28, 3020, 'RHB BANK', 1),
  241. (29, 3021, 'STANDARD CHARTERED BANK', 1),
  242. (30, 4001, 'Melayu', 1),
  243. (31, 4002, 'Cina', 1),
  244. (32, 4003, 'India', 1),
  245. (33, 4004, 'Iban', 1),
  246. (34, 4005, 'Kadazan', 1),
  247. (35, 4006, 'Bidayuh', 1),
  248. (36, 4007, 'Lain-lain', 1);
  249.  
  250. -- --------------------------------------------------------
  251.  
  252. --
  253. -- Table structure for table `states`
  254. --
  255.  
  256. DROP TABLE IF EXISTS `states`;
  257. CREATE TABLE `states` (
  258. `id` int(11) NOT NULL,
  259. `code` varchar(4) NOT NULL,
  260. `name` varchar(200) NOT NULL,
  261. `is_active` tinyint(1) NOT NULL
  262. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  263.  
  264. --
  265. -- Dumping data for table `states`
  266. --
  267.  
  268. INSERT INTO `states` (`id`, `code`, `name`, `is_active`) VALUES
  269. (1, '01', 'Johor', 1),
  270. (2, '02', 'Kedah', 1),
  271. (3, '03', 'Kelantan', 1),
  272. (4, '04', 'Melaka', 1),
  273. (5, '05', 'Negeri Sembilan', 1),
  274. (6, '06', 'Pahang', 1),
  275. (7, '07', 'Pulau Pinang', 1),
  276. (8, '08', 'Perak', 1),
  277. (9, '09', 'Perlis', 1),
  278. (10, '10', 'Selangor', 1),
  279. (11, '11', 'Terengganu', 1),
  280. (12, '12', 'Sabah', 1),
  281. (13, '13', 'Sarawak', 1),
  282. (14, '14', 'Wilayah Persekutuan Kuala Lumpur', 1),
  283. (15, '15', 'Wilayah Persekutuan Labuan', 1),
  284. (16, '16', 'Wilayah Persekutuan Putrajaya', 1),
  285. (98, '00', 'Tiada Maklumat', 1);
  286.  
  287. -- --------------------------------------------------------
  288.  
  289. --
  290. -- Table structure for table `users`
  291. --
  292.  
  293. DROP TABLE IF EXISTS `users`;
  294. CREATE TABLE `users` (
  295. `id` int(11) NOT NULL,
  296. `role` int(11) NOT NULL DEFAULT '200',
  297. `username` varchar(150) NOT NULL,
  298. `password` varchar(255) NOT NULL,
  299. `name` varchar(255) NOT NULL,
  300. `email` char(40) NOT NULL,
  301. `token_exp` datetime DEFAULT NULL,
  302. `token_key` varchar(255) DEFAULT NULL,
  303. `token_reset` tinyint(1) DEFAULT '0',
  304. `is_active` tinyint(1) NOT NULL DEFAULT '1',
  305. `created` datetime DEFAULT NULL,
  306. `modified` datetime DEFAULT NULL
  307. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  308.  
  309. --
  310. -- Dumping data for table `users`
  311. --
  312.  
  313. INSERT INTO `users` (`id`, `role`, `username`, `password`, `name`, `email`, `token_exp`, `token_key`, `token_reset`, `is_active`, `created`, `modified`) VALUES
  314. (1, 100, 'zakimustafa', '$2y$11$WUZYeGN6S2djMnFhaXlNZu7K0uvPpeWVbmw3BkJlDKRunhCJJEJym', 'Mohamad Zaki Mustafa', '[email protected]', NULL, NULL, 0, 1, '2016-10-20 10:17:17', '2016-10-26 13:42:05'),
  315. (2, 200, 'azmios', '$2y$11$UWpLYWtAQ3BXR0pYVVd6Vup4CFAjN.3Jwm1MsqSL7hNgiwZCsCIdq', 'Mohd Azmi Osman', '[email protected]', NULL, NULL, 0, 1, '2016-10-26 14:49:19', '2016-10-26 14:50:40');
  316.  
  317. --
  318. -- Indexes for dumped tables
  319. --
  320.  
  321. --
  322. -- Indexes for table `attachments`
  323. --
  324. ALTER TABLE `attachments`
  325. ADD PRIMARY KEY (`id`);
  326.  
  327. --
  328. -- Indexes for table `claims`
  329. --
  330. ALTER TABLE `claims`
  331. ADD PRIMARY KEY (`id`);
  332.  
  333. --
  334. -- Indexes for table `funds`
  335. --
  336. ALTER TABLE `funds`
  337. ADD PRIMARY KEY (`id`);
  338.  
  339. --
  340. -- Indexes for table `items`
  341. --
  342. ALTER TABLE `items`
  343. ADD PRIMARY KEY (`id`);
  344.  
  345. --
  346. -- Indexes for table `members`
  347. --
  348. ALTER TABLE `members`
  349. ADD PRIMARY KEY (`id`);
  350.  
  351. --
  352. -- Indexes for table `params`
  353. --
  354. ALTER TABLE `params`
  355. ADD PRIMARY KEY (`id`);
  356.  
  357. --
  358. -- Indexes for table `states`
  359. --
  360. ALTER TABLE `states`
  361. ADD PRIMARY KEY (`id`);
  362.  
  363. --
  364. -- Indexes for table `users`
  365. --
  366. ALTER TABLE `users`
  367. ADD PRIMARY KEY (`id`);
  368.  
  369. --
  370. -- AUTO_INCREMENT for dumped tables
  371. --
  372.  
  373. --
  374. -- AUTO_INCREMENT for table `attachments`
  375. --
  376. ALTER TABLE `attachments`
  377. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  378. --
  379. -- AUTO_INCREMENT for table `claims`
  380. --
  381. ALTER TABLE `claims`
  382. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  383. --
  384. -- AUTO_INCREMENT for table `funds`
  385. --
  386. ALTER TABLE `funds`
  387. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  388. --
  389. -- AUTO_INCREMENT for table `items`
  390. --
  391. ALTER TABLE `items`
  392. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
  393. --
  394. -- AUTO_INCREMENT for table `members`
  395. --
  396. ALTER TABLE `members`
  397. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;
  398. --
  399. -- AUTO_INCREMENT for table `params`
  400. --
  401. ALTER TABLE `params`
  402. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
  403. --
  404. -- AUTO_INCREMENT for table `states`
  405. --
  406. ALTER TABLE `states`
  407. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;
  408. --
  409. -- AUTO_INCREMENT for table `users`
  410. --
  411. ALTER TABLE `users`
  412. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!