zwzNDurZ

1SET NAMES utf8mb4;
2
3ALTER TABLE `user_level` ADD `can_remote_download` int(1) NOT NULL DEFAULT '1' AFTER `max_download_filesize_allowed`;
4
5INSERT INTO `site_config` (`config_key`, `label`, `config_value`, `config_description`, `availableValues`, `config_type`, `config_group`, `display_order`) VALUES ('captcha_login_screen_normal', 'Show User Login Screen', 'no', 'Show the captcha on the standard login screen.', '[\"yes\",\"no\"]', 'select', 'Captcha', 6);
6INSERT INTO `site_config` (`config_key`, `label`, `config_value`, `config_description`, `availableValues`, `config_type`, `config_group`, `display_order`) VALUES ('captcha_login_screen_admin', 'Show Admin Login Screen', 'no', 'Show the captcha on the admin login screen.', '[\"yes\",\"no\"]', 'select', 'Captcha', 7);
7UPDATE `site_config` SET label = 'File Download - Non User' WHERE config_key = 'non_user_show_captcha';
8UPDATE `site_config` SET label = 'File Download - Free User' WHERE config_key = 'free_user_show_captcha';
9
10ALTER TABLE `download_token` ADD `file_transfer` int(1) NOT NULL DEFAULT '1';
11
12ALTER TABLE `file_action` ADD `is_uploaded_file` int(11) NOT NULL DEFAULT '0' AFTER `file_path`;
13
14UPDATE file_server SET storagePath = 'files/' WHERE (storagePath = '' OR storagePath IS NULL) AND serverType = 'local';
15
16ALTER TABLE `file_server` DROP `lastFileActionQueueProcess`;
17ALTER TABLE `file_server` ADD `lastFileActionQueueProcess` datetime NULL AFTER `routeViaMainSite`;
18ALTER TABLE `file_server` ADD `scriptRootPath` varchar(255) NULL AFTER `statusId`;
19
20UPDATE file_folder_share SET last_accessed = '2038-01-01 00:00:00' WHERE CAST(last_accessed AS CHAR(20)) = '0000-00-00 00:00:00';
21ALTER TABLE `file_folder_share` CHANGE `last_accessed` `last_accessed` datetime NULL AFTER `date_created`;
22UPDATE file_folder_share SET last_accessed = NULL WHERE last_accessed = '2038-01-01 00:00:00';
23
24UPDATE plugin SET date_installed = '2038-01-01 00:00:00' WHERE CAST(date_installed AS CHAR(20)) = '0000-00-00 00:00:00';
25ALTER TABLE `plugin` CHANGE `date_installed` `date_installed` datetime NULL AFTER `is_installed`;
26UPDATE plugin SET date_installed = NULL WHERE date_installed = '2038-01-01 00:00:00';
27
28ALTER TABLE `file` DROP INDEX `keywords`;
29ALTER TABLE `file` ADD INDEX `keywords` (`keywords`);
30ALTER TABLE `stats` CHANGE `download_date` `download_date` datetime NULL AFTER `id`;
31
32ALTER TABLE `apiv2_access_token` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
33ALTER TABLE `apiv2_api_key` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
34ALTER TABLE `background_task` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
35ALTER TABLE `background_task_log` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
36ALTER TABLE `banned_files` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
37ALTER TABLE `banned_ips` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
38ALTER TABLE `country_info` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
39ALTER TABLE `cross_site_action` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
40ALTER TABLE `download_page` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
41ALTER TABLE `download_token` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
42ALTER TABLE `download_tracker` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
43ALTER TABLE `file` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
44ALTER TABLE `file_action` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
45ALTER TABLE `file_block_hash` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
46ALTER TABLE `file_folder` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
47ALTER TABLE `file_folder_share` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
48ALTER TABLE `file_report` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
49ALTER TABLE `file_server` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
50ALTER TABLE `file_server_container` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
51ALTER TABLE `file_server_status` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
52ALTER TABLE `file_status` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
53ALTER TABLE `internal_notification` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
54ALTER TABLE `language` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
55ALTER TABLE `language_content` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
56ALTER TABLE `language_key` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
57ALTER TABLE `login_failure` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
58ALTER TABLE `login_success` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
59ALTER TABLE `payment_log` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
60ALTER TABLE `payment_subscription` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
61ALTER TABLE `plugin` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
62ALTER TABLE `premium_order` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
63ALTER TABLE `remote_url_download_queue` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
64ALTER TABLE `sessions` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
65ALTER TABLE `site_config` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
66ALTER TABLE `stats` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
67ALTER TABLE `theme` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
68ALTER TABLE `users` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
69ALTER TABLE `user_level` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
70ALTER TABLE `user_level_pricing` ENGINE= InnoDB COLLATE 'utf8mb4_general_ci';
71
72ALTER TABLE `file_folder` ADD `status` enum('active','trash','deleted') COLLATE 'utf8_general_ci' NULL DEFAULT 'active' AFTER `urlHash`;
73ALTER TABLE `file` ADD `status` enum('active','trash','deleted') NULL DEFAULT 'active' AFTER `statusId`;
74UPDATE `file` SET status = 'deleted' WHERE statusId != 1;
75ALTER TABLE `file` ADD `date_updated` datetime NULL;
76
77ALTER TABLE `file` ADD INDEX `status` (`status`);
78ALTER TABLE `file_folder` ADD INDEX `status` (`status`);
79
80ALTER TABLE `user_level` ADD `max_uploads_per_day` bigint(18) NOT NULL DEFAULT '0' AFTER `max_upload_size`;
81UPDATE `user_level` SET `max_uploads_per_day` = (SELECT config_value FROM site_config WHERE config_key = 'max_files_per_day' LIMIT 1);
82DELETE FROM `site_config` WHERE config_key = 'max_files_per_day' LIMIT 1;
83
84ALTER TABLE `file` ADD INDEX `uploadedIP` (`uploadedIP`);
85
86ALTER TABLE `user_level` ADD `accepted_file_types` varchar(255) NOT NULL DEFAULT '' AFTER `max_uploads_per_day`;
87UPDATE `user_level` SET `accepted_file_types` = (SELECT config_value FROM site_config WHERE config_key = 'accepted_upload_file_types' LIMIT 1);
88DELETE FROM `site_config` WHERE config_key = 'accepted_upload_file_types' LIMIT 1;
89
90ALTER TABLE `user_level` ADD `blocked_file_types` varchar(255) NOT NULL DEFAULT '' AFTER `accepted_file_types`;
91UPDATE `user_level` SET `blocked_file_types` = (SELECT config_value FROM site_config WHERE config_key = 'blocked_upload_file_types' LIMIT 1);
92DELETE FROM `site_config` WHERE config_key = 'blocked_upload_file_types' LIMIT 1;
93
94ALTER TABLE `user_level` ADD `days_to_keep_trashed_files` int(11) NOT NULL DEFAULT '0' AFTER `days_to_keep_inactive_files`;
95
96INSERT INTO `plugin` (`id`, `plugin_name`, `folder_name`, `plugin_description`, `is_installed`, `date_installed`, `plugin_settings`, `plugin_enabled`, `load_order`) VALUES
97(NULL,	'Payment Gateways',	'payment',	'Access to over 50 payment gateways for premium account upgrades.',	1,	NULL,	'',	1,	999);
98
99DROP TABLE IF EXISTS `plugin_payment_gateways`;
100CREATE TABLE `plugin_payment_gateways` (
101  `id` int(11) NOT NULL AUTO_INCREMENT,
102  `class_name` varchar(150) COLLATE utf8_bin NOT NULL,
103  `label` varchar(150) COLLATE utf8_bin DEFAULT NULL,
104  `description` text COLLATE utf8_bin,
105  `url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
106  `gateway_type` enum('onsite','offsite') COLLATE utf8_bin NOT NULL DEFAULT 'offsite',
107  `gateway_group` varchar(100) COLLATE utf8_bin DEFAULT NULL,
108  `available` tinyint(1) NOT NULL DEFAULT '1',
109  PRIMARY KEY (`id`),
110  UNIQUE KEY `class_name` (`class_name`)
111) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
112
113INSERT INTO `plugin_payment_gateways` (`id`, `class_name`, `label`, `description`, `url`, `gateway_type`, `gateway_group`, `available`) VALUES
114(1,	'TwoCheckout',	'2Checkout',	NULL,	'https://www.2checkout.com',	'offsite',	'2Checkout',	0),
115(2,	'AuthorizeNet_AIM',	'AuthorizeNet - AIM',	NULL,	'https://www.authorize.net',	'offsite',	'AuthorizeNet',	1),
116(3,	'AuthorizeNet_CIM',	'AuthorizeNet - CIM',	NULL,	'https://www.authorize.net',	'offsite',	'AuthorizeNet',	1),
117(4,	'AuthorizeNet_SIM',	'AuthorizeNet - SIM',	NULL,	'https://www.authorize.net',	'offsite',	'AuthorizeNet',	1),
118(5,	'AuthorizeNet_DPM',	'AuthorizeNet - DPM',	NULL,	'https://www.authorize.net',	'offsite',	'AuthorizeNet',	1),
119(6,	'BitPay',	'BitPay',	NULL,	'https://bitpay.com',	'offsite',	'BitPay',	1),
120(7,	'Braintree',	'Braintree',	NULL,	'https://www.braintreepayments.com',	'offsite',	'Braintree',	1),
121(8,	'Buckaroo_CreditCard',	'Buckaroo - CreditCard',	NULL,	'https://www.buckaroo-payments.com',	'offsite',	'Buckaroo',	1),
122(9,	'Buckaroo_Ideal',	'Buckaroo - Ideal',	NULL,	'https://www.buckaroo-payments.com',	'offsite',	'Buckaroo',	1),
123(10,	'Buckaroo_PayPal',	'Buckaroo - PayPal',	NULL,	'https://www.buckaroo-payments.com',	'offsite',	'Buckaroo',	1),
124(11,	'Buckaroo_SepaDirectDebit',	'Buckaroo - SepaDirectDebit',	NULL,	'https://www.buckaroo-payments.com',	'offsite',	'Buckaroo',	1),
125(12,	'CardSave',	'CardSave',	NULL,	'https://www.cardsave.net',	'offsite',	'CardSave',	1),
126(13,	'Coinbase',	'Coinbase',	NULL,	'https://www.coinbase.com',	'offsite',	'Coinbase',	1),
127(14,	'Eway_RapidDirect',	'Eway - RapidDirect',	'This is the primary gateway used for direct card processing, i.e. where you collect the card details from the customer and pass them to eWay yourself via the API.',	'https://eway.io',	'offsite',	'Eway',	1),
128(15,	'Eway_Rapid',	'Eway - Rapid',	'This is used for eWAY Rapid Transparent Redirect requests. The gateway is just called Eway_Rapid as it was the first implemented. Like other redirect gateways the purchase() call will return a redirect response and then requires you to redirect the customer to the eWay site for the actual purchase.',	'https://eway.io',	'offsite',	'Eway',	1),
129(16,	'Eway_RapidShared',	'Eway - RapidShared',	'This provides a hosted form for entering payment information, other than that it is similar to the Eway_Rapid gateway in functionality.',	'https://eway.io',	'offsite',	'Eway',	1),
130(17,	'FirstData_Connect',	'FirstData - Connect',	NULL,	'https://www.firstdata.com/ecommerce/index.html',	'offsite',	'FirstData',	1),
131(18,	'FirstData_Webservice',	'FirstData - Webservice',	NULL,	'https://www.firstdata.com/ecommerce/index.html',	'offsite',	'FirstData',	1),
132(19,	'FirstData_Payeezy',	'FirstData - Payeezy',	NULL,	'https://www.firstdata.com/ecommerce/index.html',	'offsite',	'FirstData',	1),
133(20,	'GoCardless',	'GoCardless',	NULL,	'https://gocardless.com',	'offsite',	'GoCardless',	1),
134(21,	'Migs_TwoParty',	'Migs - TwoParty',	NULL,	'https://www.mastercard.us/en-us/about-mastercard/what-we-do/payment-processing.html',	'offsite',	'Migs',	1),
135(22,	'Migs_ThreeParty',	'Migs - ThreeParty',	NULL,	'https://www.mastercard.us/en-us/about-mastercard/what-we-do/payment-processing.html',	'offsite',	'Migs',	1),
136(23,	'Mollie',	'Mollie',	NULL,	'https://www.mollie.com',	'offsite',	'Mollie',	1),
137(24,	'MultiSafepay_Rest',	'MultiSafepay - Rest',	NULL,	'https://www.multisafepay.com',	'offsite',	'MultiSafepay',	1),
138(25,	'Netaxept',	'Netaxept',	NULL,	'https://www.nets.eu',	'offsite',	'Netaxept',	1),
139(26,	'NetBanx',	'NetBanx',	NULL,	NULL,	'offsite',	'NetBanx',	0),
140(27,	'OKPAY',	'OKPay',	NULL,	'https://www.okpay.com',	'offsite',	'OKPay',	1),
141(28,	'PayFast',	'PayFast',	NULL,	'https://www.payfast.co.za',	'offsite',	'PayFast',	1),
142(29,	'Payflow_Pro',	'Payflow - Pro',	NULL,	NULL,	'offsite',	'Payflow',	0),
143(30,	'PaymentExpress_PxPay',	'PaymentExpress - PxPay',	NULL,	'https://www.paymentexpress.co.uk',	'offsite',	'PaymentExpress',	1),
144(31,	'PaymentExpress_PxPost',	'PaymentExpress - PxPost',	NULL,	'https://www.paymentexpress.co.uk',	'offsite',	'PaymentExpress',	1),
145(32,	'PaymentExpress_PxFusion',	'PaymentExpress - PxFusion',	NULL,	'https://www.paymentexpress.co.uk',	'offsite',	'PaymentExpress',	0),
146(33,	'PayPal_Express',	'PayPal - Express',	'PayPal Express Checkout',	'https://www.paypal.com',	'offsite',	'PayPal',	1),
147(34,	'PayPal_ExpressInContext',	'PayPal - ExpressInContext',	'PayPal Express In-Context Checkout',	'https://www.paypal.com',	'offsite',	'PayPal',	1),
148(35,	'PayPal_Pro',	'PayPal - Pro',	'PayPal Website Payments Pro',	'https://www.paypal.com',	'offsite',	'PayPal',	1),
149(36,	'PayPal_Rest',	'PayPal - Rest',	'Paypal Rest API',	'https://www.paypal.com',	'offsite',	'PayPal',	1),
150(37,	'Paysafecard',	'Paysafecard',	NULL,	'https://www.paysafecard.com',	'offsite',	'Paysafecard',	1),
151(38,	'Pin',	'Pin',	NULL,	'https://pinpayments.com',	'offsite',	'Pin',	1),
152(39,	'SagePay_Direct',	'SagePay - Direct',	NULL,	'https://www.sagepay.co.uk',	'offsite',	'SagePay',	1),
153(40,	'SagePay_Server',	'SagePay - Server',	NULL,	'https://www.sagepay.co.uk',	'offsite',	'SagePay',	1),
154(41,	'SecurePay_SecureXML',	'SecurePay Secure XML',	NULL,	'https://www.securepay.com.au',	'offsite',	'SecurePay',	1),
155(42,	'Stripe',	'Stripe',	NULL,	'https://stripe.com',	'offsite',	'Stripe',	1),
156(43,	'TargetPay_Directebanking',	'TargetPay - Directebanking',	NULL,	'https://www.targetpay.com',	'offsite',	'TargetPay',	1),
157(44,	'TargetPay_Ideal',	'TargetPay - Ideal',	NULL,	'https://www.targetpay.com',	'offsite',	'TargetPay',	1),
158(45,	'TargetPay_Mrcash',	'TargetPay - Mrcash',	NULL,	'https://www.targetpay.com',	'offsite',	'TargetPay',	1),
159(46,	'WebMoney',	'WebMoney',	NULL,	'https://www.wmtransfer.com',	'offsite',	'WebMoney',	1),
160(47,	'WorldPay',	'WorldPay',	NULL,	'https://www.worldpay.com',	'offsite',	'WorldPay',	1),
161(48,	'WorldPay_Json',	'WorldPay - Json',	NULL,	'https://www.worldpay.com',	'offsite',	'WorldPay',	1),
162(49,	'Sofort',	'Sofort',	NULL,	'https://www.klarna.com/sofort',	'offsite',	'Sofort',	1),
163(50,	'Paysera',	'Paysera',	NULL,	'https://www.paysera.com',	'offsite',	'Paysera',	1),
164(51,	'EgopayRu',	'EgopayRu',	NULL,	'http://www.ego-pay.com',	'offsite',	'EgopayRu',	0),
165(52,	'CoinPayments',	'Coinpayments',	NULL,	'https://www.coinpayments.net',	'offsite',	'Coinpayments',	1);
166
167DROP TABLE IF EXISTS `plugin_payment_gateways_configured`;
168CREATE TABLE `plugin_payment_gateways_configured` (
169  `id` int(11) NOT NULL AUTO_INCREMENT,
170  `gateway_id` int(11) NOT NULL,
171  `params` text COLLATE utf8_bin,
172  `status` enum('active','disabled') COLLATE utf8_bin NOT NULL DEFAULT 'active',
173  `date_created` datetime DEFAULT NULL,
174  `date_updated` datetime DEFAULT NULL,
175  PRIMARY KEY (`id`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;