/****** Object:  Trigger dbo.Administrators_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Administrators_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Administrators_ITrig]
GO

/****** Object:  Trigger dbo.Administrators_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Administrators_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Administrators_UTrig]
GO

/****** Object:  Trigger dbo.ApplicationDSs_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[ApplicationDSs_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[ApplicationDSs_ITrig]
GO

/****** Object:  Trigger dbo.ApplicationDSs_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[ApplicationDSs_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[ApplicationDSs_UTrig]
GO

/****** Object:  Trigger dbo.Applications_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Applications_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Applications_ITrig]
GO

/****** Object:  Trigger dbo.Applications_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Applications_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Applications_UTrig]
GO

/****** Object:  Trigger dbo.Attachments_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Attachments_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Attachments_ITrig]
GO

/****** Object:  Trigger dbo.Attachments_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Attachments_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Attachments_UTrig]
GO

/****** Object:  Trigger dbo.Conferences_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Conferences_ITrig]
GO

/****** Object:  Trigger dbo.Conferences_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Conferences_UTrig]
GO

/****** Object:  Trigger dbo.Conferences_Forums_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_Forums_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Conferences_Forums_ITrig]
GO

/****** Object:  Trigger dbo.Conferences_Forums_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_Forums_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Conferences_Forums_UTrig]
GO

/****** Object:  Trigger dbo.Forums_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Forums_ITrig]
GO

/****** Object:  Trigger dbo.Forums_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Forums_UTrig]
GO

/****** Object:  Trigger dbo.Forums_Groups_Rights_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums_Groups_Rights_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Forums_Groups_Rights_ITrig]
GO

/****** Object:  Trigger dbo.Forums_Groups_Rights_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums_Groups_Rights_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Forums_Groups_Rights_UTrig]
GO

/****** Object:  Trigger dbo.Groups_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Groups_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Groups_ITrig]
GO

/****** Object:  Trigger dbo.Groups_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Groups_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Groups_UTrig]
GO

/****** Object:  Trigger dbo.Realms_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Realms_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Realms_ITrig]
GO

/****** Object:  Trigger dbo.Realms_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Realms_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Realms_UTrig]
GO

/****** Object:  Trigger dbo.Rights_Groups_Applicatio_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Groups_Applicatio_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Rights_Groups_Applicatio_ITrig]
GO

/****** Object:  Trigger dbo.Rights_Groups_Applicatio_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Groups_Applicatio_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Rights_Groups_Applicatio_UTrig]
GO

/****** Object:  Trigger dbo.Rights_Users_Application_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Users_Application_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Rights_Users_Application_ITrig]
GO

/****** Object:  Trigger dbo.Rights_Users_Application_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Users_Application_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Rights_Users_Application_UTrig]
GO

/****** Object:  Trigger dbo.Threads_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Threads_ITrig]
GO

/****** Object:  Trigger dbo.Threads_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Threads_UTrig]
GO

/****** Object:  Trigger dbo.Threads_Archived_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_Archived_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Threads_Archived_ITrig]
GO

/****** Object:  Trigger dbo.Threads_Archived_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_Archived_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Threads_Archived_UTrig]
GO

/****** Object:  Trigger dbo.Users_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Users_ITrig]
GO

/****** Object:  Trigger dbo.Users_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Users_UTrig]
GO

/****** Object:  Trigger dbo.Users_Groups_ITrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_Groups_ITrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Users_Groups_ITrig]
GO

/****** Object:  Trigger dbo.Users_Groups_UTrig    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_Groups_UTrig]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Users_Groups_UTrig]
GO

/****** Object:  Table [dbo].[Administrators]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Administrators]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Administrators]
GO

/****** Object:  Table [dbo].[ApplicationDSs]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[ApplicationDSs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ApplicationDSs]
GO

/****** Object:  Table [dbo].[Applications]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Applications]
GO

/****** Object:  Table [dbo].[Attachments]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Attachments]
GO

/****** Object:  Table [dbo].[Censored]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Censored]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Censored]
GO

/****** Object:  Table [dbo].[Conferences]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Conferences]
GO

/****** Object:  Table [dbo].[Conferences_Forums]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_Forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Conferences_Forums]
GO

/****** Object:  Table [dbo].[Forums]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forums]
GO

/****** Object:  Table [dbo].[Forums_Groups_Rights]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Forums_Groups_Rights]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forums_Groups_Rights]
GO

/****** Object:  Table [dbo].[Groups]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Groups]
GO

/****** Object:  Table [dbo].[Messages]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Messages]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Messages]
GO

/****** Object:  Table [dbo].[Messages_Archived]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Messages_Archived]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Messages_Archived]
GO

/****** Object:  Table [dbo].[PvtClass]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[PvtClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PvtClass]
GO

/****** Object:  Table [dbo].[PvtMessage]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[PvtMessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PvtMessage]
GO

/****** Object:  Table [dbo].[PvtPriority]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[PvtPriority]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PvtPriority]
GO

/****** Object:  Table [dbo].[Realms]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Realms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Realms]
GO

/****** Object:  Table [dbo].[Rights_Groups_Applications]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Groups_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rights_Groups_Applications]
GO

/****** Object:  Table [dbo].[Rights_Users_Applications]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Users_Applications]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rights_Users_Applications]
GO

/****** Object:  Table [dbo].[Threads]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Threads]
GO

/****** Object:  Table [dbo].[Threads_Archived]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_Archived]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Threads_Archived]
GO

/****** Object:  Table [dbo].[Threads_NotificationRequests]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Threads_NotificationRequests]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Threads_NotificationRequests]
GO

/****** Object:  Table [dbo].[Users]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO

/****** Object:  Table [dbo].[Users_Groups]    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_Groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users_Groups]
GO

/****** Object:  Default dbo.Conferences_IsEmoticonActive    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Conferences_IsEmoticonActive]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Conferences_IsEmoticonActive]
GO

/****** Object:  Default dbo.Messages_Archived_DateCreate    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Messages_Archived_DateCreate]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Messages_Archived_DateCreate]
GO

/****** Object:  Default dbo.Messages_DateCreated_D    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Messages_DateCreated_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Messages_DateCreated_D]
GO

/****** Object:  Default dbo.Rights_Users_Applications_Da    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rights_Users_Applications_Da]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Rights_Users_Applications_Da]
GO

/****** Object:  Default dbo.Users_DateCreated_D    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_DateCreated_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Users_DateCreated_D]
GO

/****** Object:  Default dbo.Users_Role_D    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Users_Role_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[Users_Role_D]
GO

/****** Object:  Default dbo.UW_ZeroDefault    Script Date: 10/16/2000 12:36:40 PM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[UW_ZeroDefault]') and OBJECTPROPERTY(id, N'IsDefault') = 1)
drop default [dbo].[UW_ZeroDefault]
GO

/****** Object:  Default dbo.Conferences_IsEmoticonActive    Script Date: 10/16/2000 12:36:47 PM ******/
CREATE DEFAULT dbo.Conferences_IsEmoticonActive AS 1

