This is an old revision of the document!
User Area:
Admin Area:
ALTER TABLE `invoices` CHANGE `created` `inv_date` DATE NOT NULL; ALTER TABLE `invoices` CHANGE `method` `pay_method` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; ALTER TABLE `invoices` ADD `taxrate` DECIMAL( 6, 4 ) NOT NULL AFTER `pay_method`; ALTER TABLE `invoices` CHANGE `tax` `taxtotal` DECIMAL( 8, 2 ) NOT NULL DEFAULT '0.00'; ALTER TABLE `invoices` CHANGE `status` `status_OLD` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; ALTER TABLE `invoices` ADD `status` TINYINT( 2 ) NOT NULL, ADD `notes` TEXT NOT NULL; UPDATE `invoices` SET `status` =1 WHERE `status_OLD` = 'Paid'; ALTER TABLE `invoices` DROP `status_OLD`;