-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: 64.31.43.162    Database: techwork_dump_simpleclock
-- ------------------------------------------------------
-- Server version	5.5.5-10.6.17-MariaDB-cll-lve

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `regions`
--

DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `regions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status_id` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regions`
--

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` VALUES (1,2,'0000-00-00 00:00:00',NULL,'region 1',2,'2020-05-24 17:00:00',NULL),(2,2,'0000-00-00 00:00:00',NULL,'region 2',2,'2020-05-24 17:00:00',NULL),(3,2,'0000-00-00 00:00:00',NULL,'region 3',2,'2020-05-24 17:00:00',NULL),(4,2,'0000-00-00 00:00:00',NULL,'region 4',NULL,'2020-05-24 17:00:00',NULL),(8,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','region 3',NULL,'2020-05-24 17:00:00',NULL),(9,2,'0000-00-00 00:00:00',NULL,'r1',NULL,'2020-05-24 17:00:00',NULL),(10,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','Region 3',NULL,'2020-05-24 17:00:00',NULL),(11,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','Region 2',NULL,'2020-05-24 17:00:00',NULL),(12,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','Region 1',NULL,'2020-05-24 17:00:00',NULL),(13,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','Region 4',NULL,'2020-05-24 17:00:00',NULL),(14,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','Region 5',NULL,'2020-05-24 17:00:00',NULL),(16,2,'0000-00-00 00:00:00',NULL,'region 6',NULL,'2020-05-24 17:00:00',NULL),(17,2,'0000-00-00 00:00:00',NULL,'region7',NULL,'2020-05-24 17:00:00',NULL),(18,2,'0000-00-00 00:00:00',NULL,'region 4',NULL,'2020-05-24 17:00:00',NULL),(19,1,'0000-00-00 00:00:00','2017-08-16 09:58:30','Region 1',3,NULL,NULL),(20,1,'0000-00-00 00:00:00','2017-08-16 09:58:40','Region 3',3,NULL,NULL),(21,2,'0000-00-00 00:00:00',NULL,'Region 4',NULL,'2020-05-24 17:00:00',NULL),(22,2,'0000-00-00 00:00:00',NULL,'Region 4',NULL,'2020-05-24 17:00:00',NULL),(23,1,'0000-00-00 00:00:00','2017-08-16 09:58:48','Region 2',3,NULL,NULL),(24,2,'0000-00-00 00:00:00','2018-05-03 20:41:20','Fresno Dinuba',3,'2020-05-24 17:00:00',NULL),(25,1,'0000-00-00 00:00:00','2017-08-16 09:59:04','Region 5',3,NULL,NULL),(26,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(27,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(28,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(29,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(30,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(31,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(32,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(33,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(34,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(35,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(36,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(37,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(38,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(39,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(40,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(41,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(42,2,'0000-00-00 00:00:00',NULL,'Region 6',NULL,'2020-05-24 17:00:00',NULL),(43,2,'0000-00-00 00:00:00','2017-03-24 03:26:19','Region6666',NULL,'2020-05-24 17:00:00',NULL),(44,2,'0000-00-00 00:00:00',NULL,'region 7',NULL,'2020-05-24 17:00:00',NULL),(45,2,'0000-00-00 00:00:00',NULL,'region 7',NULL,'2020-05-24 17:00:00',NULL),(46,2,'0000-00-00 00:00:00',NULL,'asadsads',NULL,'2020-05-24 17:00:00',NULL),(47,2,'2017-02-05 14:45:02','2017-02-05 22:05:40','Region 0',NULL,'2020-05-24 17:00:00',NULL),(48,1,'2017-02-05 15:04:34','2017-08-16 09:59:12','Region 7',3,NULL,NULL),(49,2,'2017-02-05 15:10:13','2017-02-05 22:10:33','region 10',NULL,'2020-05-24 17:00:00',NULL),(50,2,'2017-02-05 15:10:21','2017-02-05 22:13:12','region 9sdfsdf',NULL,'2020-05-24 17:00:00',NULL),(51,2,'2017-02-05 15:13:08',NULL,'sdfsdfsdf',NULL,'2020-05-24 17:00:00',NULL),(52,2,'2017-02-05 15:13:16',NULL,'sdfdssfdfds',NULL,'2020-05-24 17:00:00',NULL),(53,2,'2017-02-05 15:36:35','2017-02-05 22:36:44','Region 10',NULL,'2020-05-24 17:00:00',NULL),(54,2,'2017-02-19 13:39:26',NULL,'Region 8',NULL,'2020-05-24 17:00:00',NULL),(55,2,'2017-03-05 23:37:20',NULL,'Region 8',NULL,'2020-05-24 17:00:00',NULL),(56,2,'2017-03-09 14:49:18','2017-08-16 09:59:22','Region 0',3,'2020-05-24 17:00:00',NULL),(57,1,'2017-08-10 12:20:15','2017-08-19 21:05:57','Reg1',5,NULL,NULL),(58,1,'2017-08-11 11:17:34','2017-08-16 09:59:34','Zone Merced Los Banos',5,NULL,NULL),(59,1,'2017-08-11 11:17:43','2017-08-16 09:59:42','Zone Fresno',5,NULL,NULL),(60,1,'2017-08-19 14:36:20',NULL,'Reg 2',5,NULL,NULL),(61,1,'2018-02-02 16:49:41',NULL,'R1',6,NULL,NULL),(62,1,'2018-02-02 16:50:06',NULL,'R2',6,NULL,NULL),(63,1,'2018-02-02 16:50:14',NULL,'R3',6,NULL,NULL),(64,1,'2018-02-02 17:03:16',NULL,'Office',6,NULL,NULL),(65,1,'2018-08-21 12:44:35',NULL,'Merced',7,NULL,NULL),(66,1,'2018-11-13 15:53:55',NULL,'Region A',8,NULL,NULL),(67,2,'2018-11-13 15:54:09',NULL,'Region B',8,'2020-05-24 17:00:00',NULL),(68,1,'2018-12-10 17:29:24',NULL,'Head Quarter',9,NULL,NULL),(69,2,'2018-12-11 21:05:33',NULL,'Main Office',9,'2020-05-24 17:00:00',NULL),(70,1,'2018-12-11 21:06:12',NULL,'Main Office',10,NULL,NULL),(71,1,'2019-02-08 13:23:00',NULL,'R1B',6,NULL,NULL),(72,1,'2020-07-07 05:22:34','2020-07-07 01:22:34','Nort West',6,NULL,NULL),(73,1,'2020-07-20 00:14:57','2020-07-19 20:14:57','R4',6,NULL,NULL),(74,1,'2020-08-12 13:16:24','2020-08-12 09:16:24','Region One',11,NULL,NULL),(75,1,'2020-08-16 00:10:23','2020-08-15 20:19:50','Fresno Region',14,'2020-08-16 00:19:50',235),(76,1,'2020-08-16 20:22:56','2020-08-17 14:03:28','Region 10',14,NULL,NULL),(77,1,'2020-08-17 18:01:28','2020-08-17 14:01:28','Region 20',14,NULL,NULL),(78,1,'2020-08-17 18:02:00','2020-08-23 11:37:09','Region 30',14,'2020-08-23 15:37:09',238),(79,1,'2020-08-23 15:37:51','2020-08-23 11:40:34','Region 30',14,NULL,NULL),(80,1,'2020-08-23 15:39:34','2020-08-23 11:39:34','Region 40',14,NULL,NULL),(81,1,'2020-11-03 01:33:40','2020-11-02 20:33:40','Region 15',14,NULL,NULL),(82,1,'2023-09-13 01:39:23','2023-09-12 18:39:23','Region ABC',6,NULL,NULL);
/*!40000 ALTER TABLE `regions` 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 2024-06-10 19:34:10