Changeset 5452 for trunk/install

Timestamp:

Mar 29, 2010, 8:16:33 PM (14 years ago)

Author:

nikrou

Message:

Fix some issues with database engines :

• insert into syntax not correct for posgresql or sqlite
• add languages table
• incorrect function for row count (sqlite)

Location:

trunk/install

Files:

• db/86-database.php (modified) (1 diff)
• piwigo_structure-pdo-sqlite.sql (modified) (1 diff)
• piwigo_structure-pgsql.sql (modified) (1 diff)
• piwigo_structure-sqlite.sql (modified) (1 diff)

trunk/install/db/86-database.php

@@ -57 +57 @@
   $query = '
 INSERT INTO '.PREFIX_TABLE.'themes
-  SET id = "'.$theme.'"
+  (id) VALUES(\''.$theme.'\'
 ;';
   pwg_query($query);

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -207 +207 @@
 
 -----------------------------------------------------------------------------
+-- 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
 -----------------------------------------------------------------------------

trunk/install/piwigo_structure-pgsql.sql

@@ -254 +254 @@
 
 -----------------------------------------------------------------------------
+-- 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
 -----------------------------------------------------------------------------

trunk/install/piwigo_structure-sqlite.sql

@@ -207 +207 @@
 
 -----------------------------------------------------------------------------
+-- 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
 -----------------------------------------------------------------------------