-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 19, 2025 at 07:00 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
-- Database: `house`
--
CREATE DATABASE IF NOT EXISTS `house` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `house`;

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

--
-- Table structure for table `school`
--

CREATE TABLE IF NOT EXISTS `school` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `school`
--

INSERT INTO `school` (`id`, `name`, `link`) VALUES
(1, 'คุรุราษฎร์รังสฤษฏ์', 'https://docs.google.com/spreadsheets/d/1YIiI6UKgfcPB-1Kpu6D1z7mMgFb0O30cW590e2D_uTY/edit?usp=sharing'),
(2, 'ช่องพรานวิทยา', 'https://docs.google.com/spreadsheets/d/1XQeAP70dOxqJ8tcgYfoEVbIJ9YKniZPeINEQJFJUnW0/edit?usp=sharing'),
(3, 'ราชโบริกานุเคราะห์', 'https://docs.google.com/spreadsheets/d/1LPTFS8GYKbqy5xAGyZPoi2Dw5iPl359sFjA6yuDkk7Q/edit?usp=sharing'),
(4, 'โสภณศิริราษฎร์', 'https://docs.google.com/spreadsheets/d/136qcUAojqbjUfn5qBpw9bdDkPCtCPCXY6nTHA4RbcJQ/edit?usp=sharing'),
(5, 'รัฐราษฎร์อุปถัมภ์', 'https://drive.google.com/drive/folders/1YUfcRiQAckNxyyWGuv35fZQL2THC_dfV?usp=drive_link'),
(6, 'หนองปลาหมอพิทยาคม', 'https://docs.google.com/spreadsheets/d/1alo7wqeZzjFGXFR91O1XiU8NOKlENW685Y8e-5LfyLo/edit?usp=sharing'),
(7, 'ด่านทับตะโกราษฎร์อุปถัมภ์', 'https://lookerstudio.google.com/reporting/95e76a30-a37b-438b-8db0-ee46e25fb1e5'),
(8, 'ปากท่อพิทยาคม (ใช้ username admin001 รหัส admin00123 เข้าระบบ)', 'https://paktho.mis-stu.net/index-1.php?fbclid=IwAR2xnthcz-6VdD6_LTQx8AY7iHLsEjyq8ABdaqxuT72OP8C3EYRKYrEzH5k_aem_th_ATpc5Ld6xqFwtmXExZGsAv-fixMxwnBaUfieIGRWD9Wm99h6sBQMbKIP1Kq7ijA5GbI'),
(9, 'โพธาวัฒนาเสนี (ใช้ username 001 รหัส 2509 เข้าระบบ)', 'http://110.164.191.222/~t221/homestd'),
(10, 'ประสาทรัฐประชากิจ', 'https://docs.google.com/spreadsheets/d/1WihgPpVIlwFToAuUyOvfek5p1TaUE6fpB4QNxlZGuFM/edit?usp=sharing'),
(11, 'สวนผึ้งวิทยา', 'https://docs.google.com/spreadsheets/d/1W0_N8vJS9oDkMIdYeqos77YjCapodmqXgtTzagZEisw/edit?usp=sharing'),
(12, 'เบญจมราชูทิศ ราชบุรี', 'https://docs.google.com/spreadsheets/d/1-0alrK3JDPaadjUgv7vQVf-oHiL3m2Z1WXQZChmoHmg/edit?usp=sharing'),
(13, 'กรับใหญ่ว่องกุศลกิจพิทยาคม', 'https://docs.google.com/spreadsheets/d/1NtsRJttVmPUHsNzfZbstSlfkKHcttITACrJt8g2F7ug/edit?usp=sharing'),
(14, 'หนองโพวิทยา', 'https://lookerstudio.google.com/reporting/49896d38-e72d-4fbe-8c37-0a94b57b09d8/page/jfo3D/edit'),
(15, 'บางแพปฐมพิทยา', 'https://lookerstudio.google.com/u/0/reporting/9a6a7419-b175-4ee7-9d9d-ad6f0362f990'),
(16, 'ท่ามะขามวิทยา', 'https://docs.google.com/spreadsheets/d/1lIYk0r7W1_vqKEYK8G-1cRusTDiV06NCL0CFAmrU8Hc/edit?fbclid=IwZXh0bgNhZW0CMTAAAR14OmAYuiLfFudTk5oWpF_t9-CnR2n7OcG_9C6uY0VVc9eld7wDW8Uy88k_aem_OS1N_5qAgnUDFw6U0B_GAw&gid=528251645#gid=528251645'),
(17, 'บรมราชินีนาถราชวิทยาลัย', 'https://docs.google.com/spreadsheets/d/1KDsFbTcEOR5KCwdEM6qAXHu6tmvKJOsdxZ8CMEGYSs4/edit?usp=sharing'),
(18, 'มัธยมวัดดอนตูม', 'https://docs.google.com/spreadsheets/d/1rlnNNCnuLP0b1Mq9ly6wQBZegj11kca3p9qgxUv4xL4/edit?gid=1051794498#gid=1051794498'),
(19, 'โพหักวงศ์สมบูรณ์ราษฎร์อุปถัมภ์', 'https://lookerstudio.google.com/u/0/reporting/8a6a24ad-93b1-457b-aea6-421713d745b5/page/xnL5D'),
(20, 'รัตนราษฎร์บำรุง', 'https://bit.ly/2567RRSTD'),
(21, 'เตรียมอุดมศึกษาพัฒนาการ ราชบุรี', 'https://docs.google.com/spreadsheets/d/1xkKG6DuJrie1qYojINA7zy2D2m2JuLZLoPZBAbeFR8g/edit?usp=sharing'),
(22, 'สายธรรมจันทร์ (ใช้ username 1 รหัส 1 เข้าระบบ)', 'https://www.saischool.ac.th/dmcs/dmcs_person/web_visit_home/login.php'),
(23, 'บ้านคาวิทยา', 'https://docs.google.com/spreadsheets/d/1NZgsdpZZq5LmK0GpgGjN8yoMpiulUPwwO6r4STyaNTQ/edit?usp=sharing'),
(24, 'เนกขัมวิทยา', 'https://docs.google.com/spreadsheets/d/1rEdOvtv10cVrqv6-y_9jixV_JJx5G8UNgRFn_q3b52k/edit?usp=sharing'),
(25, 'วัดสันติการามวิทยา ในพระบรมราชานุเคราะห์', 'https://sites.google.com/sesao8.go.th/santikaramwitthaya/%E0%B8%A3%E0%B8%B0%E0%B8%9A%E0%B8%9A%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%94%E0%B9%81%E0%B8%A5%E0%B8%8A%E0%B8%A7%E0%B8%A2%E0%B9%80%E0%B8%AB%E0%B8%A5%E0%B8%AD%E0%B8%99%E0%B8%81%E0%B9%80%E0%B8%A3%E0%B8%A2%E0%B8%99/%E0%B8%9B%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%A8%E0%B8%81%E0%B8%A9%E0%B8%B2-2567/%E0%B8%AA%E0%B8%B3%E0%B8%AB%E0%B8%A3%E0%B8%9A%E0%B8%84%E0%B8%A3-167'),
(26, 'แคทรายวิทยา', 'https://docs.google.com/spreadsheets/d/102dNQyqR1gIjaLm91HCjyR__KtmCac-6hOrftz99H3U/edit?usp=sharing\r\n');

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

--
-- Table structure for table `tbl_login`
--

CREATE TABLE IF NOT EXISTS `tbl_login` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `user_level` varchar(20) NOT NULL,
  `u_name` varchar(100) NOT NULL,
  `u_lastname` varchar(100) NOT NULL,
  `u_tel` varchar(20) NOT NULL,
  `u_email` varchar(50) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_login`
--

INSERT INTO `tbl_login` (`user_id`, `username`, `password`, `user_level`, `u_name`, `u_lastname`, `u_tel`, `u_email`) VALUES
(1, 'admin', 'admin1234', 'admin', 'admin', 'admin', '0812345678', '[email protected]');

/*!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 */;