aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-sqlite.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--install/piwigo_structure-sqlite.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql
index 54e2f0d12..a46c5929d 100644
--- a/install/piwigo_structure-sqlite.sql
+++ b/install/piwigo_structure-sqlite.sql
@@ -425,6 +425,7 @@ CREATE TABLE piwigo_user_cache_categories
"nb_images" INTEGER default 0 NOT NULL,
"count_images" INTEGER default 0,
"count_categories" INTEGER default 0,
+ "user_representative_picture_id" INTEGER,
PRIMARY KEY ("user_id","cat_id")
);
@@ -535,3 +536,4 @@ CREATE TABLE piwigo_comments
CREATE INDEX "comments_i2" ON "piwigo_comments" ("validation_date");
CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id");
+