/* DocShop SQL Table Changes Needed at HRF, MVV, FBG
/* 
/* ALTER TABLE [Documents] ALTER COLUMN [Description] [nvarchar] (300) NULL ;
/* ALTER TABLE [Documents] ALTER COLUMN [Path] [nvarchar] (400) NULL ;
/* ALTER TABLE [DocHistory] ALTER COLUMN [Path] [nvarchar] (400) NULL ;
/* ALTER TABLE [DocVersions] ALTER COLUMN [Path] [nvarchar] (400) NULL ;
/* ALTER TABLE [DocVersions] ALTER COLUMN [Description] [nvarchar] (300) NULL 
/* 
/* 

/*****************************************************************/
/*                                                               */
/*              WORDTRICKS SQL DATABASE SCHEMA                   */
/*              Version 9.1                                      */
/*              Master File Including DoxShop                    */
/*                                                               */
/*              Copyright 2004 WordTricks Development, LLC       */
/*              All Rights Resvered                              */
/*                                                               */
/*                                      Author:  Bill Denney     */
/*                                        Date:  05/27/2005      */
/*                                                               */
/*****************************************************************/

/*******  LIST OF TABLES  *************************************************************/
/*                                                                                    */
/*   /*** Core Tables ************************************************************/   */
/*   /*                                                                          */   */
/*   /*   FirmInfo           Firm and Site Information                 T A B L E */   */
/*   /*   SystemControl      System Revision Information               T A B L E */   */
/*   /*   FeatureSet         Active Features and Keystrokes            T A B L E */   */
/*   /*   Locations          Location and Department List              T A B L E */   */
/*   /*   SiteServices       Multi-Site List Details                   T A B L E */   */
/*   /*   Users              User Logins and Preferences               T A B L E */   */
/*   /*   Authors            Document Authors and Preferences          T A B L E */   */
/*   /*                                                                          */   */
/*   /****************************************************************************/   */
/*                                                                                    */
/*   /*** WordTricks Standard Tables *********************************************/   */
/*   /*                                                                          */   */
/*   /*   LtrStyles          Letter Generator Styles and Templates     T A B L E */   */
/*   /*   FaxStyles          Fax Generator Styles and Templates        T A B L E */   */
/*   /*   MemoStyles         Memo Generator Styles and Templates       T A B L E */   */
/*   /*                                                                          */   */
/*   /****************************************************************************/   */
/*                                                                                    */
/*   /*** ListTricks Tables ******************************************************/   */
/*   /*                                                                          */   */
/*   /*   ListSystem         List System Groups                        T A B L E */   */
/*   /*   ListSchemes        Primary List of Numbering Schemes         T A B L E */   */
/*   /*   ListLevels         Subordinate Scheme Info each 9 Levels     T A B L E */   */
/*   /*   ListPatterns       Default Numbering Patterns                T A B L E */   */
/*   /*   GroupSchemes       Relational Tbl Assoc. Schemes to Groups   T A B L E */   */
/*   /*                                                                          */   */
/*   /****************************************************************************/   */
/*                                                                                    */
/*   /*** QlickForms Tables ******************************************************/   */
/*   /*                                                                          */   */
/*   /*   FormPracticeAreas  Form Library or Practice Area List        T A B L E */   */
/*   /*   FormCategories     Form Category List                        T A B L E */   */
/*   /*   FormObjects        Forms and Clauses List of Objects         T A B L E */   */
/*   /*                                                                          */   */
/*   /****************************************************************************/   */
/*                                                                                    */
/*   /*** DoxShop Tables *********************************************************/   */
/*   /*                                                                          */   */
/*   /*   DocSystem          Document Management System Settings       T A B L E */   */
/*   /*   Documents          Main Documents Repository                 T A B L E */   */
/*   /*   DocVersions        Secondary Table - Multi-Version Doc Info  T A B L E */   */
/*   /*   DocDirs            Document Directories                      T A B L E */   */
/*   /*   DocHistory         Document Activity and Work-List Info      T A B L E */   */
/*   /*   DocCategories      List of Document Categories               T A B L E */   */
/*   /*   DocTypes           List of Document (Application) Types      T A B L E */   */
/*   /*   DocActions         Lookup List of Document Actions           T A B L E */   */
/*   /*   DocClients         Lookup List of Clients                    T A B L E */   */
/*   /*   DocMatters         Lookup List of Matters                    T A B L E */   */
/*   /*   DocFileNums        Lookup List of Job or File Numbers        T A B L E */   */
/*   /*   DocSubMatters      Lookup List of sub-Matters                T A B L E */   */
/*   /*                                                                          */   */
/*   /****************************************************************************/   */
/*                                                                                    */
/**************************************************************************************/


CREATE DATABASE [WordTricks]
GO

USE [WordTricks]
GO


if not exists (select * from master.dbo.syslogins where loginname = N'WTX')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'us_english'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'WTX', null, @logindb, @loginlang
END
GO


EXEC sp_addsrvrolemember N'WTX', sysadmin
GO

if not exists (select * from dbo.sysusers where name = N'WTX' and uid < 16382)
	EXEC sp_grantdbaccess N'WTX', N'WTX'
GO

exec sp_addrolemember N'db_owner', N'WTX'
GO

/*******  T A B L E S  ***********************************************************/

/*******  Core Tables ************************************************************/

/*******  FirmInfo           Firm and Site Information                 T A B L E */

