aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-sqlite.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-sqlite.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-sqlite.sql')
-rw-r--r--install/piwigo_structure-sqlite.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql
index e4aa71ca3..0c38b4008 100644
--- a/install/piwigo_structure-sqlite.sql
+++ b/install/piwigo_structure-sqlite.sql
@@ -191,6 +191,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")
);