aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-pgsql.sql
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2010-03-29 18:16:33 +0000
committernikrou <nikrou@piwigo.org>2010-03-29 18:16:33 +0000
commita6a3a6e0c271099b6f199c7363eba572fc7b5266 (patch)
tree25176b040dd1bc2b0ba7e7bbeda5704883c1c798 /install/piwigo_structure-pgsql.sql
parenta37f1fbae1309c44531f36e0109b1f2bfecf2539 (diff)
Fix some issues with database engines :
- insert into syntax not correct for posgresql or sqlite - add languages table - incorrect function for row count (sqlite) git-svn-id: http://piwigo.org/svn/trunk@5452 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/piwigo_structure-pgsql.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql
index e3b830eb0..719497ba7 100644
--- a/install/piwigo_structure-pgsql.sql
+++ b/install/piwigo_structure-pgsql.sql
@@ -253,6 +253,20 @@ CREATE INDEX "images_i5" ON "piwigo_images" ("date_creation");
CREATE INDEX "images_i1" ON "piwigo_images" ("storage_category_id");
-----------------------------------------------------------------------------
+-- Table structure for table `piwigo_languages`
+-----------------------------------------------------------------------------
+
+DROP TABLE IF EXISTS "piwigo_languages";
+CREATE TABLE "piwigo_languages" (
+ "id" varchar(64) NOT NULL default '',
+ "version" varchar(64) NOT NULL default '0',
+ "name" varchar(64) default NULL,
+ PRIMARY KEY ("id")
+);
+
+COMMENT ON TABLE "piwigo_languages" IS '';
+
+-----------------------------------------------------------------------------
-- piwigo_old_permalinks
-----------------------------------------------------------------------------