-- 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 `stores` -- DROP TABLE IF EXISTS `stores`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `stores` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company` int(11) DEFAULT NULL, `region_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `address` varchar(200) DEFAULT NULL, `state` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `zip` varchar(11) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `ot_daily` int(2) NOT NULL, `ot_daily_pay` tinyint(1) DEFAULT NULL, `ot_weekly` int(2) NOT NULL, `ot_weekly_pay` tinyint(1) DEFAULT NULL, `ot_biweek` int(2) NOT NULL, `ot_biweek_pay` tinyint(1) DEFAULT NULL, `ot_rate` decimal(4,2) NOT NULL, `status_id` tinyint(1) NOT NULL DEFAULT 1, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stores` -- LOCK TABLES `stores` WRITE; /*!40000 ALTER TABLE `stores` DISABLE KEYS */; INSERT INTO `stores` VALUES (13,NULL,19,'P2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(17,NULL,0,'Madera2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(18,NULL,10,'Madera1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(19,NULL,11,'Hanford1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(25,NULL,22,'Hanford 3',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(26,NULL,23,'M1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(27,NULL,23,'M2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(28,NULL,43,'Store 50',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-02-05 15:06:18','0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(29,3,19,'D1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-05-04 11:57:53','0000-00-00 00:00:00',NULL,NULL),(30,3,20,'H1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:17:01','0000-00-00 00:00:00',NULL,NULL),(31,3,20,'H2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:17:08','0000-00-00 00:00:00',NULL,NULL),(32,NULL,20,'H2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(33,3,19,'D2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-05-04 11:58:05','0000-00-00 00:00:00',NULL,NULL),(34,NULL,23,'D3',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-02-19 14:41:02','0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(37,3,20,'Lemoore',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:17:24','0000-00-00 00:00:00',NULL,NULL),(47,NULL,23,'Kerman',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(50,NULL,25,'Store 20',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(51,NULL,25,'Store 25',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(52,NULL,25,'store 26',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'0000-00-00 00:00:00',NULL,'2020-04-27 19:15:24'),(60,3,19,'Madera',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-03-04 17:32:53','2017-02-05 15:34:37',NULL,NULL),(61,NULL,19,'P3',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'2017-02-05 15:34:49',NULL,'2020-04-27 19:15:24'),(62,3,20,'H3',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:17:16','2017-02-05 15:35:30',NULL,NULL),(65,NULL,48,'Store 50',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'2017-02-19 13:48:27',NULL,'2020-04-27 19:15:24'),(66,3,19,'Madera 2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-08-10 12:16:35','2017-02-19 14:40:40',NULL,'2020-04-27 19:15:24'),(67,3,19,'Fresno',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-05-04 11:57:58','2017-02-19 14:41:15',NULL,NULL),(68,3,23,'P1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:16:41','2017-02-19 15:07:43',NULL,NULL),(69,3,23,'P2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-10 12:16:47','2017-02-19 15:08:51',NULL,NULL),(70,3,23,'Tulare',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-08-10 12:16:53','2017-02-19 15:09:01',NULL,'2020-04-27 19:15:24'),(71,3,24,'Kingsburg',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-08-10 12:17:31','2017-03-05 23:38:34',NULL,'2020-04-27 19:15:24'),(72,3,56,'Merced',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,'2017-08-10 12:16:06','2017-03-09 14:49:36',NULL,'2020-04-27 19:15:24'),(73,5,58,'Merced1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2017-08-15 11:50:04','2017-08-10 12:20:42',NULL,NULL),(74,5,59,'Fresno Reg 1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2017-08-15 11:50:46',NULL,NULL),(75,5,57,'Zone X',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2017-08-19 14:37:20',NULL,NULL),(76,5,60,'Zone XYZ',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2017-08-19 21:28:22',NULL,NULL),(77,5,57,'Store1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2017-08-19 21:28:41',NULL,NULL),(78,3,19,'Clovis',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2017-11-11 17:32:22',NULL,NULL),(79,3,23,'Farmersville ',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-03-04 17:33:22','2017-12-31 12:11:42',NULL,NULL),(80,6,61,'Madera','1510 E. Yosemite Ave Ste 105','CA','Madera','93638','559-661-0400',8,1,40,1,80,0,1.50,1,'2021-04-06 15:21:43','2018-02-02 16:55:03',NULL,NULL),(81,6,61,'Fresno',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-08-21 16:11:56','2018-02-02 16:55:24',NULL,NULL),(82,6,61,'Clovis',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,80,NULL,1.50,1,'2021-03-08 02:53:46','2018-02-02 16:55:34',NULL,NULL),(83,6,64,'Merced','3144 G Street Ste 125-255','Ca','Merced','95340',NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2021-01-24 22:27:59','2018-02-02 17:03:37',NULL,NULL),(84,7,65,'DRA Plaza',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-08-21 12:46:15',NULL,NULL),(85,6,61,'Dinuba','820 North Alta Avenue Ste K','CA','Dinuba','93618','559-595-0200',8,1,40,1,80,0,1.50,1,'2021-04-06 15:21:35','2018-08-21 16:12:16',NULL,NULL),(86,6,71,'D2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2019-02-08 13:23:36','2018-08-21 16:12:24',NULL,NULL),(87,6,63,'Hanford1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-10-01 12:31:50','2018-08-21 16:13:06',NULL,NULL),(88,6,63,'Hanford','240 N. 12th Ave Ste 105','CA','Hanford','93230','559-852-9661',8,1,40,1,80,0,1.50,1,'2021-04-06 15:22:55','2018-08-21 16:13:17',NULL,NULL),(89,6,63,'Lemoore','1108 N. Lemoore Ave','CA','Lemoore','93245','559-423-5037',8,1,40,1,80,0,1.50,1,'2021-04-06 15:23:02','2018-08-21 16:13:34',NULL,NULL),(90,6,62,'Porterville',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-10-01 12:32:13','2018-08-21 16:13:45',NULL,NULL),(91,6,62,'Farmersville',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-10-01 12:32:02','2018-08-21 16:13:56',NULL,NULL),(92,8,66,'Bullard & VIlla',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2018-11-13 15:55:42','2018-11-13 15:54:55',NULL,NULL),(93,8,66,'First & Bullard',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-11-13 15:55:34',NULL,NULL),(94,8,66,'Villa & 6th St',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-11-13 15:56:11',NULL,NULL),(95,8,67,'Main & Fresno',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'2018-11-13 16:04:52',NULL,'2020-04-27 19:15:24'),(96,8,67,'Ashlan & West',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'2018-11-13 16:05:19',NULL,'2020-04-27 19:15:24'),(97,8,67,'Herndon & West',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,2,NULL,'2018-11-13 16:05:51',NULL,'2020-04-27 19:15:24'),(98,9,68,'Finance',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-12-10 17:30:07',NULL,NULL),(99,9,68,'Marketing',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-12-10 17:49:21',NULL,NULL),(100,9,68,'Human Resouce',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-12-10 17:49:36',NULL,NULL),(101,10,70,'Accounting',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-12-11 21:07:20',NULL,NULL),(102,10,70,'Finance',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,NULL,'2018-12-11 21:10:03',NULL,NULL),(103,6,71,'TEST 1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-04-27 19:15:24','2020-04-27 03:18:38',197,'2020-04-27 19:15:24'),(104,6,64,'COBA',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-04-27 20:14:16','2020-04-27 19:27:33',153,'2020-04-27 20:14:16'),(105,6,64,'TEST',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-04-27 20:17:42','2020-04-27 19:27:48',153,'2020-04-27 20:17:42'),(106,6,62,'Trial','1250 W. Main Street','Texas','Plano','12345',NULL,8,0,40,1,80,0,1.50,1,'2021-04-11 06:26:47','2020-07-07 05:21:22',NULL,NULL),(107,6,73,'Bakersfield',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-07-20 16:30:27','2020-07-20 16:30:27',NULL,NULL),(108,6,72,'North',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2021-01-24 01:47:11','2020-07-20 16:32:45',NULL,NULL),(109,11,74,'Location One',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-12 13:16:44','2020-08-12 13:16:44',NULL,NULL),(110,14,76,'Store1',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-17 18:03:59','2020-08-17 18:03:59',NULL,NULL),(111,11,74,'locatin 2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-17 20:49:50','2020-08-17 20:49:50',NULL,NULL),(112,14,77,'Ashlan & West',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-12-07 17:44:49','2020-08-23 15:51:48',238,'2020-12-07 17:44:49'),(113,14,76,'Store2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-23 15:52:07','2020-08-23 15:52:07',NULL,NULL),(114,14,76,'Store2',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-23 15:53:39','2020-08-23 15:53:23',238,'2020-08-23 15:53:39'),(115,14,76,'Store3',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-08-23 15:55:26','2020-08-23 15:55:26',NULL,NULL),(116,14,81,'Store 151',NULL,NULL,NULL,NULL,NULL,8,NULL,40,NULL,40,NULL,1.50,1,'2020-12-07 17:45:29','2020-12-07 17:45:29',NULL,NULL); /*!40000 ALTER TABLE `stores` 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:36:26