Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [Project]
- GO
- /****** Object: Table [dbo].[Category] Script Date: 16/09/2019 7:14:10 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Category](
- [CategoryId] [int] IDENTITY(1,1) NOT NULL,
- [Name] [varchar](100) NOT NULL,
- [ImagePath] [varchar](200) NOT NULL,
- PRIMARY KEY CLUSTERED
- (
- [CategoryId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- /****** Object: Table [dbo].[Recipes] Script Date: 16/09/2019 7:14:10 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Recipes](
- [RecipesId] [int] IDENTITY(1,1) NOT NULL,
- [Name] [varchar](100) NOT NULL,
- [ImagePath] [varchar](200) NOT NULL,
- [CategoryId] [int] NOT NULL,
- PRIMARY KEY CLUSTERED
- (
- [RecipesId] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- SET IDENTITY_INSERT [dbo].[Category] ON
- GO
- INSERT [dbo].[Category] ([CategoryId], [Name], [ImagePath]) VALUES (1, N'Recetas de comida China', N'chinese/chinese_category.jpg')
- GO
- INSERT [dbo].[Category] ([CategoryId], [Name], [ImagePath]) VALUES (2, N'Recetas de comida Francesa', N'french/french_category.jpg')
- GO
- SET IDENTITY_INSERT [dbo].[Category] OFF
- GO
- /****** Object: StoredProcedure [dbo].[CategorySelectAll] Script Date: 16/09/2019 7:14:10 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- create proc [dbo].[CategorySelectAll]
- as
- begin
- SELECT * FROM Category
- end
- GO
- /****** Object: StoredProcedure [dbo].[RecipesSelectAll] Script Date: 16/09/2019 7:14:10 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- create proc [dbo].[RecipesSelectAll]
- as
- begin
- SELECT * FROM Recipes
- end
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement