DROP TABLE IF EXISTS `food_items`; SET @saved_cs_client = @@character_set_client; SET NAMES utf8; SET character_set_client = utf8; CREATE TABLE `food_items` ( `ID` int(11) NOT NULL, `Name` varchar(100) NOT NULL, `Ingredients` mediumtext NOT NULL, `Comments` text, PRIMARY KEY (`ID`), UNIQUE KEY `ID_UNIQUE` (`ID`), UNIQUE KEY `Name_UNIQUE` (`Name`) ); SET character_set_client = @saved_cs_client;