aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2016-01-18 14:02:40 +0100
committerplegall <plg@piwigo.org>2016-01-18 14:02:40 +0100
commit491464355911334ecbf49b742545286e82961112 (patch)
tree9734d0c4f836fd4c497689ee018a4bd8ec4d93b4 /install/piwigo_structure-mysql.sql
parent4bf51fc8e0ce6facc2a2b8037b3dd1f444121c17 (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.sql15
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`
--