From 4c461f36b167641fd7e0182d8c2a88f578c14e58 Mon Sep 17 00:00:00 2001 From: nikrou Date: Fri, 19 Mar 2010 19:39:15 +0000 Subject: Fix some sql issues : - permalink that use if() syntax - add tables themes for other database engines that mysql git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/piwigo_structure-pgsql.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'install/piwigo_structure-pgsql.sql') diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql index ae32d52d6..e3b830eb0 100644 --- a/install/piwigo_structure-pgsql.sql +++ b/install/piwigo_structure-pgsql.sql @@ -414,6 +414,21 @@ COMMENT ON TABLE "piwigo_tags" IS ''; SET search_path TO public; CREATE INDEX "tags_i1" ON "piwigo_tags" ("url_name"); +----------------------------------------------------------------------------- +-- piwigo_themes +----------------------------------------------------------------------------- + +DROP TABLE IF EXISTS "piwigo_themes" CASCADE; +CREATE TABLE "piwigo_themes" +( + "id" varchar(64) default '' NOT NULL, + "version" varchar(64) NOT NULL default '0', + "name" varchar(64) default NULL, + PRIMARY KEY ("id") +); + +COMMENT ON TABLE "piwigo_themes" IS ''; + ----------------------------------------------------------------------------- -- piwigo_upgrade ----------------------------------------------------------------------------- -- cgit v1.2.3