Fighting Climate Change

Create Table SQL

CREATE TABLE tblGoals( 
    pmkMyFavGoals INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldGoalNumber INT, 
    fldGoalTitle VARCHAR(50), 
    fldSpecificTarget FLOAT 
)

INSERT INTO tblGoals
(fldGoalNumber, fldGoalTitle, fldSpecificTarget)
VALUES
(2, "Zero Hunger", 2.1),
(11, "Sustainable Cities and Communities", 11.3),
(15, "Life on Land", 15.5),
(6, "Clean Water and Sanitation", 6.4)

SELECT fldGoalNumber, fldGoalTitle, fldSpecificTarget FROM tblGoals

CREATE TABLE tblGoalsOpinions(
    pmkGoalOpinionSurveyId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldFirstName VARCHAR(30) DEFAULT NULL, 
    fldLastName VARCHAR(30) DEFAULT NULL, 
    fldEmail VARCHAR(50) DEFAULT NULL,  
    fldImportant TINYINT(1) DEFAULT 0, 
    fldNotImportant TINYINT(1) DEFAULT 0, 
    fldUrgent TINYINT(1) DEFAULT 0, 
    fldNotReal TINYINT(1) DEFAULT 0, 
    fldGoodIdea TINYINT(1) DEFAULT 0, 
    fldBadIdea TINYINT(1) DEFAULT 0, 
    fldKnowledge VARCHAR(15) DEFAULT NULL, 
    fldMostImportant VARCHAR(60) NOT NULL
)

INSERT INTO tblGoalsOpinions
    (fldFirstName, fldLastName, fldEmail, fldImportant, fldNotImportant, fldUrgent, fldNotReal, fldGoodIdea, fldBadIdea, fldKnowledge, fldMostImportant)
    VALUES 
    (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);