This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
fast:fast-invoice [2013/10/18 20:35] admin [Data Migration] |
fast:fast-invoice [2014/02/01 06:45] admin |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Fast Invoice Documentation ====== | ====== Fast Invoice Documentation ====== | ||
+ | |||
+ | [[ :User Area Expansion]] | ||
**User Area:** | **User Area:** | ||
- | * Invoice List | + | - Invoice List |
- | * User Area | + | - User Area |
- | * View My Profile | + | - View My Profile |
- | * Change Password | + | - Fast Pay Area (page where invoice can be paid without log in, secure key required) |
- | * 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. |
- | * Once invoice paid key becomes invalid or if time set expires. | + | |
**Admin Area:** | **Admin Area:** | ||
Line 36: | Line 37: | ||
RENAME TABLE `users` TO `site_users`; | RENAME TABLE `users` TO `site_users`; | ||
+ | | ||
+ | FIX PHONE #s | ||
+ | UPDATE users SET phone = replace(replace(replace(replace(`phone`,' ',''),'(',''),')',''),'-','') WHERE phone RLIKE '^[+]?[-() 0-9]+$'; | ||
+ | | ||
ALTER TABLE `site_users` CHANGE `password` `user_password` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; | 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` CHANGE `email` `user_email` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; |