Changed collation to utf8mb4_bin to support 4-byte UTF-8 characters.
[timetracker.git] / mysql.sql
2018-11-16 Nik OkuntseffChanged collation to utf8mb4_bin to support 4-byte...
2018-11-16 Nik OkuntseffFixed mysql.sql for new installs - one table was not...
2018-11-15 Nik OkuntseffSwitching from utf8 to utf8mb4 character set for full...
2018-11-08 Nik OkuntseffA bit more progress with introducing org_id in tables.
2018-11-07 Nik OkuntseffAdded org_id to a couple more tables.
2018-11-07 Nik OkuntseffIntroduced org_id field in tt_projects and tt_tasks...
2018-11-07 Nik OkuntseffIntroduced org_id field in tt_clients table.
2018-11-05 Nik OkuntseffIntroduced org_id in tt_roles table for better security...
2018-11-02 Nik OkuntseffMore work in progress on subgroups.
2018-11-02 Nik OkuntseffFixing org_id for existing groups.
2018-11-01 Nik OkuntseffAdded an index on tt_custom_field_log for faster report...
2018-10-28 Nik OkuntseffAdded 2 additional group by fields in database as part...
2018-07-29 Nik OkuntseffAdded indexes on group_id to speed up searches by group_id.
2018-07-28 Nik OkuntseffAdded group_id field to tt_log and tt_expense_items...
2018-07-22 Nik OkuntseffIntroduced show_work_units field in tt_fav_reports...
2018-04-11 Nik OkuntseffIntroduced delete_group right.
2018-04-10 Nik OkuntseffIntroduced password_complexity field in tt_groups table.
2018-04-09 Nik OkuntseffA bit of cleanup.
2018-04-02 Nik OkuntseffMoved managed_basic_settings to co-manager role.
2018-03-31 Nik OkuntseffIntroduced view_own_clients right and its handling.
2018-03-31 Nik OkuntseffIntroduced view_own_tasks right and its handling.
2018-03-30 Nik OkuntseffIntroduced IP based access control for groups.
2018-03-30 Nik OkuntseffIntroduced view_all_reports right and added it to co...
2018-03-29 Nik OkuntseffRefactoring. Renamed team_id fields to become group_id.
2018-03-29 Nik OkuntseffRefactoring. Renamed tt_teams table to tt_groups.
2018-03-27 Nik OkuntseffRenamed view_projects right to view_own_projects.
2018-03-27 Nik OkuntseffIntroduced view_projects right.
2018-03-27 Nik OkuntseffIntroduced manage_own_account right.
2018-03-27 Nik OkuntseffIntroduced parent_id and org_id fields in tt_teams.
2018-03-24 Nik OkuntseffSome refactoring of access checks - in progress.
2018-03-23 Nik OkuntseffReplaced timestamp column with datetime type in tt_tmp...
2018-03-23 Nik OkuntseffDropping timestamp columns from tt_teams and tt_users.
2018-03-21 Nik OkuntseffUpdated db version.
2018-03-21 Nik OkuntseffIntroduced audit fields in tt_teams table.
2018-03-19 Nik OkuntseffAdded swap roles feature.
2018-03-19 Nik OkuntseffRemoved old timestamp field from tt_log.
2018-03-19 Nik OkuntseffIntroduced show_ip field in tt_fav_reports.
2018-03-19 Nik OkuntseffIntoduced audit fields for expenses.
2018-03-18 Nik OkuntseffAdded audit fields to tt_log table.
2018-03-18 Nik OkuntseffRenamed a field in database.
2018-03-18 Nik OkuntseffIntroduced audit fields for users.
2018-03-17 Nik OkuntseffIntroduced override_own_date_lock right.
2018-03-16 Nik OkuntseffDropped legacy role field.
2018-03-16 Nik OkuntseffIntroduced override_own_punch_mode right.
2018-03-14 Nik OkuntseffAdded override_date_lock right to supervisors.
2018-03-13 Nik OkuntseffSplit data_entry right into track_time and track_expenses.
2018-03-12 Nik OkuntseffImproved dbinstall.php to avoid potential corruption...
2018-03-12 Nik OkuntseffExtended right set for more flexibility.
2018-03-10 Nik OkuntseffFixed dbinstall.php. Resumed work on roles.
2018-03-01 Nik OkuntseffA bit more work in progress on roles.
2018-02-28 Nik OkuntseffIntroduced site admin and top manager roles in tt_roles...
2018-02-28 Nik OkuntseffA fix for default values for datetimes for older MySQL...
2018-02-27 Nik OkuntseffIntroduced role_id for users, also tt_site_config table...
2018-02-22 Nik OkuntseffAdded description field to tt_roles.
2018-02-21 Nik OkuntseffImplemented export and import of roles and improved...
2018-02-21 Nik OkuntseffWork in progress on new roles.
2018-02-20 Nik OkuntseffCleanup of mysql.sql for timestamp defaults.
2018-02-19 Nik OkuntseffFixed a timestamp problem related to WampServer.
2018-02-14 Nik OkuntseffFixed import and export for latest changes.
2018-02-12 Nik OkuntseffFixed rounding errors in monthly quotas.
2018-02-11 Nik OkuntseffMade show_holidays configurable as per issue #53.
2018-01-29 Nik OkuntseffFixed monthly quotas for non-integer workday hours.
2018-01-27 Nik OkuntseffA fix for issue #47.
2018-01-22 Nik OkuntseffAdded paid field and handling to expenses.
2018-01-21 Nik OkuntseffModified database schema to include paid status on...
2018-01-19 Nik OkuntseffDropped no longer used address field from the database.
2018-01-18 Nik OkuntseffWork in progress integrating changes from PR #48 -...
2017-09-09 anukoAdded cc option for notifications.
2017-09-09 anukoAdded Bcc option for team managers.
2017-07-29 anukoIntroduced status field in tt_fav_reports table to...
2017-07-25 anukoInitial implementation of a condition on notifications.
2017-07-09 anukoWork in progress on mking project selection for some...
2017-05-07 anukoChanged the default value of task_required field to...
2017-05-06 anukoWork in progress on task required option.
2017-05-06 anukoWork in progress on tracking mode options.
2017-02-12 anukoWork in progress on predefined expenses.
2017-02-11 anukoChanged data type for tt_log comment to TEXT because...
2016-10-23 anukoFinished renaming variables after PR#24 merge.
2016-10-23 anukoVersion change for PR#24, work in progress renaming...
2016-10-23 Andréas LundgrenAdd option to profile_edit.php to show/hide users uncom...
2016-10-16 anukoVersion change for PR#23, fixed dbinstall.php for it...
2016-10-16 Kim KeownExpense Item description - Follow-up to pull request...
2016-07-22 Nik OkuntseffRefactoring - some renaming to keep things consistent.
2016-07-18 Nik OkuntseffRefactoring: renamed a field for clarity.
2016-07-18 Nik OkuntseffMerge branch 'taskChanges' of https://github.com/aviden...
2016-07-18 Nik OkuntseffMerge branch 'avidenic-master'
2016-07-18 Nik OkuntseffMerge branch 'master' of https://github.com/avidenic...
2016-07-04 Anže VideničMerge remote-tracking branch 'upstream/master'
2016-07-04 Anže Videničupdated according to comments from anuko
2016-05-24 Anže VideničMerges an updated upstream from main.
2016-05-23 Anže VideničAdded plugin where users monthly quota can be set and...
2016-04-02 Nik OkuntseffRemoving legacy lock interval in days - replaced by...
2016-04-01 Nik OkuntseffExtended the Locking plugin with cron specification...
2016-03-20 Nik OkuntseffCleaning up whitespace
2016-02-29 Nik OkuntseffWork in progress creating a repo