Changeset 158

Show
Ignore:
Timestamp:
08/17/05 13:30:22 (5 years ago)
Author:
anti
Message:

+ change plogger_comments.date from timestamp to datetime. This leaves the date unmodified, if the comment is edited from the admin interface and allows to import comments (if ever implemented) from other gallery software

Location:
trunk
Files:
3 modified

Legend:

Unmodified
Added
Removed

  • trunk/_install.php

    r150 r158  
    206206                  `email` varchar(64) NOT NULL default '', 
    207207                  `url` varchar(64) NOT NULL default '', 
    208                   `date` timestamp(14) NOT NULL, 
     208                  `date` datetime NOT NULL, 
    209209                  `comment` longtext NOT NULL, 
    210210                  `ip` char(64), 

  • trunk/_upgrade.php

    r148 r158  
    9898 
    9999$sql = 'ALTER TABLE '.$TABLE_PREFIX.'comments ADD INDEX approved_idx (`approved`)'; 
     100mysql_query($sql); 
     101 
     102// add ip and approved fields to comments table 
     103$sql = 'ALTER TABLE '.$TABLE_PREFIX.'comments CHANGE `date` `date` datetime'; 
    100104mysql_query($sql); 
    101105                         

  • trunk/admin/plog-admin-functions.php

    r157 r158  
    573573                        email='$sql_email',  
    574574                        url='$sql_url',  
     575                        date=NOW(), 
    575576                        comment='$sql_comment', 
    576577                        parent_id='$parent_id',