· 4 years ago · Mar 01, 2021, 03:24 AM
1USE [GulfCoastTherapy]
2GO
3ALTER TABLE [dbo].[PageSection] DROP CONSTRAINT [FK_PageSection_Page]
4GO
5/****** Object: Table [dbo].[Services] Script Date: 2/28/2021 9:17:32 PM ******/
6IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Services]') AND type in (N'U'))
7DROP TABLE [dbo].[Services]
8GO
9/****** Object: Table [dbo].[PageSection] Script Date: 2/28/2021 9:17:32 PM ******/
10IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PageSection]') AND type in (N'U'))
11DROP TABLE [dbo].[PageSection]
12GO
13/****** Object: Table [dbo].[Page] Script Date: 2/28/2021 9:17:32 PM ******/
14IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Page]') AND type in (N'U'))
15DROP TABLE [dbo].[Page]
16GO
17/****** Object: Table [dbo].[FAQs] Script Date: 2/28/2021 9:17:32 PM ******/
18IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FAQs]') AND type in (N'U'))
19DROP TABLE [dbo].[FAQs]
20GO
21/****** Object: Table [dbo].[FAQs] Script Date: 2/28/2021 9:17:32 PM ******/
22SET ANSI_NULLS ON
23GO
24SET QUOTED_IDENTIFIER ON
25GO
26CREATE TABLE [dbo].[FAQs](
27 [Id] [int] IDENTITY(1,1) NOT NULL,
28 [Question] [varchar](100) NOT NULL,
29 [Answer] [varchar](max) NOT NULL,
30 [iOrderBy] [int] NOT NULL,
31 CONSTRAINT [PK_FAQs] PRIMARY KEY CLUSTERED
32(
33 [Id] ASC
34)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
35) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
36GO
37/****** Object: Table [dbo].[Page] Script Date: 2/28/2021 9:17:32 PM ******/
38SET ANSI_NULLS ON
39GO
40SET QUOTED_IDENTIFIER ON
41GO
42CREATE TABLE [dbo].[Page](
43 [PageId] [int] IDENTITY(1,1) NOT NULL,
44 [PageKey] [varchar](50) NOT NULL,
45 CONSTRAINT [PK_Page] PRIMARY KEY CLUSTERED
46(
47 [PageId] ASC
48)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
49) ON [PRIMARY]
50GO
51/****** Object: Table [dbo].[PageSection] Script Date: 2/28/2021 9:17:32 PM ******/
52SET ANSI_NULLS ON
53GO
54SET QUOTED_IDENTIFIER ON
55GO
56CREATE TABLE [dbo].[PageSection](
57 [Id] [int] IDENTITY(1,1) NOT NULL,
58 [PageId] [int] NOT NULL,
59 [ContentKey] [varchar](50) NOT NULL,
60 [ContentHtml] [varchar](max) NOT NULL,
61 CONSTRAINT [PK_PageSection] PRIMARY KEY CLUSTERED
62(
63 [Id] ASC
64)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
65) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
66GO
67/****** Object: Table [dbo].[Services] Script Date: 2/28/2021 9:17:32 PM ******/
68SET ANSI_NULLS ON
69GO
70SET QUOTED_IDENTIFIER ON
71GO
72CREATE TABLE [dbo].[Services](
73 [Id] [int] IDENTITY(1,1) NOT NULL,
74 [Title] [varchar](100) NOT NULL,
75 [Summary] [varchar](500) NOT NULL,
76 [Description] [varchar](max) NOT NULL,
77 [ImageURL] [varchar](max) NOT NULL,
78 CONSTRAINT [PK_Services] PRIMARY KEY CLUSTERED
79(
80 [Id] ASC
81)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
82) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
83GO
84SET IDENTITY_INSERT [dbo].[FAQs] ON
85GO
86INSERT [dbo].[FAQs] ([Id], [Question], [Answer], [iOrderBy]) VALUES (1, N'What is bread?', N'life', 0)
87GO
88INSERT [dbo].[FAQs] ([Id], [Question], [Answer], [iOrderBy]) VALUES (8, N'A Real Question', N'<p>And a <b>real </b>answer too!</p>', 1)
89GO
90SET IDENTITY_INSERT [dbo].[FAQs] OFF
91GO
92SET IDENTITY_INSERT [dbo].[Page] ON
93GO
94INSERT [dbo].[Page] ([PageId], [PageKey]) VALUES (1, N'Home Page')
95GO
96INSERT [dbo].[Page] ([PageId], [PageKey]) VALUES (2, N'Registration')
97GO
98INSERT [dbo].[Page] ([PageId], [PageKey]) VALUES (3, N'FAQ')
99GO
100INSERT [dbo].[Page] ([PageId], [PageKey]) VALUES (4, N'Careers')
101GO
102INSERT [dbo].[Page] ([PageId], [PageKey]) VALUES (5, N'Our Team')
103GO
104SET IDENTITY_INSERT [dbo].[Page] OFF
105GO
106SET IDENTITY_INSERT [dbo].[PageSection] ON
107GO
108INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1, 1, N'About Us', N'Howdy there! We are here for your therapy! fgfg')
109GO
110INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1002, 2, N'Registration Header', N'content')
111GO
112INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1003, 3, N'FAQ Header', N'content')
113GO
114INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1004, 4, N'Careers Header', N'content')
115GO
116INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1005, 1, N'Services Description', N'a wittle description')
117GO
118INSERT [dbo].[PageSection] ([Id], [PageId], [ContentKey], [ContentHtml]) VALUES (1006, 5, N'Our Team Header', N'content')
119GO
120SET IDENTITY_INSERT [dbo].[PageSection] OFF
121GO
122SET IDENTITY_INSERT [dbo].[Services] ON
123GO
124INSERT [dbo].[Services] ([Id], [Title], [Summary], [Description], [ImageURL]) VALUES (1, N'Hand Therapy', N' what it do', N'<b>very cool</b>', N'https://handsonpt.org/wp-content/uploads/2018/11/hand-therapy-astoria-ny.png')
125GO
126SET IDENTITY_INSERT [dbo].[Services] OFF
127GO
128ALTER TABLE [dbo].[PageSection] WITH CHECK ADD CONSTRAINT [FK_PageSection_Page] FOREIGN KEY([PageId])
129REFERENCES [dbo].[Page] ([PageId])
130GO
131ALTER TABLE [dbo].[PageSection] CHECK CONSTRAINT [FK_PageSection_Page]
132GO
133