Changeset 1116 for trunk/install

Timestamp:

Apr 1, 2006, 3:14:57 AM (18 years ago)

Author:

rub

Message:

[NBM] Step 7: Add functionalities subscribe/unsubscribe:

o reduce length of check_key
o fix bugs
o send mail on subscribe/unsubscribe
o add and used $conf parameters
o review keyword of languages
o improve selection/check
o can subscribe/unsubscribe with a link include on mail
o fix bug mass_update collate

Location:

trunk/install

Files:

• db/18-database.php (added)
• phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -318 +318 @@
 CREATE TABLE `phpwebgallery_user_mail_notification` (
   `user_id` smallint(5) NOT NULL default '0',
-  `check_key` varchar(128) binary NOT NULL default '',
+  `check_key` varchar(16) binary NOT NULL default '',
   `enabled` enum('true','false') NOT NULL default 'false',
   `last_send` datetime default NULL,