00001 00032 #ifndef LL_LLDBSTRINGS_H 00033 #define LL_LLDBSTRINGS_H 00034 00040 // asset.name varchar(63) 00041 // -also- 00042 // user_inventory_item.name varchar(63) 00043 // -also- 00044 // user_inventory_folder.name varchar(63) was CAT_NAME_SIZE 00045 // Must be >= DB_FULL_NAME_STR_LEN so that calling cards work 00046 const S32 DB_INV_ITEM_NAME_STR_LEN = 63; // was MAX_ASSET_NAME_LENGTH 00047 const S32 DB_INV_ITEM_NAME_BUF_SIZE = 64; // was ITEM_NAME_SIZE 00048 00049 // asset.description varchar(127) 00050 // -also- 00051 // user_inventory_item.description varchar(127) 00052 const S32 DB_INV_ITEM_DESC_STR_LEN = 127; // was MAX_ASSET_DESCRIPTION_LENGTH 00053 const S32 DB_INV_ITEM_DESC_BUF_SIZE = 128; // was ITEM_DESC_SIZE 00054 00055 // groups.name varchar(35) 00056 const S32 DB_GROUP_NAME_STR_LEN = 35; 00057 const S32 DB_GROUP_NAME_BUF_SIZE = 36; 00058 const S32 DB_GROUP_NAME_MIN_LEN = 4; 00059 00060 //group_roles.name 00061 const U32 DB_GROUP_ROLE_NAME_STR_LEN = 20; 00062 const U32 DB_GROUP_ROLE_NAME_BUF_SIZE = DB_GROUP_ROLE_NAME_STR_LEN + 1; 00063 00064 //group_roles.title 00065 const U32 DB_GROUP_ROLE_TITLE_STR_LEN = 20; 00066 const U32 DB_GROUP_ROLE_TITLE_BUF_SIZE = DB_GROUP_ROLE_TITLE_STR_LEN + 1; 00067 00068 00069 // group.charter text 00070 const S32 DB_GROUP_CHARTER_STR_LEN = 511; 00071 const S32 DB_GROUP_CHARTER_BUF_SIZE = 512; 00072 00073 // group.officer_title varchar(20) 00074 // -also- 00075 // group.member_title varchar(20) 00076 const S32 DB_GROUP_TITLE_STR_LEN = 20; 00077 const S32 DB_GROUP_TITLE_BUF_SIZE = 21; 00078 00079 // Since chat and im both dump into the database text message log, 00080 // they derive their max size from the same constant. 00081 const S32 MAX_MSG_STR_LEN = 1023; 00082 const S32 MAX_MSG_BUF_SIZE = 1024; 00083 00084 // instant_message.message text 00085 const S32 DB_IM_MSG_STR_LEN = MAX_MSG_STR_LEN; 00086 const S32 DB_IM_MSG_BUF_SIZE = MAX_MSG_BUF_SIZE; 00087 00088 // groupnotices 00089 const S32 DB_GROUP_NOTICE_SUBJ_STR_LEN = 63; 00090 const S32 DB_GROUP_NOTICE_SUBJ_STR_SIZE = 64; 00091 const S32 DB_GROUP_NOTICE_MSG_STR_LEN = MAX_MSG_STR_LEN - DB_GROUP_NOTICE_SUBJ_STR_LEN; 00092 const S32 DB_GROUP_NOTICE_MSG_STR_SIZE = MAX_MSG_BUF_SIZE - DB_GROUP_NOTICE_SUBJ_STR_SIZE; 00093 00094 // log_text_message.message text 00095 const S32 DB_CHAT_MSG_STR_LEN = MAX_MSG_STR_LEN; 00096 const S32 DB_CHAT_MSG_BUF_SIZE = MAX_MSG_BUF_SIZE; 00097 00098 // money_stipend.description varchar(254) 00099 const S32 DB_STIPEND_DESC_STR_LEN = 254; 00100 const S32 DB_STIPEND_DESC_BUF_SIZE = 255; 00101 00102 // script_email_message.from_email varchar(78) 00103 const S32 DB_EMAIL_FROM_STR_LEN = 78; 00104 const S32 DB_EMAIL_FROM_BUF_SIZE = 79; 00105 00106 // script_email_message.subject varchar(72) 00107 const S32 DB_EMAIL_SUBJECT_STR_LEN = 72; 00108 const S32 DB_EMAIL_SUBJECT_BUF_SIZE = 73; 00109 00110 // system_globals.motd varchar(254) 00111 const S32 DB_MOTD_STR_LEN = 254; 00112 const S32 DB_MOTD_BUF_SIZE = 255; 00113 00114 // Must be <= user_inventory_item.name so that calling cards work 00115 // First name + " " + last name...or a system assigned "from" name 00116 // instant_message.from_agent_name varchar(63) 00117 // -also- 00118 // user_mute.mute_agent_name varchar(63) 00119 const S32 DB_FULL_NAME_STR_LEN = 63; 00120 const S32 DB_FULL_NAME_BUF_SIZE = 64; // was USER_NAME_SIZE 00121 00122 // user.username varchar(31) 00123 const S32 DB_FIRST_NAME_STR_LEN = 31; 00124 const S32 DB_FIRST_NAME_BUF_SIZE = 32; // was MAX_FIRST_NAME 00125 00126 // user_last_name.name varchar(31) 00127 const S32 DB_LAST_NAME_STR_LEN = 31; 00128 const S32 DB_LAST_NAME_BUF_SIZE = 32; // was MAX_LAST_NAME 00129 00130 // user.password varchar(100) 00131 const S32 DB_USER_PASSWORD_STR_LEN = 100; 00132 const S32 DB_USER_PASSWORD_BUF_SIZE = 101; // was MAX_PASSWORD 00133 00134 // user.email varchar(254) 00135 const S32 DB_USER_EMAIL_ADDR_STR_LEN = 254; 00136 const S32 DB_USER_EMAIL_ADDR_BUF_SIZE = 255; 00137 00138 // user.about text 00139 const S32 DB_USER_ABOUT_STR_LEN = 511; 00140 const S32 DB_USER_ABOUT_BUF_SIZE = 512; 00141 00142 // user.fl_about_text text 00143 // Must be 255 not 256 as gets packed into message Variable 1 00144 const S32 DB_USER_FL_ABOUT_STR_LEN = 254; 00145 const S32 DB_USER_FL_ABOUT_BUF_SIZE = 255; 00146 00147 // user.profile_url text 00148 // Must be 255 not 256 as gets packed into message Variable 1 00149 const S32 DB_USER_PROFILE_URL_STR_LEN = 254; 00150 const S32 DB_USER_PROFILE_URL_BUF_SIZE = 255; 00151 00152 // user.want_to varchar(254) 00153 const S32 DB_USER_WANT_TO_STR_LEN = 254; 00154 const S32 DB_USER_WANT_TO_BUF_SIZE = 255; 00155 00156 // user.skills varchar(254) 00157 const S32 DB_USER_SKILLS_STR_LEN = 254; 00158 const S32 DB_USER_SKILLS_BUF_SIZE = 255; 00159 00160 // user_nv.name varchar(128) 00161 const S32 DB_NV_NAME_STR_LEN = 128; 00162 const S32 DB_NV_NAME_BUF_SIZE = 129; 00163 00164 // votes.vote_text varchar(254) 00165 const S32 DB_VOTE_TEXT_STR_LEN = 254; 00166 const S32 DB_VOTE_TEXT_BUF_SIZE = 255; 00167 00168 // vpte type text varchar(9) 00169 const S32 DB_VOTE_TYPE_STR_LEN = 9; 00170 const S32 DB_VOTE_TYPE_BUF_SIZE = 10; 00171 00172 // vote result text 00173 const S32 DB_VOTE_RESULT_BUF_LEN = 8; 00174 const S32 DB_VOTE_RESULT_BUF_SIZE = 9; 00175 00176 // user_start_location.location_name varchar(254) 00177 const S32 DB_START_LOCATION_STR_LEN = 254; 00178 const S32 DB_START_LOCATION_BUF_SIZE = 255; 00179 00180 // money_tax_assessment.sim varchar(100) 00181 //const S32 DB_SIM_NAME_STR_LEN = 100; 00182 //const S32 DB_SIM_NAME_BUF_SIZE = 101; 00183 00184 // born on date date 00185 const S32 DB_BORN_STR_LEN = 15; 00186 const S32 DB_BORN_BUF_SIZE = 16; 00187 00188 // place.name 00189 const S32 DB_PLACE_NAME_LEN = 63; 00190 const S32 DB_PLACE_NAME_SIZE = 64; 00191 const S32 DB_PARCEL_NAME_LEN = 63; 00192 const S32 DB_PARCEL_NAME_SIZE = 64; 00193 00194 // place.desc 00195 const S32 DB_PLACE_DESC_LEN = 255; 00196 const S32 DB_PLACE_DESC_SIZE = 256; 00197 const S32 DB_PARCEL_DESC_LEN = 255; 00198 const S32 DB_PARCEL_DESC_SIZE = 256; 00199 const S32 DB_PARCEL_MUSIC_URL_LEN = 255; 00200 const S32 DB_PARCEL_MEDIA_URL_LEN = 255; 00201 const S32 DB_PARCEL_MUSIC_URL_SIZE = 256; 00202 00203 // date time that is easily human readable 00204 const S32 DB_DATETIME_STR_LEN = 35; 00205 const S32 DB_DATETIME_BUF_SIZE = 36; 00206 00207 // date time that isn't easily human readable 00208 const S32 DB_TERSE_DATETIME_STR_LEN = 15; 00209 const S32 DB_TERSE_DATETIME_BUF_SIZE = 16; 00210 00211 // indra.simulator constants 00212 const S32 DB_SIM_NAME_STR_LEN = 35; 00213 const S32 DB_SIM_NAME_BUF_SIZE = 36; 00214 const S32 DB_HOST_NAME_STR_LEN = 100; 00215 const S32 DB_HOST_NAME_BUF_SIZE = 101; 00216 const S32 DB_ESTATE_NAME_STR_LEN = 63; 00217 const S32 DB_ESTATE_NAME_BUF_SIZE = DB_ESTATE_NAME_STR_LEN + 1; 00218 00219 // user_note.note 00220 const S32 DB_USER_NOTE_LEN = 1023; 00221 const S32 DB_USER_NOTE_SIZE = 1024; 00222 00223 // pick.name 00224 const S32 DB_PICK_NAME_LEN = 63; 00225 const S32 DB_PICK_NAME_SIZE = 64; 00226 00227 // pick.desc 00228 const S32 DB_PICK_DESC_LEN = 1023; 00229 const S32 DB_PICK_DESC_SIZE = 1024; 00230 00231 #endif // LL_LLDBSTRINGS_H