Hi All,
With reference to Peter's change below (there have been a string of
other db updates listed in the upgrade.sql.in file...),
I have implemented a new class purely intended for the Development phase
of the project. It is called Developer.class.php
and it will check for a list of database modifications that are required
to make the dev branch run smoothly.
It is intended as a prompt that a change is required rather than
providing a means for an automatic correction/update of a database.
I think the actual update to the db should still be done manually as we
don't want to be inadvertently break other developers databases!
If you do an svn update and you have NOT implemented the SQL change
listed below you will come across an error message that explains
a change needs to be made.
Cheers
Mark
_____________________________________________
Mob: 07725 695178
Email: ma...@rw...
On 09/10/2011 01:46, Peter Lazarus wrote:
> 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
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2dcopy2
> _______________________________________________
> Tsheetx-developers mailing list
> Tsh...@li...
> https://lists.sourceforge.net/lists/listinfo/tsheetx-developers
>
|
