diff options
| author | nikrou <nikrou@piwigo.org> | 2010-03-19 19:39:15 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2010-03-19 19:39:15 +0000 |
| commit | 4c461f36b167641fd7e0182d8c2a88f578c14e58 (patch) | |
| tree | d44f2b7c8fff005db118f177b8f96a0b7f785246 /install | |
| parent | 6b296b293d7ac666548ec74cecf827699f912ff7 (diff) | |
Fix some sql issues :
- permalink that use if() syntax
- add tables themes for other database engines that mysql
git-svn-id: http://piwigo.org/svn/trunk@5192 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install')
| -rw-r--r-- | install/piwigo_structure-pdo-sqlite.sql | 13 | ||||
| -rw-r--r-- | install/piwigo_structure-pgsql.sql | 15 | ||||
| -rw-r--r-- | install/piwigo_structure-sqlite.sql | 13 |
3 files changed, 41 insertions, 0 deletions
diff --git a/install/piwigo_structure-pdo-sqlite.sql b/install/piwigo_structure-pdo-sqlite.sql index 56022d66a..34d4fa0c4 100644 --- a/install/piwigo_structure-pdo-sqlite.sql +++ b/install/piwigo_structure-pdo-sqlite.sql @@ -341,6 +341,19 @@ CREATE TABLE piwigo_tags CREATE INDEX "tags_i1" ON "piwigo_tags" ("url_name"); ----------------------------------------------------------------------------- +-- 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 ----------------------------------------------------------------------------- diff --git a/install/piwigo_structure-pgsql.sql b/install/piwigo_structure-pgsql.sql index ae32d52d6..e3b830eb0 100644 --- a/install/piwigo_structure-pgsql.sql +++ b/install/piwigo_structure-pgsql.sql @@ -415,6 +415,21 @@ SET search_path TO public; CREATE INDEX "tags_i1" ON "piwigo_tags" ("url_name"); ----------------------------------------------------------------------------- +-- 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") +); + +COMMENT ON TABLE "piwigo_themes" IS ''; + +----------------------------------------------------------------------------- -- piwigo_upgrade ----------------------------------------------------------------------------- diff --git a/install/piwigo_structure-sqlite.sql b/install/piwigo_structure-sqlite.sql index 56022d66a..34d4fa0c4 100644 --- a/install/piwigo_structure-sqlite.sql +++ b/install/piwigo_structure-sqlite.sql @@ -341,6 +341,19 @@ CREATE TABLE piwigo_tags CREATE INDEX "tags_i1" ON "piwigo_tags" ("url_name"); ----------------------------------------------------------------------------- +-- 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 ----------------------------------------------------------------------------- |