Форум пользователей MySQL

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

USE `baza` ;
CREATE TABLE IF NOT EXISTS `baza`.`users` (
  `id` INT NOT NULL,
  `name` TEXT NOT NULL,
  `group` TEXT NOT NULL,
  `status` TEXT NOT NULL,
  `password` TEXT NOT NULL,
  `reputation` INT NOT NULL,
  `points` INT NOT NULL,
  `emailnotices` TINYINT(1) NOT NULL,
  `banpoints` INT NOT NULL,
  `ban` TINYINT(1) NOT NULL,
  `surname` TEXT NOT NULL,
  `birthday` DATE NOT NULL,
  PRIMARY KEY (`id`, `name`, `group`, `status`, `password`, `reputation`, `points`, `emailnotices`, `banpoints`, `ban`, `name`, `surname`, `birthday`))
ENGINE = InnoDB;