-- https://www.phpmyadmin.net/
--
-- 主機： localhost:3306
-- 產生時間： 2026-01-28 12:25:18
-- 伺服器版本： 5.7.24
-- PHP 版本： 8.3.1

START TRANSACTION;



--
-- 資料庫: `ts_php_2025`
--

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

--
-- 資料表結構 `mem`
--

CREATE TABLE `mem` (
  `mem_id` int(11) NOT NULL COMMENT '會員ID',
  `mem_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '會員名稱',
  `mem_mail` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '會員帳號',
  `mem_pwd` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '會員密碼',
  `mem_level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '會員等級 1:已申請未確認, 2:已確認可登入, 9:管理者, 0:黑名單',
  `mem_chkcode` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '會員驗證碼',
  `mem_time_c` datetime NOT NULL COMMENT '建檔時間',
  `mem_time_m` datetime NOT NULL COMMENT '最後修改時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `mem` (`mem_id`, `mem_name`, `mem_mail`, `mem_pwd`, `mem_level`, `mem_chkcode`, `mem_time_c`, `mem_time_m`) VALUES
(1, 'TS001', 'ts001@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 1, '779012', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(2, 'TS002', 'ts002@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '906903', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(3, 'TS999', 'ts999@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 9, '789890', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(4, 'TS003', 'ts003@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '123456', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(5, 'TS005', 'ts005@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '123456', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(6, 'TS004', 'ts004@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '123456', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(7, 'TS006', 'ts006@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '166205', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(8, 'TS007', 'ts007@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '765706', '2023-12-15 00:00:00', '2023-12-27 00:16:09'),
(9, 'TS008', 'ts008@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 2, '473775', '2023-12-15 00:00:00', '2023-12-27 00:16:19'),
(10, 'TS009', 'ts009@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 0, '873701', '2023-12-15 00:00:00', '2023-12-31 11:43:28'),
(11, 'TS011', 'ts011@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 0, '926952', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(12, 'TS012', 'ts012@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 0, '029025', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(13, 'TS013', 'ts013@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 0, '122893', '2023-12-15 00:00:00', '2023-12-15 00:00:00'),
(14, 'TS101', 'ts101@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 1, '214971', '2023-12-26 22:19:03', '2023-12-26 22:19:03'),
(16, 'TSuiling', 'tsuiling1020@gmail.com', '4b8962a1bc48a81895b21eb69afd44f0', 9, '746321', '2023-12-26 22:22:10', '2023-12-26 22:22:10');

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

--
-- 資料表索引 `mem`
--
ALTER TABLE `mem`
  ADD PRIMARY KEY (`mem_id`),
  ADD UNIQUE KEY `mem_mail` (`mem_mail`);

--
-- 在傾印的資料表使用自動遞增(AUTO_INCREMENT)
--

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `mem`
--
ALTER TABLE `mem`
  MODIFY `mem_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '會員ID', AUTO_INCREMENT=17;
COMMIT;

