-- 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 `company` -- DROP TABLE IF EXISTS `company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `companyname` varchar(50) DEFAULT NULL, `tradename` varchar(30) NOT NULL, `fein` varchar(10) DEFAULT NULL, `ownername` varchar(50) DEFAULT NULL, `contactname` varchar(50) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `address` varchar(200) DEFAULT NULL, `state` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `zip` varchar(10) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `website` varchar(50) DEFAULT NULL, `logo` varchar(50) DEFAULT NULL, `contacttelephone` varchar(20) DEFAULT NULL, `contactfax` varchar(20) DEFAULT NULL, `contactemail` varchar(50) DEFAULT NULL, `contactposition` varchar(30) DEFAULT NULL, `package` int(11) DEFAULT NULL, `module` varchar(255) DEFAULT NULL, `hr` tinyint(1) NOT NULL, `scheduler` tinyint(1) NOT NULL, `payroll` tinyint(1) NOT NULL, `startdate` date DEFAULT NULL, `status` int(1) DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company` -- LOCK TABLES `company` WRITE; /*!40000 ALTER TABLE `company` DISABLE KEYS */; INSERT INTO `company` VALUES (2,'CRICKET WIRELESS','CW','111222222','-','-','mail@mail.com','-','-','-','-','-','-','111222222.png','-','-','mail@email.com','-',2,NULL,0,1,0,'2020-05-31',2,'2020-08-15 22:52:17','2020-08-15 22:52:17','2017-08-09 19:27:52',235),(3,'US Prepaid Wireless Inc.','US Prepaid Wireless','222223333','Diana Nurul','Diana','sales@usprepaidwireless.com','3144 G street STE 125-152','California','Merced','95340','2099474000',NULL,NULL,'1','1','mail@mail.com','1',4,NULL,0,1,0,'2020-05-31',1,NULL,'2020-12-07 21:51:08','2017-08-09 22:47:27',NULL),(5,'Wireless Connection','',NULL,'Jose Rafi','Jose','info@wirelessmanagement.us','2536 Main Street','CA','Atwater','96301','209-725-9000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,2,'2020-08-15 22:52:28','2020-08-15 22:52:28','2017-08-11 11:16:15',235),(6,'Premier Wireless Group Inc.','Premier Wireless','111111111','Rose Vitale','Rose Vitale','diananurul2002@gmail.com','3144 G Street #125-255','CA','Merced','95340','209-600-7400',NULL,'111111111.png','2096007400','2096007400','premierwireless2021@gmail.com','CEO',3,NULL,1,1,1,'2018-10-01',1,NULL,'2023-02-28 21:05:36','2018-02-02 16:48:29',NULL),(7,'DRA Development LLC','1111','111111112','Annisa Fahira','Annisa','nisye2007@gmail.com','1160 W. Olive Ave Ste A1','CA','Merced','95348','2099474702',NULL,NULL,'1234','124','nisye2007@gmail.com','saa',4,NULL,0,1,0,'2020-05-29',1,NULL,'2020-05-29 07:46:37','2018-08-21 12:43:51',NULL),(8,'A&B Wireless','zzzz','333333333','Mr. ABC dddd','Mr. Henderson','henderson123@gmail.com','123 Main Street','CA','Fresno','93716','559-500-5600',NULL,'333333333.png','1234','1231','maie@email.com','wqwq',1,'hr,payrolle',0,1,0,'2020-06-24',2,'2020-08-15 23:45:31','2020-08-15 23:45:31','2018-11-13 15:52:58',235),(9,'XYZ Fiesta Inc.','Fiesta','123456789','Mr. Fiesta','Fiesta Gerardo','fiesta123@gmail.com','789 W. Main Street','CA','Modesto','95350','209-559-1234',NULL,NULL,'209-000-0000','209-000-0000','demotest123@gmail.com','209-000-0000',3,NULL,1,1,1,'2020-08-09',1,NULL,'2020-08-14 20:59:19','2018-12-10 17:27:02',NULL),(10,'Tech Works','tradenamet','222222222','Mr. XYZ','XYZ','xyz@gmail.com','916 W. Main Street','CA','Sacramento','95815','916-200-5000',NULL,'tech_works_logo.png','123','123','mail@mail.com','qw',4,NULL,0,1,0,'2020-06-10',2,'2020-08-15 22:52:04','2020-08-15 22:52:04','2018-12-11 21:01:50',235),(11,'IPS','IPS','123457666','ownername','Contact Name','useaxes@gmail.com','Address','state','city','12345','12345',NULL,'123457666.png','243123','12312','useaxes@gmail.com','owner',4,NULL,0,1,0,'2020-08-12',NULL,NULL,'2020-08-12 13:48:25','2020-08-12 13:08:40',NULL),(12,'ABCDemo','ABC Demo','234567899','ABC Demo','ABC Demo','abcdemo@gmail.com','123 W Main St','CA','Fresno','93746','559-234-5678',NULL,NULL,'559-234-5678','559-234-5678','demoabc@gmail.com','Owner',3,NULL,0,1,0,'2020-08-10',2,'2020-08-15 22:52:12','2020-08-15 22:52:12','2020-08-13 03:00:48',235),(14,'Retail Demo Inc','Retail Demo','789456123','Retail Retail','Retail Demo','info@wirelessmanagement.us','345 W. Main Street','CA','Fresno','93764','5590001111',NULL,NULL,'5590001111','5590001111','info@wirelessmanagement.us','Owner',1,NULL,0,1,0,'2020-08-15',NULL,NULL,'2020-08-23 15:30:18','2020-08-15 23:42:57',NULL); /*!40000 ALTER TABLE `company` 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:59