quote:

---

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Download_Links_Download_Sections]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Download_Links] DROP CONSTRAINT FK_Download_Links_Download_Sections
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Download_Sections]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Download_Sections]
GO

CREATE TABLE [dbo].[Download_Sections] (
[Section_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Page_ID] [int] NOT NULL ,
[Section_Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Section_Description] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Section_Order] [int] NULL ,
[Created_By] [int] NULL ,
[Created_On] [datetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Download_Sections] WITH NOCHECK ADD
CONSTRAINT [PK_Download_Sections] PRIMARY KEY CLUSTERED
(
[Section_ID]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Download_Sections] WITH NOCHECK ADD
CONSTRAINT [DF_Download_Sections_Created_On] DEFAULT (getdate()) FOR [Created_On]
GO

CREATE INDEX [IX_Download_Sections] ON [dbo].[Download_Sections]([Page_ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Download_Sections] ADD
CONSTRAINT [FK_Download_Sections_Download_Pages] FOREIGN KEY
(
[Page_ID]
) REFERENCES [dbo].[Download_Pages] (
[Page_ID]
) ON DELETE CASCADE NOT FOR REPLICATION
GO

---

quote:

---

create trigger tr_Download_Sections_ins on Download_Sections for insert
as
update Download_Sections
set Section_Order = (select coalesce(max(Section_Order),0) + 1 from Download_Sections ds where i.Page_ID = ds.Page_ID)
from Download_Sections ds, inserted i
where i.Section_ID = ds.Section_ID
go

---