Changeset 8464


Ignore:
Timestamp:
Jan 4, 2011, 11:55:08 AM (10 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.