GO

/****** Object:  Default dbo.Messages_Archived_DateCreate    Script Date: 10/16/2000 12:36:47 PM ******/
CREATE DEFAULT dbo.Messages_Archived_DateCreate AS getdate()

GO

/****** Object:  Default dbo.Messages_DateCreated_D    Script Date: 10/16/2000 12:36:47 PM ******/
CREATE DEFAULT dbo.Messages_DateCreated_D AS getdate()

GO

/****** Object:  Default dbo.Rights_Users_Applications_Da    Script Date: 10/16/2000 12:36:47 PM ******/
CREATE DEFAULT dbo.Rights_Users_Applications_Da AS getdate()

GO

/****** Object:  Default dbo.Users_DateCreated_D    Script Date: 10/16/2000 12:36:48 PM ******/
CREATE DEFAULT dbo.Users_DateCreated_D AS getdate()

GO

/****** Object:  Default dbo.Users_Role_D    Script Date: 10/16/2000 12:36:48 PM ******/
CREATE DEFAULT dbo.Users_Role_D AS 'Participant'

GO

/****** Object:  Default dbo.UW_ZeroDefault    Script Date: 10/16/2000 12:36:48 PM ******/
CREATE DEFAULT dbo.UW_ZeroDefault AS 0

GO

/****** Object:  Table [dbo].[Administrators]    Script Date: 10/16/2000 12:36:48 PM ******/
CREATE TABLE [dbo].[Administrators] (
	[CFID] [int] IDENTITY (1, 1) NOT NULL ,
	[CFTOKEN] [int] NULL ,
	[UserName] [varchar] (32) NULL ,
	[Password] [varchar] (32) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[ApplicationDSs]    Script Date: 10/16/2000 12:36:49 PM ******/
CREATE TABLE [dbo].[ApplicationDSs] (
	[ApplicationDS_ID] [int] NOT NULL ,
	[ApplicationDSN] [varchar] (32) NULL ,
	[ApplicationDSDN] [varchar] (50) NULL ,
	[DataDirectory] [varchar] (255) NULL ,
	[Realm_ID] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Applications]    Script Date: 10/16/2000 12:36:49 PM ******/
CREATE TABLE [dbo].[Applications] (
	[Application_ID] [int] NOT NULL ,
	[ApplicationName] [varchar] (32) NULL ,
	[DescriptiveName] [varchar] (64) NULL ,
	[ApplicationType] [varchar] (32) NULL ,
	[ApplicationDS_ID] [int] NULL ,
	[IsUsernameRequired] [bit] NULL ,
	[IsUserApprovalRequired] [bit] NULL ,
	[IsSessionLoginRequired] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Attachments]    Script Date: 10/16/2000 12:36:50 PM ******/
CREATE TABLE [dbo].[Attachments] (
	[Attachment_ID] [int] NOT NULL ,
	[Message_ID] [int] NULL ,
	[IsEmbedded] [bit] NULL ,
	[ClientFileName] [varchar] (64) NULL ,
	[ClientFileExt] [varchar] (16) NULL ,
	[ContentType] [varchar] (16) NULL ,
	[ContentSubType] [varchar] (16) NULL ,
	[ServerFile] [varchar] (64) NULL ,
	[FileSize] [int] NULL ,
	[DateUploaded] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Censored]    Script Date: 10/16/2000 12:36:51 PM ******/
CREATE TABLE [dbo].[Censored] (
	[Cid] [int] IDENTITY (1, 1) NOT NULL ,
	[Nasty] [varchar] (35) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Conferences]    Script Date: 10/16/2000 12:36:51 PM ******/
CREATE TABLE [dbo].[Conferences] (
	[Conference_ID] [int] NULL ,
	[IsActive] [bit] NULL ,
	[ConferenceName] [varchar] (32) NULL ,
	[DescriptiveName] [varchar] (64) NULL ,
	[IsUsernameRequired] [bit] NULL ,
	[IsUserApprovalRequired] [bit] NULL ,
	[IsSessionLoginRequired] [bit] NULL ,
	[IsMessageApprovalRequired] [bit] NULL ,
	[ExitURL] [varchar] (255) NULL ,
	[ExitTarget] [varchar] (50) NULL ,
	[DefaultAgeFilter] [int] NULL ,
	[DisplayNewThreadsFirst] [bit] NULL ,
	[IsAdvMessageDefault] [bit] NULL ,
	[IsHTMLCodeWindowEnabled] [bit] NULL ,
	[IsFileUploadEnabled] [bit] NULL ,
	[IsSearchEnabled] [bit] NULL ,
	[AreFramesEnabled] [bit] NULL ,
	[AreImageButtonsEnabled] [bit] NULL ,
	[ImageDirectory] [varchar] (128) NULL ,
	[BodyTextColor] [varchar] (8) NULL ,
	[LabelTextColor] [varchar] (8) NULL ,
	[ButtonTextColor] [varchar] (8) NULL ,
	[LinkColor] [varchar] (8) NULL ,
	[VLinkColor] [varchar] (8) NULL ,
	[IsBodyBackgroundImageEnabled] [bit] NULL ,
	[BodyBackgroundColor] [varchar] (8) NULL ,
	[LabelBackgroundColor] [varchar] (8) NULL ,
	[ButtonBackgroundColor] [varchar] (8) NULL ,
	[FormBackgroundColor] [varchar] (8) NULL ,
	[Header1] [text] NULL ,
	[Header2] [text] NULL ,
	[Footer1] [text] NULL ,
	[Footer2] [text] NULL ,
	[IsEmoticonActive] [bit] NULL ,
	[IsMsgCensored] [bit] NULL ,
	[LeftColumn] [text] NULL ,
	[CId] [int] IDENTITY (1, 1) NOT NULL ,
	[OpenTag] [varchar] (75) NULL ,
	[CloseTag] [varchar] (75) NULL ,
	[FramedSite] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Conferences_Forums]    Script Date: 10/16/2000 12:36:52 PM ******/
CREATE TABLE [dbo].[Conferences_Forums] (
	[CFId] [int] IDENTITY (1, 1) NOT NULL ,
	[Conference_ID] [int] NULL ,
	[Forum_ID] [int] NULL ,
	[IsActive] [bit] NULL ,
	[Precedence] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forums]    Script Date: 10/16/2000 12:36:53 PM ******/
CREATE TABLE [dbo].[Forums] (
	[Forum_ID] [int] NULL ,
	[IsActive] [bit] NULL ,
	[Title] [varchar] (64) NULL ,
	[ForumDescription] [text] NULL ,
	[FId] [int] IDENTITY (1, 1) NOT NULL ,
	[FDate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forums_Groups_Rights]    Script Date: 10/16/2000 12:36:53 PM ******/
CREATE TABLE [dbo].[Forums_Groups_Rights] (
	[Forum_ID] [int] NULL ,
	[Group_ID] [int] NULL ,
	[Rights] [int] NULL ,
	[IsActive] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Groups]    Script Date: 10/16/2000 12:36:54 PM ******/
CREATE TABLE [dbo].[Groups] (
	[Group_ID] [int] NOT NULL ,
	[GroupName] [varchar] (32) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Messages]    Script Date: 10/16/2000 12:36:54 PM ******/
CREATE TABLE [dbo].[Messages] (
	[Message_ID] [int] NOT NULL ,
	[IsActive] [bit] NULL ,
	[IsApproved] [bit] NULL ,
	[IsDeleted] [bit] NULL ,
	[Thread_ID] [int] NULL ,
	[ParentMessage_ID] [int] NULL ,
	[ReplyLevel] [int] NULL ,
	[User_ID] [int] NULL ,
	[Author] [varchar] (64) NULL ,
	[Email] [varchar] (128) NULL ,
	[Subject] [varchar] (64) NULL ,
	[Message] [text] NULL ,
	[HTML_Code] [text] NULL ,
	[IsMessagePreformated] [bit] NULL ,
	[IsNotificationRequested] [bit] NULL ,
	[AreThreadParticipantsNotified] [bit] NULL ,
	[DateCreated] [datetime] NULL ,
	[DateEdited] [datetime] NULL ,
	[Pvt] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Messages_Archived]    Script Date: 10/16/2000 12:36:55 PM ******/
CREATE TABLE [dbo].[Messages_Archived] (
	[Message_ID] [int] NOT NULL ,
	[IsActive] [bit] NULL ,
	[IsApproved] [bit] NULL ,
	[IsDeleted] [bit] NULL ,
	[Thread_ID] [int] NULL ,
	[ParentMessage_ID] [int] NULL ,
	[ReplyLevel] [int] NULL ,
	[User_ID] [int] NULL ,
	[Author] [varchar] (64) NULL ,
	[Email] [varchar] (128) NULL ,
	[Subject] [varchar] (64) NULL ,
	[Message] [text] NULL ,
	[HTML_Code] [text] NULL ,
	[IsMessagePreformated] [bit] NULL ,
	[IsNotificationRequested] [bit] NULL ,
	[AreThreadParticipantsNotified] [bit] NULL ,
	[DateCreated] [datetime] NULL ,
	[DateEdited] [datetime] NULL ,
	[Pvt] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[PvtClass]    Script Date: 10/16/2000 12:36:56 PM ******/
CREATE TABLE [dbo].[PvtClass] (
	[PvtClass_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[PvtClass] [char] (15) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[PvtMessage]    Script Date: 10/16/2000 12:36:56 PM ******/
CREATE TABLE [dbo].[PvtMessage] (
	[ToUser] [int] NOT NULL ,
	[ToUser2] [int] NULL ,
	[DateCreated] [datetime] NULL ,
	[DateRead] [datetime] NULL ,
	[FromUser] [int] NULL ,
	[Message] [text] NULL ,
	[Subject] [char] (50) NULL ,
	[PvtClass] [char] (15) NULL ,
	[PvtPriority] [char] (15) NULL ,
	[PvtMsg_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Message_Id] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[PvtPriority]    Script Date: 10/16/2000 12:36:57 PM ******/
CREATE TABLE [dbo].[PvtPriority] (
	[PvtPriority_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[PvtPriority] [char] (15) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Realms]    Script Date: 10/16/2000 12:36:58 PM ******/
CREATE TABLE [dbo].[Realms] (
	[Realm_ID] [int] NOT NULL ,
	[RealmName] [varchar] (64) NULL ,
	[RealmDSN] [varchar] (32) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Rights_Groups_Applications]    Script Date: 10/16/2000 12:36:58 PM ******/
CREATE TABLE [dbo].[Rights_Groups_Applications] (
	[Group_ID] [int] NULL ,
	[Application_ID] [int] NULL ,
	[Rights] [int] NULL ,
	[IsActive] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Rights_Users_Applications]    Script Date: 10/16/2000 12:36:59 PM ******/
CREATE TABLE [dbo].[Rights_Users_Applications] (
	[User_ID] [int] NOT NULL ,
	[Application_ID] [int] NOT NULL ,
	[Rights] [int] NULL ,
	[DateCreated] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Threads]    Script Date: 10/16/2000 12:36:59 PM ******/
CREATE TABLE [dbo].[Threads] (
	[Thread_ID] [int] NOT NULL ,
	[IsActive] [bit] NULL ,
	[Forum_ID] [int] NULL ,
	[Subject] [varchar] (64) NULL ,
	[MessageCount] [int] NULL ,
	[TimeLastUpdated] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Threads_Archived]    Script Date: 10/16/2000 12:37:00 PM ******/
CREATE TABLE [dbo].[Threads_Archived] (
	[Thread_ID] [int] NOT NULL ,
	[IsActive] [bit] NULL ,
	[Forum_ID] [int] NULL ,
	[Subject] [varchar] (64) NULL ,
	[MessageCount] [int] NULL ,
	[TimeLastUpdated] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Threads_NotificationRequests]    Script Date: 10/16/2000 12:37:00 PM ******/
CREATE TABLE [dbo].[Threads_NotificationRequests] (
	[User_ID] [int] NOT NULL ,
	[Thread_ID] [int] NOT NULL ,
	[TId] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Users]    Script Date: 10/16/2000 12:37:01 PM ******/
CREATE TABLE [dbo].[Users] (
	[User_ID] [int] NULL ,
	[cfid] [int] NULL ,
	[st] [int] NULL ,
	[UserName] [varchar] (64) NULL ,
	[Description] [varchar] (255) NULL ,
	[Password] [varchar] (30) NULL ,
	[Email] [varchar] (128) NULL ,
	[DateCreated] [datetime] NULL ,
	[Role] [varchar] (50) NULL ,
	[Profile] [text] NULL ,
	[Url] [varchar] (75) NULL ,
	[SiteName] [varchar] (75) NULL ,
	[Admin] [bit] NULL ,
	[Komment] [text] NULL ,
	[Cnt] [int] NULL ,
	[LastLogin] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Users_Groups]    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TABLE [dbo].[Users_Groups] (
	[User_ID] [int] NOT NULL ,
	[Group_ID] [int] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Administrators] WITH NOCHECK ADD 
	CONSTRAINT [PK_Administrators] PRIMARY KEY  NONCLUSTERED 
	(
		[CFID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ApplicationDSs] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaApplicationDSs_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[ApplicationDS_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Applications] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaApplications_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Application_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Attachments] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaAttachments_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Attachment_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Censored] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaCensored_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Cid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Conferences] WITH NOCHECK ADD 
	CONSTRAINT [DF_Conferences_IsFramed] DEFAULT (0) FOR [FramedSite],
	CONSTRAINT [PK_Conferences] PRIMARY KEY  NONCLUSTERED 
	(
		[CId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Conferences_Forums] WITH NOCHECK ADD 
	CONSTRAINT [PK_Conferences_Forums] PRIMARY KEY  NONCLUSTERED 
	(
		[CFId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forums] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forums] PRIMARY KEY  NONCLUSTERED 
	(
		[FId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Groups] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaGroups_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Group_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Messages] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaMessages_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Message_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Messages_Archived] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaMessages_Archived_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Message_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PvtClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_PvtClass] PRIMARY KEY  NONCLUSTERED 
	(
		[PvtClass_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PvtMessage] WITH NOCHECK ADD 
	CONSTRAINT [PK_PvtMessage] PRIMARY KEY  NONCLUSTERED 
	(
		[PvtMsg_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[PvtPriority] WITH NOCHECK ADD 
	CONSTRAINT [PK_PvtPriority] PRIMARY KEY  NONCLUSTERED 
	(
		[PvtPriority_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Realms] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaRealms_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Realm_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Rights_Users_Applications] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaRights_Users_Applicati_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[User_ID],
		[Application_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Threads] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaThreads_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Thread_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Threads_Archived] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaThreads_Archived_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[Thread_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Threads_NotificationRequests] WITH NOCHECK ADD 
	CONSTRAINT [PK_Threads_NotificationRequests] PRIMARY KEY  NONCLUSTERED 
	(
		[TId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Users_Groups] WITH NOCHECK ADD 
	CONSTRAINT [aaaaaUsers_Groups_PK] PRIMARY KEY  NONCLUSTERED 
	(
		[User_ID],
		[Group_ID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [CFID] ON [dbo].[Administrators]([CFID]) ON [PRIMARY]
GO

 CREATE  INDEX [CFTOKEN] ON [dbo].[Administrators]([CFTOKEN]) ON [PRIMARY]
GO

 CREATE  INDEX [AppDataSourcesRealm_ID] ON [dbo].[ApplicationDSs]([Realm_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [DataSourceName] ON [dbo].[ApplicationDSs]([ApplicationDSN]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [PrimaryDatasource_ID] ON [dbo].[ApplicationDSs]([ApplicationDS_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [AppDataSource_ID] ON [dbo].[Applications]([ApplicationDS_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [Application_ID] ON [dbo].[Applications]([Application_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [ApplicationName] ON [dbo].[Applications]([ApplicationName]) ON [PRIMARY]
GO

 CREATE  INDEX [Attachment_ID] ON [dbo].[Attachments]([Attachment_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_ID] ON [dbo].[Attachments]([Message_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Cid] ON [dbo].[Censored]([Cid]) ON [PRIMARY]
GO

 CREATE  INDEX [Project_ID] ON [dbo].[Conferences]([Conference_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Conference_ID] ON [dbo].[Conferences_Forums]([Conference_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[Conferences_Forums]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[Forums]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Rights] ON [dbo].[Forums_Groups_Rights]([Rights]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Forums_Groups_Rights]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Forums_Groups_Rights]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Group_ID] ON [dbo].[Groups]([Group_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [GroupName] ON [dbo].[Groups]([GroupName]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_ID] ON [dbo].[Messages]([Message_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ParentMessage_ID] ON [dbo].[Messages]([ParentMessage_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Messages]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Messages]([User_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_ID] ON [dbo].[Messages_Archived]([Message_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ParentMessage_ID] ON [dbo].[Messages_Archived]([ParentMessage_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Messages_Archived]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Messages_Archived]([User_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [Realm_ID] ON [dbo].[Realms]([Realm_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Project_ID] ON [dbo].[Rights_Groups_Applications]([Application_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Rights_Groups_Applications]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Project_ID] ON [dbo].[Rights_Users_Applications]([Application_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Rights_Users_Applications]([User_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[Threads]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Threads]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[Threads_Archived]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Threads_Archived]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[Threads_NotificationRequests]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Threads_NotificationRequests]([User_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [CFClientID] ON [dbo].[Users]([User_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [cfid] ON [dbo].[Users]([cfid]) ON [PRIMARY]
GO

 CREATE  INDEX [CFToken] ON [dbo].[Users]([st]) ON [PRIMARY]
GO

 CREATE  INDEX [Group_ID] ON [dbo].[Users_Groups]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [User_ID] ON [dbo].[Users_Groups]([User_ID]) ON [PRIMARY]
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Administrators].[CFTOKEN]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[ApplicationDSs].[ApplicationDS_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[ApplicationDSs].[Realm_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Applications].[Application_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Applications].[ApplicationDS_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Applications].[IsSessionLoginRequired]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Applications].[IsUserApprovalRequired]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Applications].[IsUsernameRequired]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Attachments].[Attachment_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Attachments].[FileSize]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Attachments].[IsEmbedded]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Attachments].[Message_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[AreFramesEnabled]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[AreImageButtonsEnabled]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[Conference_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[DefaultAgeFilter]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[DisplayNewThreadsFirst]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsAdvMessageDefault]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsBodyBackgroundImageEnabled]'
GO

EXEC sp_bindefault N'[dbo].[Conferences_IsEmoticonActive]', N'[Conferences].[IsEmoticonActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsFileUploadEnabled]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsHTMLCodeWindowEnabled]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsMessageApprovalRequired]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsMsgCensored]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsSearchEnabled]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsSessionLoginRequired]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsUserApprovalRequired]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences].[IsUsernameRequired]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences_Forums].[Conference_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences_Forums].[Forum_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences_Forums].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Conferences_Forums].[Precedence]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Forums].[IsActive]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Forums_Groups_Rights].[Forum_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Forums_Groups_Rights].[Group_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Forums_Groups_Rights].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Forums_Groups_Rights].[Rights]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Groups].[Group_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[AreThreadParticipantsNotified]'
GO

EXEC sp_bindefault N'[dbo].[Messages_DateCreated_D]', N'[Messages].[DateCreated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[IsApproved]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[IsDeleted]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[IsMessagePreformated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[IsNotificationRequested]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[Message_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[ParentMessage_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[ReplyLevel]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[Thread_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages].[User_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[AreThreadParticipantsNotified]'
GO

EXEC sp_bindefault N'[dbo].[Messages_Archived_DateCreate]', N'[Messages_Archived].[DateCreated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[IsApproved]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[IsDeleted]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[IsMessagePreformated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[IsNotificationRequested]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[Message_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[ParentMessage_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[ReplyLevel]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[Thread_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Messages_Archived].[User_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Realms].[Realm_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Groups_Applications].[Application_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Groups_Applications].[Group_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Groups_Applications].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Groups_Applications].[Rights]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Users_Applications].[Application_ID]'
GO

EXEC sp_bindefault N'[dbo].[Rights_Users_Applications_Da]', N'[Rights_Users_Applications].[DateCreated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Users_Applications].[Rights]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Rights_Users_Applications].[User_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads].[Forum_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads].[MessageCount]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads].[Thread_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_Archived].[Forum_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_Archived].[IsActive]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_Archived].[MessageCount]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_Archived].[Thread_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_NotificationRequests].[Thread_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Threads_NotificationRequests].[User_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users].[Admin]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users].[cfid]'
GO

EXEC sp_bindefault N'[dbo].[Users_DateCreated_D]', N'[Users].[DateCreated]'
GO

EXEC sp_bindefault N'[dbo].[Users_Role_D]', N'[Users].[Role]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users].[st]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users].[User_ID]'
GO

setuser
GO

setuser N'dbo'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users_Groups].[Group_ID]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Users_Groups].[User_ID]'
GO

setuser
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Administrators_ITrig    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TRIGGER Administrators_ITrig ON dbo.Administrators FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'CFID'
 */
IF (SELECT Count(*) FROM inserted WHERE CFID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''CFID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'CFTOKEN'
 */
IF (SELECT Count(*) FROM inserted WHERE CFTOKEN IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''CFTOKEN'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'UserName'
 */
IF (SELECT Count(*) FROM inserted WHERE UserName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''UserName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Password'
 */
IF (SELECT Count(*) FROM inserted WHERE Password IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Password'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Administrators_UTrig    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TRIGGER Administrators_UTrig ON dbo.Administrators FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'CFID'
 */
IF (SELECT Count(*) FROM inserted WHERE CFID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''CFID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'CFTOKEN'
 */
IF (SELECT Count(*) FROM inserted WHERE CFTOKEN IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''CFTOKEN'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'UserName'
 */
IF (SELECT Count(*) FROM inserted WHERE UserName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''UserName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Password'
 */
IF (SELECT Count(*) FROM inserted WHERE Password IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Password'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.ApplicationDSs_ITrig    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TRIGGER ApplicationDSs_ITrig ON ApplicationDSs FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'ApplicationDS_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDS_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDS_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationDSDN'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDSDN IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDSDN'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DataDirectory'
 */
IF (SELECT Count(*) FROM inserted WHERE DataDirectory IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DataDirectory'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Realm_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Realm_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Realm_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.ApplicationDSs_UTrig    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TRIGGER ApplicationDSs_UTrig ON ApplicationDSs FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'ApplicationDS_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDS_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDS_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationDSDN'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDSDN IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDSDN'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DataDirectory'
 */
IF (SELECT Count(*) FROM inserted WHERE DataDirectory IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DataDirectory'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Realm_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Realm_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Realm_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Applications_ITrig    Script Date: 10/16/2000 12:37:02 PM ******/
CREATE TRIGGER Applications_ITrig ON Applications FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationName'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DescriptiveName'
 */
IF (SELECT Count(*) FROM inserted WHERE DescriptiveName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DescriptiveName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationType'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationDS_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDS_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDS_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Applications_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Applications_UTrig ON Applications FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationName'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DescriptiveName'
 */
IF (SELECT Count(*) FROM inserted WHERE DescriptiveName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DescriptiveName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationType'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ApplicationDS_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE ApplicationDS_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ApplicationDS_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Attachments_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Attachments_ITrig ON Attachments FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Attachment_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Attachment_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Attachment_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ClientFileName'
 */
IF (SELECT Count(*) FROM inserted WHERE ClientFileName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ClientFileName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ClientFileExt'
 */
IF (SELECT Count(*) FROM inserted WHERE ClientFileExt IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ClientFileExt'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ContentType'
 */
IF (SELECT Count(*) FROM inserted WHERE ContentType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ContentType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ContentSubType'
 */
IF (SELECT Count(*) FROM inserted WHERE ContentSubType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ContentSubType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ServerFile'
 */
IF (SELECT Count(*) FROM inserted WHERE ServerFile IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ServerFile'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'FileSize'
 */
IF (SELECT Count(*) FROM inserted WHERE FileSize IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''FileSize'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DateUploaded'
 */
IF (SELECT Count(*) FROM inserted WHERE DateUploaded IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DateUploaded'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Attachments_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Attachments_UTrig ON Attachments FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Attachment_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Attachment_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Attachment_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ClientFileName'
 */
IF (SELECT Count(*) FROM inserted WHERE ClientFileName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ClientFileName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ClientFileExt'
 */
IF (SELECT Count(*) FROM inserted WHERE ClientFileExt IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ClientFileExt'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ContentType'
 */
IF (SELECT Count(*) FROM inserted WHERE ContentType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ContentType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ContentSubType'
 */
IF (SELECT Count(*) FROM inserted WHERE ContentSubType IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ContentSubType'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ServerFile'
 */
IF (SELECT Count(*) FROM inserted WHERE ServerFile IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ServerFile'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'FileSize'
 */
IF (SELECT Count(*) FROM inserted WHERE FileSize IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''FileSize'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DateUploaded'
 */
IF (SELECT Count(*) FROM inserted WHERE DateUploaded IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DateUploaded'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Conferences_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Conferences_ITrig ON dbo.Conferences FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Conference_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Conference_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Conference_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ConferenceName'
 */
IF (SELECT Count(*) FROM inserted WHERE ConferenceName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ConferenceName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DescriptiveName'
 */
IF (SELECT Count(*) FROM inserted WHERE DescriptiveName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DescriptiveName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ExitURL'
 */
IF (SELECT Count(*) FROM inserted WHERE ExitURL IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ExitURL'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ExitTarget'
 */
IF (SELECT Count(*) FROM inserted WHERE ExitTarget IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ExitTarget'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DefaultAgeFilter'
 */
IF (SELECT Count(*) FROM inserted WHERE DefaultAgeFilter IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DefaultAgeFilter'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ImageDirectory'
 */
IF (SELECT Count(*) FROM inserted WHERE ImageDirectory IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ImageDirectory'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'BodyTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE BodyTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''BodyTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LabelTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LabelTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LabelTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ButtonTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE ButtonTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ButtonTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LinkColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LinkColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LinkColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'VLinkColor'
 */
IF (SELECT Count(*) FROM inserted WHERE VLinkColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''VLinkColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'BodyBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE BodyBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''BodyBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LabelBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LabelBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LabelBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ButtonBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE ButtonBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ButtonBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'FormBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE FormBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''FormBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Conferences_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Conferences_UTrig ON dbo.Conferences FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Conference_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Conference_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Conference_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ConferenceName'
 */
IF (SELECT Count(*) FROM inserted WHERE ConferenceName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ConferenceName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DescriptiveName'
 */
IF (SELECT Count(*) FROM inserted WHERE DescriptiveName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DescriptiveName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ExitURL'
 */
IF (SELECT Count(*) FROM inserted WHERE ExitURL IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ExitURL'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ExitTarget'
 */
IF (SELECT Count(*) FROM inserted WHERE ExitTarget IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ExitTarget'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DefaultAgeFilter'
 */
IF (SELECT Count(*) FROM inserted WHERE DefaultAgeFilter IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DefaultAgeFilter'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ImageDirectory'
 */
IF (SELECT Count(*) FROM inserted WHERE ImageDirectory IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ImageDirectory'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'BodyTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE BodyTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''BodyTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LabelTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LabelTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LabelTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ButtonTextColor'
 */
IF (SELECT Count(*) FROM inserted WHERE ButtonTextColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ButtonTextColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LinkColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LinkColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LinkColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'VLinkColor'
 */
IF (SELECT Count(*) FROM inserted WHERE VLinkColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''VLinkColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'BodyBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE BodyBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''BodyBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'LabelBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE LabelBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''LabelBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'ButtonBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE ButtonBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''ButtonBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'FormBackgroundColor'
 */
IF (SELECT Count(*) FROM inserted WHERE FormBackgroundColor IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''FormBackgroundColor'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Conferences_Forums_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Conferences_Forums_ITrig ON dbo.Conferences_Forums FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Conference_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Conference_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Conference_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Precedence'
 */
IF (SELECT Count(*) FROM inserted WHERE Precedence IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Precedence'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Conferences_Forums_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Conferences_Forums_UTrig ON dbo.Conferences_Forums FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Conference_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Conference_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Conference_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Precedence'
 */
IF (SELECT Count(*) FROM inserted WHERE Precedence IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Precedence'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Forums_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Forums_ITrig ON dbo.Forums FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Title'
 */
IF (SELECT Count(*) FROM inserted WHERE Title IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Title'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Forums_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Forums_UTrig ON dbo.Forums FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Title'
 */
IF (SELECT Count(*) FROM inserted WHERE Title IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Title'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Forums_Groups_Rights_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Forums_Groups_Rights_ITrig ON Forums_Groups_Rights FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Forums_Groups_Rights_UTrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Forums_Groups_Rights_UTrig ON Forums_Groups_Rights FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Groups_ITrig    Script Date: 10/16/2000 12:37:03 PM ******/
CREATE TRIGGER Groups_ITrig ON Groups FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'GroupName'
 */
IF (SELECT Count(*) FROM inserted WHERE GroupName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''GroupName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Groups_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Groups_UTrig ON Groups FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'GroupName'
 */
IF (SELECT Count(*) FROM inserted WHERE GroupName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''GroupName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Realms_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Realms_ITrig ON Realms FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Realm_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Realm_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Realm_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Realms_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Realms_UTrig ON Realms FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Realm_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Realm_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Realm_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Rights_Groups_Applicatio_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Rights_Groups_Applicatio_ITrig ON Rights_Groups_Applications FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Rights_Groups_Applicatio_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Rights_Groups_Applicatio_UTrig ON Rights_Groups_Applications FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Rights_Users_Application_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Rights_Users_Application_ITrig ON Rights_Users_Applications FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DateCreated'
 */
IF (SELECT Count(*) FROM inserted WHERE DateCreated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DateCreated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Rights_Users_Application_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Rights_Users_Application_UTrig ON Rights_Users_Applications FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Application_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Application_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Application_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Rights'
 */
IF (SELECT Count(*) FROM inserted WHERE Rights IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Rights'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'DateCreated'
 */
IF (SELECT Count(*) FROM inserted WHERE DateCreated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''DateCreated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Threads_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Threads_ITrig ON Threads FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Thread_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Thread_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Thread_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Subject'
 */
IF (SELECT Count(*) FROM inserted WHERE Subject IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Subject'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'MessageCount'
 */
IF (SELECT Count(*) FROM inserted WHERE MessageCount IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''MessageCount'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'TimeLastUpdated'
 */
IF (SELECT Count(*) FROM inserted WHERE TimeLastUpdated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''TimeLastUpdated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Threads_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Threads_UTrig ON Threads FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Thread_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Thread_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Thread_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Subject'
 */
IF (SELECT Count(*) FROM inserted WHERE Subject IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Subject'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'MessageCount'
 */
IF (SELECT Count(*) FROM inserted WHERE MessageCount IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''MessageCount'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'TimeLastUpdated'
 */
IF (SELECT Count(*) FROM inserted WHERE TimeLastUpdated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''TimeLastUpdated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Threads_Archived_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Threads_Archived_ITrig ON Threads_Archived FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'Thread_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Thread_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Thread_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Subject'
 */
IF (SELECT Count(*) FROM inserted WHERE Subject IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Subject'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'MessageCount'
 */
IF (SELECT Count(*) FROM inserted WHERE MessageCount IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''MessageCount'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'TimeLastUpdated'
 */
IF (SELECT Count(*) FROM inserted WHERE TimeLastUpdated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''TimeLastUpdated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Threads_Archived_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Threads_Archived_UTrig ON Threads_Archived FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'Thread_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Thread_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Thread_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Forum_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Forum_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Forum_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Subject'
 */
IF (SELECT Count(*) FROM inserted WHERE Subject IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Subject'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'MessageCount'
 */
IF (SELECT Count(*) FROM inserted WHERE MessageCount IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''MessageCount'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'TimeLastUpdated'
 */
IF (SELECT Count(*) FROM inserted WHERE TimeLastUpdated IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''TimeLastUpdated'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Users_ITrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Users_ITrig ON dbo.Users FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'cfid'
 */
IF (SELECT Count(*) FROM inserted WHERE cfid IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''cfid'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'st'
 */
IF (SELECT Count(*) FROM inserted WHERE st IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''st'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'UserName'
 */
IF (SELECT Count(*) FROM inserted WHERE UserName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''UserName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Description'
 */
IF (SELECT Count(*) FROM inserted WHERE Description IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Description'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Password'
 */
IF (SELECT Count(*) FROM inserted WHERE Password IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Password'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Email'
 */
IF (SELECT Count(*) FROM inserted WHERE Email IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Email'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Users_UTrig    Script Date: 10/16/2000 12:37:04 PM ******/
CREATE TRIGGER Users_UTrig ON dbo.Users FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'cfid'
 */
IF (SELECT Count(*) FROM inserted WHERE cfid IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''cfid'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'st'
 */
IF (SELECT Count(*) FROM inserted WHERE st IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''st'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'UserName'
 */
IF (SELECT Count(*) FROM inserted WHERE UserName IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''UserName'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Description'
 */
IF (SELECT Count(*) FROM inserted WHERE Description IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Description'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Password'
 */
IF (SELECT Count(*) FROM inserted WHERE Password IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Password'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Email'
 */
IF (SELECT Count(*) FROM inserted WHERE Email IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Email'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Users_Groups_ITrig    Script Date: 10/16/2000 12:37:05 PM ******/
CREATE TRIGGER Users_Groups_ITrig ON Users_Groups FOR INSERT AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  Trigger dbo.Users_Groups_UTrig    Script Date: 10/16/2000 12:37:05 PM ******/
CREATE TRIGGER Users_Groups_UTrig ON Users_Groups FOR UPDATE AS
/*
 * PREVENT NULL VALUES IN 'User_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE User_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''User_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END
ELSE 
/*
 * PREVENT NULL VALUES IN 'Group_ID'
 */
IF (SELECT Count(*) FROM inserted WHERE Group_ID IS NULL) > 0
    BEGIN
        RAISERROR 44444 'Field ''Group_ID'' cannot contain a null value.'
        ROLLBACK TRANSACTION
    END

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

