#acupoftea - frochicken.com

System	:	Linux ts5.whitelabelverse.com 5.14.0-570.23.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jun 24 11:27:16 EDT 2025 x86_64
Software	:	LiteSpeed
Server	:	103.163.247.115
Domains	:	Cant read /etc/named.conf
Permission	:	[ drwxr-xr-x ]
	:	/ home / ezzecare / x.logiq.digital / resources / sql /

216.73.216.80

Home

File upgrade790alpha1.sql

-- Add new configuration value for AutoNumberingResetMonth
set @query = if ((select count(*) from `tblconfiguration` where `setting` = 'AutoNumberingResetMonth') = 0, "INSERT INTO `tblconfiguration` (`setting`, `value`, `created_at`, `updated_at`) VALUES ('AutoNumberingResetMonth', CONCAT_WS('-', YEAR(CURRENT_DATE()), MONTH(CURRENT_DATE())), now(), now());",'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new configuration value for AutoPaidNumberingResetMonth
set @query = if ((select count(*) from `tblconfiguration` where `setting` = 'AutoPaidNumberingResetMonth') = 0, "INSERT INTO `tblconfiguration` (`setting`, `value`, `created_at`, `updated_at`) VALUES ('AutoPaidNumberingResetMonth', CONCAT_WS('-', YEAR(CURRENT_DATE()), MONTH(CURRENT_DATE())), now(), now());",'DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new payment gateway product mapping table
CREATE TABLE IF NOT EXISTS `tblpaymentgateways_product_mapping` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gateway` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `account_identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `product_identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `remote_identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Add new field to tblinvoices for date_refunded
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblinvoices' and column_name='date_refunded') = 0, 'alter table `tblinvoices` add `date_refunded` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\' AFTER `last_capture_attempt`', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new field to tblinvoices for date_cancelled
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblinvoices' and column_name='date_cancelled') = 0, 'alter table `tblinvoices` add `date_cancelled` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\' AFTER `date_refunded`', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new field to tblinvoices for created_at
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblinvoices' and column_name='created_at') = 0, 'alter table `tblinvoices` add `created_at` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\' AFTER `notes`', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- Add new field to tblinvoices for updated_at
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblinvoices' and column_name='updated_at') = 0, 'alter table `tblinvoices` add `updated_at` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\' AFTER `created_at`', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

-- update type of gateways to BankAccount
UPDATE `tblpaymentgateways` SET `value` = 'Bank' WHERE `setting` = 'type' AND `gateway` IN ('authorizeecheck', 'bluepayecheck', 'directdebit');

-- Update pricing enum type to include usage billing values
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblpricing' and column_name='type' and column_type='enum("product","addon","configoptions","domainregister","domaintransfer","domainrenew","domainaddons")') = 0, 'ALTER TABLE `tblpricing` CHANGE `type` `type` enum("product","addon","configoptions","domainregister","domaintransfer","domainrenew","domainaddons","usage") CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL','DO 0;');
prepare statement from @query;
execute statement;
deallocate prepare statement;

CREATE TABLE IF NOT EXISTS `tblpricing_bracket` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `floor` decimal(19,6) NOT NULL DEFAULT '0.000000',
  `ceiling` decimal(19,6) NOT NULL DEFAULT '0.000000',
  `rel_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rel_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `schema_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'flat',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tbltenant_stats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` int(11) NOT NULL DEFAULT '0',
  `metric` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` decimal(19,6) NOT NULL DEFAULT '0.000000',
  `measured_at` decimal(18,6) NOT NULL DEFAULT '0.000000',
  `invoice_id` int(11) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tblserver_tenants` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `server_id` int(11) NOT NULL DEFAULT '0',
  `tenant` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `server_tenant` (`tenant`,`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `tblusage_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rel_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rel_id` int(11) NOT NULL DEFAULT '0',
  `module_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `module` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `metric` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `included` decimal(19,6) NOT NULL DEFAULT '0.000000',
  `is_hidden` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tblusage_items_rel_type_id` (`rel_type`,`rel_id`),
  KEY `tblusage_items_module_type` (`module_type`),
  KEY `tblusage_items_module` (`module`),
  KEY `tblusage_items_metric` (`metric`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2021-07-09 06:28:42
..	DIR	-	drwxr-xr-x	2021-07-09 06:28:42
install	DIR	-	drwxr-xr-x	2021-07-09 06:28:42
index.php	text/x-php	4.69 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade321.sql	text/plain	100 B	-rw-r--r--	2021-07-09 06:28:42
upgrade330.sql	text/plain	2.79 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade340.sql	text/plain	5.65 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade341.sql	text/plain	1.17 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade350.sql	text/plain	2.08 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade360.sql	text/plain	5.36 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade361.sql	text/plain	1.03 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade362.sql	text/plain	14.13 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade370.sql	text/plain	4.12 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade380.sql	text/plain	4.59 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade400.sql	text/plain	5.75 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade410.sql	text/html	3.93 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade420.sql	text/plain	2.59 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade421.sql	text/plain	347 B	-rw-r--r--	2021-07-09 06:28:42
upgrade430.sql	text/plain	6.84 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade431.sql	text/plain	103 B	-rw-r--r--	2021-07-09 06:28:42
upgrade440.sql	text/plain	1.06 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade442.sql	text/plain	84 B	-rw-r--r--	2021-07-09 06:28:42
upgrade450.sql	text/plain	2.42 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade452.sql	text/plain	228 B	-rw-r--r--	2021-07-09 06:28:42
upgrade500.sql	text/html	4.53 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade501.sql	text/plain	1.04 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade502.sql	text/plain	200 B	-rw-r--r--	2021-07-09 06:28:42
upgrade503.sql	text/plain	145 B	-rw-r--r--	2021-07-09 06:28:42
upgrade510.sql	text/plain	7.25 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade512.sql	text/plain	112 B	-rw-r--r--	2021-07-09 06:28:42
upgrade520.sql	text/html	4.15 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade521.sql	text/plain	439 B	-rw-r--r--	2021-07-09 06:28:42
upgrade524.sql	text/html	556 B	-rw-r--r--	2021-07-09 06:28:42
upgrade530.sql	text/plain	6.18 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade533release1.sql	text/plain	756 B	-rw-r--r--	2021-07-09 06:28:42
upgrade538release1.sql	text/plain	147 B	-rw-r--r--	2021-07-09 06:28:42
upgrade539release1.sql	text/plain	181 B	-rw-r--r--	2021-07-09 06:28:42
upgrade600alpha1.sql	text/plain	11.13 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade601release1.sql	text/plain	295 B	-rw-r--r--	2021-07-09 06:28:42
upgrade610alpha1.sql	text/plain	2.37 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade620alpha1.sql	text/plain	11 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade622release1.sql	text/plain	82 B	-rw-r--r--	2021-07-09 06:28:42
upgrade630alpha1.sql	text/plain	4.95 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade630rc1.sql	text/plain	1.17 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade700alpha1.sql	text/plain	1.34 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade700alpha5.sql	text/plain	672 B	-rw-r--r--	2021-07-09 06:28:42
upgrade700beta2.sql	text/plain	420 B	-rw-r--r--	2021-07-09 06:28:42
upgrade700rc1.sql	text/plain	61 B	-rw-r--r--	2021-07-09 06:28:42
upgrade7100alpha1.sql	text/plain	1.41 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade7101release1.sql	text/plain	486 B	-rw-r--r--	2021-07-09 06:28:42
upgrade710alpha1.sql	text/plain	6.21 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade710beta1.sql	text/plain	8.23 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade710rc1.sql	text/plain	423 B	-rw-r--r--	2021-07-09 06:28:42
upgrade720alpha1.sql	text/plain	7.49 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade720beta3.sql	text/plain	755 B	-rw-r--r--	2021-07-09 06:28:42
upgrade720release1.sql	text/plain	3.02 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade723release1.sql	text/plain	585 B	-rw-r--r--	2021-07-09 06:28:42
upgrade730alpha1.sql	text/plain	1.62 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade730rc1.sql	text/plain	147 B	-rw-r--r--	2021-07-09 06:28:42
upgrade740alpha1.sql	text/plain	855 B	-rw-r--r--	2021-07-09 06:28:42
upgrade740beta1.sql	text/plain	1.49 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade740release1.sql	text/plain	123 B	-rw-r--r--	2021-07-09 06:28:42
upgrade750alpha1.sql	text/plain	6.68 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade750rc1.sql	text/plain	808 B	-rw-r--r--	2021-07-09 06:28:42
upgrade750release1.sql	text/plain	666 B	-rw-r--r--	2021-07-09 06:28:42
upgrade751release1.sql	text/plain	380 B	-rw-r--r--	2021-07-09 06:28:42
upgrade760alpha1.sql	text/plain	1.64 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade760release1.sql	text/plain	213 B	-rw-r--r--	2021-07-09 06:28:42
upgrade761release1.sql	text/plain	306 B	-rw-r--r--	2021-07-09 06:28:42
upgrade770alpha1.sql	text/plain	4.79 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade771release1.sql	text/plain	424 B	-rw-r--r--	2021-07-09 06:28:42
upgrade780alpha1.sql	text/plain	7.15 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade780rc1.sql	text/plain	796 B	-rw-r--r--	2021-07-09 06:28:42
upgrade780release1.sql	text/plain	432 B	-rw-r--r--	2021-07-09 06:28:42
upgrade783release1.sql	text/plain	276 B	-rw-r--r--	2021-07-09 06:28:42
upgrade790alpha1.sql	text/plain	6.57 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade792release1.sql	text/plain	442 B	-rw-r--r--	2021-07-09 06:28:42
upgrade800alpha1.sql	text/plain	13.37 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade800rc1.sql	text/plain	340 B	-rw-r--r--	2021-07-09 06:28:42
upgrade800rc2.sql	text/plain	1.14 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade800rc3.sql	text/plain	203 B	-rw-r--r--	2021-07-09 06:28:42
upgrade810alpha1.sql	text/plain	409 B	-rw-r--r--	2021-07-09 06:28:42
upgrade810rc1.sql	text/plain	1.15 KB	-rw-r--r--	2021-07-09 06:28:42
upgrade810release1.sql	text/plain	191 B	-rw-r--r--	2021-07-09 06:28:42
upgrade820alpha1.sql	text/plain	3.43 KB	-rw-r--r--	2021-07-09 06:28:42

~ ACUPOFTEA - frochicken.com