-- 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 `positions`
--

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

--
-- Dumping data for table `positions`
--

LOCK TABLES `positions` WRITE;
/*!40000 ALTER TABLE `positions` DISABLE KEYS */;
INSERT INTO `positions` VALUES (1,'position 1','position-1',0,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(2,'job 2','job-2',0,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(3,'Regional Sales manager','regional-sales-manager',4,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(4,'position 3','position-3',0,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(5,'Owner','owner',5,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(6,'Regular Managers','regular-managers',2,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(7,'District Manager','district-manager',3,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(8,'Sales People','sales-people',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(9,'test','test',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(10,'test1','test1',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(11,'position 3','position-3',2,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(12,'Owner','owner',5,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(13,'Regional Manager','regional-manager',4,3,'2020-04-16 21:40:47','2017-08-19 19:34:15',NULL,1,NULL),(14,'District Manager','district-manager',3,3,'2020-04-16 21:40:47','2018-05-03 13:31:15',NULL,1,NULL),(15,'Sales Manager','sales-manager',2,NULL,'2020-04-16 21:48:13','2017-03-06 13:40:36','2020-04-16 21:48:13',2,NULL),(16,'Sales Associate','sales-associate',1,3,'2020-04-16 21:40:47','2017-08-19 20:47:14',NULL,1,NULL),(17,'HR','hr',6,3,'2020-04-16 21:40:47','2017-08-19 20:47:23',NULL,1,NULL),(18,'Probation Employee','probation-employee',1,3,'2020-04-16 21:40:47','2017-08-19 21:15:41',NULL,1,NULL),(19,'sdfsfdsdfsdfsdfdsf sdfsdfdsfdfs fads fsda afdadsf','sdfsfdsdfsdfsdfdsf-sdfsdfdsfdfs-fads-fsda-afdadsf',1,NULL,'2020-04-16 21:48:13','2017-02-05 15:07:48','2020-04-16 21:48:13',2,NULL),(20,'adsadsads','adsadsads',1,NULL,'2020-04-16 21:48:13','2017-02-05 14:59:56','2020-04-16 21:48:13',2,NULL),(21,'Sales dfsdfasfdsfd','sales-dfsdfasfdsfd',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(22,'sdfsdfsdf afd asfddfsa','sdfsdfsdf-afd-asfddfsa',1,NULL,'2020-04-16 21:48:13','2017-02-05 15:07:42','2020-04-16 21:48:13',2,NULL),(23,'sdfsdfds','sdfsdfds',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(24,'afsdasdf adfs sdf','afsdasdf-adfs-sdf',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(25,'as fda sdfasdf','as-fda-sdfasdf',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(26,' sdf sdfadfs as adsf asdasdf','sdf-sdfadfs-as-adsf-asdasdf',1,NULL,'2020-04-16 21:48:13','2017-02-05 15:09:21','2020-04-16 21:48:13',2,NULL),(27,' sfdafaf asdfdfafa afsd sadfsf sdfsdf','sfdafaf-asdfdfafa-afsd-sadfsf-sdfsdf',1,NULL,'2020-04-16 21:48:13','2017-02-05 15:09:35','2020-04-16 21:48:13',2,NULL),(28,'asfda dfs asdf','asfda-dfs-asdf',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(29,'aaaaa','aaaaa',1,NULL,'2020-04-16 21:48:13','2017-02-05 15:09:48','2020-04-16 21:48:13',2,NULL),(30,'Probation','probation',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(31,'test','test',1,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(32,'Training','training',1,3,'2020-04-16 21:40:47','2017-08-19 21:15:49',NULL,1,NULL),(33,'DM Trainee','dm-trainee',3,3,'2020-04-16 21:40:47','2017-08-19 21:16:03',NULL,1,NULL),(34,'ASM','asm',2,3,'2020-04-16 21:40:47','2017-08-19 21:16:11',NULL,1,NULL),(35,'ASM Trainee','asm-trainee',2,3,'2020-04-16 21:40:47','2018-08-27 12:42:54',NULL,1,NULL),(36,'Regional Manager Trainee','regional-manager-trainee',4,3,'2020-04-16 21:40:47','2017-08-19 21:16:30',NULL,1,NULL),(37,'Store Manager','store-manager',2,3,'2020-04-16 21:40:47','2018-07-13 18:43:41',NULL,1,NULL),(38,'Company Admin','company-admin',7,3,'2020-04-16 21:40:47','2017-08-19 21:16:58',NULL,1,NULL),(39,'Owner','owner',7,3,'2020-04-16 21:40:47','2018-08-23 08:38:30',NULL,1,NULL),(40,'Owner','owner',7,3,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(41,'Sales Associate','sales-associate',1,5,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(42,'Trainee','trainee',1,5,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(43,'Sales Associate','sales-associate',1,5,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(44,'Assistan Manager','assistan-manager',2,5,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(45,'Sales Manager','sales-manager',2,5,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(46,'District Manager','district-manager',3,5,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(47,'Sales Associate','sales-associate',1,6,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(48,'DM','dm',3,6,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(49,'Owner','owner',7,6,'2020-04-16 21:40:47','2018-08-23 08:38:12',NULL,1,NULL),(50,'Admin - HR','admin-hr',6,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(51,'Owner','owner',5,6,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(52,'Only Test','only-test',1,3,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(53,'only test','only-test',1,3,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(54,'test only','test-only',1,5,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(55,'Test only 1','test-only-1',1,5,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(56,'Company Admin','company-admin',7,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(57,'Sales Associate','sales-associate',1,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(58,'Team Leader Training','team-leader-training',2,6,'2020-07-06 23:23:19','2020-07-07 03:23:19',NULL,1,NULL),(59,'Store Manager','store-manager',3,6,'2020-04-16 21:48:13','2018-07-03 13:12:44','2020-04-16 21:48:13',2,NULL),(60,'Store Manager','store-manager',2,6,'2020-04-16 21:40:47','2018-08-21 16:01:37',NULL,1,NULL),(61,'Sales Manager','sales-manager',2,6,'2020-04-16 21:40:47','2018-10-29 11:12:48',NULL,1,NULL),(62,'District Manager','district-manager',3,6,'2020-04-16 21:40:47','2018-10-06 12:25:59',NULL,1,NULL),(63,'ASM','asm',2,6,'2020-04-16 21:40:47','2019-02-02 14:39:45',NULL,1,NULL),(64,'ASM Training','asm-training',2,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(65,'Training','training',1,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(66,'Regional Sales Manager','regional-sales-manager',4,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(67,'test1','test1',1,6,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(68,'Owner','owner',7,7,'2020-04-16 21:40:47','2018-08-23 08:37:20',NULL,1,NULL),(69,'IPS Admin','super-admin',5,6,'2020-05-31 00:29:44','2020-05-30 17:29:44',NULL,1,NULL),(70,'Owner','owner',7,8,'2020-04-16 21:40:47','2018-11-28 16:35:16',NULL,1,NULL),(71,'Sales Associate','sales-associate',1,8,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(72,'Trainee','trainee',1,8,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(73,'Team Leader','team-leader',4,8,'2020-04-16 21:40:47','2018-11-28 16:58:01',NULL,1,NULL),(74,'Store Manager','store-manager',2,8,'2020-04-16 21:48:13','2018-11-13 18:40:07','2020-04-16 21:48:13',2,NULL),(75,'District Manager','district-manager',3,8,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(76,'Owner','owner',7,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(77,'Owner','owner',7,9,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(78,'Finance Manager','finance-manager',3,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(79,'HR Manager','hr-manager',6,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(80,'Assistant Manager','assistant-manager',2,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(81,'Owners','owners',7,9,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2,NULL),(82,'Receptionist','receptionist',1,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(83,'Clerk 1','clerk-1',1,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(84,'Clerk 2','clerk-2',1,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(85,'Account Representative','account-representative',1,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(86,'Marketing Manager','marketing-manager',3,9,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(87,'Developer','developer',99,10,'2020-05-26 06:51:56','0000-00-00 00:00:00',NULL,1,NULL),(88,'Secretary','secretary',1,10,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(89,'Jr. Accounting','jr-accounting',1,10,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(90,'Clerk1','clerk1',1,10,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(91,'Special Assignment','special-assignment',4,6,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1,NULL),(92,'developer',NULL,99,3,'2020-05-25 23:45:37','2020-05-25 23:45:37',NULL,1,NULL),(93,'Clerk',NULL,1,6,'2020-07-07 05:23:22','2020-07-07 05:23:22',NULL,1,NULL),(94,'Owner',NULL,7,11,'2020-08-12 13:12:12','2020-08-12 13:12:12',NULL,1,NULL),(95,'IPS Admin',NULL,5,11,'2020-08-12 13:13:37','2020-08-12 13:13:37',NULL,1,NULL),(96,'company-admin',NULL,8,11,'2020-08-12 13:32:42','2020-08-12 13:32:42',NULL,1,NULL),(97,'Sales Associate',NULL,1,14,'2020-08-23 15:15:45','2020-08-23 15:15:45',NULL,1,NULL),(98,'Trainee',NULL,1,14,'2020-11-03 04:34:18','2020-11-03 01:34:18','2020-11-03 01:34:18',1,238),(99,'Assistant Manager',NULL,6,14,'2020-08-23 18:43:06','2020-08-23 15:43:06',NULL,1,NULL),(100,'Manager',NULL,6,14,'2020-08-23 15:16:40','2020-08-23 15:16:40',NULL,1,NULL),(101,'Company Owner',NULL,7,14,'2020-08-23 15:23:19','2020-08-23 15:23:19',NULL,1,NULL),(102,'Trainee',NULL,1,14,'2020-11-03 01:34:32','2020-11-03 01:34:32',NULL,1,NULL),(103,'District Manager',NULL,3,14,'2020-12-07 17:50:31','2020-12-07 17:50:31',NULL,1,NULL),(104,'Regional Sales Manager',NULL,4,14,'2020-12-07 17:51:00','2020-12-07 17:51:00',NULL,1,NULL),(105,'Supervisor',NULL,6,14,'2023-09-13 01:34:28','2023-09-13 01:34:28',NULL,1,NULL);
/*!40000 ALTER TABLE `positions` 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:37:25