Menu
▾
▴
tcdb-devel — Development Issues
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(4) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(16) |
Jun
(41) |
Jul
(101) |
Aug
(71) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jason C. <jas...@gm...> - 2006-05-25 01:07:46
|
Here's what sourceforge says: http://sourceforge.net/docs/E07#email The ability to send email from the project web servers has been stopped to curb past abuse that has occurred from the project web servers. However, we do realize that this is a valued and required feature for many projects hosted on SourceForge.net, so we have provided a method for a project to accomplish this task. At a high level, it would look like this: 1. The module of the project web service that requires the ability to send out mail would now be modified to queue the message to the project database. 2. A cron job <http://sourceforge.net/docs/E07#cron> would be configured to pull out and send the emails from the project shell server= . The project shell servers can be used to send email. This should help keep holes in project web sites from being abused by outside sources to send spam. The 'mail' command on the shell server can be used to send out mail, amongst other possible methods. We recommend that each project re-evaluate their need to send email first, before configuring this. We do not provide specific assistance in making this process work for projects, they are responsible for implementation level details at this point. Each user is limited to sending only 1000 emails per day from the shell server. This limit should allow for verification of account creation on forums, and other such items, but not full-blown email integrated forums, i= n most cases. The mailing list service should take care of this need. |
|
From: Jason C. <jas...@gm...> - 2006-05-25 00:58:09
|
Here's what sourceforge says: http://sourceforge.net/docs/E07#email The ability to send email from the project web servers has been stopped to curb past abuse that has occurred from the project web servers. However, we do realize that this is a valued and required feature for many projects hosted on SourceForge.net, so we have provided a method for a project to accomplish this task. At a high level, it would look like this: 1. The module of the project web service that requires the ability to send out mail would now be modified to queue the message to the project database. 2. A cron job <http://sourceforge.net/docs/E07#cron> would be configured to pull out and send the emails from the project shell server= . The project shell servers can be used to send email. This should help keep holes in project web sites from being abused by outside sources to send spam. The 'mail' command on the shell server can be used to send out mail, amongst other possible methods. We recommend that each project re-evaluate their need to send email first, before configuring this. We do not provide specific assistance in making this process work for projects, they are responsible for implementation level details at this point. Each user is limited to sending only 1000 emails per day from the shell server. This limit should allow for verification of account creation on forums, and other such items, but not full-blown email integrated forums, i= n most cases. The mailing list service should take care of this need. |
|
From: <m_h...@us...> - 2006-05-24 23:56:12
|
Revision: 2 Author: m_hildebrand Date: 2006-05-24 16:55:35 -0700 (Wed, 24 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=2&view=rev Log Message: ----------- Initial commit Added Paths: ----------- Design/ Design/Schema/ Design/Thumbs.db Design/UI/ Design/UI/My-Assignments.jpg Design/UI/Quest Swatches.aco Design/UI/TCDB Depreciated Controls.psd Design/UI/TCDB Design 2006.psd Design/UI/TCDB Design.psd Design/UI/Thumbs.db Design/UI/tcdb.css Design/UI/test.htm Directory.README.txt Graphics/ Graphics/ArrowDown.gif Graphics/ArrowUp.gif Graphics/Header-Background.gif Graphics/Thumbs.db Graphics/reddot.gif Graphics/spacer.gif WebPrototype/ WebPrototype/ActionItem.aspx WebPrototype/ActionItem.aspx.cs WebPrototype/Admin.aspx WebPrototype/Admin.aspx.cs WebPrototype/App_Themes/ WebPrototype/App_Themes/Python/ WebPrototype/App_Themes/Python/Images/ WebPrototype/App_Themes/Python/Images/Thumbs.db WebPrototype/App_Themes/Python/Images/background.gif WebPrototype/App_Themes/Python/Images/hrdot.gif WebPrototype/App_Themes/Python/python.css WebPrototype/App_Themes/Python/python.skin WebPrototype/Assignments.aspx WebPrototype/Assignments.aspx.cs WebPrototype/Bin/ WebPrototype/Bin/AtlasControlToolkit.dll WebPrototype/Bin/Microsoft.AtlasControlExtender.dll WebPrototype/Bin/Microsoft.Web.Atlas.dll WebPrototype/Default.aspx WebPrototype/Default.aspx.cs WebPrototype/Images/ WebPrototype/Images/Thumbs.db WebPrototype/Images/spacer.gif WebPrototype/MasterPage.master WebPrototype/MasterPage.master.cs WebPrototype/Notes.aspx WebPrototype/Notes.aspx.cs WebPrototype/Privacy.aspx WebPrototype/Privacy.aspx.cs WebPrototype/Settings.aspx WebPrototype/Settings.aspx.cs WebPrototype/Web.config WebPrototype/Web.sitemap Added: Design/Thumbs.db =================================================================== (Binary files differ) Property changes on: Design/Thumbs.db ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/My-Assignments.jpg =================================================================== (Binary files differ) Property changes on: Design/UI/My-Assignments.jpg ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/Quest Swatches.aco =================================================================== (Binary files differ) Property changes on: Design/UI/Quest Swatches.aco ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/TCDB Depreciated Controls.psd =================================================================== (Binary files differ) Property changes on: Design/UI/TCDB Depreciated Controls.psd ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/TCDB Design 2006.psd =================================================================== (Binary files differ) Property changes on: Design/UI/TCDB Design 2006.psd ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/TCDB Design.psd =================================================================== (Binary files differ) Property changes on: Design/UI/TCDB Design.psd ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/Thumbs.db =================================================================== (Binary files differ) Property changes on: Design/UI/Thumbs.db ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Design/UI/tcdb.css =================================================================== --- Design/UI/tcdb.css (rev 0) +++ Design/UI/tcdb.css 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,32 @@ +/**** Vintela Colors **** + Black: 231F20 + Blue: 1D2877 + Red: ED1B24 + Orange: F7921E + Yellow: FDB928 + White: FFFFF +**** /Vintela Colors ****/ + +/* Page defaults */ +body {font-family: Verdana, Helvetica, Arial, sans-serif; font-size: 10px font-color: #231F20;} +.largeText {font-size:12px;} +/* Heading style */ +H1 {font-size:12px; color: 1D2877;} + +/* Default page links */ +a {font-size: 11px; color: #F7921E;} + +/* Currently open link on same page */ +a.loaded {font-size: 11px; color: #1D2877;} + +/* Links that open popup windows */ +a.popup {font-size: 11px; color: #231F20;} + +/* White text on blue BG; header and footer */ +.inverse {color: #FFFFFF; font-size: 10px;} + +/* Username in the header */ +.username {color: #F7921E; font-size: 10px;} + +/* Radio controls */ +input.radio {margin: 0px; padding: 0px; height: 8px; width: 8px;} \ No newline at end of file Added: Design/UI/test.htm =================================================================== --- Design/UI/test.htm (rev 0) +++ Design/UI/test.htm 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,35 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> +<title>Untitled Document</title> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> +<link href="tcdb.css" rel="stylesheet" type="text/css"> +</head> + +<body> +<p>body text<br> + <br> + <a href="somewhere" class="loaded">loaded</a> + <a href="here">link</a> + <a href="there" class="popup">popup</a><br> +</p> +<p><br> +</p> +<form name="form1" method="post" action=""> + <p> + <input type="radio" name="All" value="n" class="radio"> + <input type="radio" name="All" value="p" class="radio"> + <input type="radio" name="All" value="f" class="radio"> + <input type="radio" name="All" value="c" class="radio"> + <input type="radio" name="All" value="w" class="radio"> + </p> +</form> +<p> </p> +<h1>Heading</h1> +<table bgcolor="1D2877"> +<tr><td> +<span class="inverse">Welcome</span> <span class="username">Matthew Hildebrand</span> <span class="inverse">| </span><a href="settings" class="inverse">Settings</a> +</td></tr> +</table> +</body> +</html> Added: Directory.README.txt =================================================================== --- Directory.README.txt (rev 0) +++ Directory.README.txt 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,11 @@ +Design Contains all of the planning/design documents + |---UI Designs and screen comps for the UI + \---Schema Table layout for database schema +Graphics Any graphics that are global across the project +Schema Contains the database schema +WebPrototype Web application prototype root + |---App_Themes Application themes + | \---Python Python theme + | \---Images + |---Bin Required components to build + \---Images Generic non-theme images Added: Graphics/ArrowDown.gif =================================================================== (Binary files differ) Property changes on: Graphics/ArrowDown.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/ArrowUp.gif =================================================================== (Binary files differ) Property changes on: Graphics/ArrowUp.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/Header-Background.gif =================================================================== (Binary files differ) Property changes on: Graphics/Header-Background.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/Thumbs.db =================================================================== (Binary files differ) Property changes on: Graphics/Thumbs.db ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/reddot.gif =================================================================== (Binary files differ) Property changes on: Graphics/reddot.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: Graphics/spacer.gif =================================================================== (Binary files differ) Property changes on: Graphics/spacer.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/ActionItem.aspx =================================================================== --- WebPrototype/ActionItem.aspx (rev 0) +++ WebPrototype/ActionItem.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,166 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + CodeFile="ActionItem.aspx.cs" Inherits="ActionItem" Title="Untitled Page" %> + +<%@ Register Assembly="AtlasControlToolkit" Namespace="AtlasControlToolkit" TagPrefix="cc1" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td width="*" valign="top"> + <div id="ActionItem"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left" valign="bottom"> + <h2> + Action Item</h2> + </td> + <td align="right" valign="bottom" style="padding-right: 20px;"> + <a href="#">Active</a> | + <asp:RadioButtonList ID="rdoAmountDone" runat="server" SkinID="rdoAmountDone"> + <asp:ListItem Selected="true" Text="0%" Value="0">0%</asp:ListItem> + <asp:ListItem Selected="true" Text="25%" Value="25">25%</asp:ListItem> + <asp:ListItem Selected="true" Text="50%" Value="50">50%</asp:ListItem> + <asp:ListItem Selected="true" Text="75%" Value="75">75%</asp:ListItem> + <asp:ListItem Selected="true" Text="100%" Value="100">100%</asp:ListItem> + </asp:RadioButtonList> + </td> + </tr> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table cellpadding="0" cellspacing="0" border="0" width="100%"> + <tr> + <td align="left"> + <h3> + Setup Personal Environment</h3> + </td> + <td align="right"> + 23 Dec 2006</td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <div id="ActionItemData"> + Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer fermentum laoreet + nunc. Maecenas consectetuer metus a justo. Donec semper. Proin tempor mauris non + arcu. Mauris nonummy convallis sapien. Aliquam erat volutpat. Ut eget ante a turpis + volutpat lobortis. Morbi accumsan justo eu massa. Nullam diam. Cras venenatis bibendum + diam. Suspendisse a erat tristique nunc consectetuer ultrices. + </div> + <table cellpadding="0" cellspacing="0" border="0" width="100%" style="padding-top: 10px;"> + <tr> + <td align="left"> + <a href="#">Edit</a> | <a href="#">Delete</a></td> + <td align="right"> + Jason Corbett</td> + </tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </div> + </td> + <td width="300px" align="right"> + <!--<iframe src="Notes.aspx" frameborder="0" width="100%" height="100%" scrolling="auto"></iframe>--> + <atlas:ScriptManager ID="ScriptManager1" runat="server" /> + <table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td width="100%"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <asp:Panel ID="Panel2" runat="server" CssClass="collapsePanelHeader"> + <td align="left" valign="bottom"> + <h4> + Don't Forget!:</h4> + 12 May 2006 + </td> + <td align="right" valign="bottom"> + <asp:Image ID="Image1" runat="server" ImageUrl="images/ArrowUp.gif" /> + <!--<asp:Image ID="Image2" runat="server" ImageUrl="images/ArrowDown.gif" />--> + <a href="#" class="notedelete">x</a></td> + </asp:Panel> + </tr> + + </table> + <asp:Panel ID="Panel1" runat="server" Height="0"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer fermentum laoreet + nunc. Maecenas consectetuer metus a justo. Donec semper. Proin tempor mauris non + arcu. Mauris nonummy convallis sapien. Aliquam erat volutpat. Ut eget ante a turpis + volutpat lobortis. Morbi accumsan justo eu massa. Nullam diam. Cras venenatis bibendum + diam. Suspendisse a erat tristique nunc consectetuer ultrices. + </asp:Panel> + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b></b> + </td></tr> + </table> + <cc1:CollapsiblePanelExtender ID="CollapsiblePanelExtender1" runat="server"> + <cc1:CollapsiblePanelProperties Collapsed="true" SuppressPostBack="true" CollapseControlID="Image1" + ExpandControlID="Image1" ExpandedImage="images/ArrowUp.gif" CollapsedImage="images/ArrowUp.gif" + TargetControlID="Panel1" AutoCollapse="false" AutoExpand="false" CollapsedSize="0" + ImageControlID="Image1" /> + </cc1:CollapsiblePanelExtender> + <!-- + + + </asp:Panel> + --> + <div class="note"> + <div id="note1"> + </div> + <div id="note2"> + <b class="noteb1"></b> + <br /> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b> + <b class="noteb4"></b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h4> + Reminder:</h4> + 01 Apr 2006 + </td> + <td align="right" valign="bottom"> + <a href="#" class="notedelete">x</a></td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa + luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin + nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. + Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque + habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. + Suspendisse blandit. + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"> + </b><b class="noteb1"></b></b> + </div> + <br /> + <a href="#" style="padding-left: 10px; text-align: right;">New Note</a> + </div> + </td> + </tr> + </table> +</asp:Content> Added: WebPrototype/ActionItem.aspx.cs =================================================================== --- WebPrototype/ActionItem.aspx.cs (rev 0) +++ WebPrototype/ActionItem.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class ActionItem : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Admin.aspx =================================================================== --- WebPrototype/Admin.aspx (rev 0) +++ WebPrototype/Admin.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,4 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Admin.aspx.cs" Inherits="Admin" Title="TCDB: Admin" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> +</asp:Content> + Added: WebPrototype/Admin.aspx.cs =================================================================== --- WebPrototype/Admin.aspx.cs (rev 0) +++ WebPrototype/Admin.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Admin : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/App_Themes/Python/Images/Thumbs.db =================================================================== (Binary files differ) Property changes on: WebPrototype/App_Themes/Python/Images/Thumbs.db ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/App_Themes/Python/Images/background.gif =================================================================== (Binary files differ) Property changes on: WebPrototype/App_Themes/Python/Images/background.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/App_Themes/Python/Images/hrdot.gif =================================================================== (Binary files differ) Property changes on: WebPrototype/App_Themes/Python/Images/hrdot.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/App_Themes/Python/python.css =================================================================== --- WebPrototype/App_Themes/Python/python.css (rev 0) +++ WebPrototype/App_Themes/Python/python.css 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,170 @@ +.master +{ + background-image: url(images/background.gif); + background-repeat: repeat-x; + margin: 0; + padding: 0; + font-family: Verdana, Sans-Serif; + font-size: 10pt; +} +H2, H3, H4 +{ + display: inline; +} + +#header +{ + background-image: url(images/background.gif); + background-repeat: repeat-x; + +} +.logo +{ + border: none; + padding-top: 7px; + padding-left: 10px; +} +TD.hr +{ + background-image: url(images/hrdot.gif); + background-repeat: repeat-x; + height: 1px; + margin: 4px 0px 2px 0px; + padding: 4px 0px 2px 0px; + background-position: center 4px; +} +#header TD +{ + color: white; +} +.username +{ + color: #FDB928; + display: inline; +} +#header A +{ + color: White; +} +#header A:hover, #header A:active +{ + color: #FDB928; +} +#footer A +{ + color: White; +} +#footer A:hover, #footer A:active +{ + color: #FDB928; +} +#content +{ + padding-left: 10px; +} + +html +{ + height: 100%; +} + +body +{ + height: 100%; +} + +#nonFooter +{ + position: relative; + min-height: 100%; +} + +* html #nonFooter +{ + height: 100%; +} + +#footer +{ + background-color: #022e66; + color: white; + padding-bottom: 4px; + vertical-align: middle; + padding-top: 4px; + text-align: center; + + position: relative; + margin: -1.8em auto 0 auto; +} + +#MyAssignmentsData TD +{ + text-align: center; +} + +/* A CSS hack that only applies to IE -- specifies a different height for the footer */ + +* html #footer +{ + margin-top: -1.8em; +} + +/* Snazzy borders by Stu Nicholls (http://www.cssplay.co.uk/boxes/snazzy.html) */ +/*#xsnazzy h1, #xsnazzy h2, #xsnazzy p, #xsnazzy2 h1, #xsnazzy2 h2, #xsnazzy2 p, #xsnazzy3 h1, #xsnazzy3 h2, #xsnazzy3 p {margin:0 10px; letter-spacing:1px;} +#xsnazzy h1, #xsnazzy2 h1, #xsnazzy3 h1 {font-size:2.5em; color:#fff;} +#xsnazzy h2, #xsnazzy2 h2, #xsnazzy3 h2 {font-size:2em;color:#06a; border:0;} +#xsnazzy p, #xsnazzy2 p, #xsnazzy3 p {padding-bottom:0.5em;} +#xsnazzy h2, #xsnazzy2 h2, #xsnazzy3 h2 {padding-top:0.5em;} +#xsnazzy, #xsnazzy2, #xsnazzy3 {background: transparent; margin: .5em 1em;/*margin:1em;}*/ + +.xsnazzy h1, .xsnazzy h2, .xsnazzy p {margin:0 10px; letter-spacing:1px;} +.xsnazzy h1 {font-size:2.5em; color:#fff;} +.xsnazzy h2 {font-size:2em;color:#06a; border:0;} +.xsnazzy p {padding-bottom:0.5em;} +.xsnazzy h2 {padding-top:0.5em;} +.xsnazzy {background: transparent; margin: .5em 1em;/*margin:1em;*/} + +.xtop, .xbottom {display:block; background:transparent; font-size:1px;} +.xb1, .xb2, .xb3, .xb4 {display:block; overflow:hidden;} +.xb1, .xb2, .xb3 {height:1px;} +.xb2, .xb3, .xb4 {background:#d4d4d4; border-left:1px solid #08c; border-right:1px solid #08c;} +.xb1 {margin:0 5px; background:#08c;} +.xb2 {margin:0 3px; border-width:0 2px;} +.xb3 {margin:0 2px;} +.xb4 {height:2px; margin:0 1px;} + +.xboxcontent {display:block; background:#d4d4d4; border:0 solid #08c; border-width:0 1px; padding: 0px 5px 0px 5px;} + + + +.note h1, .note h2, .note p {margin:0 10px; letter-spacing:1px;} +.note h1 {font-size:2.5em; color:#fff;} +.note h2 {font-size:2em;color:#06a; border:0;} +.note p {padding-bottom:0.5em;} +.note h2 {padding-top:0.5em;} +.note {background: transparent; margin: .5em 1em;/*margin:1em;*/} + +.notetop, .notebottom {display:block; background:transparent; font-size:1px;} +.noteb1, .noteb2, .noteb3, .noteb4 {display:block; overflow:hidden;} +.noteb1, .noteb2, .noteb3 {height:1px;} +.noteb2, .noteb3, .noteb4 {background:#ff9; border-left:1px solid #08c; border-right:1px solid #08c;} +.noteb1 {margin:0 5px; background:#08c;} +.noteb2 {margin:0 3px; border-width:0 2px;} +.noteb3 {margin:0 2px;} +.noteb4 {height:2px; margin:0 1px;} + +.noteboxcontent {display:block; background:#ff9; border:0 solid #08c; border-width:0 1px; padding: 0px 5px 0px 5px; text-align: left;} + +.notedelete +{ + text-decoration: none; + margin-top: -2px; + padding: 0px 2px 0px 2px; + font-variant: small-caps; +} + +.fullheight { + height:100%; + padding: 0px; + margin: 0px; +} \ No newline at end of file Added: WebPrototype/App_Themes/Python/python.skin =================================================================== --- WebPrototype/App_Themes/Python/python.skin (rev 0) +++ WebPrototype/App_Themes/Python/python.skin 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,16 @@ +<%-- +Default skin template. The following skins are provided as examples only. + +1. Named control skin. The SkinId should be uniquely defined because + duplicate SkinId's per control type are not allowed in the same theme. + +<asp:GridView runat="server" SkinId="gridviewSkin" BackColor="White" > + <AlternatingRowStyle BackColor="Blue" /> +</asp:GridView> + +2. Default skin. The SkinId is not defined. Only one default + control skin per control type is allowed in the same theme. + +<asp:Image runat="server" ImageUrl="~/images/image1.jpg" /> +--%> + Added: WebPrototype/Assignments.aspx =================================================================== --- WebPrototype/Assignments.aspx (rev 0) +++ WebPrototype/Assignments.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,218 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" + CodeFile="Assignments.aspx.cs" Inherits="Assignments" Title="TCDB: Assignments" %> + +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" runat="Server"> + <br /> + <div id="MyAssignments"> + <table cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h2> + My Assignments</h2> + </td> + <td align="right" valign="bottom" style="padding-right: 20px;"> + <asp:CheckBox ID="cboShowCompleted" runat="server" Text="Show Completed" TextAlign="Left" /></td> + </tr> + <tr> + <td colspan="2"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <div id="MyAssignmentsData"> + <table> + <tr> + <td style="text-align: left; width: 60px;"> + <a href="#">Date</a></td> + <td style="text-align: left; width: 50px;"> + <a href="#">Type</a></td> + <td style="text-align: left; width: 200px;"> + <a href="#">Assignment</a></td> + <td style="text-align: left; width: 85px;"> + <a href="#">Status</a></td> + <td> + <a href="#">% Complete</a></td> + <td> + <a href="#">Total</a></td> + <td> + <a href="#">Run</a></td> + <td> + <a href="#">Pass Rate</a></td> + <td> + <a href="#">Pass</a></td> + <td> + <a href="#">Fail</a></td> + <td> + <a href="#">Error</a></td> + </tr> + <tr> + <td style="text-align: left;"> + 23 Dec</td> + <td style="text-align: left;"> + AI</td> + <td style="text-align: left;"> + <a href="ActionItem.aspx">Setup Personal Environment</a></td> + <td style="text-align: left;"> + Started</td> + <td> + 25%</td> + <td> + </td> + <td> + </td> + <td> + </td> + <td> + </td> + <td> + </td> + <td> + </td> + </tr> + <tr> + <td style="text-align: left;"> + 18 Jan</td> + <td style="text-align: left;"> + WO</td> + <td style="text-align: left;"> + <a href="WorkOrder.aspx">1847 on REAS 3.0</a></td> + <td style="text-align: left;"> + Not Started</td> + <td> + 50%</td> + <td> + 8</td> + <td> + 4</td> + <td> + 25%</td> + <td> + 1</td> + <td> + 2</td> + <td> + 1</td> + </tr> + </table> + </div> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </div> + <br /> + <div id="Filters"> + <table cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom" colspan="3"> + <h3> + Filters</h3> + </td> + </tr> + <tr> + <td valign="top"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h4> + Date</h4> + </td> + <td align="right" valign="bottom"> + <asp:CheckBox ID="cboDateFilter" runat="server" TextAlign="Left" /></td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + <tr> + <td>From:</td><td><asp:DropDownList ID="startMonth" runat="server"> + <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="startDay" runat="server"> + <asp:ListItem Selected="True" Text="1">01</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="startYear" runat="server"> + <asp:ListItem Selected="True" Text="2006">2006</asp:ListItem> + </asp:DropDownList></td></tr> + <tr><td>To:</td><td><asp:DropDownList ID="stopMonth" runat="server"> + <asp:ListItem Selected="True" Text="Jan">Jan</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="stopDay" runat="server"> + <asp:ListItem Selected="True" Text="1">01</asp:ListItem> + </asp:DropDownList> + <asp:DropDownList ID="stopYear" runat="server"> + <asp:ListItem Selected="True" Text="2007">2007</asp:ListItem> + </asp:DropDownList></td></tr> + </table> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + <td valign="top"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h4> + Type</h4> + </td> + <td align="right" valign="bottom"> + <asp:CheckBox ID="cboTypeFilter" runat="server" TextAlign="Left" /></td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <asp:CheckBox ID="cboShowActionItems" runat="server" Text="Action Items" Checked="true" /><br /> + <asp:CheckBox ID="cboShowWorkOrders" runat="server" Text="Work Orders" Checked="true" /> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + <td valign="top"> + <div class="xsnazzy"> + <b class="xtop"><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"> + </b></b> + <div class="xboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h4> + Status</h4> + </td> + <td align="right" valign="bottom"> + <asp:CheckBox ID="cboStatusFilter" runat="server" TextAlign="Left" /></td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + <asp:CheckBox ID="cboFilterStarted" runat="server" Text="Started" Checked="true" /><br /> + <asp:CheckBox ID="cboFilterNotStarted" runat="server" Text="Not Started" Checked="true" /><br /> + <asp:CheckBox ID="cboFilterCompleted" runat="server" Text="Completed" Checked="false" /> + </div> + <b class="xbottom"><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"> + </b></b> + </div> + </td> + </tr> + </table> + </div> +</asp:Content> Added: WebPrototype/Assignments.aspx.cs =================================================================== --- WebPrototype/Assignments.aspx.cs (rev 0) +++ WebPrototype/Assignments.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Assignments : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Bin/AtlasControlToolkit.dll =================================================================== (Binary files differ) Property changes on: WebPrototype/Bin/AtlasControlToolkit.dll ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/Bin/Microsoft.AtlasControlExtender.dll =================================================================== (Binary files differ) Property changes on: WebPrototype/Bin/Microsoft.AtlasControlExtender.dll ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/Bin/Microsoft.Web.Atlas.dll =================================================================== (Binary files differ) Property changes on: WebPrototype/Bin/Microsoft.Web.Atlas.dll ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/Default.aspx =================================================================== --- WebPrototype/Default.aspx (rev 0) +++ WebPrototype/Default.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,5 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Assignments" Title="TCDB: Home" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> + +</asp:Content> + Added: WebPrototype/Default.aspx.cs =================================================================== --- WebPrototype/Default.aspx.cs (rev 0) +++ WebPrototype/Default.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Assignments : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Images/Thumbs.db =================================================================== (Binary files differ) Property changes on: WebPrototype/Images/Thumbs.db ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/Images/spacer.gif =================================================================== (Binary files differ) Property changes on: WebPrototype/Images/spacer.gif ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: WebPrototype/MasterPage.master =================================================================== --- WebPrototype/MasterPage.master (rev 0) +++ WebPrototype/MasterPage.master 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,69 @@ +<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %> +<!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 runat="server"> + <title>TCDB</title> +</head> +<body class="master"> + <div id="nonFooter"> + <div id="header"> + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td align="left" valign="top"> + <a href="Default.aspx"><img src="images/logo.gif" alt="Logo" class="logo" style="padding-top: 7px; padding-left: 10px" /></a></td> + <td align="right" style="padding-right: 10px" width="500" valign="middle"> + <table border="0" cellpadding="0" cellspacing="0" width="100%"> + <tr> + <td colspan="2" align="right"> + Welcome + <div class="username"> + <asp:Label ID="lblWelcome" runat="server"></asp:Label></div> + | + <asp:LoginView ID="MenuLoginView" runat="server"> + <AnonymousTemplate> + <a href="Register.aspx" class="header">Register</a> | <a href="Login.aspx" class="header"> + Login</a></AnonymousTemplate> + <LoggedInTemplate> + <a href="Settings.aspx" class="header">Settings</a> | <a href="Admin.aspx" class="header"> + Admin</a> | <a href="Logout.aspx" class="header">Logout</a></LoggedInTemplate> + </asp:LoginView> + </td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="1" /><br /> + </td> + </tr> + <tr> + <td align="left"> + VSM | 1.1 | Alpha | 134</td> + <td align="right"> + <a href="Assignments.aspx" class="header">Assignments</a> | <a href="Execution.aspx" + class="header">Execution</a> | <a href="Management.aspx" class="header">Test Management</a></td> + </tr> + </table> + </td> + </tr> + </table> + </div> + <br /> + <div id="content" class="fullheight"> + <form id="form1" runat="server"> + <asp:SiteMapPath ID="SiteMapPath1" runat="server"> + <PathSeparatorTemplate> + > + </PathSeparatorTemplate> + </asp:SiteMapPath> + <br /> + <div> + <asp:ContentPlaceHolder ID="PageContent" runat="server"> + </asp:ContentPlaceHolder> + </div> + </form> + </div> + </div> + <div id="footer"> + \xA9 2006 <a href="http://www.quest.com">Quest Software, Inc.</a> | <a href="Privacy.aspx"> + Privacy Policy</a> | <a href="SiteMap.aspx">Site Map</a></div> +</body> +</html> Added: WebPrototype/MasterPage.master.cs =================================================================== --- WebPrototype/MasterPage.master.cs (rev 0) +++ WebPrototype/MasterPage.master.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,21 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class MasterPage : System.Web.UI.MasterPage +{ + protected void Page_Load(object sender, EventArgs e) + { + if (!Page.IsPostBack) + { + lblWelcome.Text = Profile.FirstName + " " + Profile.LastName; + } + } +} Added: WebPrototype/Notes.aspx =================================================================== --- WebPrototype/Notes.aspx (rev 0) +++ WebPrototype/Notes.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,36 @@ +<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Notes.aspx.cs" Inherits="Notes" %> + +<!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 runat="server"> + <title>Notes</title> +</head> +<body style="height: 100%"> + <form id="form1" runat="server"> + <div class="note"> + <b class="notetop"><b class="noteb1"></b><b class="noteb2"></b><b class="noteb3"></b><b class="noteb4"> + </b></b> + <div class="noteboxcontent"> + <table width="100%" cellpadding="0" cellspacing="0" border="0"> + <tr> + <td align="left" valign="bottom"> + <h4> + Note</h4> + </td> + <td align="right" valign="bottom"> + <a href="Notes.aspx" class="notedelete">x</a></td> + </tr> + <tr> + <td colspan="2" class="hr"> + <img alt="" src="images/spacer.gif" height="5" /><br /> + </td> + </tr> + </table> + Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer fermentum laoreet nunc. Maecenas consectetuer metus a justo. Donec semper. Proin tempor mauris non arcu. Mauris nonummy convallis sapien. Aliquam erat volutpat. Ut eget ante a turpis volutpat lobortis. Morbi accumsan justo eu massa. Nullam diam. Cras venenatis bibendum diam. Suspendisse a erat tristique nunc consectetuer ultrices. Integer lacus elit, consectetuer nec, rutrum at, pretium ac, risus. Sed semper massa luctus mi. Donec placerat, diam vitae ultricies posuere, felis dui sollicitudin nibh, eget blandit purus libero in elit. Aenean eget lectus eget ipsum rutrum scelerisque. Nunc orci mauris, rhoncus ac, pellentesque sit amet, condimentum vel, nibh. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Suspendisse blandit. + </div> + <b class="notebottom"><b class="noteb4"></b><b class="noteb3"></b><b class="noteb2"></b><b class="noteb1"> + </b></b> + </div> + </form> +</body> +</html> Added: WebPrototype/Notes.aspx.cs =================================================================== --- WebPrototype/Notes.aspx.cs (rev 0) +++ WebPrototype/Notes.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Notes : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Privacy.aspx =================================================================== --- WebPrototype/Privacy.aspx (rev 0) +++ WebPrototype/Privacy.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,4 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Privacy.aspx.cs" Inherits="Privacy" Title="TCDB: Privacy Policy" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> +</asp:Content> + Added: WebPrototype/Privacy.aspx.cs =================================================================== --- WebPrototype/Privacy.aspx.cs (rev 0) +++ WebPrototype/Privacy.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Privacy : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Settings.aspx =================================================================== --- WebPrototype/Settings.aspx (rev 0) +++ WebPrototype/Settings.aspx 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,4 @@ +<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Settings.aspx.cs" Inherits="Settings" Title="TCDB: Settings" %> +<asp:Content ID="Content1" ContentPlaceHolderID="PageContent" Runat="Server"> +</asp:Content> + Added: WebPrototype/Settings.aspx.cs =================================================================== --- WebPrototype/Settings.aspx.cs (rev 0) +++ WebPrototype/Settings.aspx.cs 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,18 @@ +using System; +using System.Data; +using System.Configuration; +using System.Collections; +using System.Web; +using System.Web.Security; +using System.Web.UI; +using System.Web.UI.WebControls; +using System.Web.UI.WebControls.WebParts; +using System.Web.UI.HtmlControls; + +public partial class Settings : System.Web.UI.Page +{ + protected void Page_Load(object sender, EventArgs e) + { + + } +} Added: WebPrototype/Web.config =================================================================== --- WebPrototype/Web.config (rev 0) +++ WebPrototype/Web.config 2006-05-24 23:55:35 UTC (rev 2) @@ -0,0 +1,143 @@ +<?xml version="1.0"?> +<!-- + Note: As an alternative to hand editing this file you can use the + web admin tool to configure settings for your application. Use + the Website->Asp.Net Configuration option in Visual Studio. + A full list of settings and comments can be found in + machine.config.comments usually located in + \Windows\Microsoft.Net\Framework\v2.x\Config +--> +<configuration> + <!-- + The configSections define a section for ASP.NET Atlas. + --> + <configSections> + <sectionGroup name="microsoft.web" type="Microsoft.Web.Configuration.MicrosoftWebSectionGroup"> + <section name="converters" type="Microsoft.Web.Configuration.ConvertersSection" requirePermission="false"/> + <section name="webServices" type="Microsoft.Web.Configuration.WebServicesSection" requirePermission="false"/> + <section name="authenticationService" type="Microsoft.Web.Configuration.AuthenticationServiceSection" requirePermission="false"/> + <section name="profileService" type="Microsoft.Web.Configuration.ProfileServiceSection" requirePermission="false"/> + </sectionGroup> + </configSections> + <!-- + The microsoft.web section defines items required for the Atlas framework. + --> + <microsoft.web> + <converters> + <add type="Microsoft.Web.Script.Serialization.Converters.DataSetConverter"/> + <add type="Microsoft.Web.Script.Serialization.Converters.DataRowConverter"/> + <add type="Microsoft.Web.Script.Serialization.Converters.DataTableConverter"/> + </converters> + <webServices enableBrowserAccess="true"/> + <!-- + Uncomment this line to enable the authentication service. + <authenticationService enabled="true" /> + --> + <!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved + and modified in Atlas applications, you need to add each property name to the setProperties and + getProperties attributes. If you intend for all properties to be available, you can use "*" + as a shorthand rather than enumerating each property --> + <!-- + <profileService enabled="true" + setProperties="propertyname1;propertyname2" + getProperties="propertyname1;propertyname2" /> + --> + </microsoft.web> + <appSettings/> + <connectionStrings/> + <system.web> + <pages theme="Python" styleSheetTheme="Python"> + <controls> + <add namespace="Microsoft.Web.UI" assembly="Microsoft.Web.Atlas" tagPrefix="atlas"/> + <add namespace="Microsoft.Web.UI.Controls" assembly="Microsoft.Web.Atlas" tagPrefix="atlas"/> + </controls> + </pages> + <roleManager enabled="true" cacheRolesInCookie="true" cookieProtection="All"> + </roleManager> + <anonymousIdentification enabled="true"/> + <profile enabled="true"> + <properties> + <add name="UserName" defaultValue="Guest" allowAnonymous="false"/> + <add name="FirstName" defaultValue="Guest"/> + <add name="LastName" defaultValue=""/> + </properties> + </profile> + <!-- + Set compilation debug="true" to insert debugging + symbols into the compiled page. Because this + affects performance, set this value to true only + during development. + --> + <compilation debug="true"> + <assemblies> + <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> + </assemblies> + <buildProviders> + <add extension=".asbx" type="Microsoft.Web.Services.BridgeBuildProvider"/> + </buildProviders> + </compilation> + <!-- + ASMX is mapped to a new handler so that proxy javascripts can also be served. + --> + <httpHandlers> + <remove verb="*" path="*.asmx"/> + <add verb="*" path="*.asmx" type="Microsoft.Web.Services.ScriptHandlerFactory" validate="false"/> + <!-- + The MultiRequestHandler enables multiple requests to be handled in one + roundtrip to the server. Its use requires Full Trust. + --> + <add verb="*" path="atlasbatchcall.axd" type="Microsoft.Web.Services.MultiRequestHandler" validate="false"/> + <add verb="*" path="atlasglob.axd" type="Microsoft.Web.Globalization.GlobalizationHandler" validate="false"/> + <!-- + The IFrameHandler enables a limited form of cross-domain calls to 'Atlas' web services. + This should only be enabled if you need this functionality and you're willing to expose + the data publicly on the Internet. + To use it, you will also need to add the attribute [WebOperation(true, ResponseFormatMode.Json, true)] + on the methods that you want to be called cross-domain. + This attribute is by default on any DataService's GetData method. + + <add verb="*" path="iframecall.axd" type="Microsoft.Web.Services.IFrameHandler" validate="false"/> + --> + <add verb="*" path="*.asbx" type="Microsoft.Web.Services.ScriptHandlerFactory" validate="false"/> + </httpHandlers> + <httpModules> + <add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/> + <add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/> + <add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/> + </httpModules> + <!-- + The <authentication> section enables configuration + of the security authentication mode used by + ASP.NET to identify an incoming user. + + <authentication mode="Windows"/> + --> + <!-- + The <customErrors> section enables configuration + of what to do if/when an unhandled error occurs + during the execution of a request. Specifically, + it enables developers to configure html error pages + to be displayed in place of a error stack trace. + + <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> + <error statusCode="403" redirect="NoAccess.htm"/> + <error statusCode="404" redirect="FileNotFound.htm"/> + </customErrors> + --> + </system.web> + <!-- Uncomment this if your site globally denies access to anonymous users. The + authentication service and profile service are located under the virtual + "ScriptServices" directory. Since you normally call the authentication web + service with an un-authenticated user, the following location tag can be used + to grant access to anonymous users.... [truncated message content] |
|
From: <jon...@us...> - 2006-05-24 23:37:52
|
Revision: 1 Author: jon_r_johnson Date: 2006-05-24 16:37:47 -0700 (Wed, 24 May 2006) ViewCVS: http://svn.sourceforge.net/tcdb/?rev=1&view=rev Log Message: ----------- Added Paths: ----------- Schema/ Schema/TCDBSQLServer2005.sql Added: Schema/TCDBSQLServer2005.sql =================================================================== --- Schema/TCDBSQLServer2005.sql (rev 0) +++ Schema/TCDBSQLServer2005.sql 2006-05-24 23:37:47 UTC (rev 1) @@ -0,0 +1,690 @@ +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_user]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_user]( + [userID] [int] IDENTITY(1,1) NOT NULL, + [email] [varchar](50) NULL, + [officePhone] [varchar](14) NULL, + [homePhone] [varchar](14) NULL, + [cellPhone] [varchar](14) NULL, + [firstName] [varchar](24) NULL, + [lastName] [varchar](24) NULL, + [automation] [bit] NULL, + CONSTRAINT [PK_tcdb_user] PRIMARY KEY CLUSTERED +( + [userID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_userRights]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_userRights]( + [userRightsID] [int] IDENTITY(1,1) NOT NULL, + [userID] [int] NULL, + [rightsID] [int] NULL, + [dateCreated] [datetime] NULL, + [grantedBy] [int] NULL, + CONSTRAINT [PK_tcdb_userRights] PRIMARY KEY CLUSTERED +( + [userRightsID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_featureVersion]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_featureVersion]( + [featureVersionID] [int] IDENTITY(1,1) NOT NULL, + [featureID] [int] NULL, + [versionID] [int] NULL, + CONSTRAINT [PK_tcdb_featureVersion] PRIMARY KEY CLUSTERED +( + [featureVersionID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_platform]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_platform]( + [platformID] [int] IDENTITY(1,1) NOT NULL, + [architectureID] [int] NULL, + [osID] [int] NULL, + CONSTRAINT [PK_tcdb_platform] PRIMARY KEY CLUSTERED +( + [platformID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCaseTags]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_testCaseTags]( + [testcaseTagsID] [int] IDENTITY(1,1) NOT NULL, + [testcaseID] [int] NULL, + [tagID] [int] NULL, + CONSTRAINT [PK_tcdb_testcasetags] PRIMARY KEY CLUSTERED +( + [testcaseTagsID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrderTestCase]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_workOrderTestCase]( + [workOrderTestCaseID] [int] IDENTITY(1,1) NOT NULL, + [workOrderID] [int] NULL, + [testCaseID] [int] NULL, + CONSTRAINT [PK_tcdb_workOrderTestCase] PRIMARY KEY CLUSTERED +( + [workOrderTestCaseID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrderTestCase]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_savedWorkOrderTestCase]( + [savedWOTestCaseID] [int] IDENTITY(1,1) NOT NULL, + [savedWorkOrderID] [int] NULL, + [testCaseID] [int] NULL, + CONSTRAINT [PK_tcdb_savedWorkOrderTestCase] PRIMARY KEY CLUSTERED +( + [savedWOTestCaseID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignment]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_assignment]( + [assignmentID] [int] IDENTITY(1,1) NOT NULL, + [creatorID] [int] NULL, + [assignedID] [int] NULL, + [dateAssigned] [datetime] NULL, + [dateFinished] [datetime] NULL, + [assignmentStatusID] [int] NULL, + [workOrderID] [int] NULL, + [actionItemID] [int] NULL, + CONSTRAINT [PK_tcdb_assignment] PRIMARY KEY CLUSTERED +( + [assignmentID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_actionItem]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_actionItem]( + [actionItemID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + [creatorID] [int] NULL, + [dateCreated] [datetime] NULL, + [percentComplete] [int] NULL, + CONSTRAINT [PK_tcdb_actionItem] PRIMARY KEY CLUSTERED +( + [actionItemID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testPass]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_testPass]( + [testPassID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [versionID] [int] NULL, + CONSTRAINT [PK_tcdb_testPass] PRIMARY KEY CLUSTERED +( + [testPassID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_result]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_result]( + [resultID] [bigint] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [statusEnum] [int] NULL, + CONSTRAINT [PK_tcdb_result] PRIMARY KEY CLUSTERED +( + [resultID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_results]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_results]( + [resultsID] [bigint] IDENTITY(1,1) NOT NULL, + [testCaseID] [int] NULL, + [platformID] [int] NULL, + [dateStarted] [datetime] NULL, + [dateFinished] [datetime] NULL, + [assignedID] [int] NULL, + [testPassID] [int] NULL, + [resultID] [bigint] NULL, + [buildID] [int] NULL, + [workOrderID] [int] NULL +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_logs]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_logs]( + [logID] [bigint] NULL, + [resultID] [bigint] NULL, + [name] [varchar](255) NULL, + [dataLocation] [text] NULL +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_state]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_state]( + [stateID] [int] IDENTITY(1,1) NOT NULL, + [currentDomain] [varchar](15) NULL, + [vasClnt] [varchar](16) NULL, + [vasClnts] [varchar](16) NULL, + [vasDev] [varchar](16) NULL, + [vasDevi] [varchar](16) NULL, + [vasGps] [varchar](16) NULL, + [vasProxy] [varchar](16) NULL, + [vasYP] [varchar](16) NULL, + [nis] [varchar](4) NULL, + [openssh] [varchar](16) NULL, + CONSTRAINT [PK_tcdb_state] PRIMARY KEY CLUSTERED +( + [stateID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_architecture]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_architecture]( + [architectureID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + CONSTRAINT [PK_tcdb_architecture] PRIMARY KEY CLUSTERED +( + [architectureID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_assignmentStatus]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_assignmentStatus]( + [assignmentStatusID] [int] IDENTITY(1,1) NOT NULL, + [statusName] [varchar](255) NULL, + [statusEnum] [int] NULL, + CONSTRAINT [PK_tcdb_assignmentStatus] PRIMARY KEY CLUSTERED +( + [assignmentStatusID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_computer]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_computer]( + [computerID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [ipAddress] [varchar](15) NULL, + [hostname] [varchar](50) NULL, + [platformID] [int] NULL, + [labID] [int] NULL, + [stateID] [int] NULL, + CONSTRAINT [PK_tcdb_computer] PRIMARY KEY CLUSTERED +( + [computerID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_feature]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_feature]( + [featureID] [int] IDENTITY(1,1) NOT NULL, + [parentFeatureID] [int] NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + [userID] [int] NULL, + [dateCreated] [datetime] NULL, + [featureNumber] [varchar](20) NULL, + CONSTRAINT [PK_tcdb_feature] PRIMARY KEY CLUSTERED +( + [featureID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_lab]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_lab]( + [labID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + [DNS] [varchar](15) NULL, + CONSTRAINT [PK_tcdb_lab] PRIMARY KEY CLUSTERED +( + [labID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_notes]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_notes]( + [noteID] [int] IDENTITY(1,1) NOT NULL, + [tableName] [varchar](50) NULL, + [tableID] [int] NULL, + [dateCreated] [datetime] NULL, + [noteField] [text] NULL, + [noteAuthor] [int] NULL, + CONSTRAINT [PK_tcdb_notes] PRIMARY KEY CLUSTERED +( + [noteID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_objective]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_objective]( + [objectiveID] [int] IDENTITY(1,1) NOT NULL, + [featureID] [int] NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + [userID] [int] NULL, + [dateEdited] [datetime] NULL, + CONSTRAINT [PK_tcdb_objective] PRIMARY KEY CLUSTERED +( + [objectiveID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_os]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_os]( + [osID] [int] IDENTITY(1,1) NOT NULL, + [friendlyName] [varchar](255) NULL, + [codeName] [varchar](30) NULL, + CONSTRAINT [PK_tcdb_os] PRIMARY KEY CLUSTERED +( + [osID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_product]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_product]( + [productID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + [devManager] [int] NULL, + [qaManager] [int] NULL, + [devLead] [int] NULL, + [qaLead] [int] NULL, + [pm] [int] NULL, + [codeName] [varchar](10) NULL, + CONSTRAINT [PK_tcdb_product] PRIMARY KEY CLUSTERED +( + [productID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_rights]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_rights]( + [rightsID] [int] NOT NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + CONSTRAINT [PK_tcdb_rights] PRIMARY KEY CLUSTERED +( + [rightsID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_savedWorkOrder]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_savedWorkOrder]( + [savedWorkOrderID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [platformID] [int] NULL, + [creatorID] [int] NULL, + [versionID] [int] NULL, + CONSTRAINT [PK_tcdb_savedWorkOrder] PRIMARY KEY CLUSTERED +( + [savedWorkOrderID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_tags]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_tags]( + [tagID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [description] [text] NULL, + CONSTRAINT [PK_tcdb_tags] PRIMARY KEY CLUSTERED +( + [tagID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_testCase]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_testCase]( + [testCaseID] [int] IDENTITY(1,1) NOT NULL, + [objectiveID] [int] NULL, + [name] [varchar](255) NULL, + [number] [varchar](30) NULL, + [steps] [text] NULL, + [creatorID] [int] NULL, + [lastEditID] [int] NULL, + [dateCreated] [datetime] NULL, + [dateEdited] [datetime] NULL, + CONSTRAINT [PK_tcdb_testcase] PRIMARY KEY CLUSTERED +( + [testCaseID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_version]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_version]( + [versionID] [int] IDENTITY(1,1) NOT NULL, + [productID] [int] NULL, + [number] [varchar](50) NULL, + [code] [varchar](50) NULL, + [active] [bit] NULL, + [dateCreated] [datetime] NULL, + [devManager] [int] NULL, + [qaManager] [int] NULL, + [devLead] [int] NULL, + [pm] [int] NULL, + CONSTRAINT [PK_tcdb_version] PRIMARY KEY CLUSTERED +( + [versionID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_workOrder]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_workOrder]( + [workorderID] [int] IDENTITY(1,1) NOT NULL, + [name] [varchar](255) NULL, + [platformID] [int] NULL, + [dateCreated] [datetime] NULL, + [dateCompleted] [datetime] NULL, + [creatorID] [int] NULL, + [testPassID] [int] NULL, + CONSTRAINT [PK_tcdb_workorder] PRIMARY KEY CLUSTERED +( + [workorderID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_versionTestCase]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_versionTestCase]( + [versionTestCaseID] [int] IDENTITY(1,1) NOT NULL, + [testCaseID] [int] NULL, + [versionID] [int] NULL, + [include] [bit] NULL, + [minVersion] [varchar](50) NULL, + [maxVersion] [varchar](50) NULL, + CONSTRAINT [PK_tcdb_versionTestCase] PRIMARY KEY CLUSTERED +( + [versionTestCaseID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tcdb_build]') AND type in (N'U')) +BEGIN +CREATE TABLE [dbo].[tcdb_build]( + [buildID] [int] IDENTITY(1,1) NOT NULL, + [versionID] [int] NULL, + [number] [varchar](20) NULL, + [active] [bit] NULL, + [dateCreated] [datetime] NULL, + CONSTRAINT [PK_tcdb_build] PRIMARY KEY CLUSTERED +( + [buildID] ASC +)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] +) ON [PRIMARY] +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_user]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_user +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/23/2006 +-- Purpose: Insert a new user in the master users table. +-- +-- Input: @firstName -- User First Name +-- @lastName -- User Last Name +-- @email -- Email Address for User +-- @officePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' +-- @homePhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' +-- @cellPhone -- Office Phone for User I.E. ''(xxx) xxx-xxxx'' +-- @automation -- 0 - Normal Person, 1 - Automation Account +-- +-- Output: none +------------------------------------------------------------------ +CREATE proc [dbo].[ins_user] ( + @firstName varchar(24), + @lastName varchar(24), + @email varchar(50), + @officePhone varchar(14), + @homePhone varchar(14), + @cellPhone varchar(14), + @automation bit +) as + +-- 2006/05/24 JRJ Corrected table name +insert into tcdb_user +select + @email, + @officePhone, + @homePhone, + @cellPhone, + @firstName, + @lastName, + @automation' +END +GO +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ins_product]') AND type in (N'P', N'PC')) +BEGIN +EXEC dbo.sp_executesql @statement = N'------------------------------------------------------------------ +-- Stored Procedure: ins_product +-- +-- Database: TCDB +-- Author: Jon R. Johnson +-- Date: 05/23/2006 +-- Purpose: Insert a new product in the master products table. +-- +-- Input: @name -- Product Name +-- @description -- Product Description +-- @devManager -- Development Manager +-- @qaManager -- Q.A. Manager +-- @devLead -- Development Lead +-- @qaLead -- Q.A. Lead +-- @pm -- Product Manager +-- @codeName -- Product Code Name +-- +-- Output: none +------------------------------------------------------------------ +create proc [dbo].[ins_product] ( + @name varchar(255), + @description text, + @devManager varchar(49), + @qaManager varchar(49), + @devLead varchar(49), + @qaLead varchar(49), + @pm varchar(49), + @codeName varchar(10) +) as + + +insert into tcdb_product +select + @name, + @description, + devManager=(select userID from tcdb_user where firstName+'' ''+lastName = @devManager), + qaManager=(select userID from tcdb_user where firstName+'' ''+lastName = @qaManager), + devLead=(select userID from tcdb_user where firstName+'' ''+lastName = @devLead), + qaLead=(select userID from tcdb_user where firstName+'' ''+lastName = @qaLead), + pm=(select userID from tcdb_user where firstName+'' ''+lastName = @pm), + @codeName + +' +END This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: Jason C. <jco...@vi...> - 2005-01-05 18:27:41
|
Ok, sounds good. There is an example on the docs for Pear's logging site about how to set php's logger to your own, I'll get that in soon. Jason Corbett On Wed, 2005-01-05 at 10:57 -0700, Matthew Hildebrand wrote: > Jason, >=20 > =20 >=20 > This sounds really good=E2=80=94I just want to make a couple of suggestio= ns. >=20 > =20 >=20 > 1) We need to be logging any actual PHP errors/warnings as well. > There is a way to set a custom logger (ie. ours) to handle these > instead of the default PHP logging environment. That way, not only > will any trace/debug statements WE place in the code leave logs, but > so will any system issues (bad SQL query, DB connection failure, > required file not found, etc.). >=20 > 2) I think that it would be wise NOT to pull the log config from > the database, but rather from the initial config file. Otherwise, if > there are DB issues the logs for that will never make it into the > logfile (let alone be CRONed into the DB). I don=E2=80=99t immediately se= e the > logging as something that will change all that frequently. If we want, > we may think about having a config file that only provides default > fallback values (guaranteed paths, default logging levels, etc.) that > will be overridden by anything actually populated from the logConfig > in the DB. >=20 > =20 >=20 > Other than those two points, things sound good to me. >=20 > =20 >=20 > =20 >=20 > =20 > ______________________________________________________________________ >=20 > From: tcd...@li... [mailto:tcdb-devel- > ad...@li...] On Behalf Of Jason Corbett > Sent: Tuesday, January 04, 2005 5:25 PM > To: TCDB Development Mailing List > Subject: Re: [tcdb-devel] initializing logging >=20 >=20 > =20 >=20 > Ok, >=20 > Just in case you wanted to know, CTRL-ENTER in Evolution sends the > email :) >=20 > on Point 1, there are the following PEAR definitions for log levels: >=20 > Level=20 >=20 >=20 > Shortcut=20 >=20 >=20 > Description=20 >=20 >=20 > PEAR_LOG_EMERG=20 >=20 >=20 > emerg()=20 >=20 >=20 > System is unusable=20 >=20 >=20 > PEAR_LOG_ALERT=20 >=20 >=20 > alert()=20 >=20 >=20 > Immediate action > required=20 >=20 >=20 > PEAR_LOG_CRIT=20 >=20 >=20 > crit()=20 >=20 >=20 > Critical conditions=20 >=20 >=20 > PEAR_LOG_ERR=20 >=20 >=20 > err()=20 >=20 >=20 > Error conditions=20 >=20 >=20 > PEAR_LOG_WARNING=20 >=20 >=20 > warning()=20 >=20 >=20 > Warning conditions=20 >=20 >=20 > PEAR_LOG_NOTICE=20 >=20 >=20 > notice()=20 >=20 >=20 > Normal but significant=20 >=20 >=20 > PEAR_LOG_INFO=20 >=20 >=20 > info()=20 >=20 >=20 > Informational=20 >=20 >=20 > PEAR_LOG_DEBUG=20 >=20 >=20 > debug()=20 >=20 >=20 > Debug-level messages=20 >=20 >=20 >=20 >=20 > What I want is a user based log of events (or things the user has > done/changed). This doesn't seem to be too hard of a thing to log, we > just need a convenient configuration to do it. I think this might be > interesting information for the admin. When the user complains that > something didn't work, the admin can quickly look > at the user's action log to see how they tried to do it. >=20 > The way I propose to do this is by creating 2 different log objects, > which will always be available (as long as you include the backend's > 'Initialize.php' file): > $plogger and $ulogger. You use $plogger for everything dealing with > the tcdb framework itself, and $ulogger for all errors, trace of what > the user has tried to do. Sound good???? >=20 >=20 > Number 2 was supposed to be about the text included below my > unfinished list, that is storing all the config stuff in the database, > using key value based config options (grouped by sections). Any > objections? >=20 > Jason Corbett >=20 >=20 > On Tue, 2005-01-04 at 17:05 -0700, Jason Corbett wrote: >=20 >=20 >=20 > Hey guys, >=20 > I'm making some cool progress. We're going to use PEAR logging > mainly because propel already does (the classes would be required > anyways). The logging will use a backtrace to determine what > file/line/function/class you called the log method from, and add that > to the log file. It is configurable to turn off the backtrace for > performance reasons, in which case all those fields will report > 'unknown'. It also adds session id to the log line if there is one. > That way maybe we can log sessions, and have a trace of what each user > did when. >=20 > On that note I have 2 proposals to put before you tonight:=20 >=20 > 1. We choose some special definitions for log levels that make > sense to us.=20 >=20 >=20 >=20 > I kinda want to store all configs in the database, including logging > configs. This would make it so that the only config file we have, > will be the one generated at install time. Everything else would be > in the database. >=20 > Matt I know that you suggested the idea (I'm not trying to steal > credit for it). Any objections? I'm planning on making the database > schema such that it's like an ini file. You have a Config object, > that's a collection of sections. Each section can have key/value > components. Sound like a good idea? I'll start implementing it, tell > me to go to he@$ if you think otherwise. >=20 > Jason Corbett=20 >=20 >=20 |
|
From: Jason C. <jco...@vi...> - 2005-01-05 00:05:58
|
Hey guys,
I'm making some cool progress. We're going to use PEAR logging mainly
because propel already does (the classes would be required anyways).
The logging will use a backtrace to determine what
file/line/function/class you called the log method from, and add that to
the log file. It is configurable to turn off the backtrace for
performance reasons, in which case all those fields will report
'unknown'. It also adds session id to the log line if there is one.
That way maybe we can log sessions, and have a trace of what each user
did when.
On that note I have 2 proposals to put before you tonight:
1. We choose some special definitions for log levels that make
sense to us.
2.
I kinda want to store all configs in the database, including logging
configs. This would make it so that the only config file we have, will
be the one generated at install time. Everything else would be in the
database.
Matt I know that you suggested the idea (I'm not trying to steal
credit for it). Any objections? I'm planning on making the database
schema such that it's like an ini file. You have a Config object,
that's a collection of sections. Each section can have key/value
components. Sound like a good idea? I'll start implementing it, tell
me to go to he@$ if you think otherwise.
Jason Corbett
|
|
From: Jason C. <jco...@vi...> - 2004-12-16 18:54:34
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Windows/IIS, ewww! Well I guess it's a valid environment, add it to
the feature list and we'll discuss it. I guess it's possible that
other people might be using windows for their server.<br>
<br>
Logging, yes we do need to figure this out. I looked at a log4php
package, and it looked fairly complete, with the exception that it
didn't seem to have much documentation. I didn't like the log package
in pear (it didn't record file/line/class/function information at all),
but I'll keep looking, there might be something else.<br>
<br>
I'll get started on the build and inclusion of propel/phing/creole and
set some things up.<br>
<br>
Jason Corbett<br>
<br>
Matthew Hildebrand wrote:
<blockquote cite="mid...@sc..."
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:595946227;
mso-list-template-ids:-124605534;}
@list l1
{mso-list-id:1911767713;
mso-list-template-ids:-891246554;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">I think that
these are all excellent
ideas. The only new thought that I have to add at the moment is a
reminder that
we need to select some sort of logging facility to use for our portion
of the
code.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">As far as
securing php files, I believe
(though I may be mistaken) that php include/require statements can
point to an
absolute file in the file system as opposed to a relative/absolute URL
(actually, I believe that it’s the recommended practice, though it’s
possible
to make the statement reference a URL). With this as the case, I think
that we
can store said files in /etc/tcdb/ or /usr/etc/tcdb/, secure them so
that they
only have read/execute access by wheel, and be set. I definitely agree
that the
only publicly available files should be those that actually generate
content
the user directly sees. Also, we should consider a statement at the top
of each
file that restricts the file from being run if it is run directly (I
know that
I’ve done/seen it before, so I’ll look around for this snipit of code).<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Also,
something that we probably should
keep under consideration is allowing for usage under Windows/IIS.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;">--Matt<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font
color="black" face="Times New Roman" size="3"><span
style="font-size: 12pt; color: windowtext;">
<hr tabindex="-1" align="center" size="2" width="100%"></span></font></div>
<p class="MsoNormal"><b><font color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; color: windowtext;">
<a class="moz-txt-link-abbreviated" href="mailto:tcd...@li...">tcd...@li...</a>
[<a class="moz-txt-link-freetext" href="mailto:tcd...@li...">mailto:tcd...@li...</a>] <b><span
style="font-weight: bold;">On Behalf Of </span></b>Jason Corbett<br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday,
December 15, 2004
6:15 PM<br>
<b><span style="font-weight: bold;">To:</span></b> Jason Corbett<br>
<b><span style="font-weight: bold;">Cc:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:tcd...@li...">tcd...@li...</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re:
[tcdb-devel]
Organization of tcdb2.php cvs module</span></font><font color="black"><span
style="color: windowtext;"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">Sorry for the big email, but
I've thought of some
things, and I'm expecting some feedback on this.<br>
<br>
Alright, I've had some time to think about it, and I'm not sure on the
copy 'n
run idea. There are a couple of issues:<o:p></o:p></span></font></p>
<ol start="1" type="1">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">We want
this to work for Mysql and for Postgres out of the box (I think we
should also consider sqlite for demo purposes, but we can start another
thread on that). I'm almost positive that the class files that are
generated (not the subclass ones we edit, but the parent persistent
ones) are different for the different databases. I could be wrong,
maybe creole handles this, we may want to investigate it, but at any
rate we'll need 2 different builds of the sql file.<br>
<br>
I think that a better way to handle this is that we should have a build
system based on phing, that does the generation/install dynamic. This
way we can script it as we need, and we have a much cleaner
cvs/distribution.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">After
going through and trying to custimize the propel-gen script so that we
could make the directories live in the places we want, I realized that
it would be much easier to customize it if we distributed
phing/creole/propel in our cvs, and then used our own build process. I
could probably get it done in a day. It would make a lot more sense
than having to say as part of the install - follow the instructions
from propel to install the propel runtime. We should distribute this
stuff, it isn't really big, and I don't think any of it is native code.<o:p></o:p></span></font></li>
</ol>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">So my proposal is this:<o:p></o:p></span></font></p>
<ol start="1" type="1">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">We have
an installer / build system with the following requirements:<o:p></o:p></span></font></li>
<ul type="circle">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">shell
based, not to restrictive since this project is meant as an intranet
system. Some projects use a web based installer, but I find that the
reason they do this is for people deploying it that only have ftp
access. Our potential users don't typically fit into this category.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">It
should request the information on what database to use, what
username/password, etc. from the user. All information to get it
basically set up and running, no editing of properties files/config
files. The properties it asks for should be minimal (ie enough to get
it up and running with an admin user). All other settings should be
customized within the web interface.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">We
should have a uninstall/wipe. Maybe wipe is more accurate. The reason
for this is that we want dev people (us) to be able to update from cvs,
and to quickly deploy the latest schema. Most of this is already in
the sql generation.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">The
ability for non web php files to live outside the web root. I find one
of the most annoying things about securing a php application is that
you have to edit .htaccess files for all the dirs that have php files
that shouldn't be accessed through the web (like a config.php should
never be accessable directly).<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Much
easier install on apache2 systems / newer versions of Redhat, SuSE, and
debian if possible. We won't garuntee anything, but apache2 installs
almost always have the ability for individual applications to create
their own .conf entry in a separate file that will be read in upon
startup. I don't think this is a necessary feature to begin with, but
it is one I would like to have eventually.<o:p></o:p></span></font></li>
</ul>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Directories:<o:p></o:p></span></font></li>
<ul type="circle">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">build:
this contains our version of phing/creole/propel necessary for the
building/installing of tcdb.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">docs:
self explanatory<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">lib: At
first I had this as runtime-lib, but that seems kinda long, so let's
just call it lib. It should contain propel runtime (and of course
creole) and any other dependent / non changing classes (ie ones not
specific to tcdb)<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">backend:
all the backend classes, the ones that are generated, and the ones that
we write.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">frontend:
UI stuff. All the files that need to be in the web need to be in this
dir.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">tests:
What Unit tests for a Tester's project? Yup, these will help me verify
that the backend works like I think it does, so the person writing the
frontend won't have to find out the hard way that the backend is
completely broken. I'm not saying that we'll have complete code
coverage, I don't have that much time, but we can at least test things
that have been problems for us in the past (regression).<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">schema:
this will contain the tcdb schema. I've figured out how to allow for
each table to live in it's own xml file for nice viewing/editing.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Any
others???<o:p></o:p></span></font></li>
</ul>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Files
in root:<o:p></o:p></span></font></li>
<ul type="circle">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">README:
general description of tcdb, and design goals, something no one will
probably read...<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">INSTALL:
simple manual on how to get up and running the quickest, example
commands for mysql/postgres<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">installer.php:
yup, the installer<o:p></o:p></span></font></li>
</ul>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Beautifiers:<o:p></o:p></span></font></li>
<ul type="circle">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">I would
like to have php code formatters/beautifiers to keep all our code
consistant in it's look and feel. I've found this to be very helpful
(I don't have to spend so much time while coding trying to follow some
weird style that I'm not used to, the formatter will take care of it).
I found one in pear, but I still have to look to see if it's
configurable.<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">A
html/xml beautifier would probably be good, but maybe not necessary. I
know I need to run one on the xml I've written for the schema (make
sure all the indentation looks consistent), but someone else can make
that call.<o:p></o:p></span></font></li>
</ul>
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">Doc
generator for backend:<o:p></o:p></span></font></li>
<ul type="circle">
<li class="MsoNormal" style=""><font color="black"
face="Times New Roman" size="3"><span style="font-size: 12pt;">javadoc
is nice for learning how to use someone else's classes. Since we're
trying to separate the backend and frontend appropriately, it might
help to have some doc tool to generate nice looking docs from it.
Someone please comment on what you think about this. If you want to
see an example of a few I found: <a href="http://www.phpdoc.de/">http://www.phpdoc.de/</a>
<a href="http://phpdoctor.sourceforge.net/">http://phpdoctor.sourceforge.net/</a>
<a href="http://www.phpdoc.org">www.phpdoc.org</a> (the last
one, the web site created is ugly, however it says it has different
templates, we'll see. It also has output ability of pdf, chm, etc.)<o:p></o:p></span></font></li>
</ul>
</ol>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;">Please let me know what you
think... I want to get
moving, but I also want feedback. If you think one of my ideas is
overdone, that's perfect!<br>
<br>
Jason Corbett<br>
<br>
Jason Corbett wrote: <o:p></o:p></span></font></p>
<pre wrap=""><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">As Matt and I discussed, Sourceforge has been gracious enough to wipe out what we had in cvs. Now we can rebuild it like we want... Umm how did we want to do that?<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> In my experience php programs have one awesome quality, copy and run. I would like to have everything that is needed to run the web interface in 1 folder. I propose distribution, but feel free to come up with your own ideas. That folder should be the root of the php class paths, and should be copyable to the web folder, and wala, installed. Well there might be a few steps in setting up the config/installing db. But you get the idea.<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> Docs should probably live in a folder called docs. I'm sure I'm missing some things, but basically distribution (or whatever you want to call it) should be the main concern as to how it's structured. Any replies?<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Jason Corbett<o:p></o:p></span></font></pre>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
</div>
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real
users.
Discover which products truly live up to the hype. Start reading now.
<a class="moz-txt-link-freetext" href="http://productguide.itmanagersjournal.com/">http://productguide.itmanagersjournal.com/</a>
_______________________________________________
Tcdb-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Tcd...@li...">Tcd...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/tcdb-devel">https://lists.sourceforge.net/lists/listinfo/tcdb-devel</a>
</blockquote>
<br>
</body>
</html>
|
|
From: Matthew H. <mhi...@vi...> - 2004-12-16 17:26:46
|
I think that these are all excellent ideas. The only new thought that I have to add at the moment is a reminder that we need to select some sort of logging facility to use for our portion of the code. As far as securing php files, I believe (though I may be mistaken) that php include/require statements can point to an absolute file in the file system as opposed to a relative/absolute URL (actually, I believe that it's the recommended practice, though it's possible to make the statement reference a URL). With this as the case, I think that we can store said files in /etc/tcdb/ or /usr/etc/tcdb/, secure them so that they only have read/execute access by wheel, and be set. I definitely agree that the only publicly available files should be those that actually generate content the user directly sees. Also, we should consider a statement at the top of each file that restricts the file from being run if it is run directly (I know that I've done/seen it before, so I'll look around for this snipit of code). Also, something that we probably should keep under consideration is allowing for usage under Windows/IIS. --Matt _____ From: tcd...@li... [mailto:tcd...@li...] On Behalf Of Jason Corbett Sent: Wednesday, December 15, 2004 6:15 PM To: Jason Corbett Cc: tcd...@li... Subject: Re: [tcdb-devel] Organization of tcdb2.php cvs module Sorry for the big email, but I've thought of some things, and I'm expecting some feedback on this. Alright, I've had some time to think about it, and I'm not sure on the copy 'n run idea. There are a couple of issues: 1. We want this to work for Mysql and for Postgres out of the box (I think we should also consider sqlite for demo purposes, but we can start another thread on that). I'm almost positive that the class files that are generated (not the subclass ones we edit, but the parent persistent ones) are different for the different databases. I could be wrong, maybe creole handles this, we may want to investigate it, but at any rate we'll need 2 different builds of the sql file. I think that a better way to handle this is that we should have a build system based on phing, that does the generation/install dynamic. This way we can script it as we need, and we have a much cleaner cvs/distribution. 2. After going through and trying to custimize the propel-gen script so that we could make the directories live in the places we want, I realized that it would be much easier to customize it if we distributed phing/creole/propel in our cvs, and then used our own build process. I could probably get it done in a day. It would make a lot more sense than having to say as part of the install - follow the instructions from propel to install the propel runtime. We should distribute this stuff, it isn't really big, and I don't think any of it is native code. So my proposal is this: 1. We have an installer / build system with the following requirements: * shell based, not to restrictive since this project is meant as an intranet system. Some projects use a web based installer, but I find that the reason they do this is for people deploying it that only have ftp access. Our potential users don't typically fit into this category. * It should request the information on what database to use, what username/password, etc. from the user. All information to get it basically set up and running, no editing of properties files/config files. The properties it asks for should be minimal (ie enough to get it up and running with an admin user). All other settings should be customized within the web interface. * We should have a uninstall/wipe. Maybe wipe is more accurate. The reason for this is that we want dev people (us) to be able to update from cvs, and to quickly deploy the latest schema. Most of this is already in the sql generation. * The ability for non web php files to live outside the web root. I find one of the most annoying things about securing a php application is that you have to edit .htaccess files for all the dirs that have php files that shouldn't be accessed through the web (like a config.php should never be accessable directly). * Much easier install on apache2 systems / newer versions of Redhat, SuSE, and debian if possible. We won't garuntee anything, but apache2 installs almost always have the ability for individual applications to create their own .conf entry in a separate file that will be read in upon startup. I don't think this is a necessary feature to begin with, but it is one I would like to have eventually. 2. Directories: * build: this contains our version of phing/creole/propel necessary for the building/installing of tcdb. * docs: self explanatory * lib: At first I had this as runtime-lib, but that seems kinda long, so let's just call it lib. It should contain propel runtime (and of course creole) and any other dependent / non changing classes (ie ones not specific to tcdb) * backend: all the backend classes, the ones that are generated, and the ones that we write. * frontend: UI stuff. All the files that need to be in the web need to be in this dir. * tests: What Unit tests for a Tester's project? Yup, these will help me verify that the backend works like I think it does, so the person writing the frontend won't have to find out the hard way that the backend is completely broken. I'm not saying that we'll have complete code coverage, I don't have that much time, but we can at least test things that have been problems for us in the past (regression). * schema: this will contain the tcdb schema. I've figured out how to allow for each table to live in it's own xml file for nice viewing/editing. * Any others??? 3. Files in root: * README: general description of tcdb, and design goals, something no one will probably read... * INSTALL: simple manual on how to get up and running the quickest, example commands for mysql/postgres * installer.php: yup, the installer 4. Beautifiers: * I would like to have php code formatters/beautifiers to keep all our code consistant in it's look and feel. I've found this to be very helpful (I don't have to spend so much time while coding trying to follow some weird style that I'm not used to, the formatter will take care of it). I found one in pear, but I still have to look to see if it's configurable. * A html/xml beautifier would probably be good, but maybe not necessary. I know I need to run one on the xml I've written for the schema (make sure all the indentation looks consistent), but someone else can make that call. 5. Doc generator for backend: * javadoc is nice for learning how to use someone else's classes. Since we're trying to separate the backend and frontend appropriately, it might help to have some doc tool to generate nice looking docs from it. Someone please comment on what you think about this. If you want to see an example of a few I found: http://www.phpdoc.de/ http://phpdoctor.sourceforge.net/ www.phpdoc.org (the last one, the web site created is ugly, however it says it has different templates, we'll see. It also has output ability of pdf, chm, etc.) Please let me know what you think... I want to get moving, but I also want feedback. If you think one of my ideas is overdone, that's perfect! Jason Corbett Jason Corbett wrote: As Matt and I discussed, Sourceforge has been gracious enough to wipe out what we had in cvs. Now we can rebuild it like we want... Umm how did we want to do that? In my experience php programs have one awesome quality, copy and run. I would like to have everything that is needed to run the web interface in 1 folder. I propose distribution, but feel free to come up with your own ideas. That folder should be the root of the php class paths, and should be copyable to the web folder, and wala, installed. Well there might be a few steps in setting up the config/installing db. But you get the idea. Docs should probably live in a folder called docs. I'm sure I'm missing some things, but basically distribution (or whatever you want to call it) should be the main concern as to how it's structured. Any replies? Jason Corbett ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Tcdb-devel mailing list Tcd...@li... https://lists.sourceforge.net/lists/listinfo/tcdb-devel |
|
From: Jason C. <jco...@vi...> - 2004-12-16 01:15:01
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Sorry for the big email, but I've thought of some things, and I'm
expecting some feedback on this.<br>
<br>
Alright, I've had some time to think about it, and I'm not sure on the
copy 'n run idea. There are a couple of issues:<br>
<ol>
<li>We want this to work for Mysql and for Postgres out of the box (I
think we should also consider sqlite for demo purposes, but we can
start another thread on that). I'm almost positive that the class
files that are generated (not the subclass ones we edit, but the parent
persistent ones) are different for the different databases. I could be
wrong, maybe creole handles this, we may want to investigate it, but at
any rate we'll need 2 different builds of the sql file.<br>
<br>
I think that a better way to handle this is that we should have a build
system based on phing, that does the generation/install dynamic. This
way we can script it as we need, and we have a much cleaner
cvs/distribution.</li>
<li>After going through and trying to custimize the propel-gen script
so that we could make the directories live in the places we want, I
realized that it would be much easier to customize it if we distributed
phing/creole/propel in our cvs, and then used our own build process. I
could probably get it done in a day. It would make a lot more sense
than having to say as part of the install - follow the instructions
from propel to install the propel runtime. We should distribute this
stuff, it isn't really big, and I don't think any of it is native code.</li>
</ol>
So my proposal is this:<br>
<ol>
<li>We have an installer / build system with the following
requirements:</li>
<ul>
<li>shell based, not to restrictive since this project is meant as
an intranet system. Some projects use a web based installer, but I
find that the reason they do this is for people deploying it that only
have ftp access. Our potential users don't typically fit into this
category.</li>
<li>It should request the information on what database to use, what
username/password, etc. from the user. All information to get it
basically set up and running, no editing of properties files/config
files. The properties it asks for should be minimal (ie enough to get
it up and running with an admin user). All other settings should be
customized within the web interface.</li>
<li>We should have a uninstall/wipe. Maybe wipe is more accurate.
The reason for this is that we want dev people (us) to be able to
update from cvs, and to quickly deploy the latest schema. Most of this
is already in the sql generation.</li>
<li>The ability for non web php files to live outside the web
root. I find one of the most annoying things about securing a php
application is that you have to edit .htaccess files for all the dirs
that have php files that shouldn't be accessed through the web (like a
config.php should never be accessable directly).</li>
<li>Much easier install on apache2 systems / newer versions of
Redhat, SuSE, and debian if possible. We won't garuntee anything, but
apache2 installs almost always have the ability for individual
applications to create their own .conf entry in a separate file that
will be read in upon startup. I don't think this is a necessary
feature to begin with, but it is one I would like to have eventually.</li>
</ul>
<li>Directories:</li>
<ul>
<li>build: this contains our version of phing/creole/propel
necessary for the building/installing of tcdb.</li>
<li>docs: self explanatory</li>
<li>lib: At first I had this as runtime-lib, but that seems kinda
long, so let's just call it lib. It should contain propel runtime (and
of course creole) and any other dependent / non changing classes (ie
ones not specific to tcdb)</li>
<li>backend: all the backend classes, the ones that are generated,
and the ones that we write.</li>
<li>frontend: UI stuff. All the files that need to be in the web
need to be in this dir.</li>
<li>tests: What Unit tests for a Tester's project? Yup, these will
help me verify that the backend works like I think it does, so the
person writing the frontend won't have to find out the hard way that
the backend is completely broken. I'm not saying that we'll have
complete code coverage, I don't have that much time, but we can at
least test things that have been problems for us in the past
(regression).</li>
<li>schema: this will contain the tcdb schema. I've figured out
how to allow for each table to live in it's own xml file for nice
viewing/editing.<br>
</li>
<li>Any others???</li>
</ul>
<li>Files in root:</li>
<ul>
<li>README: general description of tcdb, and design goals,
something no one will probably read...<br>
</li>
<li>INSTALL: simple manual on how to get up and running the
quickest, example commands for mysql/postgres</li>
<li>installer.php: yup, the installer<br>
</li>
</ul>
<li>Beautifiers:</li>
<ul>
<li>I would like to have php code formatters/beautifiers to keep
all our code consistant in it's look and feel. I've found this to be
very helpful (I don't have to spend so much time while coding trying to
follow some weird style that I'm not used to, the formatter will take
care of it). I found one in pear, but I still have to look to see if
it's configurable.</li>
<li>A html/xml beautifier would probably be good, but maybe not
necessary. I know I need to run one on the xml I've written for the
schema (make sure all the indentation looks consistent), but someone
else can make that call.</li>
</ul>
<li>Doc generator for backend:</li>
<ul>
<li>javadoc is nice for learning how to use someone else's
classes. Since we're trying to separate the backend and frontend
appropriately, it might help to have some doc tool to generate nice
looking docs from it. Someone please comment on what you think about
this. If you want to see an example of a few I found:
<a class="moz-txt-link-freetext" href="http://www.phpdoc.de/">http://www.phpdoc.de/</a> <a class="moz-txt-link-freetext" href="http://phpdoctor.sourceforge.net/">http://phpdoctor.sourceforge.net/</a> <a class="moz-txt-link-abbreviated" href="http://www.phpdoc.org">www.phpdoc.org</a>
(the last one, the web site created is ugly, however it says it has
different templates, we'll see. It also has output ability of pdf,
chm, etc.)</li>
</ul>
</ol>
Please let me know what you think... I want to get moving, but I also
want feedback. If you think one of my ideas is overdone, that's
perfect!<br>
<br>
Jason Corbett<br>
<br>
Jason Corbett wrote:
<blockquote
cite="mid...@ma..."
type="cite">
<pre wrap="">As Matt and I discussed, Sourceforge has been gracious enough to wipe out what we had in cvs. Now we can rebuild it like we want... Umm how did we want to do that?
In my experience php programs have one awesome quality, copy and run. I would like to have everything that is needed to run the web interface in 1 folder. I propose distribution, but feel free to come up with your own ideas. That folder should be the root of the php class paths, and should be copyable to the web folder, and wala, installed. Well there might be a few steps in setting up the config/installing db. But you get the idea.
Docs should probably live in a folder called docs. I'm sure I'm missing some things, but basically distribution (or whatever you want to call it) should be the main concern as to how it's structured. Any replies?
Jason Corbett
HW�j)b��h��+y��N�L��v�-�y�v'z�\jwbv����,�xn���v� !3�ۜ���j�j[�z���(���'!�� ��l����X�z�m��^�*^J֫���v)�!�����v�-��z+fjv�z�#���jW(���u�^��fj)b� b���u�^��e��l���q���z�m��?�X���(�� ~��zw��X�����b��?��[u��l===</pre>
</blockquote>
<br>
</body>
</html>
|
|
From: Jason C. <jco...@vi...> - 2004-12-15 01:28:57
|
QXMgTWF0dCBhbmQgSSBkaXNjdXNzZWQsIFNvdXJjZWZvcmdlIGhhcyBiZWVuIGdyYWNpb3VzIGVu b3VnaCB0byB3aXBlIG91dCB3aGF0IHdlIGhhZCBpbiBjdnMuICBOb3cgd2UgY2FuIHJlYnVpbGQg aXQgbGlrZSB3ZSB3YW50Li4uICBVbW0gaG93IGRpZCB3ZSB3YW50IHRvIGRvIHRoYXQ/DQogDQog IEluIG15IGV4cGVyaWVuY2UgcGhwIHByb2dyYW1zIGhhdmUgb25lIGF3ZXNvbWUgcXVhbGl0eSwg Y29weSBhbmQgcnVuLiAgSSB3b3VsZCBsaWtlIHRvIGhhdmUgZXZlcnl0aGluZyB0aGF0IGlzIG5l ZWRlZCB0byBydW4gdGhlIHdlYiBpbnRlcmZhY2UgaW4gMSBmb2xkZXIuICBJIHByb3Bvc2UgZGlz dHJpYnV0aW9uLCBidXQgZmVlbCBmcmVlIHRvIGNvbWUgdXAgd2l0aCB5b3VyIG93biBpZGVhcy4g IFRoYXQgZm9sZGVyIHNob3VsZCBiZSB0aGUgcm9vdCBvZiB0aGUgcGhwIGNsYXNzIHBhdGhzLCBh bmQgc2hvdWxkIGJlIGNvcHlhYmxlIHRvIHRoZSB3ZWIgZm9sZGVyLCBhbmQgd2FsYSwgaW5zdGFs bGVkLiAgV2VsbCB0aGVyZSBtaWdodCBiZSBhIGZldyBzdGVwcyBpbiBzZXR0aW5nIHVwIHRoZSBj b25maWcvaW5zdGFsbGluZyBkYi4gIEJ1dCB5b3UgZ2V0IHRoZSBpZGVhLg0KIA0KICBEb2NzIHNo b3VsZCBwcm9iYWJseSBsaXZlIGluIGEgZm9sZGVyIGNhbGxlZCBkb2NzLiAgSSdtIHN1cmUgSSdt IG1pc3Npbmcgc29tZSB0aGluZ3MsIGJ1dCBiYXNpY2FsbHkgZGlzdHJpYnV0aW9uIChvciB3aGF0 ZXZlciB5b3Ugd2FudCB0byBjYWxsIGl0KSBzaG91bGQgYmUgdGhlIG1haW4gY29uY2VybiBhcyB0 byBob3cgaXQncyBzdHJ1Y3R1cmVkLiAgQW55IHJlcGxpZXM/DQogDQpKYXNvbiBDb3JiZXR0DQo= |
|
From: Jason C. <jco...@vi...> - 2004-12-13 22:09:35
|
As the project raises itself from ashes of inactivity, welcome! Ok so most of us are here at Vintela, and we could just email each other, I'd like to use this list so we're saving any decisions we make and it's recorded, and so that we can hopefully welcome other people into this project (ie get help). I've requested (as Matt and I talked about today) that sourceforge wipe out our tcdb2.php module in CVS, so that we can start over. We'll be using propel (http://propel.phpdb.org) because it looks like something to get us off the ground the fastest. I've already got the xml schema for the database done (well obviously not DONE, but at an initial playing stage at least). The downside to using propel is that we need php5 for development. I've created rpms for Fedora Core 3 (fc3) if anyone needs them. Matt, I know we did this a while ago, but we may want to get a list of tasks in the sf.net tracker, but let's be wise about it (ie not add a bunch of stuff we don't ever want to look at agian), let's add them so that if anyone want's to contribute, they can actually grab that task and run with it. I'll add the stuff I sent to you and Richard to the task manager for the backend. Once again, here we go... Jason Corbett |
2 messages has been excluded from this view by a project administrator.
