· 8 years ago · Aug 14, 2018, 04:34 PM
1DROP TABLE IF EXISTS `users`;
2CREATE TABLE `users` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `full_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
5 `email_address` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
6 `password` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
7 `rol_id` tinyint(10) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
10
11-- ----------------------------
12-- Records of users
13-- ----------------------------
14INSERT INTO `users` VALUES ('1', 'Name I', 'email1@correo.com', 'e10adc3949ba59abbe56e057f20f883e', '1');
15INSERT INTO `users` VALUES ('2', 'Name II', 'email2@correo.com', '9400df890da90b431e338527a2c37f7c', '2');
16INSERT INTO `users` VALUES ('3', 'Name III', 'email4@correo.com', 'd5f57556962614c787e7aaf9dbe34c88', '3');
17INSERT INTO `users` VALUES ('4', 'Name IV', 'email5@correo.com', '8be41fbbea39a7a1a9d5e377e2d3a9ad', '2');
18INSERT INTO `users` VALUES ('5', 'Name V', 'email6@correo.com', '119217648da2e72f52e2b6a0204d3579', '3');
19INSERT INTO `users` VALUES ('6', 'Name VI', 'email7@correo.com', 'b5015ffdff2f1bbaa527126a338a649f', '3');
20INSERT INTO `users` VALUES ('7', 'Name VII', 'email8@correo.com', 'f55710c644ac5a67896b5f5ce8c8ad24', '1');
21INSERT INTO `users` VALUES ('8', 'Name VIII', 'email9@correo.com', 'dc5b847a75e9df3686ee30d6cac98cbc', '3');