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

START TRANSACTION;



--
-- Database: `db_web-rail`
--

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(10) NOT NULL,
  `names` varchar(500) NOT NULL,
  `detail` varchar(10000) NOT NULL,
  `dates` varchar(100) NOT NULL,
  `img` varchar(500) NOT NULL,
  `link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `names`, `detail`, `dates`, `img`, `link`) VALUES
(1, 'TSSSSS', 'sssss', 'sssssssss', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSvkUFmp5jSF-DhrD5102bzHU7RbidetfqYfA&s', ''),
(3, 'Kamalasai Robotics #10', 'งานปีนี้ครบรอบ 10 ปี ', '20-31 ตุลาคม 2568', 'https://d3g5ywftkpzr0e.cloudfront.net/wp-content/uploads/2023/07/13220529/Artificial-Intelligence-in-Indonesia-The-current-state-and-its-opportunities.jpeg', 'https://chatgpt.com/c/67234601-2614-800a-8882-571f501b3fe7'),
(4, '', '', '', '', '');

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

--
-- Table structure for table `person`
--

CREATE TABLE `person` (
  `id` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL,
  `phone_num` varchar(100) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `img` varchar(500) NOT NULL,
  `row` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `person`
--

INSERT INTO `person` (`id`, `name`, `role`, `phone_num`, `Email`, `img`, `row`) VALUES
(36, 'Jaturong Kamonlert', 'Professional Level Teachers (K 3 Teachers)', '-', 'jaturong@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/07%E0%B8%88%E0%B8%95%E0%B8%B8%E0%B8%A3%E0%B8%87%E0%B8%84%E0%B9%8C-1.jpg', '3'),
(37, 'นายพลกฤษณ์ รินรทึก', 'Professional Level Teachers (K 3 Teachers)', '-', '-', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/%E0%B8%9E%E0%B8%A5%E0%B8%81%E0%B8%A4%E0%B8%A9%E0%B8%93%E0%B9%8C-1.png', '3'),
(38, 'Sararit Phothirat', 'Professional Level Teachers (K 3 Teachers)', '-', 'sararit@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/02%E0%B8%AA%E0%B8%B2%E0%B8%A3%E0%B8%A4%E0%B8%97%E0%B8%98%E0%B8%B4%E0%B9%8C-1.jpg', '3'),
(39, 'นางชัญญานุช  รัตนวิชัย', 'Professional Level Teachers (K 3 Teachers)', '-', '-', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/%E0%B8%8A%E0%B8%B1%E0%B8%99%E0%B8%A2%E0%B8%B2%E0%B8%99%E0%B8%B8%E0%B8%8A2.jpg-1.png', '3'),
(44, 'Maroot Worasarn', 'Senior Professional Level Teachers (K 3 Teachers)', '0864553881', 'marootx@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/01-%E0%B8%A1%E0%B8%B2%E0%B8%A3%E0%B8%B8%E0%B8%95-1.jpg', '3'),
(45, 'Suchart Kamonnut', 'Senior Professional Level Teachers (K 3 Teachers)', '-', 'suchart.ka@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/06-%E0%B8%AA%E0%B8%B8%E0%B8%8A%E0%B8%B2%E0%B8%95%E0%B8%B4-1.jpg', '2'),
(46, 'Apiradee Suebchompoo', 'K1 Teacher', '0892788118', 'apiradee.su@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/%E0%B8%AD%E0%B8%A0%E0%B8%B4%E0%B8%A3%E0%B8%94%E0%B8%B5-1.jpg', '3'),
(47, 'Siwarin Talacheep', 'Practitioner Level', '0999579786', 'siwarin.ta@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/%E0%B8%99%E0%B8%B2%E0%B8%87%E0%B8%AA%E0%B8%B2%E0%B8%A7%E0%B8%A8%E0%B8%B4%E0%B8%A7%E0%B8%A3%E0%B8%B4%E0%B8%99%E0%B8%97%E0%B8%A3%E0%B9%8C-%E0%B8%95%E0%B8%B2%E0%B8%A5%E0%B8%B0%E0%B8%8A%E0%B8%B5%E0%B8%9E-1.jpg', '3'),
(48, 'นางสาวพชรกร  ภูภักดิ์', 'Practitioner Level', '-', 'phacharakorn.p@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/04%E0%B8%9E%E0%B8%8A%E0%B8%A3%E0%B8%81%E0%B8%A3-1.jpg', '3'),
(49, 'Sirapop bunsawat', 'Practitioner Level', '-', 'sirapop.b@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/%E0%B8%AA%E0%B8%B4%E0%B8%A3%E0%B8%A0%E0%B8%9E-1.jpg', '3'),
(50, 'นายวรุตม์  เขจรสัตย์', 'Director', '-', '-', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/01-%E0%B8%9C%E0%B8%AD.%E0%B8%A7%E0%B8%A3%E0%B8%B8%E0%B8%95%E0%B8%A1%E0%B9%8C-2-248x300.jpg', '1'),
(51, 'Klomjit Donpirom', 'Expert Level Teachers (K 4 Teachers)', '-', 'klomjit.do@kls.ac.th', 'https://www.kls.ac.th/web/wp-content/uploads/2023/11/01-%E0%B8%81%E0%B8%A5%E0%B9%88%E0%B8%AD%E0%B8%A1%E0%B8%88%E0%B8%B4%E0%B8%95-1.jpg', '2'),
(52, 'Dullayut Pimdee', 'Dev', '0651125689', 'dullayut.pimdee@gmail.com', 'https://cdn.discordapp.com/attachments/857622277369364530/1317794092524245043/34222.jpg?ex=675ffae3&is=675ea963&hm=e35424509b064c2beedee6aaa0f5e6df845b56680c95d3b578f84032f19f6395&', '5');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `person`
--
ALTER TABLE `person`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `person`
--
ALTER TABLE `person`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
COMMIT;

