[Tsheetx-developers] Revision 439 to txsheet-2.0-demo to rename a field in times table

[Peter L. <pal...@gm...>]

Revision 439 to txsheet-2.0-demo renames the 'uid' field in the times 
table to 'username'. This change has been made to make the field name 
consistent with its contents, and consistent with the user table. 
Username is the string meaning the user's login name e.g. 'peter', 
whereas the uid is the user's number or key in the user table e.g. 3. If 
you look at the contents of uid in the times table, you will find it has 
usernames instead of numbers.

You can use this sql statement to rename the field in your existing 
database:
ALTER TABLE __TABLE_PREFIX__times CHANGE `uid` `username` varchar(32) 
DEFAULT '' NOT NULL

File timesheet.sql.in now contains the username field instead of uid.

Peter