Remote DM Setup
DOCUMENTS TO KEEP IN THE DATABASE
Documents can be stored in a different database than the one on which the eBA is installed. Since the data will be kept in the Database, the following script should be run in the remote server database.
''USE [EBA] GO /** Object: Table [dbo]. [FSDELETEDITEMS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSDELETEDITEMS]( [LIBRARYID][int] NOT NULL, [NAME][nvarchar](255) NOT NULL, [OBJECTTYPE][nvarchar](255) NOT NULL, [DELETEUSER][nvarchar](50) NOT NULL, [DELETEDATE][datetime] NOT NULL, [ORIGINALPATH][nvarchar](255) NOT NULL, CONSTRAINT [PK_FSDELETEDITEMS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [NAME] ASC [OBJECTTYPE] 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]. [FSDOCUMENTTYPES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSDOCUMENTTYPES]( [ID][int] NOT NULL, [DESCRIPTION][nvarchar](2000) NULL, CONSTRAINT [PK_FSDOCUMENTTYPES] PRIMARY KEY CLUSTERED ( [id] 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]. [FSFAVORITES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFAVORITES]( [USERID][nvarchar](50) NOT NULL, [FILEPATH][nvarchar](255) NOT NULL, CONSTRAINT [PK_FSFAVORITES] PRIMARY KEY CLUSTERED ( [USERID] ASC [FILEPATH] 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]. [FSFILECHECKOUTS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILECHECKOUTS]( [LIBRARYID][int] NOT NULL, [FILEID][int] NOT NULL, [FOLDERID][int] NOT NULL, [USERID][nvarchar](50) NOT NULL, [CHECKOUTDATE][datetime] NOT NULL, CONSTRAINT [PK_FSFILECHECKOUTS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [FILEID] 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]. [FSFILEDATA] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEDATA]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [CONTENTTYPE][int] NOT NULL, [PARTCOUNT][int] NOT NULL, [FILESIZE][bigint] NOT NULL, [HASH][nvarchar](64) NOT NULL, [EXTENSION][nvarchar](25) NULL, [MIMETYPE][nvarchar](100) NULL, [STORAGEID][nvarchar](25) NULL, [INDEXSTATUS][int] NULL [INDEXDATAID][int] NULL [OCRDATAID][int] NULL [HASPROPERTIES][int] NOT NULL, [PROPERTIES][nvarchar](2000) NULL, CONSTRAINT [PK_FSFILEDATA] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILEDATAPARTS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo]. [FSFILEDATAPARTS]( [LIBRARYID][int] NOT NULL, [FILEDATAID][int] NOT NULL, [PARTINDEX][int] NOT NULL, [DATA][varbinary](max) NULL CONSTRAINT [PK_FSFILEDATAPARTS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [FILEDATAID] ASC [PARTINDEX] ASC WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO SET ANSI_PADDING OFF GO /** Object: Table [dbo]. [FSFILEDATAREMOTECONTENT] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEDATAREMOTECONTENT]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [STORAGEID][nvarchar](25) NOT NULL, [LASTACCESS][datetime] NOT NULL, [FILESIZE][bigint] NOT NULL, [TRANSFERRED][int] NOT NULL, CONSTRAINT [PK_FSFILEDATAREMOTECONTENT] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [ID] ASC, [STORAGEID] 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]. [FSFILEDATASET] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEDATASET]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [FILEID][int] NOT NULL, [FILEVERSIONID][int] NOT NULL, [NAME][nvarchar](255) NULL, [STATUS][int] NOT NULL, [DATAID][int] NULL [DESCRIPTION][nvarchar](1024) NULL, [CREATORUSER][nvarchar](50) NULL, [CREATEDATE][datetime] NULL [MODIFYUSER][nvarchar](50) NULL, [MODIFYDATE][datetime] NULL CONSTRAINT [PK_FSFILEDATASET] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILEEXTENDEDPROFILES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEEXTENDEDPROFILES]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [PROFILE][int] NOT NULL, CONSTRAINT [PK_FSFILEEXTENDEDPROFILES] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [ID] ASC, [PROFILE] 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]. [FSFILEEXTENDEDPROPERTIES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEEXTENDEDPROPERTIES]( [LIBRARYID][int] NOT NULL, [FILEID][int] NOT NULL, [KEEPVERSIONCOUNT][int] NULL [KEEPMINORVERSIONS][int] NULL [PUBLISHWORKFLOW][nvarchar](50) NULL, [ISREADONLY][int] NULL [DIGITALSIGNATURESCHEME][int] NULL [WATERMARKOPTIONS][ntext] NULL [KEEPMINORVERSIONCOUNT][int] NULL CONSTRAINT [PK_FSFILEEXTENDEDPROPERTIES] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [FILEID] ASC WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO /** Object: Table [dbo]. [FSFILEHISTORY] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEHISTORY]( [LIBRARYID][int] NOT NULL, [FILEID][int] NOT NULL, [FOLDERID][int] NOT NULL, [USERID][nvarchar](50) NOT NULL, [HDATE][datetime] NOT NULL, [HTYPE][int] NOT NULL, [PATH][nvarchar](500) NOT NULL, [PARAMETERS][nvarchar] NULL (1000) ON [PRIMARY]
GO /** Object: Table [dbo]. [FSFILEPARENTS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEPARENTS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [FILEID][int] NOT NULL, [FOLDERID][int] NOT NULL, [STATUS][int] NOT NULL, [OVERRIDESECURITY][int] NOT NULL, CONSTRAINT [PK_FSFILEPARENTS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILEPROPERTIES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo]. [FSFILEPROPERTIES]( [OBJECTID][binary](16) NOT NULL, [FILETYPE][int] NOT NULL, [PROFILE][int] NULL [KEEPVERSIONCOUNT][int] NOT NULL, [PUBLISHWORKFLOW][nvarchar](50) NULL, [DOCUMENTTYPE][int] NOT NULL, [KEEPMINORVERSIONS][int] NOT NULL, CONSTRAINT [PK_FSFILEPROPERTIES] PRIMARY KEY CLUSTERED ( [OBJECTID] 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 SET ANSI_PADDING OFF GO /** Object: Table [dbo]. [FSFILERELATIONS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILERELATIONS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [STATUS][int] NOT NULL, [FILEID][int] NOT NULL, [FILEVERSIONID][int] NOT NULL, [RELATEDFILEPATH][nvarchar](255) NOT NULL, [NAME][nvarchar](255) NULL, [DESCRIPTION][nvarchar](1024) NULL, CONSTRAINT [PK_FSFILERELATIONS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILES]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [NAME][nvarchar](255) NOT NULL, [STATUS][int] NOT NULL, [OWNER][nvarchar](50) NULL, [OWNERTYPE][int] NULL [CREATEDATE][datetime] NOT NULL, [MODIFYDATE][datetime] NULL [MODIFYUSER][nvarchar](50) NULL, [PUBLISHEDVERSION][int] NULL [CREATORUSER][nvarchar](50) NOT NULL, [PUBLISHDATE][datetime] NULL [PROFILE][int] NULL [DOCUMENTTYPE][int] NULL [DESCRIPTION][nvarchar](1024) NULL, [FILETYPE][int] NULL [INDEXSTATUS][int] NULL CONSTRAINT [PK_FSFILES] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILESECURITY] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILESECURITY]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [FILEPARENTID][int] NOT NULL, [STATUS][int] NOT NULL, [ROLEID][nvarchar](50) NOT NULL, [ROLETYPE][int] NOT NULL, [MODIFYPERMISSION][int] NULL [WRITEPERMISSION][int] NULL [READPERMISSION][int] NULL [SEEPERMISSION][int] NOT NULL, [SEECONTENTSPERMISSION][int] NOT NULL, [SEEVERSIONSPERMISSIONS][int] NOT NULL, [SEERELATIONSPERMISSION][int] NOT NULL, [SEEPROFILEPERMISSION][int] NOT NULL, [DOWNLOADPERMISSION][int] NOT NULL, [PRINTPERMISSION][int] NOT NULL, [EDITPERMISSION][int] NOT NULL, [EDITPROPERTIESPERMISSION][int] NOT NULL, [EDITDESCRIPTIONPERMISSION][int] NOT NULL, [RENAMEPERMISSION][int] NOT NULL, [EDITPROFILEPERMISSION][int] NOT NULL, [ACTIONPERMISSION][int] NOT NULL, [MOVEPERMISSION][int] NOT NULL, [COPYPERMISSION][int] NOT NULL, [REFERENCEFILEPERMISSION][int] NOT NULL, [CREATESHORTCUTPERMISSION][int] NOT NULL, [REFRESHINDEXPERMISSION][int] NOT NULL, [SHARELINKPERMISSION][int] NOT NULL, [ADDITEMPERMISSION][int] NOT NULL, [ADDCONTENTPERMISSION][int] NOT NULL, [ADDATTACHMENTPERMISSION][int] NOT NULL, [ADDRELATIONPERMISSION][int] NOT NULL, [ADDVERSIONPERMISSION][int] NOT NULL, [CHECKINOUTPERMISSION][int] NOT NULL, [PUBLISHPERMISSION][int] NOT NULL, [EDITWITHOUTCHECKOUTPERMISSION][int] NOT NULL, [DELETEPERMISSION][int] NOT NULL, [DELETEFILEPERMISSION][int] NOT NULL, [DELETEVERSIONPERMISSION][int] NOT NULL, [DELETECONTENTPERMISSION][int] NOT NULL, [DELETEATTACHMENTPERMISSION][int] NOT NULL, [DELETERELATIONPERMISSION][int] NOT NULL, [EDITSECURITYPERMISSION][int] NOT NULL, [ANNOTATIONPERMISSION][int] NOT NULL, [VIEWANNOTATIONPERMISSION][int] NOT NULL, [EDITANNOTATIONPERMISSION][int] NOT NULL, [DELETEANNOTATIONPERMISSION][int] NOT NULL, [SEEFILEPERMISSION][int] NOT NULL, [SEEATTACHMENTPERMISSION][int] NOT NULL, [DIGITALSIGNPERMISSION][int] NOT NULL, CONSTRAINT [PK_FSFILESECURITY] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILESHORTCUTS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILESHORTCUTS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [PATH][nvarchar](255) NOT NULL, CONSTRAINT [PK_FSFILESHORTCUTS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFILEVERSIONS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFILEVERSIONS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [FILEID][int] NOT NULL, [STATUS][int] NOT NULL, [MAJORVERSION][int] NOT NULL, [MINORVERSION][int] NOT NULL, [CREATORUSER][nvarchar](50) NOT NULL, [CREATEDATE][datetime] NOT NULL, CONSTRAINT [PK_FSFILEVERSIONS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFOLDEREXTENDEDPROFILES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDEREXTENDEDPROFILES]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [PROFILE][int] NOT NULL, CONSTRAINT [PK_FSFOLDEREXTENDEDPROFILES] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [ID] ASC, [PROFILE] 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]. [FSFOLDEREXTENDEDPROPERTIES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDEREXTENDEDPROPERTIES]( [LIBRARYID][int] NOT NULL, [FOLDERID][int] NOT NULL, [KEEPVERSIONCOUNT][int] NULL [KEEPMINORVERSIONS][int] NULL [PUBLISHWORKFLOW][nvarchar](50) NULL, [CFPROFILEPROCESS][nvarchar](50) NULL, [CFPROFILEFORM][nvarchar](50) NULL, [CFTEMPLATECONTENTPATH][nvarchar](255) NULL, [CFCUSTOMIZABLE][int] NULL [DEFAULTSTORAGEID][nvarchar](25) NULL, [INDEXING][int] NULL [OCRINDEXING][int] NULL [CFDPROFILEPROCESS][nvarchar](50) NULL, [CFDPROFILEFORM][nvarchar](50) NULL, [CFDCUSTOMIZABLE][int] NULL [FOLDEREXPROFILESCHEME][nvarchar](2000) NULL, [FILEEXPROFILESCHEME][nvarchar](2000) NULL, [MANAGEMENTTYPE][int] NULL [ENTRYSTATUS][int] NULL [ISREADONLY][int] NULL [DIGITALSIGNATURESCHEME][int] NULL [CLOSINGDATE][datetime] NULL [RETENTIONPOLICY][nvarchar](2000) NULL, [CONTROLLEDTERMINOLOGY][nvarchar](50) NULL, [AUDITENABLE][int] NULL [FILEENABLE][int] NULL [FOLDERENABLE][int] NULL [EMPTYFILEENABLE][int] NULL [VOLUMEENABLE][int] NULL [VERSIONINGTYPE][int] NULL [AUDITTYPE][int] NULL [ICON][int] NULL [ALLOWEDEXT][ntext] NULL [CREATEWORKFLOW][nvarchar](250) NULL, [MAXALLOWEDFILESIZE][bigint] NULL [INITIALVERSIONNUMBER][nvarchar](50) NULL, [CREATESUBFOLDERWORKFLOW][nvarchar](250) NULL, [WATERMARKOPTIONS][ntext] NULL [KEEPMINORVERSIONCOUNT][int] NULL [FILECREATETIMESTAMPENABLE][int] NULL CONSTRAINT [PK_FSFOLDEREXTENDEDPROPERTIES] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [FOLDERID] ASC WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO /** Object: Table [dbo]. [FSFOLDERHISTORY] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDERHISTORY]( [LIBRARYID][int] NOT NULL, [FOLDERID][int] NOT NULL, [USERID][nvarchar](50) NOT NULL, [HDATE][datetime] NOT NULL, [HTYPE][int] NOT NULL, [PATH][nvarchar](500) NOT NULL, [PARAMETERS][nvarchar] NULL (1000) ON [PRIMARY]
GO /** Object: Table [dbo]. [FSFOLDERS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDERS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [NAME][nvarchar](255) NOT NULL, [FOLDERID][int] NOT NULL, [STATUS][int] NOT NULL, [OWNER][nvarchar](50) NULL, [OWNERTYPE][int] NULL [CREATEDATE][datetime] NOT NULL, [MODIFYDATE][datetime] NOT NULL, [OVERRIDESECURITY][int] NOT NULL, [CREATORUSER][nvarchar](50) NOT NULL, [MODIFYUSER][nvarchar](50) NOT NULL, [PROFILE][int] NULL [DOCUMENTTYPE][int] NULL [DESCRIPTION][nvarchar](1024) NULL, CONSTRAINT [PK_FSFOLDERS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFOLDERSECURITY] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDERSECURITY]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [FOLDERID][int] NOT NULL, [STATUS][int] NOT NULL, [ROLEID][nvarchar](50) NOT NULL, [ROLETYPE][int] NOT NULL, [MODIFYPERMISSION][int] NULL [WRITEPERMISSION][int] NULL [READPERMISSION][int] NULL [LISTPERMISSION][int] NULL [SEEPERMISSION][int] NOT NULL, [SEECONTENTSPERMISSION][int] NOT NULL, [SEEVERSIONSPERMISSIONS][int] NOT NULL, [SEERELATIONSPERMISSION][int] NOT NULL, [SEEPROFILEPERMISSION][int] NOT NULL, [DOWNLOADPERMISSION][int] NOT NULL, [PRINTPERMISSION][int] NOT NULL, [EDITPERMISSION][int] NOT NULL, [EDITPROPERTIESPERMISSION][int] NOT NULL, [EDITDESCRIPTIONPERMISSION][int] NOT NULL, [RENAMEPERMISSION][int] NOT NULL, [EDITPROFILEPERMISSION][int] NOT NULL, [ACTIONPERMISSION][int] NOT NULL, [MOVEPERMISSION][int] NOT NULL, [COPYPERMISSION][int] NOT NULL, [REFERENCEFILEPERMISSION][int] NOT NULL, [CREATESHORTCUTPERMISSION][int] NOT NULL, [REFRESHINDEXPERMISSION][int] NOT NULL, [SHARELINKPERMISSION][int] NOT NULL, [ADDITEMPERMISSION][int] NOT NULL, [ADDCONTENTPERMISSION][int] NOT NULL, [ADDATTACHMENTPERMISSION][int] NOT NULL, [ADDRELATIONPERMISSION][int] NOT NULL, [ADDVERSIONPERMISSION][int] NOT NULL, [CREATEFOLDERPERMISSION][int] NOT NULL, [CREATEFILEPERMISSION][int] NOT NULL, [CHECKINOUTPERMISSION][int] NOT NULL, [PUBLISHPERMISSION][int] NOT NULL, [EDITWITHOUTCHECKOUTPERMISSION][int] NOT NULL, [DELETEPERMISSION][int] NOT NULL, [DELETEFILEPERMISSION][int] NOT NULL, [DELETEVERSIONPERMISSION][int] NOT NULL, [DELETECONTENTPERMISSION][int] NOT NULL, [DELETEATTACHMENTPERMISSION][int] NOT NULL, [DELETERELATIONPERMISSION][int] NOT NULL, [EDITSECURITYPERMISSION][int] NOT NULL, [ANNOTATIONPERMISSION][int] NOT NULL, [VIEWANNOTATIONPERMISSION][int] NOT NULL, [EDITANNOTATIONPERMISSION][int] NOT NULL, [DELETEANNOTATIONPERMISSION][int] NOT NULL, [DELETELIBRARYPERMISSION][int] NOT NULL, [SEEFILEPERMISSION][int] NOT NULL, [SEEFOLDERPERMISSION][int] NOT NULL, [SEEATTACHMENTPERMISSION][int] NOT NULL, [DIGITALSIGNPERMISSION][int] NOT NULL, [SEERECYCLEBINPERMISSION][int] NOT NULL, [EDITRECYCLEBINPERMISSION][int] NOT NULL, [DELETEFOLDERPERMISSION][int] NOT NULL, [SEEALLRECYCLEBINPERMISSION][int] NOT NULL, CONSTRAINT [PK_FSFOLDERSECURITY] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFOLDERSHORTCUTS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDERSHORTCUTS]( [LIBRARYID][int] NOT NULL, [ID][int] NOT NULL, [PATH][nvarchar](255) NOT NULL, CONSTRAINT [PK_FSFOLDERSHORTCUTS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [id] 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]. [FSFOLDERSUBSCRIPTIONS] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSFOLDERSUBSCRIPTIONS]( [LIBRARYID][int] NOT NULL, [FOLDERID][int] NOT NULL, [ROLEID][nvarchar](50) NOT NULL, [ROLETYPE][int] NOT NULL, [NOTIFYDELETEFILE][int] NULL [NOTIFYCREATEFILE][int] NULL CONSTRAINT [PK_FSFOLDERSUBSCRIPTIONS] PRIMARY KEY CLUSTERED ( [LIBRARYID] ASC [FOLDERID] ASC [ROLEID] ASC [ROLETYPE] 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]. [FSLIBRARIES] Script date: 3.10.2016 11:43:50 **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [FSLIBRARIES]( [ID][int] NOT NULL, [NAME][nvarchar](255) NOT NULL, [STATUS][int] NOT NULL, [PROGID][nvarchar](32) NOT NULL, CONSTRAINT [PK_FSLIBRARIES] PRIMARY KEY CLUSTERED ( [id] 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
On the server where the eBA application is installed, we must open eBAServerConfigurationEditor.exe and enter the server information that we will make remote dm and get the Success result by clicking on the test connection.
On the server where the eBA application is installed, open the eBAConfigurationEditor.exe and enter the following information under DocumentManagement ```>``` ContentStorages, respectively.
The DataBase name must be the same as the name we entered in eBAServerConfigurationEditor.exe.
The length of the name we will add under ContentStorages should not be more than 8 characters.
to be kept in the DB; LocationType: Local StorageType: Database TableName: FSFILEDATAPARTS WebServiceAddres:eba.net.dm information must be entered.
On the server where we will do Remote Dm, we should add eba.net.dm application to IIS as follows and show the eba.net.dm folder as Physical Path.
Finally, a library should be added to the DM from the web browser and the name we added in the config as Storage Place should be selected.
After all these operations, eBA services and iis should be restarted.
## DOCUMENTS TO KEEP IN FILESYSTEM
Documents added to document management can be stored on a disk instead of a database.
On the server where the eBA application is installed, open the eBAConfigurationEditor.exe and enter the following information under DocumentManagement ```>``` ContentStorages, respectively.
The length of the name we will add under ContentStorages should not be more than 8 characters.
To be kept in the FILESYSTEM;
LocationType: Remote Path: The folder path created under the directory C StorageType: FileSystem WebServiceAddres: eba.net.dm.remote information must be entered.
The corresponding folder should be created under directory C.
Finally, a library should be added to the DM from the web browser and the name we added in the config as Storage Place should be selected.
After all these operations, eBA services and iis should be restarted.