aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2011-01-04 10:55:08 +0000
committerplegall <plg@piwigo.org>2011-01-04 10:55:08 +0000
commitb4d2a1362fa6dc15d8a1e849d5e36fe341953baf (patch)
tree3b3a6a2246e00ec50dfc5d57ced6bffaad8e9012 /install/piwigo_structure-mysql.sql
parent621ed0b391f81bb7d636d1e447154e1f5b43fb24 (diff)
feature 2095 added: new column images.added_by (foreign key on users.id)
git-svn-id: http://piwigo.org/svn/trunk@8464 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
-rw-r--r--install/piwigo_structure-mysql.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql
index 44124f072..a241ab1f4 100644
--- a/install/piwigo_structure-mysql.sql
+++ b/install/piwigo_structure-mysql.sql
@@ -195,6 +195,7 @@ CREATE TABLE `piwigo_images` (
`high_filesize` mediumint(9) unsigned default NULL,
`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`),
KEY `images_i3` (`average_rate`),