От: | EyfelFenk | ||
Дата: | 25.03.10 10:38 | ||
Оценка: |
Error 4 Error 2016: Condition cannot be specified for Column member 'player_id_1' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1223 13 ROIServerDLL
Error 5 Error 2016: Condition cannot be specified for Column member 'player_id_2' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1232 13 ROIServerDLL
Error 6 Error 2016: Condition cannot be specified for Column member 'command_id_1' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1249 13 ROIServerDLL
Error 7 Error 2016: Condition cannot be specified for Column member 'command_id_2' because it is marked with a 'Computed' or 'Identity' StoreGeneratedPattern. C:\WorkFiles\Juggers\VS\RoomOfInquisitor\roi\ROIServerDLL\ServerDBModel.edmx 1258 13 ROIServerDLL
USE [jugger]
GO
/****** Object: Table [dbo].[tr_fights] Script Date: 03/25/2010 13:37:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tr_fights](
[id] [int] IDENTITY(1,1) NOT NULL,
[part_id] [int] NOT NULL,
[command_id_1] [int] NULL,
[command_id_2] [int] NULL,
[player_id_1] [int] NULL,
[player_id_2] [int] NULL,
[winner_id] [int] NOT NULL,
[guid] [varchar](50) NOT NULL,
[linktolog] [varchar](100) NULL,
[seria_guid] [varchar](50) NOT NULL,
CONSTRAINT [PK_tr_fights] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ссылка на лог боя' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights', @level2type=N'COLUMN',@level2name=N'linktolog'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Идентификатор серии боев.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights', @level2type=N'COLUMN',@level2name=N'seria_guid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Собственно сами бои' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tr_fights'
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_players] FOREIGN KEY([player_id_1])
REFERENCES [dbo].[players] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players]
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_players1] FOREIGN KEY([player_id_2])
REFERENCES [dbo].[players] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players1]
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_players2] FOREIGN KEY([winner_id])
REFERENCES [dbo].[players] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_players2]
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_tr_commands] FOREIGN KEY([command_id_1])
REFERENCES [dbo].[tr_commands] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_commands]
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_tr_commands1] FOREIGN KEY([command_id_2])
REFERENCES [dbo].[tr_commands] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_commands1]
GO
ALTER TABLE [dbo].[tr_fights] WITH CHECK ADD CONSTRAINT [FK_tr_fights_tr_part] FOREIGN KEY([part_id])
REFERENCES [dbo].[tr_part] ([id])
GO
ALTER TABLE [dbo].[tr_fights] CHECK CONSTRAINT [FK_tr_fights_tr_part]
GO