-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- 主機： 127.0.0.1
-- 產生時間： 2024-03-26 22:38:05
-- 伺服器版本： 10.4.27-MariaDB
-- PHP 版本： 8.2.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 資料庫： `test`
--

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

--
-- 資料表結構 `mtr`
--

CREATE TABLE `mtr` (
  `stno` int(11) NOT NULL,
  `code` char(3) NOT NULL,
  `ename` char(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 傾印資料表的資料 `mtr`
--

INSERT INTO `mtr` (`stno`, `code`, `ename`) VALUES
(1, 'CEN', 'Central'),
(2, 'ADM', 'Admiralty'),
(3, 'TST', 'Tsim Sha Tsui'),
(4, 'JOR', 'Jordan'),
(5, 'YMT', 'Yau Ma Tei'),
(6, 'MOK', 'Mong Kok'),
(7, 'SKM', 'Shek Kip Mei'),
(8, 'KOT', 'Kowloon Tong'),
(9, 'LOF', 'Lok Fu'),
(10, 'WTS', 'Wong Tai Sin'),
(11, 'DIH', 'Diamond Hill'),
(12, 'CHH', 'Choi Hung'),
(13, 'KOB', 'Kowloon Bay'),
(14, 'NTK', 'Ngau Tau Kok'),
(15, 'KWT', 'Kwun Tong'),
(16, 'PRE', 'Prince Edward'),
(17, 'SSP', 'Sham Shui Po'),
(18, 'CSW', 'Cheung Sha Wan'),
(19, 'LCK', 'Lai Chi Kok'),
(20, 'MEF', 'Mei Foo'),
(21, 'LAK', 'Lai King'),
(22, 'KWF', 'Kwai Fong'),
(23, 'KWH', 'Kwai Hing'),
(24, 'TWH', 'Tai Wo Hau'),
(25, 'TSW', 'Tsuen Wan'),
(26, 'SHW', 'Sheung Wan'),
(27, 'WAC', 'Wan Chai'),
(28, 'CAB', 'Causeway Bay'),
(29, 'TIH', 'Tin Hau'),
(30, 'FOH', 'Fortress Hill'),
(31, 'NOP', 'North Point'),
(32, 'QUB', 'Quarry Bay'),
(33, 'TAK', 'Tai Koo'),
(34, 'SWH', 'Sai Wan Ho'),
(35, 'SKW', 'Shau Kei Wan'),
(36, 'HFC', 'Heng Fa Chuen'),
(37, 'CHW', 'Chai Wan'),
(38, 'LAT', 'Lam Tin'),
(39, 'HOK', 'Hong Kong'),
(40, 'KOW', 'Kowloon'),
(41, 'OLY', 'Olympic'),
(42, 'TSY', 'Tsing Yi'),
(43, 'TUC', 'Tung Chung'),
(44, 'HOK', 'Hong Kong'),
(45, 'KOW', 'Kowloon'),
(46, 'TSY', 'Tsing Yi'),
(47, 'AIR', 'Airport'),
(48, 'YAT', 'Yau Tong'),
(49, 'TIK', 'Tiu Keng Leng'),
(50, 'TKO', 'Tseung Kwan O'),
(51, 'HAH', 'Hang Hau'),
(52, 'POA', 'Po Lam'),
(53, 'NAC', 'Nam Cheong'),
(54, 'SUN', 'Sunny Bay'),
(55, 'DIS', 'Disneyland Resort'),
(56, 'AWE', 'AsiaWorld-Expo'),
(57, 'LHP', 'LOHAS Park'),
(64, 'HUH', 'Hung Hom'),
(65, 'MKK', 'Mong Kok East'),
(67, 'TAW', 'Tai Wai'),
(68, 'SHT', 'Sha Tin'),
(69, 'FOT', 'Fo Tan'),
(70, 'RAC', 'Racecourse'),
(71, 'UNI', 'University'),
(72, 'TAP', 'Tai Po Market'),
(73, 'TWO', 'Tai Wo'),
(74, 'FAN', 'Fanling'),
(75, 'SHS', 'Sheung Shui'),
(76, 'LOW', 'Lo Wu'),
(78, 'LMC', 'Lok Ma Chau'),
(80, 'ETS', 'East Tsim Sha Tsui'),
(81, 'SYP', 'Sai Ying Pun'),
(82, 'HKU', 'HKU'),
(83, 'KET', 'Kennedy Town'),
(84, 'HOM', 'Ho Man Tin'),
(85, 'WHA', 'Whampoa'),
(86, 'OCP', 'Ocean Park'),
(87, 'WCH', 'Wong Chuk Hang'),
(88, 'LET', 'Lei Tung'),
(89, 'SOH', 'South Horizons'),
(90, 'HIK', 'Hin Keng'),
(91, 'KAT', 'Kai Tak'),
(92, 'SUW', 'Sung Wong Toi'),
(93, 'TKW', 'To Kwa Wan'),
(94, 'EXC', 'Exhibition Centre'),
(96, 'CKT', 'Che Kung Temple'),
(97, 'STW', 'Sha Tin Wai'),
(98, 'CIO', 'City One'),
(99, 'SHM', 'Shek Mun'),
(100, 'TSH', 'Tai Shui Hang'),
(101, 'HEO', 'Heng On'),
(102, 'MOS', 'Ma On Shan'),
(103, 'WKS', 'Wu Kai Sha'),
(111, 'AUS', 'Austin'),
(114, 'TWW', 'Tsuen Wan West'),
(115, 'KSR', 'Kam Sheung Road'),
(116, 'YUL', 'Yuen Long'),
(117, 'LOP', 'Long Ping'),
(118, 'TIS', 'Tin Shui Wai'),
(119, 'SIH', 'Siu Hong'),
(120, 'TUM', 'Tuen Mun'),
(888, 'HWK', 'HK West Kowloon');

--
-- 已傾印資料表的索引
--

--
-- 資料表索引 `mtr`
--
ALTER TABLE `mtr`
  ADD PRIMARY KEY (`stno`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
