'	SBM Database Schema constants

'  $File: //depot/DB Schema Constants.tsl $
'  $DateTime: 2012/05/06 23:36:43 $
'  $Revision: #2 $
'  $Change: 2 $
'  $Author: pthompson $


'  Values for TS_FLDTYPE column
' TS_FLDTYPE_USER TS_FLDTYPE_RELATIONAL TS_FLDTYPE_MULTIPLE_RELATIONAL
CONST TS_FLDTYPE_NUMERIC = 100   'Integer or floating-point field.
CONST TS_FLDTYPE_TEXT = 101   'Text field up to 255 characters.
CONST TS_FLDTYPE_DATETIME = 103   'Date/Time field.
CONST TS_FLDTYPE_SELECTION = 104   'Single selection field.
CONST TS_FLDTYPE_BINARY = 105   'Binary field.
CONST TS_FLDTYPE_STATE = 106   'System-defined state field.
CONST TS_FLDTYPE_USER = 107   'User selection field.
CONST TS_FLDTYPE_PROJECT = 108   'System-defined project field.
CONST TS_FLDTYPE_SUMMATION = 109   'Calculated summation field.
CONST TS_FLDTYPE_MULTIPLE_SELECTION = 110   'Multi-selection selection field.
CONST TS_FLDTYPE_CONTACT = 111   'Contact selection field.
CONST TS_FLDTYPE_COMPANY = 112   'Obsolete.
CONST TS_FLDTYPE_INCIDENT = 113   'Incident selection field.
CONST TS_FLDTYPE_PRODUCT = 114   'Obsolete.
CONST TS_FLDTYPE_SERVICEAGREEMENT = 115   'Obsolete.
CONST TS_FLDTYPE_FOLDER = 116   'Folder link selection field.
CONST TS_FLDTYPE_KEYWORDLIST = 117   'Obsolete.
CONST TS_FLDTYPE_PRODUCTLIST = 118   'Obsolete.
CONST TS_FLDTYPE_PROBLEM = 119   'Obsolete.
CONST TS_FLDTYPE_RESOLUTION = 120   'Obsolete.
CONST TS_FLDTYPE_MERCHANDISE = 121   'Obsolete.
CONST TS_FLDTYPE_RELATIONAL = 122   'Single selection relational field.
CONST TS_FLDTYPE_SUBRELATIONAL = 123   'Sub-relational selection field.
CONST TS_FLDTYPE_SYSTEM = 124   'System field.
CONST TS_FLDTYPE_MULTIPLE_RELATIONAL = 125   'Multi-selection relational field.
CONST TS_FLDTYPE_MULTIPLE_USER = 126   'Multi-selection field of users.
CONST TS_FLDTYPE_MULTIPLE_GROUP = 127   'Multi-selection field of groups.

' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --

'  For TS_FLDTYPE_TEXT:
CONST TS_FLDATTRIB_MEMO  = 0     '    Memo
CONST TS_FLDATTRIB_FIXEDTEXT = 1 '   Fixed length text
CONST TS_FLDATTRIB_JOURNAL = 2      '  SBM Journal field
CONST TS_FLDATTRIB_JOURNAL_RO = 3   '  SBM Append-Only Journal field


'  For TS_FLDTYPE_NUMERIC:
CONST TS_FLDATTRIB_INT  = 0
CONST TS_FLDATTRIB_FLOAT  = 1
CONST TS_FLDATTRIB_FIXED_PRECISION  = 2


'  For TS_FLDTYPE_DATETIME:
CONST TS_FLDATTRIB_DT_DATEONLY = 0   'Date only field.
CONST TS_FLDATTRIB_DT_DATETIME = 1   'Combined date and time of day.
CONST TS_FLDATTRIB_DT_TIMEOFDAY = 2   'Time of day only.
CONST TS_FLDATTRIB_DT_ELAPSEDTIME = 3   'Elapsed time.

'  For TS_FLDTYPE_BINARY (TeamScript can't handle HEX constants)
CONST TS_FLDATTRIB_BIN_LISTBOX  = 0
CONST TS_FLDATTRIB_BIN_RADIOBUTTON  = 1
CONST TS_FLDATTRIB_BIN_CHECKBOX  = 2
CONST TS_FLDATTRIB_BIN_TRINARY  = 16      ' &H10  ' Indicates that this binary field is really trinary.

' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
'  Values for TS_PROPERTY column:

CONST TS_FLDPROP_NONE                  =   0    '  &h0
CONST TS_FLDPROP_NONEDITABLE           =   1    '  &h1  Field will not be editable; i.e. read-only.
CONST TS_FLDPROP_CALC_BEFORE           =   2    '  &h2  Calculation  occurs before the transition form appears.
CONST TS_FLDPROP_CALC_AFTER            =   4    '  &h4  Calculation occurs after the transition form is submitted.
CONST TS_FLDPROP_CALC_ADD_CUR          =   8    '  &h8   Add the calculation to the current value.
CONST TS_FLDPROP_CALC_EMPTY_INVALID    =   0    '  &h00   Empty value results in the field being invalid.
CONST TS_FLDPROP_CALC_EMPTY_SKIP_CALC  =  16    '  &h10   If empty, skip the calculation.
CONST TS_FLDPROP_CALC_EMPTY_TREAT_ZERO =  32    '  &h20   If empty, use 0 for the field value and complete the calculation.
CONST TS_FLDPROP_CALC_EMPTY_MASK       =  48    '  &h30   Mask for either/both above bits.
CONST TS_FLDPROP_CHECKBOXES            = 256    '  &h100   If field can have multiple values, display the choices as checkboxes.


' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
'  Values for TS_SYSCODE column.  SYSCODE is dependent on table ID and Table type

CONST TS_SYSFLD_ID                        =   1
CONST TS_SYSFLD_PARENTID                  =   2
CONST TS_SYSFLD_PROJECTID                 =   3
CONST TS_SYSFLD_TITLE                     =   4
CONST TS_SYSFLD_DESC                      =   5
CONST TS_SYSFLD_STATE                     =   6
CONST TS_SYSFLD_DT_CREATE                 =   7
CONST TS_SYSFLD_DT_LASTMODIFIED           =   8
CONST TS_SYSFLD_DT_LASTSTATECHANGE        =   9
CONST TS_SYSFLD_DT_CLOSE                  =  10
CONST TS_SYSFLD_DT_REOPEN                 =  11
CONST TS_SYSFLD_USER_OWNER                =  12
CONST TS_SYSFLD_USER_SUBMITTER            =  13
CONST TS_SYSFLD_USER_LASTMODIFIER         =  14
CONST TS_SYSFLD_USER_LASTSTATECHANGER     =  15
CONST TS_SYSFLD_TEXT_DISPLAYID            =  16
CONST TS_SYSFLD_SEL_CASETYPE              =  17
CONST TS_SYSFLD_BIN_ACTIVEINACTIVE        =  18
CONST TS_SYSFLD_FOLDERID                  =  19
CONST TS_SYSFLD_LASTINCIDENT              =  20
CONST TS_SYSFLD_MULTIUSER_SECONDARYOWNER  =  21
CONST TS_SYSFLD_COMPANY                   = 100
CONST TS_SYSFLD_CONTACT                   = 101
CONST TS_SYSFLD_MERCHANDISE               = 102
CONST TS_SYSFLD_SERVICEAGREEMENT          = 103
CONST TS_SYSFLD_PROBLEM                   = 104
CONST TS_SYSFLD_RESOLUTION                = 105
CONST TS_SYSFLD_RESOLUTIONTITLE           = 106
CONST TS_SYSFLD_RESOLUTIONDESC            = 107
CONST TS_SYSFLD_CONTACT_COMPID            = 200
CONST TS_SYSFLD_CONTACT_FNAME             = 201
CONST TS_SYSFLD_CONTACT_MNAME             = 202
CONST TS_SYSFLD_CONTACT_LNAME             = 203
CONST TS_SYSFLD_CONTACT_USERID            = 204
CONST TS_SYSFLD_CONTACT_PHONE             = 205
CONST TS_SYSFLD_CONTACT_EMAIL             = 206
CONST TS_SYSFLD_CONTACT_ADDRESS1          = 207
CONST TS_SYSFLD_CONTACT_ADDRESS2          = 208
CONST TS_SYSFLD_CONTACT_CITY              = 209
CONST TS_SYSFLD_CONTACT_STATE             = 210
CONST TS_SYSFLD_CONTACT_COUNTRY           = 211
CONST TS_SYSFLD_CONTACT_ZIPCODE           = 212
CONST TS_SYSFLD_CONTACT_FAXNUMBER         = 213
CONST TS_SYSFLD_CONTACT_MOBILENUMBER      = 214
CONST TS_SYSFLD_COMPANY_NUMBER            = 300
CONST TS_SYSFLD_COMPANY_PRICONTACT        = 301
CONST TS_SYSFLD_COMPANY_SECCONTACT        = 302
CONST TS_SYSFLD_COMPANY_ADDRESS1          = 303
CONST TS_SYSFLD_COMPANY_ADDRESS2          = 304
CONST TS_SYSFLD_COMPANY_CITY              = 305
CONST TS_SYSFLD_COMPANY_STATE             = 306
CONST TS_SYSFLD_COMPANY_COUNTRY           = 307
CONST TS_SYSFLD_COMPANY_ZIPCODE           = 308
CONST TS_SYSFLD_COMPANY_FAXNUMBER         = 309
CONST TS_SYSFLD_COMPANY_PHONENUMBER       = 310
CONST TS_SYSFLD_DT_EXPIRATION             = 400
CONST TS_SYSFLD_VISIBILITY                = 500
CONST TS_SYSFLD_VISIBILITY                = 500
CONST TS_SYSFLD_PRODUCTS                  = 501
CONST TS_SYSFLD_URL                       = 800
CONST TS_SYSFLD_DOC_LIB                   = 801
CONST TS_SYSFLD_PARENT_SITENAME           = 802
CONST TS_SYSFLD_URL_ADDUSER               = 803
CONST TS_SYSFLD_SHAREPOINT_USER           = 804
CONST TS_SYSFLD_SHAREPOINT_PASS           = 805






' Values for TS_TABLES.TS_ID column:
CONST TS_TBLID_NONE = "-1"  ' Default.  SBM BUG: AppScript will not all negative integers.
CONST TS_TBLID_CASES = 1 ' Deprecated. See note below.   *
CONST TS_TBLID_CHANGES = 2
CONST TS_TBLID_FIELDS = 3
CONST TS_TBLID_GROUPS = 4
CONST TS_TBLID_LICENSES = 5 ' No longer valid.
CONST TS_TBLID_MEMBERS = 6
CONST TS_TBLID_PRIVILEGES = 7
CONST TS_TBLID_PROJECTS = 8
CONST TS_TBLID_PROJECTSELECTIONS = 9
CONST TS_TBLID_PROPERTIES = 10
CONST TS_TBLID_REPORTS = 11
CONST TS_TBLID_SELECTIONS = 12
CONST TS_TBLID_STATES = 13
CONST TS_TBLID_TRANSISSUETYPES = 14
CONST TS_TBLID_SYSTEMINFO = 15
CONST TS_TBLID_TRANSITIONS = 16
CONST TS_TBLID_USERS = 17
CONST TS_TBLID_TABLES = 18
CONST TS_TBLID_ATTACHMENTS = 19
CONST TS_TBLID_FOLDERS = 20
CONST TS_TBLID_FOLDERITEMS = 21
CONST TS_TBLID_FOLDERCOLUMNS = 22 ' No longer valid.
CONST TS_TBLID_VCACTIONS = 23
CONST TS_TBLID_PROJECTTRANSITIONS = 24
CONST TS_TBLID_NOTIFICATIONS = 25
CONST TS_TBLID_NOTIFICATIONRULES = 26
CONST TS_TBLID_NOTIFICATIONCONDITIONS = 27
CONST TS_TBLID_NOTIFICATIONEVENTS = 28
CONST TS_TBLID_NOTIFICATIONFIELDS = 29
CONST TS_TBLID_NOTIFICATIONMESSAGES = 30
CONST TS_TBLID_NOTIFICATIONPERMISSIONS = 31
CONST TS_TBLID_NOTIFICATIONSUBSCRIPTIONS = 32
CONST TS_TBLID_MACROS = 33
CONST TS_TBLID_WORKFLOWS = 34
CONST TS_TBLID_FIELDORDERINGS = 35
CONST TS_TBLID_INCIDENTS = 36 ' Deprecated. See note below.   *
CONST TS_TBLID_COMPANIES = 37
CONST TS_TBLID_CONTACTS = 38
CONST TS_TBLID_MERCHANDISE = 39 ' Deprecated. See note below.   *
CONST TS_TBLID_SERVICEAGREEMENTS = 40 ' Deprecated. See note below.   *
CONST TS_TBLID_PROBLEMS = 41
CONST TS_TBLID_RESOLUTIONS = 42
CONST TS_TBLID_PRODUCTS = 43 ' Deprecated. See note below.   *
CONST TS_TBLID_KEYWORDS = 44
CONST TS_TBLID_PRODUCTUSAGES = 45
CONST TS_TBLID_KEYWORDUSAGES = 46
CONST TS_TBLID_TRANSTRIGGERS = 47
CONST TS_TBLID_TRANSTRIGGERSTATES = 48 ' Replaced by TS_STACTIONS in 62002.
CONST TS_TBLID_TRANSTRIGGERTRANSITIONS = 49 ' Replaced by TS_STACTIONS in 62002.
CONST TS_TBLID_ADMINGROUPS = 50
CONST TS_TBLID_MAILHEADERFIELDS = 51
CONST TS_TBLID_MAILBOX = 52
CONST TS_TBLID_MAILMAPPINGS = 53
CONST TS_TBLID_SELFREGFIELDS = 54
CONST TS_TBLID_MSSELECTION = 55
CONST TS_TBLID_SYSTEMSETTINGS = 56
CONST TS_TBLID_GWESTATES = 57
CONST TS_TBLID_GWETRANSITIONS = 58
CONST TS_TBLID_GWECOMMENTS = 59
CONST TS_TBLID_SOLUTIONS = 60
CONST TS_TBLID_SUBTASKS = 61
CONST TS_TBLID_SECTIONS = 62 ' Not currently used.
CONST TS_TBLID_BROWSERS = 63
CONST TS_TBLID_RESOURCES = 64
CONST TS_TBLID_BLOBS = 65
CONST TS_TBLID_RECORDLOCKS = 66
CONST TS_TBLID_ITEMNOTIFICATIONS = 67
CONST TS_TBLID_USAGES = 68
CONST TS_TBLID_ADMINTABLES = 69
CONST TS_TBLID_GROUPENABLER = 70 ' No longer valid.
CONST TS_TBLID_ADMINLOCKS = 71
CONST TS_TBLID_EXTERNALDATABASES = 72
CONST TS_TBLID_EXTERNALPOSTINGS = 73
CONST TS_TBLID_EXTERNALPOSTFIELDMAP = 74
CONST TS_TBLID_ADMINCHANGES = 75
CONST TS_TBLID_LASTID = 76
CONST TS_TBLID_LASTIDS = 76
CONST TS_TBLID_URLSTORE = 77
CONST TS_TBLID_TRANSGROUPS = 78
CONST TS_TBLID_ATTACHMENTSEQUENCES = 79
CONST TS_TBLID_TOOLS = 80
CONST TS_TBLID_BRIDGES = 81
CONST TS_TBLID_FIELD_MAP = 82
CONST TS_TBLID_USER_MAP = 83
CONST TS_TBLID_XREF = 84
CONST TS_TBLID_MULTIUSERUSAGES = 85
CONST TS_TBLID_CONCURRENTLOGINS = 86
CONST TS_TBLID_LABELS = 87
CONST TS_TBLID_VCURLFORMATS = 88
CONST TS_TBLID_TRANSORDERINGS = 89
CONST TS_TBLID_USERSOLUTIONDATA = 90
CONST TS_TBLID_USERQUICKLINKS = 91
CONST TS_TBLID_CACHEACTIONS = 92
CONST TS_TBLID_TRANSATTRS = 93
CONST TS_TBLID_TRANSATTRUSAGES = 94
CONST TS_TBLID_URLINTEGRATIONS = 95
CONST TS_TBLID_URLUSAGES = 96
CONST TS_TBLID_LANGUAGES = 97
CONST TS_TBLID_STRINGIDENTIFIERS = 98
CONST TS_TBLID_STRINGS = 99
CONST TS_TBLID_STACTIONS = 100
CONST TS_TBLID_SELECTIONUSAGES = 101
CONST TS_TBLID_OBJATTRS = 102
CONST TS_TBLID_DBSOURCES = 103
CONST TS_TBLID_IMPORTOPTIONSETS = 104
CONST TS_TBLID_CHANGEACTIONS = 105
CONST TS_TBLID_CHANGETEXT = 107
CONST TS_TBLID_FIELDPRIVILEGES = 108
CONST TS_TBLID_OLDPASSWORDS = 109
CONST TS_TBLID_TRANSSIGNS = 110
CONST TS_TBLID_WSDESCRIPTIONS = 111
CONST TS_TBLID_WSCALLS = 112
CONST TS_TBLID_WSSELECTIONMAPPINGS = 113
CONST TS_TBLID_WSDATAMAPPINGS = 114
CONST TS_TBLID_CALENDARS = 115
CONST TS_TBLID_CALENDARWEEKDAYS = 116
CONST TS_TBLID_CALENDAROVERRIDES = 117
CONST TS_TBLID_CALENDARTIMERANGES = 118
CONST TS_TBLID_TIMEINSTATE = 119
CONST TS_TBLID_ROLES = 120
CONST TS_TBLID_PERMISSIONACTIONS = 121
CONST TS_TBLID_PERMISSIONOBJECTS = 122
CONST TS_TBLID_PERMISSIONCONDITIONS = 123
CONST TS_TBLID_PERMISSIONS = 124
CONST TS_TBLID_ROLEPERMISSIONS = 125
CONST TS_TBLID_SECURITYCONTROLS = 126
CONST TS_TBLID_FORMS = 127
CONST TS_TBLID_FORMUSAGES = 128
CONST TS_TBLID_FORMUSERPREF = 129
CONST TS_TBLID_TRANSITIONPOSTPROJECTS = 130
CONST TS_TBLID_APPLICATIONS = 131
CONST TS_TBLID_IMPORTSTATUS = 132
CONST TS_TBLID_REPORTDISPLAYFORMATS = 133
CONST TS_TBLID_ALFEVENTS = 134
CONST TS_TBLID_ALFEVENTCALLS = 135
CONST TS_TBLID_DELETEDOBJECTS = 136
CONST TS_TBLID_USERFORMSTATES = 137
CONST TS_TBLID_PROCESSMODELS = 138
CONST TS_TBLID_APPLICATIONPROCESSMODELS = 139

