Code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[isplate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[isplate]
GO
CREATE TABLE [dbo].[isplate] (
[idradnika] [int] NOT NULL ,
[idprojekta] [int] NOT NULL ,
[rbr] [int] NOT NULL ,
[iznos] [decimal](18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[isplate] ADD
CONSTRAINT [PK_isplate] PRIMARY KEY CLUSTERED
(
[idradnika],
[idprojekta],
[rbr]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[isplate] ADD
CONSTRAINT [FK_isplate_projekti] FOREIGN KEY
(
[idprojekta]
) REFERENCES [dbo].[projekti] (
[idprojekta]
),
CONSTRAINT [FK_isplate_radnici] FOREIGN KEY
(
[idradnika]
) REFERENCES [dbo].[radnici] (
[idradnika]
)
GO
Kako ti bre rodjače radi QA a neradi EM.
Jesi li probao da instaliraš ponovo samo klijentske alate?
You can fool some people sometimes,
But you can't fool all the people all the time. (Bob Marley)