All pastes #114479 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-08-04 02:40 UTC
rendered paste body
/* Table where FeedData is being truncated: */

CREATE TABLE `Feeds` (
  `FeedID` int(12) NOT NULL auto_increment,
  `FeedURL` text NOT NULL,
  `FeedName` varchar(150) NOT NULL default '',
  `FeedData` text,
  `FeedCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
  `FeedUpdated` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FeedID`),
  KEY `FeedURL` (`FeedURL`(150)),
  KEY `FeedName` (`FeedName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/* Table where FeedData holds large values fine: */

CREATE TABLE `Feeds` (
  `FeedID` int(12) NOT NULL auto_increment,
  `FeedURL` text NOT NULL,
  `FeedData` text NOT NULL,
  `LastUpdated` datetime NOT NULL default '0000-00-00 00:00:00',
  `Spawned` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FeedID`),
  KEY `LastUpdated` (`LastUpdated`),
  KEY `Spawned` (`Spawned`),
  KEY `FeedURL` (`FeedURL`(150))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;