Ignore:
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:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/piwigo_structure-pgsql.sql

    r5192 r5452  
    254254
    255255-----------------------------------------------------------------------------
     256-- Table structure for table `piwigo_languages`
     257-----------------------------------------------------------------------------
     258
     259DROP TABLE IF EXISTS "piwigo_languages";
     260CREATE TABLE "piwigo_languages" (
     261  "id" varchar(64) NOT NULL default '',
     262  "version" varchar(64) NOT NULL default '0',
     263  "name" varchar(64) default NULL,
     264  PRIMARY KEY  ("id")
     265);
     266
     267COMMENT ON TABLE "piwigo_languages" IS '';
     268
     269-----------------------------------------------------------------------------
    256270-- piwigo_old_permalinks
    257271-----------------------------------------------------------------------------
Note: See TracChangeset for help on using the changeset viewer.