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

• 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  `users` TO  `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';

yum install libXrender
yum install fontconfig
yum install libXext