CREATE TABLE `availablelangs` (
  `lang` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`lang`)
) ENGINE = InnoDB;

CREATE TABLE `webuser` (
  `id` INT UNSIGNED NOT NULL,
  `username` VARCHAR(1) NULL,
--  `password` VARCHAR(1) NULL,
  `password` VARCHAR(1) NULL COMMENT 'If user is registered - mandatory: SHA-256 of salt+user`s password (Passwords will be case sensitive. Passwords should be between 6-20 characters. Passwords will be alphanumeric (a-z;A-Z;0-9).). Otherwise NULL.',
  `lang` VARCHAR(20) NOT NULL DEFAULT 'english-us',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`lang`) REFERENCES `availablelangs`(`lang`)
) ENGINE = InnoDB;