'  * These tables are specific to the Issue Management and Incident Management
'  solutions. The TS_ID listed above is correct after upgrade from a 4.0 database.
'  If either or both solutions were deleted from a given database, and
'  subsequently reinstalled, the tables were then created with different values
'  for TS_ID. In short, these values can be used to reliably reference system
'  tables, but not solution tables.


' Values for TS_TABLES.TS_TYPE column:
CONST TS_TBLTYPE_SYS = 0 ' System table, e.g. TS_USERS.
CONST TS_TBLTYPE_PRI = 1 ' Primary table, e.g. TTT_ISSUES.
CONST TS_TBLTYPE_AUX = 2 ' Auxiliary table, e.g. TTS_PRODUCTS.
CONST TS_TBLTYPE_SYSAUX = 3 ' System auxiliary table, e.g. TS_CONTACTS.
CONST TS_TBLTYPE_ARCHIVE = 4 ' Archive for another table.



' -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
'  Values for TS_OPTIONS column:
CONST TS_FLDOPTION_CHECKBOXES       = 0002 ' Deprecated.  Replaced by overridable property: TS_FLDPROP_CHECKBOXES.

CONST TS_FLDOPTION_SELECT_DEFAULT   = 0000 ' Default field selection options.
CONST TS_FLDOPTION_SELECT_MULTIPLE  = 0001 ' Allow multiple selections if set. Otherwise allow only one selection.
CONST TS_FLDOPTION_CHECKBOXES       = 0002 ' Deprecated.  Replaced by overridable property: TS_FLDPROP_CHECKBOXES.
CONST TS_FLDOPTION_FINDFIELD        = 0004 ' Allow field to be searched during a find.
CONST TS_FLDOPTION_PREFORMATTED_HTML= 0008 ' Used to preserve text format on a cut and paste.
' CONST TS_FLDOPTION_STOPWATCH        = &h0010 ' Elapsed time field that is to be viewed as a stopwatch.
CONST TS_FLDOPTION_STOPWATCH        = 16 ' Elapsed time field that is to be viewed as a stopwatch.
CONST TS_FLDOPTION_PRECISION_MASK   =  0000 ' F00  For fixed precision numeric fields only,
													' i.e. fields of type TS_FLDTYPE_NUMERIC
													' with attribute TS_FLDATTRIB_FIXED_PRECISION.
													' Bits 8 - 11 of the TS_OPTIONS column specify the
													' number of digits to display after the decimal point.
