📁 File Manager Pro
v10.0.3 | PHP: 8.1.34
Server: LiteSpeed
2026-07-01 04:45:48
📂
/ (Root)
/
var
/
softaculous
/
hizup
📍 /var/softaculous/hizup
🔄 Refresh
✏️
Editing: hizup.sql
Read Only
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8 */; -- -- Database: `ph71801` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]admins` -- CREATE TABLE `[[dbprefix]]admins` ( `profileId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) NOT NULL, `password` varchar(120) NOT NULL, `email` varchar(120) NOT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `sex` enum('male','female') NOT NULL DEFAULT 'male', `lang` varchar(5) NOT NULL DEFAULT 'en_US', `timeZone` varchar(6) NOT NULL DEFAULT '-6', `joinDate` datetime DEFAULT NULL, `lastActivity` datetime DEFAULT NULL, `lastEdit` datetime DEFAULT NULL, `ban` enum('0','1') DEFAULT '0', `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `isTwoFactorAuth` enum('1','0') DEFAULT '0', `twoFactorAuthSecret` varchar(40) DEFAULT NULL, `hashValidation` varchar(40) DEFAULT NULL, PRIMARY KEY (`profileId`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]admins` -- INSERT INTO `[[dbprefix]]admins` VALUES (1, '[[admin_username]]', '[[admin_pass]]', '[[admin_email]]', '[[admin_fname]]', '[[admin_lname]]', 'male', 'en_US', '-6', '[[regtime]]', '[[regtime]]', NULL, '0', '[[clientip]]', '0', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]admins_attempts_login` -- CREATE TABLE `[[dbprefix]]admins_attempts_login` ( `attemptsId` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL DEFAULT '', `attempts` smallint(5) unsigned NOT NULL, `lastLogin` datetime NOT NULL, PRIMARY KEY (`attemptsId`), UNIQUE KEY `ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]admins_log_login` -- CREATE TABLE `[[dbprefix]]admins_log_login` ( `logId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(120) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `password` varchar(40) DEFAULT NULL, `status` varchar(60) NOT NULL DEFAULT '', `ip` varchar(45) NOT NULL DEFAULT '', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`logId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]admins_log_sess` -- CREATE TABLE `[[dbprefix]]admins_log_sess` ( `sessionId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` tinyint(3) unsigned NOT NULL, `username` varchar(40) DEFAULT NULL, `email` varchar(120) DEFAULT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`sessionId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]ads` -- CREATE TABLE `[[dbprefix]]ads` ( `adsId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) DEFAULT NULL, `code` text, `active` enum('1','0') DEFAULT '1', `width` smallint(3) unsigned DEFAULT NULL, `height` smallint(3) unsigned DEFAULT NULL, `views` int(10) unsigned NOT NULL DEFAULT '0', `clicks` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`adsId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=17 ; -- -- Dumping data for table `[[dbprefix]]ads` -- INSERT INTO `[[dbprefix]]ads` VALUES (1, 'Sponsor pH7Builder 1 (728x90)', '<a href="#0"><img data-src="holder.js/728x90" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 728, 90, 0, 0), (2, 'Sponsor pH7Builder 2 (728x90)', '<a href="#0"><img data-src="holder.js/728x90" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 728, 90, 0, 0), (3, 'Sponsor pH7Builder 3 (200x200)', '<a href="#0"><img data-src="holder.js/200x200" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 200, 200, 0, 0), (4, 'Sponsor pH7Builder 4 (200x200)', '<a href="#0"><img data-src="holder.js/200x200" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 200, 200, 0, 0), (5, 'Sponsor pH7Builder 5 (250x250)', '<a href="#0"><img data-src="holder.js/250x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 250, 250, 0, 0), (6, 'Sponsor pH7Builder 6 (250x250)', '<a href="#0"><img data-src="holder.js/250x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 250, 250, 0, 0), (7, 'Sponsor pH7Builder 7 (468x60)', '<a href="#0"><img data-src="holder.js/468x60" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 468, 60, 0, 0), (8, 'Sponsor pH7Builder 8 (468x60)', '<a href="#0"><img data-src="holder.js/468x60" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 468, 60, 0, 0), (9, 'Sponsor pH7Builder 9 (300x250)', '<a href="#0"><img data-src="holder.js/300x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 300, 250, 0, 0), (10, 'Sponsor pH7Builder 10 (300x250)', '<a href="#0"><img data-src="holder.js/300x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 300, 250, 0, 0), (11, 'Sponsor pH7Builder 11 (336x280)', '<a href="#0"><img data-src="holder.js/336x280" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 336, 280, 0, 0), (12, 'Sponsor pH7Builder 12 (336x280)', '<a href="#0"><img data-src="holder.js/336x280" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 336, 280, 0, 0), (13, 'Sponsor pH7Builder 13 (120x600)', '<a href="#0"><img data-src="holder.js/120x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 120, 600, 0, 0), (14, 'Sponsor pH7Builder 14 (120x600)', '<a href="#0"><img data-src="holder.js/120x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 120, 600, 0, 0), (15, 'Sponsor pH7Builder 15 (160x600)', '<a href="#0"><img data-src="holder.js/160x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 160, 600, 0, 0), (16, 'Sponsor pH7Builder 16 (160x600)', '<a href="#0"><img data-src="holder.js/160x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 160, 600, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]ads_affiliates` -- CREATE TABLE `[[dbprefix]]ads_affiliates` ( `adsId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) DEFAULT NULL, `code` text, `active` enum('1','0') DEFAULT '1', `width` smallint(3) unsigned DEFAULT NULL, `height` smallint(3) unsigned DEFAULT NULL, PRIMARY KEY (`adsId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=17 ; -- -- Dumping data for table `[[dbprefix]]ads_affiliates` -- INSERT INTO `[[dbprefix]]ads_affiliates` VALUES (1, 'Affiliate Banner 1 (728x90)', '<a href="%affiliate_url%"><img data-src="holder.js/728x90" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 728, 90), (2, 'Affiliate Banner 2 (728x90)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/728x90" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 728, 90), (3, 'Affiliate Banner 3 (200x200)', '<a href="%affiliate_url%"><img data-src="holder.js/200x200" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 200, 200), (4, 'Affiliate Banner 4 (200x200)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/200x200" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 200, 200), (5, 'Affiliate Banner 5 (250x250)', '<a href="%affiliate_url%"><img data-src="holder.js/250x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 250, 250), (6, 'Affiliate Banner 6 (250x250)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/250x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 250, 250), (7, 'Affiliate Banner 7 (468x60)', '<a href="%affiliate_url%"><img data-src="holder.js/468x60" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 468, 60), (8, 'Affiliate Banner 8 (468x60)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/468x60" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 468, 60), (9, 'Affiliate Banner 9 (300x250)', '<a href="%affiliate_url%"><img data-src="holder.js/300x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 300, 250), (10, 'Affiliate Banner 10 (300x250)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/300x250" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 300, 250), (11, 'Affiliate Banner 11 (336x280)', '<a href="%affiliate_url%"><img data-src="holder.js/336x280" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 336, 280), (12, 'Affiliate Banner 12 (336x280)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/336x280" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 336, 280), (13, 'Affiliate Banner 13 (120x600)', '<a href="%affiliate_url%"><img data-src="holder.js/120x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 120, 600), (14, 'Affiliate Banner 14 (120x600)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/120x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 120, 600), (15, 'Affiliate Banner 15 (160x600)', '<a href="%affiliate_url%"><img data-src="holder.js/160x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 160, 600), (16, 'Affiliate Banner 16 (160x600)', '<a href="%affiliate_url%/signup"><img data-src="holder.js/160x600" alt="%site_name% by %software_name%" title="%site_name% powered by %software_name%" /></a>', '0', 160, 600); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates` -- CREATE TABLE `[[dbprefix]]affiliates` ( `profileId` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) NOT NULL, `firstName` varchar(50) NOT NULL, `lastName` varchar(50) NOT NULL, `password` varchar(120) NOT NULL, `email` varchar(120) NOT NULL, `sex` enum('male','female') NOT NULL DEFAULT 'male', `birthDate` date DEFAULT NULL, `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `bankAccount` varchar(150) DEFAULT NULL, `amount` decimal(8,2) NOT NULL DEFAULT '0.00', `totalPayment` decimal(8,2) NOT NULL DEFAULT '0.00', `lastPayment` decimal(8,2) NOT NULL DEFAULT '0.00', `lastPaymentDate` datetime DEFAULT NULL, `lang` varchar(5) NOT NULL DEFAULT 'en_US', `hashValidation` varchar(40) DEFAULT NULL, `isTwoFactorAuth` enum('1','0') DEFAULT '0', `twoFactorAuthSecret` varchar(40) DEFAULT NULL, `refer` int(10) unsigned DEFAULT '0', `joinDate` datetime DEFAULT NULL, `lastActivity` datetime DEFAULT NULL, `lastEdit` datetime DEFAULT NULL, `affiliatedId` int(10) unsigned NOT NULL DEFAULT '0', `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `ban` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`profileId`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), UNIQUE KEY `bankAccount` (`bankAccount`), KEY `birthDate` (`birthDate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]affiliates` -- INSERT INTO `[[dbprefix]]affiliates` VALUES (1, 'jkozey', 'Antonietta', 'Mertz', '$2y$12$S.crJ.9ToHTL7de5w9XOEOyrKt/iKv2dvmPKe7A53KyGcm1kDkLTm', 'koss.vito@little.com', 'male', '1968-08-14', '140.87.166.9', 'garrison12@doyle.com', '0.00', '0.00', '0.00', NULL, 'el_GR', NULL, '0', NULL, 0, '[[regtime]]', '[[regtime]]', NULL, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates_attempts_login` -- CREATE TABLE `[[dbprefix]]affiliates_attempts_login` ( `attemptsId` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL DEFAULT '', `attempts` smallint(5) unsigned NOT NULL, `lastLogin` datetime NOT NULL, PRIMARY KEY (`attemptsId`), UNIQUE KEY `ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates_countries` -- CREATE TABLE `[[dbprefix]]affiliates_countries` ( `countryId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `countryCode` char(2) NOT NULL, PRIMARY KEY (`countryId`), UNIQUE KEY `countryCode` (`countryCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=243 ; -- -- Dumping data for table `[[dbprefix]]affiliates_countries` -- INSERT INTO `[[dbprefix]]affiliates_countries` VALUES (1, 'AD'), (2, 'AE'), (3, 'AF'), (4, 'AG'), (5, 'AI'), (6, 'AL'), (7, 'AM'), (8, 'AN'), (9, 'AO'), (10, 'AQ'), (11, 'AR'), (12, 'AS'), (13, 'AT'), (14, 'AU'), (15, 'AW'), (16, 'AX'), (17, 'AZ'), (18, 'BA'), (19, 'BB'), (20, 'BD'), (21, 'BE'), (22, 'BF'), (23, 'BG'), (24, 'BH'), (25, 'BI'), (26, 'BJ'), (27, 'BM'), (28, 'BN'), (29, 'BO'), (30, 'BR'), (31, 'BS'), (32, 'BT'), (33, 'BV'), (34, 'BW'), (35, 'BY'), (36, 'BZ'), (37, 'CA'), (38, 'CC'), (39, 'CD'), (40, 'CF'), (41, 'CG'), (42, 'CH'), (43, 'CI'), (44, 'CK'), (45, 'CL'), (46, 'CM'), (47, 'CN'), (48, 'CO'), (49, 'CR'), (50, 'CU'), (51, 'CV'), (52, 'CX'), (53, 'CY'), (54, 'CZ'), (55, 'DE'), (56, 'DJ'), (57, 'DK'), (58, 'DM'), (59, 'DO'), (60, 'DZ'), (61, 'EC'), (62, 'EE'), (63, 'EG'), (64, 'EH'), (65, 'ER'), (66, 'ES'), (67, 'ET'), (68, 'FI'), (69, 'FJ'), (70, 'FK'), (71, 'FM'), (72, 'FO'), (73, 'FR'), (74, 'FX'), (75, 'GA'), (76, 'GD'), (77, 'GE'), (78, 'GF'), (79, 'GH'), (80, 'GI'), (81, 'GL'), (82, 'GM'), (83, 'GN'), (84, 'GP'), (85, 'GQ'), (86, 'GR'), (87, 'GS'), (88, 'GT'), (89, 'GU'), (90, 'GW'), (91, 'GY'), (92, 'HK'), (93, 'HM'), (94, 'HN'), (95, 'HR'), (96, 'HT'), (97, 'HU'), (98, 'ID'), (99, 'IE'), (100, 'IL'), (101, 'IN'), (102, 'IO'), (103, 'IQ'), (104, 'IR'), (105, 'IS'), (106, 'IT'), (107, 'JM'), (108, 'JO'), (109, 'JP'), (110, 'KE'), (111, 'KG'), (112, 'KH'), (113, 'KI'), (114, 'KM'), (115, 'KN'), (116, 'KP'), (117, 'KR'), (118, 'KW'), (119, 'KY'), (120, 'KZ'), (121, 'LA'), (122, 'LB'), (123, 'LC'), (124, 'LI'), (125, 'LK'), (126, 'LR'), (127, 'LS'), (128, 'LT'), (129, 'LU'), (130, 'LV'), (131, 'LY'), (132, 'MA'), (133, 'MC'), (134, 'MD'), (135, 'ME'), (136, 'MG'), (137, 'MH'), (138, 'MK'), (139, 'ML'), (140, 'MM'), (141, 'MN'), (142, 'MO'), (143, 'MP'), (144, 'MQ'), (145, 'MR'), (146, 'MS'), (147, 'MT'), (148, 'MU'), (149, 'MV'), (150, 'MW'), (151, 'MX'), (152, 'MY'), (153, 'MZ'), (154, 'NA'), (155, 'NC'), (156, 'NE'), (157, 'NF'), (158, 'NG'), (159, 'NI'), (160, 'NL'), (161, 'NO'), (162, 'NP'), (163, 'NR'), (164, 'NU'), (165, 'NZ'), (166, 'OM'), (167, 'PA'), (168, 'PE'), (169, 'PF'), (170, 'PG'), (171, 'PH'), (172, 'PK'), (173, 'PL'), (174, 'PM'), (175, 'PN'), (176, 'PR'), (177, 'PT'), (178, 'PW'), (179, 'PY'), (180, 'QA'), (181, 'RE'), (182, 'RO'), (183, 'RS'), (184, 'RU'), (185, 'RW'), (186, 'SA'), (187, 'SB'), (188, 'SC'), (189, 'SD'), (190, 'SE'), (191, 'SG'), (192, 'SH'), (193, 'SI'), (194, 'SJ'), (195, 'SK'), (196, 'SL'), (197, 'SM'), (198, 'SN'), (199, 'SO'), (200, 'SR'), (201, 'ST'), (202, 'SV'), (203, 'SY'), (204, 'SZ'), (205, 'TC'), (206, 'TD'), (207, 'TF'), (208, 'TG'), (209, 'TH'), (210, 'TJ'), (211, 'TK'), (212, 'TM'), (213, 'TN'), (214, 'TO'), (215, 'TP'), (216, 'TR'), (217, 'TT'), (218, 'TV'), (219, 'TW'), (220, 'TZ'), (221, 'UA'), (222, 'UG'), (223, 'UK'), (224, 'UM'), (225, 'US'), (226, 'UY'), (227, 'UZ'), (228, 'VA'), (229, 'VC'), (230, 'VE'), (231, 'VG'), (232, 'VI'), (233, 'VN'), (234, 'VU'), (235, 'WF'), (236, 'WS'), (237, 'XK'), (238, 'YE'), (239, 'YT'), (240, 'ZA'), (241, 'ZM'), (242, 'ZW'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates_info` -- CREATE TABLE `[[dbprefix]]affiliates_info` ( `profileId` int(10) unsigned NOT NULL, `middleName` varchar(50) DEFAULT NULL, `businessName` varchar(100) DEFAULT NULL, `taxId` varchar(40) DEFAULT NULL, `address` varchar(191) DEFAULT NULL, `country` char(2) DEFAULT NULL, `city` varchar(150) DEFAULT NULL, `state` varchar(150) DEFAULT NULL, `zipCode` varchar(20) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `description` text, `website` varchar(120) DEFAULT NULL, PRIMARY KEY (`profileId`), KEY `country` (`country`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]affiliates_info` -- INSERT INTO `[[dbprefix]]affiliates_info` VALUES (1, '', NULL, NULL, NULL, 'NU', 'Muellershire', '', '45866-8159', '678.212.8032', 'Omnis facilis hic error in. Hic omnis eum nemo sint dolore dolorum.', 'https://pierrehenry.be'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates_log_login` -- CREATE TABLE `[[dbprefix]]affiliates_log_login` ( `logId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(120) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `password` varchar(40) DEFAULT NULL, `status` varchar(60) NOT NULL DEFAULT '', `ip` varchar(45) NOT NULL DEFAULT '', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`logId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]affiliates_log_sess` -- CREATE TABLE `[[dbprefix]]affiliates_log_sess` ( `sessionId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `username` varchar(40) DEFAULT NULL, `email` varchar(120) DEFAULT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`sessionId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]albums_pictures` -- CREATE TABLE `[[dbprefix]]albums_pictures` ( `albumId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `name` varchar(80) NOT NULL, `thumb` char(11) NOT NULL, `approved` enum('1','0') DEFAULT '1', `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `description` varchar(191) DEFAULT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`albumId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]albums_videos` -- CREATE TABLE `[[dbprefix]]albums_videos` ( `albumId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `name` varchar(80) NOT NULL, `thumb` char(11) NOT NULL, `approved` enum('1','0') DEFAULT '1', `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `description` varchar(191) DEFAULT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`albumId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]analytics_api` -- CREATE TABLE `[[dbprefix]]analytics_api` ( `analyticsId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) DEFAULT NULL, `code` text, `active` enum('1','0') DEFAULT '1', PRIMARY KEY (`analyticsId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]analytics_api` -- INSERT INTO `[[dbprefix]]analytics_api` VALUES (1, 'Analytics Code', '', '1'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_countries` -- CREATE TABLE `[[dbprefix]]block_countries` ( `countryId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `countryCode` char(2) NOT NULL, PRIMARY KEY (`countryId`), UNIQUE KEY `countryCode` (`countryCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_ip` -- CREATE TABLE `[[dbprefix]]block_ip` ( `ipId` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL, `expiration` smallint(5) unsigned NOT NULL, PRIMARY KEY (`ip`), KEY `ipId` (`ipId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]blogs` -- CREATE TABLE `[[dbprefix]]blogs` ( `blogId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `postId` varchar(60) NOT NULL, `langId` char(2) NOT NULL DEFAULT '', `title` varchar(100) DEFAULT NULL, `content` longtext NOT NULL, `pageTitle` varchar(100) NOT NULL, `metaDescription` varchar(191) NOT NULL, `metaKeywords` varchar(191) NOT NULL, `slogan` varchar(191) NOT NULL, `metaRobots` varchar(50) NOT NULL, `metaAuthor` varchar(50) NOT NULL, `metaCopyright` varchar(50) NOT NULL, `tags` varchar(191) DEFAULT NULL, `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `enableComment` enum('1','0') DEFAULT '1', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`blogId`), UNIQUE KEY `postId` (`postId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]blogs_categories` -- CREATE TABLE `[[dbprefix]]blogs_categories` ( `categoryId` smallint(4) unsigned NOT NULL, `blogId` mediumint(10) unsigned NOT NULL, KEY `categoryId` (`categoryId`), KEY `blogId` (`blogId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]blogs_data_categories` -- CREATE TABLE `[[dbprefix]]blogs_data_categories` ( `categoryId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) DEFAULT NULL, PRIMARY KEY (`categoryId`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=21 ; -- -- Dumping data for table `[[dbprefix]]blogs_data_categories` -- INSERT INTO `[[dbprefix]]blogs_data_categories` VALUES (1, 'Affiliate'), (2, 'Business'), (3, 'Company'), (4, 'Dating'), (5, 'Education'), (6, 'Family'), (7, 'Food'), (8, 'Game'), (9, 'Health'), (10, 'Hobby'), (11, 'Movie'), (12, 'Music'), (13, 'News'), (14, 'Programming'), (15, 'Recreation'), (16, 'Shopping'), (17, 'Society'), (18, 'Sports'), (19, 'Technology'), (20, 'Travel'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]bottom_menus` -- CREATE TABLE `[[dbprefix]]bottom_menus` ( `menuId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `vendorName` varchar(40) NOT NULL, `moduleName` varchar(40) NOT NULL, `controllerName` varchar(40) NOT NULL, `actionName` varchar(40) NOT NULL, `vars` varchar(60) DEFAULT NULL, `parentMenu` smallint(4) unsigned DEFAULT NULL, `grandParentMenu` smallint(4) unsigned DEFAULT NULL, `active` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`menuId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments_blog` -- CREATE TABLE `[[dbprefix]]comments_blog` ( `commentId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL, `recipient` mediumint(10) unsigned NOT NULL, `comment` text NOT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` enum('1','0') NOT NULL DEFAULT '1', PRIMARY KEY (`commentId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments_note` -- CREATE TABLE `[[dbprefix]]comments_note` ( `commentId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL, `recipient` int(10) unsigned NOT NULL, `comment` text NOT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` enum('1','0') NOT NULL DEFAULT '1', PRIMARY KEY (`commentId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments_picture` -- CREATE TABLE `[[dbprefix]]comments_picture` ( `commentId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL, `recipient` int(10) unsigned NOT NULL, `comment` text NOT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` enum('1','0') NOT NULL DEFAULT '1', PRIMARY KEY (`commentId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments_profile` -- CREATE TABLE `[[dbprefix]]comments_profile` ( `commentId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL, `recipient` int(10) unsigned NOT NULL, `comment` text NOT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` enum('1','0') DEFAULT '1', PRIMARY KEY (`commentId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]comments_video` -- CREATE TABLE `[[dbprefix]]comments_video` ( `commentId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL, `recipient` int(10) unsigned NOT NULL, `comment` text NOT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` enum('1','0') NOT NULL DEFAULT '1', PRIMARY KEY (`commentId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]custom_code` -- CREATE TABLE `[[dbprefix]]custom_code` ( `code` text, `codeType` enum('css','js') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]custom_code` -- INSERT INTO `[[dbprefix]]custom_code` VALUES ('/* Your custom CSS code here */\r\n', 'css'), ('/* Your custom JS code here */\r\n', 'js'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]forums` -- CREATE TABLE `[[dbprefix]]forums` ( `forumId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL DEFAULT 'New forum', `description` varchar(191) NOT NULL, `categoryId` smallint(4) unsigned DEFAULT NULL, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`forumId`), KEY `categoryId` (`categoryId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]forums` -- INSERT INTO `[[dbprefix]]forums` VALUES (1, 'Hello', 'Free dating site', 1, NULL, NULL), (2, 'Online Dating', 'Discussion about the online dating websites', 2, NULL, NULL), (3, 'The Best Dating Site', 'The best dating site', 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]forums_categories` -- CREATE TABLE `[[dbprefix]]forums_categories` ( `categoryId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(60) DEFAULT NULL, PRIMARY KEY (`categoryId`), UNIQUE KEY `title` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]forums_categories` -- INSERT INTO `[[dbprefix]]forums_categories` VALUES (3, 'Business'), (2, 'Free Online Dating Site'), (1, 'General'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]forums_messages` -- CREATE TABLE `[[dbprefix]]forums_messages` ( `messageId` int(10) unsigned NOT NULL AUTO_INCREMENT, `topicId` int(10) unsigned NOT NULL, `profileId` int(10) unsigned NOT NULL, `message` text NOT NULL, `approved` enum('1','0') DEFAULT '1', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`messageId`), KEY `topicId` (`topicId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]forums_topics` -- CREATE TABLE `[[dbprefix]]forums_topics` ( `topicId` int(10) unsigned NOT NULL AUTO_INCREMENT, `forumId` mediumint(10) unsigned DEFAULT NULL, `profileId` int(10) unsigned NOT NULL, `title` varchar(100) NOT NULL, `message` text NOT NULL, `approved` enum('1','0') DEFAULT '1', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `views` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`topicId`), KEY `forumId` (`forumId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]languages_info` -- CREATE TABLE `[[dbprefix]]languages_info` ( `langId` varchar(5) NOT NULL, `name` varchar(60) NOT NULL, `charset` varchar(15) NOT NULL, `active` enum('0','1') NOT NULL DEFAULT '0', `direction` enum('ltr','rtl') NOT NULL DEFAULT 'ltr', `author` varchar(60) NOT NULL, `website` varchar(120) DEFAULT NULL, `email` varchar(120) DEFAULT NULL, PRIMARY KEY (`langId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]languages_info` -- INSERT INTO `[[dbprefix]]languages_info` VALUES ('en_US', 'English', 'UTF-8', '1', 'ltr', 'Pierre-Henry Soria', 'http://ph7.me', 'hi@ph7.me'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]likes` -- CREATE TABLE `[[dbprefix]]likes` ( `keyId` varchar(191) NOT NULL, `votes` int(10) unsigned NOT NULL, `lastVote` datetime NOT NULL, `lastIp` varchar(45) NOT NULL, UNIQUE KEY `keyId` (`keyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_error` -- CREATE TABLE `[[dbprefix]]log_error` ( `logId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `logError` longtext, PRIMARY KEY (`logId`), FULLTEXT KEY `logError` (`logError`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members` -- CREATE TABLE `[[dbprefix]]members` ( `profileId` int(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(120) NOT NULL, `username` varchar(40) NOT NULL, `password` varchar(120) NOT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `birthDate` date DEFAULT NULL, `sex` enum('male','female','couple') NOT NULL DEFAULT 'female', `matchSex` set('male','female','couple') NOT NULL DEFAULT 'male', `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `bankAccount` varchar(150) DEFAULT NULL, `groupId` tinyint(2) unsigned NOT NULL DEFAULT '2', `membershipDate` datetime DEFAULT NULL, `userStatus` tinyint(1) unsigned NOT NULL DEFAULT '1', `joinDate` datetime DEFAULT NULL, `lastActivity` datetime DEFAULT NULL, `lastEdit` datetime DEFAULT NULL, `avatar` char(5) DEFAULT NULL, `approvedAvatar` tinyint(1) unsigned NOT NULL DEFAULT '1', `featured` tinyint(1) unsigned NOT NULL DEFAULT '0', `lang` varchar(5) NOT NULL DEFAULT 'en_US', `hashValidation` varchar(40) DEFAULT NULL, `isTwoFactorAuth` enum('1','0') DEFAULT '0', `twoFactorAuthSecret` varchar(40) DEFAULT NULL, `views` int(11) unsigned NOT NULL DEFAULT '0', `reference` varchar(191) DEFAULT NULL, `votes` int(11) DEFAULT '0', `score` float DEFAULT '0', `credits` int(6) unsigned NOT NULL DEFAULT '0', `affiliatedId` int(10) unsigned NOT NULL DEFAULT '0', `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `ban` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`profileId`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), KEY `groupId` (`groupId`), KEY `birthDate` (`birthDate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=18 ; -- -- Dumping data for table `[[dbprefix]]members` -- INSERT INTO `[[dbprefix]]members` VALUES (1, 'ghost@ghost', 'ghost', '582428c52630c8771867157aaee56a798a1cb376', 'Ghost', 'The Ghost', '1001-01-01', 'female', 'male', '00.000.00.00', NULL, 2, NULL, 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'en_US', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 0, 0), (2, 'koss.vito@little.com', 'jkozey', '$2y$12$/JlwU4JDduqwzkU6cX7OsuQ.JJlCJaDuLHLsr5zHICbaAyA.GJ9PG', 'Antonietta', 'Mertz', '1968-08-14', 'male', 'female', '140.87.166.9', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'el_GR', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (3, 'sibyl.tromp@gmail.com', 'lacy-hauck', '$2y$12$oiqH72d0RiAM1jN/6ZYQFehL.6bXyAztoPHcu/5lXq7LvHhhKBlF6', 'Marquise', 'Yost', '1970-06-14', 'female', 'couple', '198.247.55.72', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'fr_BE', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (4, 'margarita.graham@hane.com', 'will-hillary', '$2y$12$yQCdCWFStF9DgVlA3HFnXOdvWbX/eFseK4yj/ZSRjzmS6Wyh1aXqm', 'Lenore', 'McKenzie', '1987-08-06', 'male', 'female', '84.225.102.176', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'te_IN', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (5, 'alexandria.effertz@hagenes.com', 'julien-volkman', '$2y$12$03TDFI.wOG3l/pTK4wEX..ZxgwwWB/v4Qtlx1m.zXWsg6GmanGMuS', 'Graham', 'Collier', '1986-07-30', 'female', 'male', '152.53.194.243', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'ru_UA', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (6, 'josue87@yahoo.com', 'tabitha27', '$2y$12$Bip0kEn6tVmgQZbIFNTahO7REG/aPvMXICD4Z7t6vobWqgIX7D3dy', 'Sherman', 'Wolff', '1984-11-02', 'female', 'couple', '122.50.61.1', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'es_CL', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (7, 'uwisozk@boehm.com', 'hettinger-moriah', '$2y$12$L/0faRAnHoJ0oSl5.FCZQO5.GmmchoMEutXNRjwgn9uSJkECzd.lS', 'Abagail', 'Grimes', '1968-12-11', 'female', 'female', '32.203.149.233', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'en_GU', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (8, 'jabari43@gmail.com', 'maximilian-halvorson', '$2y$12$hxlgV/nUrmWn3P0KjvCksOrj6duRnxuiq5/aYxHe90.PLHM1sJ7uy', 'Skylar', 'Ernser', '1990-07-25', 'male', 'couple', '203.47.140.215', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'sr_ME', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (9, 'smoore@hotmail.com', 'kmohr', '$2y$12$ssSE8vwk.SjRRBd7c5BHzO3qlC8fhK4pILz1Tbp0IxFWocpZeBxNS', 'Macy', 'Ziemann', '1978-09-14', 'female', 'female', '236.159.100.14', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'ln_CD', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (10, 'vbins@yahoo.com', 'umitchell', '$2y$12$s6CWvdUFSi1kjOvwo2TXn.wGeAf6rDRPnCs8TvzJv.h2UsLxPOV5O', 'Leif', 'Zemlak', '1999-05-14', 'female', 'female', '203.119.88.203', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'fi_FI', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (11, 'nasir.mertz@keebler.com', 'hschulist', '$2y$12$vAgB6xmR25JDelo.iAHWie4xwVd7g61Jgmk.kfQZJCN1cMnbvj1j6', 'Meredith', 'Kreiger', '1966-10-14', 'male', 'couple', '180.168.192.186', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'mn_CN', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (12, 'trever.fritsch@gmail.com', 'vortiz', '$2y$12$W0aeNJWVS.ZV9Dw/1t7.rOCxUgqIOIHD4IjF1KJ6ASn2t3B7Hmhz2', 'Verona', 'O''Reilly', '1975-01-09', 'male', 'couple', '238.121.51.147', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'en_UM', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (13, 'taurean68@yahoo.com', 'mable32', '$2y$12$dU5VIeamFlhzN67uUhO.Nu2P6Rq3UINrtE/kxCy/BAj9w2Qxrbn0q', 'Yasmeen', 'McKenzie', '1972-05-23', 'female', 'female', '216.87.127.34', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'fi_FI', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (14, 'sid46@braun.com', 'ressie-jacobson', '$2y$12$.J5drfi5VbTNGcXn04LGsOrNB8qD2bbMCE31esuY4nyriqDZccPUa', 'Gunner', 'Breitenberg', '1974-12-18', 'male', 'female', '67.78.197.163', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'en_SG', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (15, 'maynard86@gmail.com', 'schmitt-clifton', '$2y$12$54mZehUw0RUAEGlZz0kHD.kq9vzLVmMFq./OPRCKcDBu6HNeFNRRq', 'Sim', 'Anderson', '2007-03-25', 'female', 'male', '73.98.27.81', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'nds_D', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (16, 'ohara.shania@leuschke.org', 'mattie38', '$2y$12$s7qOws5dS1tTr/x9MhcrduRpBYlLLOiEC9Yi1AWlbnwI4XceJNzMe', 'Myrna', 'Green', '1990-07-28', 'female', 'couple', '229.178.213.135', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'haw_U', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0), (17, 'roselyn89@lueilwitz.net', 'ldoyle', '$2y$12$xDqRHpRB/KzRnYGzKVTmF.z/7aBKy8Dmr4MJLXFfzymiwwR7imUsi', 'Verna', 'Franecki', '1977-11-09', 'female', 'couple', '158.80.90.224', NULL, 2, '[[regtime]]', 1, '[[regtime]]', '[[regtime]]', NULL, NULL, 1, 0, 'te_IN', NULL, '0', NULL, 0, NULL, 0, 0, 0, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]memberships` -- CREATE TABLE `[[dbprefix]]memberships` ( `groupId` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '', `description` varchar(191) NOT NULL, `permissions` text NOT NULL, `price` decimal(10,2) unsigned NOT NULL, `expirationDays` smallint(4) unsigned NOT NULL, `enable` enum('1','0') DEFAULT '1', PRIMARY KEY (`groupId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=10 ; -- -- Dumping data for table `[[dbprefix]]memberships` -- INSERT INTO `[[dbprefix]]memberships` VALUES (1, 'Visitor (not visible)', 'This subscription is offered to all visitors who visit the site.', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"0";s:10:"send_mails";s:1:"0";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"0";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"0";s:17:"instant_messaging";s:1:"0";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"0";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"0";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"0";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"0";s:19:"answer_forum_topics";s:1:"0";s:18:"member_site_access";s:1:"0";}', '0.00', 0, '1'), (2, 'Regular (Free)', 'Free Membership.', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"1";s:10:"send_mails";s:1:"1";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"1";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"1";s:17:"instant_messaging";s:1:"1";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"1";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"1";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"1";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"1";s:19:"answer_forum_topics";s:1:"1";s:18:"member_site_access";s:1:"1";}', '0.00', 0, '1'), (4, 'Platinum', 'The membership for the small budget.', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"1";s:10:"send_mails";s:1:"1";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"1";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"1";s:17:"instant_messaging";s:1:"1";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"1";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"1";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"1";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"1";s:19:"answer_forum_topics";s:1:"1";s:18:"member_site_access";s:1:"1";}', '9.99', 5, '1'), (5, 'Silver', 'The premium membership!', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"1";s:10:"send_mails";s:1:"1";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"1";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"1";s:17:"instant_messaging";s:1:"1";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"1";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"1";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"1";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"1";s:19:"answer_forum_topics";s:1:"1";s:18:"member_site_access";s:1:"1";}', '19.99', 10, '1'), (6, 'Gold', 'The must membership! The Gold!!!', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"1";s:10:"send_mails";s:1:"1";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"1";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"1";s:17:"instant_messaging";s:1:"1";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"1";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"1";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"1";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"1";s:19:"answer_forum_topics";s:1:"1";s:18:"member_site_access";s:1:"1";}', '29.99', 30, '1'), (9, 'Pending (not visible)', 'Pending subscription provisional migration to a different subscription.', 'a:21:{s:21:"quick_search_profiles";s:1:"1";s:24:"advanced_search_profiles";s:1:"1";s:10:"read_mails";s:1:"0";s:10:"send_mails";s:1:"0";s:13:"view_pictures";s:1:"1";s:15:"upload_pictures";s:1:"0";s:11:"view_videos";s:1:"1";s:13:"upload_videos";s:1:"0";s:17:"instant_messaging";s:1:"0";s:4:"chat";s:1:"1";s:10:"hot_or_not";s:1:"1";s:15:"love_calculator";s:1:"0";s:10:"read_notes";s:1:"1";s:11:"write_notes";s:1:"0";s:15:"read_blog_posts";s:1:"1";s:13:"view_comments";s:1:"1";s:14:"write_comments";s:1:"0";s:12:"forum_access";s:1:"1";s:19:"create_forum_topics";s:1:"0";s:19:"answer_forum_topics";s:1:"0";s:18:"member_site_access";s:1:"0";}', '0.00', 15, '0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_attempts_login` -- CREATE TABLE `[[dbprefix]]members_attempts_login` ( `attemptsId` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL DEFAULT '', `attempts` smallint(5) unsigned NOT NULL, `lastLogin` datetime NOT NULL, PRIMARY KEY (`attemptsId`), UNIQUE KEY `ip` (`ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_background` -- CREATE TABLE `[[dbprefix]]members_background` ( `profileId` int(10) unsigned NOT NULL, `file` varchar(5) NOT NULL, `file_cdn_url` varchar(40) NOT NULL, `approved` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_countries` -- CREATE TABLE `[[dbprefix]]members_countries` ( `countryId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `countryCode` char(2) NOT NULL, PRIMARY KEY (`countryId`), UNIQUE KEY `countryCode` (`countryCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=243 ; -- -- Dumping data for table `[[dbprefix]]members_countries` -- INSERT INTO `[[dbprefix]]members_countries` VALUES (1, 'AD'), (2, 'AE'), (3, 'AF'), (4, 'AG'), (5, 'AI'), (6, 'AL'), (7, 'AM'), (8, 'AN'), (9, 'AO'), (10, 'AQ'), (11, 'AR'), (12, 'AS'), (13, 'AT'), (14, 'AU'), (15, 'AW'), (16, 'AX'), (17, 'AZ'), (18, 'BA'), (19, 'BB'), (20, 'BD'), (21, 'BE'), (22, 'BF'), (23, 'BG'), (24, 'BH'), (25, 'BI'), (26, 'BJ'), (27, 'BM'), (28, 'BN'), (29, 'BO'), (30, 'BR'), (31, 'BS'), (32, 'BT'), (33, 'BV'), (34, 'BW'), (35, 'BY'), (36, 'BZ'), (37, 'CA'), (38, 'CC'), (39, 'CD'), (40, 'CF'), (41, 'CG'), (42, 'CH'), (43, 'CI'), (44, 'CK'), (45, 'CL'), (46, 'CM'), (47, 'CN'), (48, 'CO'), (49, 'CR'), (50, 'CU'), (51, 'CV'), (52, 'CX'), (53, 'CY'), (54, 'CZ'), (55, 'DE'), (56, 'DJ'), (57, 'DK'), (58, 'DM'), (59, 'DO'), (60, 'DZ'), (61, 'EC'), (62, 'EE'), (63, 'EG'), (64, 'EH'), (65, 'ER'), (66, 'ES'), (67, 'ET'), (68, 'FI'), (69, 'FJ'), (70, 'FK'), (71, 'FM'), (72, 'FO'), (73, 'FR'), (74, 'FX'), (75, 'GA'), (76, 'GD'), (77, 'GE'), (78, 'GF'), (79, 'GH'), (80, 'GI'), (81, 'GL'), (82, 'GM'), (83, 'GN'), (84, 'GP'), (85, 'GQ'), (86, 'GR'), (87, 'GS'), (88, 'GT'), (89, 'GU'), (90, 'GW'), (91, 'GY'), (92, 'HK'), (93, 'HM'), (94, 'HN'), (95, 'HR'), (96, 'HT'), (97, 'HU'), (98, 'ID'), (99, 'IE'), (100, 'IL'), (101, 'IN'), (102, 'IO'), (103, 'IQ'), (104, 'IR'), (105, 'IS'), (106, 'IT'), (107, 'JM'), (108, 'JO'), (109, 'JP'), (110, 'KE'), (111, 'KG'), (112, 'KH'), (113, 'KI'), (114, 'KM'), (115, 'KN'), (116, 'KP'), (117, 'KR'), (118, 'KW'), (119, 'KY'), (120, 'KZ'), (121, 'LA'), (122, 'LB'), (123, 'LC'), (124, 'LI'), (125, 'LK'), (126, 'LR'), (127, 'LS'), (128, 'LT'), (129, 'LU'), (130, 'LV'), (131, 'LY'), (132, 'MA'), (133, 'MC'), (134, 'MD'), (135, 'ME'), (136, 'MG'), (137, 'MH'), (138, 'MK'), (139, 'ML'), (140, 'MM'), (141, 'MN'), (142, 'MO'), (143, 'MP'), (144, 'MQ'), (145, 'MR'), (146, 'MS'), (147, 'MT'), (148, 'MU'), (149, 'MV'), (150, 'MW'), (151, 'MX'), (152, 'MY'), (153, 'MZ'), (154, 'NA'), (155, 'NC'), (156, 'NE'), (157, 'NF'), (158, 'NG'), (159, 'NI'), (160, 'NL'), (161, 'NO'), (162, 'NP'), (163, 'NR'), (164, 'NU'), (165, 'NZ'), (166, 'OM'), (167, 'PA'), (168, 'PE'), (169, 'PF'), (170, 'PG'), (171, 'PH'), (172, 'PK'), (173, 'PL'), (174, 'PM'), (175, 'PN'), (176, 'PR'), (177, 'PT'), (178, 'PW'), (179, 'PY'), (180, 'QA'), (181, 'RE'), (182, 'RO'), (183, 'RS'), (184, 'RU'), (185, 'RW'), (186, 'SA'), (187, 'SB'), (188, 'SC'), (189, 'SD'), (190, 'SE'), (191, 'SG'), (192, 'SH'), (193, 'SI'), (194, 'SJ'), (195, 'SK'), (196, 'SL'), (197, 'SM'), (198, 'SN'), (199, 'SO'), (200, 'SR'), (201, 'ST'), (202, 'SV'), (203, 'SY'), (204, 'SZ'), (205, 'TC'), (206, 'TD'), (207, 'TF'), (208, 'TG'), (209, 'TH'), (210, 'TJ'), (211, 'TK'), (212, 'TM'), (213, 'TN'), (214, 'TO'), (215, 'TP'), (216, 'TR'), (217, 'TT'), (218, 'TV'), (219, 'TW'), (220, 'TZ'), (221, 'UA'), (222, 'UG'), (223, 'UK'), (224, 'UM'), (225, 'US'), (226, 'UY'), (227, 'UZ'), (228, 'VA'), (229, 'VC'), (230, 'VE'), (231, 'VG'), (232, 'VI'), (233, 'VN'), (234, 'VU'), (235, 'WF'), (236, 'WS'), (237, 'XK'), (238, 'YE'), (239, 'YT'), (240, 'ZA'), (241, 'ZM'), (242, 'ZW'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_friends` -- CREATE TABLE `[[dbprefix]]members_friends` ( `profileId` int(10) unsigned NOT NULL, `friendId` int(10) unsigned NOT NULL, `requestDate` datetime DEFAULT NULL, `pending` tinyint(1) unsigned NOT NULL DEFAULT '0', KEY `profileId` (`profileId`), KEY `friendId` (`friendId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_info` -- CREATE TABLE `[[dbprefix]]members_info` ( `profileId` int(10) unsigned NOT NULL, `middleName` varchar(50) DEFAULT NULL, `description` text, `punchline` varchar(191) DEFAULT NULL, `address` varchar(191) DEFAULT NULL, `city` varchar(150) DEFAULT NULL, `state` varchar(150) DEFAULT NULL, `zipCode` varchar(20) DEFAULT NULL, `country` char(2) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `website` varchar(120) DEFAULT NULL, `socialNetworkSite` varchar(120) DEFAULT NULL, `height` tinyint(3) unsigned DEFAULT NULL, `weight` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`profileId`), KEY `country` (`country`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]members_info` -- INSERT INTO `[[dbprefix]]members_info` VALUES (1, NULL, 'This profile doesn''t exist anymore. So I''m the ghost who replaces him/her during this time', NULL, 'The Ghost City', 'Ghost Town', 'Ghost State', '000000', 'US', NULL, NULL, NULL, NULL, NULL), (2, NULL, 'Omnis facilis hic error in. Hic omnis eum nemo sint dolore dolorum.', '', NULL, 'Muellershire', '', '45866-8159', 'NU', NULL, NULL, NULL, NULL, NULL), (3, NULL, 'Enim ullam aut ut quod. Delectus qui voluptate quia eum ab asperiores et. Fuga id doloremque occaecati sit.', '', NULL, 'Lake Leif', '', '17312', 'MH', NULL, NULL, NULL, NULL, NULL), (4, NULL, 'Natus blanditiis eius molestiae fugit est error tempora placeat. Eos dolorum rerum rerum. Beatae ipsa quia aut quas.', '', NULL, 'North Gunner', '', '73925-7770', 'AZ', NULL, NULL, NULL, NULL, NULL), (5, NULL, 'Dolorem soluta sapiente dignissimos consequatur laudantium sit et. Qui laudantium incidunt molestias voluptas tempora vitae eum.', '', NULL, 'Sengerfurt', '', '19812', 'IS', NULL, NULL, NULL, NULL, NULL), (6, NULL, 'Sed consequatur id ab deserunt. Labore veritatis ipsa et molestiae voluptas ducimus exercitationem.', '', NULL, 'North Daphnemouth', '', '57241', 'TJ', NULL, NULL, NULL, NULL, NULL), (7, NULL, 'Molestias asperiores et corrupti eos eligendi enim molestiae rerum. Ut ut et dolores animi. Voluptatem possimus consequatur nesciunt non velit.', '', NULL, 'Jerrodhaven', '', '37430', 'SC', NULL, NULL, NULL, NULL, NULL), (8, NULL, 'Consequatur ex non nam. Blanditiis sunt rerum dolore in.', '', NULL, 'Lilianaton', '', '51298', 'NA', NULL, NULL, NULL, NULL, NULL), (9, NULL, 'Occaecati quia at aut dolorem quisquam soluta atque nobis. Optio ipsa iure at. Excepturi ab saepe itaque est magnam assumenda ut.', '', NULL, 'New Rosinaberg', '', '81688-9560', 'KW', NULL, NULL, NULL, NULL, NULL), (10, NULL, 'Qui nam unde quo molestias quis minus aliquam et. Dolore sed et dolorum sit.', '', NULL, 'Biankatown', '', '18603', 'CU', NULL, NULL, NULL, NULL, NULL), (11, NULL, 'Consequatur aliquam amet et. Ab qui et quidem quaerat sunt fugit. Qui commodi modi beatae placeat nisi modi sint cumque.', '', NULL, 'South Waynebury', '', '67760-0609', 'SL', NULL, NULL, NULL, NULL, NULL), (12, NULL, 'Ex quibusdam voluptatem dicta eum. Voluptatem praesentium consectetur atque nisi optio. Consequatur architecto ullam aut velit.', '', NULL, 'Lake Claudie', '', '30986-9264', 'FO', NULL, NULL, NULL, NULL, NULL), (13, NULL, 'Et qui omnis quis veniam. Cumque atque dolor qui corporis labore illo.', '', NULL, 'Jermainfurt', '', '11831', 'LR', NULL, NULL, NULL, NULL, NULL), (14, NULL, 'Qui eius nam nihil accusamus et fugit voluptatem. Dolore asperiores harum delectus repudiandae molestias. Non aut ut et vero.', '', NULL, 'East Thealand', '', '41242', 'CX', NULL, NULL, NULL, NULL, NULL), (15, NULL, 'Est accusantium doloribus ut distinctio voluptatum. Et qui veniam eligendi soluta reiciendis veniam.', '', NULL, 'North Kennedy', '', '47020-6023', 'GE', NULL, NULL, NULL, NULL, NULL), (16, NULL, 'Dolor deserunt quidem cumque ipsam temporibus. Facere incidunt iure cumque velit odit vel cupiditate. Quia qui dolore natus similique aut magni.', '', NULL, 'East Jacintofort', '', '36067-4936', 'BM', NULL, NULL, NULL, NULL, NULL), (17, NULL, 'Officia ut unde pariatur repudiandae aut magni doloremque. Ut expedita impedit dolor quas voluptatem voluptatum.', '', NULL, 'East Jeniferborough', '', '34891-8016', 'NP', NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_log_login` -- CREATE TABLE `[[dbprefix]]members_log_login` ( `logId` mediumint(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(120) NOT NULL DEFAULT '', `username` varchar(64) NOT NULL DEFAULT '', `password` varchar(40) DEFAULT NULL, `status` varchar(60) NOT NULL DEFAULT '', `ip` varchar(45) NOT NULL DEFAULT '', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`logId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_log_sess` -- CREATE TABLE `[[dbprefix]]members_log_sess` ( `sessionId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `username` varchar(40) DEFAULT NULL, `email` varchar(120) DEFAULT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`sessionId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_notifications` -- CREATE TABLE `[[dbprefix]]members_notifications` ( `profileId` int(10) unsigned NOT NULL, `enableNewsletters` tinyint(1) unsigned NOT NULL DEFAULT '1', `newMsg` tinyint(1) unsigned NOT NULL DEFAULT '1', `friendRequest` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]members_notifications` -- INSERT INTO `[[dbprefix]]members_notifications` VALUES (1, 0, 0, 0), (2, 1, 1, 1), (3, 1, 1, 1), (4, 1, 1, 1), (5, 1, 1, 1), (6, 1, 1, 1), (7, 1, 1, 1), (8, 1, 1, 1), (9, 1, 1, 1), (10, 1, 1, 1), (11, 1, 1, 1), (12, 1, 1, 1), (13, 1, 1, 1), (14, 1, 1, 1), (15, 1, 1, 1), (16, 1, 1, 1), (17, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_privacy` -- CREATE TABLE `[[dbprefix]]members_privacy` ( `profileId` int(10) unsigned NOT NULL, `privacyProfile` enum('all','only_members','only_me') NOT NULL DEFAULT 'all', `searchProfile` enum('yes','no') NOT NULL DEFAULT 'yes', `userSaveViews` enum('yes','no') NOT NULL DEFAULT 'yes', PRIMARY KEY (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]members_privacy` -- INSERT INTO `[[dbprefix]]members_privacy` VALUES (1, 'all', 'yes', 'yes'), (2, 'all', 'yes', 'yes'), (3, 'all', 'yes', 'yes'), (4, 'all', 'yes', 'yes'), (5, 'all', 'yes', 'yes'), (6, 'all', 'yes', 'yes'), (7, 'all', 'yes', 'yes'), (8, 'all', 'yes', 'yes'), (9, 'all', 'yes', 'yes'), (10, 'all', 'yes', 'yes'), (11, 'all', 'yes', 'yes'), (12, 'all', 'yes', 'yes'), (13, 'all', 'yes', 'yes'), (14, 'all', 'yes', 'yes'), (15, 'all', 'yes', 'yes'), (16, 'all', 'yes', 'yes'), (17, 'all', 'yes', 'yes'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_wall` -- CREATE TABLE `[[dbprefix]]members_wall` ( `wallId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL DEFAULT '0', `post` text CHARACTER SET armscii8, `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`wallId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]members_who_views` -- CREATE TABLE `[[dbprefix]]members_who_views` ( `profileId` int(10) unsigned NOT NULL, `visitorId` int(10) unsigned NOT NULL, `lastVisit` datetime DEFAULT NULL, KEY `profileId` (`profileId`), KEY `visitorId` (`visitorId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]messages` -- CREATE TABLE `[[dbprefix]]messages` ( `messageId` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender` int(10) unsigned NOT NULL DEFAULT '0', `recipient` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(30) NOT NULL DEFAULT '', `message` text NOT NULL, `sendDate` datetime DEFAULT NULL, `status` tinyint(1) unsigned NOT NULL DEFAULT '1', `trash` set('sender','recipient') NOT NULL DEFAULT '', `toDelete` set('sender','recipient') NOT NULL DEFAULT '', PRIMARY KEY (`messageId`), KEY `recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]messenger` -- CREATE TABLE `[[dbprefix]]messenger` ( `messengerId` int(10) unsigned NOT NULL AUTO_INCREMENT, `fromUser` varchar(40) NOT NULL DEFAULT '', `toUser` varchar(40) NOT NULL DEFAULT '', `message` text NOT NULL, `sent` datetime DEFAULT NULL, `recd` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`messengerId`), KEY `fromUser` (`fromUser`), KEY `toUser` (`toUser`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]meta_main` -- CREATE TABLE `[[dbprefix]]meta_main` ( `langId` varchar(5) NOT NULL DEFAULT '', `pageTitle` varchar(100) NOT NULL, `metaDescription` varchar(191) NOT NULL, `metaKeywords` varchar(191) NOT NULL, `headline` varchar(50) NOT NULL, `slogan` varchar(191) NOT NULL, `promoText` text, `metaRobots` varchar(50) NOT NULL DEFAULT '', `metaAuthor` varchar(50) NOT NULL DEFAULT '', `metaCopyright` varchar(55) NOT NULL DEFAULT '', `metaRating` varchar(50) NOT NULL DEFAULT '', `metaDistribution` varchar(50) NOT NULL DEFAULT '', `metaCategory` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`langId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]meta_main` -- INSERT INTO `[[dbprefix]]meta_main` VALUES ('en_US', 'Home', 'The Best Online Social Dating Service to meet people and keep in touch with your friends', 'meet people, community, single, friends, meet singles, women, men, dating site, dating service, dating website, online dating website', 'Be on the right place!', 'The place to meet lovely people!', 'You''re on the best place for meeting new people nearby! Chat, Flirt, Socialize and have Fun!<br />Create any Social Dating Web Apps or Websites like this one with the #1 <a href="https://ph7builder.com">Dating Web App Builder</a>. It''s Professional, Modern, Open Source, and gives you the Best Way to launch a new Social/Dating Business!', 'index, follow, all', 'Pierre-Henry Soria (pH7Builder.com)', 'Copyright Pierre-Henry Soria. All Rights Reserved.', 'general', 'global', 'dating'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]modules` -- CREATE TABLE `[[dbprefix]]modules` ( `moduleId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `vendorName` varchar(40) NOT NULL, `moduleName` varchar(40) NOT NULL, `version` varchar(6) NOT NULL, `uri` varchar(40) DEFAULT NULL, `path` varchar(191) DEFAULT NULL, `active` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`moduleId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]modules` -- INSERT INTO `[[dbprefix]]modules` VALUES (1, 'pH7Builder', 'SQL System Schema', '1.6.4', NULL, NULL, '0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]notes` -- CREATE TABLE `[[dbprefix]]notes` ( `noteId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `postId` varchar(60) NOT NULL, `langId` char(2) NOT NULL DEFAULT '', `title` varchar(100) DEFAULT NULL, `content` longtext NOT NULL, `pageTitle` varchar(100) NOT NULL, `metaDescription` varchar(191) NOT NULL, `metaKeywords` varchar(191) NOT NULL, `slogan` varchar(191) NOT NULL, `metaRobots` varchar(50) NOT NULL, `metaAuthor` varchar(50) NOT NULL, `metaCopyright` varchar(50) NOT NULL, `tags` varchar(191) DEFAULT NULL, `thumb` char(24) DEFAULT NULL, `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `enableComment` enum('1','0') DEFAULT '1', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `approved` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`noteId`), UNIQUE KEY `postId` (`postId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]notes_categories` -- CREATE TABLE `[[dbprefix]]notes_categories` ( `categoryId` smallint(4) unsigned NOT NULL, `noteId` int(10) unsigned NOT NULL, `profileId` int(10) unsigned NOT NULL, KEY `categoryId` (`categoryId`), KEY `noteId` (`noteId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]notes_data_categories` -- CREATE TABLE `[[dbprefix]]notes_data_categories` ( `categoryId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) DEFAULT NULL, PRIMARY KEY (`categoryId`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=21 ; -- -- Dumping data for table `[[dbprefix]]notes_data_categories` -- INSERT INTO `[[dbprefix]]notes_data_categories` VALUES (1, 'Business'), (2, 'Companies'), (3, 'Dating'), (4, 'Education'), (5, 'Family'), (6, 'Food'), (7, 'Game'), (8, 'Health'), (9, 'Hobby'), (10, 'Movie'), (11, 'Music'), (12, 'News'), (13, 'Pets'), (14, 'Recreation'), (15, 'Shopping'), (16, 'Society'), (17, 'Sports'), (18, 'Study'), (19, 'Technology'), (20, 'Travel'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]pictures` -- CREATE TABLE `[[dbprefix]]pictures` ( `pictureId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `albumId` int(10) unsigned NOT NULL, `title` varchar(80) NOT NULL, `description` varchar(191) DEFAULT NULL, `file` varchar(40) NOT NULL, `file_cdn_url` varchar(40) NOT NULL, `approved` enum('1','0') DEFAULT '1', `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`pictureId`), KEY `albumId` (`albumId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]report` -- CREATE TABLE `[[dbprefix]]report` ( `reportId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `reporterId` int(10) unsigned DEFAULT NULL, `spammerId` int(10) unsigned DEFAULT NULL, `dateTime` datetime DEFAULT NULL, `contentType` enum('user','avatar','mail','comment','picture','video','forum','note') NOT NULL DEFAULT 'user', `description` varchar(191) DEFAULT NULL, `url` varchar(191) DEFAULT NULL, PRIMARY KEY (`reportId`), KEY `reporterId` (`reporterId`), KEY `spammerId` (`spammerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]settings` -- CREATE TABLE `[[dbprefix]]settings` ( `settingName` varchar(64) NOT NULL, `settingValue` varchar(150) DEFAULT '', `description` varchar(120) DEFAULT '' COMMENT 'Informative desc about the setting', `settingGroup` varchar(12) NOT NULL, PRIMARY KEY (`settingName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `[[dbprefix]]settings` -- INSERT INTO `[[dbprefix]]settings` VALUES ('adminEmail', '[[admin_email]]', '', 'email'), ('affActivationType', '1', '1 = no activation, 2 = email activation, 3 = Manual activation by the administrator', 'registration'), ('autoplayVideo', '1', '1 = Autoplay is enabled, 0 = Autoplay is disabled', 'video'), ('avatarManualApproval', '0', '0 to disable or 1 to enable ', 'moderation'), ('backgroundColor', '', 'Override background color. Leave empty to disable', 'design'), ('banWordReplace', '[removed]', '', 'security'), ('bgProfileManualApproval', '0', 'Background Profile Manual Approval. 0 to disable or 1 to enable ', 'moderation'), ('bgSplashVideo', '1', '0 to disable or 1 to enable the background splash video', 'homepage'), ('captchaCaseSensitive', '1', '1 to enable captcha case sensitive | 0 to enable', 'spam'), ('captchaComplexity', '5', 'number of captcha complexity', 'spam'), ('chatApi', 'https://ph7builder.com/addons/chat/?name=%site_name%&url=%site_url%&skin=4', 'Chat Api URL', 'api'), ('cleanComment', '0', 'Delete comments older than X days. 0 = Disable', 'pruning'), ('cleanMessenger', '0', 'Delete IM messages older than X days. 0 = Disable', 'pruning'), ('cleanMsg', '0', 'Delete messages older than X days. 0 = Disable', 'pruning'), ('cookieConsentBar', '0', 'Enable the cookie consent bar to prevent your users that your site uses cookies. 0 = Disable | 1 = Enable', 'general'), ('cronSecurityHash', '[[cronsecurityhash]]', 'The secret word for the URL of the cron', 'automation'), ('DDoS', '0', '0 to disabled or 1 to enabled DDoS attack protection', 'security'), ('defaultLanguage', 'en_US', '', 'language'), ('defaultMembershipGroupId', '2', 'Default Membership Group', 'registration'), ('defaultSysModule', 'user', 'The default module running by default on the index page. Recommended to keep the "user" module', 'general'), ('defaultTemplate', 'base', '', 'design'), ('defaultVideo', 'https://www.youtube.com/watch?v=q-1eHnBOg4A', 'Video by default if no video is found', 'video'), ('disclaimer', '0', 'Enable a disclaimer to enter to the site. This is useful for sites with adult content. 0 = Disable | 1 = Enable', 'general'), ('displayPoweredByLink', '1', 'Show or not the branding link in the footer.', 'general'), ('emailName', '[[site_name]]', '', 'email'), ('feedbackEmail', '[[feedback_email]]', '', 'email'), ('footerLinkColor', '', 'Override footer links color. Leave empty to disable', 'design'), ('googleApiKey', '', 'Google Maps API key https://developers.google.com/maps/documentation/javascript/get-api-key', 'api'), ('heading1Color', '', 'Override H1 color. Leave empty to disable', 'design'), ('heading2Color', '', 'Override H2 color. Leave empty to disable', 'design'), ('heading3Color', '', 'Override H3 color. Leave empty to disable', 'design'), ('ipApi', 'https://whatismyipaddress.com/ip/', 'IP Api URL', 'api'), ('ipLogin', '', '', 'security'), ('isAdminLoginAttempt', '1', 'Enable blocking connection attempts abusive. Enable = 1 or disable = 0', 'security'), ('isAdminSessionIpCheck', '1', 'Enable it to Protect against session hijacking. Disable it if use dynamic IPs', 'security'), ('isAffiliateLoginAttempt', '1', 'Enable blocking connection attempts abusive. Enable = 1 or disable = 0', 'security'), ('isAffiliateSessionIpCheck', '1', 'Enable it to Protect against session hijacking. Disable it if use dynamic IPs', 'security'), ('isCaptchaAffiliateSignup', '0', '0 to disable or 1 to enable', 'spam'), ('isCaptchaComment', '0', '0 to disable or 1 to enable', 'spam'), ('isCaptchaForum', '0', '0 to disable or 1 to enable', 'spam'), ('isCaptchaMail', '0', '0 to disable or 1 to enable', 'spam'), ('isCaptchaNote', '0', '0 to disable or 1 to enable', 'spam'), ('isCaptchaUserSignup', '0', '0 to disable or 1 to enable', 'spam'), ('isSiteValidated', '0', '0 = site not validated | 1 = site validated', 'security'), ('isSoftwareNewsFeed', '1', 'Enable the news feed. 0 = Disable | 1 = Enable', 'general'), ('isUserAgeRangeField', '1', '0 to disable or 1 to enable', 'registration'), ('isUserLoginAttempt', '1', 'Enable blocking connection attempts abusive. Enable = 1 or disable = 0', 'security'), ('isUserSessionIpCheck', '0', 'Enable it to Protect against session hijacking. Disable it if use dynamic IPs', 'security'), ('linkColor', '', 'Override links color. Leave empty to disable', 'design'), ('linkHoverColor', '', 'Override links hover color. Leave empty to disable', 'design'), ('loginAdminAttemptTime', '120', 'Time before a new connection attempt, in minutes!', 'security'), ('loginAffiliateAttemptTime', '60', 'Time before a new connection attempt, in minutes!', 'security'), ('loginUserAttemptTime', '60', 'Time before a new connection attempt, in minutes!', 'security'), ('mailType', 'mail', '', 'email'), ('mapType', 'roadmap', 'Choose between: ''roadmap'', ''hybrid'', ''terrain'', ''satellite''', 'map'), ('maxAdminLoginAttempts', '10', 'Maximum login attempts before blocking', 'security'), ('maxAffiliateLoginAttempts', '15', 'Maximum login attempts before blocking', 'security'), ('maxAgeRegistration', '99', '', 'registration'), ('maxPasswordLength', '60', '', 'security'), ('maxUserLoginAttempts', '20', 'Maximum login attempts before blocking', 'security'), ('maxUsernameLength', '30', '', 'registration'), ('minAgeRegistration', '18', '', 'registration'), ('minPasswordLength', '6', '', 'security'), ('minUsernameLength', '3', '', 'registration'), ('navbarType', 'default', 'Choose between "default" or "dark"', 'design'), ('noteManualApproval', '0', '0 to disable or 1 to enable ', 'moderation'), ('nudityFilter', '0', '1 = enable | 0 = disable', 'moderation'), ('numberProfileSplashPage', '44', 'Number of profiles to display on the splash homepage', 'homepage'), ('pictureManualApproval', '0', '0 to disable or 1 to enable ', 'moderation'), ('profileWithAvatarSet', '0', '1 to display only the profiles with a profile photo.', 'homepage'), ('requireRegistrationAvatar', '0', '', 'registration'), ('returnEmail', '[[noreply_email]]', 'Usually noreply@yoursite.com', 'email'), ('securityToken', '0', '0 to disable or 1 to enable the CSRF security token in the forms', 'security'), ('securityTokenLifetime', '720', 'Time in seconds to the CSRF security token. Default 720 seconds (12 mins)', 'security'), ('sendReportMail', '1', 'Send the Report by eMail (1 = enable, 0 = disable)', 'security'), ('siteName', '[[site_name]]', '', 'general'), ('siteStatus', 'enable', 'enable or maintenance', 'general'), ('sizeWatermarkTextImage', '2', 'Between 0 to 5', 'image'), ('smtpHostName', 'mail.example.com', '', 'email'), ('smtpPassword', '123456', '', 'email'), ('smtpPort', '25', '', 'email'), ('socialMediaWidgets', '0', 'Enable the Social Media Widgets such as Like and Sharing buttons. 0 = Disable | 1 = Enable', 'general'), ('splashPage', '1', 'Use Splash Page | enable = 1 or disable = 0', 'homepage'), ('textColor', '', 'Override text color. Leave empty to disable', 'design'), ('timeDelayAffRegistration', '2880', '2880 minutes = 2 days (in minutes!)', 'spam'), ('timeDelaySendComment', '5', 'Waiting time to send a new comment, in minutes!', 'spam'), ('timeDelaySendForumMsg', '10', 'Waiting time to send a reply message in the same topic, in minutes!', 'spam'), ('timeDelaySendForumTopic', '5', 'Waiting time to send a new topic in the forum, in minutes!', 'spam'), ('timeDelaySendMail', '3', 'Waiting time to send a new message, in minutes!', 'spam'), ('timeDelaySendNote', '20', 'Waiting time to add a new note post, in minutes!', 'spam'), ('timeDelayUserRegistration', '1440', '1440 minutes = 24 hours (in minutes!)', 'spam'), ('userActivationType', '1', '1 = no activation, 2 = email activation, 3 = manual activation by admin, 4 = SMS activation', 'registration'), ('usersBlock', '1', '0 to disable | 1 to enable the profile photos on the homepage', 'homepage'), ('userTimeout', '1', 'User inactivity timeout. The number of minutes that a member becomes inactive (offline)', 'automation'), ('videoManualApproval', '0', '0 to disable or 1 to enable ', 'moderation'), ('watermarkTextImage', '[[site_name]]', 'Watermark text', 'image'), ('wysiwygEditorForum', '0', 'Enable or not the WYSIWYG. 0 = Disable | 1 = Enable', 'general'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]static_files` -- CREATE TABLE `[[dbprefix]]static_files` ( `staticId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `file` varchar(191) NOT NULL, `fileType` enum('css','js') NOT NULL, `active` enum('1','0') DEFAULT '1', PRIMARY KEY (`staticId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]static_files` -- INSERT INTO `[[dbprefix]]static_files` VALUES (1, '//static.addtoany.com/menu/page.js', 'js', '0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]subscribers` -- CREATE TABLE `[[dbprefix]]subscribers` ( `profileId` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `email` varchar(120) NOT NULL, `joinDate` datetime DEFAULT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '2', `ip` varchar(45) NOT NULL DEFAULT '127.0.0.1', `hashValidation` varchar(40) DEFAULT NULL, `affiliatedId` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`profileId`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]subscribers` -- INSERT INTO `[[dbprefix]]subscribers` VALUES (1, 'Dr. Francisco Abshire V', 'koss.vito@little.com', '2008-08-15 04:10:15', 1, '140.87.166.9', 'ac36ff589883e9d4445b075beded10a23ba7adf1', 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sys_mods_enabled` -- CREATE TABLE `[[dbprefix]]sys_mods_enabled` ( `moduleId` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `moduleTitle` varchar(50) NOT NULL, `folderName` varchar(20) NOT NULL, `premiumMod` enum('0','1') NOT NULL DEFAULT '0', `enabled` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`moduleId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=22 ; -- -- Dumping data for table `[[dbprefix]]sys_mods_enabled` -- INSERT INTO `[[dbprefix]]sys_mods_enabled` VALUES (1, 'Affiliate', 'affiliate', '0', '1'), (2, 'Chat', 'chat', '1', '1'), (3, 'Photo', 'picture', '0', '1'), (4, 'Video', 'video', '0', '1'), (5, 'Hot or Not', 'hotornot', '0', '1'), (6, 'Discussions Board', 'forum', '0', '1'), (7, 'Note (community blog)', 'note', '0', '1'), (8, 'Blog (company blog)', 'blog', '0', '1'), (9, 'Love Calculator', 'love-calculator', '0', '1'), (10, 'Mail (private message)', 'mail', '0', '1'), (11, 'Instant Messaging (IM)', 'im', '0', '1'), (12, 'Friends', 'friend', '0', '1'), (13, 'Related Profiles', 'related-profile', '0', '1'), (14, 'User Dashboard', 'user-dashboard', '0', '1'), (15, 'Dating-Style Profile Page', 'cool-profile-page', '0', '1'), (16, 'Birthday: Let''s Celebrate Birthdays', 'birthday', '0', '1'), (17, 'Google Maps', 'map', '0', '1'), (18, 'Newsletter', 'newsletter', '0', '1'), (19, 'Invite Friends', 'invite', '0', '1'), (20, 'SMS Verification', 'sms-verification', '0', '0'), (21, 'Progressive Web App (HTTPS required)', 'pwa', '0', '0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]top_menus` -- CREATE TABLE `[[dbprefix]]top_menus` ( `menuId` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `vendorName` varchar(40) NOT NULL, `moduleName` varchar(40) NOT NULL, `controllerName` varchar(40) NOT NULL, `actionName` varchar(40) NOT NULL, `vars` varchar(60) DEFAULT NULL, `parentMenu` smallint(4) unsigned DEFAULT NULL, `grandParentMenu` smallint(4) unsigned DEFAULT NULL, `onlyForUsers` enum('0','1') NOT NULL DEFAULT '0', `active` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`menuId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]videos` -- CREATE TABLE `[[dbprefix]]videos` ( `videoId` int(10) unsigned NOT NULL AUTO_INCREMENT, `profileId` int(10) unsigned NOT NULL, `albumId` int(10) unsigned NOT NULL, `title` varchar(80) DEFAULT NULL, `description` varchar(191) DEFAULT NULL, `file` varchar(191) DEFAULT NULL, `thumb` varchar(191) DEFAULT NULL, `approved` enum('1','0') NOT NULL DEFAULT '1', `votes` int(9) unsigned DEFAULT '0', `score` float unsigned DEFAULT '0', `views` int(10) unsigned DEFAULT '0', `createdDate` datetime DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, `duration` int(9) NOT NULL, PRIMARY KEY (`videoId`), KEY `albumId` (`albumId`), KEY `profileId` (`profileId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `[[dbprefix]]admins_log_sess` -- ALTER TABLE `[[dbprefix]]admins_log_sess` ADD CONSTRAINT `[[dbprefix]]admins_log_sess_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]admins` (`profileId`); -- -- Constraints for table `[[dbprefix]]affiliates_info` -- ALTER TABLE `[[dbprefix]]affiliates_info` ADD CONSTRAINT `[[dbprefix]]affiliates_info_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]affiliates` (`profileId`); -- -- Constraints for table `[[dbprefix]]affiliates_log_sess` -- ALTER TABLE `[[dbprefix]]affiliates_log_sess` ADD CONSTRAINT `[[dbprefix]]affiliates_log_sess_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]affiliates` (`profileId`); -- -- Constraints for table `[[dbprefix]]albums_pictures` -- ALTER TABLE `[[dbprefix]]albums_pictures` ADD CONSTRAINT `[[dbprefix]]albums_pictures_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]albums_videos` -- ALTER TABLE `[[dbprefix]]albums_videos` ADD CONSTRAINT `[[dbprefix]]albums_videos_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]blogs_categories` -- ALTER TABLE `[[dbprefix]]blogs_categories` ADD CONSTRAINT `[[dbprefix]]blogs_categories_ibfk_1` FOREIGN KEY (`blogId`) REFERENCES `[[dbprefix]]blogs` (`blogId`); -- -- Constraints for table `[[dbprefix]]comments_blog` -- ALTER TABLE `[[dbprefix]]comments_blog` ADD CONSTRAINT `[[dbprefix]]comments_blog_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]blogs` (`blogId`); -- -- Constraints for table `[[dbprefix]]comments_note` -- ALTER TABLE `[[dbprefix]]comments_note` ADD CONSTRAINT `[[dbprefix]]comments_note_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]notes` (`noteId`); -- -- Constraints for table `[[dbprefix]]comments_picture` -- ALTER TABLE `[[dbprefix]]comments_picture` ADD CONSTRAINT `[[dbprefix]]comments_picture_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]pictures` (`pictureId`); -- -- Constraints for table `[[dbprefix]]comments_profile` -- ALTER TABLE `[[dbprefix]]comments_profile` ADD CONSTRAINT `[[dbprefix]]comments_profile_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]comments_video` -- ALTER TABLE `[[dbprefix]]comments_video` ADD CONSTRAINT `[[dbprefix]]comments_video_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]videos` (`videoId`); -- -- Constraints for table `[[dbprefix]]forums` -- ALTER TABLE `[[dbprefix]]forums` ADD CONSTRAINT `[[dbprefix]]forums_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `[[dbprefix]]forums_categories` (`categoryId`); -- -- Constraints for table `[[dbprefix]]forums_messages` -- ALTER TABLE `[[dbprefix]]forums_messages` ADD CONSTRAINT `[[dbprefix]]forums_messages_ibfk_1` FOREIGN KEY (`topicId`) REFERENCES `[[dbprefix]]forums_topics` (`topicId`); -- -- Constraints for table `[[dbprefix]]forums_topics` -- ALTER TABLE `[[dbprefix]]forums_topics` ADD CONSTRAINT `[[dbprefix]]forums_topics_ibfk_1` FOREIGN KEY (`forumId`) REFERENCES `[[dbprefix]]forums` (`forumId`); -- -- Constraints for table `[[dbprefix]]members` -- ALTER TABLE `[[dbprefix]]members` ADD CONSTRAINT `[[dbprefix]]members_ibfk_1` FOREIGN KEY (`groupId`) REFERENCES `[[dbprefix]]memberships` (`groupId`); -- -- Constraints for table `[[dbprefix]]members_background` -- ALTER TABLE `[[dbprefix]]members_background` ADD CONSTRAINT `[[dbprefix]]members_background_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_friends` -- ALTER TABLE `[[dbprefix]]members_friends` ADD CONSTRAINT `[[dbprefix]]members_friends_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`), ADD CONSTRAINT `[[dbprefix]]members_friends_ibfk_2` FOREIGN KEY (`friendId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_info` -- ALTER TABLE `[[dbprefix]]members_info` ADD CONSTRAINT `[[dbprefix]]members_info_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_log_sess` -- ALTER TABLE `[[dbprefix]]members_log_sess` ADD CONSTRAINT `[[dbprefix]]members_log_sess_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_notifications` -- ALTER TABLE `[[dbprefix]]members_notifications` ADD CONSTRAINT `[[dbprefix]]members_notifications_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_privacy` -- ALTER TABLE `[[dbprefix]]members_privacy` ADD CONSTRAINT `[[dbprefix]]members_privacy_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_wall` -- ALTER TABLE `[[dbprefix]]members_wall` ADD CONSTRAINT `[[dbprefix]]members_wall_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]members_who_views` -- ALTER TABLE `[[dbprefix]]members_who_views` ADD CONSTRAINT `[[dbprefix]]members_who_views_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`), ADD CONSTRAINT `[[dbprefix]]members_who_views_ibfk_2` FOREIGN KEY (`visitorId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]messages` -- ALTER TABLE `[[dbprefix]]messages` ADD CONSTRAINT `[[dbprefix]]messages_ibfk_1` FOREIGN KEY (`recipient`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]messenger` -- ALTER TABLE `[[dbprefix]]messenger` ADD CONSTRAINT `[[dbprefix]]messenger_ibfk_1` FOREIGN KEY (`fromUser`) REFERENCES `[[dbprefix]]members` (`username`), ADD CONSTRAINT `[[dbprefix]]messenger_ibfk_2` FOREIGN KEY (`toUser`) REFERENCES `[[dbprefix]]members` (`username`); -- -- Constraints for table `[[dbprefix]]notes` -- ALTER TABLE `[[dbprefix]]notes` ADD CONSTRAINT `[[dbprefix]]notes_ibfk_1` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]notes_categories` -- ALTER TABLE `[[dbprefix]]notes_categories` ADD CONSTRAINT `[[dbprefix]]notes_categories_ibfk_1` FOREIGN KEY (`noteId`) REFERENCES `[[dbprefix]]notes` (`noteId`), ADD CONSTRAINT `[[dbprefix]]notes_categories_ibfk_2` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]pictures` -- ALTER TABLE `[[dbprefix]]pictures` ADD CONSTRAINT `[[dbprefix]]pictures_ibfk_1` FOREIGN KEY (`albumId`) REFERENCES `[[dbprefix]]albums_pictures` (`albumId`), ADD CONSTRAINT `[[dbprefix]]pictures_ibfk_2` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]report` -- ALTER TABLE `[[dbprefix]]report` ADD CONSTRAINT `[[dbprefix]]report_ibfk_1` FOREIGN KEY (`reporterId`) REFERENCES `[[dbprefix]]members` (`profileId`), ADD CONSTRAINT `[[dbprefix]]report_ibfk_2` FOREIGN KEY (`spammerId`) REFERENCES `[[dbprefix]]members` (`profileId`); -- -- Constraints for table `[[dbprefix]]videos` -- ALTER TABLE `[[dbprefix]]videos` ADD CONSTRAINT `[[dbprefix]]videos_ibfk_1` FOREIGN KEY (`albumId`) REFERENCES `[[dbprefix]]albums_videos` (`albumId`), ADD CONSTRAINT `[[dbprefix]]videos_ibfk_2` FOREIGN KEY (`profileId`) REFERENCES `[[dbprefix]]members` (`profileId`); /*!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 */;
💾 Save Changes
❌ Cancel