Schema of tables 'users' and 'friends'

dump.sql

DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invitor_id` int(11) NOT NULL,
  `invited_id` int(11) NOT NULL,
  `status` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `surname` text NOT NULL,
  `email` text NOT NULL,
  `pass` text NOT NULL,
  `name` text NOT NULL,
  `picture` text NOT NULL,
  `gender` text NOT NULL,
  `birthday_day` int(11) NOT NULL,
  `birthday_month` int(11) NOT NULL,
  `birthday_year` int(11) NOT NULL,
  `country` text NOT NULL,
  `nickname` text NOT NULL,
  `about_me` text NOT NULL,
  `skills` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;