Changeset 11992 for trunk/install

Timestamp:

Aug 24, 2011, 10:03:53 PM (13 years ago)

Author:

plg

Message:

feature 2027 implemented: the "lost password" feature was rewritten.

The algorithm is highly inspired from WordPress :

1) in a single field, you give a username or an email
2) Piwigo sends an email with the activation key
3) the user clicks on the link in the email (with the activation key) and is able to set a new password

The "lost password" feature is no longer limited to "classic" users:
administrators and webmasters can use it too (no need to tell webmasters
that they can only change their password in the database)

Location:

trunk/install

Files:

• db/111-database.php (added)
• piwigo_structure-mysql.sql (modified) (1 diff)
• piwigo_structure-pdo-sqlite.sql (modified) (1 diff)
• piwigo_structure-pgsql.sql (modified) (1 diff)
• piwigo_structure-sqlite.sql (modified) (1 diff)

trunk/install/piwigo_structure-mysql.sql

@@ -418 +418 @@
   `enabled_high` enum('true','false') NOT NULL default 'true',
   `level` tinyint unsigned NOT NULL default '0',
+  `activation_key` char(20) default NULL,
   UNIQUE KEY `user_infos_ui1` (`user_id`)
 ) ENGINE=MyISAM;

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -481 +481 @@
   "enabled_high" BOOLEAN default true,
   "level" INTEGER default 0 NOT NULL,
+  "activation_key" CHAR(20) default NULL,
   PRIMARY KEY ("user_id"),
   CONSTRAINT "user_infos_ui1" UNIQUE ("user_id")

trunk/install/piwigo_structure-pgsql.sql

@@ -582 +582 @@
   "enabled_high" BOOLEAN default true,
   "level" INTEGER default 0 NOT NULL,
+  "activation_key" CHAR(20) default NULL,
   PRIMARY KEY ("user_id"),
   CONSTRAINT "user_infos_ui1" UNIQUE ("user_id")

trunk/install/piwigo_structure-sqlite.sql

@@ -481 +481 @@
   "enabled_high" BOOLEAN default true,
   "level" INTEGER default 0 NOT NULL,
+  "activation_key" CHAR(20) default NULL,
   PRIMARY KEY ("user_id"),
   CONSTRAINT "user_infos_ui1" UNIQUE ("user_id")