Guest User

Untitled

a guest
Mar 9th, 2021
42
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.  
  3.  
  4. return "DROP TABLE IF EXISTS `banner_ads`;\nCREATE TABLE `banner_ads` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(200) NOT NULL,\n `img` varchar(200) NOT NULL,\n `url` varchar(200) NOT NULL,\n `credits` int(11) DEFAULT '0',\n `views` int(11) NOT NULL DEFAULT '0',\n `clicks` int(11) NOT NULL DEFAULT '0',\n `status` varchar(50) NOT NULL DEFAULT 'Active'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `banner_price`;\nCREATE TABLE `banner_price` (\n `id` int(11) NOT NULL,\n `credits` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `banner_price` (`id`, `credits`, `price`) VALUES\n(1, 25000, '2.00');\n\nDROP TABLE IF EXISTS `blacklist`;\nCREATE TABLE `blacklist` (\n `id` int(11) NOT NULL,\n `date` int(11) NOT NULL,\n `type` varchar(255) NOT NULL,\n `criteria` varchar(255) DEFAULT NULL,\n `note` text\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `buyoptions`;\nCREATE TABLE `buyoptions` (\n `name` varchar(200) NOT NULL,\n `tblname` varchar(200) NOT NULL,\n `fieldassign` varchar(200) DEFAULT NULL,\n `comtype` varchar(200) DEFAULT NULL,\n `autoassign` varchar(10) DEFAULT 'yes',\n `descr` varchar(200) DEFAULT NULL,\n `hook_verify` varchar(10) DEFAULT NULL,\n `enable` varchar(10) DEFAULT 'yes'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `buyoptions` (`name`, `tblname`, `fieldassign`, `comtype`, `autoassign`, `descr`, `hook_verify`, `enable`) VALUES\n('ptc_credits', 'ads_price', 'credits', 'purchase', 'yes', '%descr PTC Credits', NULL, 'yes'),\n('ptsu_credits', 'ptsu_price', 'credits', 'purchase', '', '%descr PTSU Credits', NULL, 'yes'),\n('fad_credits', 'fads_price', 'credits', 'purchase', '', '%descr Featured Ads Credits', NULL, 'yes'),\n('bannerad_credits', 'banner_price', 'credits', 'purchase', '', '%descr Banner Ad Credits', NULL, 'yes'),\n('flink_credits', 'flinks_price', 'month', 'purchase', '', '%descr Featured Link Month(s)', NULL, 'yes'),\n('specialpack', 'specialpacks', 'name', NULL, 'yes', 'Special pack: %descr', NULL, 'yes'),\n('membership', 'membership', 'name', 'upgrade', 'yes', '%descr Membership', NULL, 'yes'),\n('referrals', 'referral_price', 'refs', NULL, '', '%descr Referral(s)', 'yes', 'yes'),\n('rent_referrals', '', '', NULL, 'yes', '%descr Rented Referral(s)', 'yes', 'yes'),\n('purchase_balance', '', NULL, NULL, 'yes', 'Internal transfer to purchase balance: \$%descr', 'yes', 'yes'),\n('membership_points', 'membership', 'name', '', 'yes', '%descr Membership', 'yes', 'yes'),\n('loginads_credits', 'loginads_price', 'days', 'purchase', 'yes', '%descr Login Ads Day(s)', NULL, 'yes');\n\nDROP TABLE IF EXISTS `cheat_log`;\nCREATE TABLE `cheat_log` (\n `id` int(11) NOT NULL,\n `date` int(11) NOT NULL,\n `type` int(11) NOT NULL DEFAULT '0',\n `log` mediumtext,\n `user_id` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `country`;\nCREATE TABLE `country` (\n `name` varchar(200) NOT NULL,\n `users` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `country` (`name`, `users`) VALUES\n('', 0);\n\nDROP TABLE IF EXISTS `cron_settings`;\nCREATE TABLE `cron_settings` (\n `field` varchar(100) NOT NULL,\n `value` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `cron_settings` (`field`, `value`) VALUES\n('delete_bannerads', 'yes'),\n('delete_fads', 'yes'),\n('delete_flinks', 'yes'),\n('delete_inactive', ''),\n('delete_loginads', 'yes'),\n('delete_ptc', 'yes'),\n('last_cron', '0000-00-00'),\n('reset_ptc', 'yes'),\n('suspend_inactive', '');\n\nDROP TABLE IF EXISTS `deposit_history`;\nCREATE TABLE `deposit_history` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL,\n `method` int(11) NOT NULL,\n `fromacc` varchar(100) NOT NULL,\n `amount` decimal(11,2) NOT NULL,\n `batch` varchar(200) DEFAULT NULL,\n `date` int(11) NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n\nDROP TABLE IF EXISTS `fads_price`;\nCREATE TABLE `fads_price` (\n `id` int(11) NOT NULL,\n `credits` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `fads_price` (`id`, `credits`, `price`) VALUES\n(1, 150000, '1.00');\n\nDROP TABLE IF EXISTS `faq`;\nCREATE TABLE `faq` (\n `id` int(11) NOT NULL,\n `forder` int(11) NOT NULL DEFAULT '1',\n `question` varchar(200) DEFAULT NULL,\n `answer` mediumtext\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `featured_ads`;\nCREATE TABLE `featured_ads` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(30) NOT NULL,\n `url` varchar(200) NOT NULL,\n `ad` varchar(51) NOT NULL,\n `credits` int(11) NOT NULL DEFAULT '0',\n `views` int(11) NOT NULL DEFAULT '0',\n `clicks` int(11) NOT NULL DEFAULT '0',\n `status` varchar(50) NOT NULL DEFAULT 'Active'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `featured_link`;\nCREATE TABLE `featured_link` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(30) NOT NULL,\n `url` varchar(200) NOT NULL,\n `expires` int(11) NOT NULL DEFAULT '0',\n `views` int(11) NOT NULL DEFAULT '0',\n `clicks` int(11) NOT NULL DEFAULT '0',\n `status` varchar(50) NOT NULL DEFAULT 'Active'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `flinks_price`;\nCREATE TABLE `flinks_price` (\n `id` int(11) NOT NULL,\n `month` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `flinks_price` (`id`, `month`, `price`) VALUES\n(1, 1, '10.00');\n\nDROP TABLE IF EXISTS `forum_boards`;\nCREATE TABLE `forum_boards` (\n `id` int(11) NOT NULL,\n `cat_id` int(11) NOT NULL DEFAULT '0',\n `name` varchar(200) DEFAULT NULL,\n `descr` varchar(200) DEFAULT NULL,\n `topics` int(11) NOT NULL DEFAULT '0',\n `posts` int(11) NOT NULL DEFAULT '0',\n `position` int(11) NOT NULL DEFAULT '1'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `forum_boards` (`id`, `cat_id`, `name`, `descr`, `topics`, `posts`, `position`) VALUES\n(1, 1, 'Announcements', 'Site news here', 0, 0, 1);\n\nDROP TABLE IF EXISTS `forum_categories`;\nCREATE TABLE `forum_categories` (\n `id` int(11) NOT NULL,\n `name` varchar(200) DEFAULT NULL,\n `position` int(11) NOT NULL DEFAULT '1'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `forum_categories` (`id`, `name`, `position`) VALUES\n(1, 'News and Information', 1);\n\nDROP TABLE IF EXISTS `forum_groups`;\nCREATE TABLE `forum_groups` (\n `id` int(11) NOT NULL,\n `name` varchar(200) NOT NULL,\n `canviewforum` varchar(5) NOT NULL DEFAULT 'yes',\n `canviewtopic` varchar(5) NOT NULL DEFAULT 'yes',\n `canposttopic` varchar(5) NOT NULL DEFAULT 'yes',\n `caneditownpost` varchar(5) NOT NULL DEFAULT 'yes',\n `caneditotherspost` varchar(5) NOT NULL DEFAULT 'no',\n `candeleteownpost` varchar(5) NOT NULL DEFAULT 'no',\n `candeleteotherspost` varchar(5) NOT NULL DEFAULT 'no',\n `canopencloseowntopics` varchar(5) NOT NULL DEFAULT 'no',\n `canopenclosetopics` varchar(5) NOT NULL DEFAULT 'no',\n `canmoveowntopics` varchar(5) NOT NULL DEFAULT 'no',\n `canmoveotherstopic` varchar(5) NOT NULL DEFAULT 'no',\n `canbanmembers` varchar(5) DEFAULT 'no',\n `cansuspendmember` varchar(5) DEFAULT 'no'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `forum_groups` (`id`, `name`, `canviewforum`, `canviewtopic`, `canposttopic`, `caneditownpost`, `caneditotherspost`, `candeleteownpost`, `candeleteotherspost`, `canopencloseowntopics`, `canopenclosetopics`, `canmoveowntopics`, `canmoveotherstopic`, `canbanmembers`, `cansuspendmember`) VALUES\n(1, 'Admin', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n(2, 'Moderator', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no'),\n(3, 'Normal Members', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n(4, 'Banned', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n(5, 'Guests', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');\n\nDROP TABLE IF EXISTS `forum_log_boards`;\nCREATE TABLE `forum_log_boards` (\n `id_member` int(11) NOT NULL,\n `id_board` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `forum_posts`;\nCREATE TABLE `forum_posts` (\n `id` int(11) NOT NULL,\n `bid` int(11) NOT NULL DEFAULT '0',\n `topic_rel` int(11) NOT NULL DEFAULT '0',\n `title` varchar(200) DEFAULT NULL,\n `descr` varchar(200) DEFAULT '............',\n `message` text,\n `date` int(11) NOT NULL DEFAULT '0',\n `date_updated` int(11) NOT NULL DEFAULT '0',\n `edit_date` int(11) NOT NULL DEFAULT '0',\n `author` varchar(200) DEFAULT NULL,\n `topic` varchar(5) NOT NULL DEFAULT 'no',\n `replies` int(11) NOT NULL DEFAULT '0',\n `views` int(11) NOT NULL DEFAULT '0',\n `sticky` int(1) NOT NULL DEFAULT '0',\n `locked` int(1) NOT NULL DEFAULT '0',\n `edited` int(1) NOT NULL DEFAULT '0',\n `edited_author` varchar(200) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `helpdesk_department`;\nCREATE TABLE `helpdesk_department` (\n `id` int(11) NOT NULL,\n `name` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `helpdesk_department` (`id`, `name`) VALUES\n(1, 'General Support'),\n(2, 'Payments Support'),\n(3, 'Advertising Support');\n\nDROP TABLE IF EXISTS `helpdesk_replies`;\nCREATE TABLE `helpdesk_replies` (\n `id` int(11) NOT NULL,\n `ticket_id` int(11) NOT NULL DEFAULT '0',\n `user_reply` int(2) NOT NULL DEFAULT '0',\n `message` mediumtext,\n `date` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `helpdesk_settings`;\nCREATE TABLE `helpdesk_settings` (\n `field` varchar(200) NOT NULL,\n `value` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `helpdesk_settings` (`field`, `value`) VALUES\n('helpdesk_enable', 'yes'),\n('members_only', 'no');\n\nDROP TABLE IF EXISTS `helpdesk_ticket`;\nCREATE TABLE `helpdesk_ticket` (\n `id` int(11) NOT NULL,\n `ticket` varchar(200) NOT NULL,\n `department` int(11) DEFAULT NULL,\n `user_id` int(11) DEFAULT NULL,\n `name` varchar(200) DEFAULT NULL,\n `email` varchar(200) DEFAULT NULL,\n `subject` varchar(200) DEFAULT NULL,\n `message` mediumtext NOT NULL,\n `status` int(11) NOT NULL DEFAULT '1',\n `date` int(11) NOT NULL DEFAULT '0',\n `last_update` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `ip_ptc`;\nCREATE TABLE `ip_ptc` (\n `ip` varchar(200) DEFAULT NULL,\n `ad_id` int(11) NOT NULL DEFAULT '0',\n `date` date DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `language`;\nCREATE TABLE `language` (\n `id` int(11) NOT NULL,\n `name` varchar(50) NOT NULL,\n `filename` varchar(50) NOT NULL,\n `default_lang` int(1) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `language` (`id`, `name`, `filename`, `default_lang`) VALUES\n(1, 'English (US)', 'english.php', 1);\n\nDROP TABLE IF EXISTS `linktracker`;\nCREATE TABLE `linktracker` (\n `id` int(11) NOT NULL,\n `date` int(11) NOT NULL DEFAULT '0',\n `name` varchar(200) NOT NULL,\n `descr` varchar(255) DEFAULT NULL,\n `hits` int(11) NOT NULL DEFAULT '0',\n `uniquehits` int(11) NOT NULL DEFAULT '0',\n `signups` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `linktracker_log`;\nCREATE TABLE `linktracker_log` (\n `id` int(11) NOT NULL,\n `track_id` int(11) NOT NULL,\n `ip` varchar(100) NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `localkey`;\nCREATE TABLE `localkey` (\n `id` int(1) NOT NULL DEFAULT '1',\n `localkey` text\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `localkey` (`id`, `localkey`) VALUES\n(1, '9tjIlZXa0NWQiojN6M3OiMXd0FGdzJiO2ozc7EDN0MjM0kDO0EjOptjIlRXYkt2Ylh2YioTO6M3OikTO3IDO3QTM1EjI6ATM6M3OiQncvBHc1NnI6cjOztjT7IyclJXawhXZiozN6M3OiYUQFhzM1ITR1QURENkQwADMyYDOGNTOEVjI6UjM6M3OiU2cuV2YpxmI6cjOztjIiV2duAjNvZXZioTO6M3Oi4Wah12bkJiO2ozc7ISZz5WZjlGbgUWbpRXZmlGTiojNxozc7ICdjVHZvJHciozN6M3Oi02bj5CdwlmcjNnbvlGd1x2b2VGQ0J3bwBXdzJiO3IjOztjIslWYtVGduVWasNmI6ETM6M3OiQHcpJ3YT52bpRXds9mdFJiO1EjOztjIl1WYuRnbllGbjJiOwEjOztnO5oTY6d068377f4d7f6af5fc252db8364a67094d96c2f07771bae1bfb794ef4d28b9fa1778ed1469c40a746445ea60e5722f9');\n\nDROP TABLE IF EXISTS `loginads_price`;\nCREATE TABLE `loginads_price` (\n `id` int(11) NOT NULL,\n `days` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `loginads_price` (`id`, `days`, `price`) VALUES\n(1, 30, '10.00');\n\nDROP TABLE IF EXISTS `login_ads`;\nCREATE TABLE `login_ads` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(30) NOT NULL,\n `image` varchar(200) NOT NULL,\n `url` varchar(200) NOT NULL,\n `expires` int(11) NOT NULL DEFAULT '0',\n `views` int(11) NOT NULL DEFAULT '0',\n `clicks` int(11) NOT NULL DEFAULT '0',\n `status` varchar(50) NOT NULL DEFAULT 'Active'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `login_history`;\nCREATE TABLE `login_history` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `ip` varchar(100) DEFAULT NULL,\n `status` varchar(20) NOT NULL DEFAULT 'Successful',\n `password` varchar(100) DEFAULT NULL,\n `date` int(11) NOT NULL DEFAULT '0',\n `agent` text\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `mail_settings`;\nCREATE TABLE `mail_settings` (\n `field` varchar(200) NOT NULL,\n `value` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `mail_settings` (`field`, `value`) VALUES\n('email_from_address', 'noreply@evolutionscript.com'),\n('email_from_name', 'EvolutionScript Staff'),\n('email_type', 'php'),\n('smtp_host', 'smtp.gmail.com'),\n('smtp_password', ''),\n('smtp_port', '587'),\n('smtp_ssl', 'tls'),\n('smtp_username', 'test@gmail.com');\n\nDROP TABLE IF EXISTS `members`;\nCREATE TABLE `members` (\n `id` int(11) NOT NULL,\n `type` int(2) NOT NULL DEFAULT '1',\n `fullname` varchar(200) DEFAULT NULL,\n `comes_from` varchar(250) NOT NULL DEFAULT '-',\n `username` varchar(200) NOT NULL,\n `two_factor` mediumtext,\n `password` varchar(100) NOT NULL,\n `email` varchar(200) NOT NULL,\n `new_email` varchar(200) DEFAULT NULL,\n `ref1` varchar(200) NOT NULL DEFAULT '0',\n `referrals` int(11) NOT NULL DEFAULT '0',\n `rented_referrals` int(11) NOT NULL DEFAULT '0',\n `purchase_balance` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `money` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `points` decimal(11,2) NOT NULL DEFAULT '0.00',\n `withdraw` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `pending_withdraw` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `cashout_times` int(11) NOT NULL DEFAULT '0',\n `ad_credits` int(11) NOT NULL DEFAULT '0',\n `loginads_credits` int(11) NOT NULL DEFAULT '0',\n `ptsu_credits` int(11) NOT NULL DEFAULT '0',\n `banner_credits` int(11) NOT NULL DEFAULT '0',\n `fads_credits` int(11) NOT NULL DEFAULT '0',\n `flink_credits` int(11) NOT NULL DEFAULT '0',\n `adminad` int(1) NOT NULL DEFAULT '0',\n `advisto` mediumtext,\n `loginads_view` int(11) NOT NULL DEFAULT '0',\n `clicks` int(11) NOT NULL DEFAULT '0',\n `offerwall_earnings` double NOT NULL DEFAULT '0',\n `offerwall_upline_commission` double NOT NULL DEFAULT '0',\n `for_refclicks` int(11) NOT NULL DEFAULT '0',\n `for_refearned` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `for_reflastclick` int(11) NOT NULL DEFAULT '0',\n `signup` int(11) NOT NULL DEFAULT '0',\n `country` varchar(100) DEFAULT NULL,\n `autopay` varchar(5) NOT NULL DEFAULT 'no',\n `last_rent` int(11) NOT NULL DEFAULT '0',\n `last_cashout` int(11) NOT NULL DEFAULT '0',\n `upgrade_ends` int(11) NOT NULL DEFAULT '0',\n `signup_ip` varchar(100) NOT NULL DEFAULT '-',\n `last_ip` varchar(100) NOT NULL DEFAULT '-',\n `last_login` int(11) NOT NULL DEFAULT '0',\n `rented` int(11) NOT NULL DEFAULT '0',\n `rented_time` int(11) NOT NULL DEFAULT '0',\n `rented_expires` int(11) NOT NULL DEFAULT '0',\n `rented_clicks` int(11) NOT NULL DEFAULT '0',\n `rented_lastclick` int(11) NOT NULL DEFAULT '0',\n `rented_earned` decimal(11,3) NOT NULL DEFAULT '0.000',\n `rented_autopay` int(11) NOT NULL DEFAULT '0',\n `status` varchar(100) NOT NULL DEFAULT 'Un-verified',\n `myrefs1` int(11) NOT NULL DEFAULT '0',\n `refearnings` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `refclicks` int(11) NOT NULL DEFAULT '0',\n `mc1` int(11) NOT NULL DEFAULT '0',\n `mc2` int(11) NOT NULL DEFAULT '0',\n `mc3` int(11) NOT NULL DEFAULT '0',\n `mc4` int(11) NOT NULL DEFAULT '0',\n `mc5` int(11) NOT NULL DEFAULT '0',\n `mc6` int(11) NOT NULL DEFAULT '0',\n `mc7` int(11) NOT NULL DEFAULT '0',\n `r1` int(11) NOT NULL DEFAULT '0',\n `r2` int(11) NOT NULL DEFAULT '0',\n `r3` int(11) NOT NULL DEFAULT '0',\n `r4` int(11) NOT NULL DEFAULT '0',\n `r5` int(11) NOT NULL DEFAULT '0',\n `r6` int(11) NOT NULL DEFAULT '0',\n `r7` int(11) NOT NULL DEFAULT '0',\n `rr1` int(11) NOT NULL DEFAULT '0',\n `rr2` int(11) NOT NULL DEFAULT '0',\n `rr3` int(11) NOT NULL DEFAULT '0',\n `rr4` int(11) NOT NULL DEFAULT '0',\n `rr5` int(11) NOT NULL DEFAULT '0',\n `rr6` int(11) NOT NULL DEFAULT '0',\n `rr7` int(11) NOT NULL DEFAULT '0',\n `ap1` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap2` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap3` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap4` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap5` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap6` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `ap7` decimal(11,4) NOT NULL DEFAULT '0.0000',\n `acceptmails` varchar(10) NOT NULL DEFAULT 'yes',\n `cookie_id` varchar(100) DEFAULT NULL,\n `computer_stored` varchar(5) NOT NULL DEFAULT 'no',\n `computer_id` varchar(100) DEFAULT NULL,\n `verifycode` varchar(200) DEFAULT NULL,\n `forum_posts` int(11) NOT NULL DEFAULT '0',\n `forum_avatar` varchar(200) DEFAULT NULL,\n `forum_status` varchar(100) NOT NULL DEFAULT 'Active',\n `forum_role` int(2) NOT NULL DEFAULT '3',\n `forum_stats` varchar(5) DEFAULT 'no',\n `forum_signature` text,\n `personal_msg` varchar(5) NOT NULL DEFAULT 'no',\n `adminnotes` mediumtext,\n `gateways` mediumtext,\n `ptsu_denied` int(11) NOT NULL DEFAULT '0',\n `last_cron` date DEFAULT NULL,\n `chart_num` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `membership`;\nCREATE TABLE `membership` (\n `id` int(11) NOT NULL,\n `name` varchar(200) NOT NULL,\n `duration` int(11) NOT NULL DEFAULT '30',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00',\n `click` int(11) NOT NULL DEFAULT '100',\n `ref_click` int(11) NOT NULL DEFAULT '0',\n `minimum_payout` varchar(100) DEFAULT NULL,\n `ref_upgrade` decimal(11,2) NOT NULL DEFAULT '0.00',\n `ref_purchase` int(11) NOT NULL DEFAULT '0',\n `directref_limit` int(11) NOT NULL DEFAULT '10',\n `rent_pack` varchar(100) NOT NULL DEFAULT '0',\n `rentedref_limit` int(11) NOT NULL DEFAULT '300',\n `recycle_cost` decimal(11,3) NOT NULL DEFAULT '0.000',\n `rent_time` int(11) NOT NULL DEFAULT '0',\n `cashout_time` int(11) NOT NULL DEFAULT '0',\n `referral_deletion` decimal(11,3) NOT NULL DEFAULT '0.000',\n `active` varchar(4) DEFAULT 'yes',\n `instant_withdrawal` varchar(4) DEFAULT 'yes',\n `max_clicks` int(11) NOT NULL DEFAULT '0',\n `rentprice` decimal(11,2) NOT NULL DEFAULT '0.00',\n `cashoutamount` decimal(11,2) NOT NULL DEFAULT '100.00',\n `max_withdraw` decimal(11,2) NOT NULL DEFAULT '0.00',\n `rent250` varchar(11) NOT NULL DEFAULT '0.32',\n `rent500` varchar(11) NOT NULL DEFAULT '0.32',\n `rent750` varchar(11) NOT NULL DEFAULT '0.32',\n `rent1000` varchar(11) NOT NULL DEFAULT '0.32',\n `rent1250` varchar(11) NOT NULL DEFAULT '0.32',\n `rent1500` varchar(11) NOT NULL DEFAULT '0.32',\n `rent1750` varchar(11) NOT NULL DEFAULT '0.32',\n `rentover` varchar(11) NOT NULL DEFAULT '0.32',\n `autopay250` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay500` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay750` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay1000` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay1250` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay1500` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopay1750` varchar(11) NOT NULL DEFAULT '0.0067',\n `autopayover` varchar(11) NOT NULL DEFAULT '0.0067',\n `point_enable` int(2) NOT NULL DEFAULT '0',\n `point_ref` decimal(11,2) NOT NULL DEFAULT '0.00',\n `point_ptc` decimal(11,2) NOT NULL DEFAULT '0.00',\n `point_post` decimal(11,2) NOT NULL DEFAULT '0.00',\n `point_ptsu` decimal(11,2) NOT NULL DEFAULT '0.00',\n `point_deposit` decimal(11,2) NOT NULL DEFAULT '0.00',\n `point_upgrade` int(2) NOT NULL DEFAULT '0',\n `point_upgraderate` decimal(11,2) NOT NULL DEFAULT '20.00',\n `point_purchasebalance` int(2) NOT NULL DEFAULT '0',\n `point_cashrate` decimal(11,2) NOT NULL DEFAULT '10.00',\n `cpxresearch_ratio` double NOT NULL DEFAULT '0',\n `cpxresearch_points` decimal(11,2) NOT NULL DEFAULT '0.00',\n `cpxresearch_ref` double NOT NULL DEFAULT '0',\n `wannads_ratio` double NOT NULL DEFAULT '0',\n `wannads_points` decimal(11,2) NOT NULL DEFAULT '0.00',\n `wannads_ref` double NOT NULL DEFAULT '0',\n `mediumpath_ratio` double NOT NULL DEFAULT '0',\n `mediumpath_points` decimal(11,2) NOT NULL DEFAULT '0.00',\n `mediumpath_ref` double NOT NULL DEFAULT '0',\n `opinioncapital_ratio` double NOT NULL DEFAULT '0',\n `opinioncapital_points` decimal(11,2) NOT NULL DEFAULT '0.00',\n `opinioncapital_ref` double NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `membership` (`id`, `name`, `duration`, `price`, `click`, `ref_click`, `minimum_payout`, `ref_upgrade`, `ref_purchase`, `directref_limit`, `rent_pack`, `rentedref_limit`, `recycle_cost`, `rent_time`, `cashout_time`, `referral_deletion`, `active`, `instant_withdrawal`, `max_clicks`, `rentprice`, `cashoutamount`, `max_withdraw`, `rent250`, `rent500`, `rent750`, `rent1000`, `rent1250`, `rent1500`, `rent1750`, `rentover`, `autopay250`, `autopay500`, `autopay750`, `autopay1000`, `autopay1250`, `autopay1500`, `autopay1750`, `autopayover`, `point_enable`, `point_ref`, `point_ptc`, `point_post`, `point_ptsu`, `point_deposit`, `point_upgrade`, `point_upgraderate`, `point_purchasebalance`, `point_cashrate`) VALUES\n(1, 'Standard', 30, '0.00', 50, 20, '2,4,6,8,10', '0.00', 0, 20, '5,10,20,50,75,100', 100, '0.080', 0, 7, '0.100', 'yes', NULL, 100, '0.50', '10.00', '10.00', '0.32', '0.32', '0.32', '0.32', '0.32', '0.32', '0.32', '0.32', '0.0067', '0.0067', '0.0067', '0.0067', '0.0067', '0.0067', '0.0067', '0.0067', 1, '0.01', '0.02', '0.04', '0.05', '0.07', 1, '1.00', 0, '0.01');\n\nDROP TABLE IF EXISTS `messages`;\nCREATE TABLE `messages` (\n `id` int(11) NOT NULL,\n `user_from` int(11) NOT NULL DEFAULT '0',\n `user_to` int(11) NOT NULL DEFAULT '0',\n `subject` mediumtext,\n `message` text,\n `date` int(11) NOT NULL DEFAULT '0',\n `user_read` varchar(5) NOT NULL DEFAULT 'no'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `news`;\nCREATE TABLE `news` (\n `id` int(11) NOT NULL,\n `title` varchar(200) DEFAULT NULL,\n `message` mediumtext,\n `date` int(11) NOT NULL DEFAULT '0',\n `loginads` int(2) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `order_history`;\nCREATE TABLE `order_history` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `name` varchar(200) DEFAULT NULL,\n `type` varchar(200) DEFAULT NULL,\n `item_id` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) DEFAULT NULL,\n `date` int(11) NOT NULL DEFAULT '0',\n `status` varchar(100) NOT NULL DEFAULT 'Pending',\n `ref` int(11) NOT NULL DEFAULT '0',\n `ref_comission` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `payeer_orders`;\nCREATE TABLE `payeer_orders` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `upgrade` int(2) NOT NULL DEFAULT '0',\n `membership_id` int(11) DEFAULT '0',\n `batch` varchar(100) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `ptsu_offers`;\nCREATE TABLE `ptsu_offers` (\n `id` int(11) NOT NULL,\n `user_id` int(11) NOT NULL DEFAULT '0',\n `title` varchar(100) DEFAULT NULL,\n `descr` varchar(200) DEFAULT NULL,\n `instructions` mediumtext,\n `url` varchar(100) DEFAULT NULL,\n `value` decimal(11,2) NOT NULL DEFAULT '0.00',\n `credits` int(11) NOT NULL DEFAULT '0',\n `approved` int(11) NOT NULL DEFAULT '0',\n `pending` int(11) NOT NULL DEFAULT '0',\n `claims` int(11) NOT NULL DEFAULT '0',\n `country` text,\n `status` varchar(100) NOT NULL DEFAULT 'Inactive',\n `membership` text\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `ptsu_price`;\nCREATE TABLE `ptsu_price` (\n `id` int(11) NOT NULL,\n `credits` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `ptsu_requests`;\nCREATE TABLE `ptsu_requests` (\n `id` int(11) NOT NULL,\n `ptsu_id` int(11) NOT NULL,\n `owner_id` int(11) NOT NULL DEFAULT '0',\n `user_id` int(11) NOT NULL DEFAULT '0',\n `username` varchar(100) DEFAULT NULL,\n `message` mediumtext,\n `title` varchar(200) DEFAULT NULL,\n `value` decimal(11,2) NOT NULL DEFAULT '0.00',\n `url` varchar(200) DEFAULT NULL,\n `date` int(11) NOT NULL DEFAULT '0',\n `status` varchar(50) NOT NULL DEFAULT 'Pending',\n `advertiser_notes` mediumtext\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `ptsu_value`;\nCREATE TABLE `ptsu_value` (\n `id` int(11) NOT NULL,\n `value` decimal(11,2) NOT NULL DEFAULT '0.00',\n `credits` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `referral_price`;\nCREATE TABLE `referral_price` (\n `id` int(11) NOT NULL,\n `refs` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `referral_price` (`id`, `refs`, `price`) VALUES\n(1, 1, '1.00');\n\nDROP TABLE IF EXISTS `rent_discount`;\nCREATE TABLE `rent_discount` (\n `id` int(11) NOT NULL,\n `days` int(11) NOT NULL DEFAULT '0',\n `discount` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `rent_discount` (`id`, `days`, `discount`) VALUES\n(1, 30, 0);\n\nDROP TABLE IF EXISTS `settings`;\nCREATE TABLE `settings` (\n `field` varchar(100) NOT NULL,\n `value` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `settings` (`field`, `value`) VALUES\n('allowchangelanguage', 'yes'),\n('amount_transfer', '0.10'),\n('autoloadad_secs', '7'),\n('balance_bonus', '0.00'),\n('bannerads_approval', ''),\n('bannerads_available', 'yes'),\n('bannerad_chars_title', '200'),\n('bonus_date', ''),\n('bonus_date_ends', ''),\n('bonus_ends', '0'),\n('bonus_start', '0'),\n('bonus_totalmembers', ''),\n('buyref_clicks', '0'),\n('buyref_days', '7'),\n('buyref_filter', 'disable'),\n('buy_referrals', 'yes'),\n('cancel_pendingwithdraw', 'no'),\n('captcha_contact', 'yes'),\n('captcha_login', 'yes'),\n('captcha_register', 'yes'),\n('captcha_type', '1'),\n('captcha_viewads', ''),\n('captcha_bg', '#FFFFFF'),\n('captcha_text_1', '#000000'),\n('captcha_text_2', '#5E1BE5'),\n('captcha_text_3', '#AA0B0B'),\n('captcha_text_4', '#0F9C00'),\n('captcha_text_5', '#FD9F06'),\n('clicks_necessary', '4'),\n('click_yesterday', 'yes'),\n('copyright', '1'),\n('currency_symbol', '\$'),\n('demo', ''),\n('emailchange_activation', 'yes'),\n('email_support', 'support@yourdomain.com'),\n('fads_approval', ''),\n('fads_available', 'yes'),\n('fail_payments', 'yes'),\n('featuredad_chars_descr', '51'),\n('featuredad_chars_title', '30'),\n('featuredlink_chars_title', '30'),\n('flinks_approval', ''),\n('flinks_available', 'yes'),\n('force_viewads', '1'),\n('forum_active', 'yes'),\n('forum_search', '1'),\n('forum_signature', 'yes'),\n('forum_signature_maxchar', '500'),\n('googleanalytics', ''),\n('googleanalyticsid', ''),\n('hcaptcha_public',''),\n('hcaptcha_private',''),\n('inactive_days', '30'),\n('instant_payment', ''),\n('loginads_approval', ''),\n('loginads_available', 'yes'),\n('loginads_max', '2'),\n('loginad_chars_title', '30'),\n('maintenance', ''),\n('maintenance_msg', 'We are currently performing maintenance and will be back shortly.'),\n('max_result_page', '50'),\n('membershipdays_bonus', '0'),\n('membership_bonus', ''),\n('message_per_page', '5'),\n('message_system', 'yes'),\n('money_transfer', 'yes'),\n('multi_country', ''),\n('multi_login', ''),\n('multi_registration', ''),\n('payment_proof', 'yes'),\n('ptc_approval', ''),\n('ptc_chars_descr', '100'),\n('ptc_chars_title', '100'),\n('ptsu_approval', 'yes'),\n('ptsu_autoapprovedays', '30'),\n('ptsu_available', 'yes'),\n('ptsu_chars_descr', '200'),\n('ptsu_chars_title', '100'),\n('ptsu_exclusion', '1'),\n('purchase_bonus', '0.00'),\n('recaptcha_version', '2'),\n('recaptcha_privatekey', ''),\n('recaptcha_publickey', ''),\n('ref_deletion', 'yes'),\n('register_activation', 'yes'),\n('rentref_clicks', '0'),\n('rentref_days', '7'),\n('rentref_filter', 'disable'),\n('rentype', '2'),\n('rent_referrals', 'yes'),\n('show_fads', '4'),\n('show_flinks', '4'),\n('signup_bonus', 'no'),\n('site_name', 'EvolutionScript 5.4'),\n('site_stats', 'yes'),\n('site_title', 'EvolutionScript 5.4'),\n('site_url', 'http://evo60.web/'),\n('solvemedia_ckey', ''),\n('solvemedia_hkey', ''),\n('solvemedia_vkey', ''),\n('special_available', 'yes'),\n('ssl_host', ''),\n('timezone', ''),\n('todayclick', '6'),\n('topdomains', 'yes'),\n('unique_ip', ''),\n('upgrade_purchasebalance', 'yes'),\n('usersonline', ''),\n('withdraw_clicks', '0'),\n('withdraw_sameprocessor', 'yes');\n\nDROP TABLE IF EXISTS `site_banners`;\nCREATE TABLE `site_banners` (\n `id` int(11) NOT NULL,\n `url` varchar(200) DEFAULT NULL,\n `width` int(4) NOT NULL DEFAULT '0',\n `height` int(4) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `site_content`;\nCREATE TABLE `site_content` (\n `id` varchar(100) NOT NULL,\n `content` text\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `site_content` (`id`, `content`) VALUES\n('terms', '<h2 align=\"center\"><u>Terms of Service</u></h2>My terms of service');\n\nDROP TABLE IF EXISTS `specialpacks`;\nCREATE TABLE `specialpacks` (\n `id` int(11) NOT NULL,\n `name` varchar(200) DEFAULT NULL,\n `date` int(11) NOT NULL DEFAULT '0',\n `buys` int(11) NOT NULL DEFAULT '0',\n `price` decimal(11,2) NOT NULL DEFAULT '0.00',\n `enable` varchar(5) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `specialpacks_list`;\nCREATE TABLE `specialpacks_list` (\n `id` int(11) NOT NULL,\n `specialpack` int(11) NOT NULL DEFAULT '0',\n `title` varchar(200) DEFAULT NULL,\n `type` varchar(200) DEFAULT NULL,\n `amount` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `statistics`;\nCREATE TABLE `statistics` (\n `field` varchar(100) NOT NULL,\n `value` varchar(100) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nINSERT INTO `statistics` (`field`, `value`) VALUES\n('cashout', '0.00'),\n('deposit', '0.00'),\n('last_check', '0'),\n('members', '0'),\n('members_today', '0');\n\nDROP TABLE IF EXISTS `stp_pending`;\nCREATE TABLE `stp_pending` (\n `id` int(11) NOT NULL,\n `amount` decimal(11,2) NOT NULL DEFAULT '0.00',\n `order_id` varchar(200) DEFAULT NULL,\n `batch` varchar(200) DEFAULT NULL,\n `customer` varchar(200) DEFAULT NULL,\n `date` int(11) DEFAULT NULL,\n `upgrade_id` varchar(200) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `topdomains`;\nCREATE TABLE `topdomains` (\n `id` int(11) NOT NULL,\n `domain` varchar(200) DEFAULT NULL,\n `hits` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `users_online`;\nCREATE TABLE `users_online` (\n `ip` varchar(200) DEFAULT NULL,\n `date` int(11) NOT NULL DEFAULT '0'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\nDROP TABLE IF EXISTS `withdraw_history`;\nCREATE TABLE `withdraw_history` (\n `id` int(11) NOT NULL,\n `user_id` varchar(200) NOT NULL DEFAULT '0',\n `method` int(11) NOT NULL DEFAULT '0',\n `account` varchar(200) DEFAULT NULL,\n `amount` decimal(11,2) NOT NULL DEFAULT '0.00',\n `fee` double NOT NULL DEFAULT '0',\n `date` varchar(11) NOT NULL DEFAULT '0',\n `status` varchar(100) NOT NULL DEFAULT 'Pending'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n\n\nALTER TABLE `banner_ads`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `banner_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `blacklist`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `cheat_log`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `cron_settings`\n ADD PRIMARY KEY (`field`);\n\nALTER TABLE `deposit_history`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `fads_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `faq`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `featured_ads`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `featured_link`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `flinks_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `forum_boards`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `forum_categories`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `forum_groups`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `forum_posts`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `helpdesk_department`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `helpdesk_replies`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `helpdesk_ticket`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `ip_ptc`\n ADD KEY `ip` (`ip`);\n\nALTER TABLE `language`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `linktracker`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `linktracker_log`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `localkey`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `loginads_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `login_ads`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `login_history`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `mail_settings`\n ADD UNIQUE KEY `field` (`field`);\n\nALTER TABLE `members`\n ADD PRIMARY KEY (`id`),\n ADD KEY `username` (`username`),\n ADD KEY `rented` (`rented`),\n ADD KEY `computer_id` (`computer_id`),\n ADD KEY `ref1` (`ref1`);\n\nALTER TABLE `membership`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `messages`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `news`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `order_history`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `payeer_orders`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `ptsu_offers`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `ptsu_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `ptsu_requests`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `ptsu_value`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `referral_price`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `rent_discount`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `settings`\n ADD PRIMARY KEY (`field`);\n\nALTER TABLE `site_banners`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `site_content`\n ADD KEY `id` (`id`);\n\nALTER TABLE `specialpacks`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `specialpacks_list`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `statistics`\n ADD PRIMARY KEY (`field`);\n\nALTER TABLE `stp_pending`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `topdomains`\n ADD PRIMARY KEY (`id`);\n\nALTER TABLE `withdraw_history`\n ADD PRIMARY KEY (`id`);\n\n\nALTER TABLE `banner_ads`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `banner_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `blacklist`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `cheat_log`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `deposit_history`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `fads_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `faq`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `featured_ads`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `featured_link`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `flinks_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `forum_boards`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `forum_categories`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `forum_groups`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;\nALTER TABLE `forum_posts`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\n\nALTER TABLE `helpdesk_department`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;\nALTER TABLE `helpdesk_replies`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `helpdesk_ticket`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `language`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `linktracker`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `linktracker_log`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `loginads_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `login_ads`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `login_history`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `members`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `membership`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `messages`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `news`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `order_history`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `payeer_orders`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `ptsu_offers`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `ptsu_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `ptsu_requests`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `ptsu_value`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `referral_price`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `rent_discount`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;\nALTER TABLE `site_banners`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `specialpacks`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `specialpacks_list`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `stp_pending`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `topdomains`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;\nALTER TABLE `withdraw_history`\n MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;";
  5.  
  6. ?>
RAW Paste Data