Spot-net.nl Forums

Code: Selecteer alles

Unable to connect to database: Error executing query: Table 'spotweb.commentsxover' doesn't exist

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `commentsxover` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` varchar(250) DEFAULT NULL,
  `revid` int(11) DEFAULT NULL,
  `nntpref` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_commentsxover_1` (`nntpref`,`messageid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `downloadlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` varchar(250) DEFAULT NULL,
  `stamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_downloadlist_1` (`messageid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `nntp` (
  `server` varchar(128) NOT NULL,
  `maxarticleid` int(11) DEFAULT NULL,
  `nowrunning` int(11) DEFAULT '0',
  `lastrun` int(11) DEFAULT '0',
  PRIMARY KEY (`server`),
  UNIQUE KEY `maxarticleid` (`maxarticleid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `spots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` varchar(250) DEFAULT NULL,
  `spotid` int(11) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `subcat` int(11) DEFAULT NULL,
  `poster` text,
  `groupname` text,
  `subcata` varchar(24) DEFAULT NULL,
  `subcatb` varchar(24) DEFAULT NULL,
  `subcatc` varchar(24) DEFAULT NULL,
  `subcatd` varchar(24) DEFAULT NULL,
  `title` text,
  `tag` text,
  `stamp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_spots_3` (`messageid`),
  KEY `idx_spots_1` (`id`,`category`,`subcata`,`subcatd`,`stamp`),
  KEY `idx_spots_2` (`id`,`category`,`subcatd`,`stamp`),
  KEY `idx_spots_4` (`stamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8956 ;

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `spotsfull` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` varchar(250) DEFAULT NULL,
  `userid` varchar(32) DEFAULT NULL,
  `verified` tinyint(1) DEFAULT NULL,
  `usersignature` text,
  `userkey` text,
  `xmlsignature` text,
  `fullxml` text,
  `filesize` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_spotsfull_1` (`messageid`,`userid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8956 ;