Differences

This shows you the differences between two versions of the page.

--- fast:fast-invoice [2013/10/09 12:14]
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;
-  UPDATE  `invoices` SET  `status` =1 WHERE  `status_OLD` =  'Paid';
-  ALTER TABLE `invoices` DROP `status_OLD`;
-  * table users
-  RENAME TABLE  `donias2_iasdb`.`users` TO  `donias2_iasdb`.`site_users`;
-  ALTER TABLE  `site_users` CHANGE  `password`  `user_password` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
-  ALTER TABLE  `site_users` CHANGE  `email`  `user_email` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
-  ALTER TABLE `site_users` DROP `currency`;
-  ALTER TABLE  `site_users` CHANGE  `userlevel`  `group_id` TINYINT( 1 ) NOT NULL DEFAULT  '1';
-  UPDATE  `site_users` SET  `group_id` = 20 WHERE group_id = 1;
-  UPDATE  `site_users` SET  `group_id` =1 WHERE group_id =9;
-  **created RENAME TO user_regdate**
-  ALTER TABLE  `site_users` CHANGE  `notes`  `note` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
-  ALTER TABLE  `site_users` CHANGE  `lastlogin`  `user_lastvisit` DATETIME NULL DEFAULT  '0000-00-00 00:00:00';
-  ALTER TABLE `site_users` DROP `active`;
-  ALTER TABLE  `site_users` CHANGE  `lastip`  `last_ip` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT  '0';

wiki

User Tools

Site Tools

Differences

Page Tools