--
-- Table structure for table `mydownloads_broken`
--
CREATE TABLE mydownloads_broken (
  reportid      serial          NOT NULL,
  lid           integer         NOT NULL default '0',
  sender        integer         NOT NULL default '0',
  ip            varchar(20)     NOT NULL default '',
  PRIMARY KEY (reportid)
);

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

--
-- Table structure for table `mydownloads_cat`
--
CREATE TABLE mydownloads_cat (
  cid       serial          NOT NULL,
  pid       integer         NOT NULL default '0',
  title     varchar(50)     NOT NULL default '',
  imgurl    varchar(150)    NOT NULL default '',
  PRIMARY KEY (cid)
);

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

--
-- Table structure for table `mydownloads_downloads`
--
CREATE TABLE mydownloads_downloads (
  lid           serial          NOT NULL,
  cid           integer         NOT NULL default '0',
  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          integer         NOT NULL default '0',
  platform      varchar(50)     NOT NULL default '',
  logourl       varchar(60)     NOT NULL default '',
  submitter     integer         NOT NULL default '0',
  status        smallint        NOT NULL default '0',
  date          integer         NOT NULL default '0',
  hits          integer         NOT NULL default '0',
  rating        double precision    NOT NULL default '0.0000',
  votes         integer         NOT NULL default '0',
  comments      integer         NOT NULL default '0',
  PRIMARY KEY (lid)
);

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

--
-- Table structure for table `mydownloads_mod`
--
CREATE TABLE mydownloads_mod (
  requestid         serial          NOT NULL,
  lid               integer         NOT NULL default '0',
  cid               integer         NOT NULL default '0',
  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              integer         NOT NULL default '0',
  platform          varchar(50)     NOT NULL default '',
  logourl           varchar(60)     NOT NULL default '',
  description       text            NOT NULL,
  modifysubmitter   integer         NOT NULL default '0',
  PRIMARY KEY (requestid)
);

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

--
-- Table structure for table `mydownloads_text`
--
CREATE TABLE mydownloads_text (
  lid           integer     NOT NULL default '0',
  description   text        NOT NULL
);

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

--
-- Table structure for table `mydownloads_votedata`
--
CREATE TABLE mydownloads_votedata (
  ratingid          serial          NOT NULL,
  lid               integer         NOT NULL default '0',
  ratinguser        integer         NOT NULL default '0',
  rating            smallint        NOT NULL default '0',
  ratinghostname    varchar(60)     NOT NULL default '',
  ratingtimestamp   integer         NOT NULL default '0',
  PRIMARY KEY (ratingid)
);

