--
-- Host: localhost    Database: hpanaderosos
-- ------------------------------------------------------


--
-- Table structure for table `$recordsSource`
--

CREATE TABLE `$recordsSource` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `revisions_id` int(10) unsigned NOT NULL,
  `field_name` varchar(24) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `is_primary` char(1) NOT NULL,
  `changed` char(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `revisions_id_name` (`revisions_id`,`field_name`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `$recordsSource`
--


--
-- Table structure for table `acteco`
--

CREATE TABLE `acteco` (
  `codact` int(10) unsigned NOT NULL,
  `nombre` varchar(70) NOT NULL,
  PRIMARY KEY (`codact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acteco`
--

INSERT INTO `acteco` VALUES (1,'SIN DEFINIR'),(101,'AMBIENTAL'),(102,'BANCARIO'),(103,'CONSTRUCCIÓN'),(104,'COMUNICACIONES Y MEDIOS'),(105,'CONSULTORIA'),(106,'HOTELERA'),(107,'GUBERNAMENTAL'),(108,'ENERGETICA'),(109,'TECNOLOGIA'),(110,'TEXTIL Y MODA'),(111,'TELECOMUNICACIONES'),(112,'SEGUROS'),(113,'TRANSPORTE'),(114,'SALUD'),(115,'EDUCACIÓN'),(116,'MILITAR'),(117,'RECREACIÓN'),(118,'VENTAS MINORISTAS'),(119,'MAQUINARIAS'),(120,'SIN ANIMO DE LUCRO'),(121,'QUIMICOS'),(122,'DISEÑO'),(123,'COOPERATIVAS'),(124,'FONDOS '),(125,'INDUSTRIAL'),(126,'PETROLERAS'),(127,'SERVICIOS'),(128,'AGENCIAS DE VIAJE');

--
-- Table structure for table `acuinf`
--

CREATE TABLE `acuinf` (
  `gruest` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mes` decimal(16,2) NOT NULL,
  `ano` decimal(16,2) NOT NULL,
  PRIMARY KEY (`gruest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `acuinf`
--


--
-- Table structure for table `apife_empresa`
--

CREATE TABLE `apife_empresa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `language_id` int(11) DEFAULT '79',
  `type_environment_id` int(11) DEFAULT '2',
  `type_operation_id` int(11) DEFAULT '10',
  `type_document_identification_id` int(11) NOT NULL,
  `country_id` int(11) DEFAULT '46',
  `type_currency_id` int(11) DEFAULT '35',
  `type_organization_id` int(11) NOT NULL,
  `type_regime_id` int(11) NOT NULL,
  `type_liability_id` int(11) NOT NULL,
  `tax_detail_id` int(11) NOT NULL DEFAULT '1',
  `identification_number` int(11) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `merchant_registration` varchar(20) NOT NULL,
  `municipality_id` int(11) NOT NULL,
  `address` varchar(150) NOT NULL,
  `phone` bigint(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `password` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `software_id` text,
  `software_pin` varchar(255) NOT NULL,
  `software_url` varchar(255) NOT NULL,
  `certificate` text,
  `certificate_password` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_user` varchar(15) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_user` varchar(15) DEFAULT NULL,
  `branch_name` varchar(255) DEFAULT NULL,
  `branch_merchant_registration` varchar(20) DEFAULT NULL,
  `branch_country_id` int(11) DEFAULT '46',
  `branch_municipality_id` int(11) DEFAULT NULL,
  `branch_address` varchar(150) DEFAULT NULL,
  `branch_phone` varchar(20) DEFAULT NULL,
  `branch_email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `apife_empresa`
--

INSERT INTO `apife_empresa` VALUES (1,79,1,10,6,46,35,1,1,12,1,901680931,'PANADEROSOS SAS','901680931',149,'AV SUBA NRO 120 49 LC 2',3108600296,'panaderosos07@gmail.com',0,'','nvwCIsqQBxefmFEnlJFqYx8TnyTWZtlw1UypmZDn2VP3dS4CNRpcU747VSGOybr7dgkZtplpsMseu4aq','c96163dc-7cf7-4fc5-93c3-d4e4dbc26a8c','31063','https://vpfe.dian.gov.co/WcfDianCustomerServices.svc?wsdl','[encoded data, 4540 characters]','thomas2020','2020-10-24 00:00:00','admin','2023-03-30 00:00:00','admin',NULL,NULL,46,NULL,NULL,NULL,NULL);

--
-- Table structure for table `apife_facturas`
--

CREATE TABLE `apife_facturas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type_document_id` int(1) NOT NULL,
  `sync` tinyint(1) DEFAULT '1',
  `zipKey` varchar(100) DEFAULT NULL,
  `prefac` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numfac` int(11) NOT NULL,
  `prefac_contig` varchar(5) DEFAULT NULL,
  `numfac_contig` int(11) DEFAULT NULL,
  `number` varchar(14) NOT NULL,
  `request` longtext NOT NULL,
  `isvalid` int(1) NOT NULL,
  `cuuid` varchar(255) NOT NULL,
  `contenidoCodigoQR` text,
  `attachedDocumentBytes` text,
  `errormessage` text,
  `response` longtext,
  `sendRepresentacion` char(1) NOT NULL DEFAULT 'N',
  `sendEmail` varchar(150) DEFAULT NULL,
  `sendDate` datetime DEFAULT NULL,
  `sendError` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_user` varchar(20) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_user` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `apife_facturas_prefac_numfac` (`prefac`,`numfac`),
  KEY `apife_facturas_prefac` (`prefac`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `apife_facturas`
--

INSERT INTO `apife_facturas` VALUES (1,1,1,'','PND',1,NULL,NULL,'PND1','{\"number\":1,\"resolution_id\":195,\"sync\":true,\"type_document_id\":1,\"due_date\":\"2023-04-11\",\"date\":\"2023-04-11\",\"time\":\"19:20:24\",\"payment_forms\":[{\"payment_form_id\":1,\"payment_method_id\":10,\"payment_due_date\":\"2023-04-11\",\"duration_measure\":0}],\"customer\":{\"type_document_identification_id\":\"6\",\"identification_number\":\"900328341\",\"type_organization_id\":\"1\",\"name\":\"SOCIEDAD COLOMBIANA DE CONSTRUCCIONES SOCOLCO SAS\",\"phone\":\"7451188\",\"address\":\"TV 22 98 82\",\"email\":\"facturacionelectronica@socolco.com.co\",\"merchant_registration\":\"No tiene\",\"country_id\":\"46\",\"municipality_id\":\"149\",\"type_regime_id\":\"1\",\"tax_detail_id\":\"1\",\"type_liability_id\":\"29\"},\"invoice_lines\":[{\"unit_measure_id\":642,\"invoiced_quantity\":\"1.000000\",\"line_extension_amount\":\"64814.81\",\"free_of_charge_indicator\":false,\"tax_totals\":[{\"tax_id\":4,\"tax_amount\":\"5185.19\",\"taxable_amount\":\"64814.81\",\"percent\":\"8.00\"}],\"description\":\"ALMUERZOS\",\"code\":\"2\",\"type_item_identification_id\":3,\"price_amount\":\"64814.81\",\"base_quantity\":\"1.000000\"}],\"legal_monetary_totals\":{\"line_extension_amount\":\"64814.81\",\"tax_exclusive_amount\":\"64814.81\",\"tax_inclusive_amount\":\"70000.00\",\"allowance_total_amount\":\"0.00\",\"charge_total_amount\":\"0.00\",\"payable_amount\":\"70000.00\"},\"tax_totals\":[{\"tax_id\":4,\"percent\":\"8.00\",\"tax_amount\":\"5185.19\",\"taxable_amount\":\"64814.81\"}]}',1,'de3f2d9c5c708a741a3de60667ae4288ee3526b2922ad000fc52735fd5756dd51991ccc759e3ac4b07ced6a32565be59','TnVtRmFjOiBQTkQxCkZlY0ZhYzogMjAyMy0wNC0xMQpIb3JGYWM6IDE5OjIwOjI0LTA1OjAwCk5pdEZhYzogOTAxNjgwOTMxCkRvY0FkcTogOTAwMzI4MzQxClZhbEZhYzogNjQ4MTQuODEKVmFsSXZhOiAwLjAwClZhbE90cm9JbTogMTAzNzAuMzgKVmFsVG9sRmFjOiA3MDAwMC4wMApDVUZFOiBkZTNmMmQ5YzVjNzA4YTc0MWEzZGU2MDY2N2FlNDI4OGVlMzUyNmIyOTIyYWQwMDBmYzUyNzM1ZmQ1NzU2ZGQ1MTk5MWNjYzc1OWUzYWM0YjA3Y2VkNmEzMjU2NWJlNTkKaHR0cHM6Ly9jYXRhbG9nby12cGZlLmRpYW4uZ292LmNvL2RvY3VtZW50L3NlYXJjaHFyP2RvY3VtZW50a2V5PWRlM2YyZDljNWM3MDhhNzQxYTNkZTYwNjY3YWU0Mjg4ZWUzNTI2YjI5MjJhZDAwMGZjNTI3MzVmZDU3NTZkZDUxOTkxY2NjNzU5ZTNhYzRiMDdjZWQ2YTMyNTY1YmU1OQ==','[encoded data, 51184 characters]','Regla: RUT01, Notificación: La validación del estado del RUT próximamente estará disponible.','[encoded data, 194816 characters]','S','facturacionelectronica@socolco.com.co','2023-04-11 19:26:30','','2023-04-11 19:22:00','contador.perini','2023-04-11 19:26:22','contador.perini');

--
-- Table structure for table `apife_language`
--

CREATE TABLE `apife_language` (
  `id` int(11) unsigned NOT NULL,
  `nombre` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `apife_language`
--

INSERT INTO `apife_language` VALUES (1,'Afar'),(2,'Afar'),(3,'Abkhazian'),(4,'Abkhazian'),(5,'Avestan'),(6,'Avestan'),(7,'Afrikaans'),(8,'Afrikaans'),(9,'Akan'),(10,'Akan'),(11,'Amharic'),(12,'Amharic'),(13,'Aragonese'),(14,'Aragonese'),(15,'Arabic'),(16,'Arabic'),(17,'Assamese'),(18,'Assamese'),(19,'Avaric'),(20,'Avaric'),(21,'Aymara'),(22,'Aymara'),(23,'Azerbaijani'),(24,'Azerbaijani'),(25,'Bashkir'),(26,'Bashkir'),(27,'Belarusian'),(28,'Belarusian'),(29,'Bulgarian'),(30,'Bulgarian'),(31,'Bihari languages'),(32,'Bihari languages'),(33,'Bislama'),(34,'Bislama'),(35,'Bambara'),(36,'Bambara'),(37,'Bengali'),(38,'Bengali'),(39,'Tibetan'),(40,'Tibetan'),(41,'Breton'),(42,'Breton'),(43,'Bosnian'),(44,'Bosnian'),(45,'Catalan; Valencian'),(46,'Catalan; Valencian'),(47,'Chechen'),(48,'Chechen'),(49,'Chamorro'),(50,'Chamorro'),(51,'Corsican'),(52,'Corsican'),(53,'Cree'),(54,'Cree'),(55,'Czech'),(56,'Czech'),(57,'Church Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic'),(58,'Church Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic'),(59,'Chuvash'),(60,'Chuvash'),(61,'Welsh'),(62,'Welsh'),(63,'Danish'),(64,'Danish'),(65,'German'),(66,'German'),(67,'Divehi; Dhivehi; Maldivian'),(68,'Divehi; Dhivehi; Maldivian'),(69,'Dzongkha'),(70,'Dzongkha'),(71,'Ewe'),(72,'Ewe'),(73,'Greek; Modern (1453-)'),(74,'Greek; Modern (1453-)'),(75,'English'),(76,'English'),(77,'Esperanto'),(78,'Esperanto'),(79,'Spanish; Castilian'),(80,'Spanish; Castilian'),(81,'Estonian'),(82,'Estonian'),(83,'Basque'),(84,'Basque'),(85,'Persian'),(86,'Persian'),(87,'Fulah'),(88,'Fulah'),(89,'Finnish'),(90,'Finnish'),(91,'Fijian'),(92,'Fijian'),(93,'Faroese'),(94,'Faroese'),(95,'French'),(96,'French'),(97,'Western Frisian'),(98,'Western Frisian'),(99,'Irish'),(100,'Irish'),(101,'Gaelic; Scottish Gaelic'),(102,'Gaelic; Scottish Gaelic'),(103,'Galician'),(104,'Galician'),(105,'Guarani'),(106,'Guarani'),(107,'Gujarati'),(108,'Gujarati'),(109,'Manx'),(110,'Manx'),(111,'Hausa'),(112,'Hausa'),(113,'Hebrew'),(114,'Hebrew'),(115,'Hindi'),(116,'Hindi'),(117,'Hiri Motu'),(118,'Hiri Motu'),(119,'Croatian'),(120,'Croatian'),(121,'Haitian; Haitian Creole'),(122,'Haitian; Haitian Creole'),(123,'Hungarian'),(124,'Hungarian'),(125,'Armenian'),(126,'Armenian'),(127,'Herero'),(128,'Herero'),(129,'Interlingua (International Auxiliary Language Association)'),(130,'Interlingua (International Auxiliary Language Association)'),(131,'Indonesian'),(132,'Indonesian'),(133,'Interlingue; Occidental'),(134,'Interlingue; Occidental'),(135,'Igbo'),(136,'Igbo'),(137,'Sichuan Yi; Nuosu'),(138,'Sichuan Yi; Nuosu'),(139,'Inupiaq'),(140,'Inupiaq'),(141,'Ido'),(142,'Ido'),(143,'Icelandic'),(144,'Icelandic'),(145,'Italian'),(146,'Italian'),(147,'Inuktiut'),(148,'Inuktiut'),(149,'Japanese'),(150,'Japanese'),(151,'Javanese'),(152,'Javanese'),(153,'Georgian'),(154,'Georgian'),(155,'Kongo'),(156,'Kongo'),(157,'Kikuyu; Gikuyu'),(158,'Kikuyu; Gikuyu'),(159,'Kuanyama; Kwanyama'),(160,'Kuanyama; Kwanyama'),(161,'Kazakh'),(162,'Kazakh'),(163,'Kalaallisut; Greenlandic'),(164,'Kalaallisut; Greenlandic'),(165,'Central Khmer'),(166,'Central Khmer'),(167,'Kannada'),(168,'Kannada'),(169,'Korean'),(170,'Korean'),(171,'Kanuri'),(172,'Kanuri'),(173,'Kashmiri'),(174,'Kashmiri'),(175,'Kurdish'),(176,'Kurdish'),(177,'Komi'),(178,'Komi'),(179,'Cornish'),(180,'Cornish'),(181,'Kirghiz; Kyrgyz'),(182,'Kirghiz; Kyrgyz'),(183,'Latin'),(184,'Latin'),(185,'Luxembourgish; Letzeburgesch'),(186,'Luxembourgish; Letzeburgesch'),(187,'Ganda'),(188,'Ganda'),(189,'Limburgan; Limburger; Limburgish'),(190,'Limburgan; Limburger; Limburgish'),(191,'Lingala'),(192,'Lingala'),(193,'Lao'),(194,'Lao'),(195,'Lithuanian'),(196,'Lithuanian'),(197,'Luba-Katanga'),(198,'Luba-Katanga'),(199,'Latvian'),(200,'Latvian'),(201,'Malagasy'),(202,'Malagasy'),(203,'Marshallese'),(204,'Marshallese'),(205,'Maori'),(206,'Maori'),(207,'Macedonian'),(208,'Macedonian'),(209,'Malayalam'),(210,'Malayalam'),(211,'Mongolian'),(212,'Mongolian'),(213,'Moldavian; Moldovan'),(214,'Moldavian; Moldovan'),(215,'Marathi'),(216,'Marathi'),(217,'Malay'),(218,'Malay'),(219,'Maltese'),(220,'Maltese'),(221,'Burmese'),(222,'Burmese'),(223,'Nauru'),(224,'Nauru'),(225,'Bokmal Norwegian; Norwegian Bokmal'),(226,'Bokmal Norwegian; Norwegian Bokmal'),(227,'Ndebele; North; North Ndebele'),(228,'Ndebele; North; North Ndebele'),(229,'Nepali'),(230,'Nepali'),(231,'Ndonga'),(232,'Ndonga'),(233,'Dutch; Flemish'),(234,'Dutch; Flemish'),(235,'Norwegian Nynorsk; Nynorsk, Norwegian'),(236,'Norwegian Nynorsk; Nynorsk, Norwegian'),(237,'Norwegian'),(238,'Norwegian'),(239,'Ndebele; South; South Ndebele'),(240,'Ndebele; South; South Ndebele'),(241,'Navajo; Navaho'),(242,'Navajo; Navaho'),(243,'Chichewa; Chewa; Nyanja'),(244,'Chichewa; Chewa; Nyanja'),(245,'Occitan (post 1500)'),(246,'Occitan (post 1500)'),(247,'Ojibwa'),(248,'Ojibwa'),(249,'Oromo'),(250,'Oromo'),(251,'Oriya'),(252,'Oriya'),(253,'Ossetian; Ossetic'),(254,'Ossetian; Ossetic'),(255,'Panjabi; Punjabi'),(256,'Panjabi; Punjabi'),(257,'Pali'),(258,'Pali'),(259,'Polish'),(260,'Polish'),(261,'Pushto; Pashto'),(262,'Pushto; Pashto'),(263,'Portuguese'),(264,'Portuguese'),(265,'Quechua'),(266,'Quechua'),(267,'Romansh'),(268,'Romansh'),(269,'Rundi'),(270,'Rundi'),(271,'Romanian'),(272,'Romanian'),(273,'Russian'),(274,'Russian'),(275,'Kinyarwanda'),(276,'Kinyarwanda'),(277,'Sanskrit'),(278,'Sanskrit'),(279,'Sardinian'),(280,'Sardinian'),(281,'Sindhi'),(282,'Sindhi'),(283,'Northern Sami'),(284,'Northern Sami'),(285,'Sango'),(286,'Sango'),(287,'Sinhala; Sinhalese'),(288,'Sinhala; Sinhalese'),(289,'Slovak'),(290,'Slovak'),(291,'Slovenian'),(292,'Slovenian'),(293,'Samoan'),(294,'Samoan'),(295,'Shona'),(296,'Shona'),(297,'Somali'),(298,'Somali'),(299,'Albanian'),(300,'Albanian'),(301,'Serbian'),(302,'Serbian'),(303,'Swati'),(304,'Swati'),(305,'Sotho, Southern'),(306,'Sotho, Southern'),(307,'Sundanese'),(308,'Sundanese'),(309,'Swedish'),(310,'Swedish'),(311,'Swahili'),(312,'Swahili'),(313,'Tamil'),(314,'Tamil'),(315,'Telugu'),(316,'Telugu'),(317,'Tajik'),(318,'Tajik'),(319,'Thai'),(320,'Thai'),(321,'Tigrinya'),(322,'Tigrinya'),(323,'Turkmen'),(324,'Turkmen'),(325,'Tagalog'),(326,'Tagalog'),(327,'Tswana'),(328,'Tswana'),(329,'Tonga (Tonga Islands)'),(330,'Tonga (Tonga Islands)'),(331,'Turkish'),(332,'Turkish'),(333,'Tsonga'),(334,'Tsonga'),(335,'Tatar'),(336,'Tatar'),(337,'Twi'),(338,'Twi'),(339,'Tahitian'),(340,'Tahitian'),(341,'Uighur; Uyghur'),(342,'Uighur; Uyghur'),(343,'Ukrainian'),(344,'Ukrainian'),(345,'Urdu'),(346,'Urdu'),(347,'Uzbek'),(348,'Uzbek'),(349,'Venda'),(350,'Venda'),(351,'Vietnamese'),(352,'Vietnamese'),(353,'Volapu00fck'),(354,'Volapu00fck'),(355,'Walloon'),(356,'Walloon'),(357,'Wolof'),(358,'Wolof'),(359,'Xhosa'),(360,'Xhosa'),(361,'Yiddish'),(362,'Yiddish'),(363,'Yoruba'),(364,'Yoruba'),(365,'Zhuang; Chuang'),(366,'Zhuang; Chuang'),(367,'Chinese'),(368,'Chinese'),(369,'Zulu'),(370,'Zulu');

--
