From a6a3a6e0c271099b6f199c7363eba572fc7b5266 Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
Date: Mon, 29 Mar 2010 18:16:33 +0000
Subject: 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
---
 install/piwigo_structure-pdo-sqlite.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'install/piwigo_structure-pdo-sqlite.sql')

diff --git a/install/piwigo_structure-pdo-sqlite.sql b/install/piwigo_structure-pdo-sqlite.sql
index 34d4fa0c4..6b48218c8 100644
--- a/install/piwigo_structure-pdo-sqlite.sql
+++ b/install/piwigo_structure-pdo-sqlite.sql
@@ -205,6 +205,19 @@ 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")
+);
+
 -----------------------------------------------------------------------------
 -- piwigo_old_permalinks
 -----------------------------------------------------------------------------
-- 
cgit v1.2.3

