I'm trying to build an SQL table with one element, a 'Description' column, which has to be tagged as longtext. When I try to load the database I'm getting an 1170 error telling me the Primary Key needs a key length specified. What would be the solution to this?
Yeah, I know it sounds weird... but I'm experimenting.
CREATE TABLE IF NOT EXISTS `Items` (
PRIMARY KEY (`Description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Dumping data for table `Items`
INSERT INTO `Items` (`Description`) VALUES
('Long Description text goes here');