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

START TRANSACTION;



--
-- Database: `u68319090001`
--

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

--
-- 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 COMMENT 'ชื่อเต็ม',
  `email` varchar(200) NOT NULL COMMENT 'อีเมล',
  `phone` varchar(200) NOT NULL COMMENT 'โทรศัพท์',
  `address` text NOT NULL COMMENT 'ที่อยู่',
  `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, 'Night', '1234', 'Mr.night', 'night@gmail.com', '1230123', 'sea', '2025-07-21 15:21:22');

--
-- 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=2;
COMMIT;

