4 Database free

-- Table structure for table `admin`
--
DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin_user` varchar(30) NOT NULL,
`admin_pass` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `admin_user`, `admin_pass`) VALUES
(1, 'admin', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `booking`
--
DROP TABLE IF EXISTS `booking`;
CREATE TABLE IF NOT EXISTS `booking` (
`M_code` varchar(11) DEFAULT NULL,
`C_name` varchar(6) DEFAULT NULL,
`E_name` varchar(13) DEFAULT NULL,
`IC` varchar(14) DEFAULT NULL,
`H_phone` int(11) DEFAULT NULL,
`HP_phone` bigint(20) DEFAULT NULL,
`Student` varchar(11) DEFAULT NULL,
`Booking` varchar(4) DEFAULT NULL,
`B_date` varchar(19) DEFAULT NULL,
`B_time_from` varchar(19) DEFAULT NULL,
`B_time_to` varchar(19) DEFAULT NULL,
`Price` tinyint(4) DEFAULT NULL,
`Member` varchar(5) DEFAULT NULL,
`Expired` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `booking`
--
INSERT INTO `booking` (`M_code`, `C_name`, `E_name`, `IC`, `H_phone`, `HP_phone`, `Student`, `Booking`, `B_date`, `B_time_from`, `B_time_to`, `Price`, `Member`, `Expired`) VALUES
('MYC-S070001', 'ºÎÐÒÒæ', 'HO SIN AIK', '831122-13-5139', 84314164, 168965445, 'Non-Student', 'B002', '2011-03-04 00:00:00', '1899-12-30 10:59:37', '1899-12-30 11:59:37', 10, 'False', 'No-Expired'),
('MYC-S070002', 'ÍõÀí¸Ù', 'WONG LEE KHAN', '881010-52-5031', 323625, 128809474, 'Student', 'G001', '2011-03-05 00:00:00', '1899-12-30 16:08:49', '1899-12-30 17:08:49', 8, 'False', 'No-Expired');
-- --------------------------------------------------------
--
-- Table structure for table `facility`
--
DROP TABLE IF EXISTS `facility`;
CREATE TABLE IF NOT EXISTS `facility` (
`Facility_code` varchar(4) DEFAULT NULL,
`Facility_name` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `facility`
--
INSERT INTO `facility` (`Facility_code`, `Facility_name`) VALUES
('B001', 'Basketball'),
('B002', 'Badminton'),
('P001', 'Ping Pong'),
('G001', 'Gym'),
('K001', 'Karaoke'),
('D001', 'Dance Room');
-- --------------------------------------------------------
--
-- Table structure for table `history`
--
DROP TABLE IF EXISTS `history`;
CREATE TABLE IF NOT EXISTS `history` (
`m_code` varchar(11) DEFAULT NULL,
`m_c_name` varchar(8) DEFAULT NULL,
`m_e_name` varchar(32) DEFAULT NULL,
`IC` varchar(14) DEFAULT NULL,
`DOB` varchar(19) DEFAULT NULL,
`Religious` varchar(21) DEFAULT NULL,
`Council` varchar(17) DEFAULT NULL,
`Join_date` varchar(19) DEFAULT NULL,
`Old_Received_no` varchar(6) DEFAULT NULL,
`Expired_date` varchar(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `history`
--
INSERT INTO `history` (`m_code`, `m_c_name`, `m_e_name`, `IC`, `DOB`, `Religious`, `Council`, `Join_date`, `Old_Received_no`, `Expired_date`) VALUES
('MYC-S070002', 'ÍõÀí¸Ù', 'WONG LEE KHAN', '881010-52-5031', '1988-10-10 00:00:00', 'Christian - Methodist', '', '2007-06-05 00:00:00', 'E50301', '2008-06-04 00:00:00'),
('MYC-S070003', 'µËÁ¦ÕÃ', 'LESLIE TENG LIK CHANG', '880304-52-6473', '1988-04-03 00:00:00', 'Christian - Methodist', 'ÎÀ˹ÀíÌÃ', '2007-06-05 00:00:00', '50302', '2008-06-04 00:00:00'),
('MYC-S070004', '·¶´«²¨', 'DANNY HUANG DUNG PO', '880530-13-5059', '1988-05-30 00:00:00', 'Christian - Methodist', '', '2007-06-05 00:00:00', '50303', '2008-06-04 00:00:00'),
('MYC-SS07005', 'Áõ¾ÃÔ´', 'ROGER LAU JIU YUAN', '880725-52-5751', '1988-07-25 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-06-05 00:00:00', '50304', '2008-06-04 00:00:00'),
('MYC-S070006', 'ÁÖΰ׳', 'LIM WEI CHUAN', '881028-13-5437', '1988-10-28 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-06-05 00:00:00', '50306', '2008-06-04 00:00:00'),
('MYC-S070009', '³Â¼Æ˳', 'TING CHEE SOON', '890419-13-6837', '1989-04-19 00:00:00', 'Christian - Methodist', 'и£Ô´ÌÃ', '2007-06-15 00:00:00', '50309', '2008-06-14 00:00:00'),
('MYC-S070011', 'ÁÖçë½Ý', 'DANNY LIM BENG KIAT', '920406-13-5813', '1992-04-06 00:00:00', 'None', '', '2007-06-16 00:00:00', '50311', '2008-06-15 00:00:00'),
('MYC-S070012', 'Áõ¾ÃÕý', 'MALCOLM LAU JIN ZHENG', '920127-13-6071', '1992-01-27 00:00:00', 'Christian - Methodist', '»³°²ÌÃ', '2007-06-16 00:00:00', '50312', '2008-06-15 00:00:00'),
('MYC-S070015', 'ÁºÇìÍþ', 'VICTOR LIONG CHIN WEE', '870719-52-5801', '1987-07-19 00:00:00', 'Christian - Methodist', '¾ÈÖ÷ÌÃ', '2007-06-28 00:00:00', '50316', '2008-06-27 00:00:00'),
('MYC-S070018', 'Áõ¹§ÐÅ', 'JOEL LAU KUN SING', '871016-52-6167', '1987-10-16 00:00:00', 'Christian - Methodist', '»³°²ÌÃ', '2007-07-05 00:00:00', '50319', '2008-07-04 00:00:00'),
('MYC-S070021', 'κ˳µä', 'NGUI SOON TIENG', '830306-13-5681', '1983-06-06 00:00:00', 'Christian - Methodist', 'Îý°²ÌÃ', '2007-07-11 00:00:00', '50322', '2008-07-10 00:00:00'),
('MYC-S070032', '»ÆÀñ¿ª', 'BILLY WONG LEH KAI', '851103-13-5721', '1985-11-03 00:00:00', 'Christian - Methodist', 'ÎÀ˹ÀñÌÃ', '2007-07-18 00:00:00', '50336', '2008-07-17 00:00:00'),
('MYC-S070037', 'ÁøÃÀÈã', 'LIEW MEE YUNG', '800212-13-5640', '1980-02-12 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-07-20 00:00:00', '50342', '2008-07-19 00:00:00'),
('MYC-S070048', 'Ö£ÓÑÃ÷', 'TANG YEW MING', '851107-13-6473', '1985-11-07 00:00:00', 'Christian - Methodist', 'и£Ô´ÌÃ', '2007-07-25 00:00:00', '50354', '2008-07-24 00:00:00'),
('MYC-S070060', 'ÇñÊçÔÆ', 'KIU SUK HUNG', '890923-13-6086', '1989-09-23 00:00:00', 'None', '', '2007-08-01 00:00:00', '50367', '2008-07-31 00:00:00'),
('MYC-S080553', '½¯ÓÑÍú', 'CHIONG YEW WONG', '900330-13-5605', '1990-03-30 00:00:00', 'Christian - Methodist', 'Ê¥¹âÌÃ', '2009-12-09 00:00:00', '43964', '2010-12-09 00:00:00'),
('MYC-S101283', '»ÆÓÀºÀ', 'DANIEL WONG INN HO', '841208-13-5649', '1984-12-08 00:00:00', 'None', '', '2010-02-10 00:00:00', '44063', '2011-02-10 00:00:00'),
('MYC-S070061', 'ÖÜÍðñÄ', 'IRENE CHEW WANG NA', '850314-13-5540', '1985-03-14 00:00:00', 'Buddhism', '', '2007-08-03 00:00:00', '50368', '2008-08-02 00:00:00'),
('MYC-S070188', 'Õų©ÓÓ', 'TIONG CHANG YAW', '901117-13-6023', '1990-11-17 00:00:00', 'Christian - Methodist', 'Îý°²ÌÃ', '2007-11-09 00:00:00', '62861', '2008-11-08 00:00:00'),
('MYC-S070193', 'ÁõÓþù', 'LAU YUNG KIM', '910622-13-6117', '1991-06-22 00:00:00', 'Christian - Methodist', 'Îý°²ÌÃ', '2007-11-11 00:00:00', '62866', '2008-11-10 00:00:00'),
('MYC-S070200', '»ÆÏ齨', 'WONG SIONG KIONG', '870822-13-5449', '1987-08-22 00:00:00', 'Christian - Methodist', '', '2007-11-27 00:00:00', '62893', '2008-11-26 00:00:00'),
('MYC-S070214', 'ËïÕñÑô', 'LAWRENCE SOON ZHEN YANG', '820613-13-5359', '1982-06-13 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-11-20 00:00:00', '62881', '2008-11-19 00:00:00'),
('MYC-S070217', 'ÏÄТԴ', 'HAH HOW GUANG', '930708-13-5869', '1993-07-08 00:00:00', 'None', '', '2007-12-06 00:00:00', '62900', '2008-12-05 00:00:00'),
('MYC-S070218', 'ÏÄТΰ', 'HAH HOW UNG', '910613-13-6063', '1991-03-16 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-12-06 00:00:00', '63101', '2008-12-05 00:00:00'),
('MYC-S070223', '³ØÐÅÒ«', 'JOSEPH TIE SING YEW', '901224-13-5835', '1990-12-24 00:00:00', 'Christian - Methodist', '³ÇÊзáÊÕ', '2007-12-21 00:00:00', '63120', '2008-12-20 00:00:00'),
('MYC-S070224', 'ÁÖ¸£ÐÇ', 'LIM HOCK SING', '860921-52-6825', '1986-09-21 00:00:00', 'Christian - Methodist', 'ÌìÎýÌÃ', '2007-12-31 00:00:00', '63121', '2008-12-30 00:00:00'),
('MYC-S070225', 'ÁÖ¸£ÒÚ', 'LIM KOCK YII', '910128-13-6189', '1991-01-28 00:00:00', 'Christian - Methodist', 'ÌìÎýÌÃ', '2007-12-31 00:00:00', '63122', '2008-12-30 00:00:00'),
('MYC-S070227', 'ÁÖ¸£Íò', 'LIM HOCK WAN', '910128-13-6031', '1991-01-28 00:00:00', 'Christian - Methodist', 'ÌìÎýÌÃ', '2007-12-31 00:00:00', '63124', '2008-12-30 00:00:00'),
('MYC-S070228', 'Ïôи»', 'SIAW SING HO', '890118-13-5881', '1989-01-18 00:00:00', 'Christian - Methodist', 'ÌìÎýÌÃ', '2007-12-31 00:00:00', '63125', '2008-12-30 00:00:00'),
('MYC-S080229', 'ÁÖ×ÚÏÍ', 'ARTHUR LING JONG SHIEN', '911221-135783', '1991-12-21 00:00:00', 'Christian - Methodist', 'Ê«Î×Êн̻á', '2008-01-18 00:00:00', '63128', '2009-01-17 00:00:00'),
('MYC-S070236', 'ÁõÀûÇà', 'LAU LEE CHING', '891222-13-6168', '1989-12-22 00:00:00', 'Christian - Methodist', '', '2007-09-22 00:00:00', '62804', '2008-09-21 00:00:00'),
('MYC-S070237', '³ÂÓñÁá', 'CONNIE CHIN EK LING', '870512-52-6348', '1987-05-12 00:00:00', 'None', '', '2007-12-27 00:00:00', '63112', '2008-12-26 00:00:00'),
('MYC-S070238', 'ÌÆ»ÛÁè', 'DONG HUI LING', '870826-13-5550', '1987-08-26 00:00:00', 'Christian - Methodist', 'Ê¥µÀÌÃ', '2007-12-27 00:00:00', '63114', '2008-12-26 00:00:00'),
('MYC-S080240', 'ÎâÓýÁ¼', 'MARTIN NGU YIIK LUNG', '911003-13-6067', '1991-10-03 00:00:00', 'Catholic', 'Ê¥ÐÄÌÃ', '2008-01-25 00:00:00', '63132', '2009-01-24 00:00:00'),
('MYC-S080242', 'ÑԴ', 'YONG HUO NGUON', '910126-13-5895', '1991-01-26 00:00:00', 'Christian - Methodist', '°®ÃñÌÃ', '2008-02-17 00:00:00', '63143', '2009-02-16 00:00:00'),
('MYC-S080250', 'Öìѧ½', 'CHUO KOCK LUK', '840308-13-6329', '1984-03-08 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2008-03-01 00:00:00', '63151', '2009-03-01 00:00:00'),
('MYC-S070255', 'Ôø¼ÍÊ¢', 'CHANG CHEE SENG', '910102-13-5903', '1991-01-02 00:00:00', 'Christian - Methodist', '»³°²ÌÃ', '2007-11-24 00:00:00', '62886', '2008-11-23 00:00:00'),
('MYC-S070202', 'ÁÖÐãϼ', 'CHRISTIME LIM SHIEW HSIA', '910511-13-6018', '1991-05-11 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-08-04 00:00:00', '50371', '2008-08-03 00:00:00'),
('MYC-S070256', 'ÔøÀö°²', 'CHAN LIH ANN', '880703-13-5074', '1988-07-03 00:00:00', 'Christian - Methodist', '»³°²ÌÃ', '2007-11-24 00:00:00', '62887', '2008-11-23 00:00:00'),
('MYC-S070124', '³Ì½øè°', 'TIANG JING CHEONG', '850205-13-5197', '1985-02-05 00:00:00', 'Christian - Others', 'µØ·½½Ì»á', '2007-08-17 00:00:00', '50851', '2008-08-16 00:00:00'),
('MYC-S070125', 'Áõ¼Ò¸»', 'LIEW KAH FU', '850417-13-5543', '1985-04-17 00:00:00', 'Christian - Others', 'µØ·½½Ì»á', '2007-08-28 00:00:00', '50852', '2008-08-27 00:00:00'),
('MYC-S070134', '³ÂÓ¨Áä', 'VIVIAN TING YIN LING', '911108-13-5730', '1991-11-08 00:00:00', 'Christian - Methodist', 'ÍòÃñÌÃ', '2007-08-29 00:00:00', '50861', '2008-08-28 00:00:00'),
('MYC-S070128', 'ëÎÄæ¼', 'MOH UNG JIE', '880126-52-5426', '1988-01-26 00:00:00', 'Christian - Methodist', 'Ê«Î×Êн̻á', '2007-08-29 00:00:00', '50856', '2008-08-28 00:00:00'),
('MYC-S070135', '»ÆÓñƼ', 'WONG NYIIK PING', '910622-13-5300', '1991-09-22 00:00:00', 'Buddhism', '', '2007-08-29 00:00:00', '50862', '2008-08-28 00:00:00'),
('MYC-S070136', 'ÁõÊÀ¿', 'CHRISTOPHER LAU SIE KAI', '930806-13-6099', '1993-08-06 00:00:00', 'Christian - Methodist', '»³°²ÌÃ', '2007-11-24 00:00:00', '62888', '2008-11-23 00:00:00'),
('MYC-S070140', 'ÁÖÖÒÀñ', 'LING TIONG LEH', '890415-13-6493', '1989-04-04 00:00:00', 'Catholic', '', '2007-08-30 00:00:00', '50871', '2008-08-29 00:00:00'),
('MYC-SS07014', 'ÑÈÙ', 'YONG HUA YIING', '881020-13-5299', '1988-10-20 00:00:00', 'Christian - Methodist', 'Ê¥µÀÌÃ', '2007-08-30 00:00:00', '50872', '2008-08-29 00:00:00'),
('MYC-S070142', '»Æ¾§¾§', 'WONG GING GING', '911030-13-5852', '1991-10-30 00:00:00', 'Christian - Methodist', '°®ÃñÌÃ', '2007-08-30 00:00:00', '50873', '2008-08-29 00:00:00'),
('MYC-S070149', 'Óá±ÌæÃ', 'YII PING TING', '840319-13-5196', '1984-03-19 00:00:00', 'Christian - Methodist', 'и£Ô´ÌÃ', '2007-08-31 00:00:00', '50884', '2008-08-30 00:00:00'),
('MYC-S070150', 'ÁֳɸÕ', 'JACKIE LING SING KONG', '900813-13-7973', '1990-08-13 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-09-01 00:00:00', '50886', '2008-08-31 00:00:00'),
('MYC-S070151', 'ÁÖ³Çʯ', 'JOE LING SING SU', '921201-13-6139', '1992-12-01 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-09-01 00:00:00', '50887', '2008-08-31 00:00:00'),
('MYC-S070152', '½×Ú²¨', 'KELVIN KONG CHUNG POH', '900703-13-8035', '1990-07-03 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2007-09-03 00:00:00', '50888', '2008-09-02 00:00:00'),
('MYC-S080479', '»ÆÃô³Ç', 'RAYMOND WONG MING SIANG', '860501-13-6175', '1996-05-01 00:00:00', 'Christian - Methodist', 'Ê¥µÀÌÃ', '2009-11-19 00:00:00', '43921', '2010-11-19 00:00:00'),
('MYC-S091157', 'Ö£¹çÒæ', 'RONNIE TANG GUI YIK', '970307-13-5901', '1997-03-07 00:00:00', 'Christian - Others', '³ÇÊзáÊÕ', '2009-10-08 00:00:00', '43858', '2010-10-08 00:00:00'),
('MYC-S080222', 'ÀîͬÐÄ', 'LEE TUNG SING', '850618-13-5611', '1985-06-18 00:00:00', 'Christian - Methodist', '¾ÈÖ÷ÌÃ', '2009-06-06 00:00:00', '63648', '2010-06-06 00:00:00'),
('MYC-S070002', 'ÍõÀí¸Ù', 'WONG LEE KHAN', '881010-52-5031', '1988-10-10 00:00:00', 'None', '', '2008-06-14 00:00:00', '63253', '2009-06-14 00:00:00'),
('MYC-S080452', '³ÌìõÁØ', 'JOSEPH TIANG TING LING', '930612-13-5805', '1993-06-12 00:00:00', 'Christian - Methodist', '¸£Ô´ÌÃ', '2008-08-09 00:00:00', '00909', '2009-08-09 00:00:00'),
('MYC-S090854', 'ÁÖÐÂ˳', 'RONY LING SING SUNG', '941105-13-5935', '1994-11-05 00:00:00', 'Christian - Methodist', 'и£Ô´ÌÃ', '2009-02-12 00:00:00', '01244', '2010-02-12 00:00:00'),
('MYC-S090855', 'ÁÖ¹úºÆ', 'LING KUOK HOU', '940505-13-6131', '1994-05-05 00:00:00', 'Christian - Methodist', 'и£Ô´ÌÃ', '2009-02-12 00:00:00', '01245', '2010-02-12 00:00:00'),
('MYC-S101297', 'Ö£ÖÐÈÙ', 'TANG JONG RONG', '920722-13-5719', '1992-07-22 00:00:00', 'Christian - Methodist', '°®ÃñÌÃ', '2010-02-25 00:00:00', '44082', '2011-02-25 00:00:00'),
('MYC-S091179', '¸µ±¾Â¡', 'HOO PUONG LONG', '920402-13-6085', '1992-04-02 00:00:00', 'Buddhism', '', '2009-11-06 00:00:00', '43895', '2010-11-06 00:00:00'),

Click to expand...