local host/users and rights
Adding a table of house and city. CREATE TABLE maja ( majaID int PRIMARY KEY AUTO_INCREMENT, majaNimi varchar(25) UNIQUE, majaAddress varchar(100), linn int); CREATE TABLE linn ( linnID int PRIMARY KEY AUTO_INCREMENT, linnNimi varchar(25) UNIQUE); Add a connection between the house and the city. alter TABLE maja add CONSTRAINT fk_linnFOREIGN KEY (linn) REFERENCES linn(linnID)