当前文件： SmallBusinessStarterKit/App_Data/SetupDatabase.sql[68K，2009-6-12 11:54:21]，打开代码结构图

		            
  1/**//*
  2* Create Table News
  3* */
  4SET ANSI_NULLS ON
  5GO
  6SET QUOTED_IDENTIFIER ON
  7GO
  8IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U'))
  9BEGIN
 10CREATE TABLE [dbo].[News](
 11    [id] [nvarchar](32) NOT NULL,
 12    [visible] [bit] NOT NULL,
 13    [title] [nvarchar](256) NOT NULL,
 14    [date] [datetime] NOT NULL,
 15    [content] [nvarchar](4000) NULL,
 16    [imageUrl] [nvarchar](256) NULL,
 17    [imageAltText] [nvarchar](256) NULL,
 18    [displayOrder] [int] NULL,
 19PRIMARY KEY CLUSTERED 
 20(
 21    [id] ASC
 22)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
 23) ON [PRIMARY]
 24END
 25GO
 26/**//*
 27* Create Table People
 28* */
 29SET ANSI_NULLS ON
 30GO
 31SET QUOTED_IDENTIFIER ON
 32GO
 33IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[People]') AND type in (N'U'))
 34BEGIN
 35CREATE TABLE [dbo].[People](
 36    [id] [nvarchar](32) NOT NULL,
 37    [visible] [bit] NOT NULL,
 38    [firstName] [nvarchar](64) NOT NULL,
 39    [middleName] [nvarchar](64) NULL,
 40    [lastName] [nvarchar](64) NOT NULL,
 41    [title] [nvarchar](128) NULL,
 42    [description] [nvarchar](2048) NULL,
 43    [email] [nvarchar](256) NULL,
 44    [phone] [nvarchar](64) NULL,
 45    [fax] [nvarchar](64) NULL,
 46    [streetAddress] [nvarchar](128) NULL,
 47    [city] [nvarchar](128) NULL,
 48    [state] [nvarchar](64) NULL,
 49    [postalCode] [nvarchar](64) NULL,
 50    [country] [nvarchar](64) NULL,
 51    [imageUrl] [nvarchar](256) NULL,
 52    [imageAltText] [nvarchar](256) NULL,
 53    [displayOrder] [int] NULL,
 54PRIMARY KEY CLUSTERED 
 55(
 56    [id] ASC
 57)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
 58) ON [PRIMARY]
 59END
 60GO
 61/**//*
 62* Create Table Category
 63* */
 64SET ANSI_NULLS ON
 65GO
 66SET QUOTED_IDENTIFIER ON
 67GO
 68IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))
 69BEGIN
 70CREATE TABLE [dbo].[Category](
 71    [id] [nvarchar](32) NOT NULL,
 72    [visible] [bit] NOT NULL,
 73    [title] [nvarchar](256) NULL,
 74    [description] [nvarchar](2048) NULL,
 75    [imageUrl] [nvarchar](256) NULL,
 76    [imageAltText] [nvarchar](256) NULL,
 77    [parentCategoryId] [nvarchar](32) NULL,
 78    [displayOrder] [int] NULL,
 79PRIMARY KEY CLUSTERED 
 80(
 81    [id] ASC
 82)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
 83) ON [PRIMARY]
 84END
 85GO
 86/**//*
 87* Create Table Item
 88* */
 89SET ANSI_NULLS ON
 90GO
 91SET QUOTED_IDENTIFIER ON
 92GO
 93IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Item]') AND type in (N'U'))
 94BEGIN
 95CREATE TABLE [dbo].[Item](
 96    [id] [nvarchar](32) NOT NULL,
 97    [visible] [bit] NOT NULL,
 98    [title] [nvarchar](256) NOT NULL,
 99    [description] [nvarchar](2048) NULL,
100    [price] [float] NULL,
101    [inStock] [bit] NULL,
102    [imageUrl] [nvarchar](256) NULL,
103    [imageAltText] [nvarchar](256) NULL,
104    [displayOrder] [int] NULL,
105PRIMARY KEY CLUSTERED 
106(
107    [id] ASC
108)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
109) ON [PRIMARY]
110END
111GO
112/**//*
113* Create Table Testimonails
114* */
115SET ANSI_NULLS ON
116GO
117SET QUOTED_IDENTIFIER ON
118GO
119IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Testimonials]') AND type in (N'U'))
120BEGIN
121CREATE TABLE [dbo].[Testimonials](
122    [id] [nvarchar](32) NOT NULL,
123    [visible] [bit] NOT NULL,
124    [title] [nvarchar](256) NOT NULL,
125    [date] [datetime] NOT NULL,
126    [content] [nvarchar](1024) NULL,
127    [testifier] [nvarchar](256) NULL,
128    [testifierTitle] [nvarchar](256) NULL,
129    [testifierCompany] [nvarchar](256) NULL,
130    [imageUrl] [nvarchar](256) NULL,
131    [imageAltText] [nvarchar](256) NULL,
132    [displayOrder] [int] NULL,
133PRIMARY KEY CLUSTERED 
134(
135    [id] ASC
136)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
137) ON [PRIMARY]
138END
139GO
140/**//*
141* Create Table Categorization
142* */
143SET ANSI_NULLS ON
144GO
145SET QUOTED_IDENTIFIER ON
146GO
147IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Categorization]') AND type in (N'U'))
148BEGIN
149CREATE TABLE [dbo].[Categorization](
150    [itemId] [nvarchar](32) NOT NULL,
151    [parentCategoryId] [nvarchar](32) NOT NULL,
152PRIMARY KEY CLUSTERED 
153(
154    [itemId] ASC,
155    [parentCategoryId] ASC
156)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
157) ON [PRIMARY]
158END
159GO
160/**//*
161 * Procedure GetRootCategories
162 * */
163SET ANSI_NULLS ON
164GO
165SET QUOTED_IDENTIFIER ON
166GO
167IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetRootCategories]') AND type in (N'P', N'PC'))
168BEGIN
169EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetRootCategories] AS SELECT id, visible, title, description, imageUrl, imageAltText, parentCategoryId FROM Category WHERE (parentCategoryId IS NULL)' 
170END
171GO
172/**//*
173* Procedure GetNonRootCategories
174* */
175SET ANSI_NULLS ON
176GO
177SET QUOTED_IDENTIFIER ON
178GO
179IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetNonRootCategories]') AND type in (N'P', N'PC'))
180BEGIN
181EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetNonRootCategories] @categoryId nvarchar(32) AS SELECT id, visible, title, description, imageUrl, imageAltText, parentCategoryId FROM Category WHERE (parentCategoryId = @categoryId)' 
182END
183GO
184/**//*
185* Procedure GetChildItems(@categoryId)
186* */
187SET ANSI_NULLS ON
188GO
189SET QUOTED_IDENTIFIER ON
190GO
191IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetChildItems]') AND type in (N'P', N'PC'))
192BEGIN
193EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetChildItems] @categoryId nvarchar(32) AS SELECT Item.id, Item.visible, Item.title, Item.description, Item.price, Item.inStock, Item.imageUrl, Item.imageAltText FROM Item INNER JOIN Categorization ON Item.id = Categorization.itemId WHERE (Categorization.parentCategoryId = @categoryId)' 
194END
195GO
196
197/**//*
198* Create Procedure GetNewsItem(@id)
199* */
200SET ANSI_NULLS ON
201GO
202SET QUOTED_IDENTIFIER ON
203GO
204IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetNewsItem]') AND type in (N'P', N'PC'))
205BEGIN
206EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetNewsItem] @id nvarchar(32) AS SELECT id, visible, title, date, [content], imageUrl, imageAltText FROM News WHERE (id = @id)' 
207END
208GO
209/**//*
210* Create Procedure GetNews()
211* */
212SET ANSI_NULLS ON
213GO
214SET QUOTED_IDENTIFIER ON
215GO
216IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetNews]') AND type in (N'P', N'PC'))
217BEGIN
218EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetNews] AS SELECT id, visible, title, date, [content], imageUrl, imageAltText FROM News ORDER BY date DESC' 
219END
220GO
221/**//*
222* Create Procedure GetPeople()
223* */
224SET ANSI_NULLS ON
225GO
226SET QUOTED_IDENTIFIER ON
227GO
228IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetPeople]') AND type in (N'P', N'PC'))
229BEGIN
230EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetPeople] AS SELECT id, visible, firstName, middleName, lastName, title, description, email, phone, fax, streetAddress, city, state, postalCode, country, imageUrl, imageAltText FROM People ORDER BY displayOrder' 
231END
232GO
233/**//*
234* Create Procedure GetTestimonials()
235* */
236SET ANSI_NULLS ON
237GO
238SET QUOTED_IDENTIFIER ON
239GO
240IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetTestimonials]') AND type in (N'P', N'PC'))
241BEGIN
242EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetTestimonials] AS SELECT id, visible, title, date, [content], testifier, testifierTitle, testifierCompany, imageUrl, imageAltText FROM Testimonials ORDER BY displayOrder' 
243END
244GO
245/**//*
246* Create Procedure GetItem(@id)
247* */
248SET ANSI_NULLS ON
249GO
250SET QUOTED_IDENTIFIER ON
251GO
252IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetItem]') AND type in (N'P', N'PC'))
253BEGIN
254EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[GetItem] @itemId nvarchar(32) AS SELECT Item.id, Item.visible, Item.title, Item.description, Item.price, Item.inStock, Item.imageUrl, Item.imageAltText FROM Item WHERE (Item.id = @itemId)' 
255END
256GO
257/**//*
258* Create Foreign Key Relationships
259* */
260IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__Category__parent__5165187F]') AND parent_object_id = OBJECT_ID(N'[dbo].[Category]'))
261ALTER TABLE [dbo].[Category]  WITH CHECK ADD FOREIGN KEY([parentCategoryId])
262REFERENCES [dbo].[Category] ([id])
263GO
264IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__Categoriz__itemI__5FB337D6]') AND parent_object_id = OBJECT_ID(N'[dbo].[Categorization]'))
265ALTER TABLE [dbo].[Categorization]  WITH CHECK ADD FOREIGN KEY([itemId])
266REFERENCES [dbo].[Item] ([id])
267GO
268IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__Categoriz__paren__60A75C0F]') AND parent_object_id = OBJECT_ID(N'[dbo].[Categorization]'))
269ALTER TABLE [dbo].[Categorization]  WITH CHECK ADD FOREIGN KEY([parentCategoryId])
270REFERENCES [dbo].[Category] ([id])
271/**//*
272* Insert Data: table Category
273*/
274INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('01',1,'Amet','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'cat01.jpg', 'image of Category 1', null , 1)
275INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('02',1,'Consectetuer','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'cat02.jpg', 'image of Category 2' , null , 2)
276INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('03',1,'Adipiscing','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'cat03.jpg', 'image of Category 3', null, 3)
277INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('04',1,'Pharetra Diam','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'cat04.jpg', 'image of Category 4', null, 4)
278INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('05',1,'Ullamcorper','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'cat06.jpg', 'image of Category 5', null, 5)
279INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('06',1,'Sed eget Magna','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-1.jpg', 'image of Category 6', '01', 6)
280INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('07',1,'Vestibulum','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-2.jpg', 'image of Category 7', '01', 7)
281INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('08',1,'Proin Feugiat Enim','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-3.jpg', 'image of Category 8', '01', 8)
282INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('09',1,'Vivamus Gravida','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-4.jpg', 'image of Category 9', '01', 9)
283INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('10',1,'Pellentesque','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-5.jpg', 'image of Category 10', '02', 10)
284INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('11',1,'Maecenas auctor Luctus','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-6.jpg', 'image of Category 11', '03', 11)
285INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('12',1,'Blandit','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-7.jpg', 'image of Category 11', '03', 12)
286INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('13',1,'Eu Mollis Nunc','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-8.jpg', 'image of Category 11', '04', 13)
287INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('14',1,'Luctus Dictum','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-9.jpg', 'image of Category 11', '04', 14)
288INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('15',1,'Rhoncus','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-10.jpg', 'image of Category 11', '05', 15)
289INSERT INTO Category (id, visible, title, description, imageUrl, imageAltText, parentCategoryId, displayOrder) VALUES ('16',1,'Elementum','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt', 'product-small-11.jpg', 'image of Category 11', '05', 16)
290/**//*
291* Insert Data: table Item
292*/
293INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('01',1,'Proin vitae','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item01.jpg', 'image of item 1', 1)
294INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('02',1,'Felis Non Purus','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item02.jpg', 'image of item 2', 2)
295INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('03',1,'Eleifend Consequat','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item01.jpg', 'image of item 3', 3)
296INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('04',1,'Pellentesque','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item02.jpg', 'image of item 4', 4)
297INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('05',1,'Sodales Mollis','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item01.jpg', 'image of item 5', 5)
298INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('06',1,'Vel Purus','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item02.jpg', 'image of item 6', 6)
299INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('07',1,'Mollis','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item01.jpg', 'image of item 7', 7)
300INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('08',1,'Tincidunt','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed ', 12.00,1, 'item02.jpg', 'image of item 8', 8)
301INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('09',1,'Nullam Tellus','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed', 12.00,1, 'item01.jpg', 'image of item 9', 9)
302INSERT INTO Item (id, visible, title, description, price, inStock, imageUrl, imageAltText, displayOrder) VALUES ('10',1,'Fusce Vulputate','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed', 12.00,1, 'item02.jpg', 'image of item 10', 10)
303/**//*
304* Insert Data: table Categorization
305* a child item may belong to multiple parent categories
306*/
307INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('01','05');
308INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('02','05');
309INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('03','05');
310INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('04','05');
311INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('05','05');
312INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('06','05');
313INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('01','06');
314INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('02','06');
315INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('03','06');
316INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('04','07');
317INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('05','07');
318INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('06','07');
319INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('07','08');
320INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('01','09');
321INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('02','09');
322INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('03','09');
323INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('06','10');
324INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('07','10');
325INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('08','10');
326INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('09','10');
327INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('10','10');
328INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('06','12');
329INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('07','12');
330INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('08','12');
331INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('09','12');
332INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('10','12');
333INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('06','14');
334INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('07','14');
335INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('08','14');
336INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('09','14');
337INSERT INTO Categorization (itemId, parentCategoryId) VALUES ('10','14');
338/**//*
339* Insert Data: table Testimonials
340*/
341INSERT INTO Testimonials (id, visible, title, date, content, testifier, testifierTitle, testifierCompany, imageUrl, imageAltText, displayOrder) VALUES     ('01', 1, 'Northwind Traders sadipscing elitr Fabrikam', '07-12-2006 03:00:00', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.','Pernille Halberg', 'Director', 'Northwind Traders', 'person-3.jpg', 'Pernille Halberg - Northwind Traders', 1);
342INSERT INTO Testimonials (id, visible, title, date, content, testifier, testifierTitle, testifierCompany, imageUrl, imageAltText, displayOrder) VALUES     ('02', 1, 'Contoso Pharmaceuticals sadipscing elitr Fabrikam', '07-12-2006 12:00:00', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.','Darren Parker', 'Manager', 'Contoso Pharmaceuticals', '', 'Darren Parker -  Manager, Contoso Pharmaceuticals',3);
343INSERT INTO Testimonials (id, visible, title, date, content, testifier, testifierTitle, testifierCompany, imageUrl, imageAltText, displayOrder) VALUES     ('03', 1, 'Contoso Pharmaceuticals sadipscing elitr Fabrikam', '07-10-2006 02:34:00', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.','Nielsen Bardenfleth', 'Engineer', 'Contoso Pharmaceuticals', 'person-6.jpg', 'Nielsen Bardenfleth-  Manager, Contoso Pharmaceuticals',2);
344/**//*
345* Insert Data: table News
346*/
347INSERT INTO News (id, visible, title, date, [content], imageUrl, imageAltText, displayOrder) VALUES     ('01', 1, 'Consectetur Fabrikam Dolor Sit Amet', '02-12-2006 12:00:00', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididuntt labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'news.jpg', 'Fabrikam - anim id est laborum', 1)
348INSERT INTO News (id, visible, title, date, [content], imageUrl, imageAltText, displayOrder) VALUES     ('02', 1, 'Fabrikam Consectetur Adipisicing Elit', '03-12-2006 12:00:00', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'news-2.jpg', 'Fabrikam - anim id est laborum', 2)
349INSERT INTO News (id, visible, title, date, [content], imageUrl, imageAltText, displayOrder) VALUES     ('03', 1, 'Mollit Anim Id Est Laborum', '03-10-2006 12:00:00', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'news1.jpg', 'Fabrikam - anim id est laborum', 2)
350/**//*
351* Insert Data: table People
352*/
353INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('01',1,'Jesper','','Aaberg','President','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.', 'aaberg@fabrikam.com','2025550100','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-1.jpg','Jesper - President', 1)
354INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('11',1,'Del Moral Negugogor','','Oscar','Chairman','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.','lene@fabrikam.com','2025550100','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-4.jpg','Del Moral Negugogor', 2)
355INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('12',1,'Dziegiel','Hanefeld','Andreas','Editor','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.', 'Dziegiel@fabrikam.com','2025550102','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-5.jpg','Dziegiel', 3)
356INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('02',1,'Aalling','','Lene','Editor','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.', 'Aalling@fabrikam.com','2025550102','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-2.jpg','Aalling', 3)
357INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('03',1,'Abbas','','Syed','Editor','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.', 'syed@fabrikam.com','2025550102','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-7.jpg','Abbas - Editor', 3)
358INSERT INTO People (id, visible, firstName, middleName, lastName,title, description, email, phone, fax, streetAddress, city , state, postalCode, country, imageUrl, imageAltText , displayOrder) VALUES ('04',1,'Nielsen','Bardenfleth','Thomas','Editor','Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exercitation ulliam corper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem veleum iriure dolor in hendrerit in vulputate velit esse molestie consequat.', 'Nielsen@fabrikam.com','2025550102','2025556100', '567 Main St','Buffalo','NY','99887','USA','person-4.jpg','Image of Nielsen', 3)
359
360