Changeset 8464

Timestamp:

Jan 4, 2011, 11:55:08 AM (13 years ago)

Author:

plg

Message:

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

Location:

trunk

Files:

• admin/include/functions_upload.inc.php (modified) (2 diffs)
• admin/site_update.php (modified) (1 diff)
• include/ws_functions.inc.php (modified) (2 diffs)
• install/db/92-database.php (added)
• install/piwigo_structure-mysql.sql (modified) (1 diff)
• install/piwigo_structure-pdo-sqlite.sql (modified) (1 diff)
• install/piwigo_structure-pgsql.sql (modified) (1 diff)
• install/piwigo_structure-sqlite.sql (modified) (1 diff)

trunk/admin/include/functions_upload.inc.php

@@ -185 +185 @@
   // * check md5sum (already exists?)
   
-  global $conf;
+  global $conf, $user;
   
   // current date
@@ -307 +307 @@
     'height' => $file_infos['height'],
     'md5sum' => $md5sum,
+    'added_by' => $user['id'],
     );
 

trunk/admin/site_update.php

@@ -450 +450 @@
           : null,
         'storage_category_id' => $db_fulldirs[$dirname],
+        'added_by' => $user['id'],
         );
 

trunk/include/ws_functions.inc.php

@@ -1210 +1210 @@
 function ws_images_add($params, &$service)
 {
-  global $conf;
+  global $conf, $user;
   if (!is_admin())
   {
@@ -1285 +1285 @@
     'height' => $file_infos['height'],
     'md5sum' => $params['original_sum'],
+    'added_by' => $user['id'],
     );
 

trunk/install/piwigo_structure-mysql.sql

@@ -196 +196 @@
   `level` tinyint unsigned NOT NULL default '0',
   `md5sum` char(32) default NULL,
+  `added_by` smallint(5) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -192 +192 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );

trunk/install/piwigo_structure-pgsql.sql

@@ -236 +236 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );

trunk/install/piwigo_structure-sqlite.sql

@@ -192 +192 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );