 CREATE TABLE `threads` ( `message_id` INT NOT NULL, PRIMARY KEY (`message_id`) );
 

  CREATE TABLE `reply` (`thread_id` INT NOT NULL, `reply_id` INT NOT NULL);
  
  CREATE TABLE `message` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `text` TEXT NOT NULL, `author` TINYTEXT NOT NULL, `created` TIMESTAMP NOT NULL, `subject` TINYTEXT NOT NULL);
CREATE TABLE `diabit`.`user` (
  `userid` INT(11)  NOT NULL AUTO_INCREMENT,
  `login` TINYTEXT  NOT NULL,
  `password` TEXT  NOT NULL,
  `name` TEXT ,
  PRIMARY KEY(`userid`)
)
TYPE = MYISAM;