-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.32-Debian_7-log


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema xoops_unq_apar_dev
--

CREATE DATABASE IF NOT EXISTS xoops_unq_apar_dev;
USE xoops_unq_apar_dev;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_broken`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_cat`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_cat` (
  `cid` int(5) unsigned NOT NULL auto_increment,
  `pid` int(5) unsigned NOT NULL default '0',
  `title` longtext NOT NULL,
  `imgurl` longtext NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
INSERT INTO `xoops_unq_apar_dev`.`apar_cdcyt_cat` VALUES  (1,0,'2007',''),
 (2,0,'Años Anteriores',''),
 (7,2,'2003',''),
 (4,2,'2005',''),
 (5,2,'2004',''),
 (6,2,'2006',''),
 (8,2,'2002',''),
 (9,2,'2001',''),
 (10,2,'2000',''),
 (11,2,'1999',''),
 (12,2,'1998',''),
 (13,2,'1997',''),
 (14,2,'1996','');

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_downloads`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_downloads` (
  `lid` int(11) unsigned NOT NULL auto_increment,
  `cid` int(5) unsigned NOT NULL default '0',
  `title` longtext NOT NULL,
  `url` longtext NOT NULL,
  `homepage` longtext NOT NULL,
  `version` varchar(10) NOT NULL default '',
  `size` int(8) NOT NULL default '0',
  `platform` longtext NOT NULL,
  `logourl` longtext NOT NULL,
  `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',
  `linkarchivo` longtext NOT NULL,
  PRIMARY KEY  (`lid`),
  KEY `cid` (`cid`),
  KEY `status` (`status`),
  KEY `title` (`title`(40))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
INSERT INTO `xoops_unq_apar_dev`.`apar_cdcyt_downloads` VALUES  (1,1,'test','','','',0,'','',1,1,1176311525,0,0.0000,0,0,'HTTP_NOT_FOUND.html.var');

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_mod`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_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',
  `title` longtext NOT NULL,
  `url` longtext NOT NULL,
  `homepage` longtext NOT NULL,
  `version` varchar(10) NOT NULL default '',
  `size` int(8) NOT NULL default '0',
  `platform` longtext NOT NULL,
  `logourl` longtext NOT NULL,
  `description` longtext NOT NULL,
  `modifysubmitter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_text`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_text` (
  `lid` int(11) unsigned NOT NULL default '0',
  `description` longtext NOT NULL,
  KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `xoops_unq_apar_dev`.`apar_cdcyt_text` VALUES  (1,'test');

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_cdcyt_votedata`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_cdcyt_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_broken`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_cat`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_cat` (
  `cid` int(5) unsigned NOT NULL auto_increment,
  `pid` int(5) unsigned NOT NULL default '0',
  `title` longtext NOT NULL,
  `imgurl` longtext NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
INSERT INTO `xoops_unq_apar_dev`.`apar_dcyt_cat` VALUES  (1,0,'2007',''),
 (5,4,'2005',''),
 (3,4,'2006',''),
 (4,0,'Años Anteriores','');

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_downloads`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_downloads` (
  `lid` int(11) unsigned NOT NULL auto_increment,
  `cid` int(5) unsigned NOT NULL default '0',
  `title` longtext NOT NULL,
  `url` longtext NOT NULL,
  `homepage` longtext NOT NULL,
  `version` varchar(10) NOT NULL default '',
  `size` int(8) NOT NULL default '0',
  `platform` longtext NOT NULL,
  `logourl` longtext NOT NULL,
  `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',
  `linkarchivo` longtext NOT NULL,
  PRIMARY KEY  (`lid`),
  KEY `cid` (`cid`),
  KEY `status` (`status`),
  KEY `title` (`title`(40))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_mod`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_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',
  `title` longtext NOT NULL,
  `url` longtext NOT NULL,
  `homepage` longtext NOT NULL,
  `version` varchar(10) NOT NULL default '',
  `size` int(8) NOT NULL default '0',
  `platform` longtext NOT NULL,
  `logourl` longtext NOT NULL,
  `description` longtext NOT NULL,
  `modifysubmitter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_text`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_text` (
  `lid` int(11) unsigned NOT NULL default '0',
  `description` longtext NOT NULL,
  KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `xoops_unq_apar_dev`.`apar_dcyt_votedata`;
CREATE TABLE  `xoops_unq_apar_dev`.`apar_dcyt_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;