· 6 years ago · Oct 24, 2019, 03:30 PM
1SET NAMES utf8 ;
2
3DROP TABLE IF EXISTS `users`;
4 SET character_set_client = utf8mb4 ;
5CREATE TABLE `users` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
8 `user_password` varchar(32) COLLATE utf8_unicode_ci DEFAULT 'md5',
9 `user_full_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12
13LOCK TABLES `users` WRITE;
14INSERT INTO `users` VALUES (1,'eduprog@gmail.com','202cb962ac59075b964b07152d234b70','Ahmad Eduprog');
15UNLOCK TABLES;