aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-pgsql.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-pgsql.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-pgsql.sql')
-rw-r--r--install/piwigo_structure-pgsql.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql
index f4679cc83..5f9d5a8cf 100644
--- a/install/piwigo_structure-pgsql.sql
+++ b/install/piwigo_structure-pgsql.sql
@@ -235,6 +235,7 @@ CREATE TABLE "piwigo_images"
"high_filesize" INTEGER,
"level" INTEGER default 0 NOT NULL,
"md5sum" CHAR(32),
+ "added_by" INTEGER default 0 NOT NULL,
PRIMARY KEY ("id")
);