aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql
diff options
context:
space:
mode:
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`
--