Connected to database.
CREATE TABLE deck (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
pitch VARCHAR(4),
defence VARCHAR(4),
power VARCHAR(4),
cost VARCHAR(4)
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'deck' already exists
CREATE TABLE pitches (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pitch VARCHAR(1),
color VARCHAR(30) NOT NULL
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'pitches' already exists
CREATE TABLE cost (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cost VARCHAR(6)
)
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cost' already exists