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

START TRANSACTION;



--
-- Database: `u68319090009`
--

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `uid` int(5) NOT NULL,
  `username` varchar(200) NOT NULL COMMENT 'ชื่อผู้ใช้',
  `password` varchar(200) NOT NULL COMMENT 'รหัสผู้ใช้งาน',
  `fullname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `creation_date` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'วันที่สมัคร'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`uid`, `username`, `password`, `fullname`, `email`, `phone`, `address`, `creation_date`) VALUES
(1, 'admin', '123456', 'นาย นนทพัทธ์ ไชยชนะ', 'tungtungtungsahur@gmail.com', '0954507090', 'บ้านตั้งบนพื้นดิน มีอากาศ มีน้ำ', '2025-07-21 10:07:55'),
(2, 'asdasda', '452452', 'dfsdf', 'asda@gmail.com', '03542423', 'fghdfhfgh', '2025-07-21 11:26:09'),
(4, 'sdfsdfsdfsdf', '546545614', 'sgsdgsdfsdf', 'tungtungtung@gmail.com', '53756756', 'efrthrth', '2025-07-21 14:18:38'),
(5, 'dasfsdfsdf', '61661', 'aassdasdad', 'eiei@gmail.com', '65', '', '2025-07-21 14:19:16'),
(6, 'asdasd', '61661', 'maime', 'kikiki@gmail.com', '6575275', 'rgdfsdf', '2025-07-21 14:19:36');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`uid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `uid` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

