YAFLogo

AndyLL
  • AndyLL
  • 59% (Neutral)
  • YAF Forumling Topic Starter
14 years ago
ALTER TABLE [dbo].[yaf_Forum] ADD  CONSTRAINT [IX_yaf_Forum] UNIQUE NONCLUSTERED 
(
	[ParentID] ASC,
	[Name] ASC
) ON [PRIMARY]

Shouldn't this be CategoryID, Name instead of ParentID,Name

I have no sub-forums so ParentID is always null but have the same forum names under different categories.

Or is my conversion program populating ParentID incorrectly?

Andy
Sponsor

YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button