text: CREATE DATABASE University;
  USE University;
  
  CREATE TABLE students (
      id INT NOT NULL AUTO_INCREMENT,
      first_name CHAR(255) NULL,
      patronymic CHAR(255) NULL,
      lastname CHAR(255) NULL,
      course INT,
      `group` INT,
      PRIMARY KEY (id)
  );
  CREATE TABLE specialties(
      id INT NOT NULL AUTO_INCREMENT,
      student INT,
      discipline INT,
      PRIMARY KEY (id)
  );
  CREATE TABLE disciplines(
      id INT NOT NULL AUTO_INCREMENT,
      name CHAR(255) NULL,
      hours INT,
      PRIMARY KEY (id)
  );
  
  GRANT ALL PRIVILEGES ON *.* TO 'sys_all'@'localhost';
  REVOKE ALL PRIVILEGES  ON *.* FROM 'sys'@'localhost';
  GRANT SELECT, UPDATE, INSERT ON *.* TO 'user'@'localhost';
  GRANT SELECT, UPDATE, INSERT, DROP ON *.* TO 'user_all'@'localhost';
  