
--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` varchar(20) NOT NULL,
  `role` varchar(20) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (2,'Amit','amitsahajanand1@gmail.com','Amit123','developer','2023-03-30 09:43:53','2023-03-30 09:43:53'),(3,'Surbhi','surbhi.sahajanand@gmail.com','surbhi123','developer','2023-03-31 04:28:50','2023-03-31 04:28:50'),(4,'Nikhil','sahajanandnikhildev@gmail.com','nikhil123','developer','2023-04-01 06:08:47','2023-04-01 06:08:47'),(5,'Janvi','janvi.sahajanand@gmail.com','Janvi123','developer','2023-04-01 07:01:53','2023-04-01 07:01:53'),(6,'Chintan','chintan.sahajanand@gmail.com','Qwe!@#123','developer','2023-09-14 04:53:39','2023-04-03 07:29:26'),(7,'Naimish','naimish.sahajanand@gmail.com','Naimish@123','developer','2023-04-12 04:46:05','2023-04-12 04:46:05'),(8,'Kemish','kemishsahajanand001@gmail.com','Kemish@123','developer','2023-04-12 07:04:18','2023-04-12 07:04:18'),(9,'Raj','rgsahajanand@gmail.com','Raj@123','developer','2023-04-14 10:55:35','2023-04-14 10:55:35'),(10,'Hiren','nasithiren510@gmail.com','Hiren@123','developer','2023-04-15 03:58:15','2023-04-15 03:58:15'),(11,'Alis','alissahajanand@gmail.com','Alis123','developer','2023-04-18 05:55:28','2023-04-18 05:55:28'),(12,'Parag','parag.sahajanand@gmail.com','Parag@123','developer','2023-05-01 09:15:16','2023-05-01 09:15:16'),(13,'Romik','romik.sahajanand@gmail.com','sahajanand3210','admin','2023-05-03 11:54:38','2023-05-03 11:54:38'),(14,'Ashish','ashish.sahajanand@gmail.com','ashish123','admin','2023-05-03 11:56:45','2023-05-03 11:56:45'),(15,'hardik kevadiya','hardikkevadiya29@gmail.com','Hkhkhk@2050','admin','2023-05-03 12:05:12','2023-05-03 12:05:12'),(16,'hardik lukhi','hp02610585@gmail.com','Hphphp@2050','admin','2023-05-03 12:06:02','2023-05-03 12:05:50'),(17,'Fenil monapara','fenil@gmail.com','Fenil@2050','admin','2023-05-03 14:09:09','2023-05-03 14:09:09'),(18,'Mitul','mitulsahjanand@gmail.com','Mitul@123','admin','2023-05-18 06:09:15','2023-05-18 06:09:15'),(19,'keval','keval.sahajanand@gmail.com','keval@123','admin','2023-06-16 04:22:28','2023-06-16 04:22:28'),(20,'Nishant','nishant.sahajanand@gmail.com','Nishant@123','developer','2023-07-18 12:41:00','2023-07-18 12:41:00'),(21,'hardik','hardik.sahajanand@gmail.com','Hardik@123','developer','2023-08-08 04:43:46','2023-08-08 04:43:46'),(22,'Rutvik','rutvik.sahajanand@gmail.com','Rutvik@123','developer','2023-08-09 05:24:13','2023-08-09 05:24:13');

--
-- Table structure for table `usercount`
--

CREATE TABLE `usercount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `package` varchar(200) NOT NULL,
  `today` int NOT NULL,
  `ytd` int NOT NULL,
  `total` int NOT NULL,
  `isdate` varchar(200) NOT NULL,
  `iplog` longtext NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `data` longblob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=372 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usercount`
--

INSERT INTO `usercount` VALUES (188,'com.app.asyncdrive',4,5,737,'11-10-2023','0.0.0.0','2023-10-12 06:36:45','2023-06-30 10:19:08',_binary '[binary data, 7113 characters]'),(189,'com.fastmediadownload.allsocialdownloadr.videosaver',1022,2049,344351,'11-10-2023','0.0.0.0','2023-10-12 11:37:34','2023-06-30 11:54:59',_binary '[binary data, 209824 characters]'),(190,'com.astroguide.astrolink.vedicastro.numerologija',12,15,33707,'11-10-2023','0.0.0.0','2023-10-12 11:29:45','2023-06-30 11:55:00',_binary '[binary data, 134144 characters]'),(191,'com.adharloanapp.ispronallife.adharhelping',4,3,19363,'11-10-2023','0.0.0.0','2023-10-12 08:10:42','2023-06-30 11:55:06',_binary '[binary data, 38146 characters]'),(192,'com.crackscreen.brokenscreen.fuunyscreenprank.brokeneffect',0,0,4320,'11-10-2023','0.0.0.0','2023-10-11 23:59:00','2023-06-30 11:55:17',_binary '[binary data, 13862 characters]'),(193,'com.fbdownloder.allfiledownload.downloaderstorysaver',57,111,18933,'11-10-2023','0.0.0.0','2023-10-12 11:25:12','2023-06-30 11:55:26',_binary '[binary data, 47666 characters]'),(194,'com.photoscreensaver.blackgallery',79,119,26980,'11-10-2023','0.0.0.0','2023-10-12 11:36:39','2023-06-30 11:55:45',_binary '[binary data, 37782 characters]'),(195,'videoplayer.audioplayer.musicplayer.videodownloader',21,43,5379,'11-10-2023','0.0.0.0','2023-10-12 10:18:15','2023-06-30 11:55:54',_binary '[binary data, 26793 characters]'),