' CONST TS_FLDOPTION_PASSWORD         = &h0020 ' For fixed length text fields only. Field will display in the browser as a password field.
CONST TS_FLDOPTION_PASSWORD         = 32 ' For fixed length text fields only. Field will display in the browser as a password field.
' CONST TS_FLDOPTION_NODELETE         = &h0040 ' Can only be set when the field is initially
CONST TS_FLDOPTION_NODELETE         = 64 ' Can only be set when the field is initially
													' created, and if set, the field cannot
													' subsequently be deleted, e.g. system
													' fields are not deletable.
'CONST TS_FLDOPTION_NOSECONDS        = &h0080 ' Don't show seconds in Elapsed Time fields..
CONST TS_FLDOPTION_NOSECONDS        = 128 ' Don't show seconds in Elapsed Time fields..
'CONST TS_FLDOPTION_GROUPING         = &h1000 ' Shows thousands separators, e.g., 1,000 vs. 1000.
CONST TS_FLDOPTION_GROUPING         = 4096 ' Shows thousands separators, e.g., 1,000 vs. 1000.
'CONST TS_FLDOPTION_BACKFILL         = &h2000 ' Temporary flag indicating the new column should
CONST TS_FLDOPTION_BACKFILL         = 8192 ' Temporary flag indicating the new column should
													' be set to default value upon create. This corresponds
													' to the checkbox  "Backfill to existing items" in the
													' Administrator Options tab, while adding a field.
