/*

Navicat MySQL Data Transfer



Source Server         : 192.168.1.251

Source Server Version : 50568

Source Host           : 192.168.1.251:3306

Source Database       : ubo_prueba



Target Server Type    : MYSQL

Target Server Version : 50568

File Encoding         : 65001



Date: 2022-12-13 19:00:19

*/






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

-- Table structure for failed_jobs

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


CREATE TABLE `failed_jobs` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,

  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,

  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

-- Records of failed_jobs

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



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

-- Table structure for migrations

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


CREATE TABLE `migrations` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

  `batch` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

-- Records of migrations

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

INSERT INTO `migrations` VALUES ('17', '2014_10_12_000000_create_users_table', '1');

INSERT INTO `migrations` VALUES ('18', '2014_10_12_100000_create_password_resets_table', '1');

INSERT INTO `migrations` VALUES ('19', '2014_10_12_200000_add_two_factor_columns_to_users_table', '1');

INSERT INTO `migrations` VALUES ('20', '2019_08_19_000000_create_failed_jobs_table', '1');



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

-- Records of password_resets

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



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

-- Table structure for persona

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


CREATE TABLE `persona` (

  `idpersona` int(11) NOT NULL AUTO_INCREMENT,

  `nombre` varchar(20) DEFAULT NULL,

  `apellido_paterno` varchar(20) DEFAULT NULL,

  `apellido_materno` varchar(20) DEFAULT NULL,

  `rut` varchar(15) DEFAULT NULL,

  `mail` varchar(20) DEFAULT NULL,

  `direccion` varchar(50) DEFAULT NULL,

  `estatus` char(1) DEFAULT '1',

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT NULL,

  PRIMARY KEY (`idpersona`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;



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

-- Records of persona

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

INSERT INTO `persona` VALUES ('1', 'Juslain', 'Belizaire', 'Belizaire', '26.092.000-6', 'hlain2000@gmail.com', 'Adelaida de la Feitra', '1', '2021-08-09 15:41:26', '2021-08-09 15:41:26');

