1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
|
/**
* @file lldbstrings.h
* @brief Database String Lengths.
*
* $LicenseInfo:firstyear=2002&license=viewergpl$
*
* Copyright (c) 2002-2009, Linden Research, Inc.
*
* Second Life Viewer Source Code
* The source code in this file ("Source Code") is provided by Linden Lab
* to you under the terms of the GNU General Public License, version 2.0
* ("GPL"), unless you have obtained a separate licensing agreement
* ("Other License"), formally executed by you and Linden Lab. Terms of
* the GPL can be found in doc/GPL-license.txt in this distribution, or
* online at http://secondlifegrid.net/programs/open_source/licensing/gplv2
*
* There are special exceptions to the terms and conditions of the GPL as
* it is applied to this Source Code. View the full text of the exception
* in the file doc/FLOSS-exception.txt in this software distribution, or
* online at http://secondlifegrid.net/programs/open_source/licensing/flossexception
*
* By copying, modifying or distributing this software, you acknowledge
* that you have read and understood your obligations described above,
* and agree to abide by those obligations.
*
* ALL LINDEN LAB SOURCE CODE IS PROVIDED "AS IS." LINDEN LAB MAKES NO
* WARRANTIES, EXPRESS, IMPLIED OR OTHERWISE, REGARDING ITS ACCURACY,
* COMPLETENESS OR PERFORMANCE.
* $/LicenseInfo$
*/
#ifndef LL_LLDBSTRINGS_H
#define LL_LLDBSTRINGS_H
/**
* Defines the length of strings that are stored in the database (and
* the size of the buffer large enough to hold each one)
*/
// asset.name varchar(63)
// -also-
// user_inventory_item.name varchar(63)
// -also-
// user_inventory_folder.name varchar(63) was CAT_NAME_SIZE
// Must be >= DB_FULL_NAME_STR_LEN so that calling cards work
const S32 DB_INV_ITEM_NAME_STR_LEN = 63; // was MAX_ASSET_NAME_LENGTH
const S32 DB_INV_ITEM_NAME_BUF_SIZE = 64; // was ITEM_NAME_SIZE
// asset.description varchar(127)
// -also-
// user_inventory_item.description varchar(127)
const S32 DB_INV_ITEM_DESC_STR_LEN = 127; // was MAX_ASSET_DESCRIPTION_LENGTH
const S32 DB_INV_ITEM_DESC_BUF_SIZE = 128; // was ITEM_DESC_SIZE
// groups.name varchar(35)
const S32 DB_GROUP_NAME_STR_LEN = 35;
const S32 DB_GROUP_NAME_BUF_SIZE = 36;
const S32 DB_GROUP_NAME_MIN_LEN = 4;
//group_roles.name
const U32 DB_GROUP_ROLE_NAME_STR_LEN = 20;
const U32 DB_GROUP_ROLE_NAME_BUF_SIZE = DB_GROUP_ROLE_NAME_STR_LEN + 1;
//group_roles.title
const U32 DB_GROUP_ROLE_TITLE_STR_LEN = 20;
const U32 DB_GROUP_ROLE_TITLE_BUF_SIZE = DB_GROUP_ROLE_TITLE_STR_LEN + 1;
// group.charter text
const S32 DB_GROUP_CHARTER_STR_LEN = 511;
const S32 DB_GROUP_CHARTER_BUF_SIZE = 512;
// group.officer_title varchar(20)
// -also-
// group.member_title varchar(20)
const S32 DB_GROUP_TITLE_STR_LEN = 20;
const S32 DB_GROUP_TITLE_BUF_SIZE = 21;
// Since chat and im both dump into the database text message log,
// they derive their max size from the same constant.
const S32 MAX_MSG_STR_LEN = 1023;
const S32 MAX_MSG_BUF_SIZE = 1024;
// instant_message.message text
const S32 DB_IM_MSG_STR_LEN = MAX_MSG_STR_LEN;
const S32 DB_IM_MSG_BUF_SIZE = MAX_MSG_BUF_SIZE;
// groupnotices
const S32 DB_GROUP_NOTICE_SUBJ_STR_LEN = 63;
const S32 DB_GROUP_NOTICE_SUBJ_STR_SIZE = 64;
const S32 DB_GROUP_NOTICE_MSG_STR_LEN = MAX_MSG_STR_LEN - DB_GROUP_NOTICE_SUBJ_STR_LEN;
const S32 DB_GROUP_NOTICE_MSG_STR_SIZE = MAX_MSG_BUF_SIZE - DB_GROUP_NOTICE_SUBJ_STR_SIZE;
// log_text_message.message text
const S32 DB_CHAT_MSG_STR_LEN = MAX_MSG_STR_LEN;
const S32 DB_CHAT_MSG_BUF_SIZE = MAX_MSG_BUF_SIZE;
// money_stipend.description varchar(254)
const S32 DB_STIPEND_DESC_STR_LEN = 254;
const S32 DB_STIPEND_DESC_BUF_SIZE = 255;
// script_email_message.from_email varchar(78)
const S32 DB_EMAIL_FROM_STR_LEN = 78;
const S32 DB_EMAIL_FROM_BUF_SIZE = 79;
// script_email_message.subject varchar(72)
const S32 DB_EMAIL_SUBJECT_STR_LEN = 72;
const S32 DB_EMAIL_SUBJECT_BUF_SIZE = 73;
// system_globals.motd varchar(254)
const S32 DB_MOTD_STR_LEN = 254;
const S32 DB_MOTD_BUF_SIZE = 255;
// Must be <= user_inventory_item.name so that calling cards work
// First name + " " + last name...or a system assigned "from" name
// instant_message.from_agent_name varchar(63)
// -also-
// user_mute.mute_agent_name varchar(63)
const S32 DB_FULL_NAME_STR_LEN = 63;
const S32 DB_FULL_NAME_BUF_SIZE = 64; // was USER_NAME_SIZE
// user.username varchar(31)
const S32 DB_FIRST_NAME_STR_LEN = 31;
const S32 DB_FIRST_NAME_BUF_SIZE = 32; // was MAX_FIRST_NAME
// user_last_name.name varchar(31)
const S32 DB_LAST_NAME_STR_LEN = 31;
const S32 DB_LAST_NAME_BUF_SIZE = 32; // was MAX_LAST_NAME
// user.password varchar(100)
const S32 DB_USER_PASSWORD_STR_LEN = 100;
const S32 DB_USER_PASSWORD_BUF_SIZE = 101; // was MAX_PASSWORD
// user.email varchar(254)
const S32 DB_USER_EMAIL_ADDR_STR_LEN = 254;
const S32 DB_USER_EMAIL_ADDR_BUF_SIZE = 255;
// user.about text
const S32 DB_USER_ABOUT_STR_LEN = 511;
const S32 DB_USER_ABOUT_BUF_SIZE = 512;
// user.fl_about_text text
// Must be 255 not 256 as gets packed into message Variable 1
const S32 DB_USER_FL_ABOUT_STR_LEN = 254;
const S32 DB_USER_FL_ABOUT_BUF_SIZE = 255;
// user.profile_url text
// Must be 255 not 256 as gets packed into message Variable 1
const S32 DB_USER_PROFILE_URL_STR_LEN = 254;
const S32 DB_USER_PROFILE_URL_BUF_SIZE = 255;
// user.want_to varchar(254)
const S32 DB_USER_WANT_TO_STR_LEN = 254;
const S32 DB_USER_WANT_TO_BUF_SIZE = 255;
// user.skills varchar(254)
const S32 DB_USER_SKILLS_STR_LEN = 254;
const S32 DB_USER_SKILLS_BUF_SIZE = 255;
// user_nv.name varchar(128)
const S32 DB_NV_NAME_STR_LEN = 128;
const S32 DB_NV_NAME_BUF_SIZE = 129;
// votes.vote_text varchar(254)
const S32 DB_VOTE_TEXT_STR_LEN = 254;
const S32 DB_VOTE_TEXT_BUF_SIZE = 255;
// vpte type text varchar(9)
const S32 DB_VOTE_TYPE_STR_LEN = 9;
const S32 DB_VOTE_TYPE_BUF_SIZE = 10;
// vote result text
const S32 DB_VOTE_RESULT_BUF_LEN = 8;
const S32 DB_VOTE_RESULT_BUF_SIZE = 9;
// user_start_location.location_name varchar(254)
const S32 DB_START_LOCATION_STR_LEN = 254;
const S32 DB_START_LOCATION_BUF_SIZE = 255;
// money_tax_assessment.sim varchar(100)
//const S32 DB_SIM_NAME_STR_LEN = 100;
//const S32 DB_SIM_NAME_BUF_SIZE = 101;
// born on date date
const S32 DB_BORN_STR_LEN = 15;
const S32 DB_BORN_BUF_SIZE = 16;
// place.name
const S32 DB_PLACE_NAME_LEN = 63;
const S32 DB_PLACE_NAME_SIZE = 64;
const S32 DB_PARCEL_NAME_LEN = 63;
const S32 DB_PARCEL_NAME_SIZE = 64;
// place.desc
const S32 DB_PLACE_DESC_LEN = 255;
const S32 DB_PLACE_DESC_SIZE = 256;
const S32 DB_PARCEL_DESC_LEN = 255;
const S32 DB_PARCEL_DESC_SIZE = 256;
const S32 DB_PARCEL_MUSIC_URL_LEN = 255;
const S32 DB_PARCEL_MEDIA_URL_LEN = 255;
const S32 DB_PARCEL_MUSIC_URL_SIZE = 256;
// date time that is easily human readable
const S32 DB_DATETIME_STR_LEN = 35;
const S32 DB_DATETIME_BUF_SIZE = 36;
// date time that isn't easily human readable
const S32 DB_TERSE_DATETIME_STR_LEN = 15;
const S32 DB_TERSE_DATETIME_BUF_SIZE = 16;
// indra.simulator constants
const S32 DB_SIM_NAME_STR_LEN = 35;
const S32 DB_SIM_NAME_BUF_SIZE = 36;
const S32 DB_HOST_NAME_STR_LEN = 100;
const S32 DB_HOST_NAME_BUF_SIZE = 101;
const S32 DB_ESTATE_NAME_STR_LEN = 63;
const S32 DB_ESTATE_NAME_BUF_SIZE = DB_ESTATE_NAME_STR_LEN + 1;
// user_note.note
const S32 DB_USER_NOTE_LEN = 1023;
const S32 DB_USER_NOTE_SIZE = 1024;
// pick.name
const S32 DB_PICK_NAME_LEN = 63;
const S32 DB_PICK_NAME_SIZE = 64;
// pick.desc
const S32 DB_PICK_DESC_LEN = 1023;
const S32 DB_PICK_DESC_SIZE = 1024;
#endif // LL_LLDBSTRINGS_H
|
