Databases¶
The Registration Server setup will install 2 databases:
Database “td2reg”¶
This is the main database with the following tables:
TD2AddressRange table¶
Entries to identify users by the ip address (see Network Allocation)
Columns:
ID
: Primary key columnOwnerID
: Reference to Owner=TableAddressType
: 0 = API Access, 1 = Clients of the ProviderMinAddress
: IP address startMaxAddress
: IP address endRangeSize
: IP range
TD2Autotask table¶
Entries for period tasks (see Auto Tasks for details)
Columns:
ID
: Primary key columnName
: Name of the taskStatus
: En= or disabledDescription
: Task descriptionRunnerConnID
: ID of the PBAC which is processing the task currently to avoid duplicate execution at the same time by two different PBACRunnerLoginTime
: Start timeLastStartTime
: Start timeLastEndTime
: End timeLastResult
: Error descriptionProcedureText
: Function callFrequency
: Frequency in seconds, minutes or hours for tasks which should not run on every PBAC start
TD2BlobData table¶
Stores blob data which is necessary for update notifications for the clients.
Columns:
ID:
Primary key columnOwnerID
: Reference to Owner=TableCreationTime
: Creation timestampModifyTime
: Modification timestampType
: type of the blob. Could be “update”, “banner”, “email”, “csv”, “logs”. Please notice, that not all types are in use at the moment. A few types are planned for future release.IsActive
: Is entry activated or notLanguage
: Language for the entry to support banner or update informations in different languagesName
: An internal name for the entryExtension
: Additional field to store non blob information for the entryData
: The file itself
TD2Depots table¶
Will store the reference to the depots for a user (see Hosting Server Documentation for more info).
Columns:
ID
: Primary key columnUserID
: Reference to User=TableReposDoc
: Repository documentHostUrl
: URL of the Host=ServerRepositoryID
: Repository IDIsDefault
: Default repository or not
TD2Device table¶
Each client installation will be stored in this table
Columns:
ID
: Primary key columnMD5Password
: Identical to user md5 passwordStatus
: Status of the deviceUser
: Reference to User=TableName
: Name of the deviceActivationCode
: Activation code for device activationPublicKey
: Public key of the deviceCreationTime
: Creation timestampActiveTime
: Last active timestampIPAddress
: IP address of the device when it was createdClientVersion
: Version of the client installationPlatform
: Windows, Mac, Linux, iOS, AndroidScreenResolution
: For later usePublicKey2
: The new public key using a RSA 2048 Bit key length
TD2Email table¶
All emails generated by the clients are stored in this table. One autotask process will send the emails from this table
Columns:
ID
: Primary key columnOwnerID
: Reference to Owner=TableStatus
: Status of the mailDestUserID
: Reference to User=TableErrorMessage
: Error messageDestination
: Reference to Device or User=Table (depends on the Template=column)Email
: Destination EmailCreationTime
: Creation timestampSendTime
: Send timestampTemplate
: Template nameContent
: Mail body in case it’s mixed with user data
TD2FreeUserStorage table¶
If the referral functionality is enabled, information about additional storage space awarded will be stored here (see REFERRAL Settings for details).
Columns:
UserID
: Reference to User=Table`InviteFriend
: Additional free storage due to invited usersFreeOffset
: An additional free offset (used for old TeamDrive 2 clients)Fixed
: A fixed value (no changes inFreeOffset
)
TD2LicenceType table¶
License types for monthly, yearly, permanent, or not=for=resale licenses
Columns:
ID
: Primary key columnLicenceName
: License name: Permanent, Monthly Payment, Not for Resale, Yearly Payment
TD2Message table¶
This table stores invitations and other messages exchanged between Clients until a Client polls for its messages (see Messages, Invitations & Invitation Types)
Columns:
ID
: Primary key columnDestination
: Reference to Device table. The device which should receive the messageOrigin
: Reference to Device table. The device which send the messageCreationTime
: Creation timestampHash
: Hash to identify a message for the revoke functionContent
: Encrypted message body
TD2MessageFD table¶
This table stores invitations for devices of a user which will be installed in the future (see Invitation for future devices)
Columns:
ID
: Primary key columnUser
: Reference to the User=TableOrigin
: Reference to the Device tableCreationTime
: Creation timestampHash
: Hash to identify a message for the revoke functionContent
: Encrypted message bodyClientVersion
: Version of the client
TD2MessageSF table¶
This table contains store-forward invitations for new users that are not registered yet, but have been invited by an existing user to join one of his spaces (see Store-forward invitation)
Columns:
ID
: Primary key columnEmail
: Email of the invited userOrigin
: Reference to the Device tableCreationTime
: Creation timestampHash
: Hash to identify a message for the revoke functionContent
: Encrypted message bodyClientVersion
: Version of the client
TD2Owner table¶
The table for the Provider entries (see Provider Concept)
Columns:
ID
: Primary key columnLoginName
: LoginnameMD5Password
: MD5 PasswordLanguage
: Language of the ProviderFirstName
: Firstname of the ProviderLastName
: Lastname of the ProviderEmail
: Email of the ProviderWorkPhone
: Phone number of the ProviderCreationDate
: Creation timestampGender
: Gender m(ale)/f(emale)Address
: Address of the ProviderCity
: City of the ProviderPostalCode
: PostalCode of the ProviderCountry
: Country of the ProviderCompany
: Company of the ProviderTicketPrefix
: 4 letter Provider CodeLicenseEmail
: CC=Email for license creation
TD2OwnerLicenceType table¶
Which Provider can use which license types for host licenses
Columns:
IDOwner
: Reference to Owner tableIDLicenceType
: Reference to LicenseType table
TD2OwnerMeta table¶
A key=value table to store different Provider settings as described in (see Provider Settings)
Columns:
ID
: Primary key columnOwnerID
: Reference to Owner tableName
: Name of the keyValue
: Value of the key
TD2OwnerMetaSetting table¶
A template table to store all available settings which could be chosen
as a new parameter for an entry in TD2OwnerMeta
.
Columns:
ID
: Primary key columnGrouping
: A group entryName
: Name of the keyDefaultValue
: A default value of the key. Will be used if a new entry will be created inTD2OwnerMeta
or if the key inTD2OwnerMeta
is missing.Description
: A description for this valueReadOnly
: Is the entry read only when editing aTD2OwnerMeta
valueVisible
: Is the entry visibleIsUnique
: Is only one entry per provider inTD2OwnerMeta
allowedDeletable
: Is the entry inTD2OwnerMeta
deletableType
: Data typeFormat
: A regular expression to validate the user inputCreationTime
: Creation timestampModifyTime
: Modification timestamp
TD2OwnerProduct table¶
Which Provider can create which licenses for the client and/or TDPS
Columns:
IDOwner
: Reference to Owner tableIDProduct
: Reference to Product table
TD2Parcel table¶
The Key Repository table to store space access data for the users on the server.
Columns:
ID
: Primary key columnUserID
: Reference to theTD2User
tableType
: user=private=key, user=public=key or space=keyStatus
: 1 = active, 2 = archived, 3 = backed upCreationTime
: Creation timestampModifyTime
: Modification timestampPublicKeyID
: Reference to the “user=public=key”=type for a user in this tableGlobalID
: An internal global IDContent
: The key data
TD2Product table¶
The list of products which are available to create licenses
Columns:
ID
: Primary key columnProductName
: Name of the product (TeamDrive Client, TeamDrive Personal Server)
TD2RegServerList table¶
Table with available Registration Server within the TDNS. List will be updated by an autotask process from a server of TeamDrive Systems GmbH. Only active if TDNS usages is activated see TeamDrive Name Server (TDNS))
Columns:
ID
: Primary key columnRegServerName
: Name of the Registration ServerCreationTime
: Creation timestampModifyTime
: Modification timestampEnabled
: White= or blacklistedData
: Data blockAuthSequence
: Authorization sequence
TD2Setting table¶
A key=value table to store different global settings for the server as described in Registration Server Settings.
Columns:
ID
: Primary key columnGrouping
: Field to group values in the GUIName
: Name of the keyValue
: Value of the keyDescription
: Description of the fieldReadOnly
: Readonly attributeVisible
: Visible attributeType
: Data type (boolean, varchar, integer)Format
: A regular expression to validate the user inputCreationTime
: Creation timestampModifyTime
: Modification timestamp
TD2Ticket table¶
The license keys for the clients
Columns:
ID
: Primary key columnNumber
: License numberMD5Password
: MD5Password to allow administration of the license by the userType
: Reference to LicenseType tableStatus
: Status of the licenseOwner
: Reference to Owner tableContractNumber
: Free text fieldHolderEmail
: License emailLanguage
: LanguageTimeLimit
: Time limitation for the licenseValidUntil
: A fixed valid timestampLicenseLimit
: Single or Multi=User license valueLicenseUsed
: License in useFeatureFlag
: Combination of WebDAV, Professional, SecureOffice, Agent,
Inbox and Restricted
CreationTime
: Creation timestampUserID
: Reference to User table if license is bound to a userProduct
: TeamDrive Client or TDPSIsDefault
: Default licenseExtReference
: Free text field to store an external reference
TD2TicketChanges table¶
A history table with all changes made to license keys (amount of seats changed or changed features)
Columns:
ID
: Primary key columnTicket
: Reference to Ticket tableWhatChanged
: Information what changedChangeDate
: Change dateChangeID
: Text field with change informationStatus
: The originalstatus
ContractNumber
: The originalContractNumber
HolderEmail
: The originalHolderEmail
ValidUntil
: The originalValidUntil
LicenseLimit
: The originalLicenseLimit
FeatureFlag
: The originalFeatureFlag
LicenseKey
: The originalLicenseKey
TD2User table¶
A table with all registered users
Columns:
ID
: Primary key columnCreationTime
: Creation timestampUserName
: UsernameTdnsUserName
: The hashed Username for TDNSEmail
: EmailExtReference
: Free text field to store an external referenceDepartment
: Free text fieldExtAuthID
: External ID. Will be set when using external authentication (see External Authentication)AllowEmailSearch
: Not longer usedMD5Password
: Salted MD5Password of the userLanguage
: Language of the userEmailDay
: Date when the last mail was sentEmailCount
: How many mails were send by this user a theEmailDay
TmpPwd
: Temporary password for lost password functionTmpEmail
: New Email until email is confirmed by the linkTmpSession
: Used during registration processStatus
: Status of the userInvitedBy
: Reference to the user which invited this userOwnerID
: Reference to Owner tableCapability
: User settings to enable or disable certain functionalityUserTicket
: Reference toTicket=Table
TD2UserPrivileges table¶
Assigned privileges for users for the access to the Admin Console
Columns:
userId
flagList
TD2UserPrivilegesSetting table¶
Available privileges for users for the access to the Admin Console
Columns:
ID
Grouping
Name
Description
CreationTime
ModifyTime
Keys table¶
This table stores the all keys for the Registration Server. The private and public key of this Registration Server and all public keys of the clients will be stored in this database. Prior to version 3.0.017, this table was stored in a separate database named “pbpg”.
Columns:
Code
: Primary key columnUniqueDevice
: Unique devicename within the TDNS networkVersion
: Public key versionCreationTime
: Creation timestampData
: Public key of the device
Database “td2apilog”¶
A database with one “TD2APIRequests
“=table.
API calls can be logged in this table to identify problems when using
the Registration Server API interface (look in
Registration Server Settings
for the part about request logging).
Columns:
ID
: Primary key columnCreated
: Creation timestampIPAddress
: IP of the requestCommand
: API function call nameUser
: UsernameRequest
: XML from the requestAnswer
: XML which was send back