Menu
▾
▴
pidgin-commits
|
From: <bi...@us...> - 2006-06-25 23:15:34
|
Revision: 16338 Author: billatq Date: 2006-06-25 16:15:25 -0700 (Sun, 25 Jun 2006) ViewCVS: http://svn.sourceforge.net/gaim/?rev=16338&view=rev Log Message: ----------- Add documentation for the dblogger database schema Added Paths: ----------- branches/soc-2006-db-logger/doc/static-html/ branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-logo.png branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-overview.png branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-transparent.gif branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.css branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.html branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.js Added: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-logo.png =================================================================== (Binary files differ) Property changes on: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-logo.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-overview.png =================================================================== (Binary files differ) Property changes on: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-overview.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-transparent.gif =================================================================== (Binary files differ) Property changes on: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema-transparent.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.css =================================================================== --- branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.css (rev 0) +++ branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.css 2006-06-25 23:15:25 UTC (rev 16338) @@ -0,0 +1,217 @@ +.Body { + color: #000000; + font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; + font-size: 9pt; + font-style: normal; + font-variant: normal; + font-weight: normal; + letter-spacing: 0; + line-height: 14.3pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 9pt; + padding-top: 0pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Footnote_Text { + color: #000000; + font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; + font-size: 9pt; + font-style: normal; + font-variant: normal; + font-weight: normal; + letter-spacing: 0; + line-height: 14.3pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 0pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Free_Form { + color: #000000; + font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; + font-size: 9pt; + font-style: normal; + font-variant: normal; + font-weight: normal; + letter-spacing: 0; + line-height: 14.3pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 0pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Heading_1 { + color: #136993; + font-family: 'HelveticaNeue', 'Helvetica Neue', 'Arial', 'sans-serif'; + font-size: 13pt; + font-style: normal; + font-variant: normal; + font-weight: bold; + letter-spacing: 0; + line-height: 19.5pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 9pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Heading_3 { + color: #000000; + font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; + font-size: 9pt; + font-style: normal; + font-variant: normal; + font-weight: bold; + letter-spacing: 0; + line-height: 14.3pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 9pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.TOC_Heading_1 { + color: #136993; + font-family: 'HelveticaNeue', 'Helvetica Neue', 'Arial', 'sans-serif'; + font-size: 14pt; + font-style: normal; + font-variant: normal; + font-weight: bold; + letter-spacing: 0; + line-height: 16pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 12pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.TOC_Heading_2 { + color: #136993; + font-family: 'HelveticaNeue', 'Helvetica Neue', 'Arial', 'sans-serif'; + font-size: 10pt; + font-style: normal; + font-variant: normal; + font-weight: bold; + letter-spacing: 0; + line-height: 12pt; + margin-bottom: 0pt; + margin-left: 9pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 0pt; + padding-top: 12pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Title { + color: #000000; + font-family: 'HelveticaNeue-UltraLight', 'Helvetica Neue', 'Helvetica Neue UltraLight', 'Arial', 'sans-serif'; + font-size: 32pt; + font-style: normal; + font-variant: normal; + font-weight: normal; + letter-spacing: 0.06em; + line-height: 38pt; + margin-bottom: 0pt; + margin-left: 0pt; + margin-right: 0pt; + margin-top: 0pt; + padding-bottom: 68pt; + padding-top: 0pt; + text-align: left; + text-decoration: none; + text-indent: 0pt; + text-transform: none; +} +.Normal_22 { + width: 468pt; +} +.Normal_23 { + width: 468pt; +} +.Normal_26 { + width: 468pt; +} +.Table { + background: transparent; + border-collapse: collapse; +} +.graphic_textbox_style_default, .graphic_textbox_style_default_6 { + background: transparent; + border: 1pt #000000 none; + float: none; + margin: 0pt; +} +.graphic_textbox_style_default_6 { + float: none; + margin: 0pt; +} +.table_cell_style_default { + background: transparent; +} +.table_header_row_cell_style_default { + background: #136993; +} +.FootnoteRegion { + border-bottom-width: 0; + border-color: #7f7f7f; + border-left-width: 0; + border-right-width: 0; + border-style: solid; + border-top-width: thin; + margin-top: 1em; + padding-top: 0.5em; +} +.Spacer {display: inline; } +.Spacer {display: inline-block; } +ol { + list-style-image: none; + list-style-position: inside; + list-style-type: none; + margin: 0; + padding: 0; + text-indent: 0; +} +.Bullet { text-decoration: none; +} +div { + overflow: visible; +} +img { + border: none; +} Property changes on: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.css ___________________________________________________________________ Name: svn:mime-type + text/css Name: svn:eol-style + native Added: branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.html =================================================================== --- branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.html (rev 0) +++ branches/soc-2006-db-logger/doc/static-html/gaim-dbschema.html 2006-06-25 23:15:25 UTC (rev 16338) @@ -0,0 +1,1277 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> + +<meta name="Generator" content="Pages 2.0" /> +<title></title> +<link rel="stylesheet" type="text/css" media="screen" href="gaim-dbschema.css" /> +<script type="text/javascript" src="gaim-dbschema.js"></script></head> +<body style="margin: 72pt; " onload="onPageLoad();"> +<div><div style="margin: 90pt 0pt 0pt 0pt; width: 468pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; padding-top: 0pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; margin-top: 1.6pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div class="paragraph Free_Form" style="line-height: 14.3pt; text-decoration: none;"> </div> +<div style="float: right; position: relative; "><img src="gaim-dbschema-logo.png" alt="" id="id1" style="border: none; float: right; height: 47pt; position: relative; width: 35.8pt; " /></div> +<div style="float: none; margin: 0pt; float: right; height: 14pt; position: relative; width: 93pt; "><div><div><div class="graphic_textbox_layout_style_default"><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; text-align: center; line-height: 14.3pt;">Gaim Project</div> +</div> +</div> +</div> +</div> +<div class="paragraph Title" style="line-height: 38pt; ">SQL Logging Database Schema Design Document</div> +<div class="paragraph Body" style="line-height: 14.3pt; margin-top: -1.6pt; ">Prepared By: William Reading</div> +<div class="paragraph Body" style="line-height: 14.3pt; margin-top: 1.6pt; ">Date: 25 June 2006</div> +<div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; ">Version: 5</div> +</div> +</div> +<div><div style="margin: 36pt 0pt 0pt 0pt; width: 468pt; "><div class="paragraph"></div> +<div class="paragraph Title" style="line-height: 38pt; padding-top: 0pt; "><span>Table of Contents</span><span style="color: #136993; line-height: 38pt; "></span></div> +<div class="paragraph TOC_Heading_1" style="line-height: 17pt; "><a href="#TOC398">Table Design</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC411">Conventions</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC880">Definitions</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC1602">Overview</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC1622">Accounts</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC1927">AliasDates</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC2224">Aliases</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC2497">Buddies</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC2766">Events</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC2850">MessageEvents</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC3130">Messages</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC3585">Metadata</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC3757">Protocols</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC3924">SessionBuddy</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC4149">Sessions</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC4609">Status</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC4765">StatusChange</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC5067">Timezones</a></div> +<div class="paragraph TOC_Heading_1" style="line-height: 17pt; "><a href="#TOC5116">Appendix: Sample SQL</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC5137">Overview</a></div> +<div class="paragraph TOC_Heading_2" style="line-height: 12pt; "><a href="#TOC5205">Schema</a></div> +</div> +</div> +<div><div style="margin: 36pt 0pt 0pt 0pt; width: 468pt; "><div class="paragraph"></div> +<div class="paragraph Title" style="line-height: 38pt; padding-top: 0pt; "><a name="TOC398" id="TOC398"></a><span>Table Design</span></div> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: -2.4pt; "><a name="TOC411" id="TOC411"></a><span>Conventions</span></div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 1pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">The key words “MUST”, “MUST NOT”, “SHOULD”, “SHOULD NOT”, and “MAY” in this document are to be interpreted as defined in RFC2119.</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">Primary keys implicitly require that the field is NOT NULL and UNIQUE.</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">Primary keys of type INTEGER will AUTOINCREMENT unless otherwise specified.</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">All fields are NOT NULL unless otherwise specified.</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">All VARCHAR fields SHOULD be stored as UTF-8.</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">Times MUST be stored in UTC, with a link to the Timezone that it was logged from.</span></div> +</li> +</ol> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "><a name="TOC880" id="TOC880"></a><span>Definitions</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; "><span style="font-weight: bold; line-height: 14.3pt; ">ASCII</span><span> - </span><span style="font-style: italic; line-height: 14.3pt; ">American Standard Code for Information Interchange. </span><span>Commonly used character encoding based upon the English language</span><a href="#Footnote1" style="font-size: 5.9pt; line-height: 14.3pt; vertical-align: 0.50em; ">3</a><span>.</span><span style="font-weight: bold; line-height: 14.3pt; "> </span></div> +<div class="paragraph Body" style="line-height: 14.3pt; "><span style="font-weight: bold; line-height: 14.3pt; ">PRPL </span><span>- </span><span style="font-style: italic; line-height: 14.3pt; ">Protocol Plugin</span><span>. Protocol plugins provide support for protocols that Gaim uses, such as Jabber or Zephyr.</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; "><span style="font-weight: bold; line-height: 14.3pt; ">Unicode</span><span> - Industry standard designed to allow text and symbols from all of the writing systems of the world to be consistently represented and manipulated by computers</span><a href="#(null)" style="font-size: 5.9pt; line-height: 14.3pt; vertical-align: 0.50em; "></a><span>.</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; "><span style="font-weight: bold; line-height: 14.3pt; ">UTC</span><span> - </span><span style="font-style: italic; line-height: 14.3pt; ">Coordinated Universal Time</span><span>. The time system in which time zone offsets use as a reference point.</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; "><span style="font-weight: bold; line-height: 14.3pt; ">UTF-8</span><span style="line-height: 14.3pt; "> - </span><span style="font-style: italic; line-height: 14.3pt; ">8-bit Unicode Transformation Format</span><span style="line-height: 14.3pt; ">. A variable-length character encoding for Unicode that can represent any letter in the Unicode standard, but is also backwards-compatible with ASCII</span><a href="#(null)" style="font-size: 5.9pt; line-height: 14.3pt; vertical-align: 0.50em; "></a><span style="line-height: 14.3pt; ">.</span></div> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "></div> +<div class="paragraph Heading_1" style="line-height: 20.8pt; "><a name="TOC1602" id="TOC1602"></a><span>Overview</span></div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; margin-top: -1.6pt; ">Diagram</div> +<div class="paragraph Body" style="line-height: 14.3pt; margin-top: 1.6pt; text-decoration: none;"> </div> +<div class="paragraph Body" style="line-height: 14.3pt; "><img src="gaim-dbschema-overview.png" alt="" id="id2" style="border: none; height: 399.7pt; margin-bottom: 1pt; margin-right: 1pt; width: 468pt; " /></div> +<div class="paragraph Heading_1" style="line-height: 20.8pt; "><a name="TOC1622" id="TOC1622"></a><span>Accounts</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Stores information about accounts in which the buddy is associated. The ‘Name’ field MUST be processed with the gaim_normalize() function before being inserted into the database.</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 79pt; width: 467pt; word-wrap: break-word; " id="id3"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AccountID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the Account in the table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">ProtocolID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Uniquely identifies the protocol in the table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Name</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">VARCHAR</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the name of the account</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Constraints</div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">UNIQUE(ProtocolID, Name)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (ProtocolID) REFERENCES Protocols (ProtocolID)</span></div> +</li> +</ol> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "><a name="TOC1927" id="TOC1927"></a><span>AliasDates</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Stores when the alias was used.</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 169pt; width: 467pt; word-wrap: break-word; " id="id4"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AliasDateID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the date range.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AliasID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies an AliasID that this AliasDate describes.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">StartTime</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">DATETIME</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Contains the time that the alias entered use.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">EndTime</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">DATETIME NULL</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Contains the time that the alias finished use.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">BeginTimezone</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the timezone for the time when the alias entered use.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">EndTimezone</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER NULL</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the timezone for the time when the alias ended use.</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Constraints</div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">CHECK (EndTime IS NULL OR EndTime >= StartTime)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (AliasID) REFERENCES Aliases (AliasID)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (BeginTimezone) REFERENCES Timezones (TimezoneID)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (EndTimezone) REFERENCES Timezones (TimezoneID)</span></div> +</li> +</ol> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "><a name="TOC2224" id="TOC2224"></a><span>Aliases</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Stores information about aliases in use. An alias represents the name displayed when the conversation took place. For instance, this could be a buddy alias, contact alias, server alias or a non-normalized screen name.</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 59pt; width: 467pt; word-wrap: break-word; " id="id5"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AliasID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies an Alias in the table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Alias</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">VARCHAR</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">An Alias as a string.</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Constraints</div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">UNIQUE(Alias)</span></div> +</li> +</ol> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "><a name="TOC2497" id="TOC2497"></a><span>Buddies</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Buddies stores data about the buddy. The ‘Name’ field MUST be processed with the gaim_normalize() function before being inserted into the database.</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 94pt; width: 467pt; word-wrap: break-word; " id="id6"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">BuddyID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the buddy.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AccountID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 33pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Uniquely identifies the Account in which the buddy is associated.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Name</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">VARCHAR</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the name of the buddy.</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Constraints</div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">UNIQUE(AccountID, Name)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (AccountID) REFERENCES Accounts (AccountID)</span></div> +</li> +</ol> +<div class="paragraph Heading_1" style="line-height: 20.8pt; margin-top: 1.6pt; "><a name="TOC2766" id="TOC2766"></a><span>Events</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Stores a list of system events. Names SHOULD be in lowercase.</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 59pt; width: 467pt; word-wrap: break-word; " id="id7"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">EventID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the Event in Events.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Name</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">VARCHAR</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Stores the name of the Event.</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_1" style="line-height: 20.8pt; "><a name="TOC2850" id="TOC2850"></a><span>MessageEvents</span></div> +<div class="paragraph Body" style="line-height: 14.3pt; ">Event types are defined here as they are implemented. Applications needing events not defined here MUST prefix them with "x-".</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Layout</div> +<div class="paragraph Body" style="line-height: 14.3pt; "><table cellspacing="0" cellpadding="0" style="background: transparent; border-collapse: collapse; height: 139pt; width: 467pt; word-wrap: break-word; " id="id8"><tr><th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Field Name</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Data Type</div> +</div> +</div> +</th> +<th style="background: #136993; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Free_Form" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; padding-bottom: 0pt; padding-top: 0pt; color: #ffffff; font-family: 'HelveticaNeue-Bold', 'Helvetica Neue', 'Arial', 'sans-serif'; font-weight: bold; line-height: 14.3pt;">Purpose</div> +</div> +</div> +</th> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">MessageEventID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER PRIMARY KEY</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the MessageEvent in MessageEvents.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">AccountID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER NULL</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the account in the “Accounts” table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">EventID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the event in the “Events” table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">BuddyID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER NULL</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the buddy in the “Buddies” table.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Timestamp</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">DATETIME</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Stores the time the event occurred.</div> +</div> +</div> +</td> +</tr> +<tr><td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">TimezoneID</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 116pt; "><div><div style="margin: 4pt; width: 115.9pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">INTEGER</div> +</div> +</div> +</td> +<td style="background: transparent; border: 1pt #7f7f7f solid; height: 18pt; width: 232pt; "><div><div style="margin: 4pt; width: 232.2pt; "><div class="paragraph Body" style="line-height: 14.3pt; padding-bottom: 0pt; padding-top: 0pt; ">Identifies the timezone when the event occurred.</div> +</div> +</div> +</td> +</tr> +</table> +</div> +<div class="paragraph Heading_3" style="line-height: 14.3pt; ">Table Constraints</div> +<ol><li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: -1.6pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: 0; line-height: 14.3pt; position: relative; text-decoration: none; text-transform: none; top: 1pt; " class="Bullet">•</span><span style="width: 4pt; " class="Spacer"></span><span style="line-height: 14.3pt; ">FOREIGN KEY (AccountID) REFERENCES Accounts (AccountID)</span></div> +</li> +<li style="line-height: 14.3pt; margin-left: 9pt; padding-left: 0pt; text-indent: -9pt; "><div class="paragraph Body" style="line-height: 14.3pt; margin-bottom: 0pt; margin-top: 0pt; text-indent: -9pt; "><span style="color: #000000; font-family: 'HelveticaNeue-Light', 'Helvetica Neue', 'Helvetica Neue Light', 'Arial', 'sans-serif'; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: norma... [truncated message content] |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X