b1hZMSdF

1-- phpMyAdmin SQL Dump
2-- version 4.9.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3308
6-- Generation Time: Feb 18, 2020 at 04:01 PM
7-- Server version: 8.0.18
8-- PHP Version: 7.4.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `denuncias`
23--
24CREATE DATABASE IF NOT EXISTS `denuncias` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci;
25USE `denuncias`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `accounts`
31--
32
33DROP TABLE IF EXISTS `accounts`;
34CREATE TABLE IF NOT EXISTS `accounts` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `expedient` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
37  `banco` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
38  `numero` bigint(20) UNSIGNED ZEROFILL NOT NULL,
39  `sospechoso` varchar(12) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
40  `casos` int(11) NOT NULL,
41  PRIMARY KEY (`id`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `complaints`
48--
49
50DROP TABLE IF EXISTS `complaints`;
51CREATE TABLE IF NOT EXISTS `complaints` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `expedient` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
54  `monto` bigint(20) NOT NULL,
55  `detail` text COLLATE utf8_spanish_ci NOT NULL,
56  PRIMARY KEY (`id`)
57) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `phones`
63--
64
65DROP TABLE IF EXISTS `phones`;
66CREATE TABLE IF NOT EXISTS `phones` (
67  `id` int(11) NOT NULL AUTO_INCREMENT,
68  `expedient` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
69  `numero` bigint(11) UNSIGNED ZEROFILL NOT NULL,
70  `suspect` bigint(11) NOT NULL,
71  `veces` int(11) NOT NULL,
72  PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `suspects`
79--
80
81DROP TABLE IF EXISTS `suspects`;
82CREATE TABLE IF NOT EXISTS `suspects` (
83  `id` int(11) NOT NULL AUTO_INCREMENT,
84  `expedient` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
85  `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
86  `cedula` int(11) NOT NULL,
87  `veces` int(10) NOT NULL,
88  PRIMARY KEY (`id`)
89) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `users`
95--
96
97DROP TABLE IF EXISTS `users`;
98CREATE TABLE IF NOT EXISTS `users` (
99  `id` int(11) NOT NULL AUTO_INCREMENT,
100  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
101  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
102  `pass` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
103  PRIMARY KEY (`id`)
104) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
105
106-- --------------------------------------------------------
107
108--
109-- Table structure for table `victim`
110--
111
112DROP TABLE IF EXISTS `victim`;
113CREATE TABLE IF NOT EXISTS `victim` (
114  `id` int(11) NOT NULL AUTO_INCREMENT,
115  `expedient` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
116  `nombre` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
117  `cedula` int(11) NOT NULL,
118  `veces` int(11) NOT NULL,
119  PRIMARY KEY (`id`)
120) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
121COMMIT;
122
123/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
124/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
125/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;