��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/tie.cx/install/dump.sql

��ѧ٧ѧ�
CREATE TABLE `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `billing` text COLLATE utf8mb4_unicode_ci, `api_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `twofa_secret` varchar(16) DEFAULT NULL, `one_time_login_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pending_email` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_activation_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `lost_password_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `facebook_id` bigint(20) DEFAULT NULL, `type` int(11) NOT NULL DEFAULT '0', `active` int(11) NOT NULL DEFAULT '0', `plan_id` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `plan_expiration_date` datetime DEFAULT NULL, `plan_settings` text COLLATE utf8_unicode_ci, `plan_trial_done` tinyint(4) DEFAULT '0', `payment_subscription_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `language` varchar(32) COLLATE utf8_unicode_ci DEFAULT 'english', `timezone` varchar(32) DEFAULT 'UTC', `date` datetime DEFAULT NULL, `ip` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `country` varchar(32) DEFAULT NULL, `last_activity` datetime DEFAULT NULL, `last_user_agent` text COLLATE utf8_unicode_ci, `total_logins` int(11) DEFAULT '0', PRIMARY KEY (`user_id`), KEY `plan_id` (`plan_id`), KEY `api_key` (`api_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- INSERT INTO `users` (`user_id`, `email`, `password`, `api_key`, `name`, `token_code`, `email_activation_code`, `lost_password_code`, `facebook_id`, `type`, `active`, `plan_id`, `plan_expiration_date`, `plan_settings`, `plan_trial_done`, `payment_subscription_id`, `date`, `ip`, `last_activity`, `last_user_agent`, `total_logins`) VALUES (1,'admin','$2y$10$uFNO0pQKEHSFcus1zSFlveiPCB3EvG9ZlES7XKgJFTAl5JbRGFCWy', md5(rand()), 'AltumCode','','','',NULL,1,1,'free','2020-07-15 11:26:19', '{"additional_global_domains":true,"custom_url":true,"deep_links":true,"no_ads":true,"removable_branding":true,"custom_branding":true,"custom_colored_links":true,"statistics":true,"google_analytics":true,"facebook_pixel":true,"custom_backgrounds":true,"verified":true,"scheduling":true,"seo":true,"utm":true,"socials":true,"fonts":true,"password":true,"sensitive_content":true,"leap_link":true,"projects_limit":-1,"biolinks_limit":-1,"links_limit":-1,"domains_limit":-1,"enabled_biolink_blocks":{"applemusic":true,"tidal":true,"anchor":true,"twitter_tweet":true,"instagram_media":true,"rss_feed":true,"custom_html":true,"vcard":true,"image_grid":true,"divider":true,"link":true,"text":true,"image":true,"mail":true,"soundcloud":true,"spotify":true,"youtube":true,"twitch":true,"vimeo":true,"tiktok":true}}', 1,'',NOW(),'',NOW(),'',0); -- SEPARATOR -- CREATE TABLE `projects` ( `project_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `color` varchar(16) DEFAULT '#000', `last_datetime` datetime DEFAULT NULL, `datetime` datetime NOT NULL, PRIMARY KEY (`project_id`), KEY `user_id` (`user_id`), CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `links` ( `link_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `user_id` int(11) NOT NULL, `biolink_id` int(11) DEFAULT NULL, `domain_id` int(11) DEFAULT '0', `pixels_ids` text, `type` varchar(32) NOT NULL DEFAULT '', `subtype` varchar(32) DEFAULT NULL, `url` varchar(256) NOT NULL DEFAULT '', `location_url` varchar(512) DEFAULT NULL, `clicks` int(11) NOT NULL DEFAULT '0', `settings` text, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `is_enabled` tinyint(4) NOT NULL DEFAULT '1', `datetime` datetime NOT NULL, PRIMARY KEY (`link_id`), KEY `project_id` (`project_id`), KEY `user_id` (`user_id`), KEY `url` (`url`), KEY `links_subtype_index` (`subtype`), KEY `links_type_index` (`type`), KEY `links_links_link_id_fk` (`biolink_id`), CONSTRAINT `links_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `links_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `links_links_link_id_fk` FOREIGN KEY (`biolink_id`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `biolinks_blocks` ( `biolink_block_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `link_id` int(11) DEFAULT NULL, `type` varchar(32) NOT NULL DEFAULT '', `location_url` varchar(512) DEFAULT NULL, `clicks` int(11) NOT NULL DEFAULT '0', `settings` text, `order` int(11) NOT NULL DEFAULT '0', `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `is_enabled` tinyint(4) NOT NULL DEFAULT '1', `datetime` datetime NOT NULL, PRIMARY KEY (`biolink_block_id`), KEY `user_id` (`user_id`), KEY `links_type_index` (`type`), KEY `links_links_link_id_fk` (`link_id`), CONSTRAINT `biolinks_blocks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `biolinks_blocks_ibfk_2` FOREIGN KEY (`link_id`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `pixels` ( `pixel_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `type` varchar(64) NOT NULL, `name` varchar(64) NOT NULL, `pixel` varchar(64) NOT NULL, `last_datetime` datetime DEFAULT NULL, `datetime` datetime NOT NULL, PRIMARY KEY (`pixel_id`), KEY `user_id` (`user_id`), CONSTRAINT `pixels_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `plans` ( `plan_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL DEFAULT '', `monthly_price` float NULL, `annual_price` float NULL, `lifetime_price` float NULL, `settings` text NOT NULL, `taxes_ids` text, `status` tinyint(4) NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`plan_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `pages_categories` ( `pages_category_id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT '', `icon` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`pages_category_id`), KEY `url` (`url`) ) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- SEPARATOR -- CREATE TABLE `pages` ( `page_id` int(11) NOT NULL AUTO_INCREMENT, `pages_category_id` int(11) DEFAULT NULL, `url` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci, `type` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT '', `position` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `order` int(11) DEFAULT '0', `total_views` int(11) DEFAULT '0', `date` datetime DEFAULT NULL, `last_date` datetime DEFAULT NULL, PRIMARY KEY (`page_id`), KEY `pages_pages_category_id_index` (`pages_category_id`), KEY `pages_url_index` (`url`), CONSTRAINT `pages_pages_categories_pages_category_id_fk` FOREIGN KEY (`pages_category_id`) REFERENCES `pages_categories` (`pages_category_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- SEPARATOR -- CREATE TABLE `track_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `link_id` int(11) DEFAULT NULL, `biolink_block_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `country_code` varchar(8) DEFAULT NULL, `city_name` varchar(128) DEFAULT NULL, `os_name` varchar(16) DEFAULT NULL, `browser_name` varchar(32) DEFAULT NULL, `referrer_host` varchar(256) DEFAULT NULL, `referrer_path` varchar(1024) DEFAULT NULL, `device_type` varchar(16) DEFAULT NULL, `browser_language` varchar(16) DEFAULT NULL, `utm_source` varchar(128) DEFAULT NULL, `utm_medium` varchar(128) DEFAULT NULL, `utm_campaign` varchar(128) DEFAULT NULL, `is_unique` tinyint(4) DEFAULT '0', `datetime` datetime NOT NULL, PRIMARY KEY (`id`), KEY `link_id` (`link_id`), KEY `track_links_date_index` (`datetime`), KEY `track_links_project_id_index` (`project_id`), KEY `track_links_users_user_id_fk` (`user_id`), KEY `track_links_biolink_block_id_index` (`biolink_block_id`), CONSTRAINT `track_links_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `track_links_links_project_id_fk` FOREIGN KEY (`project_id`) REFERENCES `links` (`project_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `track_links_projects_project_id_fk` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `track_links_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(64) NOT NULL DEFAULT '', `value` longtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- SET @cron_key = MD5(RAND()); -- SEPARATOR -- SET @cron_reset_date = NOW(); -- SEPARATOR -- INSERT INTO `settings` (`key`, `value`) VALUES ('ads', '{"header":"","footer":"","header_biolink":"","footer_biolink":""}'), ('captcha', '{"type":"basic","recaptcha_public_key":"","recaptcha_private_key":"","login_is_enabled":0,"register_is_enabled":0,"lost_password_is_enabled":0,"resend_activation_is_enabled":0}'), ('cron', concat('{\"key\":\"', @cron_key, '\"}')), ('default_language', 'english'), ('default_theme_style', 'light'), ('email_confirmation', '0'), ('register_is_enabled', '1'), ('email_notifications', '{\"emails\":\"\",\"new_user\":\"0\",\"new_payment\":\"0\"}'), ('facebook', '{\"is_enabled\":\"0\",\"app_id\":\"\",\"app_secret\":\"\"}'), ('favicon', ''), ('logo', ''), ('opengraph', ''), ('plan_custom', '{\"plan_id\":\"custom\",\"name\":\"Custom\",\"status\":1}'), ('plan_free', '{\"plan_id\":\"free\",\"name\":\"Free\",\"days\":null,\"status\":1,\"settings\":{"additional_global_domains":true,"custom_url":true,"deep_links":true,"no_ads":true,"removable_branding":true,"custom_branding":true,"custom_colored_links":true,"statistics":true,"google_analytics":true,"facebook_pixel":true,"custom_backgrounds":true,"verified":true,"scheduling":true,"seo":true,"utm":true,"socials":true,"fonts":true,"password":true,"sensitive_content":true,"leap_link":true,"projects_limit":-1,"biolinks_limit":-1,"links_limit":-1,"domains_limit":-1,"enabled_biolink_blocks":{"applemusic":true,"tidal":true,"anchor":true,"twitter_tweet":true,"instagram_media":true,"rss_feed":true,"custom_html":true,"vcard":true,"image_grid":true,"divider":true,"link":true,"text":true,"image":true,"mail":true,"soundcloud":true,"spotify":true,"youtube":true,"twitch":true,"vimeo":true,"tiktok":true}}}'), ('plan_trial', '{\"plan_id\":\"trial\",\"name\":\"Trial\",\"days\":7,\"status\":1,\"settings\":{"additional_global_domains":true,"custom_url":true,"deep_links":true,"no_ads":true,"removable_branding":true,"custom_branding":true,"custom_colored_links":true,"statistics":true,"google_analytics":true,"facebook_pixel":true,"custom_backgrounds":true,"verified":true,"scheduling":true,"seo":true,"utm":true,"socials":true,"fonts":true,"password":true,"sensitive_content":true,"leap_link":true,"projects_limit":-1,"biolinks_limit":-1,"links_limit":-1,"domains_limit":-1,"enabled_biolink_blocks":{"applemusic":true,"tidal":true,"anchor":true,"twitter_tweet":true,"instagram_media":true,"rss_feed":true,"custom_html":true,"vcard":true,"image_grid":true,"divider":true,"link":true,"text":true,"image":true,"mail":true,"soundcloud":true,"spotify":true,"youtube":true,"twitch":true,"vimeo":true,"tiktok":true}}}'), ('payment', '{\"is_enabled\":\"0\",\"type\":\"both\",\"brand_name\":\"phpBiolinks\",\"currency\":\"USD\", \"codes_is_enabled\": false}'), ('paypal', '{\"is_enabled\":\"0\",\"mode\":\"sandbox\",\"client_id\":\"\",\"secret\":\"\"}'), ('stripe', '{\"is_enabled\":\"0\",\"publishable_key\":\"\",\"secret_key\":\"\",\"webhook_secret\":\"\"}'), ('offline_payment', '{\"is_enabled\":\"0\",\"instructions\":\"Your offline payment instructions go here..\"}'), ('smtp', '{\"host\":\"\",\"from\":\"\",\"from_name\":\"\",\"encryption\":\"tls\",\"port\":\"587\",\"auth\":\"0\",\"username\":\"\",\"password\":\"\"}'), ('custom', '{\"head_js\":\"\",\"head_css\":\"\"}'), ('socials', '{\"facebook\":\"\",\"instagram\":\"\",\"twitter\":\"\",\"youtube\":\"\"}'), ('default_timezone', 'UTC'), ('title', 'phpBiolinks.com'), ('privacy_policy_url', ''), ('terms_and_conditions_url', ''), ('index_url', ''), ('announcements', '{"id":"","content":"","show_logged_in":"","show_logged_out":""}'), ('business', '{\"invoice_is_enabled\":\"0\",\"name\":\"\",\"address\":\"\",\"city\":\"\",\"county\":\"\",\"zip\":\"\",\"country\":\"\",\"email\":\"\",\"phone\":\"\",\"tax_type\":\"\",\"tax_id\":\"\",\"custom_key_one\":\"\",\"custom_value_one\":\"\",\"custom_key_two\":\"\",\"custom_value_two\":\"\"}'), ('webhooks', '{"user_new": "", "user_delete": ""}'), ('links', '{"branding":"Page by phpBiolinks.","shortener_is_enabled":"1","domains_is_enabled":"1","main_domain_is_enabled":"1","blacklisted_domains":"","blacklisted_keywords":"","phishtank_is_enabled":"","phishtank_api_key":"","google_safe_browsing_is_enabled":"","google_safe_browsing_api_key":""}'), ('license', '{\"license\":\"\",\"type\":\"\"}'), ('product_info', '{\"version\":\"8.0.1\", \"code\":\"801\"}'); -- SEPARATOR -- CREATE TABLE `users_logs` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` varchar(64) DEFAULT NULL, `date` datetime DEFAULT NULL, `ip` varchar(64) DEFAULT NULL, `public` int(11) DEFAULT '1', PRIMARY KEY (`id`), KEY `users_logs_user_id` (`user_id`), CONSTRAINT `users_logs_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- SEPARATOR -- CREATE TABLE `domains` ( `domain_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `scheme` varchar(8) NOT NULL DEFAULT '', `host` varchar(256) NOT NULL DEFAULT '', `custom_index_url` varchar(256) DEFAULT NULL, `custom_not_found_url` varchar(256) DEFAULT NULL, `type` tinyint(11) DEFAULT '1', `is_enabled` tinyint(4) DEFAULT '0', `datetime` datetime DEFAULT NULL, `last_datetime` datetime DEFAULT NULL, PRIMARY KEY (`domain_id`), KEY `user_id` (`user_id`), KEY `host` (`host`), KEY `type` (`type`), CONSTRAINT `domains_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.01 | proxy | phpinfo | ��ѧ��ۧܧ