/*
SQLyog Trial v13.1.8 (64 bit)
MySQL - 10.6.18-MariaDB-cll-lve : Database - bymtechn_kiaradb
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`bymtechn_kiaradb` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;

USE `bymtechn_kiaradb`;

/*Table structure for table `usuarios` */


CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre_completo` varchar(100) NOT NULL,
  `correo` varchar(100) NOT NULL,
  `usuario` varchar(50) NOT NULL,
  `contrasena` varchar(255) NOT NULL,
  `perfil` varchar(50) DEFAULT 'usuario',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `usuarios` */

insert  into `usuarios`(`id`,`nombre_completo`,`correo`,`usuario`,`contrasena`,`perfil`) values 
(1,'Marcy','marcy@senati.pe','Marcy','3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79','usuario'),
(2,'Kiara Jackeline','kiara@senati.pe','kiara','d404559f602eab6fd602ac7680dacbfaadd13630335e951f097af3900e9de176b6db28512f2e000b9d04fba5133e8b1c6e8df59db3a8ab9d60be4b97cc9e81db','usuario');

