DROP TABLE IF EXISTS `text`;
CREATE TABLE `text` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) NOT NULL,
  `date` datetime NOT NULL,
  `some` tinytext COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `text` (`id`, `user_id`, `date`, `some`) VALUES
(1, 1,  '2012-07-10 11:16:51',  'text od 1 číslo 1'),
(2, 1,  '2012-07-10 11:16:57',  'text od 1 číslo 2'),
(3, 2,  '2012-07-10 11:17:01',  'text od 2 číslo 1'),
(4, 3,  '2012-07-10 11:17:05',  'text od 3 číslo 1'),
(5, 3,  '2012-07-10 11:17:08',  'text od 3 číslo 2');

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `user` (`id`, `name`) VALUES
(1, 'aaaa'),
(2, 'bbbb'),
(3, 'cccc');