' CONST TS_FLDOPTION_NODAYS           = &h4000 ' Convert elapsed  time to include number of days. Flag
CONST TS_FLDOPTION_NODAYS           = 16384 ' Convert elapsed  time to include number of days. Flag
													' corresponds to the check box "Calculate Days" in the
													' Administrator Options tab, while adding/editing a
													' date time field. If the checkbox is checked in the
													' options tab, this bit will be cleared.
'CONST TS_FLDOPTION_SORT_NEWEST_FIRST= &h8000 ' Used for journal fields only. Entries will be sorted starting with the newest entry.
CONST TS_FLDOPTION_SORT_NEWEST_FIRST= 32768 ' Used for journal fields only. Entries will be sorted starting with the newest entry.
'CONST TS_FLDOPTION_RENDER_HTML      = &h10000 ' Used for memo fields only. When this flag is set,
CONST TS_FLDOPTION_RENDER_HTML      = 65536 ' Used for memo fields only. When this flag is set,
													 ' HTML tags in the field will be passed to the browser
													 ' for rendering. Without this flag, HTML tags in the
													 ' field will be escaped so that the tags will be
													 ' displayed as plain text.
'CONST TS_FLDOPTION_ALLOW_HUGE       = &h20000 ' Used for memo and journal fields in an Oracle
CONST TS_FLDOPTION_ALLOW_HUGE       = 131072 ' Used for memo and journal fields in an Oracle
													 ' database only. When this flag is set, the field
													 ' will be created as a CLOB column. Without this
													 ' flag, the field will be created as a VARCHAR
													 ' column. The flag is not used in SQL Server or
													 ' Access databases, where all memo and journal
													 ' fields are created as LONGVARCHAR columns.
'CONST TS_FLDOPTION_SPANS_ROW        = &h40000 ' Applicable to all fields, field is displayed on a row by itself.
CONST TS_FLDOPTION_SPANS_ROW        = 262144 ' Applicable to all fields, field is displayed on a row by itself.