PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Michael Beck   Xoops 2.5   htdocs/modules/pm/sql/mysql.upgrade.sql   Download  
File: htdocs/modules/pm/sql/mysql.upgrade.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Xoops 2.5
Modular content management publication system
Author: By
Last change:
Date: 7 years ago
Size: 365 bytes
 

Contents

Class file image Download 
ALTER TABLE `priv_msgs`
  
  ADD `from_delete` tinyint(1) unsigned     NOT NULL default '1',
  ADD `from_save`   tinyint(1) unsigned     NOT NULL default '0',
  ADD `to_delete`   tinyint(1) unsigned     NOT NULL default '0',
  ADD `to_save`     tinyint(1) unsigned     NOT NULL default '0',
  
  ADD INDEX `prune` (`msg_time`, `read_msg`, `from_save`, `to_delete`);