83 lines
2.7 KiB
SQL
83 lines
2.7 KiB
SQL
# Discounts
|
|
ALTER TABLE `ip_quotes`
|
|
ADD COLUMN `quote_discount_amount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `quote_number`,
|
|
ADD COLUMN `quote_discount_percent` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `quote_discount_amount`;
|
|
|
|
ALTER TABLE `ip_quote_item_amounts`
|
|
ADD COLUMN `item_discount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `item_tax_total`;
|
|
ALTER TABLE `ip_quote_items`
|
|
ADD COLUMN `item_discount_amount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `item_price`;
|
|
|
|
ALTER TABLE `ip_invoices`
|
|
ADD COLUMN `invoice_discount_amount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `invoice_number`,
|
|
ADD COLUMN `invoice_discount_percent` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `invoice_discount_amount`;
|
|
|
|
ALTER TABLE `ip_invoice_item_amounts`
|
|
ADD COLUMN `item_discount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `item_tax_total`;
|
|
ALTER TABLE `ip_invoice_items`
|
|
ADD COLUMN `item_discount_amount` DECIMAL(20, 2) NOT NULL DEFAULT 0
|
|
AFTER `item_price`;
|
|
|
|
# Feature IP-162
|
|
# For module "projects"
|
|
CREATE TABLE `ip_projects` (
|
|
`project_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`client_id` INT(11) NOT NULL,
|
|
`project_name` VARCHAR(150) NOT NULL,
|
|
PRIMARY KEY (`project_id`)
|
|
)
|
|
ENGINE = MyISAM
|
|
DEFAULT CHARSET = utf8;
|
|
|
|
# For module "tasks"
|
|
CREATE TABLE `ip_tasks` (
|
|
`task_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`project_id` INT(11) NOT NULL,
|
|
`task_name` VARCHAR(50) NOT NULL,
|
|
`task_description` LONGTEXT NOT NULL,
|
|
`task_price` FLOAT(10, 2) NOT NULL,
|
|
`task_finish_date` DATE NOT NULL,
|
|
`task_status` TINYINT(1) NOT NULL,
|
|
PRIMARY KEY (`task_id`)
|
|
)
|
|
ENGINE = MyISAM
|
|
DEFAULT CHARSET = utf8;
|
|
|
|
# For module "upload" IP-211
|
|
CREATE TABLE `ip_uploads` (
|
|
`upload_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`client_id` INT(11) NOT NULL,
|
|
`url_key` CHAR(32) NOT NULL,
|
|
`file_name_original` LONGTEXT NOT NULL,
|
|
`file_name_new` LONGTEXT NOT NULL,
|
|
`uploaded_date` DATE NOT NULL,
|
|
PRIMARY KEY (`upload_id`)
|
|
)
|
|
ENGINE = MyISAM
|
|
DEFAULT CHARSET = utf8;
|
|
|
|
# Attach pdf on emails setting
|
|
INSERT INTO `ip_settings` (`setting_key`, `setting_value`)
|
|
VALUES ('email_pdf_attachment', '1');
|
|
|
|
# IP-283 - Allow larger item amounts
|
|
ALTER TABLE ip_invoice_item_amounts
|
|
MODIFY COLUMN item_subtotal DECIMAL(20, 2);
|
|
ALTER TABLE ip_invoice_item_amounts
|
|
MODIFY COLUMN item_tax_total DECIMAL(20, 2);
|
|
ALTER TABLE ip_invoice_item_amounts
|
|
MODIFY COLUMN item_total DECIMAL(20, 2);
|
|
ALTER TABLE ip_quote_item_amounts
|
|
MODIFY COLUMN item_subtotal DECIMAL(20, 2);
|
|
ALTER TABLE ip_quote_item_amounts
|
|
MODIFY COLUMN item_tax_total DECIMAL(20, 2);
|
|
ALTER TABLE ip_quote_item_amounts
|
|
MODIFY COLUMN item_total DECIMAL(20, 2);
|