-- MySQL dump 10.19  Distrib 10.3.31-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: db5006133589.hosting-data.io    Database: dbs5131681
-- ------------------------------------------------------
-- Server version	5.7.33-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `amr_calendar`
--

DROP TABLE IF EXISTS `amr_calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` varchar(50) DEFAULT NULL,
  `empieza` varchar(100) DEFAULT NULL,
  `termina` varchar(100) DEFAULT NULL,
  `titulo` varchar(150) DEFAULT NULL,
  `estado` varchar(50) DEFAULT NULL,
  `notas` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_calendar`
--

LOCK TABLES `amr_calendar` WRITE;
/*!40000 ALTER TABLE `amr_calendar` DISABLE KEYS */;
/*!40000 ALTER TABLE `amr_calendar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_contacts`
--

DROP TABLE IF EXISTS `amr_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `puesto` varchar(20) NOT NULL,
  `mail` varchar(50) DEFAULT NULL,
  `nombre` varchar(150) DEFAULT NULL,
  `img` varchar(150) DEFAULT NULL,
  `empresa` varchar(50) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `direccion` varchar(50) DEFAULT NULL,
  `ciudad` varchar(20) DEFAULT NULL,
  `estado` varchar(20) DEFAULT NULL,
  `pais` varchar(20) DEFAULT NULL,
  `cp` varchar(6) DEFAULT NULL,
  `proyectos` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_contacts`
--

LOCK TABLES `amr_contacts` WRITE;
/*!40000 ALTER TABLE `amr_contacts` DISABLE KEYS */;
INSERT INTO `amr_contacts` VALUES (1,'2021-06-19 09:01:31','2022-02-04 06:03:21','boss','alexcd2000@yopmail.com','Don Smtih Jr','./assets/images/users/user-1.jpg','Canada LLC','5554545454','parque lira','cdmx','state','mx','234556',NULL);
/*!40000 ALTER TABLE `amr_contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_products`
--

DROP TABLE IF EXISTS `amr_products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `categoria1` varchar(100) DEFAULT NULL,
  `categoria2` varchar(100) DEFAULT NULL,
  `categoria3` varchar(100) DEFAULT NULL,
  `nombre` varchar(200) NOT NULL,
  `descripcion` text,
  `precio` varchar(50) NOT NULL,
  `descuento` varchar(100) DEFAULT NULL,
  `archivo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=471 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_products`
--

LOCK TABLES `amr_products` WRITE;
/*!40000 ALTER TABLE `amr_products` DISABLE KEYS */;
INSERT INTO `amr_products` VALUES (432,'2022-01-12 01:19:40','2022-02-13 20:56:17','3','19','','uno','Lorem ipsum ddolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ','23.31','04','sdsfil'),(469,'2022-02-13 20:51:04','2022-02-13 20:56:08','22','23','25','cool lamp','234','2','','nothing'),(470,'2022-02-13 20:51:28','2022-02-13 20:56:12','3','5','26','fancy heater','234','55','','nothing');
/*!40000 ALTER TABLE `amr_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_products_meta`
--

DROP TABLE IF EXISTS `amr_products_meta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_products_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` varchar(50) DEFAULT NULL,
  `tipo` varchar(50) DEFAULT NULL,
  `producto` varchar(20) DEFAULT NULL,
  `padre` varchar(20) DEFAULT NULL,
  `nivel` int(1) NOT NULL,
  `nombre` varchar(200) DEFAULT NULL,
  `ajuste` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_products_meta`
--

LOCK TABLES `amr_products_meta` WRITE;
/*!40000 ALTER TABLE `amr_products_meta` DISABLE KEYS */;
INSERT INTO `amr_products_meta` VALUES (1,'2022-02-12 01:56:10','2022-02-13 11:52:39','atributo','432',NULL,0,'made of copper','6700'),(3,'2022-02-12 01:56:10','2022-02-13 15:16:39','categoria',NULL,'0',1,'heater',NULL),(5,'2022-02-12 01:56:10',NULL,'categoria',NULL,'3',2,'indoor',NULL),(18,'2022-02-13 20:14:41',NULL,'categoria',NULL,'4',2,'other',NULL),(19,'2022-02-13 20:15:23',NULL,'categoria',NULL,'3',2,'outdoor',NULL),(20,'2022-02-13 20:15:55',NULL,'categoria',NULL,'19',3,'gas',NULL),(22,'2022-02-13 20:51:37',NULL,'categoria',NULL,'0',1,'lights',NULL),(23,'2022-02-13 20:51:51',NULL,'categoria',NULL,'22',2,'lcd',NULL),(24,'2022-02-13 20:52:04',NULL,'categoria',NULL,'23',3,'white',NULL),(25,'2022-02-13 20:52:16',NULL,'categoria',NULL,'23',3,'red',NULL),(26,'2022-02-13 20:52:42',NULL,'categoria',NULL,'5',3,'whale oil',NULL),(27,'2022-02-13 20:54:07',NULL,'categoria',NULL,'5',3,'electric',NULL),(28,'2022-02-13 20:57:37','2022-02-13 16:01:53','atributo','469',NULL,0,'made of gold with diamonds','450');
/*!40000 ALTER TABLE `amr_products_meta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_projects`
--

DROP TABLE IF EXISTS `amr_projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `nombre` varchar(150) NOT NULL,
  `descripcion` text,
  `estatus` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_projects`
--

LOCK TABLES `amr_projects` WRITE;
/*!40000 ALTER TABLE `amr_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `amr_projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_takeoff`
--

DROP TABLE IF EXISTS `amr_takeoff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_takeoff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `nombre` varchar(150) DEFAULT NULL,
  `descripcion` text,
  `total` varchar(20) DEFAULT NULL,
  `descuento` varchar(20) DEFAULT NULL,
  `archivo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_takeoff`
--

LOCK TABLES `amr_takeoff` WRITE;
/*!40000 ALTER TABLE `amr_takeoff` DISABLE KEYS */;
/*!40000 ALTER TABLE `amr_takeoff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_takeoff_meta`
--

DROP TABLE IF EXISTS `amr_takeoff_meta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_takeoff_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` varchar(50) DEFAULT NULL,
  `takeoff` varchar(20) DEFAULT NULL,
  `ubicacion` varchar(20) DEFAULT NULL,
  `archivo` varchar(200) DEFAULT NULL,
  `producto` varchar(20) DEFAULT NULL,
  `atributos` varchar(20) DEFAULT NULL,
  `precio` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_takeoff_meta`
--

LOCK TABLES `amr_takeoff_meta` WRITE;
/*!40000 ALTER TABLE `amr_takeoff_meta` DISABLE KEYS */;
/*!40000 ALTER TABLE `amr_takeoff_meta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `amr_users`
--

DROP TABLE IF EXISTS `amr_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `amr_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ultmodif` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(20) NOT NULL,
  `email` varchar(150) NOT NULL,
  `pwd` varchar(50) NOT NULL,
  `resetpwd` varchar(5) DEFAULT NULL,
  `theme` varchar(20) DEFAULT NULL,
  `layout` varchar(20) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `img` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `amr_users`
--

LOCK TABLES `amr_users` WRITE;
/*!40000 ALTER TABLE `amr_users` DISABLE KEYS */;
INSERT INTO `amr_users` VALUES (1,'2022-02-11 17:10:33','2022-02-12 04:34:42','admin','alexcd2000@yopmail.com','1','YF0UG','light','horizontal','Amr','./assets/images/users/user-2.jpg');
/*!40000 ALTER TABLE `amr_users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-02-13 15:15:18
