riainvoice/application/modules/setup/sql/007_1.2.1.sql
gandhimathi Bharathirajan c940cb1a2c all files
2017-09-11 14:38:03 +05:30

16 lines
462 B
SQL

# Insert default value for read_only_toggle in ip_settings
INSERT INTO `ip_settings` (`setting_key`, `setting_value`)
VALUES ('read_only_toggle', 'paid');
# Update the period settings
UPDATE `ip_settings`
SET `setting_value` = "this-month"
WHERE `setting_value` = "month";
UPDATE `ip_settings`
SET `setting_value` = "this-year"
WHERE `setting_value` = "year";
# Solves IP-198
ALTER TABLE ip_tax_rates
CHANGE tax_rate_name tax_rate_name VARCHAR(60) NOT NULL;