· 7 years ago · Feb 21, 2019, 02:54 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.21 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.5.0.5423
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for ikampus
16CREATE DATABASE IF NOT EXISTS `ikampus` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `ikampus`;
18
19-- Dumping structure for table ikampus.sa_applicationfilter
20CREATE TABLE IF NOT EXISTS `sa_applicationfilter` (
21 `saaf_id` bigint(20) NOT NULL AUTO_INCREMENT,
22 `saaf_category` enum('R','C','A','P','O') DEFAULT NULL COMMENT 'R - Result , C - Achievement , A - Achievement Level , P - Participation , O - Sport',
23 `saaf_criteria` varchar(50) DEFAULT NULL,
24 `saaf_value` decimal(6,2) DEFAULT NULL,
25 `saaf_remarks` varchar(100) DEFAULT NULL,
26 `created_at` datetime DEFAULT NULL,
27 `created_by` int(11) DEFAULT NULL,
28 `updated_at` timestamp NULL DEFAULT NULL,
29 `updated_by` int(11) DEFAULT NULL,
30 PRIMARY KEY (`saaf_id`)
31) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
32
33-- Dumping data for table ikampus.sa_applicationfilter: ~5 rows (approximately)
34DELETE FROM `sa_applicationfilter`;
35/*!40000 ALTER TABLE `sa_applicationfilter` DISABLE KEYS */;
36INSERT INTO `sa_applicationfilter` (`saaf_id`, `saaf_category`, `saaf_criteria`, `saaf_value`, `saaf_remarks`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
37 (1, 'R', 'A', 9.00, 'CUBAAN', NULL, NULL, NULL, NULL),
38 (2, 'C', '5', 10.00, 'MARKAH PENUH UNTUK EMAS', '2019-02-20 03:46:28', 3, '2019-02-20 03:46:28', 3),
39 (3, 'A', '1', 15.00, 'MARKAH PENUH 15 UNTUK PERINGKAT KEBANGSAAN', '2019-02-20 03:48:51', 3, '2019-02-20 03:48:51', 3),
40 (4, 'R', 'B', 7.00, 'CUBAAN B', NULL, NULL, NULL, NULL),
41 (5, 'P', '1', 20.00, 'CUBAAN', NULL, NULL, NULL, NULL);
42/*!40000 ALTER TABLE `sa_applicationfilter` ENABLE KEYS */;
43
44-- Dumping structure for table ikampus.sa_filteringresult
45CREATE TABLE IF NOT EXISTS `sa_filteringresult` (
46 `safs_id` int(11) NOT NULL AUTO_INCREMENT,
47 `safs_applicationid` int(11) DEFAULT NULL,
48 `safs_result` decimal(6,2) DEFAULT NULL,
49 `safs_participation` decimal(6,2) DEFAULT NULL,
50 `safs_association` decimal(6,2) DEFAULT NULL,
51 `safs_seminar` decimal(6,2) DEFAULT NULL,
52 `safs_total` decimal(6,2) DEFAULT NULL,
53 `safs_ranking` decimal(6,2) DEFAULT NULL,
54 `safs_icnumber` varchar(12) DEFAULT NULL,
55 `created_at` datetime DEFAULT NULL,
56 `created_by` int(11) DEFAULT NULL,
57 `updated_at` timestamp NULL DEFAULT NULL,
58 `updated_by` int(11) DEFAULT NULL,
59 PRIMARY KEY (`safs_id`)
60) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
61
62-- Dumping data for table ikampus.sa_filteringresult: ~6 rows (approximately)
63DELETE FROM `sa_filteringresult`;
64/*!40000 ALTER TABLE `sa_filteringresult` DISABLE KEYS */;
65INSERT INTO `sa_filteringresult` (`safs_id`, `safs_applicationid`, `safs_result`, `safs_participation`, `safs_association`, `safs_seminar`, `safs_total`, `safs_ranking`, `safs_icnumber`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
66 (3, 52, 62.00, 25.00, 70.00, 70.00, NULL, NULL, '2147483647', '2019-02-21 01:52:26', 3, '2019-02-21 01:52:26', 3),
67 (4, 54, 62.00, 30.00, 70.00, 70.00, NULL, NULL, '2147483647', '2019-02-21 02:04:21', 3, '2019-02-21 02:04:21', 3),
68 (5, 55, 62.00, 30.00, 70.00, 70.00, 232.00, NULL, '2147483647', '2019-02-21 02:12:27', 3, '2019-02-21 02:12:27', 3),
69 (6, 56, 62.00, 30.00, 70.00, 70.00, 232.00, NULL, '2147483647', '2019-02-21 02:20:01', 3, '2019-02-21 02:20:01', 3),
70 (7, 57, 62.00, 30.00, 70.00, 70.00, 232.00, NULL, '2147483647', '2019-02-21 02:21:28', 3, '2019-02-21 02:21:28', 3),
71 (8, 58, 62.00, 30.00, 70.00, 70.00, 232.00, NULL, '970101010101', '2019-02-21 02:27:36', 3, '2019-02-21 02:27:36', 3);
72/*!40000 ALTER TABLE `sa_filteringresult` ENABLE KEYS */;
73
74/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
75/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
76/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;