Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_invoices/sql/updates/2.1.0.sql
Назад
CREATE TABLE IF NOT EXISTS `#__invoices_tax_invoice` ( `id` int(11) NOT NULL AUTO_INCREMENT, `reference_id` int(11) NOT NULL, `tax_id` int(11) NOT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `value` decimal(10,2) NOT NULL, `active` tinyint(1) NOT NULL, `computed_value` decimal(12,4) NOT NULL, PRIMARY KEY (`id`), KEY `reference_id` (`reference_id`), KEY `tax_id` (`tax_id`) ) ENGINE=MyISAM ; ALTER TABLE `#__invoices_items` ADD `tax_id` INT(11) NOT NULL AFTER `tax`; ALTER TABLE `#__invoices_items` ADD INDEX(`tax_id`); ALTER TABLE `#__invoices_taxes` ADD `calculate_on` TINYINT(1) NOT NULL ; ALTER TABLE `#__invoices_invoices` ADD `computed_subtotal` DECIMAL(12,4) NOT NULL AFTER `computed_total`, ADD `computed` TEXT NOT NULL AFTER `computed_subtotal`; ALTER TABLE `#__invoices_payments` ADD INDEX(`invoice_id`); ALTER TABLE `#__invoices_invoices` ADD INDEX( `created_by`); ALTER TABLE `#__invoices_invoices` ADD INDEX( `user_id`); ALTER TABLE `#__invoices_invoices` ADD INDEX( `template_id`); ALTER TABLE `#__invoices_invoices` ADD INDEX( `type`);
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка