From 4c461f36b167641fd7e0182d8c2a88f578c14e58 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
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

