Advertisement
pushrbx

DS Populate tables

Nov 8th, 2013
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.87 KB | None | 0 0
  1. USE [bookstore]
  2. GO
  3. SET IDENTITY_INSERT [dbo].[Document] ON
  4.  
  5. INSERT [dbo].[Document] ([DocId], [Name], [STATUS]) VALUES (1, N'Coppelion 03', 1)
  6. SET IDENTITY_INSERT [dbo].[Document] OFF
  7. SET IDENTITY_INSERT [dbo].[Page] ON
  8.  
  9. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (1, 0, 1, N'images/069.jpg')
  10. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (2, 1, 1, N'images/070.jpg')
  11. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (3, 2, 1, N'images/071.jpg')
  12. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (4, 3, 1, N'images/072.jpg')
  13. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (5, 4, 1, N'images/073.jpg')
  14. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (6, 5, 1, N'images/074.jpg')
  15. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (7, 6, 1, N'images/075.jpg')
  16. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (8, 7, 1, N'images/076.jpg')
  17. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (9, 8, 1, N'images/077.jpg')
  18. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (10, 9, 1, N'images/078.jpg')
  19. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (11, 10, 1, N'images/079.jpg')
  20. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (12, 11, 1, N'images/080.jpg')
  21. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (13, 12, 1, N'images/081.jpg')
  22. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (14, 13, 1, N'images/082.jpg')
  23. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (15, 14, 1, N'images/083.jpg')
  24. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (16, 15, 1, N'images/084.jpg')
  25. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (17, 16, 1, N'images/085.jpg')
  26. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (18, 17, 1, N'images/086.jpg')
  27. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (19, 18, 1, N'images/087.jpg')
  28. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (20, 19, 1, N'images/088.jpg')
  29. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (21, 20, 1, N'images/089.jpg')
  30. INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (22, 21, 1, N'images/090.jpg')
  31. SET IDENTITY_INSERT [dbo].[Page] OFF
  32. SET IDENTITY_INSERT [dbo].[Line] ON
  33.  
  34. INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (1, 1)
  35. INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (2, 2)
  36. INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (3, 3)
  37. SET IDENTITY_INSERT [dbo].[Line] OFF
  38. SET IDENTITY_INSERT [dbo].[Word] ON
  39.  
  40. INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (1, 0, 0, 3, 3, N'won''t')
  41. INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (2, 0, 0, 3, 3, N'you')
  42. INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (3, 0, 0, 3, 3, N'all')
  43. INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (4, 0, 0, 2, 1, N'brand')
  44. INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (5, 0, 5, 6, 6, N'please')
  45. SET IDENTITY_INSERT [dbo].[Word] OFF
  46. INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (1, 1)
  47. INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (2, 1)
  48. INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (3, 1)
  49. INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (4, 1)
  50. INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (5, 1)
  51. INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (1, 2)
  52. INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (2, 2)
  53. INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (3, 2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement