Connected to database.
CREATE TABLE garage (
garageid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
garagename VARCHAR(30) NOT NULL
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'garage' already exists
CREATE TABLE owner (
ownerid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
garagename VARCHAR(30) NOT NULL
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'owner' already exists
CREATE TABLE car (
carid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
regnr VARCHAR(30) NOT NULL,
color VARCHAR(30) NOT NULL,
garage int(6) NOT NULL,
owner int(6) NOT NULL
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'car' already exists