PRINT(N'Add 103669 rows to [dbo].[HistoricalAthletes]') INSERT INTO [dbo].[HistoricalAthletes] ([HistoricalAthleteId], [DateOfCreation], [Username], [UserFullName], [AthleteId], [AssociationId], [AthleteName], [RingNumber], [AgeCategoryId], [CategoryId], [CountryId], [TrainerId], [OwnerId], [MemberId], [isDisqualified], [isSuspended], [isOffline], [RingTypeId], [BibNumber], [MgRing], [RfidTag], [RegisteredSeasonId], [Notes], [HairTypeId], [ColorId], [Sex], [DateOfBirth], [PersonalBestTime], [MobilePhone], [Email]) VALUES ('434e66b5-b158-40ae-9157-00001596d58d', '2016-12-12 08:28:58.337', N'J.ALJASMI', N'Jassim Ahmed', 'e953672c-e726-4307-b7cd-5ff11739017c', 'AD', N'M17', N'17BINTMARRAW2016', 'FA', 'TE', 'UAE', '005531e5-94e6-4a53-a393-21ecd443b1e7', 'c1bd53bc-54c8-467c-b408-6ceb8659d9a1', NULL, 0, 0, 0, 'AD', 2817, 'AD-2817', 'E20030980107013416007130', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) INSERT INTO [dbo].[HistoricalAthletes] ([HistoricalAthleteId], [DateOfCreation], [Username], [UserFullName], [AthleteId], [AssociationId], [AthleteName], [RingNumber], [AgeCategoryId], [CategoryId], [CountryId], [TrainerId], [OwnerId], [MemberId], [isDisqualified], [isSuspended], [isOffline], [RingTypeId], [BibNumber], [MgRing], [RfidTag], [RegisteredSeasonId], [Notes], [HairTypeId], [ColorId], [Sex], [DateOfBirth], [PersonalBestTime], [MobilePhone], [Email]) VALUES ('b16f2135-0b88-469c-83f5-0000d8b77812', '2017-12-28 16:40:08.023', N'TAHER', N'taher', 'db13483b-6292-4ef9-a271-f6ddf660605e', 'AD', N'افران', N'915BOBCREESEW17', 'FA', 'KA', 'UAE', 'dda5dbee-5393-4f93-9acf-73eeb287a79e', '12d62444-0562-4535-9325-e536c18418c3', NULL, 0, 0, 0, 'AD', 3275, 'AD-3275', 'E2003098010501551140A6D1', 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) CREATE TABLE [dbo].[HistoricalAthletes]( [HistoricalAthleteId] [uniqueidentifier] ROWGUIDCOL NOT NULL, [DateOfCreation] [datetime] NOT NULL, [Username] [nvarchar](20) NOT NULL, [UserFullName] [nvarchar](20) NOT NULL, [AthleteId] [uniqueidentifier] NULL, [AssociationId] [varchar](2) NULL, [AthleteName] [nvarchar](128) NULL, [RingNumber] [nvarchar](48) NULL, [AgeCategoryId] [varchar](2) NULL, [CategoryId] [varchar](2) NULL, [CountryId] [varchar](3) NULL, [TrainerId] [uniqueidentifier] NULL, [OwnerId] [uniqueidentifier] NULL, [MemberId] [uniqueidentifier] NULL, [isDisqualified] [bit] NULL, [isSuspended] [bit] NULL, [isOffline] [bit] NULL, [RingTypeId] [varchar](2) NULL, [BibNumber] [int] NULL, [MgRing] [varchar](33) NULL, [RfidTag] [varchar](24) NULL, [RegisteredSeasonId] [int] NULL, [Notes] [nvarchar](max) NULL, [HairTypeId] [varchar](2) NULL, [ColorId] [varchar](2) NULL, [Sex] [varchar](1) NULL, [DateOfBirth] [date] NULL, [PersonalBestTime] [time](7) NULL, [MobilePhone] [nvarchar](25) NULL, [Email] [nvarchar](128) NULL, CONSTRAINT [PK_HistoricalAthletes] PRIMARY KEY CLUSTERED ( [HistoricalAthleteId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO