-- 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 `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `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, `module` varchar(30) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `deleted_at` timestamp NULL DEFAULT NULL, `status_id` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'position 1','position-1',0,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(2,'job 2','job-2',0,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(3,'Regional Sales manager','regional-sales-manager',4,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(4,'position 3','position-3',0,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(5,'Owner','owner',5,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(6,'Regular Managers','regular-managers',2,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(7,'District Manager','district-manager',3,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(8,'Sales People','sales-people',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(9,'test','test',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(10,'test1','test1',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(11,'position 3','position-3',2,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(12,'Owner','owner',5,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(13,'Regional Manager','regional-manager',4,3,NULL,'2020-04-16 21:40:47','2017-08-19 19:34:15',NULL,1),(14,'District Manager','district-manager',3,3,NULL,'2020-04-16 21:40:47','2018-05-03 13:31:15',NULL,1),(15,'Sales Manager','sales-manager',2,NULL,NULL,'2020-04-16 21:48:13','2017-03-06 13:40:36','2020-04-16 21:48:13',2),(16,'Sales Associate','sales-associate',1,3,NULL,'2020-04-16 21:40:47','2017-08-19 20:47:14',NULL,1),(17,'HR','hr',6,3,NULL,'2020-04-16 21:40:47','2017-08-19 20:47:23',NULL,1),(18,'Probation Employee','probation-employee',1,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:15:41',NULL,1),(19,'sdfsfdsdfsdfsdfdsf sdfsdfdsfdfs fads fsda afdadsf','sdfsfdsdfsdfsdfdsf-sdfsdfdsfdfs-fads-fsda-afdadsf',1,NULL,NULL,'2020-04-16 21:48:13','2017-02-05 15:07:48','2020-04-16 21:48:13',2),(20,'adsadsads','adsadsads',1,NULL,NULL,'2020-04-16 21:48:13','2017-02-05 14:59:56','2020-04-16 21:48:13',2),(21,'Sales dfsdfasfdsfd','sales-dfsdfasfdsfd',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(22,'sdfsdfsdf afd asfddfsa','sdfsdfsdf-afd-asfddfsa',1,NULL,NULL,'2020-04-16 21:48:13','2017-02-05 15:07:42','2020-04-16 21:48:13',2),(23,'sdfsdfds','sdfsdfds',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(24,'afsdasdf adfs sdf','afsdasdf-adfs-sdf',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(25,'as fda sdfasdf','as-fda-sdfasdf',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(26,' sdf sdfadfs as adsf asdasdf','sdf-sdfadfs-as-adsf-asdasdf',1,NULL,NULL,'2020-04-16 21:48:13','2017-02-05 15:09:21','2020-04-16 21:48:13',2),(27,' sfdafaf asdfdfafa afsd sadfsf sdfsdf','sfdafaf-asdfdfafa-afsd-sadfsf-sdfsdf',1,NULL,NULL,'2020-04-16 21:48:13','2017-02-05 15:09:35','2020-04-16 21:48:13',2),(28,'asfda dfs asdf','asfda-dfs-asdf',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(30,'Probation','probation',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(31,'test','test',1,NULL,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(32,'Training','training',1,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:15:49',NULL,1),(33,'DM Trainee','dm-trainee',3,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:16:03',NULL,1),(34,'ASM','asm',2,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:16:11',NULL,1),(35,'ASM Trainee','asm-trainee',2,3,NULL,'2020-04-16 21:40:47','2018-08-27 12:42:54',NULL,1),(36,'Regional Manager Trainee','regional-manager-trainee',4,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:16:30',NULL,1),(37,'Store Manager','store-manager',2,3,NULL,'2020-04-16 21:40:47','2018-07-13 18:43:41',NULL,1),(38,'Company Admin','company-admin',7,3,NULL,'2020-04-16 21:40:47','2017-08-19 21:16:58',NULL,1),(39,'Owner','owner',7,3,NULL,'2020-04-16 21:40:47','2018-08-23 08:38:30',NULL,1),(40,'Owner','owner',7,3,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(41,'Sales Associate','sales-associate',1,5,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(42,'Trainee','trainee',1,5,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(43,'Sales Associate','sales-associate',1,5,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(44,'Assistan Manager','assistan-manager',2,5,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(45,'Sales Manager','sales-manager',2,5,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(46,'District Manager','district-manager',3,5,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(47,'Sales Associate','sales-associate',1,6,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(48,'DM','dm',3,6,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(49,'Owner','owner',7,6,NULL,'2020-04-16 21:40:47','2018-08-23 08:38:12',NULL,1),(50,'Admin - HR','admin-hr',6,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(51,'Owner','owner',5,6,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(52,'Only Test','only-test',1,3,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(53,'only test','only-test',1,3,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(54,'test only','test-only',1,5,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(55,'Test only 1','test-only-1',1,5,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(56,'Company Admin','company-admin',7,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(57,'Sales Associate','sales-associate',1,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(58,'Team Leader Training','team-leader-training',3,6,NULL,'2020-04-16 21:40:47','2019-03-27 16:43:10',NULL,1),(59,'Store Manager','store-manager',3,6,NULL,'2020-04-16 21:48:13','2018-07-03 13:12:44','2020-04-16 21:48:13',2),(60,'Store Manager','store-manager',2,6,NULL,'2020-04-16 21:40:47','2018-08-21 16:01:37',NULL,1),(61,'Sales Manager','sales-manager',2,6,NULL,'2020-04-16 21:40:47','2018-10-29 11:12:48',NULL,1),(62,'District Manager','district-manager',3,6,NULL,'2020-04-16 21:40:47','2018-10-06 12:25:59',NULL,1),(63,'ASM','asm',2,6,NULL,'2020-04-16 21:40:47','2019-02-02 14:39:45',NULL,1),(64,'ASM Training','asm-training',2,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(65,'Training','training',1,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(66,'Regional Sales Manager','regional-sales-manager',4,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(67,'test1','test1',1,6,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(68,'Owner','owner',7,7,NULL,'2020-04-16 21:40:47','2018-08-23 08:37:20',NULL,1),(69,'Super Admin','super-admin',5,3,NULL,'2020-05-31 02:01:35','2020-05-29 05:49:54',NULL,1),(70,'Owner','owner',7,8,NULL,'2020-04-16 21:40:47','2018-11-28 16:35:16',NULL,1),(71,'Sales Associate','sales-associate',1,8,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(72,'Trainee','trainee',1,8,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(73,'Team Leader','team-leader',4,8,NULL,'2020-04-16 21:40:47','2018-11-28 16:58:01',NULL,1),(74,'Store Manager','store-manager',2,8,NULL,'2020-04-16 21:48:13','2018-11-13 18:40:07','2020-04-16 21:48:13',2),(75,'District Manager','district-manager',3,8,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(76,'Owner','owner',7,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(77,'Owner','owner',7,9,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(78,'Finance Manager','finance-manager',3,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(79,'HR Manager','hr-manager',6,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(80,'Assistant Manager','assistant-manager',2,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(81,'Owners','owners',7,9,NULL,'2020-04-16 21:48:13','0000-00-00 00:00:00','2020-04-16 21:48:13',2),(82,'Receptionist','receptionist',1,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(83,'Clerk 1','clerk-1',1,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(84,'Clerk 2','clerk-2',1,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(85,'Account Representative','account-representative',1,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(86,'Marketing Manager','marketing-manager',3,9,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(87,'Owner','owner',7,10,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(88,'Secretary','secretary',1,10,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(89,'Jr. Accounting','jr-accounting',1,10,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(90,'Clerk1','clerk1',1,10,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(91,'Special Assignment','special-assignment',4,6,NULL,'2020-04-16 21:40:47','0000-00-00 00:00:00',NULL,1),(92,'Create Test Module','create-test-module',0,NULL,NULL,'2020-07-12 00:22:58','2020-07-11 21:22:58',NULL,1),(93,'Read Test Module','read-test-module',0,NULL,NULL,'2020-07-12 00:23:27','2020-07-11 21:23:27',NULL,1),(94,'Update Test Module','update-test-module',0,NULL,NULL,'2020-07-12 00:23:35','2020-07-11 21:23:35',NULL,1),(95,'Delete Test Module','delete-test-module',0,NULL,NULL,'2020-07-12 00:23:12','2020-07-11 21:23:12',NULL,1),(96,'Schedule','schedule',0,NULL,NULL,'2020-07-11 21:30:17','2020-07-11 21:30:17',NULL,1),(97,'Scheduler','scheduler',0,NULL,'scheduler','2020-07-18 03:32:53','2020-07-18 03:32:53',NULL,1),(98,'Position','position',0,NULL,'position','2020-07-18 03:34:16','2020-07-18 03:34:16',NULL,1),(99,'Store','store',0,NULL,'store','2020-07-18 03:34:33','2020-07-18 03:34:33',NULL,1),(100,'Region','region',0,NULL,'region','2020-07-18 03:34:47','2020-07-18 03:34:47',NULL,1),(101,'Employee','employee',0,NULL,'employee','2020-07-18 03:35:12','2020-07-18 03:35:12',NULL,1),(102,'Report','report',0,NULL,'report','2020-07-18 03:35:47','2020-07-18 03:35:47',NULL,1),(103,'Role','role',0,NULL,'role','2020-07-18 03:35:57','2020-07-18 03:35:57',NULL,1),(104,'Notification','notification',0,NULL,'notification','2020-07-18 03:36:43','2020-07-18 03:36:43',NULL,1),(105,'Sick Leave','sickleave',0,NULL,'sickleave','2020-07-18 03:37:24','2020-07-18 03:37:24',NULL,1),(106,'Department','department',0,NULL,'department','2020-07-18 03:38:21','2020-07-18 03:38:21',NULL,1),(107,'Location','location',0,NULL,'location','2020-07-18 03:38:35','2020-07-18 03:38:35',NULL,1); /*!40000 ALTER TABLE `permissions` 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:35:39