/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 100428
 Source Host           : localhost:3306
 Source Schema         : encuesta

 Target Server Type    : MySQL
 Target Server Version : 100428
 File Encoding         : 65001

 Date: 29/09/2023 04:52:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for departamentos
-- ----------------------------
DROP TABLE IF EXISTS `departamentos`;
CREATE TABLE `departamentos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre_departamento` varchar(300) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of departamentos
-- ----------------------------
BEGIN;
INSERT INTO `departamentos` VALUES (1, 'AMAZONAS', NULL, NULL);
INSERT INTO `departamentos` VALUES (2, 'ANTIOQUIA', NULL, NULL);
INSERT INTO `departamentos` VALUES (3, 'ARAUCA', NULL, NULL);
INSERT INTO `departamentos` VALUES (4, 'ARCHIPIELAGO DE SAN ANDRES, PROVIDENCIA Y SANTA CATALINA', NULL, NULL);
INSERT INTO `departamentos` VALUES (5, 'ATLANTICO', NULL, NULL);
INSERT INTO `departamentos` VALUES (6, 'BOGOTA, D.C.', NULL, NULL);
INSERT INTO `departamentos` VALUES (7, 'BOLIVAR', NULL, NULL);
INSERT INTO `departamentos` VALUES (8, 'BOYACA', NULL, NULL);
INSERT INTO `departamentos` VALUES (9, 'CALDAS', NULL, NULL);
INSERT INTO `departamentos` VALUES (10, 'CAQUETA', NULL, NULL);
INSERT INTO `departamentos` VALUES (11, 'CASANARE', NULL, NULL);
INSERT INTO `departamentos` VALUES (12, 'CAUCA', NULL, NULL);
INSERT INTO `departamentos` VALUES (13, 'CESAR', NULL, NULL);
INSERT INTO `departamentos` VALUES (14, 'CHOCO', NULL, NULL);
INSERT INTO `departamentos` VALUES (15, 'CORDOBA', NULL, NULL);
INSERT INTO `departamentos` VALUES (16, 'CUNDINAMARCA', NULL, NULL);
INSERT INTO `departamentos` VALUES (17, 'GUAINIA', NULL, NULL);
INSERT INTO `departamentos` VALUES (18, 'GUAVIARE', NULL, NULL);
INSERT INTO `departamentos` VALUES (19, 'HUILA', NULL, NULL);
INSERT INTO `departamentos` VALUES (20, 'LA GUAJIRA', NULL, NULL);
INSERT INTO `departamentos` VALUES (21, 'MAGDALENA', NULL, NULL);
INSERT INTO `departamentos` VALUES (22, 'META', NULL, NULL);
INSERT INTO `departamentos` VALUES (23, 'NARIÑO', NULL, NULL);
INSERT INTO `departamentos` VALUES (24, 'NORTE DE SANTANDER', NULL, NULL);
INSERT INTO `departamentos` VALUES (25, 'PUTUMAYO', NULL, NULL);
INSERT INTO `departamentos` VALUES (26, 'QUINDIO', NULL, NULL);
INSERT INTO `departamentos` VALUES (27, 'RISARALDA', NULL, NULL);
INSERT INTO `departamentos` VALUES (28, 'SANTANDER', NULL, NULL);
INSERT INTO `departamentos` VALUES (29, 'SUCRE', NULL, NULL);
INSERT INTO `departamentos` VALUES (30, 'TOLIMA', NULL, NULL);
INSERT INTO `departamentos` VALUES (31, 'VALLE DEL CAUCA', NULL, NULL);
INSERT INTO `departamentos` VALUES (32, 'VAUPES', NULL, NULL);
INSERT INTO `departamentos` VALUES (33, 'VICHADA', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
