Hi samuels,
well, I hope you are satisfied with me.
See what I´ve got. I hope it is it what you wanted.
# phpMyAdmin MySQL-Dump
# version 2.4.0
#
http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 23. Februar 2004 um 21:44
# Server Version: 3.23.55
# PHP-Version: 4.3.1
# Datenbank: `xoops`
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_broken`
#
CREATE TABLE xoops_mydownloads_broken (
reportid int(5) NOT NULL auto_increment,
lid int(11) NOT NULL default '0',
sender int(11) NOT NULL default '0',
ip varchar(20) NOT NULL default '',
PRIMARY KEY (reportid),
KEY lid (lid),
KEY sender (sender),
KEY ip (ip)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_cat`
#
CREATE TABLE xoops_mydownloads_cat (
cid int(5) unsigned NOT NULL auto_increment,
pid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '1 2 3',
title varchar(50) NOT NULL default '',
imgurl varchar(150) NOT NULL default '',
PRIMARY KEY (cid),
KEY pid (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_downloads`
#
CREATE TABLE xoops_mydownloads_downloads (
lid int(11) unsigned NOT NULL auto_increment,
cid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '1 2 3',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
homepage varchar(100) NOT NULL default '',
version varchar(10) NOT NULL default '',
size int(8) NOT NULL default '0',
platform varchar(50) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
submitter int(11) NOT NULL default '0',
status tinyint(2) NOT NULL default '0',
date int(10) NOT NULL default '0',
hits int(11) unsigned NOT NULL default '0',
rating double(6,4) NOT NULL default '0.0000',
votes int(11) unsigned NOT NULL default '0',
comments int(11) unsigned NOT NULL default '0',
PRIMARY KEY (lid),
KEY cid (cid),
KEY status (status),
KEY title (title(40))
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_mod`
#
CREATE TABLE xoops_mydownloads_mod (
requestid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned NOT NULL default '0',
cid int(5) unsigned NOT NULL default '0',
groupid varchar(100) NOT NULL default '',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
homepage varchar(100) NOT NULL default '',
version varchar(10) NOT NULL default '',
size int(8) NOT NULL default '0',
platform varchar(50) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
description text NOT NULL,
modifysubmitter int(11) NOT NULL default '0',
PRIMARY KEY (requestid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_text`
#
CREATE TABLE xoops_mydownloads_text (
lid int(11) unsigned NOT NULL default '0',
description text NOT NULL,
KEY lid (lid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `xoops_mydownloads_votedata`
#
CREATE TABLE xoops_mydownloads_votedata (
ratingid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned NOT NULL default '0',
ratinguser int(11) NOT NULL default '0',
rating tinyint(3) unsigned NOT NULL default '0',
ratinghostname varchar(60) NOT NULL default '',
ratingtimestamp int(10) NOT NULL default '0',
PRIMARY KEY (ratingid),
KEY ratinguser (ratinguser),
KEY ratinghostname (ratinghostname),
KEY lid (lid)
) TYPE=MyISAM;
Thanks again, samuels.
Slowly, very slowly I get to know the system.
)
Cheers
Marc