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

START TRANSACTION;



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

--
-- 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;

