This shows you the differences between two versions of the page.
fast:fast-invoice [2013/10/09 11:20] admin [Data Migration] |
fast:fast-invoice [2017/03/10 23:00] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Fast Invoice Documentation ====== | ||
- | **User Area:** | ||
- | |||
- | * Invoice List | ||
- | * User Area | ||
- | * View My Profile | ||
- | * Change Password | ||
- | * Fast Pay Area (page where invoice can be paid without log in, secure key required) | ||
- | * Once invoice paid key becomes invalid or if time set expires. | ||
- | |||
- | **Admin Area:** | ||
- | |||
- | * Invoice List | ||
- | * Manage Clients | ||
- | * Manage Users | ||
- | * User Area | ||
- | * View My Profile | ||
- | * Change Password | ||
- | |||
- | ===== Data Migration ===== | ||
- | |||
- | * table invoices | ||
- | |||
- | 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; |