Changeset 8464


Ignore:
Timestamp:
01/04/11 11:55:08 (9 years ago)
Author:
plg
Message:

feature 2095 added: new column images.added_by (foreign key on users.id)

Location:
trunk
Files:
1 added
7 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/include/functions_upload.inc.php

    r8253 r8464  
    185185  // * check md5sum (already exists?) 
    186186   
    187   global $conf; 
     187  global $conf, $user; 
    188188   
    189189  // current date 
     
    307307    'height' => $file_infos['height'], 
    308308    'md5sum' => $md5sum, 
     309    'added_by' => $user['id'], 
    309310    ); 
    310311 
  • trunk/admin/site_update.php

    r8126 r8464  
    450450          : null, 
    451451        'storage_category_id' => $db_fulldirs[$dirname], 
     452        'added_by' => $user['id'], 
    452453        ); 
    453454 
  • trunk/include/ws_functions.inc.php

    r8297 r8464  
    12101210function ws_images_add($params, &$service) 
    12111211{ 
    1212   global $conf; 
     1212  global $conf, $user; 
    12131213  if (!is_admin()) 
    12141214  { 
     
    12851285    'height' => $file_infos['height'], 
    12861286    'md5sum' => $params['original_sum'], 
     1287    'added_by' => $user['id'], 
    12871288    ); 
    12881289 
  • trunk/install/piwigo_structure-mysql.sql

    r8131 r8464  
    196196  `level` tinyint unsigned NOT NULL default '0', 
    197197  `md5sum` char(32) default NULL, 
     198  `added_by` smallint(5) NOT NULL default '0', 
    198199  PRIMARY KEY  (`id`), 
    199200  KEY `images_i2` (`date_available`), 
  • trunk/install/piwigo_structure-pdo-sqlite.sql

    r8131 r8464  
    192192  "level" INTEGER default 0 NOT NULL, 
    193193  "md5sum" CHAR(32), 
     194  "added_by" INTEGER default 0 NOT NULL, 
    194195  PRIMARY KEY ("id") 
    195196); 
  • trunk/install/piwigo_structure-pgsql.sql

    r8131 r8464  
    236236  "level" INTEGER default 0 NOT NULL, 
    237237  "md5sum" CHAR(32), 
     238  "added_by" INTEGER default 0 NOT NULL, 
    238239  PRIMARY KEY ("id") 
    239240); 
  • trunk/install/piwigo_structure-sqlite.sql

    r8131 r8464  
    192192  "level" INTEGER default 0 NOT NULL, 
    193193  "md5sum" CHAR(32), 
     194  "added_by" INTEGER default 0 NOT NULL, 
    194195  PRIMARY KEY ("id") 
    195196); 
Note: See TracChangeset for help on using the changeset viewer.