pushrbx icon

DS Populate tables

pushrbx | PRO | 11/08/13 04:41:31 PM UTC | 0 ⭐ | 382 👁️ | Never ⏰ | []
SQL |

3.87 KB

|

None

|

0 👍

/

0 👎

USE [bookstore]
GO
SET IDENTITY_INSERT [dbo].[Document] ON 
 
INSERT [dbo].[Document] ([DocId], [Name], [STATUS]) VALUES (1, N'Coppelion 03', 1)
SET IDENTITY_INSERT [dbo].[Document] OFF
SET IDENTITY_INSERT [dbo].[Page] ON 
 
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (1, 0, 1, N'images/069.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (2, 1, 1, N'images/070.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (3, 2, 1, N'images/071.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (4, 3, 1, N'images/072.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (5, 4, 1, N'images/073.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (6, 5, 1, N'images/074.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (7, 6, 1, N'images/075.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (8, 7, 1, N'images/076.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (9, 8, 1, N'images/077.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (10, 9, 1, N'images/078.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (11, 10, 1, N'images/079.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (12, 11, 1, N'images/080.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (13, 12, 1, N'images/081.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (14, 13, 1, N'images/082.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (15, 14, 1, N'images/083.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (16, 15, 1, N'images/084.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (17, 16, 1, N'images/085.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (18, 17, 1, N'images/086.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (19, 18, 1, N'images/087.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (20, 19, 1, N'images/088.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (21, 20, 1, N'images/089.jpg')
INSERT [dbo].[Page] ([pageId], [pageNumber], [docId], [imagePath]) VALUES (22, 21, 1, N'images/090.jpg')
SET IDENTITY_INSERT [dbo].[Page] OFF
SET IDENTITY_INSERT [dbo].[Line] ON 
 
INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (1, 1)
INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (2, 2)
INSERT [dbo].[Line] ([lineId], [lineNumber]) VALUES (3, 3)
SET IDENTITY_INSERT [dbo].[Line] OFF
SET IDENTITY_INSERT [dbo].[Word] ON 
 
INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (1, 0, 0, 3, 3, N'won''t')
INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (2, 0, 0, 3, 3, N'you')
INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (3, 0, 0, 3, 3, N'all')
INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (4, 0, 0, 2, 1, N'brand')
INSERT [dbo].[Word] ([wordId], [OffsetX], [OffsetY], [EndX], [EndY], [text]) VALUES (5, 0, 5, 6, 6, N'please')
SET IDENTITY_INSERT [dbo].[Word] OFF
INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (1, 1)
INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (2, 1)
INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (3, 1)
INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (4, 1)
INSERT [dbo].[WordToLine] ([wordId], [lineId]) VALUES (5, 1)
INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (1, 2)
INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (2, 2)
INSERT [dbo].[LineToPage] ([lineId], [pageId]) VALUES (3, 2)

Comments