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

Timestamp:

Mar 19, 2010, 8:39:15 PM (14 years ago)

Author:

nikrou

Message:

Fix some sql issues :

• permalink that use if() syntax
• add tables themes for other database engines that mysql

File:

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

trunk/install/piwigo_structure-sqlite.sql

@@ -342 +342 @@
 
 -----------------------------------------------------------------------------
+-- piwigo_themes
+-----------------------------------------------------------------------------
+
+DROP TABLE IF EXISTS "piwigo_themes" CASCADE;
+CREATE TABLE "piwigo_themes"
+(
+  "id" varchar(64) default '' NOT NULL,
+  "version" varchar(64) NOT NULL default '0',
+  "name" varchar(64) default NULL,
+  PRIMARY KEY  ("id")
+);
+
+-----------------------------------------------------------------------------
 -- piwigo_upgrade
 -----------------------------------------------------------------------------