From a6a3a6e0c271099b6f199c7363eba572fc7b5266 Mon Sep 17 00:00:00 2001 From: nikrou 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