Making the World a Better Place

Create Compost Table

CREATE TABLE tblCompostMaterials (
    pmkCompostMaterialsId int NOT NULL
    AUTO_INCREMENT PRIMARY KEY,
    fldFoodScraps varchar(30) DEFAULT NULL,
    fldNaturalMaterials varchar(30) DEFAULT NULL,
    fldPaper varchar(250) DEFAULT NULL
)
        

Insert records into the table compostMaterials

        INSERT INTO tblCompostMaterials
        (pmkCompostMaterialsId, fldFoodScraps,
        fldNaturalMaterials, fldPaper)
        VALUES
(1,'fruit peels/rinds','grass clippings','newspaper'),
(2, 'coffee grounds', 'leaves', 'cardboard'),
(3, 'rotten vegetables', 'dead plants', 'napkins');   
        

Selecting Compost records

            SELECT pmkCompostMaterialsId,fldFoodScraps,fldNaturalMaterials, fldPaper FROM tblCompostMaterials
        

Favorite Green Activity Table

        CREATE TABLE tblFavGreenActivities (
            pmkFavGreenActivitiesId int NOT NULL
            AUTO_INCREMENT PRIMARY KEY,
            fldFavGreenActivity varchar(30) DEFAULT NULL,
            fldEmail varchar(50) DEFAULT NULL,
            fldStrive varchar(11) DEFAULT NULL,
            fldGardening tinyint(1) DEFAULT NULL,
            fldThrifting tinyint(1) DEFAULT NULL,
            fldRecycling tinyint(1) DEFAULT NULL
        )