Changeset 1028 for trunk/install

Timestamp:

Feb 6, 2006, 11:59:30 PM (18 years ago)

Author:

rub

Message:

[NBM] Step 2: Add new table user_mail_notification (update, install, constants, delete user

+ Correction delete user (table user_feed missing, table sessions must be removed)

Location:

trunk/install

Files:

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

trunk/install/phpwebgallery_structure.sql

@@ -325 +325 @@
 ) TYPE=MyISAM;
 
+--
+-- Table structure for table `phpwebgallery_user_mail_notification`
+--
+
+DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`;
+CREATE TABLE `phpwebgallery_user_mail_notification`
+(
+  `user_id` smallint(5) NOT NULL default '0',
+  `check_key` varchar(128) binary NOT NULL,
+  `enabled` enum('true','false') NOT NULL default 'false',
+  `last_send` datetime default NULL,
+  PRIMARY KEY  (`user_id`),
+  UNIQUE KEY `uidx_check_key` (`check_key`)
+) TYPE=MyISAM;