SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `fruit`;
CREATE TABLE `fruit` (
  `name` text NOT NULL,
  `size` text NOT NULL,
  `color` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fruit` (`name`, `size`, `color`) VALUES
('lemon',	'small',	'yellow'),
('grape',	'small',	'purple'),
('apple',	'small',	'red'),
('banana',	'small',	'yellow'),
('watermelon',	'big',	'green');

DROP TABLE IF EXISTS `vegetable`;
CREATE TABLE `vegetable` (
  `name` text NOT NULL,
  `size` text NOT NULL,
  `color` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `vegetable` (`name`, `size`, `color`) VALUES
('pea',	'small',	'green'),
('radish',	'small',	'red'),
('bean',	'small',	'green'),
('pumpkin',	'big',	'orange'),
('corn',	'small',	'yellow');
