Simplify Time Log Template Structure

chri55w / QuickBooks-Timer

Savantech QuickBooks Timer - Issue Tracking / Wiki ONLY

3 stars 0 forks source link

Simplify Time Log Template Structure #86

Closed chri55w closed 8 years ago

chri55w commented 8 years ago

Remove the 'EMPLOYEE_TIME_LOG_TEMPLATE' table and allow users to essentially create and delete their own templates without trying to optimize the number of templates through 'sharing'.

This involves adding new columns 'EMPLOYEE_REFNUM', 'NAME' and 'LAST_USED' to the TIME_LOG_TEMPLATE table and removing the EMPLOYEE_TIME_LOG_TEMPLATE table completely.

To preserve data a script should be created prior to the tables removal to create the Time Log templates for each user.

chri55w commented 8 years ago

Tables have been modifier on Development database and scripts have been stored for deployment on Live database

Simplify Time Log Template Structure.zip