-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `tyqms_lms_test`
--

-- --------------------------------------------------------

--
-- Table structure for table `centre`
--

CREATE TABLE IF NOT EXISTS `centre` (
  `fid` int(20) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `centrename` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `address_line_1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `address_line_2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `add_state` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `postcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `add_country` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `active` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `centre`
--

INSERT INTO `centre` (`fid`, `c_name`, `password`, `centrename`, `address_line_1`, `address_line_2`, `city`, `add_state`, `postcode`, `add_country`, `active`, `deleted`) VALUES
(1, 'HQ', 'HQ12345', 'HQ', '66-1, Jalan Tasik Utama 7, Medan Niaga Tasik Damai,', 'Lakefield, Sg. Besi, ', 'Kuala Lumpur', 'Wilayah Persekutuan', '57000', 'Malaysia', 'Yes', 0),
(2, 'CT', 'CT12345', 'Centre Training', '91-2, Jalan Radin Bagus, ', 'Sri Petaling,', 'KL', 'Wilayah Persekutuan, KL', '57000', 'Malaysia', 'Yes', 0),
(3, 'SP', 'SP12345', 'SP Sri Petaling', '26-1, Jalan 14/149L,', 'Bandar Baru Sri Petaling', 'Sri Petaling', 'Wilayah Persekutuan, KL', '57000', 'Malaysia', 'Yes', 0),
(4, 'OUG', 'OUG12345', 'OUG', '54A, Jalan Hujan Rahmat 2,', 'Taman Overseas Union', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '58200', 'Malaysia', 'Yes', 0),
(5, 'BK', 'BK12345', 'BK Bandar Kinrara', '9-1, Jalan BK5A/3A', 'Bandar Kinrara', 'Puchong', 'Selangor', '47180', 'Malaysia', 'Yes', 0),
(6, 'MC', 'MC12345', 'MC Mahkota Cheras', '47-1, Jalan Temenggung 19/9, Seksyen 9,', 'Bandar Mahkota Cheras', 'Kajang', 'Selangor', '43200', 'Malaysia', 'Yes', 0),
(7, 'TS', 'TS12345', 'TS Taman Segar', '10-M, Jalan Manis Taman Segar 56100 Kuala Lumpur', 'Taman Segar', 'Cheras', 'Wilayah Persekutuan, KL', '56100', 'Malaysia', 'Yes', 0),
(8, 'TE', 'TE12345', 'TE Taman Equine', '12-1, Jalan Equine, ', 'Bandar Putra Permai', 'Seri Kembangan', 'Selangor', '43300', 'Malaysia', 'Yes', 0),
(9, 'BP', 'BP12345', 'BP Bandar Puteri', '17-1, Jalan Puteri 2/3, ', 'Bandar Puteri', 'Puchong', 'Selangor', '47100', 'Malaysia', 'Yes', 0),
(10, 'KD', 'KD12345', 'KD Kota Damansara', 'No 25-3,2nd Floor,Jalan PJU 5/9,Dataran Sunway,', 'Kota Damansara', 'Petaling Jaya', 'Selangor', '47810', 'Malaysia', 'Yes', 0),
(11, 'AD', 'AD12345', 'AD Alam Damai', '12A-1, Jalan Alam Damai 1, Damai 23,', 'Alam Damai', 'Cheras', 'Wilayah Persekutuan, KL', '56000', 'Malaysia', 'Yes', 0),
(12, 'SD', 'SD12345', 'SD Sri Damansara', '33-1, Jalan Ara SD 7/3A, ', '', 'Bandar Sri Damansara', 'Wilayah Persekutuan, KL', '52200', 'Malaysia', 'Yes', 0),
(13, 'AR', 'AR12345', 'AR Ara Damansara', 'G-1-8, Jalan PJU 1A/20E, ', 'Dataran Ara Damansara', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia', 'Yes', 0),
(14, 'USJ', 'USJ12345', 'USJ', '6,1st Floor, Jalan USJ 21/7', '', 'Subang Jaya', 'Selangor', '47630', 'Malaysia', 'Yes', 0),
(15, 'TD', 'TD12345', 'TD Taman Desa', '12-1, Jalan 4/109E, ', 'Desa Business Park,', 'Taman Desa', 'Wilayah Persekutuan, KL', '58000', 'Malaysia', 'Yes', 0),
(16, 'AP', 'AP12345', 'AP Ampang', '3-1, Jalan AWF 2, ', 'Ampang Waterfront', 'Ampang', 'Selangor', '68000', 'Malaysia', 'Yes', 0),
(17, 'SG', 'SG12345', 'SG Sungai Besi', '66-1, Jalan Tasik Utama 7,Medan Niaga Tasik Damai', 'Lakefields', 'Sungai Besi', 'Wilayah Persekutuan, KL', '57000', 'Malaysia', 'Yes', 0),
(18, 'KK', 'KK12345', 'KK Kota Kemuning', '41-2, Jalan Sungai Burung Z32/Z, ', 'Bukit Rimau, Seksyen 32', 'Shah Alam', 'Selangor', '40460', 'Malaysia', 'Yes', 0),
(19, 'KL', 'KL12345', 'KJ Kajang', '20-1, Jalan KP 1/4, ', 'Kajang Prima', 'Kajang', 'Selangor', '43000', 'Malaysia', 'Yes', 0),
(20, 'DJ', 'DJ12345', 'DJ Damansara Jaya', '49B, Jalan SS 22/19,', 'Damansara Jaya', 'Petaling Jaya', 'Selangor', '47400', 'Malaysia', 'Yes', 0),
(21, 'DK', 'DK12345', 'DK Danau Kota', 'B-12-1, Plaza Usahawan Genting Klang,', 'Jalan Danau Niaga 1,', 'Taman Danau Kota,Setapak', 'Wilayah Persekutuan, KL', '53300', 'Malaysia', 'Yes', 0),
(66, 'SB', 'SB12345', 'SB Sungai Buloh', '27A, Jalan BRP 6/12', 'Bukit Rahman Putra', 'Sungai Buloh', 'Selangor', '40160', 'Malaysia', 'Yes', 0),
(22, 'AS', 'AS12345', 'AS Aman Suria Damansara', 'B-2-6, Jalan PJU 1/43, ', 'Aman Suria Damansara', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia', 'Yes', 0),
(23, 'BT', 'BT12345', 'BT Bukit Tinggi', 'No 27-1, Lorong Batu Nilam 21C, ', 'Bandar Bukit Tinggi 2,', 'Klang', 'Selangor', '42100', 'Malaysia', 'Yes', 0),
(24, 'RW', 'RW12345', 'RW Rawang', '19 M, Jalan Bandar Rawang 12,', 'Pusat Bandar Rawang', 'Rawang', 'Selangor', '48000', 'Malaysia', 'Yes', 0),
(25, 'MJ', 'MJ12345', 'MJ Meranti Jaya', '51-2, Block C, Tanming Boulevard,', 'Jalan Meranti Jaya 3/1,', 'Puchong', 'Selangor', '47120', 'Malaysia', 'Yes', 0),
(26, 'SKK', 'SKK12345', 'SKK Kota Kinabalu', 'Lot 11-1, Block B,', 'Plaza Heritage Off Jalan Lintas Luyang,', 'Kota Kinabalu', 'Sabah', '88300', 'Malaysia', 'Yes', 0),
(27, 'KP', 'KP12345', 'KP Kepong', '23-2,Jalan Rimbunan Raya 1', 'Laman Rimbunan ', 'Kepong', 'Wilayah Persekutuan, KL', '52100', 'Malaysia', 'Yes', 0),
(28, 'JBN', 'JBN12345', 'JNB Nusa Bestari', '21-1, Jalan Bestari 1/2', 'Taman Nusa Bestari', 'Johor Bahru', 'Johor', '81200', 'Malaysia', 'Yes', 0),
(29, 'SA', 'SA12345', 'SA Setia Alam', '10-3-1, Jalan Setia Prima P U13/P,', 'Setia Alam Seksyen U13,', 'Shah Alam', 'Selangor', '40170', 'Malaysia', 'Yes', 0),
(30, 'SJ', 'SJ12345', 'SJ Selayang Jaya', '9AB, Jalan SJ6,', 'Taman Selayang Jaya', 'Batu Caves', 'Wilayah Persekutuan, KL', '68100', 'Malaysia', 'Yes', 0),
(31, 'JMA', 'JMA12345', 'JMA Mount Austin', '21-1, Jalan Austin Heights 8/3,', 'Mount Austin,', 'Johor Bahru', 'Johor', '81100', 'Malaysia', 'Yes', 0),
(32, 'PBL', 'PBL12345', 'PBL Bayan Lepas', '57, Persiaran Mahsuri 1/3,', 'Sunway Avenue,', 'Bayan Lepas', 'Pulau Pinang', '11900', 'Malaysia', 'Yes', 0),
(33, 'PTP', 'PTP12345', 'PTP Perak Taiping', '21-1, Jalan Tupai,', '', 'Taiping', 'Perak', '34000', 'Malaysia', 'Yes', 0),
(34, 'BJ', 'BJ12345', 'BJ Bukit Jalil', '27-1, Jalan 16/155C', 'Bukit Jalil', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '57000', 'Malaysia', 'Yes', 0),
(35, 'NSR', 'NSR12345', 'NSR Seremban 2', '8-1, Jalan S2 F1, Garden Homes, ', 'Seremban 2,', 'Seremban,', 'Negeri Sembilan', '70300', 'Malaysia', 'Yes', 0),
(36, 'BS', 'BS12345', 'BS Bukit Serdang', '11-1, Serdang Square, Jalan BS 5/26A,', 'Taman BS Seksyen 5,', 'Seri Kembangan', 'Selangor', '43300', 'Malaysia', 'Yes', 0),
(37, 'SS2', 'SS212345', 'SS2 ', '19B, 2nd Floor, Jalan SS2/55,', '', 'Petaling Jaya', 'Selangor', '47300', 'Malaysia', 'Yes', 0),
(38, 'PTJ', 'PTJ12345', 'PTJ Teras Jaya', '6,1st floor,Lorong Teras Jaya 9,', '', 'Butterworth', 'Pulau Pinang', '13400', 'Malaysia', 'Yes', 0),
(39, 'SY', 'SY12345', 'SY Semenyih', '6-1, Jalan 5/8, Bandar Rinching,', '', 'Semenyih', 'Selangor', '43500', 'Malaysia', 'Yes', 0),
(40, 'PM', 'PM12345', 'PM Permaisuri', '41-1, Jalan Sri Permaisuri 8,', 'Bandar Sri Permaisuri,', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '56000', 'Malaysia', 'Yes', 0),
(41, 'SC', 'SC12345', 'SC Sg Chua', '43A-1, Jalan Pasir Emas,', 'Sg Chua Pearl Avenue,', 'Kajang', 'Selangor', '43000', 'Malaysia', 'Yes', 0),
(42, 'TM', 'TM12345', 'TM Taman Muda', '45A-1, 1st Floor, Jalan Bunga Tanjung 18,', 'Taman Muda', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '56100', 'Malaysia', 'Yes', 0),
(43, 'BL', 'BL12345', 'BL Balakong', '5, 1st Floor, Jalan J-Avenue,', 'J-Avenue,', 'Cheras', 'Selangor', '43200', 'Malaysia', 'Yes', 0),
(44, 'SS14', 'SS1412345', 'SS14 ', '94B, 2nd Floor, Jalan SS 14/1,', '', 'Subang Jaya', 'Selangor', '47500', 'Malaysia', 'Yes', 0),
(45, 'ST', 'ST12345', 'ST Sentul', '17-3, Jalan 11/48A,', 'Sentul Boulevard off Jalan Ipoh,', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '51000', 'Malaysia', 'Yes', 0),
(46, 'JMR', 'JMR12345', 'JMR Muar', '29-7, Tingkat 1, Jalan Pesta 1/2,', 'Kg Ken Tun Dr Ismail,', 'Muar', 'Johor', '84000', 'Malaysia', 'Yes', 0),
(47, 'SH', 'SH12345', 'SH Sri Hartamas', '28-1, Jalan 25/70A,', 'Desa Sri Hartamas,', 'Kuala Lumpur', 'Wilayah Persekutuan', '50480', 'Malaysia', 'Yes', 0),
(48, 'EA', 'EA12345', 'EA Taman Eng Ann', '17A, Lorong Kasawari 4,', 'Taman Eng Ann,', 'Klang', 'Selangor', '41150', 'Malaysia', 'Yes', 0),
(49, 'PL', 'PL12345', 'PL Bandar Parkland', '9-1, Jalan Delima 18/KS9,', 'Bandar Parkland,', 'Klang', 'Selangor', '41200', 'Malaysia', 'Yes', 0),
(50, 'SPK', 'SPK12345', 'SPK KIDOLAND', '9-1, Jalan 13/149L, Sri Petaling,', '', 'Kuala Lumpur', 'Wilayah Persekutuan, KL', '57000', 'Malaysia', 'Yes', 0),
(51, 'JL', 'JL12345', 'JL Puncak Jalil', '60-1, Jalan PUJ 3/2, Taman Puncak Jalil,', '', 'Seri Kembangan', 'Selangor', '43300', 'Malaysia', 'Yes', 0),
(52, 'DEV', 'DEV12345', 'DEV Developer Centre', 'No-1, Jalan Salak South 1', '', '', 'Wilayah Persekutuan, KL', '57100', 'Malaysia', 'Yes', 0),
(53, 'BM', 'BM12345', 'BM Bandar Menjalara', '38-1, Jalan 8/62A,', 'Bandar Menjalara,', 'Kepong', 'Johor', '52200', 'Malaysia', 'Yes', 0),
(54, 'JBP', 'JBP12345', 'JBP Batu Pahat', '62A, Jalan Susur Perdana Tengah, ', 'Taman Bukit Perdana 2,', 'Batu Pahat', 'Johor', '83000', 'Malaysia', 'Yes', 0),
(55, 'JKL', 'JKL12345', 'JKL Kulai', '267A, Jalan Kenanga 29/8,', 'Taman Indahpura,', 'Kulai', 'Johor', '81000', 'Malaysia', 'Yes', 0),
(58, 'MT', 'MT12345', 'MT Mastiara', '22-1, Jalan 6/18A, ', 'Taman Mastiara,', 'Kuala Lumpur', 'Johor', '51200', 'Malaysia', 'Yes', 0),
(60, 'RKC', 'RKC12345', 'RKC Kuching Bormil', '1st Floor, Lot 3025, Jalan Tun Ahmad Zaidi Adruce', 'Bormill Commercial Centre', 'Kuching', 'Sarawak', '93250', 'Malaysia', 'Yes', 0),
(61, 'BBR', 'BBR12345', 'BBR Bukit Raja', '25-1, Jalan Makyong 5A/KU 5, Bandar Bukit Raja,', '', 'Klang', 'Selangor', '41050', 'Malaysia', 'Yes', 0),
(62, 'BA', 'BA12345', 'BA Banting Klang', '3-1, Jalan Seri Pekan, Medan Jalan Cempaka,', '', 'Banting', 'Selangor', '42700', 'Malaysia', 'Yes', 0),
(63, 'TK', 'TK12345', 'TK Taman Kinrara', '44B, Jalan TK1/11A', 'Taman Kinrara Seksyen 1', 'Puchong', 'Selangor', '47100', 'Malaysia', 'Yes', 0),
(64, 'RMR', 'RMR12345', 'RMR Miri ', ' Tingkat 1, Lot 1315, Jalan Jee Foh 2', '', 'Miri', 'Sarawak', '98000', 'Malaysia', 'Yes', 0),
(65, 'RSR', 'RSR12345', 'RSR Kuching Saradise', 'Level 3, Sublot 31, Block A2 Lot 19544', 'Saradise Jalan Stutong', 'Kuching', 'Sarawak', '93350', 'Malaysia', 'Yes', 0),
(67, 'PH', 'PH12345', 'PH Putra Heights', '7-1, Jalan Putra Mahkota 7/5C,', 'Putra Point Business Centre, Putra Heights,', 'Subang Jaya', 'Selangor', '47650', 'Malaysia', 'Yes', 0);

-- --------------------------------------------------------

--
-- Table structure for table `form`
--

CREATE TABLE IF NOT EXISTS `form` (
  `form_id` int(20) NOT NULL AUTO_INCREMENT,
  `centrename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `englishname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `chinesename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `line1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `line2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `postcode` int(20) NOT NULL,
  `homephone` int(30) NOT NULL,
  `birthdate` datetime NOT NULL,
  `age` int(11) NOT NULL,
  `gender` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `allergy` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `emergencynumber` int(30) NOT NULL,
  `emergencyperson` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `school` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fathername` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fphone` int(30) NOT NULL,
  `femail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mothername` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mphone` int(30) NOT NULL,
  `memail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sname1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sage1` int(20) NOT NULL,
  `sname2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sage2` int(20) NOT NULL,
  `sname3` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sage3` int(20) NOT NULL,
  `date` datetime(6) NOT NULL,
  PRIMARY KEY (`form_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `form`
--

INSERT INTO `form` (`form_id`, `centrename`, `englishname`, `chinesename`, `line1`, `line2`, `state`, `city`, `postcode`, `homephone`, `birthdate`, `age`, `gender`, `allergy`, `emergencynumber`, `emergencyperson`, `school`, `lang`, `fathername`, `fphone`, `femail`, `mothername`, `mphone`, `memail`, `sname1`, `sage1`, `sname2`, `sage2`, `sname3`, `sage3`, `date`) VALUES
(1, 'HQ', 'Woo Chien Ming', 'ZZ', 'ZZ', 'ZZ', 'ZZ', 'ZZ', 55, 55, '2013-02-02 00:00:00', 6, 'male', 'ZZ', 13, 'AZ', 'ZZ', 'Mandarin', 'ZZ', 0, 'zz', 'ZZ', 0, 'ZZ', '', 0, '', 0, '', 0, '0000-00-00 00:00:00.000000'),
(2, 'HQ', 'Woo Chien Ming', 'ZZ', 'ZZ', 'ZZ', 'ZZ', 'ZZ', 55, 55, '2013-02-02 00:00:00', 6, 'male', 'ZZ', 13, 'AZ', 'ZZ', 'Mandarin', 'ZZ', 0, 'zz', 'ZZ', 0, 'ZZ', '', 0, '', 0, '', 0, '2019-04-18 04:50:56.000000'),
(3, 'HQ', 'wOO', 'WW', 'WW', 'WW', 'WW', 'WW', 555, 555, '2013-02-02 00:00:00', 6, 'male', 'W', 5, 'W', 'W', 'Mandarin', 'W', 5, 'W', 'W', 5, 'W', '', 0, '', 0, '', 0, '2019-04-18 06:10:08.000000');

-- --------------------------------------------------------

--
-- Table structure for table `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `test_id` int(100) NOT NULL AUTO_INCREMENT,
  `form_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `total` int(100) DEFAULT NULL,
  `total1` int(100) DEFAULT NULL,
  `totalp` int(100) DEFAULT NULL,
  PRIMARY KEY (`test_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`test_id`, `form_id`, `lang`, `level`, `total`, `total1`, `totalp`) VALUES
(1, 'loon', 'Chinese', '大卡测试', 1, NULL, 1),
(2, 'loon', 'Chinese', 'Level1', 1, NULL, 0),
(3, 'loon', 'English', 'Phonics Stage1', 1, 1, 5);

-- --------------------------------------------------------

--
-- Table structure for table `testform`
--

CREATE TABLE IF NOT EXISTS `testform` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `centrename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `age` int(100) NOT NULL,
  `gender` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `testform`
--

INSERT INTO `testform` (`id`, `centrename`, `level`, `name`, `age`, `gender`, `date`) VALUES
(1, 'HQ', NULL, 'loon', 5, 'male', '2019-07-19 07:44:36.000000'),
(2, 'HQ', NULL, 'loon', 6, 'male', '2019-07-19 09:32:48.000000'),
(3, 'HQ', NULL, 'loon', 3, 'male', '2019-07-19 09:42:54.000000');
COMMIT;

