Script for Week 6 Discussion

CREATE TABLE DiscHaulRec(
    HaulRecID INT NOT NULL,
    CargoType VARCHAR(25) NULL,
    Mileage INT NOT NULL,
    HaulNotes VARCHAR(150) NULL,
    HaulBegan DATE NOT NULL,
    DelivDate DATE NOT NULL,
    )
GO

INSERT INTO DiscHaulRec (HaulRecID, CargoType, Mileage, HaulNotes, HaulBegan, DelivDate)
    VALUES
        (2, N'4', 52, N'first farm on left', CAST(N'2015-01-01' AS DATE), CAST(N'2015-01-01' AS DATE)),
        (3, N'4', 160, N'new building', CAST(N'2016-05-16' AS DATE), CAST(N'2016-05-16' AS DATE)),
        (5, N'4', 101, N'end of road', CAST(N'2018-08-08' AS DATE), CAST(N'2018-08-08' AS DATE)),
        (6, N'1', 200, N'Biggest Farm', CAST(N'2010-05-06' AS DATE), CAST(N'2010-05-06' AS DATE)),
        (7, N'4', 1200, N'Sawmill', CAST(N'2015-06-05' AS DATE), CAST(N'2015-06-09' AS DATE)),
        (8, N'1', 200, N'Biggest Farm', CAST(N'2011-05-06' AS DATE), CAST(N'2011-05-06' AS DATE)),
        (9, N'4', 150, N'Tire Depot', CAST(N'2012-12-21' AS DATE), CAST(N'2012-12-21' AS DATE)),
        (10, N'5', 30, N'RT15', CAST(N'2020-05-15' AS DATE), CAST(N'2020-05-15' AS DATE)),
        (11, N'5', 30, N'RT15', CAST(N'2020-05-16' AS DATE), CAST(N'2020-05-16' AS DATE)),
        (12, N'5', 32, N'RT15', CAST(N'2020-05-17' AS DATE), CAST(N'2020-05-17' AS DATE)),
        (13, N'5', 32, N'RT15', CAST(N'2020-05-18' AS DATE), CAST(N'2020-05-18' AS DATE)),
        (14, N'5', 34, N'RT15', CAST(N'2020-05-19' AS DATE), CAST(N'2020-05-19' AS DATE)),
        (15, N'4', 2200, N'Walmart', CAST(N'2018-09-19' AS DATE), CAST(N'2018-09-26' AS DATE)),
        (16, N'3', 900, N'Hannafords', CAST(N'2019-08-08' AS DATE), CAST(N'2019-08-09' AS DATE)),
        (17, N'3', 900, N'Hannafords', CAST(N'2019-08-12' AS DATE), CAST(N'2019-08-13' AS DATE)),
        (18, N'3', 900, N'Hannafords', CAST(N'2019-08-16' AS DATE), CAST(N'2019-08-17' AS DATE)),
        (19, N'3', 900, N'Hannafords', CAST(N'2019-08-20' AS DATE), CAST(N'2019-08-21' AS DATE)),
        (20, N'3', 900, N'Hannafords', CAST(N'2019-08-24' AS DATE), CAST(N'2019-08-25' AS DATE)),
        (21, N'1', 223, N'Party City', CAST(N'2001-03-27' AS DATE), CAST(N'2001-03-27' AS DATE)),
        (22, N'4', 75, N'Residence', CAST(N'2019-09-21' AS DATE), CAST(N'2019-09-21' AS DATE))
GO

CREATE TABLE DiscManifest(
    ItemID INT NOT NULL,
    ItemDescription VARCHAR(50) NULL,
    ItemWeightPerUnit INT NOT NULL,
    Quantity INT NOT NULL,
    HaulRecID INT NOT NULL,
    )
GO

INSERT INTO DiscManifest (ItemID, ItemDescription, ItemWeightPerUnit, Quantity, HaulRecID)
    VALUES
        (1, N'Concrete Blocks', 25, 1000, 3),
        (2, N'Chicken Feed', 40, 500, 2),
        (3, N'Water Bottles', 1, 2000, 5),
        (4, N'Milk', 8, 2000, 6),
        (5, N'Logs', 1000, 15, 7),
        (6, N'Milk', 8, 2000, 8),
        (7, N'tires', 10, 2000, 9),
        (8, N'Asphalt', 15, 500, 10),
        (9, N'Asphalt', 15, 500, 11),
        (10, N'Asphalt', 15, 500, 12),
        (11, N'Asphalt', 15, 500, 13),
        (12, N'Asphalt', 15, 500, 14),
        (13, N'Commodities', 10, 2000, 15),
        (14, N'Ice Cream', 8, 1000, 16),
        (15, N'Ice Cream', 8, 1000, 17),
        (16, N'Ice Cream', 8, 1000, 18),
        (17, N'Ice Cream', 8, 1000, 19),
        (18, N'Ice Cream', 8, 1000, 20),
        (19, N'Balloons', 1, 3000, 21),
        (20, N'Sand Fill', 20, 1000, 22)
GO