[ENG] Download Mod und PostgreSQL

[Larus]

Hallo!

Is it possible to install Download Mod wit PostreSQL dabase ? Attached db_update.php is unfortunately incompatible with Postgres and there are no maunal SQL queries in the readme.

So my question is: did anyone try to make Download Mod working with Postgres instead of MySQL ? Postgres is my only choice and Download Mod would be ideal for me. But HOWTO ?

Edit:

Question to the authors of this mod: Is there any chance to obtain pure SQL queries for this mod ? Then I could translate them to PostgreSQL myself. From the db_update.php it's too difiicult for me


Thanks in advance!

[Demolition_FABI]

Here is an empty database:

Code: Alles auswählen

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 12. März 2006 um 21:42
-- Server Version: 4.0.26
-- PHP-Version: 4.4.1

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_dl_auth`
-- 

CREATE TABLE `phpbb_dl_auth` (
  `cat_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '1',
  `auth_dl` tinyint(1) NOT NULL default '1',
  `auth_up` tinyint(1) NOT NULL default '1',
  `auth_mod` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `phpbb_dl_auth`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_dl_comments`
-- 

CREATE TABLE `phpbb_dl_comments` (
  `dl_id` bigint(20) unsigned NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `cat_id` int(11) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `comment_time` int(11) NOT NULL default '0',
  `comment_edit_time` int(11) NOT NULL default '0',
  `comment_text` text NOT NULL,
  `bbcode_uid` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`dl_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `phpbb_dl_comments`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_dl_config`
-- 

CREATE TABLE `phpbb_dl_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) default NULL,
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `phpbb_dl_config`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_dl_ratings`
-- 

CREATE TABLE `phpbb_dl_ratings` (
  `dl_id` int(11) default '0',
  `user_id` mediumint(8) default '0',
  `rate_point` varchar(10) default '0'
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `phpbb_dl_ratings`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_dl_stats`
-- 

CREATE TABLE `phpbb_dl_stats` (
  `dl_id` bigint(20) unsigned NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `cat_id` int(11) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `traffic` bigint(20) NOT NULL default '0',
  `direction` tinyint(1) NOT NULL default '0',
  `user_ip` varchar(8) NOT NULL default '',
  `browser` varchar(20) NOT NULL default '',
  `time_stamp` int(11) NOT NULL default '0',
  PRIMARY KEY  (`dl_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `phpbb_dl_stats`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_downloads`
-- 

CREATE TABLE `phpbb_downloads` (
  `id` int(11) NOT NULL auto_increment,
  `description` varchar(255) default NULL,
  `file_name` varchar(255) default NULL,
  `klicks` int(11) default '0',
  `free` tinyint(1) default '0',
  `extern` tinyint(1) default '0',
  `long_desc` text,
  `sort` int(11) default '0',
  `cat` int(11) default '0',
  `hacklist` tinyint(1) default '0',
  `hack_author` varchar(255) default '',
  `hack_author_email` varchar(255) default '',
  `hack_author_website` tinytext,
  `hack_version` varchar(32) default '',
  `hack_dl_url` tinytext,
  `test` varchar(50) default '',
  `req` text,
  `todo` varchar(255) default '',
  `warning` text,
  `mod_desc` text,
  `bbcode_uid` varchar(10) default '',
  `mod_list` tinyint(1) default '0',
  `file_size` bigint(20) NOT NULL default '0',
  `change_time` int(11) default '0',
  `add_time` int(11) default '0',
  `rating` smallint(5) NOT NULL default '0',
  `file_traffic` bigint(20) NOT NULL default '0',
  `overall_klicks` int(11) default '0',
  `approve` tinyint(1) default '0',
  `add_user` mediumint(8) default '0',
  `change_user` mediumint(8) default '0',
  `last_time` int(11) default '0',
  `down_user` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `phpbb_downloads`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `phpbb_downloads_cat`
-- 

CREATE TABLE `phpbb_downloads_cat` (
  `id` int(11) NOT NULL auto_increment,
  `parent` int(11) default '0',
  `path` varchar(255) default NULL,
  `cat_name` varchar(255) default NULL,
  `sort` int(11) default '0',
  `description` text,
  `bbcode_uid` varchar(10) default '',
  `auth_view` tinyint(1) NOT NULL default '1',
  `auth_dl` tinyint(1) NOT NULL default '1',
  `auth_up` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  `must_approve` tinyint(1) NOT NULL default '0',
  `allow_mod_desc` tinyint(1) NOT NULL default '0',
  `statistics` tinyint(1) NOT NULL default '1',
  `stats_prune` mediumint(8) NOT NULL default '0',
  `comments` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Daten für Tabelle `phpbb_downloads_cat`
--