y890SXsU

1-- phpMyAdmin SQL Dump
2-- version 3.2.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 01, 2017 at 05:33 AM
7-- Server version: 5.1.37
8-- PHP Version: 5.2.10
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `rdatabase`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `course`
20--
21
22CREATE TABLE IF NOT EXISTS `course` (
23  `cid` varchar(30) NOT NULL,
24  `cname` varchar(50) NOT NULL
25) ENGINE=MyISAM DEFAULT CHARSET=latin1;
26
27--
28-- Dumping data for table `course`
29--
30
31INSERT INTO `course` (`cid`, `cname`) VALUES
32('1', 'AI'),
33('2', 'R Programming');
34
35-- --------------------------------------------------------
36
37--
38-- Table structure for table `googletelno`
39--
40
41CREATE TABLE IF NOT EXISTS `googletelno` (
42  `Descrtiption` varchar(50) NOT NULL,
43  `TelNo` varchar(50) NOT NULL
44) ENGINE=MyISAM DEFAULT CHARSET=latin1;
45
46--
47-- Dumping data for table `googletelno`
48--
49
50INSERT INTO `googletelno` (`Descrtiption`, `TelNo`) VALUES
51('TTT', '111'),
52('UNIVERSITI MALAYA', 'Phone:  60 3-7967 7022'),
53('SRI UTAMA PJ', 'Phone:  60 3-7957 5299'),
54('UNIVERSITI PUTERA MALAYSIA', 'Phone:  60 1-800-22-55'),
55('BANK NEGAR', 'Phone:  60 1-300-88-54'),
56('SMK SRI PERMATA', 'Phone:  60 3-7875 0623'),
57('UNIVERSITI PETRONAS', 'Phone:  60 5-368 8000C'),
58('FORENCIS', ''),
59('ss', ''),
60('MIKE', ''),
61('UNIVERSIT TEKNOLOGI', 'Phone:  60 7-553 3333V'),
62('UNIVERSIT TEKNOLOGI', 'Phone:  60 7-553 3333V'),
63('uNIVERSITI mALAYS', 'Phone:  60 3-7967 7022'),
64('universiti malaya', 'Phone:  60 3-7967 7022'),
65('upsi', 'Phone:  60 5-450 6000M'),
66('UNIVERSITI PETRONAS', 'Phone:  60 5-368 8000'),
67('universiti malaya', 'Phone:  60 3-7967 7022'),
68('Tesco', ''),
69('Tesco Malaysia', ''),
70('Jabatan Ikan', ''),
71('Universiti Malaya', 'Phone:  60 3-7967 7022'),
72('UNZA', 'Phone:  260 21 1295220'),
73('Bank Negara', 'Phone:  60 1-300-88-54'),
74('VIGSHAKRI', ''),
75('universiti malaya', 'Phone:  60 3-7967 7022'),
76('UMP', 'Phone:  60 9-424 5000N'),
77('UITM JASIN', 'Phone:  60 6-264 5000P'),
78('UPM', 'Phone:  60 1-800-22-55'),
79('PERBADANAN PUTRAJAYA', 'Phone:  60 3-8000 8000');
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `students`
85--
86
87CREATE TABLE IF NOT EXISTS `students` (
88  `id` varchar(30) NOT NULL,
89  `sname` varchar(50) NOT NULL
90) ENGINE=MyISAM DEFAULT CHARSET=latin1;
91
92--
93-- Dumping data for table `students`
94--
95
96INSERT INTO `students` (`id`, `sname`) VALUES
97('1', 'Student a'),
98('2', 'Student b');
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `usermaster`
104--
105
106CREATE TABLE IF NOT EXISTS `usermaster` (
107  `username` varchar(50) NOT NULL DEFAULT '',
108  `password` varchar(50) DEFAULT NULL,
109  `userid` varchar(50) DEFAULT NULL,
110  PRIMARY KEY (`username`)
111) ENGINE=MyISAM DEFAULT CHARSET=latin1;
112
113--
114-- Dumping data for table `usermaster`
115--
116
117INSERT INTO `usermaster` (`username`, `password`, `userid`) VALUES
118('admin', 'Administrator', 'admin'),
119('user', 'System User', '123'),
120('mike', '123', 'Mikee'),
121('John', '122', 'johnee'),
122('Tt', 't111', '123'),
123('Tt1', 't111', '123'),
124('Tt51', 't111', '123');