API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 24th, 2018
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.68 KB | None | 0 0
raw download clone embed print report
  1. CREATE DATABASE SklepPixel;
  2. GO
  3. USE [SklepPixel]
  4. GO
  5.  
  6. SET ANSI_NULLS ON
  7. GO
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10. CREATE TABLE [dbo].[ProductCategory](
  11. [Id] [int] IDENTITY(1,1) NOT NULL,
  12. [Name] [nvarchar](50) NOT NULL,
  13. CONSTRAINT [PK_ProductCategory] PRIMARY KEY CLUSTERED
  14. (
  15. [Id] ASC
  16. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  17. ) ON [PRIMARY]
  18. GO
  19. SET IDENTITY_INSERT [dbo].[ProductCategory] ON
  20. INSERT [dbo].[ProductCategory] ([Id], [Name]) VALUES (1, N'Computer')
  21. INSERT [dbo].[ProductCategory] ([Id], [Name]) VALUES (2, N'Accessory')
  22. INSERT [dbo].[ProductCategory] ([Id], [Name]) VALUES (3, N'Drive')
  23. INSERT [dbo].[ProductCategory] ([Id], [Name]) VALUES (4, N'Printer')
  24. SET IDENTITY_INSERT [dbo].[ProductCategory] OFF
  25.  
  26. SET ANSI_NULLS ON
  27. GO
  28. SET QUOTED_IDENTIFIER ON
  29. GO
  30. CREATE TABLE [dbo].[Product](
  31. [Id] [int] IDENTITY(1,1) NOT NULL,
  32. [Name] [nvarchar](50) NOT NULL,
  33. [Price] [numeric](18, 0) NOT NULL,
  34. [CategoryId] [int] NOT NULL,
  35. CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED
  36. (
  37. [Id] ASC
  38. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  39. ) ON [PRIMARY]
  40. GO
  41. SET IDENTITY_INSERT [dbo].[Product] ON
  42. INSERT [dbo].[Product] ([Id], [Name], [Price], [CategoryId]) VALUES (1, N'Laptop', 2000, 1)
  43. INSERT [dbo].[Product] ([Id], [Name], [Price], [CategoryId]) VALUES (2, N'Mouse', 50, 2)
  44. INSERT [dbo].[Product] ([Id], [Name], [Price], [CategoryId]) VALUES (3, N'Keyboard', 300, 2)
  45. INSERT [dbo].[Product] ([Id], [Name], [Price], [CategoryId]) VALUES (4, N'Flash drive', 100, 3)
  46. INSERT [dbo].[Product] ([Id], [Name], [Price], [CategoryId]) VALUES (5, N'Hard drive', 400, 3)
  47. SET IDENTITY_INSERT [dbo].[Product] OFF
  48.  
  49. SET ANSI_NULLS ON
  50. GO
  51. SET QUOTED_IDENTIFIER ON
  52. GO
  53. CREATE TABLE [dbo].[Orders](
  54. [Id] [int] IDENTITY(1,1) NOT NULL,
  55. [OrderNumber] [nvarchar](50) NOT NULL,
  56. [OrderDate] [datetime] NOT NULL,
  57. [OrderTotal] [numeric](18, 0) NOT NULL,
  58. [EmployeeId] [int] NOT NULL,
  59. CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED
  60. (
  61. [Id] ASC
  62. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  63. ) ON [PRIMARY]
  64. GO
  65. SET IDENTITY_INSERT [dbo].[Orders] ON
  66. INSERT [dbo].[Orders] ([Id], [OrderNumber], [OrderDate], [OrderTotal], [EmployeeId]) VALUES (1, N'Z/13/2014', '2014-01-14', 55, 3)
  67. INSERT [dbo].[Orders] ([Id], [OrderNumber], [OrderDate], [OrderTotal], [EmployeeId]) VALUES (2, N'Z/25/2015', '2015-02-21', 668, 5)
  68. INSERT [dbo].[Orders] ([Id], [OrderNumber], [OrderDate], [OrderTotal], [EmployeeId]) VALUES (3, N'Z/30/2015', '2015-06-29', 2890, 1)
  69. INSERT [dbo].[Orders] ([Id], [OrderNumber], [OrderDate], [OrderTotal], [EmployeeId]) VALUES (5, N'Z/45/2015', '2015-07-24', 800, 3)
  70. INSERT [dbo].[Orders] ([Id], [OrderNumber], [OrderDate], [OrderTotal], [EmployeeId]) VALUES (6, N'Z/50/2015', '2015-08-02', 2700, 4)
  71. SET IDENTITY_INSERT [dbo].[Orders] OFF
  72.  
  73. SET ANSI_NULLS ON
  74. GO
  75. SET QUOTED_IDENTIFIER ON
  76. GO
  77. CREATE TABLE [dbo].[OrderDetails](
  78. [Id] [int] IDENTITY(1,1) NOT NULL,
  79. [OrderId] [int] NOT NULL,
  80. [ProductId] [int] NOT NULL,
  81. [Quantity] [int] NOT NULL,
  82. [UnitCost] [numeric](18, 0) NOT NULL,
  83. CONSTRAINT [PK_OrderDetails] PRIMARY KEY CLUSTERED
  84. (
  85. [Id] ASC
  86. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  87. ) ON [PRIMARY]
  88. GO
  89. SET IDENTITY_INSERT [dbo].[OrderDetails] ON
  90. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (2, 1, 2, 1, 55)
  91. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (3, 2, 2, 1, 55)
  92. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (4, 2, 4, 2, 99)
  93. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (5, 2, 5, 1, 415)
  94. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (6, 3, 1, 2, 1900)
  95. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (7, 3, 2, 2, 45)
  96. INSERT [dbo].[OrderDetails] ([Id], [OrderId], [ProductId], [Quantity], [UnitCost]) VALUES (8, 5, 2, 20, 40)
  97. SET IDENTITY_INSERT [dbo].[OrderDetails] OFF
  98.  
  99. SET ANSI_NULLS ON
  100. GO
  101. SET QUOTED_IDENTIFIER ON
  102. GO
  103. CREATE TABLE [dbo].[FormerEmployee](
  104. [Id] [int] NOT NULL,
  105. [FirstName] [nvarchar](50) NOT NULL,
  106. [SecondName] [nvarchar](50) NULL,
  107. [LastName] [nvarchar](50) NULL,
  108. [Gender] [nchar](1) NULL,
  109. [BirthDate] [date] NULL,
  110. [Salary] [decimal](6, 2) NULL,
  111. [DepartmentId] [int] NULL,
  112. [HireDate] [date] NULL,
  113. [RelieveDate] [date] NULL,
  114. CONSTRAINT [PK_FormerEmployee] PRIMARY KEY CLUSTERED
  115. (
  116. [Id] ASC
  117. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  118. ) ON [PRIMARY]
  119. GO
  120. INSERT [dbo].[FormerEmployee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate]) VALUES (6, N'John', NULL, N'Miller', N'W', '1993-10-20', 2000.00, 4, '2013-03-27', '2014-10-06')
  121. INSERT [dbo].[FormerEmployee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate]) VALUES (11, N'Ann', NULL, N'Pritchett', N'M', '1980-05-21', 2400.00, 6, '2014-01-05', '2015-02-01')
  122.  
  123. SET ANSI_NULLS ON
  124. GO
  125. SET QUOTED_IDENTIFIER ON
  126. GO
  127. CREATE TABLE [dbo].[Employee](
  128. [Id] [int] IDENTITY(1,1) NOT NULL,
  129. [FirstName] [nvarchar](50) NOT NULL,
  130. [SecondName] [nvarchar](50) NULL,
  131. [LastName] [nvarchar](50) NULL,
  132. [Gender] [nchar](1) NULL,
  133. [BirthDate] [date] NULL,
  134. [Salary] [decimal](6, 2) NULL,
  135. [DepartmentId] [int] NULL,
  136. [HireDate] [date] NULL,
  137. [RelieveDate] [date] NULL,
  138. [Active] [bit] NULL,
  139. CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
  140. (
  141. [Id] ASC
  142. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  143. ) ON [PRIMARY]
  144. GO
  145. SET IDENTITY_INSERT [dbo].[Employee] ON
  146. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (1, N'Mary', NULL, N'Smith', N'W', '1985-12-18', 2000.00, 1, '2011-05-06', NULL, 1)
  147. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (2, N'Paul', N'George', N'Johnson', N'M', '1990-01-13', 1500.00, 3, '2011-10-29', NULL, 1)
  148. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (3, N'Patricia', NULL, N'Wilson', N'W', '1995-05-28', 1000.00, 4, '2012-01-24', '2013-11-25', 0)
  149. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (4, N'Linda', N'Lisa', N'Brown', N'W', '1983-07-11', 2700.00, 2, '2012-06-15', NULL, 1)
  150. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (5, N'Johnatan', NULL, N'Davis', N'M', '1978-01-24', 1200.00, 1, '2013-01-15', NULL, 1)
  151. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (6, N'John', NULL, N'Miller', NULL, '1993-10-20', 2000.00, 4, '2013-03-27', '2014-10-06', 0)
  152. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (7, N'Elizabeth', N'Dorothy', N'Taylor', N'W', '1992-09-09', 2110.00, 1, '2013-05-01', NULL, 1)
  153. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (8, N'James', NULL, N'Wilson', N'M', '1978-03-19', 1000.00, 3, '2013-10-09', '2014-03-01', 1)
  154. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (9, N'Robert', NULL, N'Anderson', N'M', '1989-12-13', 2900.00, 2, '2013-12-20', '2014-05-05', 0)
  155. INSERT [dbo].[Employee] ([Id], [FirstName], [SecondName], [LastName], [Gender], [BirthDate], [Salary], [DepartmentId], [HireDate], [RelieveDate], [Active]) VALUES (10, N'John', N'Mark', N'Smith', N'W', '1990-05-24', 2500.00, 1, '2014-01-24', NULL, 1)
  156. SET IDENTITY_INSERT [dbo].[Employee] OFF
  157.  
  158. SET ANSI_NULLS ON
  159. GO
  160. SET QUOTED_IDENTIFIER ON
  161. GO
  162. CREATE TABLE [dbo].[Department](
  163. [Id] [int] IDENTITY(1,1) NOT NULL,
  164. [Name] [nvarchar](50) NOT NULL,
  165. [ManagerId] [int] NULL,
  166. [CityId] [int] NULL,
  167. CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED
  168. (
  169. [Id] ASC
  170. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  171. ) ON [PRIMARY]
  172. GO
  173. SET IDENTITY_INSERT [dbo].[Department] ON
  174. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (1, N'IT', 5, 2)
  175. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (2, N'Accounting', 4, NULL)
  176. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (3, N'HR', 8, 2)
  177. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (4, N'Marketing', 3, 1)
  178. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (5, N'Controlling', 11, 3)
  179. INSERT [dbo].[Department] ([Id], [Name], [ManagerId], [CityId]) VALUES (6, N'Data Warehouse', 5, 4)
  180. SET IDENTITY_INSERT [dbo].[Department] OFF
  181.  
  182. SET ANSI_NULLS ON
  183. GO
  184. SET QUOTED_IDENTIFIER ON
  185. GO
  186. CREATE TABLE [dbo].[Customer](
  187. [Id] [int] IDENTITY(1,1) NOT NULL,
  188. [Name] [nvarchar](50) NOT NULL,
  189. [PhoneNumber] [nvarchar](50) NOT NULL,
  190. CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
  191. (
  192. [Id] ASC
  193. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  194. ) ON [PRIMARY]
  195. GO
  196.  
  197. SET ANSI_NULLS ON
  198. GO
  199. SET QUOTED_IDENTIFIER ON
  200. GO
  201. CREATE TABLE [dbo].[Company](
  202. [Id] [int] IDENTITY(1,1) NOT NULL,
  203. [Name] [nvarchar](50) NOT NULL,
  204. [Street] [nvarchar](50) NULL,
  205. [Number] [nvarchar](50) NULL,
  206. [PostCode] [nvarchar](50) NULL,
  207. [CityId] [int] NULL,
  208. [StartDate] [date] NULL,
  209. [EmployeeCount] [int] NULL,
  210. [AnnualIncome] [int] NULL,
  211. [Active] [bit] NOT NULL,
  212. CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED
  213. (
  214. [Id] ASC
  215. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  216. ) ON [PRIMARY]
  217. GO
  218. SET IDENTITY_INSERT [dbo].[Company] ON
  219. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (1, N'Casio', N'Akacjowa', N'10', N'54-621', 5, '1993-03-18', 1000, 145000, 1)
  220. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (2, N'Kawasaki', N'Brzozowa', N'12/5', N'69-586', 3, '2001-05-25', 570, 596000, 1)
  221. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (3, N'Prada', N'Holenderska', N'18B', N'59-100', 4, '1982-03-17', 1350, 120000, 1)
  222. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (4, N'Nokia', N'Tr�jk�tna', N'16/9', N'68-487', 5, '2005-08-19', 800, 65000, 1)
  223. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (5, N'Tesco', N'Lipowa', N'56', N'36-895', 2, '2008-12-12', 450, 89000, 1)
  224. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (6, N'Shell', N'Nied�wiedzia', N'12', N'47-895', 3, '1999-10-30', 1100, 19000, 1)
  225. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (7, N'Pepsi', N'H�aski', N'84', N'56-156', NULL, '2011-05-13', 790, 300000, 1)
  226. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (8, N'Lenovo Group', N'Grecka', N'129', N'69-895', 4, '2008-01-19', 900, 78000, 0)
  227. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (9, N'Kyocera', NULL, N'15/85', N'54-785', 2, '1999-01-24', 1500, 12000, 1)
  228. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (10, N'Motorola', N'Lotnicza', N'12B/5', N'78-695', 5, NULL, 2000, 36000, 1)
  229. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (11, N'Xerox', N'Topolowa', N'13', N'56-469', 1, '2004-09-09', 1700, 69000, 1)
  230. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (12, N'Phillips', N'S�owia�ska', N'54', N'65-916', NULL, '2000-09-28', 850, 80000, 1)
  231. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (13, N'Red Hat', N'Brzozowa', N'1', N'54-608', 1, '1998-08-31', 290, 29000, 1)
  232. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (14, N'Skanska', N'Lotnicza', N'17A/8', N'63-896', 4, '2010-02-14', 670, 47000, 0)
  233. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (15, N'Vodafone', N'Rodziewicz�wny', N'26', N'759-62', 3, NULL, 800, 19000, 1)
  234. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (16, N'Yamaha', N'Kolista', N'53', N'75-647', 3, '1980-07-14', 1350, 299000, 1)
  235. INSERT [dbo].[Company] ([Id], [Name], [Street], [Number], [PostCode], [CityId], [StartDate], [EmployeeCount], [AnnualIncome], [Active]) VALUES (17, N'Twitter', N'Sosnowa', N'18/6', N'68-954', 5, '2013-01-15', 1900, 48000, 1)
  236. SET IDENTITY_INSERT [dbo].[Company] OFF
  237.  
  238. SET ANSI_NULLS ON
  239. GO
  240. SET QUOTED_IDENTIFIER ON
  241. GO
  242. CREATE TABLE [dbo].[City](
  243. [Id] [int] IDENTITY(1,1) NOT NULL,
  244. [Name] [nvarchar](50) NOT NULL,
  245. CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED
  246. (
  247. [Id] ASC
  248. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  249. ) ON [PRIMARY]
  250. GO
  251. SET IDENTITY_INSERT [dbo].[City] ON
  252. INSERT [dbo].[City] ([Id], [Name]) VALUES (1, N'New York')
  253. INSERT [dbo].[City] ([Id], [Name]) VALUES (2, N'Warsaw')
  254. INSERT [dbo].[City] ([Id], [Name]) VALUES (3, N'London')
  255. INSERT [dbo].[City] ([Id], [Name]) VALUES (4, N'Paris')
  256. INSERT [dbo].[City] ([Id], [Name]) VALUES (5, N'Venice')
  257. SET IDENTITY_INSERT [dbo].[City] OFF
  258.  
  259. SET ANSI_NULLS ON
  260. GO
  261. SET QUOTED_IDENTIFIER ON
  262. GO
  263. CREATE TABLE [dbo].[ArchivedProduct](
  264. [Id] [int] NOT NULL,
  265. [Name] [nvarchar](50) NOT NULL,
  266. [Price] [numeric](18, 0) NOT NULL,
  267. [CategoryId] [int] NOT NULL
  268. ) ON [PRIMARY]
  269. GO
  270. INSERT [dbo].[ArchivedProduct] ([Id], [Name], [Price], [CategoryId]) VALUES (3, N'Keyboard', 300, 2)
  271. INSERT [dbo].[ArchivedProduct] ([Id], [Name], [Price], [CategoryId]) VALUES (6, N'Monitor', 900, 2)
  272.  
  273. ALTER TABLE [dbo].[Company] ADD CONSTRAINT [DF_Company_Active] DEFAULT ((1)) FOR [Active]
  274. GO
  275.  
  276. ALTER TABLE [dbo].[Employee] ADD CONSTRAINT [DF_Employee_Active] DEFAULT ((1)) FOR [Active]
  277. GO
  278.  
  279. CREATE DATABASE Library;
  280. GO
  281. USE [Library]
  282. GO
  283.  
  284. SET ANSI_NULLS ON
  285. GO
  286. SET QUOTED_IDENTIFIER ON
  287. GO
  288.  
  289. CREATE TABLE [dbo].[Reader](
  290. [Id] [int] IDENTITY(1,1) NOT NULL,
  291. [CardNumber] [nvarchar](50) NULL,
  292. [FirstName] [nvarchar](50) NULL,
  293. [SecondName] [nvarchar](50) NULL,
  294. [LastName] [nvarchar](50) NULL,
  295. [Gender] [char](1) NULL,
  296. [Street] [nvarchar](50) NULL,
  297. [Number] [nvarchar](50) NULL,
  298. [City] [nvarchar](50) NULL,
  299. [BirthDate] [datetime] NULL,
  300. [SignInDate] [datetime] NULL,
  301. [SignOutDate] [datetime] NULL
  302. ) ON [PRIMARY]
  303. GO
  304. SET ANSI_PADDING OFF
  305. GO
  306. SET IDENTITY_INSERT [dbo].[Reader] ON
  307. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (1, N'CBW/256', N'Mario', NULL, N'Draghi', N'M', N'Akacjowa', N'12', N'Wroc�aw', '1978-01-24', '2013-02-25', NULL)
  308. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (2, N'CBW/290', N'Sergey', N'Timothy', N'Brin', N'M', N'Lipowa', N'34/2', N'Pozna�', '1992-04-12', '2010-06-12', '2015-06-23')
  309. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (3, N'CBW/376', N'Dilma', NULL, N'Rousseff', N'W', N'Czekoladowa', N'1', N'Wroc�aw', '2000-05-01', '2014-09-19', NULL)
  310. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (4, N'CBW/129', N'Rupert', NULL, N'Murdoch', N'M', N'Karmelkowa', N'11B', N'Wroc�aw', '1990-12-24', '2010-08-11', '2014-02-01')
  311. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (5, N'CBW/400', N'Christine', N'Anne', N'Lagarde', N'W', N'Brzozowa', N'176/23', N'Legnica', '1995-08-31', '2015-01-24', NULL)
  312. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (6, N'CBW/189', N'Ginni ', NULL, N'Rometty', N'W', N'Kasztanowa', N'90', N'Krak�w', '1999-09-02', '2013-02-19', NULL)
  313. INSERT [dbo].[Reader] ([Id], [CardNumber], [FirstName], [SecondName], [LastName], [Gender], [Street], [Number], [City], [BirthDate], [SignInDate], [SignOutDate]) VALUES (7, N'CBW/230', N'Mary', NULL, N'Barrahi', N'W', N'Listopadowa', N'14', N'Wroc�aw', '1997-04-19', '2013-05-09', NULL)
  314. SET IDENTITY_INSERT [dbo].[Reader] OFF
  315.  
  316. SET ANSI_NULLS ON
  317. GO
  318. SET QUOTED_IDENTIFIER ON
  319. GO
  320. CREATE TABLE [dbo].[Parameter](
  321. [BookLimit] [int] NULL
  322. ) ON [PRIMARY]
  323. GO
  324. INSERT [dbo].[Parameter] ([BookLimit]) VALUES (4)
  325.  
  326. SET ANSI_NULLS ON
  327. GO
  328. SET QUOTED_IDENTIFIER ON
  329. GO
  330. CREATE TABLE [dbo].[Loan](
  331. [Id] [int] IDENTITY(1,1) NOT NULL,
  332. [BookCopyId] [int] NULL,
  333. [ReaderId] [int] NULL,
  334. [EmployeeId] [int] NULL,
  335. [LoanDate] [datetime] NULL,
  336. [ExpectedReturnDate] [datetime] NULL,
  337. [ActualReturnDate] [datetime] NULL,
  338. CONSTRAINT [PK_Loan] PRIMARY KEY CLUSTERED
  339. (
  340. [Id] ASC
  341. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  342. ) ON [PRIMARY]
  343. GO
  344. SET IDENTITY_INSERT [dbo].[Loan] ON
  345. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (1, 1, 7, 1, CAST(0x00009FAC00000000 AS DateTime), CAST(0x00009FEA00000000 AS DateTime), CAST(0x00009FF800000000 AS DateTime))
  346. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (2, 3, 2, 2, CAST(0x0000A0C600000000 AS DateTime), CAST(0x0000A0E400000000 AS DateTime), CAST(0x0000A0E200000000 AS DateTime))
  347. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (3, 3, 3, 2, CAST(0x00009DA900000000 AS DateTime), CAST(0x00009DC800000000 AS DateTime), CAST(0x00009E0D00000000 AS DateTime))
  348. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (4, 16, 5, 5, CAST(0x0000A2D300000000 AS DateTime), CAST(0x0000A2EF00000000 AS DateTime), NULL)
  349. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (5, 14, 3, 1, CAST(0x0000A20000000000 AS DateTime), CAST(0x0000A25C00000000 AS DateTime), CAST(0x0000A32A00000000 AS DateTime))
  350. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (6, 9, 1, 4, CAST(0x0000A49B00000000 AS DateTime), CAST(0x0000A4BA00000000 AS DateTime), NULL)
  351. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (7, 18, 5, 1, CAST(0x0000A13000000000 AS DateTime), CAST(0x0000A14F00000000 AS DateTime), CAST(0x0000A14F00000000 AS DateTime))
  352. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (8, 7, 2, 1, CAST(0x0000A1AE00000000 AS DateTime), CAST(0x0000A1CC00000000 AS DateTime), CAST(0x0000A1CC00000000 AS DateTime))
  353. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (9, 18, 6, 4, CAST(0x0000A05700000000 AS DateTime), CAST(0x0000A07600000000 AS DateTime), CAST(0x0000A07600000000 AS DateTime))
  354. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (10, 1, 3, 5, CAST(0x0000A1EC00000000 AS DateTime), CAST(0x0000A20A00000000 AS DateTime), NULL)
  355. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (11, 12, 6, 2, CAST(0x0000A11800000000 AS DateTime), CAST(0x0000A13600000000 AS DateTime), CAST(0x0000A14C00000000 AS DateTime))
  356. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (12, 9, 3, 1, CAST(0x0000A38A00000000 AS DateTime), CAST(0x0000A3A900000000 AS DateTime), NULL)
  357. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (13, 4, 7, 4, CAST(0x0000A42A00000000 AS DateTime), CAST(0x0000A44900000000 AS DateTime), NULL)
  358. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (14, 2, 3, 5, CAST(0x0000A3C800000000 AS DateTime), CAST(0x0000A3E700000000 AS DateTime), NULL)
  359. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (15, 1, 7, 4, CAST(0x0000A46D00000000 AS DateTime), CAST(0x0000A48B00000000 AS DateTime), NULL)
  360. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (16, 10, 3, 5, CAST(0x0000A28700000000 AS DateTime), CAST(0x0000A2A600000000 AS DateTime), NULL)
  361. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (17, 7, 6, 2, CAST(0x0000A0DB00000000 AS DateTime), CAST(0x0000A0F900000000 AS DateTime), CAST(0x0000A0F900000000 AS DateTime))
  362. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (18, 11, 2, 5, CAST(0x0000A1DE00000000 AS DateTime), CAST(0x0000A0F900000000 AS DateTime), CAST(0x0000A12200000000 AS DateTime))
  363. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (19, 14, 7, 4, CAST(0x00009D0400000000 AS DateTime), CAST(0x00009D2300000000 AS DateTime), CAST(0x00009D2300000000 AS DateTime))
  364. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (20, 3, 2, 4, CAST(0x0000A45300000000 AS DateTime), CAST(0x0000A49000000000 AS DateTime), NULL)
  365. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (21, 16, 2, 2, CAST(0x0000A47F00000000 AS DateTime), CAST(0x0000A49A00000000 AS DateTime), NULL)
  366. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (22, 9, 1, 2, CAST(0x0000A3FA00000000 AS DateTime), CAST(0x0000A41900000000 AS DateTime), NULL)
  367. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (23, 14, 5, 4, CAST(0x00009FE700000000 AS DateTime), CAST(0x0000A00600000000 AS DateTime), CAST(0x0000A00600000000 AS DateTime))
  368. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (24, 10, 7, 1, CAST(0x0000A2DA00000000 AS DateTime), CAST(0x0000A2F600000000 AS DateTime), CAST(0x0000A3B800000000 AS DateTime))
  369. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (25, 3, 5, 5, CAST(0x0000A32200000000 AS DateTime), CAST(0x0000A34100000000 AS DateTime), NULL)
  370. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (26, 6, 1, 4, CAST(0x0000A17300000000 AS DateTime), CAST(0x0000A18F00000000 AS DateTime), NULL)
  371. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (27, 6, 2, 1, CAST(0x0000A0CA00000000 AS DateTime), CAST(0x0000A0E800000000 AS DateTime), CAST(0x0000A0CF00000000 AS DateTime))
  372. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (28, 14, 1, 5, CAST(0x0000A39400000000 AS DateTime), CAST(0x0000A3B300000000 AS DateTime), NULL)
  373. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (29, 1, 7, 4, CAST(0x0000A47900000000 AS DateTime), CAST(0x0000A49700000000 AS DateTime), NULL)
  374. INSERT [dbo].[Loan] ([Id], [BookCopyId], [ReaderId], [EmployeeId], [LoanDate], [ExpectedReturnDate], [ActualReturnDate]) VALUES (30, 8, 3, 3, CAST(0x0000A0BE00000000 AS DateTime), CAST(0x0000A0DC00000000 AS DateTime), NULL)
  375. SET IDENTITY_INSERT [dbo].[Loan] OFF
  376.  
  377. SET ANSI_NULLS ON
  378. GO
  379. SET QUOTED_IDENTIFIER ON
  380. GO
  381. CREATE TABLE [dbo].[Genre](
  382. [Id] [int] IDENTITY(1,1) NOT NULL,
  383. [Name] [nvarchar](50) NULL,
  384. CONSTRAINT [PK_Genre] PRIMARY KEY CLUSTERED
  385. (
  386. [Id] ASC
  387. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  388. ) ON [PRIMARY]
  389. GO
  390. SET IDENTITY_INSERT [dbo].[Genre] ON
  391. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (1, N'Horror')
  392. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (2, N'History')
  393. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (3, N'Fantasy')
  394. SET IDENTITY_INSERT [dbo].[Genre] OFF
  395.  
  396. SET ANSI_NULLS ON
  397. GO
  398. SET QUOTED_IDENTIFIER ON
  399. GO
  400. CREATE TABLE [dbo].[Employee](
  401. [Id] [int] IDENTITY(1,1) NOT NULL,
  402. [FirstName] [nvarchar](50) NULL,
  403. [LastName] [nvarchar](50) NULL,
  404. [ManagerId] [int] NULL,
  405. CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
  406. (
  407. [Id] ASC
  408. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  409. ) ON [PRIMARY]
  410. GO
  411. SET IDENTITY_INSERT [dbo].[Employee] ON
  412. INSERT [dbo].[Employee] ([Id], [FirstName], [LastName], [ManagerId]) VALUES (1, N'John', N'Wilson', 1)
  413. INSERT [dbo].[Employee] ([Id], [FirstName], [LastName], [ManagerId]) VALUES (2, N'Mary', N'Gordon', 1)
  414. INSERT [dbo].[Employee] ([Id], [FirstName], [LastName], [ManagerId]) VALUES (3, N'Jack', N'Black', 3)
  415. INSERT [dbo].[Employee] ([Id], [FirstName], [LastName], [ManagerId]) VALUES (4, N'Ginny', N'Thompson', 1)
  416. INSERT [dbo].[Employee] ([Id], [FirstName], [LastName], [ManagerId]) VALUES (5, N'Suzy', N'Bass', 3)
  417. SET IDENTITY_INSERT [dbo].[Employee] OFF
  418.  
  419. SET ANSI_NULLS ON
  420. GO
  421. SET QUOTED_IDENTIFIER ON
  422. GO
  423. CREATE TABLE [dbo].[BookRating](
  424. [Id] [int] IDENTITY(1,1) NOT NULL,
  425. [BookId] [int] NULL,
  426. [ReaderId] [int] NULL,
  427. [Rating] [numeric](18, 0) NULL,
  428. [RatingDate] [datetime] NULL,
  429. CONSTRAINT [PK_BookRate] PRIMARY KEY CLUSTERED
  430. (
  431. [Id] ASC
  432. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  433. ) ON [PRIMARY]
  434. GO
  435. SET IDENTITY_INSERT [dbo].[BookRating] ON
  436. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (1, 1, 3, 3, CAST(0x0000A1EC00000000 AS DateTime))
  437. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (2, 1, 7, 4, CAST(0x00009FAC00000000 AS DateTime))
  438. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (3, 1, 7, 3, CAST(0x0000A46D00000000 AS DateTime))
  439. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (5, 2, 3, 2, CAST(0x0000A3C800000000 AS DateTime))
  440. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (6, 3, 2, 4, CAST(0x0000A0C600000000 AS DateTime))
  441. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (7, 3, 2, 5, CAST(0x0000A45300000000 AS DateTime))
  442. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (9, 4, 6, 2, CAST(0x0000A13000000000 AS DateTime))
  443. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (10, 4, 6, 1, CAST(0x0000A05700000000 AS DateTime))
  444. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (11, 4, 7, 4, CAST(0x0000A42A00000000 AS DateTime))
  445. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (12, 5, 2, 5, CAST(0x0000A0CA00000000 AS DateTime))
  446. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (13, 5, 3, 3, CAST(0x00009DA900000000 AS DateTime))
  447. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (14, 7, 1, 4, CAST(0x0000A17300000000 AS DateTime))
  448. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (15, 7, 1, 2, CAST(0x0000A39400000000 AS DateTime))
  449. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (16, 7, 3, 1, CAST(0x0000A20000000000 AS DateTime))
  450. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (18, 7, 7, 4, CAST(0x00009D0400000000 AS DateTime))
  451. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (19, 8, 2, 3, CAST(0x0000A1AE00000000 AS DateTime))
  452. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (20, 8, 6, 5, CAST(0x0000A0DB00000000 AS DateTime))
  453. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (21, 9, 3, 4, CAST(0x0000A0BE00000000 AS DateTime))
  454. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (22, 10, 1, 1, CAST(0x0000A3FA00000000 AS DateTime))
  455. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (23, 10, 1, 3, CAST(0x0000A49B00000000 AS DateTime))
  456. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (24, 10, 3, 2, CAST(0x0000A38A00000000 AS DateTime))
  457. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (25, 11, 2, 1, CAST(0x0000A47F00000000 AS DateTime))
  458. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (28, 11, 7, 5, CAST(0x0000A2DA00000000 AS DateTime))
  459. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (29, 13, 2, 4, CAST(0x0000A1DE00000000 AS DateTime))
  460. INSERT [dbo].[BookRating] ([Id], [BookId], [ReaderId], [Rating], [RatingDate]) VALUES (30, 14, 6, 3, CAST(0x0000A11800000000 AS DateTime))
  461. SET IDENTITY_INSERT [dbo].[BookRating] OFF
  462.  
  463. SET ANSI_NULLS ON
  464. GO
  465. SET QUOTED_IDENTIFIER ON
  466. GO
  467. CREATE TABLE [dbo].[Book](
  468. [Id] [int] IDENTITY(1,1) NOT NULL,
  469. [Author] [nvarchar](50) NOT NULL,
  470. [Title] [nvarchar](50) NOT NULL,
  471. [GenreId] [int] NOT NULL,
  472. CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
  473. (
  474. [Id] ASC
  475. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  476. ) ON [PRIMARY]
  477. GO
  478. SET IDENTITY_INSERT [dbo].[Book] ON
  479. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (1, N'Steven King', N'Pet Sematary', 1)
  480. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (2, N'Terry Pratchett', N'Wyrd Sisters', 3)
  481. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (3, N'Ira Levin', N'Rosemary''s Baby', 1)
  482. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (4, N'Thomas Harris', N'Red Dragon', 1)
  483. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (5, N'Robin Hobb', N'Golden Fool', 3)
  484. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (7, N'Barbara Tuchman', N'The Guns of August', 2)
  485. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (8, N'Norman Davies', N'Europe', 2)
  486. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (9, N'Steven King', N'The Mist', 1)
  487. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (10, N'Dean Koontz', N'Watchers', 1)
  488. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (11, N'Ilona Andrews', N'Magic Bites', 3)
  489. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (13, N'Terry Pratchett', N'The Truth', 3)
  490. INSERT [dbo].[Book] ([Id], [Author], [Title], [GenreId]) VALUES (14, N'Antony Beevor', N'The Fall of Berlin 1945', 2)
  491. SET IDENTITY_INSERT [dbo].[Book] OFF
  492.  
  493. SET ANSI_NULLS ON
  494. GO
  495. SET QUOTED_IDENTIFIER ON
  496. GO
  497. CREATE TABLE [dbo].[BookCopy](
  498. [Id] [int] NOT NULL,
  499. [BookId] [int] NULL,
  500. [Number] [nvarchar](50) NULL,
  501. [PurchaseDate] [datetime] NULL,
  502. [PurchasePrice] [decimal](8, 2) NULL,
  503. [Availaible] [bit] NULL,
  504. CONSTRAINT [PK_BookCopy] PRIMARY KEY CLUSTERED
  505. (
  506. [Id] ASC
  507. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  508. ) ON [PRIMARY]
  509. GO
  510. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (1, 1, N'B/13/2000', CAST(0x00008FAB00000000 AS DateTime), 32.00, 1)
  511. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (2, 2, N'B/9/2005', CAST(0x000096C000000000 AS DateTime), 25.00, 1)
  512. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (3, 3, N'B/56/2011', CAST(0x00009FB200000000 AS DateTime), 28.00, 1)
  513. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (4, 4, N'B/132/2012', CAST(0x0000A09500000000 AS DateTime), 27.00, 1)
  514. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (5, 5, N'B/56/2012', CAST(0x0000A03600000000 AS DateTime), 20.00, 1)
  515. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (6, 7, N'B/78/2011', CAST(0x00009EB100000000 AS DateTime), 40.00, 1)
  516. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (7, 8, N'B/18/2014', CAST(0x0000A3E100000000 AS DateTime), 39.00, 1)
  517. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (8, 9, N'B/76/2013', CAST(0x0000A20900000000 AS DateTime), 28.00, 0)
  518. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (9, 10, N'B/18/2012', CAST(0x0000A0D300000000 AS DateTime), 30.00, 1)
  519. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (10, 11, N'B/279/2014', CAST(0x0000A3BE00000000 AS DateTime), 36.00, 1)
  520. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (11, 13, N'B/156/2015', CAST(0x0000A51100000000 AS DateTime), 43.00, 0)
  521. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (12, 14, N'B/99/2015', CAST(0x0000A4E800000000 AS DateTime), 20.00, 1)
  522. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (13, 4, N'B/47/2010', CAST(0x00009D5C00000000 AS DateTime), 27.00, 1)
  523. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (14, 7, N'B/16/2009', CAST(0x00009C4800000000 AS DateTime), 31.00, 1)
  524. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (15, 8, N'B/189/2012', CAST(0x0000A12500000000 AS DateTime), 34.00, 1)
  525. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (16, 11, N'B/12/2010', CAST(0x00009DF100000000 AS DateTime), 41.00, 1)
  526. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (17, 13, N'B/78/2015', CAST(0x0000A4E600000000 AS DateTime), 20.00, 1)
  527. INSERT [dbo].[BookCopy] ([Id], [BookId], [Number], [PurchaseDate], [PurchasePrice], [Availaible]) VALUES (18, 4, N'B/35/2011', CAST(0x00009E8B00000000 AS DateTime), 25.00, 1)
  528.  
  529. ALTER TABLE [dbo].[BookCopy] ADD CONSTRAINT [DF_BookCopy_Availaible] DEFAULT ((1)) FOR [Availaible]
  530. GO
  531.  
  532. ALTER TABLE [dbo].[Book] WITH CHECK ADD CONSTRAINT [FK_Book_Genre] FOREIGN KEY([GenreId])
  533. REFERENCES [dbo].[Genre] ([Id])
  534. GO
  535. ALTER TABLE [dbo].[Book] CHECK CONSTRAINT [FK_Book_Genre]
  536. GO
  537.  
  538. ALTER TABLE [dbo].[BookCopy] WITH CHECK ADD CONSTRAINT [FK_BookCopy_Book] FOREIGN KEY([BookId])
  539. REFERENCES [dbo].[Book] ([Id])
  540. GO
  541. ALTER TABLE [dbo].[BookCopy] CHECK CONSTRAINT [FK_BookCopy_Book]
  542. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!