Directory:~$ /home/lmsyaran/www/administrator/components/com_invoices/sql/updates/

Upload File

[Home] [System Details] [Kill Me]

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`);