diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/piwigo_structure-mysql.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql index 24c386abf..0c50701c0 100644 --- a/install/piwigo_structure-mysql.sql +++ b/install/piwigo_structure-mysql.sql @@ -132,6 +132,7 @@ CREATE TABLE `piwigo_history` ( `summarized` enum('true','false') default 'false', `image_type` enum('picture','high','other') default NULL, `format_id` int(11) unsigned default NULL, + `auth_key_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `history_i1` (`summarized`) ) ENGINE=MyISAM; @@ -366,6 +367,20 @@ CREATE TABLE `piwigo_user_access` ( ) ENGINE=MyISAM; -- +-- Table structure for table `piwigo_user_auth_keys` +-- + +CREATE TABLE `piwigo_user_auth_keys` ( + `auth_key_id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `auth_key` varchar(255) NOT NULL, + `user_id` mediumint(8) unsigned NOT NULL, + `created_on` datetime NOT NULL, + `duration` int(11) unsigned DEFAULT NULL, + `expired_on` datetime NOT NULL, + PRIMARY KEY (`auth_key_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `piwigo_user_cache` -- |