diff options
| author | plegall <plg@piwigo.org> | 2016-05-31 16:00:03 +0200 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2016-05-31 16:00:03 +0200 |
| commit | 4560e2d824a99514ea6a2ca2a89c8d0453923fbc (patch) | |
| tree | 015ab79fabaf7db91d8c13a2bf7cf576dccfbf99 /install/piwigo_structure-mysql.sql | |
| parent | bd0d2ae6459c63ed7f7060589297bf63ae1cc619 (diff) | |
fixes #478, add new column user_infos.last_visit
This will speed up user edit popin opening, by avoiding to search in history for the last user visit.
The column user_infos.last_visit_from_history true/false says if the last_visit has already been search in history (to avoid making it twice). I could have implemented the search of last_visit for all users in the migration task 149 but in case of many users and long history, it would have taken years to execute...
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
| -rw-r--r-- | install/piwigo_structure-mysql.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql index 1c7853edc..e1c076320 100644 --- a/install/piwigo_structure-mysql.sql +++ b/install/piwigo_structure-mysql.sql @@ -460,6 +460,8 @@ CREATE TABLE `piwigo_user_infos` ( `level` tinyint unsigned NOT NULL default '0', `activation_key` varchar(255) default NULL, `activation_key_expire` datetime default NULL, + `last_visit` datetime default NULL, + `last_visit_from_history` enum('true','false') NOT NULL default 'false' `lastmodified` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`), KEY `lastmodified` (`lastmodified`) |