AehZykTW

1CREATE DATABASE IF NOT EXISTS `isud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
2USE `isud`;
3
4DROP TABLE IF EXISTS `users`;
5CREATE TABLE `users` (
6  `user_id` int(11) NOT NULL,
7  `user_email` varchar(100) NOT NULL,
8  `user_password` varchar(256) NOT NULL,
9  `user_fullname` varchar(100) NOT NULL
10) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
11
12ALTER TABLE `users`
13  ADD PRIMARY KEY (`user_id`),
14  ADD UNIQUE KEY `user_email` (`user_email`);
15
16ALTER TABLE `users`
17  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;
18COMMIT;