Changeset 8651 for trunk/install/piwigo_structure-sqlite.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-sqlite.sql (modified) (2 diffs)

trunk/install/piwigo_structure-sqlite.sql

@@ -27 +27 @@
   "site_id" INTEGER default 1,
   "visible" BOOLEAN default true,
-  "uploadable" BOOLEAN default false,
   "representative_picture_id" INTEGER,
   "uppercats" TEXT,
@@ -537 +536 @@
 CREATE INDEX "comments_i2" ON "piwigo_comments" ("validation_date");
 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id");
-
------------------------------------------------------------------------------
--- piwigo_waiting
------------------------------------------------------------------------------
-
-DROP TABLE IF EXISTS piwigo_waiting;
-CREATE TABLE piwigo_waiting
-(
-  "id" INTEGER 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")
-);
-