memorizzare utente in una tabella

CREATE TABLE sessioni (
  uid CHAR(32) NOT NULL,
  user_id INT UNSIGNED NOT NULL,
  creation_date INT UNSIGNED NOT NULL,
  INDEX(uid)
);

CREATE TABLE utenti (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(30) NOT NULL,
  surname VARCHAR(30) NOT NULL,
  username VARCHAR(30) NOT NULL,
  password CHAR(32) NOT NULL,
  PRIMARY KEY(id),
  INDEX(username, password)
);

ALTER TABLE utenti
ADD indirizzo VARCHAR( 100 ) NOT NULL,
ADD occupazione VARCHAR( 100 ) NOT NULL,
ADD temp SET( '0', '1' ) NOT NULL,
ADD regdate VARCHAR( 11 ) NOT NULL,
ADD uid VARCHAR( 32 ) NOT NULL;