So I’m trying to publish my tables and deployment scripts onto my database, but it’s running into an error when publishing. I’m assuming it’s my insertions for my default data, but I don’t know where.
/*
My tables
*/
CREATE TABLE [dbo].[tblCustomer] (
[Id] INT NOT NULL,
[FirstName] VARCHAR (50) NOT NULL,
[LastName] VARCHAR (50) NOT NULL,
[Address] VARCHAR (50) NOT NULL,
[City] VARCHAR (50) NOT NULL,
[State] VARCHAR (10) NOT NULL,
[ZIP] VARCHAR (10) NOT NULL,
[Phone] VARCHAR (50) NOT NULL,
[UserName] VARCHAR (50) NOT NULL,
[Password] VARCHAR (30) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblDirector] (
[Id] INT NOT NULL,
[FirstName] VARCHAR (50) NOT NULL,
[LastName] VARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblFormat] (
[Id] INT NOT NULL,
[Description] VARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblGenre] (
[Id] INT NOT NULL,
[Description] VARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblMovie] (
[Id] INT NOT NULL,
[Title] VARCHAR (50) NOT NULL,
[Description] VARCHAR (50) NOT NULL,
[ImagePath] VARCHAR (50) NOT NULL,
[Cost] FLOAT (53) NOT NULL,
[RatingId] INT NOT NULL,
[FormatId] INT NOT NULL,
[DirectorId] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblMovieGenre] (
[Id] INT NOT NULL,
[MovieId] INT NOT NULL,
[GenreId] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblOrder] (
[Id] INT NOT NULL,
[CustomerId] INT NOT NULL,
[OrderDate] DATETIME NOT NULL,
[UserId] INT NOT NULL,
[PaymentReceipt] VARCHAR (50) NOT NULL,
[ShipDate] DATETIME NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblOrderItem] (
[Id] INT NOT NULL,
[OrderId] INT NOT NULL,
[MovieId] INT NOT NULL,
[Quantity] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[tblRating] (
[Id] INT NOT NULL,
[Description] VARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
/*
Post-Deployment Script Template
*/
BEGIN
INSERT INTO [dbo].[tblCustomer] ([Id], [FirstName], [LastName], [Address], [City], [State], [ZIP], [Phone],
[UserName], [Password])
VALUES
(1, 'Ken', 'Adams', '6610 Mifflin Ave', 'Harrisburg', 'PA', '17111', '920-379-1234', 'kenadams5', 'pass')
END
BEGIN
INSERT INTO [dbo].[tblDirector] ([Id], [FirstName], [LastName])
VALUES
/*Director for Star Wars */
(1, 'Jeffrey', 'Abrams'),
/*Director for Regarding Henry */
(2, 'Mike', 'Nichols'),
/*Director for Somewhere in Time */
(3, 'Jeannot', 'Szwarc'),
/*Director for No Way Out */
(4, 'Roger', 'Donaldson'),
/*Director for The Breakfast Club */
(5, 'John', 'Hughes')
END
BEGIN
INSERT INTO [dbo].[tblFormat] ([Id], [Description])
VALUES
(1, 'DVD'),
(2, 'Blu-Ray'),
(3, 'VHS')
END
BEGIN
INSERT INTO [dbo].[tblGenre] ([Id], [Description])
VALUES
(1, 'Comedy'),
(2, 'Horror'),
(3, 'Drama'),
(4, 'Romance'),
(5, 'Action'),
(6, 'Thriller'),
(7, 'Sci-Fi'),
(8, 'Adventure')
END
BEGIN
INSERT INTO [dbo].[tblMovie] ([Id], [Title], [Description], [ImagePath], [Cost], [RatingId], [FormatId],
[DirectorId])
VALUES
(1, 'Star Wars: The Force Awakens', 'Light sabers go vrummm!', '?', 19.99, 3, 1, 1),
(2, 'Regarding Henry', 'An unscrupulous corporate lawyer.', '?', 9.99, 3, 1, 2),
(3, 'Somewhere in Time', 'A playwright who becomes obsessed with a photo of a woman.', 'jpgimg', 19.99, 2, 1, 3),
(4, 'No Way Out', 'A passionate fling.', '?', 19.99, 4, 2, 4),
(5, 'No Way Out', 'A passionate fling.', '?', 9.99, 4, 1, 4),
(6, 'The Breakfast Club', 'Teens and their problems...', '?', 4.99, 4, 3, 5)
END
BEGIN
INSERT INTO [dbo].[tblMovieGenre] ([Id], [MovieId], [GenreId])
VALUES
(1, 1, 7),
(2, 2, 3),
(3, 3, 4),
(4, 4, 3),
(5, 5, 3),
(6, 6, 3)
END
BEGIN
INSERT INTO [dbo].[tblOrder] ([Id], [CustomerId], [OrderDate], [UserId], [PaymentReceipt], [ShipDate])
VALUES
(1, 1, '2017-09-10', 1, 'Cash', '2017-09-15')
END
BEGIN
INSERT INTO [dbo].[tblOrderItem] ([Id], [OrderId], [MovieId], [Quantity])
VALUES
(1, 1, 1, 1),
(2, 1, 2, 2),
(3, 1, 3, 1),
(4, 1, 4, 1),
(5, 1, 5, 2),
(6, 1, 6, 3)
END
BEGIN
INSERT INTO [dbo].[tblRating] ([Id], [Description])
VALUES
(1, 'G'),
(2, 'PG'),
(3, 'PG-13'),
(4, 'R')
END
BEGIN
INSERT INTO [dbo].[tblEmployee] ([Id], [FirstName], [LastName], [UserName], [Password])
VALUES
(1, 'Mary', 'Hinkson', 'maryhinkson', 'pass123')
END