diff options
| author | nikrou <nikrou@piwigo.org> | 2010-03-29 18:16:33 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2010-03-29 18:16:33 +0000 |
| commit | a6a3a6e0c271099b6f199c7363eba572fc7b5266 (patch) | |
| tree | 25176b040dd1bc2b0ba7e7bbeda5704883c1c798 /install/piwigo_structure-pgsql.sql | |
| parent | a37f1fbae1309c44531f36e0109b1f2bfecf2539 (diff) | |
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
Diffstat (limited to 'install/piwigo_structure-pgsql.sql')
| -rw-r--r-- | install/piwigo_structure-pgsql.sql | 14 |
1 files changed, 14 insertions, 0 deletions
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 ----------------------------------------------------------------------------- |