Changeset 8651 for trunk/install/piwigo_structure-pgsql.sql

Timestamp:

Jan 13, 2011, 4:24:18 PM (13 years ago)

Author:

plg

Message:

feature 2108 added: user upload removed from core. It will come back as a
"new generation" user upload in the Community plugin.

File:

• trunk/install/piwigo_structure-pgsql.sql (modified) (2 diffs)

trunk/install/piwigo_structure-pgsql.sql

@@ -34 +34 @@
   "site_id" INTEGER default 1,
   "visible" BOOLEAN default true,
-  "uploadable" BOOLEAN default false,
   "representative_picture_id" INTEGER,
   "uppercats" TEXT,
@@ -653 +652 @@
 
 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id");
-
------------------------------------------------------------------------------
--- piwigo_waiting
------------------------------------------------------------------------------
-
-DROP TABLE IF EXISTS "piwigo_waiting" CASCADE;
-CREATE TABLE "piwigo_waiting"
-(
-  "id" serial  NOT NULL,
-  "storage_category_id" INTEGER default 0 NOT NULL,
-  "file" VARCHAR(255) default '' NOT NULL,
-  "username" VARCHAR(255) default '' NOT NULL,
-  "mail_address" VARCHAR(255) default '' NOT NULL,
-  "date" INTEGER default 0 NOT NULL,
-  "tn_ext" CHAR(3),
-  "validated" BOOLEAN default false,
-  "infos" TEXT,
-  PRIMARY KEY ("id")
-);
-
-COMMENT ON TABLE "piwigo_waiting" IS '';
-
-
-SET search_path TO public;