· 5 years ago · Jul 19, 2020, 06:52 PM
1-- MySQL dump 10.17 Distrib 10.3.22-MariaDB, for Linux (x86_64)
2--
3-- Host: 127.0.0.1 Database: erp_harp_01
4-- ------------------------------------------------------
5-- Server version 10.3.22-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `nom_academia`
20--
21
22DROP TABLE IF EXISTS `nom_academia`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `nom_academia` (
26 `id` int(11) NOT NULL,
27 `sucursal_id` int(11) NOT NULL,
28 `descrip` varchar(255) NOT NULL,
29 `sta` tinyint(4) NOT NULL DEFAULT 0,
30 `created_at` timestamp NULL DEFAULT current_timestamp(),
31 `updated_at` timestamp NULL DEFAULT current_timestamp(),
32 PRIMARY KEY (`id`),
33 KEY `sucursal_id_academia` (`sucursal_id`),
34 CONSTRAINT `sucursal_id_academia` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursal` (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `nom_academia`
40--
41
42LOCK TABLES `nom_academia` WRITE;
43/*!40000 ALTER TABLE `nom_academia` DISABLE KEYS */;
44/*!40000 ALTER TABLE `nom_academia` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `nom_actividad_economica`
49--
50
51DROP TABLE IF EXISTS `nom_actividad_economica`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `nom_actividad_economica` (
55 `id` int(11) NOT NULL,
56 `sucursal_id` int(11) NOT NULL,
57 `codactiv` varchar(255) NOT NULL,
58 `nomactiv` varchar(255) NOT NULL,
59 `sta` tinyint(4) NOT NULL DEFAULT 0,
60 `created_at` timestamp NULL DEFAULT NULL,
61 `updated_at` timestamp NULL DEFAULT NULL,
62 PRIMARY KEY (`id`),
63 KEY `sucursal_id_actividad_economica` (`sucursal_id`),
64 CONSTRAINT `sucursal_id_actividad_economica` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursal` (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `nom_actividad_economica`
70--
71
72LOCK TABLES `nom_actividad_economica` WRITE;
73/*!40000 ALTER TABLE `nom_actividad_economica` DISABLE KEYS */;
74/*!40000 ALTER TABLE `nom_actividad_economica` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `nom_contrato`
79--
80
81DROP TABLE IF EXISTS `nom_contrato`;
82/*!40101 SET @saved_cs_client = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `nom_contrato` (
85 `id` int(11) NOT NULL AUTO_INCREMENT,
86 `sucursal_id` int(11) NOT NULL,
87 `descrip` varchar(255) NOT NULL,
88 `sta` tinyint(4) NOT NULL DEFAULT 0,
89 `created_at` timestamp NULL DEFAULT current_timestamp(),
90 `updated_at` timestamp NULL DEFAULT current_timestamp(),
91 PRIMARY KEY (`id`),
92 KEY `sucursal_id_contrato` (`sucursal_id`),
93 CONSTRAINT `sucursal_id_contrato` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursal` (`id`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `nom_contrato`
99--
100
101LOCK TABLES `nom_contrato` WRITE;
102/*!40000 ALTER TABLE `nom_contrato` DISABLE KEYS */;
103/*!40000 ALTER TABLE `nom_contrato` ENABLE KEYS */;
104UNLOCK TABLES;
105
106--
107-- Table structure for table `nom_discapacidad`
108--
109
110DROP TABLE IF EXISTS `nom_discapacidad`;
111/*!40101 SET @saved_cs_client = @@character_set_client */;
112/*!40101 SET character_set_client = utf8 */;
113CREATE TABLE `nom_discapacidad` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `sucursal_id` int(11) NOT NULL,
116 `descrip` varchar(255) NOT NULL,
117 `sta` tinyint(4) NOT NULL DEFAULT 0,
118 `created_at` timestamp NULL DEFAULT current_timestamp(),
119 `updated_at` timestamp NULL DEFAULT current_timestamp(),
120 PRIMARY KEY (`id`),
121 KEY `sucursal_id_discapacidad` (`sucursal_id`),
122 CONSTRAINT `sucursal_id_discapacidad` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursal` (`id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `nom_discapacidad`
128--
129
130LOCK TABLES `nom_discapacidad` WRITE;
131/*!40000 ALTER TABLE `nom_discapacidad` DISABLE KEYS */;
132/*!40000 ALTER TABLE `nom_discapacidad` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `nom_idiomas`
137--
138
139DROP TABLE IF EXISTS `nom_idiomas`;
140/*!40101 SET @saved_cs_client = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `nom_idiomas` (
143 `id` int(11) NOT NULL AUTO_INCREMENT,
144 `sucursal_id` int(11) NOT NULL,
145 `descrip` varchar(255) NOT NULL,
146 `sta` tinyint(4) NOT NULL DEFAULT 0,
147 `created_at` timestamp NULL DEFAULT current_timestamp(),
148 `updated_at` timestamp NULL DEFAULT current_timestamp(),
149 PRIMARY KEY (`id`),
150 KEY `sucursal_id_idiomas` (`sucursal_id`),
151 CONSTRAINT `sucursal_id_idiomas` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursal` (`id`)
152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `nom_idiomas`
157--
158
159LOCK TABLES `nom_idiomas` WRITE;
160/*!40000 ALTER TABLE `nom_idiomas` DISABLE KEYS */;
161/*!40000 ALTER TABLE `nom_idiomas` ENABLE KEYS */;
162UNLOCK TABLES;
163
164--
165-- Table structure for table `sucursal`
166--
167
168DROP TABLE IF EXISTS `sucursal`;
169/*!40101 SET @saved_cs_client = @@character_set_client */;
170/*!40101 SET character_set_client = utf8 */;
171CREATE TABLE `sucursal` (
172 `id` int(11) NOT NULL AUTO_INCREMENT,
173 `id_empresa` int(11) NOT NULL DEFAULT 1,
174 `nombre_empresa` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
175 `nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
176 `sta` tinyint(1) NOT NULL DEFAULT 1,
177 `porc_iva` double NOT NULL DEFAULT 12,
178 `razon_social` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
179 `direccion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
180 `telefono` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
181 `nit` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
182 `scafi_bod` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
183 `validanit` tinyint(1) DEFAULT 1,
184 `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
185 `fechai` datetime NOT NULL,
186 `fechaf` datetime NOT NULL,
187 `imprime_fecha` tinyint(1) NOT NULL DEFAULT 0,
188 `imprime_hora` tinyint(1) NOT NULL DEFAULT 0,
189 `erp_upd_cheque` tinyint(1) NOT NULL DEFAULT 1,
190 `regimen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
191 `identificador` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
192 `codigo_establecimiento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
193 `dispositivo` int(11) NOT NULL DEFAULT 123,
194 `direccion2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
195 `municipio` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
196 `departamento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
197 `codigo_postal` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
198 `idp_super` decimal(18,7) NOT NULL DEFAULT 0.0000000,
199 `idp_regular` decimal(18,7) NOT NULL DEFAULT 0.0000000,
200 `idp_diesel` decimal(18,7) NOT NULL DEFAULT 0.0000000,
201 `idp_kerosen` decimal(18,7) NOT NULL DEFAULT 0.0000000,
202 `fechai_t` date DEFAULT NULL,
203 `fechaf_t` date DEFAULT NULL,
204 `meses_validar` int(11) DEFAULT 1,
205 `moneda_id` int(11) DEFAULT NULL,
206 `auto_block_cli` tinyint(1) NOT NULL DEFAULT 0,
207 `dias_auto_block` int(11) NOT NULL,
208 `concepto_cheque` tinyint(1) NOT NULL DEFAULT 0,
209 `dias_trabajar` int(11) NOT NULL DEFAULT 360,
210 `block_presupuestado` tinyint(1) DEFAULT 0,
211 `text_utilidad_operacion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'UTILIDAD EN OPERACION',
212 `text_perdida_operacion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PERDIDA EN OPERACION',
213 `text_utilidad_ejercicio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'UTILIDAD DEL EJERCICIO',
214 `text_perdida_ejercicio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PERDIDA DEL EJERCICIO',
215 `text_sum_pasivo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'SUMA DEL PASIVO Y CAPITAL',
216 `text_centro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'CENTRO DE COSTO',
217 `nombre_balanceg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'BALANCE GENERAL',
218 `nombre_eresult` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'ESTADO DE RESULTADOS',
219 `nombre_bsaldo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'BALANCE DE SALDOS',
220 `nombre_diario` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'LIBRO DIARIO',
221 `nombre_mayor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'LIBRO MAYOR',
222 `nombre_balancep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'BALANCE GENERAL PRESUPUESTADO',
223 `nombre_eresultp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'ESTADO DE RESULTADOS PRESUPUESTADO',
224 `nombre_bsaldop` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'BALANCE DE SALDOS PRESUPUESTADO',
225 `certificacion` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
226 `nombre_establecimiento` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
227 `nombre_contador` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
228 `registro_contador` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
229 `cobro_mensual_consolidado` tinyint(1) NOT NULL DEFAULT 1,
230 `concepto_cheque2` tinyint(1) NOT NULL DEFAULT 0,
231 `precedencia_iva` tinyint(1) NOT NULL DEFAULT 0,
232 `ajuste_ingreso_id` int(11) NOT NULL DEFAULT 1,
233 `ajuste_egreso_id` int(11) NOT NULL DEFAULT 1,
234 `ajuste_cliente_id` int(11) NOT NULL DEFAULT 1,
235 `ajuste_proveedor_id` int(11) DEFAULT 1,
236 PRIMARY KEY (`id`)
237) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Dumping data for table `sucursal`
242--
243
244LOCK TABLES `sucursal` WRITE;
245/*!40000 ALTER TABLE `sucursal` DISABLE KEYS */;
246/*!40000 ALTER TABLE `sucursal` ENABLE KEYS */;
247UNLOCK TABLES;
248
249--
250-- Dumping events for database 'erp_harp_01'
251--
252
253--
254-- Dumping routines for database 'erp_harp_01'
255--
256/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
257
258/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
259/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
260/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
261/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
262/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
263/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
264/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
265
266-- Dump completed on 2020-07-19 12:48:09