CREATE TABLE [FirmInfo] (
	[RecordID] [int] NOT NULL ,
	[FirmID] [nvarchar] (10) NULL ,
	[FormalName] [nvarchar] (80) NULL ,
	[InformalName] [nvarchar] (80) NULL ,
	[UpperCaseName] [nvarchar] (80) NULL ,
	[PhoneMain] [nvarchar] (20) NULL ,
	[PhoneAlt1] [nvarchar] (20) NULL ,
	[PhoneAlt2] [nvarchar] (20) NULL ,
	[PhoneFaxMain] [nvarchar] (20) NULL ,
	[PhoneFaxAlt1] [nvarchar] (20) NULL ,
	[PhoneFaxAlt2] [nvarchar] (20) NULL ,
	[AdminEmailAddress] [nvarchar] (50) NULL ,
	[DomainName] [nvarchar] (50) NULL ,
	[WebSite] [nvarchar] (50) NULL ,
	[SerialNumber] [nvarchar] (50) NULL ,
	[Password] [nvarchar] (30) NULL ,
	[AddressPrimary] [ntext] NULL ,
	[AddressPO] [ntext] NULL ,
	[AddressCOS] [ntext] NULL ,
	[AddressPleading] [ntext] NULL ,
	[DocManagementType] [nvarchar] (10) NULL ,
	[CompareApplication] [nvarchar] (50) NULL ,
	[AuxApplication1] [nvarchar] (50) NULL ,
	[AuxApplication2] [nvarchar] (50) NULL ,
	[RevisionNum] [int] NULL ,
	[CCform] [nvarchar] (15) NULL ,
	[BCCform] [nvarchar] (15) NULL ,
	[NetworkDBpath] [nvarchar] (80) NULL ,
	[ClientKey] [nvarchar] (30) NULL ,
	[DefaultFont] [nvarchar] (32) NULL ,
	[DefaultFontSize] [int] NULL ,
	[DescFirmUtilityText1] [nvarchar] (50) NULL ,
	[DescFirmUtilityText2] [nvarchar] (50) NULL ,
	[DescFirmUtilityText3] [nvarchar] (50) NULL ,
	[DescFirmUtilityMemo] [nvarchar] (50) NULL ,
	[DescFirmUtilityBool1] [nvarchar] (50) NULL ,
	[DescFirmUtilityBool2] [nvarchar] (50) NULL ,
	[UtilityText1] [nvarchar] (50) NULL ,
	[UtilityText2] [nvarchar] (50) NULL ,
	[UtilityText3] [nvarchar] (50) NULL ,
	[UtilityMemo] [ntext] NULL ,
	[UtilityBool1] [nvarchar] (6) NULL ,
	[UtilityBool2] [nvarchar] (6) NULL ,
	[DescUserUtilityText1] [nvarchar] (50) NULL ,
	[DescUserUtilityText2] [nvarchar] (50) NULL ,
	[DescUserUtilityText3] [nvarchar] (50) NULL ,
	[DescUserUtilityMemo] [nvarchar] (50) NULL ,
	[DescUserUtilityBool1] [nvarchar] (50) NULL ,
	[DescUserUtilityBool2] [nvarchar] (50) NULL ,
	[DescAuthorUtilityText1] [nvarchar] (50) NULL ,
	[DescAuthorUtilityText2] [nvarchar] (50) NULL ,
	[DescAuthorUtilityText3] [nvarchar] (50) NULL ,
	[DescAuthorUtilityMemo] [nvarchar] (50) NULL ,
	[DescAuthorUtilityBool1] [nvarchar] (50) NULL ,
	[DescAuthorUtilityBool2] [nvarchar] (50) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [FirmInfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_FirmInfo] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

INSERT INTO FirmINFO (RecordID) Values (1)
GO

/*******  SystemControl      System Revision Information               T A B L E */

CREATE TABLE [SystemControl] (
	[VerSystem] [int] NULL ,
	[VerFeatureSet] [int] NULL ,
	[VerFirmInfo] [int] NULL ,
	[VerAuthors] [int] NULL ,
	[VerUsers] [int] NULL ,
	[VerLocations] [int] NULL ,
	[VerLtrStyles] [int] NULL ,
	[VerFaxStyles] [int] NULL ,
	[VerMemoStyles] [int] NULL ,
	[VerForms] [int] NULL ,
	[VerPara] [int] NULL ,
	[AutoUpdateVersions] [nvarchar] (6) NULL ,
	[VerListSystem] [float] NULL ,
	[VerListPatterns] [float] NULL ,
	[VerGroupSchemes] [float] NULL ) ON [PRIMARY]
GO


/*******  FeatureSet         Active Features and Keystrokes            T A B L E */

CREATE TABLE [FeatureSet] (
	[ID] [int] NOT NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[OnMenu] [nvarchar] (6) NULL ,
	[MenuNumber] [int] NULL ,
	[ShortcutKey] [nvarchar] (15) NULL ,
	[ButtonNumber] [int] NULL ,
	[Feature] [nvarchar] (50) NULL ,
	[Title] [nvarchar] (75) NULL ,
	[Description] [ntext] NULL ,
	[KeyStroke] [nvarchar] (20) NULL ,
	[UseShift] [nvarchar] (6) NULL ,
	[UseCtrl] [nvarchar] (6) NULL ,
	[UseAlt] [nvarchar] (6) NULL ,
	[OrigWordFeature] [nvarchar] (100) NULL ,
	[Category] [nvarchar] (50) NULL ,
	[Comments] [ntext] NULL ,
	[ModLocation] [nvarchar] (50) NULL ,
	[AdminOnly] [nvarchar] (6) NULL ,
	[Section] [nvarchar] (50) NULL ,
	[PercentComplete] [int] NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [FeatureSet] WITH NOCHECK ADD 
	CONSTRAINT [PK_FeatureSet] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

/*******  Locations          Location and Department List              T A B L E */

CREATE TABLE [Locations] (
	[ID] [int] NOT NULL ,
	[LocationID] [nvarchar] (10) NULL ,
	[DepartmentID] [nvarchar] (10) NULL ,
	[LocationName] [nvarchar] (50) NULL ,
	[DepartmentName] [nvarchar] (50) NULL ,
	[AddressLine1] [nvarchar] (100) NULL ,
	[AddressLine2] [nvarchar] (100) NULL ,
	[AddressLine3] [nvarchar] (100) NULL ,
	[AddressLine4] [nvarchar] (100) NULL ,
	[AddressLine5] [nvarchar] (100) NULL ,
	[VoicePhone1] [nvarchar] (25) NULL ,
	[VoicePhone2] [nvarchar] (25) NULL ,
	[VoicePhone3] [nvarchar] (25) NULL ,
	[FaxPhone1] [nvarchar] (25) NULL ,
	[FaxPhone2] [nvarchar] (25) NULL ,
	[Email1] [nvarchar] (60) NULL ,
	[Email2] [nvarchar] (60) NULL ,
	[Web1] [nvarchar] (60) NULL ,
	[Web2] [nvarchar] (60) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [Locations] WITH NOCHECK ADD 
	CONSTRAINT [PK_Locations] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_Locations] ON [Locations]([LocationID]) ON [PRIMARY]
GO


/*******  SiteServices       Multi-Site List Details                   T A B L E */

CREATE TABLE [SiteServices] (
	[SiteNumber] [int] NOT NULL ,
	[Description] [nvarchar] (50) NULL ,
	[IsMaster] [int] NULL ,
	[IsActive] [int] NULL ,
	[UncPath] [nvarchar] (200) NULL ,
	[DataProvider] [nvarchar] (200) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [SiteServices] WITH NOCHECK ADD 
	CONSTRAINT [PK_SiteServices] PRIMARY KEY  CLUSTERED 
	(
		[SiteNumber]
	)  ON [PRIMARY] 
GO


/*******  Users              User Logins and Preferences               T A B L E */

CREATE TABLE [Users] (
	[ID] [int] NOT NULL ,
	[UserID] [nvarchar] (20) NOT NULL ,
	[UseCounter] [int] NULL ,
	[Author1] [nvarchar] (20) NULL ,
	[Author2] [nvarchar] (20) NULL ,
	[Author3] [nvarchar] (20) NULL ,
	[Author4] [nvarchar] (20) NULL ,
	[Author5] [nvarchar] (20) NULL ,
	[Author6] [nvarchar] (20) NULL ,
	[Author7] [nvarchar] (20) NULL ,
	[Author8] [nvarchar] (20) NULL ,
	[Author9] [nvarchar] (20) NULL ,
	[Author10] [nvarchar] (20) NULL ,
	[ClearFax] [nvarchar] (6) NULL ,
	[ChainSignature] [nvarchar] (6) NULL ,
	[FullName] [nvarchar] (50) NULL ,
	[PromptAddressee] [nvarchar] (6) NULL ,
	[DefaultPracticeArea] [int] NULL ,
	[DefaultFormCategory] [int] NULL ,
	[DefaultFont] [nvarchar] (32) NULL ,
	[DefaultFontSize] [int] NULL ,
	[FloatingUser] [nvarchar] (6) NULL ,
	[NetUserPath] [nvarchar] (60) NULL ,
	[PhoneContact] [nvarchar] (20) NULL ,
	[AdminUser] [nvarchar] (6) NULL ,
	[UtilityText1] [nvarchar] (50) NULL ,
	[UtilityText2] [nvarchar] (50) NULL ,
	[UtilityText3] [nvarchar] (50) NULL ,
	[UtilityMemo] [ntext] NULL ,
	[UtilityBool1] [nvarchar] (6) NULL ,
	[UtilityBool2] [nvarchar] (6) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [Users] WITH NOCHECK ADD 
	CONSTRAINT [PK_Users] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_Users] ON [Users]([UserID]) ON [PRIMARY]
GO


/*******  Authors            Document Authors and Preferences          T A B L E */

CREATE TABLE [Authors] (
	[ID] [int] NOT NULL ,
	[AuthorID] [nvarchar] (20) NOT NULL ,
	[AuthorFullName] [nvarchar] (50) NULL ,
	[EmailAddress] [nvarchar] (70) NULL ,
	[BarCertNum] [nvarchar] (25) NULL ,
	[Alt1BarNum] [nvarchar] (25) NULL ,
	[Alt2BarNum] [nvarchar] (25) NULL ,
	[PhoneDID] [nvarchar] (20) NULL ,
	[PhoneFAX] [nvarchar] (20) NULL ,
	[PhoneOther] [nvarchar] (20) NULL ,
	[Category] [nvarchar] (15) NULL ,
	[NameOnMemo] [nvarchar] (40) NULL ,
	[NameOnFax] [nvarchar] (40) NULL ,
	[NameOnPleading] [nvarchar] (40) NULL ,
	[NameOnCOS] [nvarchar] (40) NULL ,
	[NameOnOther] [nvarchar] (40) NULL ,
	[TitleForLetterhead] [nvarchar] (150) NULL ,
	[TitleForSignature] [nvarchar] (150) NULL ,
	[ClosingInitials] [nvarchar] (10) NULL ,
	[StartLetterDraft] [nvarchar] (6) NULL ,
	[StartLetterDateText] [nvarchar] (6) NULL ,
	[StartLetterDateCode] [nvarchar] (6) NULL ,
	[StartLetterDateConvert] [nvarchar] (6) NULL ,
	[StylesOfLetters] [nvarchar] (20) NULL ,
	[StylesOfFaxes] [nvarchar] (20) NULL ,
	[StylesOfMemos] [nvarchar] (20) NULL ,
	[LetterSignatureBlock] [ntext] NULL ,
	[Location] [int] NULL ,
	[DefaultParaStyle] [int] NULL ,
	[AdmittedIn] [nvarchar] (150) NULL ,
	[TimeKeeperID] [nvarchar] (30) NULL ,
	[AreaOfLaw] [nvarchar] (30) NULL ,
	[DefaultFont] [nvarchar] (32) NULL ,
	[DefaultFontSize] [int] NULL ,
	[FaxContactUser] [nvarchar] (25) NULL ,
	[UtilityText1] [nvarchar] (50) NULL ,
	[UtilityText2] [nvarchar] (50) NULL ,
	[UtilityText3] [nvarchar] (50) NULL ,
	[UtilityMemo] [ntext] NULL ,
	[UtilityBool1] [nvarchar] (6) NULL ,
	[UtilityBool2] [nvarchar] (6) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [Authors] WITH NOCHECK ADD 
	CONSTRAINT [PK_Authors] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_Authors] ON [Authors]([AuthorID]) ON [PRIMARY]
GO


/*******  WordTricks Standard Tables *********************************************/

/*******  LtrStyles          Letter Generator Styles and Templates     T A B L E */

CREATE TABLE [LtrStyles] (
	[LetterStyleID] [int] NOT NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[ShortDescription] [nvarchar] (50) NULL ,
	[LongDescription] [nvarchar] (200) NULL ,
	[LetterPath] [nvarchar] (100) NULL ,
	[HeaderSpacing] [int] NULL ,
	[viaCaption1] [nvarchar] (14) NULL ,
	[viaCaption2] [nvarchar] (14) NULL ,
	[viaCaption3] [nvarchar] (14) NULL ,
	[viaCaption4] [nvarchar] (20) NULL ,
	[viaCaption5] [nvarchar] (20) NULL ,
	[viaCaption6] [nvarchar] (20) NULL ,
	[viaCaption7] [nvarchar] (28) NULL ,
	[viaCaption8] [nvarchar] (28) NULL ,
	[viaText1] [ntext] NULL ,
	[viaText2] [ntext] NULL ,
	[viaText3] [ntext] NULL ,
	[viaText4] [ntext] NULL ,
	[viaText5] [ntext] NULL ,
	[viaText6] [ntext] NULL ,
	[viaText7] [ntext] NULL ,
	[viaText8] [ntext] NULL ,
	[viaAlign1] [nvarchar] (1) NULL ,
	[viaAlign2] [nvarchar] (1) NULL ,
	[viaAlign3] [nvarchar] (1) NULL ,
	[viaAlign4] [nvarchar] (1) NULL ,
	[viaAlign5] [nvarchar] (1) NULL ,
	[viaAlign6] [nvarchar] (1) NULL ,
	[viaAlign7] [nvarchar] (1) NULL ,
	[viaAlign8] [nvarchar] (1) NULL ,
	[viaBold1] [nvarchar] (6) NULL ,
	[viaBold2] [nvarchar] (6) NULL ,
	[viaBold3] [nvarchar] (6) NULL ,
	[viaBold4] [nvarchar] (6) NULL ,
	[viaBold5] [nvarchar] (6) NULL ,
	[viaBold6] [nvarchar] (6) NULL ,
	[viaBold7] [nvarchar] (6) NULL ,
	[viaBold8] [nvarchar] (6) NULL ,
	[viaUnderline1] [nvarchar] (6) NULL ,
	[viaUnderline2] [nvarchar] (6) NULL ,
	[viaUnderline3] [nvarchar] (6) NULL ,
	[viaUnderline4] [nvarchar] (6) NULL ,
	[viaUnderline5] [nvarchar] (6) NULL ,
	[viaUnderline6] [nvarchar] (6) NULL ,
	[viaUnderline7] [nvarchar] (6) NULL ,
	[viaUnderline8] [nvarchar] (6) NULL ,
	[DraftStampTopPos] [nvarchar] (20) NULL ,
	[DraftStampLeftPos] [nvarchar] (20) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [LtrStyles] WITH NOCHECK ADD 
	CONSTRAINT [PK_LtrStyles] PRIMARY KEY  CLUSTERED 
	(
		[LetterStyleID]
	)  ON [PRIMARY] 
GO


/*******  FaxStyles          Fax Generator Styles and Templates        T A B L E */

CREATE TABLE [FaxStyles] (
	[FaxStyleID] [int] NOT NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[ShortDescription] [nvarchar] (50) NULL ,
	[LongDescription] [nvarchar] (200) NULL ,
	[FaxPath] [nvarchar] (100) NULL ,
	[Field1Desc] [nvarchar] (50) NULL ,
	[Field2Desc] [nvarchar] (50) NULL ,
	[Field3Desc] [nvarchar] (50) NULL ,
	[Field4Desc] [nvarchar] (50) NULL ,
	[Field5Desc] [nvarchar] (50) NULL ,
	[Field6Desc] [nvarchar] (50) NULL ,
	[Field7Desc] [nvarchar] (50) NULL ,
	[Field8Desc] [nvarchar] (50) NULL ,
	[Field9Desc] [nvarchar] (50) NULL ,
	[FieldForCompanyName] [int] NULL ,
	[FieldForBusinessTelephoneNumber] [int] NULL ,
	[FieldForBusinessFaxNumber] [int] NULL ,
	[FieldForRecipientName] [int] NULL ,
	[FieldForBillingInformation] [int] NULL ,
	[ToolTip1] [nvarchar] (200) NULL ,
	[ToolTip2] [nvarchar] (200) NULL ,
	[ToolTip3] [nvarchar] (200) NULL ,
	[ToolTip4] [nvarchar] (200) NULL ,
	[ToolTip5] [nvarchar] (200) NULL ,
	[ToolTip6] [nvarchar] (200) NULL ,
	[ToolTip7] [nvarchar] (200) NULL ,
	[ToolTip8] [nvarchar] (200) NULL ,
	[ToolTip9] [nvarchar] (200) NULL ,
	[DraftStampTopPos] [nvarchar] (20) NULL ,
	[DraftStampLeftPos] [nvarchar] (20) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [FaxStyles] WITH NOCHECK ADD 
	CONSTRAINT [PK_FaxStyles] PRIMARY KEY  CLUSTERED 
	(
		[FaxStyleID]
	)  ON [PRIMARY] 
GO


/*******  MemoStyles         Memo Generator Styles and Templates       T A B L E */

CREATE TABLE [MemoStyles] (
	[MemoStyleID] [int] NOT NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[ShortDescription] [nvarchar] (50) NULL ,
	[LongDescription] [nvarchar] (200) NULL ,
	[MemoPath] [nvarchar] (100) NULL ,
	[Field1Desc] [nvarchar] (50) NULL ,
	[Field2Desc] [nvarchar] (50) NULL ,
	[Field3Desc] [nvarchar] (50) NULL ,
	[Field4Desc] [nvarchar] (50) NULL ,
	[Field5Desc] [nvarchar] (50) NULL ,
	[Field6Desc] [nvarchar] (50) NULL ,
	[AutoDateField] [int] NULL ,
	[AutoFromField] [int] NULL ,
	[DraftStampTopPos] [nvarchar] (20) NULL ,
	[DraftStampLeftPos] [nvarchar] (20) NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [MemoStyles] WITH NOCHECK ADD 
	CONSTRAINT [PK_MemoStyles] PRIMARY KEY  CLUSTERED 
	(
		[MemoStyleID]
	)  ON [PRIMARY] 
GO


/*******  ListTricks Tables ******************************************************/

/*******  ListSystem         List System Groups                        T A B L E */

CREATE TABLE [ListSystem] (
	[GroupID] [int] NOT NULL ,
	[GroupName] [nvarchar] (20) NOT NULL ,
	[GroupDescription] [nvarchar] (100) NULL ,
	[VersionNum] [int] NULL ,
	[Visibility] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [ListSystem] WITH NOCHECK ADD 
	CONSTRAINT [PK_ListSystem] PRIMARY KEY  CLUSTERED 
	(
		[GroupID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_ListSystem] ON [ListSystem]([GroupName]) ON [PRIMARY]
GO


/*******  ListSchemes        Primary List of Numbering Schemes         T A B L E */

CREATE TABLE [ListSchemes] (
	[SchemeID] [int] NOT NULL ,
	[VersionNum] [decimal](18, 0) NULL ,
	[Description] [nvarchar] (50) NULL ,
	[Active] [int] NULL ,
	[GroupID] [int] NULL ,
	[AccessLevel] [int] NULL ,
	[NumberPattern] [int] NULL ,
	[SortInList] [int] NULL ,
	[Comments] [nvarchar] (1024) NULL ,
	[TOCMarked] [int] NULL ,
	[StyleBased] [int] NULL ,
	[ListBased] [int] NULL ,
	[FollowsWithNum] [int] NULL ,
	[WrapsToMargin] [int] NULL ,
	[UseCenter] [int] NULL ,
	[FontModified] [int] NULL ,
	[UseLegal] [int] NULL ,
	[UseChapter] [int] NULL ,
	[ForceLeadIn] [int] NULL ,
	[UseCount] [decimal](18, 0) NULL ,
	[CreatedBy] [nvarchar] (40) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [ListSchemes] WITH NOCHECK ADD 
	CONSTRAINT [PK_ListSchemes] PRIMARY KEY  CLUSTERED 
	(
		[SchemeID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_ListSchemes] ON [ListSchemes]([Description]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_ListSchemes_Group] ON [ListSchemes]([GroupID]) ON [PRIMARY]
GO


/*******  ListLevels         Subordinate Scheme Info each 9 Levels     T A B L E */

CREATE TABLE [ListLevels] (
	[RecordID] [int] IDENTITY (1, 1) NOT NULL ,
	[SchemeCode] [int] NOT NULL ,
	[LevelNumber] [int] NOT NULL ,
	[PreText] [nvarchar] (150) NULL ,
	[PostText] [nvarchar] (22) NULL ,
	[NumPos] [float] NULL ,
	[TabPos] [float] NULL ,
	[TextPos] [float] NULL ,
	[LinkStyle] [nvarchar] (20) NULL ,
	[FollowWith] [nvarchar] (10) NULL ,
	[LineFeedAfter] [int] NULL ,
	[NumAlign] [nvarchar] (10) NULL ,
	[FontModified] [int] NULL ,
	[FontName] [nvarchar] (50) NULL ,
	[FontColor] [int] NULL ,
	[FontBold] [int] NULL ,
	[FontItalic] [int] NULL ,
	[FontCaps] [int] NULL ,
	[FontUnderline] [int] NULL ,
	[FontSize] [int] NULL ,
	[LeadIn] [int] NULL ,
	[ResetHigher] [int] NULL ,
	[StyName] [nvarchar] (50) NULL ,
	[StyUseHeading] [int] NULL ,
	[StyBasedOn] [nvarchar] (50) NULL ,
	[StyNextParaType] [int] NULL ,
	[StyNextParaSty] [nvarchar] (50) NULL ,
	[StyFollowLeadIn] [nvarchar] (50) NULL ,
	[StyEndNum] [nvarchar] (50) NULL ,
	[StyLineSpacing] [int] NULL ,
	[StyAutoUpdate] [int] NULL ,
	[StyFontName] [nvarchar] (50) NULL ,
	[StyFontSize] [int] NULL ,
	[StyBold] [int] NULL ,
	[StyItalic] [int] NULL ,
	[StyUnderline] [int] NULL ,
	[StyDblUnderline] [int] NULL ,
	[StySmallCaps] [int] NULL ,
	[StyAllCaps] [int] NULL ,
	[StyAlignment] [int] NULL ,
	[StyWidowCtrl] [int] NULL ,
	[StyKeepWNext] [int] NULL ,
	[StyKeepTogether] [int] NULL ,
	[ParaSpaceBefore] [int] NULL ,
	[ParaSpaceAfter] [int] NULL ,
	[ParaOutlineLevel] [int] NULL ,
	[PttrnNum] [int] NULL ,
	[PttrnNumStyle] [nvarchar] (30) NULL ,
	[PttrnPreText] [nvarchar] (25) NULL ,
	[PttrnPostText] [nvarchar] (10) NULL ,
	[BdyBold] [int] NULL ,
	[BdyItalic] [int] NULL ,
	[BdyUnderline] [int] NULL ,
	[BdyDblUnderline] [int] NULL ,
	[BdySmallCaps] [int] NULL ,
	[BdyAllCaps] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [ListLevels] WITH NOCHECK ADD 
	CONSTRAINT [PK_ListLevels] PRIMARY KEY  CLUSTERED 
	(
		[RecordID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_ListLevels] ON [ListLevels]([SchemeCode], [LevelNumber]) ON [PRIMARY]
GO

/*******  ListPatterns       Default Numbering Patterns                T A B L E */

CREATE TABLE [ListPatterns] (
	[PatternNum] [int] NOT NULL ,
	[Active] [int] NULL ,
	[PatternDisplay] [nvarchar] (50) NULL ,
	[L1numStyle] [nvarchar] (30) NULL ,
	[L2numStyle] [nvarchar] (20) NULL ,
	[L3numStyle] [nvarchar] (10) NULL ,
	[L4numStyle] [nvarchar] (10) NULL ,
	[L5numStyle] [nvarchar] (10) NULL ,
	[L6numStyle] [nvarchar] (10) NULL ,
	[L7numStyle] [nvarchar] (10) NULL ,
	[L8numStyle] [nvarchar] (10) NULL ,
	[L9numStyle] [nvarchar] (10) NULL ,
	[L1PreText] [nvarchar] (10) NULL ,
	[L2PreText] [nvarchar] (10) NULL ,
	[L3PreText] [nvarchar] (15) NULL ,
	[L4PreText] [nvarchar] (15) NULL ,
	[L5PreText] [nvarchar] (20) NULL ,
	[L6PreText] [nvarchar] (20) NULL ,
	[L7PreText] [nvarchar] (20) NULL ,
	[L8PreText] [nvarchar] (25) NULL ,
	[L9PreText] [nvarchar] (25) NULL ,
	[L1PostText] [nvarchar] (10) NULL ,
	[L2PostText] [nvarchar] (10) NULL ,
	[L3PostText] [nvarchar] (10) NULL ,
	[L4PostText] [nvarchar] (10) NULL ,
	[L5PostText] [nvarchar] (10) NULL ,
	[L6PostText] [nvarchar] (10) NULL ,
	[L7PostText] [nvarchar] (10) NULL ,
	[L8PostText] [nvarchar] (10) NULL ,
	[L9PostText] [nvarchar] (10) NULL ,
	[SortInList] [int] NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [ListPatterns] WITH NOCHECK ADD 
	CONSTRAINT [PK_ListPatterns] PRIMARY KEY  CLUSTERED 
	(
		[PatternNum]
	)  ON [PRIMARY] 
GO


/*******  GroupSchemes       Relational Tbl Assoc. Schemes to Groups   T A B L E */

CREATE TABLE [GroupSchemes] (
	[GroupID] [int] NOT NULL ,
	[SchemeID] [int] NOT NULL, 
	[Visibility] [int] NULL ,
	[RecordRevision] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [GroupSchemes] WITH NOCHECK ADD 
	CONSTRAINT [PK_GroupSchemes] PRIMARY KEY  CLUSTERED 
	(
		[GroupID],
		[SchemeID]
	)  ON [PRIMARY] 
GO


/*******  QlickForms Tables ******************************************************/

/*******  FormPracticeAreas  Form Library or Practice Area List        T A B L E */

CREATE TABLE [FormPracticeAreas] (
	[AreaID] [int] IDENTITY (1, 1) NOT NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[SortInList] [int] NULL ,
	[ShortDescription] [nvarchar] (25) NULL ,
	[LongDescription] [nvarchar] (200) NULL ,
	[Path] [nvarchar] (50) NULL ,
	[Restricted] [nvarchar] (6) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [FormPracticeAreas] WITH NOCHECK ADD 
	CONSTRAINT [PK_FormPracticeAreas] PRIMARY KEY  CLUSTERED 
	(
		[AreaID]
	)  ON [PRIMARY] 
GO


/*******  FormCategories     Form Category List                        T A B L E */

CREATE TABLE [FormCategories] (
	[CategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[PracticeArea] [int] NULL ,
	[SortNumber] [int] NULL ,
	[HeadingEntry] [nvarchar] (6) NULL ,
	[ShortDescription] [nvarchar] (60) NULL ,
	[LongDescription] [nvarchar] (200) NULL ,
	[ManagerID] [nvarchar] (20) NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[Restricted] [nvarchar] (6) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [FormCategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_FormCategories] PRIMARY KEY  CLUSTERED 
	(
		[CategoryID]
	)  ON [PRIMARY] 
GO

/*******  FormObjects        Forms and Clauses List of Objects         T A B L E */

CREATE TABLE [FormObjects] (
	[ObjectID] [int] IDENTITY (1, 1) NOT NULL ,
	[CategoryAssoc] [int] NULL ,
	[ObjectAddress] [nvarchar] (20) NULL ,
	[SortInList] [int] NULL ,
	[HeadingEntry] [nvarchar] (6) NULL ,
	[ShortcutName] [nvarchar] (10) NULL ,
	[InUse] [nvarchar] (6) NULL ,
	[ShortDescription] [nvarchar] (100) NULL ,
	[LongDescription] [nvarchar] (255) NULL ,
	[Restricted] [nvarchar] (6) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [FormObjects] WITH NOCHECK ADD 
	CONSTRAINT [PK_FormObjects] PRIMARY KEY  CLUSTERED 
	(
		[ObjectID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_FormObjects_Cat] ON [FormObjects]([CategoryAssoc]) ON [PRIMARY]
GO

	
/*******  DoxShop Tables *********************************************************/

/*******  DocSystem          Document Management System Settings       T A B L E */

CREATE TABLE [DocSystem] (
	[ID] [int] NOT NULL ,
	[SystemName] [nvarchar] (50) NULL ,
	[Path_Root] [nvarchar] (50) NULL ,
	[Path_Backup] [nvarchar] (50) NULL ,
	[Require_Client] [int] NULL ,
	[Require_Matter] [int] NULL ,
	[Require_SubMatter] [int] NULL ,
	[Require_FileNumber] [int] NULL ,
	[Length_Client] [int] NULL ,
	[Length_Matter] [int] NULL ,
	[Length_SubMatter] [int] NULL ,
	[AllowText_Client] [int] NULL ,
	[AllowText_Matter] [int] NULL ,
	[AllowText_SubMatter] [int] NULL ,
	[LastDocNumber] [int] NULL ,
	[DocNumberLock] [nvarchar] (12) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocSystem] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocSystem] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO


/*******  Documents          Main Documents Repository                 T A B L E */

CREATE TABLE [Documents] (
	[DocNum] [float] NOT NULL ,
	[Versions] [int] NULL ,
	[Version] [int] NULL ,
	[Type] [int] NULL ,
	[Category] [nvarchar] (50) NULL ,
	[Author] [nvarchar] (20) NULL ,
	[Typist] [nvarchar] (20) NULL ,
	[Description] [nvarchar] (300) NULL ,
	[Client] [nvarchar] (20) NULL ,
	[Matter] [nvarchar] (20) NULL ,
	[SubMattFileNo] [nvarchar] (20) NULL ,
	[ReadOnly] [int] NULL ,
	[PsswrdProtect] [int] NULL ,
	[Password] [nvarchar] (50) NULL ,
	[Path] [nvarchar] (400) NULL ,
	[Status] [int] NULL ,
	[LastTouched] [nvarchar] (50) NULL ,
	[TimeAccessed] [smalldatetime] NULL ,
	[TimeModified] [smalldatetime] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [Documents] WITH NOCHECK ADD 
	CONSTRAINT [PK_Documents] PRIMARY KEY  CLUSTERED 
	(
		[DocNum]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_Documents_Author] ON [Documents]([Author]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Documents_Desc] ON [Documents]([Description]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Documents_Cat] ON [Documents]([Category]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Documents_Client] ON [Documents]([Client]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Documents_FileNo] ON [Documents]([SubMattFileNo]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Documents_Path] ON [Documents]([Path]) ON [PRIMARY]
GO


/*******  DocVersions        Secondary Table - Multi-Version Doc Info   T A B L E */

CREATE TABLE [DocVersions] (
	[DocNum] [float] NOT NULL ,
	[Version] [int] NULL ,
	[Type] [int] NULL ,
	[User] [nvarchar] (20) NULL ,
	[Path] [nvarchar] (400) NULL ,
	[Description] [nvarchar] (300) NULL ,
	[Action] [int] NULL ,
	[TimeOfAction] [smalldatetime] NULL ,
	[TimeModified] [smalldatetime] NULL 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocVersions] ON [DocVersions]([DocNum]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocVersions_Path] ON [DocVersions]([Path]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocVersions_User] ON [DocVersions]([User]) ON [PRIMARY]
GO


/*******  DocDirs         Document Directories                        T A B L E */


CREATE TABLE [DocDirs] (
	[SubDir] [nvarchar] (200)  NOT NULL ,
	[SubDirName] [nvarchar] (50)  NULL ,
	[ParentDir] [nvarchar] (200)  NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocDirs] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocDirs] PRIMARY KEY  CLUSTERED 
	(
		[SubDir]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_DocDirs_Parents] ON [DocDirs]([ParentDir]) ON [PRIMARY]
GO




/*******  DocHistory         Document Activity and Work-List Info      T A B L E */

CREATE TABLE [DocHistory] (
	[DocNum] [float] NOT NULL ,
	[Version] [int] NULL ,
	[User] [nvarchar] (20) NULL ,
	[Path] [nvarchar] (400) NULL ,
	[Action] [int] NULL ,
	[TimeOfAction] [smalldatetime] NULL 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocHistory] ON [dbo].[DocHistory]([DocNum]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocHistory_Time] ON [dbo].[DocHistory]([TimeOfAction]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_DocHistory_User] ON [dbo].[DocHistory]([User]) ON [PRIMARY]
GO


/*******  DocCategories      List of Document Categories               T A B L E */

CREATE TABLE [DocCategories] (
	[CatName] [nvarchar] (50) NOT NULL ,
	[DocCount] [float] NULL ,
	[CatDescription] [nvarchar] (100) NULL ,
	[CatType] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocCategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocCategories] PRIMARY KEY  CLUSTERED 
	(
		[CatName]
	)  ON [PRIMARY] 
GO


/*******  DocTypes           List of Document (Application) Types      T A B L E */

CREATE TABLE [DocTypes] (
	[ID] [int] NOT NULL ,
	[DocTypeID] [nvarchar] (20) NOT NULL ,
	[DocTypeDescription] [nvarchar] (100) NULL ,
	[PasswordProtect] [int] NULL ,
	[ReadOnlyProtect] [int] NULL ,
	[DefaultApplication] [nvarchar] (20) NULL ,
	[DefaultExtension] [nvarchar] (3) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocTypes] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocTypes] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [IX_DocTypes] ON [DocTypes]([DocTypeID]) ON [PRIMARY]
GO


/*******  DocActions         Lookup List of Document Actions           T A B L E */

CREATE TABLE [DocActions] (
	[ActionNum] [int] NOT NULL ,
	[Description] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocActions] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocActions] PRIMARY KEY  CLUSTERED 
	(
		[ActionNum]
	)  ON [PRIMARY] 
GO


/*******  DocClients         Lookup List of Clients                    T A B L E */

CREATE TABLE [DocClients] (
	[ClientNum] [nvarchar] (30) NOT NULL ,
	[ClientName] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO


ALTER TABLE [DocClients] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocClients] PRIMARY KEY  CLUSTERED 
	(
		[ClientNum]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_DocClients] ON [DocClients]([ClientName]) ON [PRIMARY]
GO


/*******  DocMatters         Lookup List of Matters                    T A B L E */

CREATE TABLE [DocMatters] (
	[ClientNum] [nvarchar] (30) NOT NULL ,
	[MatterNum] [nvarchar] (30) NOT NULL ,
	[MatterDesc] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocMatters] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocMatters] PRIMARY KEY  CLUSTERED 
	(
		[ClientNum],
		[MatterNum]
	)  ON [PRIMARY] 
GO

ALTER TABLE [DocMatters] WITH NOCHECK ADD 
	CONSTRAINT [FK_DocMatters_DocClients] FOREIGN KEY 
	(
		[ClientNum]
	) REFERENCES [DocClients] (
		[ClientNum]
	) ON UPDATE CASCADE  NOT FOR REPLICATION 
GO

 CREATE  INDEX [IX_DocMatters] ON [DocMatters]([MatterDesc]) ON [PRIMARY]
GO


/*******  DocFileNums        Lookup List of Job or File Numbers        T A B L E */

CREATE TABLE [DocFileNums] (
	[FileNum] [nvarchar] (30) NOT NULL ,
	[FileDesc] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocFileNums] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocFileNums] PRIMARY KEY  CLUSTERED 
	(
		[FileNum]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_DocFileNums] ON [DocFileNums]([FileDesc]) ON [PRIMARY]
GO


/*******  DocSubMatters      Lookup List of sub-Matters                T A B L E */

CREATE TABLE [DocSubMatters] (
	[ClientNum] [nvarchar] (30) NOT NULL ,
	[MatterNum] [nvarchar] (30) NOT NULL ,
	[SubMatterNum] [nvarchar] (30) NOT NULL ,
	[SubMatterDesc] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [DocSubMatters] WITH NOCHECK ADD 
	CONSTRAINT [PK_DocSubMatters] PRIMARY KEY  CLUSTERED 
	(
		[ClientNum],
		[MatterNum],
		[SubMatterNum]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_DocSubMatters] ON [DocSubMatters]([SubMatterDesc]) ON [PRIMARY]
GO