IF OBJECT_ID('_tPA_SetURLType') IS NULL
BEGIN
  CREATE TABLE [dbo].[_tPA_SetURLType](
    [anQId] [int] IDENTITY(1,1) NOT NULL,
    [acURLType] [char](30) NOT NULL,
    [acName] [varchar](128) NULL,
    CONSTRAINT [kPA_SetURLType_0] PRIMARY KEY CLUSTERED ([acURLType] ASC) WITH (PAD_INDEX = OFF,
      STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]

  CREATE NONCLUSTERED INDEX IX__tPA_SetURLType_acName ON dbo._tPA_SetURLType (acName)
END

IF OBJECT_ID('_tPA_SetURL') IS NULL
BEGIN
  CREATE TABLE [dbo].[_tPA_SetURL](
	[anQId] [int] IDENTITY(1,1) NOT NULL,
	[acSubject] [char](30) NULL,
	[acCostDrv] [char](16) NULL,
    [acIdent] [char](16) NULL,
    [acClassif] [char](16) NULL,
	[acActive] [char](1) NOT NULL,
	[acURL] [varchar](255) NOT NULL,
	[acName] [varchar](128) NOT NULL,
	[anOrder] [int] NOT NULL,
	[acType] [char](1) NOT NULL,
    [acURLType] [char](30) NULL,
    CONSTRAINT [kPA_SetURL_0] PRIMARY KEY CLUSTERED ([anQId] ASC) WITH (PAD_INDEX = OFF,
      STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]

  ALTER TABLE [dbo].[_tPA_SetURL] ADD CONSTRAINT [DF_tPA_SetURL_acActive] DEFAULT ('T') FOR [acActive]

  ALTER TABLE [dbo].[_tPA_SetURL] ADD CONSTRAINT [DF_tPA_SetURL_anOrder] DEFAULT ((0)) FOR [anOrder]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [FK__tPA_SetURL_tHE_CostDrv]
    FOREIGN KEY([acCostDrv]) REFERENCES [dbo].[tHE_CostDrv] ([ACCOSTDRV]) ON UPDATE CASCADE
  ALTER TABLE [dbo].[_tPA_SetURL] CHECK CONSTRAINT [FK__tPA_SetURL_tHE_CostDrv]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [FK__tPA_SetURL_tHE_SetSubj]
    FOREIGN KEY([acSubject]) REFERENCES [dbo].[tHE_SetSubj] ([acSubject]) --ON UPDATE CASCADE
  ALTER TABLE [dbo].[_tPA_SetURL] CHECK CONSTRAINT [FK__tPA_SetURL_tHE_SetSubj]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [FK__tPA_SetURL_tHE_SetItem]
    FOREIGN KEY([acIdent]) REFERENCES [dbo].[tHE_SetItem] ([acIdent]) ON UPDATE CASCADE
  ALTER TABLE [dbo].[_tPA_SetURL] CHECK CONSTRAINT [FK__tPA_SetURL_tHE_SetItem]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [FK__tPA_SetURL_tHE_SetItemCateg]
    FOREIGN KEY([acClassif]) REFERENCES [dbo].[tHE_SetItemCateg] ([acClassif]) ON UPDATE CASCADE
  ALTER TABLE [dbo].[_tPA_SetURL] CHECK CONSTRAINT [FK__tPA_SetURL_tHE_SetItemCateg]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [FK__tPA_SetURL__tPA_SetURLType]
    FOREIGN KEY([acURLType]) REFERENCES [dbo].[_tPA_SetURLType] ([acURLType]) ON UPDATE CASCADE
  ALTER TABLE [dbo].[_tPA_SetURL] CHECK CONSTRAINT [FK__tPA_SetURL__tPA_SetURLType]

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [CK__tPA_SetURL_acSubject_acCostDrv]
    CHECK (([acSubject] IS NOT NULL AND [acCostDrv] IS NULL AND [acIdent] IS NULL AND [acClassif] IS NULL) OR
           ([acSubject] IS NULL AND [acCostDrv] IS NOT NULL AND [acIdent] IS NULL AND [acClassif] IS NULL) OR
           ([acSubject] IS NULL AND [acCostDrv] IS NULL AND [acIdent] IS NOT NULL AND [acClassif] IS NULL) OR
           ([acSubject] IS NULL AND [acCostDrv] IS NULL AND [acIdent] IS NULL AND [acClassif] IS NOT NULL))

  ALTER TABLE [dbo].[_tPA_SetURL] WITH CHECK ADD CONSTRAINT [CK__tPA_SetURL_acType]
    CHECK (([acType] = 'D' OR [acType] = 'S' OR [acType] = 'I' OR [acType] = 'C'))

  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acCostDrv ON dbo._tPA_SetURL (acCostDrv)
  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acSubject ON dbo._tPA_SetURL (acSubject)
  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acIdent ON dbo._tPA_SetURL (acIdent)
  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acClassif ON dbo._tPA_SetURL (acClasif)
  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acActive ON dbo._tPA_SetURL (acActive)
  CREATE NONCLUSTERED INDEX IX__tPA_SetURL_acType ON dbo._tPA_SetURL (acType)
END