Remote DM Kurulumu

DATABASE’DE TUTULACAK DOKÜMANLAR

Dokümanlar eBA'nın kurulu olduğu veritabanı dışında farklı bir veritabanında saklanabilir. Veriler Database’de tutulacağı için aşağıdaki script remote sunucu databasinde çalıştırılmalıdır.
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](1000) NULL
) 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](1000) NULL
) 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
eBA uygulamasının kurulu olduğu sunucuda eBAServerConfigurationEditor.exe’yi açarak remote dm yapacağımız sunucu bilgilerini girmeli ve test connectiona tıklayarak Success sonucunu almalıdır.
eBA uygulamasının kurulu olduğu sunucuda eBAConfigurationEditor.exe’yi açarak DocumentManagement > ContentStorages’in altına sırasıyla aşağıdaki gibi bilgileri girmelidir.
DataBase ismi eBAServerConfigurationEditor.exe’ye girdiğimiz isim ile aynı olmalı.
ContentStorages’in altına ekleyeceğimiz ismin uzunluğu 8 karakterden fazla olmamalıdır.
DB'de tutulması için; LocationType: Local StorageType: Database TableName: FSFILEDATAPARTS WebServiceAddres:eba.net.dm bilgileri girilmelidir.
Remote Dm yapacağımız sunucuda IIS’e aşağıdaki gibi eba.net.dm application ekleyip Physical Path olarak da eba.net.dm klasörünü göstermelidir.
Son olarak Web browserdan DM’e bir library eklenmeli ve Storage Place olarak configte eklediğimiz isim seçilmelidir.
Bütün bu işlemlerden sonra eBA servisleri ve iis restart edilmelidir.
FILESYSTEM’DE TUTULACAK DOKÜMANLAR

Doküman yönetimine eklenen dokümanlar veritabanı yerine bir diskte saklanabilir. eBA uygulamasının kurulu olduğu sunucuda eBAConfigurationEditor.exe’yi açarak DocumentManagement > ContentStorages’in altına sırasıyla aşağıdaki gibi bilgileri girmelidir.
ContentStorages’in altına ekleyeceğimiz ismin uzunluğu 8 karakterden fazla olmamalıdır.
FILESYSTEM'de tutulması için; LocationType: Remote Path: C dizini altında oluşturulan klasör pathi StorageType: FileSystem WebServiceAddres: eba.net.dm.remote bilgileri girilmelidir.
C dizini altında ilgili klasör oluşturulmalıdır.
Son olarak Web browserdan DM’e bir library eklenmeli ve Storage Place olarak configte eklediğimiz isim seçilmelidir.
Bütün bu işlemlerden sonra eBA servisleri ve iis restart edilmelidir.
Remote DM Kurulumu

DATABASE’DE TUTULACAK DOKÜMANLAR​

FILESYSTEM’DE TUTULACAK DOKÜMANLAR​

DATABASE’DE TUTULACAK DOKÜMANLAR

FILESYSTEM’DE TUTULACAK DOKÜMANLAR
