diff options
| author | plegall <plg@piwigo.org> | 2016-01-18 14:02:40 +0100 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2016-01-18 14:02:40 +0100 |
| commit | 491464355911334ecbf49b742545286e82961112 (patch) | |
| tree | 9734d0c4f836fd4c497689ee018a4bd8ec4d93b4 /install/piwigo_structure-mysql.sql | |
| parent | 4bf51fc8e0ce6facc2a2b8037b3dd1f444121c17 (diff) | |
bug #404 fixed, database changes for auth keys
... applied during install: table user_auth_keys and column history.auth_key_id
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
| -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` -- |