/****** Object:  Table [dbo].[TaxonNameNomenclaturalCode_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameNomenclaturalCode_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](800) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameNomenclaturalCode_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameNomenclaturalStatus_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameNomenclaturalStatus_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameNomenclaturalStatus_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameRevisionLevel_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameRevisionLevel_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameRevisionLevel_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameTaxonomicRank_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameTaxonomicRank_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameTaxonomicRank_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameCreationType_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameCreationType_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameCreationType_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonName]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonName](
	[NameID] [int] NOT NULL,
	[TaxonNameCache] [nvarchar](255) NULL,
	[Version] [smallint] NULL,
	[BasedOnNameID] [int] NULL,
	[CreationType] [nvarchar](50) NULL,
	[TaxonomicRank] [nvarchar](50) NOT NULL,
	[GenusOrSupragenericName] [nvarchar](200) NOT NULL,
	[SpeciesGenusNameID] [int] NULL,
	[InfragenericEpithet] [nvarchar](200) NULL,
	[SpeciesEpithet] [nvarchar](100) NULL,
	[InfraspecificEpithet] [nvarchar](100) NULL,
	[BasionymAuthors] [nvarchar](100) NULL,
	[CombiningAuthors] [nvarchar](255) NULL,
	[PublishingAuthors] [nvarchar](255) NULL,
	[SanctioningAuthor] [nvarchar](100) NULL,
	[NonNomenclaturalNameSuffix] [nvarchar](200) NULL,
	[IsRecombination] [bit] NOT NULL,
	[IsHybrid] [bit] NULL,
	[HybridNameID1] [int] NULL,
	[HybridNameID2] [int] NULL,
	[HybridNameID3] [int] NULL,
	[HybridNameID4] [int] NULL,
	[ReferenceTitle] [nvarchar](600) NULL,
	[ReferenceURI] [varchar](255) NULL,
	[Volume] [nvarchar](20) NULL,
	[Issue] [nvarchar](255) NULL,
	[Pages] [nvarchar](50) NULL,
	[DetailLocation] [nvarchar](200) NULL,
	[DayOfPubl] [tinyint] NULL,
	[MonthOfPubl] [tinyint] NULL,
	[YearOfPubl] [smallint] NULL,
	[DateOfPublSupplement] [nvarchar](200) NULL,
	[YearOnPubl] [smallint] NULL,
	[DateOnPublSupplement] [nvarchar](200) NULL,
	[Protologue] [nvarchar](max) NULL,
	[ProtologueURI] [varchar](255) NULL,
	[ProtologueResourceURI] [varchar](255) NULL,
	[NameUsageReferences] [nvarchar](255) NULL,
	[OriginalOrthography] [nvarchar](255) NULL,
	[NomenclaturalCode] [nvarchar](50) NULL,
	[NomenclaturalStatus] [nvarchar](50) NULL,
	[NomenclaturalComment] [nvarchar](max) NULL,
	[Typification] [nvarchar](50) NULL,
	[TypificationDetails] [nvarchar](255) NULL,
	[TypificationReferenceTitle] [nvarchar](255) NULL,
	[TypificationReferenceURI] [varchar](255) NULL,
	[TypificationNotes] [nvarchar](200) NULL,
	[TypeSubstrate] [nvarchar](255) NULL,
	[TypeLocality] [nvarchar](255) NULL,
	[TypeSpecimenNotes] [nvarchar](200) NULL,
	[AnamorphTeleomorph] [nvarchar](255) NULL,
	[TypistNotes] [nvarchar](200) NULL,
	[RevisionLevel] [nvarchar](50) NULL,
	[IgnoreButKeepForReference] [bit] NULL,
	[DataWithholdingReason] [nvarchar](255) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonName] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameList]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameList](
	[NameID] [int] NOT NULL,
	[ProjectID] [int] NOT NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameList] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ProjectID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListDistribution]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListDistribution](
	[NameID] [int] NOT NULL,
	[ProjectID] [int] NOT NULL,
	[PlaceURI] [varchar](255) NOT NULL,
	[PlaceNameCache] [nvarchar](255) NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameListDistribution] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ProjectID] ASC,
	[PlaceURI] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameExternalDatabase]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameExternalDatabase](
	[ExternalDatabaseID] [int] NOT NULL,
	[ExternalDatabaseName] [nvarchar](255) NULL,
	[ExternalDatabaseVersion] [nvarchar](255) NULL,
	[Rights] [nvarchar](500) NULL,
	[ExternalDatabaseAuthors] [nvarchar](200) NULL,
	[ExternalDatabaseURI] [nvarchar](300) NULL,
	[ExternalDatabaseInstitution] [nvarchar](300) NULL,
	[InternalNotes] [nvarchar](1500) NULL,
	[ExternalAttribute_NameID] [nvarchar](255) NULL,
	[PreferredSequence] [tinyint] NULL,
	[Disabled] [bit] NULL,
 CONSTRAINT [PK_TaxonNameExternalDatabase] PRIMARY KEY CLUSTERED 
(
	[ExternalDatabaseID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameExternalID]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameExternalID](
	[NameID] [int] NOT NULL,
	[ExternalDatabaseID] [int] NOT NULL,
	[ExternalNameURI] [varchar](255) NULL,
 CONSTRAINT [PK_TaxonNameExternalID] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ExternalDatabaseID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameProject]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameProject](
	[NameID] [int] NOT NULL,
	[ProjectID] [int] NOT NULL,
	[LogInsertedWhen] [datetime] NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameProject] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ProjectID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonHierarchy]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonHierarchy](
	[ProjectID] [int] NOT NULL,
	[NameID] [int] NOT NULL,
	[IgnoreButKeepForReference] [tinyint] NOT NULL,
	[NameParentID] [int] NULL,
	[HierarchyRefURI] [varchar](255) NULL,
	[HierarchyRefText] [nvarchar](255) NULL,
	[HierarchyRefDetail] [nvarchar](255) NULL,
	[HierarchyPositionIsUncertain] [bit] NULL,
	[HierarchyTypistsNotes] [nvarchar](255) NULL,
	[HierarchyListCache] [nvarchar](1000) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonHierarchy] PRIMARY KEY CLUSTERED 
(
	[ProjectID] ASC,
	[NameID] ASC,
	[IgnoreButKeepForReference] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonAcceptedName]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonAcceptedName](
	[ProjectID] [int] NOT NULL,
	[NameID] [int] NOT NULL,
	[IgnoreButKeepForReference] [tinyint] NOT NULL,
	[ConceptSuffix] [nvarchar](200) NULL,
	[ConceptNotes] [nvarchar](500) NULL,
	[RefURI] [varchar](255) NULL,
	[RefText] [nvarchar](255) NULL,
	[RefDetail] [nvarchar](255) NULL,
	[TypistsNotes] [nvarchar](255) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonAcceptedName] PRIMARY KEY CLUSTERED 
(
	[ProjectID] ASC,
	[NameID] ASC,
	[IgnoreButKeepForReference] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LanguageCode_Enum]    Script Date: 02/22/2010 13:42:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LanguageCode_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
 CONSTRAINT [PK_LanguageCode_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonCommonName]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonCommonName](
	[NameID] [int] NOT NULL,
	[CommonName] [nvarchar](300) NOT NULL,
	[LanguageCode] [nvarchar](50) NOT NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonCommonName] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[CommonName] ASC,
	[LanguageCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameSynonymisationType_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameSynonymisationType_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameSynonymizationType_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonSynonymy]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonSynonymy](
	[ProjectID] [int] NOT NULL,
	[NameID] [int] NOT NULL,
	[SynNameID] [int] NOT NULL,
	[IgnoreButKeepForReference] [tinyint] NOT NULL,
	[ConceptSuffix] [nvarchar](200) NULL,
	[ConceptNotes] [nvarchar](500) NULL,
	[SynRefURI] [varchar](255) NULL,
	[SynRefText] [nvarchar](255) NULL,
	[SynRefDetail] [nvarchar](255) NULL,
	[SynTypistsNotes] [nvarchar](255) NULL,
	[SynType] [nvarchar](50) NOT NULL,
	[SynIsUncertain] [bit] NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_FungusSynonymy] PRIMARY KEY CLUSTERED 
(
	[ProjectID] ASC,
	[NameID] ASC,
	[SynNameID] ASC,
	[IgnoreButKeepForReference] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListReferenceType_Enum]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListReferenceType_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[ParentCode] [nvarchar](50) NULL,
 CONSTRAINT [PK_TaxonNameListReferenceType_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListReference]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListReference](
	[NameID] [int] NOT NULL,
	[ProjectID] [int] NOT NULL,
	[TaxonNameListRefText] [nvarchar](255) NOT NULL,
	[TaxonNameListRefURI] [varchar](255) NULL,
	[TaxonNameListRefDetail] [nvarchar](255) NULL,
	[ReferenceType] [nvarchar](50) NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameListReference] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ProjectID] ASC,
	[TaxonNameListRefText] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListAnalysisCategory]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListAnalysisCategory](
	[AnalysisID] [int] IDENTITY(1,1) NOT NULL,
	[AnalysisParentID] [int] NULL,
	[DisplayText] [nvarchar](50) NULL,
	[Description] [nvarchar](max) NULL,
	[AnalysisURI] [varchar](255) NULL,
	[Notes] [nvarchar](max) NULL,
	[LogCreatedWhen] [datetime] NULL,
	[LogCreatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_IdentificationAnalysis] PRIMARY KEY CLUSTERED 
(
	[AnalysisID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListAnalysis]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListAnalysis](
	[NameID] [int] NOT NULL,
	[ProjectID] [int] NOT NULL,
	[AnalysisID] [int] NOT NULL,
	[AnalysisValue] [nvarchar](255) NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameListAnalysis] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[ProjectID] ASC,
	[AnalysisID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonGeography]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonGeography](
	[NameID] [int] NOT NULL,
	[PlaceURI] [varchar](255) NOT NULL,
	[PlaceNameCache] [nvarchar](100) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameGeography] PRIMARY KEY CLUSTERED 
(
	[NameID] ASC,
	[PlaceURI] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListArea]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListArea](
	[ProjectID] [int] NOT NULL,
	[PlaceURI] [varchar](255) NOT NULL,
	[PlaceNameCache] [nvarchar](255) NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TaxonNameListArea_1] PRIMARY KEY CLUSTERED 
(
	[ProjectID] ASC,
	[PlaceURI] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TaxonNameListAnalysisCategoryValue]    Script Date: 02/22/2010 13:42:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxonNameListAnalysisCategoryValue](
	[AnalysisID] [int] NOT NULL,
	[AnalysisValue] [nvarchar](255) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[Notes] [nvarchar](500) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_ChecklistAnalysisCategoryValue] PRIMARY KEY CLUSTERED 
(
	[AnalysisID] ASC,
	[AnalysisValue] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF_TaxonAcceptedName_Project]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_Project]  DEFAULT (0) FOR [ProjectID]
GO
/****** Object:  Default [DF_TaxonAcceptedName_IgnoreButKeepForReference1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_IgnoreButKeepForReference1]  DEFAULT (0) FOR [IgnoreButKeepForReference]
GO
/****** Object:  Default [DF_TaxonAcceptedName_ConceptSuffix_1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_ConceptSuffix_1]  DEFAULT ('') FOR [ConceptSuffix]
GO
/****** Object:  Default [DF_TaxonAcceptedName_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonAcceptedName_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonAcceptedName_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonAcceptedName_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonAcceptedName] ADD  CONSTRAINT [DF_TaxonAcceptedName_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonGeography_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonGeography] ADD  CONSTRAINT [DF_TaxonGeography_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonGeography_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonGeography] ADD  CONSTRAINT [DF_TaxonGeography_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonGeography_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonGeography] ADD  CONSTRAINT [DF_TaxonGeography_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonGeography_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonGeography] ADD  CONSTRAINT [DF_TaxonGeography_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonHierarchy_Project]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_Project]  DEFAULT (0) FOR [ProjectID]
GO
/****** Object:  Default [DF_TaxonHierarchy_IgnoreButKeepForReference_1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_IgnoreButKeepForReference_1]  DEFAULT (0) FOR [IgnoreButKeepForReference]
GO
/****** Object:  Default [DF_TaxonHierarchy_HierarchyPositionIsUncertain]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_HierarchyPositionIsUncertain]  DEFAULT (0) FOR [HierarchyPositionIsUncertain]
GO
/****** Object:  Default [DF_TaxonHierarchy_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonHierarchy_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonHierarchy_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonHierarchy_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonHierarchy] ADD  CONSTRAINT [DF_TaxonHierarchy_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonName_Version_1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_Version_1]  DEFAULT ((1)) FOR [Version]
GO
/****** Object:  Default [DF_TaxonName_TaxonomicRank]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_TaxonomicRank]  DEFAULT (N'sp.') FOR [TaxonomicRank]
GO
/****** Object:  Default [DF_TaxonName_IsRecombination_1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_IsRecombination_1]  DEFAULT ((0)) FOR [IsRecombination]
GO
/****** Object:  Default [DF_TaxonName_IsHybrid]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_IsHybrid]  DEFAULT ((0)) FOR [IsHybrid]
GO
/****** Object:  Default [DF_TaxonName_IgnoreButKeepForReference_1]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_IgnoreButKeepForReference_1]  DEFAULT ((0)) FOR [IgnoreButKeepForReference]
GO
/****** Object:  Default [DF_TaxonName_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonName_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonName_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonName_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonName] ADD  CONSTRAINT [DF_TaxonName_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonChecklist_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameList] ADD  CONSTRAINT [DF_TaxonChecklist_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonChecklist_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameList] ADD  CONSTRAINT [DF_TaxonChecklist_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonChecklist_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameList] ADD  CONSTRAINT [DF_TaxonChecklist_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonChecklist_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameList] ADD  CONSTRAINT [DF_TaxonChecklist_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonChecklistAnalysis_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysis] ADD  CONSTRAINT [DF_TaxonChecklistAnalysis_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonChecklistAnalysis_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysis] ADD  CONSTRAINT [DF_TaxonChecklistAnalysis_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonChecklistAnalysis_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysis] ADD  CONSTRAINT [DF_TaxonChecklistAnalysis_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonChecklistAnalysis_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysis] ADD  CONSTRAINT [DF_TaxonChecklistAnalysis_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategory_LogCreatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategory] ADD  CONSTRAINT [DF_ChecklistAnalysisCategory_LogCreatedWhen]  DEFAULT (getdate()) FOR [LogCreatedWhen]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategory_LogCreatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategory] ADD  CONSTRAINT [DF_ChecklistAnalysisCategory_LogCreatedBy]  DEFAULT (user_name()) FOR [LogCreatedBy]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategory_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategory] ADD  CONSTRAINT [DF_ChecklistAnalysisCategory_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategory_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategory] ADD  CONSTRAINT [DF_ChecklistAnalysisCategory_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategoryValue_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategoryValue] ADD  CONSTRAINT [DF_ChecklistAnalysisCategoryValue_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategoryValue_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategoryValue] ADD  CONSTRAINT [DF_ChecklistAnalysisCategoryValue_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategoryValue_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategoryValue] ADD  CONSTRAINT [DF_ChecklistAnalysisCategoryValue_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_ChecklistAnalysisCategoryValue_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListAnalysisCategoryValue] ADD  CONSTRAINT [DF_ChecklistAnalysisCategoryValue_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonNameListArea_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListArea] ADD  CONSTRAINT [DF_TaxonNameListArea_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonNameListArea_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListArea] ADD  CONSTRAINT [DF_TaxonNameListArea_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonNameListArea_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListArea] ADD  CONSTRAINT [DF_TaxonNameListArea_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonNameListArea_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListArea] ADD  CONSTRAINT [DF_TaxonNameListArea_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonNameListDistribution_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListDistribution] ADD  CONSTRAINT [DF_TaxonNameListDistribution_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonNameListDistribution_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListDistribution] ADD  CONSTRAINT [DF_TaxonNameListDistribution_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonNameListDistribution_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListDistribution] ADD  CONSTRAINT [DF_TaxonNameListDistribution_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonNameListDistribution_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListDistribution] ADD  CONSTRAINT [DF_TaxonNameListDistribution_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonNameListReference_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListReference] ADD  CONSTRAINT [DF_TaxonNameListReference_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonNameListReference_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListReference] ADD  CONSTRAINT [DF_TaxonNameListReference_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonNameListReference_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListReference] ADD  CONSTRAINT [DF_TaxonNameListReference_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonNameListReference_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameListReference] ADD  CONSTRAINT [DF_TaxonNameListReference_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonNameProject_ProjectID]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameProject] ADD  CONSTRAINT [DF_TaxonNameProject_ProjectID]  DEFAULT (0) FOR [ProjectID]
GO
/****** Object:  Default [DF_TaxonNameProject_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameProject] ADD  CONSTRAINT [DF_TaxonNameProject_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonNameProject_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameProject] ADD  CONSTRAINT [DF_TaxonNameProject_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonNameProject_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameProject] ADD  CONSTRAINT [DF_TaxonNameProject_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TaxonNameProject_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonNameProject] ADD  CONSTRAINT [DF_TaxonNameProject_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonSynonymy_Project]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_Project]  DEFAULT ((0)) FOR [ProjectID]
GO
/****** Object:  Default [DF_TaxonSynonymy_IgnoreButKeepForReference]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_IgnoreButKeepForReference]  DEFAULT ((0)) FOR [IgnoreButKeepForReference]
GO
/****** Object:  Default [DF_TaxonSynonymy_ConceptSuffix]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_ConceptSuffix]  DEFAULT ('') FOR [ConceptSuffix]
GO
/****** Object:  Default [DF_TaxonSynonymy_SynType]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_SynType]  DEFAULT ('unknown') FOR [SynType]
GO
/****** Object:  Default [DF_TaxonSynonymy_SynIsUncertain]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_SynIsUncertain]  DEFAULT ((0)) FOR [SynIsUncertain]
GO
/****** Object:  Default [DF_TaxonSynonymy_LogInsertedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TaxonSynonymy_LogInsertedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TaxonSynonymy_LogUpdatedBy]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TaxonSynonymy_LogUpdatedWhen]    Script Date: 02/22/2010 13:42:12 ******/
ALTER TABLE [dbo].[TaxonSynonymy] ADD  CONSTRAINT [DF_TaxonSynonymy_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO