Changeset 5452 for trunk/install/piwigo_structure-sqlite.sql

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)

File:

• trunk/install/piwigo_structure-sqlite.sql (modified) (1 diff)

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
 -----------------------------------------------------------------------------