aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/db/86-database.php2
-rw-r--r--install/piwigo_structure-pdo-sqlite.sql13
-rw-r--r--install/piwigo_structure-pgsql.sql14
-rw-r--r--install/piwigo_structure-sqlite.sql13
4 files changed, 41 insertions, 1 deletions
diff --git a/install/db/86-database.php b/install/db/86-database.php
index 5ff78a033..3a736e3e2 100644
--- a/install/db/86-database.php
+++ b/install/db/86-database.php
@@ -56,7 +56,7 @@ foreach ($themes_to_activate as $theme)
{
$query = '
INSERT INTO '.PREFIX_TABLE.'themes
- SET id = "'.$theme.'"
+ (id) VALUES(\''.$theme.'\'
;';
pwg_query($query);
}
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
@@ -206,6 +206,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
-----------------------------------------------------------------------------
diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql
index e3b830eb0..719497ba7 100644
--- a/install/piwigo_structure-pgsql.sql
+++ b/install/piwigo_structure-pgsql.sql
@@ -253,6 +253,20 @@ 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")
+);
+
+COMMENT ON TABLE "piwigo_languages" IS '';
+
+-----------------------------------------------------------------------------
-- piwigo_old_permalinks
-----------------------------------------------------------------------------
diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql
index 34d4fa0c4..6b48218c8 100644
--- a/install/piwigo_structure-sqlite.sql
+++ b/install/piwigo_structure-sqlite.sql
@@ -206,6 +206,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
-----------------------------------------------------------------------------