May 13, 2022 at 5:07 PM
site : millionspoet.ae
All backup database sql
size : 99.5 MiB
Million's Poet is a reality television show on the United Arab Emirates television network Abu Dhabi TV and the Million's Poet Channel.
sample :
another sample :
All backup database sql
size : 99.5 MiB
Million's Poet is a reality television show on the United Arab Emirates television network Abu Dhabi TV and the Million's Poet Channel.
sample :
CREATE TABLE `transactions` (
`id_transactions` int(11) NOT NULL AUTO_INCREMENT,
`paymentgateway` enum('neo','ngenius') CHARACTER SET utf8 DEFAULT NULL,
`ngeniusstate` enum('STARTED','AUTHORISED','CAPTURED','PARTIALLY_CAPTURED','FAILED','POST_AUTH_REVIEW') CHARACTER SET utf8 DEFAULT NULL,
`sysid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`sort_order` int(1) NOT NULL DEFAULT '0',
`status` enum('pending','paid','canceled','failed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`lang` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`translation_id` int(11) DEFAULT '0',
`id_users` int(11) NOT NULL,
`amount` decimal(10,2) DEFAULT '0.00',
`number_of_votes` int(11) DEFAULT '0',
`guest_token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`paid` tinyint(1) NOT NULL DEFAULT '0',
`payment_date` datetime DEFAULT NULL,
`currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`free_vote` int(2) DEFAULT '0',
`source` enum('website','mobile','mobileapp') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'website',
`name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`discount` decimal(10,2) DEFAULT '0.00',
`net_amount` decimal(10,2) DEFAULT '0.00',
`merchantorderno` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`payment_card_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`id_countries` int(11) NOT NULL,
`errormsg` text COLLATE utf8_unicode_ci,
`city` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
`address` longtext CHARACTER SET utf8,
`qty` int(255) DEFAULT '0',
`answer` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
`question_id` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
`question_type` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
`question` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id_transactions`),
KEY `translation_id` (`id_transactions`),
KEY `id_users` (`id_users`),
KEY `id_countries` (`id_countries`)
) ENGINE=InnoDB AUTO_INCREMENT=162798 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transactions`
--
LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES (10,NULL,NULL,NULL,'2019-12-25 00:36:34',0,'paid','Transaction #10, 2019-12-25 00:36:34','ar',10,14496,3.00,1,'mobile1577219794',1,'2019-12-25 00:36:34','AED','2a95ea643cc0cf1871941055794a7ad3',1,'mobileapp','سعد السعد','[email protected]','',3.00,0.00,'0','','','93.169.138.189',0,'Success Payment',NULL,NULL,0,NULL,NULL,NULL,NULL),(11,NULL,NULL,NULL,'2019-12-25 00:36:52',0,'paid','Transaction #11, 2019-12-25 00:36:52','ar',11,14497,3.00,1,'mobile1577219812',1,'2019-12-25 00:36:52','AED','184e922bcdc5abd0c1cacbf05903a965',1,'mobileapp','Broq Broq','[email protected]','',3.00,0.00,'0','','','37.39.148.35',0,'Success Payment',NULL,NULL,0,NULL,NULL,NULL,NULL),(12,NULL,NULL,NULL,'2019-12-25 00:36:56',0,'paid','Transaction #12, 2019-12-25 00:36:56','ar',12,83,3.00,1,'mobile1577219816',1,'2019-12-25 00:36:56','AED','bc4a099ca10c9632cb422b7a2e69c8d6',1,'mobileapp','مشعل العتيبي','','51711838',3.00,0.00,'0','','+965','176.225.222.11',135,'Success Payment',NULL,NULL,0,NULL,NULL,NULL,NULL),(13,NULL,NULL,NULL,'2019-12-25 00:37:04',0,'pending','Transaction #13, 2019-12-25 00:37:04','ar',13,14496,3.00,1,'mobile1577219824',0,NULL,'AED','d3de128a9ff76530655edd53d11a42ac',0,'mobileapp','سعد السعد','[email protected]','',0.00,3.00,NULL,NULL,'','93.169.138.189',0,'Transaction Created',NULL,NULL,0,NULL,NULL,NULL,NULL),(14,NULL,NULL,NULL,'2019-12-25 00:37:08',0,'pending','Transaction #14, 2019-12-25 00:37:08','ar',14,14498,15.00,5,'mobile1577219828',0,NULL,'AED','d8216f5131f554f446520e1978d7415a',1,'mobileapp','Mishal Bin Mohsen','[email protected]','',3.00,12.00,NULL,NULL,'','78.95.86.239',0,'Transaction Created',NULL,NULL,0,NULL,NULL,NULL,NULL),(15,NULL,NULL,NULL,'2019-12-25 00:37:18',0,'pending','Transaction #15, 2019-12-25 00:37:18','ar',15,14497,3.00,1,'mobile1577219838',0,NULL,'AED','6f6fb3cbab2c26dc0ef97c7a8e6aa5d0',0,'mobileapp','Broq Broq','[email protected]','',0.00,3.00,NULL,NULL,'','37.39.148.35',0,'Transaction Created',NULL,NULL,0,NULL,NULL,NULL,NULL),(16,NULL,NULL,NULL,'2019-12-25 00:37:27',0,'pending','Transaction #16, 2019-12-25 00:37:27','ar',
another sample :
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id_users` int(11) NOT NULL AUTO_INCREMENT,
`twitterid` bigint(255) NOT NULL DEFAULT '0',
`facebookid` bigint(255) NOT NULL DEFAULT '0',
`module` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`record` int(11) NOT NULL,
`created_on` datetime DEFAULT NULL,
`sort_order` int(1) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`lang` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`translation_id` int(11) DEFAULT '0',
`name` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`emailvalid` tinyint(1) NOT NULL DEFAULT '0',
`password` text COLLATE utf8_unicode_ci,
`salt` text COLLATE utf8_unicode_ci NOT NULL,
`login_token` text COLLATE utf8_unicode_ci NOT NULL,
`photo` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`id_roles` int(11) NOT NULL,
`manage_trash` tinyint(1) NOT NULL,
`manage_log` tinyint(1) NOT NULL,
`confirm_password` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`old_password` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`manage_his_content` int(1) NOT NULL,
`manage_his_division` int(1) NOT NULL,
`token` varchar(900) COLLATE utf8_unicode_ci NOT NULL,
`activation_token` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`activation_date` datetime DEFAULT NULL,
`phone_code` int(11) DEFAULT '0',
`phone` int(11) DEFAULT '0',
`android_token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`ios_token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`id_countries` int(11) NOT NULL DEFAULT '0',
`token_for_business` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`username` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`enable_push_notifications` tinyint(1) NOT NULL DEFAULT '1',
`ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
`address` longtext CHARACTER SET utf8,
PRIMARY KEY (`id_users`),
KEY `translation_id` (`id_users`),
KEY `id_roles` (`id_roles`),
KEY `record` (`record`),
KEY `id_countries` (`id_countries`)
) ENGINE=InnoDB AUTO_INCREMENT=268628 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,343424323,10155589951701735,'',0,'2017-06-15 14:10:41',1,1,'Rami 11ff','en',0,'Rami Zaklit','[email protected]',0,'44f8027c40374fa4be6cbf2a8bace416ce6b604df5b5cd0d28043fc10fe0eff1','942df574c0f657543e5865d01bb127f6','bc2a9beb0bb462121990d36114f0386d','',1,0,0,'123456789','Rami','Zaklit','123456789',0,0,'',NULL,NULL,1684,70000000,'APA91bEYuj_EpeSPj1uZuNy5NC3lng4uh-GeaREzMasP-yQO7DdlqEhsXoRvtX0FGSQDRLHRVgsdoiuKzwKaI9NGb8NNcwdaKadYfgvNQhkY7bHOKxnYVEVp-XPMcv4117ji030iYchP','',1,'asdad1231312','ramizaklit1547033411',1,NULL,NULL,NULL),(52,0,0,'',0,'2018-11-04 23:17:43',0,1,NULL,'en',0,'Poet Admin','[email protected]',0,'35f18fd8db1d01d1112cd962b59b490b71ed0e11f6c7c2c3aa02b6f9d038cc74','075e5573cccb909ec4ef117799899931','fd1c8f39bd0f58b5d19d5036a0777812',NULL,2,0,0,'Poet@123','Poet','Admin','Poet@123',0,0,'',NULL,NULL,0,0,'','',0,NULL,NULL,0,NULL,NULL,NULL),(57,0,0,'',0,'2019-05-03 12:27:43',0,1,NULL,'ar',0,'شاهر سايل الشراري','[email protected]',0,'243d1ba8f47482220e23015971ff1251d0c1898eded0d1fd5ed6f4d4803ba055','147fca0034c3557f390c9a23fb0825b2','8c154a6d508b202a0b94bd8ece340473',NULL,3,0,0,NULL,NULL,NULL,NULL,0,0,'','99e7f73f73a6bb595e28cd3f8232ba98','2019-05-03 12:28:49',


