/** 
 * @file lldbstrings.h
 * @brief Database String Lengths.
 *
 * $LicenseInfo:firstyear=2002&license=viewergpl$
 * 
 * Copyright (c) 2002-2008, 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
